time_series_covid19_confirmed_global
Data source: Big Local News · About: big-local-datasette
3 rows where 1/26/20 = 3
This data as json, copyable, CSV (advanced)
Suggested facets: Province/State, 1/22/20, 1/23/20, 1/24/20, 1/27/20, 1/29/20, 1/30/20
| Link | rowid ▼ | Province/State | Country/Region | Lat | Long | 1/22/20 | 1/23/20 | 1/24/20 | 1/25/20 | 1/26/20 | 1/27/20 | 1/28/20 | 1/29/20 | 1/30/20 | 1/31/20 | 2/1/20 | 2/2/20 | 2/3/20 | 2/4/20 | 2/5/20 | 2/6/20 | 2/7/20 | 2/8/20 | 2/9/20 | 2/10/20 | 2/11/20 | 2/12/20 | 2/13/20 | 2/14/20 | 2/15/20 | 2/16/20 | 2/17/20 | 2/18/20 | 2/19/20 | 2/20/20 | 2/21/20 | 2/22/20 | 2/23/20 | 2/24/20 | 2/25/20 | 2/26/20 | 2/27/20 | 2/28/20 | 2/29/20 | 3/1/20 | 3/2/20 | 3/3/20 | 3/4/20 | 3/5/20 | 3/6/20 | 3/7/20 | 3/8/20 | 3/9/20 | 3/10/20 | 3/11/20 | 3/12/20 | 3/13/20 | 3/14/20 | 3/15/20 | 3/16/20 | 3/17/20 | 3/18/20 | 3/19/20 | 3/20/20 | 3/21/20 | 3/22/20 | 3/23/20 | 3/24/20 | 3/25/20 | 3/26/20 | 3/27/20 | 3/28/20 | 3/29/20 | 3/30/20 | 3/31/20 | 4/1/20 | 4/2/20 | 4/3/20 | 4/4/20 | 4/5/20 | 4/6/20 | 4/7/20 | 4/8/20 | 4/9/20 | 4/10/20 | 4/11/20 | 4/12/20 | 4/13/20 | 4/14/20 | 4/15/20 | 4/16/20 | 4/17/20 | 4/18/20 | 4/19/20 | 4/20/20 | 4/21/20 | 4/22/20 | 4/23/20 | 4/24/20 | 4/25/20 | 4/26/20 | 4/27/20 | 4/28/20 | 4/29/20 | 4/30/20 | 5/1/20 | 5/2/20 | 5/3/20 | 5/4/20 | 5/5/20 | 5/6/20 | 5/7/20 | 5/8/20 | 5/9/20 | 5/10/20 | 5/11/20 | 5/12/20 | 5/13/20 | 5/14/20 | 5/15/20 | 5/16/20 | 5/17/20 | 5/18/20 | 5/19/20 | 5/20/20 | 5/21/20 | 5/22/20 | 5/23/20 | 5/24/20 | 5/25/20 | 5/26/20 | 5/27/20 | 5/28/20 | 5/29/20 | 5/30/20 | 5/31/20 | 6/1/20 | 6/2/20 | 6/3/20 | 6/4/20 | 6/5/20 | 6/6/20 | 6/7/20 | 6/8/20 | 6/9/20 | 6/10/20 | 6/11/20 | 6/12/20 | 6/13/20 | 6/14/20 | 6/15/20 | 6/16/20 | 6/17/20 | 6/18/20 | 6/19/20 | 6/20/20 | 6/21/20 | 6/22/20 | 6/23/20 | 6/24/20 | 6/25/20 | 6/26/20 | 6/27/20 | 6/28/20 | 6/29/20 | 6/30/20 | 7/1/20 | 7/2/20 | 7/3/20 | 7/4/20 | 7/5/20 | 7/6/20 | 7/7/20 | 7/8/20 | 7/9/20 | 7/10/20 | 7/11/20 | 7/12/20 | 7/13/20 | 7/14/20 | 7/15/20 | 7/16/20 | 7/17/20 | 7/18/20 | 7/19/20 | 7/20/20 | 7/21/20 | 7/22/20 | 7/23/20 | 7/24/20 | 7/25/20 | 7/26/20 | 7/27/20 | 7/28/20 | 7/29/20 | 7/30/20 | 7/31/20 | 8/1/20 | 8/2/20 | 8/3/20 | 8/4/20 | 8/5/20 | 8/6/20 | 8/7/20 | 8/8/20 | 8/9/20 | 8/10/20 | 8/11/20 | 8/12/20 | 8/13/20 | 8/14/20 | 8/15/20 | 8/16/20 | 8/17/20 | 8/18/20 | 8/19/20 | 8/20/20 | 8/21/20 | 8/22/20 | 8/23/20 | 8/24/20 | 8/25/20 | 8/26/20 | 8/27/20 | 8/28/20 | 8/29/20 | 8/30/20 | 8/31/20 | 9/1/20 | 9/2/20 | 9/3/20 | 9/4/20 | 9/5/20 | 9/6/20 | 9/7/20 | 9/8/20 | 9/9/20 | 9/10/20 | 9/11/20 | 9/12/20 | 9/13/20 | 9/14/20 | 9/15/20 | 9/16/20 | 9/17/20 | 9/18/20 | 9/19/20 | 9/20/20 | 9/21/20 | 9/22/20 | 9/23/20 | 9/24/20 | 9/25/20 | 9/26/20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 10 | New South Wales | Australia | -33.8688 | 151.2093 | 0 | 0 | 0 | 0 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 6 | 6 | 13 | 22 | 22 | 26 | 28 | 38 | 48 | 55 | 65 | 65 | 92 | 112 | 134 | 171 | 210 | 267 | 307 | 353 | 436 | 669 | 669 | 818 | 1029 | 1219 | 1405 | 1617 | 1791 | 2032 | 2032 | 2182 | 2298 | 2389 | 2493 | 2580 | 2637 | 2686 | 2734 | 2773 | 2822 | 2857 | 2857 | 2863 | 2870 | 2886 | 2897 | 2926 | 2936 | 2957 | 2963 | 2969 | 2971 | 2976 | 2982 | 2994 | 3002 | 3004 | 3016 | 3016 | 3025 | 3030 | 3035 | 3033 | 3035 | 3042 | 3044 | 3047 | 3051 | 3053 | 3053 | 3053 | 3059 | 3063 | 3071 | 3074 | 3075 | 3076 | 3078 | 3081 | 3082 | 3084 | 3086 | 3087 | 3090 | 3092 | 3089 | 3090 | 3092 | 3092 | 3095 | 3098 | 3104 | 3104 | 3106 | 3110 | 3110 | 3109 | 3112 | 3114 | 3117 | 3117 | 3115 | 3119 | 3128 | 3131 | 3134 | 3135 | 3137 | 3143 | 3144 | 3149 | 3151 | 3150 | 3159 | 3162 | 3168 | 3174 | 3177 | 3184 | 3189 | 3203 | 3211 | 3211 | 3405 | 3419 | 3429 | 3433 | 3440 | 3453 | 3467 | 3474 | 3478 | 3492 | 3505 | 3517 | 3527 | 3535 | 3550 | 3568 | 3588 | 3599 | 3614 | 3633 | 3640 | 3654 | 3668 | 3685 | 3699 | 3718 | 3736 | 3756 | 3773 | 3784 | 3797 | 3809 | 3820 | 3832 | 3842 | 3851 | 3861 | 3875 | 3897 | 3915 | 3927 | 3936 | 3945 | 3950 | 3957 | 3959 | 3966 | 3971 | 3972 | 3981 | 3985 | 3988 | 3991 | 3997 | 4006 | 4019 | 4033 | 4040 | 4050 | 4063 | 4079 | 4091 | 4099 | 4104 | 4114 | 4118 | 4126 | 4135 | 4142 | 4152 | 4157 | 4166 | 4170 | 4177 | 4185 | 4190 | 4196 | 4198 | 4200 | 4204 | 4206 | 4212 | 4213 | 4217 | 4218 | 4218 |
| 127 | 127 | France | 46.2276 | 2.2137 | 0 | 0 | 2 | 3 | 3 | 3 | 4 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 14 | 18 | 38 | 57 | 100 | 130 | 191 | 204 | 285 | 377 | 653 | 949 | 1126 | 1209 | 1784 | 2281 | 2281 | 3661 | 4469 | 4499 | 6633 | 7652 | 9043 | 10871 | 12612 | 14282 | 16018 | 19856 | 22304 | 25233 | 29155 | 32964 | 37575 | 40174 | 44550 | 52128 | 56989 | 59105 | 64338 | 68605 | 70478 | 74390 | 78167 | 82048 | 86334 | 90676 | 93790 | 120633 | 124298 | 129257 | 132473 | 144944 | 146923 | 146906 | 151808 | 154188 | 156921 | 154715 | 157026 | 158636 | 160292 | 160847 | 164589 | 167605 | 165093 | 165764 | 165764 | 166976 | 167272 | 167886 | 168935 | 172465 | 173040 | 174318 | 174758 | 175027 | 175479 | 176207 | 175981 | 176712 | 177319 | 177207 | 177240 | 177554 | 178428 | 179069 | 179306 | 179645 | 179964 | 179859 | 180166 | 179887 | 180044 | 183309 | 183816 | 185616 | 185851 | 185952 | 185112 | 185440 | 186118 | 186670 | 187199 | 187492 | 187590 | 187925 | 188322 | 188680 | 189244 | 189637 | 189928 | 189996 | 190223 | 190534 | 190735 | 191304 | 191740 | 191745 | 192070 | 192452 | 192265 | 192010 | 193346 | 193152 | 192429 | 194109 | 194373 | 194985 | 195458 | 195904 | 195546 | 195535 | 196748 | 197089 | 196796 | 197964 | 198450 | 198199 | 198183 | 199571 | 199509 | 200338 | 200739 | 201448 | 201285 | 201281 | 203242 | 203696 | 204641 | 205476 | 206418 | 206334 | 206334 | 208665 | 209342 | 209211 | 210465 | 213093 | 213031 | 213028 | 212884 | 216193 | 216106 | 218763 | 222477 | 222408 | 222402 | 226384 | 226313 | 230874 | 230778 | 236114 | 239345 | 239306 | 242650 | 242592 | 242538 | 242413 | 257333 | 260873 | 265550 | 267392 | 270455 | 275640 | 281603 | 288655 | 288531 | 299320 | 302175 | 306951 | 313730 | 320656 | 329512 | 329353 | 329246 | 348982 | 355244 | 363751 | 372501 | 381907 | 381907 | 381907 | 404564 | 412360 | 421861 | 431966 | 444978 | 444978 | 444978 | 473974 | 483956 | 483956 | 511757 | 527554 | 527554 | |
| 156 | 156 | Korea, South | 35.907757000000004 | 127.766922 | 1 | 1 | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 11 | 12 | 15 | 15 | 16 | 19 | 23 | 24 | 24 | 25 | 27 | 28 | 28 | 28 | 28 | 28 | 29 | 30 | 31 | 31 | 104 | 204 | 433 | 602 | 833 | 977 | 1261 | 1766 | 2337 | 3150 | 3736 | 4335 | 5186 | 5621 | 6088 | 6593 | 7041 | 7314 | 7478 | 7513 | 7755 | 7869 | 7979 | 8086 | 8162 | 8236 | 8320 | 8413 | 8565 | 8652 | 8799 | 8961 | 8961 | 9037 | 9137 | 9241 | 9332 | 9478 | 9583 | 9661 | 9786 | 9887 | 9976 | 10062 | 10156 | 10237 | 10284 | 10331 | 10384 | 10423 | 10450 | 10480 | 10512 | 10537 | 10564 | 10591 | 10613 | 10635 | 10653 | 10661 | 10674 | 10683 | 10694 | 10708 | 10718 | 10728 | 10738 | 10752 | 10761 | 10765 | 10774 | 10780 | 10793 | 10801 | 10804 | 10806 | 10810 | 10822 | 10840 | 10874 | 10909 | 10936 | 10962 | 10991 | 11018 | 11037 | 11050 | 11065 | 11078 | 11110 | 11122 | 11142 | 11165 | 11190 | 11206 | 11225 | 11265 | 11344 | 11402 | 11441 | 11468 | 11503 | 11541 | 11590 | 11629 | 11668 | 11719 | 11776 | 11814 | 11852 | 11902 | 11947 | 12003 | 12051 | 12085 | 12121 | 12155 | 12198 | 12257 | 12306 | 12373 | 12421 | 12438 | 12484 | 12535 | 12563 | 12602 | 12653 | 12715 | 12757 | 12800 | 12850 | 12904 | 12967 | 13030 | 13091 | 13137 | 13181 | 13244 | 13293 | 13338 | 13373 | 13417 | 13479 | 13512 | 13551 | 13612 | 13672 | 13711 | 13745 | 13771 | 13816 | 13879 | 13938 | 13979 | 14092 | 14150 | 14175 | 14203 | 14251 | 14269 | 14305 | 14336 | 14366 | 14389 | 14423 | 14456 | 14499 | 14519 | 14562 | 14598 | 14626 | 14660 | 14714 | 14770 | 14873 | 15039 | 15318 | 15515 | 15761 | 16058 | 16346 | 16670 | 17002 | 17399 | 17665 | 17945 | 18265 | 18706 | 19077 | 19400 | 19699 | 19947 | 20182 | 20449 | 20644 | 20842 | 21010 | 21177 | 21296 | 21432 | 21588 | 21743 | 21919 | 22055 | 22176 | 22285 | 22391 | 22504 | 22657 | 22783 | 22893 | 22975 | 23045 | 23106 | 23216 | 23341 | 23455 | 23516 | 23611 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [time_series_covid19_confirmed_global] ( [Province/State] TEXT, [Country/Region] TEXT, [Lat] TEXT, [Long] TEXT, [1/22/20] INTEGER, [1/23/20] INTEGER, [1/24/20] INTEGER, [1/25/20] INTEGER, [1/26/20] INTEGER, [1/27/20] INTEGER, [1/28/20] INTEGER, [1/29/20] INTEGER, [1/30/20] INTEGER, [1/31/20] INTEGER, [2/1/20] INTEGER, [2/2/20] INTEGER, [2/3/20] INTEGER, [2/4/20] INTEGER, [2/5/20] INTEGER, [2/6/20] INTEGER, [2/7/20] INTEGER, [2/8/20] INTEGER, [2/9/20] INTEGER, [2/10/20] INTEGER, [2/11/20] INTEGER, [2/12/20] INTEGER, [2/13/20] INTEGER, [2/14/20] INTEGER, [2/15/20] INTEGER, [2/16/20] INTEGER, [2/17/20] INTEGER, [2/18/20] INTEGER, [2/19/20] INTEGER, [2/20/20] INTEGER, [2/21/20] INTEGER, [2/22/20] INTEGER, [2/23/20] INTEGER, [2/24/20] INTEGER, [2/25/20] INTEGER, [2/26/20] INTEGER, [2/27/20] INTEGER, [2/28/20] INTEGER, [2/29/20] INTEGER, [3/1/20] INTEGER, [3/2/20] INTEGER, [3/3/20] INTEGER, [3/4/20] INTEGER, [3/5/20] INTEGER, [3/6/20] INTEGER, [3/7/20] INTEGER, [3/8/20] INTEGER, [3/9/20] INTEGER, [3/10/20] INTEGER, [3/11/20] INTEGER, [3/12/20] INTEGER, [3/13/20] INTEGER, [3/14/20] INTEGER, [3/15/20] INTEGER, [3/16/20] INTEGER, [3/17/20] INTEGER, [3/18/20] INTEGER, [3/19/20] INTEGER, [3/20/20] INTEGER, [3/21/20] INTEGER, [3/22/20] INTEGER, [3/23/20] INTEGER, [3/24/20] INTEGER, [3/25/20] INTEGER, [3/26/20] INTEGER, [3/27/20] INTEGER, [3/28/20] INTEGER, [3/29/20] INTEGER, [3/30/20] INTEGER, [3/31/20] INTEGER, [4/1/20] INTEGER, [4/2/20] INTEGER, [4/3/20] INTEGER, [4/4/20] INTEGER, [4/5/20] INTEGER, [4/6/20] INTEGER, [4/7/20] INTEGER, [4/8/20] INTEGER, [4/9/20] INTEGER, [4/10/20] INTEGER, [4/11/20] INTEGER, [4/12/20] INTEGER, [4/13/20] INTEGER, [4/14/20] INTEGER, [4/15/20] INTEGER, [4/16/20] INTEGER, [4/17/20] INTEGER, [4/18/20] INTEGER, [4/19/20] INTEGER, [4/20/20] INTEGER, [4/21/20] INTEGER, [4/22/20] INTEGER, [4/23/20] INTEGER, [4/24/20] INTEGER, [4/25/20] INTEGER, [4/26/20] INTEGER, [4/27/20] INTEGER, [4/28/20] INTEGER, [4/29/20] INTEGER, [4/30/20] INTEGER, [5/1/20] INTEGER, [5/2/20] INTEGER, [5/3/20] INTEGER, [5/4/20] INTEGER, [5/5/20] INTEGER, [5/6/20] INTEGER, [5/7/20] INTEGER, [5/8/20] INTEGER, [5/9/20] INTEGER, [5/10/20] INTEGER, [5/11/20] INTEGER, [5/12/20] INTEGER, [5/13/20] INTEGER, [5/14/20] INTEGER, [5/15/20] INTEGER, [5/16/20] INTEGER, [5/17/20] INTEGER, [5/18/20] INTEGER, [5/19/20] INTEGER, [5/20/20] INTEGER, [5/21/20] INTEGER, [5/22/20] INTEGER, [5/23/20] INTEGER, [5/24/20] INTEGER, [5/25/20] INTEGER, [5/26/20] INTEGER, [5/27/20] INTEGER, [5/28/20] INTEGER, [5/29/20] INTEGER, [5/30/20] INTEGER, [5/31/20] INTEGER, [6/1/20] INTEGER, [6/2/20] INTEGER, [6/3/20] INTEGER, [6/4/20] INTEGER, [6/5/20] INTEGER, [6/6/20] INTEGER, [6/7/20] INTEGER, [6/8/20] INTEGER, [6/9/20] INTEGER, [6/10/20] INTEGER, [6/11/20] INTEGER, [6/12/20] INTEGER, [6/13/20] INTEGER, [6/14/20] INTEGER, [6/15/20] INTEGER, [6/16/20] INTEGER, [6/17/20] INTEGER, [6/18/20] INTEGER, [6/19/20] INTEGER, [6/20/20] INTEGER, [6/21/20] INTEGER, [6/22/20] INTEGER, [6/23/20] INTEGER, [6/24/20] INTEGER, [6/25/20] INTEGER, [6/26/20] INTEGER, [6/27/20] INTEGER, [6/28/20] INTEGER, [6/29/20] INTEGER, [6/30/20] INTEGER, [7/1/20] INTEGER, [7/2/20] INTEGER, [7/3/20] INTEGER, [7/4/20] INTEGER, [7/5/20] INTEGER, [7/6/20] INTEGER, [7/7/20] INTEGER, [7/8/20] INTEGER, [7/9/20] INTEGER, [7/10/20] INTEGER, [7/11/20] INTEGER, [7/12/20] INTEGER, [7/13/20] INTEGER, [7/14/20] INTEGER, [7/15/20] INTEGER, [7/16/20] INTEGER, [7/17/20] INTEGER, [7/18/20] INTEGER, [7/19/20] INTEGER, [7/20/20] INTEGER, [7/21/20] INTEGER, [7/22/20] INTEGER, [7/23/20] INTEGER, [7/24/20] INTEGER, [7/25/20] INTEGER, [7/26/20] INTEGER, [7/27/20] INTEGER, [7/28/20] INTEGER, [7/29/20] INTEGER, [7/30/20] INTEGER, [7/31/20] INTEGER, [8/1/20] INTEGER, [8/2/20] INTEGER, [8/3/20] INTEGER, [8/4/20] INTEGER, [8/5/20] INTEGER, [8/6/20] INTEGER, [8/7/20] INTEGER, [8/8/20] INTEGER, [8/9/20] INTEGER, [8/10/20] INTEGER, [8/11/20] INTEGER, [8/12/20] INTEGER, [8/13/20] INTEGER, [8/14/20] INTEGER, [8/15/20] INTEGER, [8/16/20] INTEGER, [8/17/20] INTEGER, [8/18/20] INTEGER, [8/19/20] INTEGER, [8/20/20] INTEGER, [8/21/20] INTEGER, [8/22/20] INTEGER, [8/23/20] INTEGER, [8/24/20] INTEGER, [8/25/20] INTEGER, [8/26/20] INTEGER, [8/27/20] INTEGER, [8/28/20] INTEGER, [8/29/20] INTEGER, [8/30/20] INTEGER, [8/31/20] INTEGER, [9/1/20] INTEGER, [9/2/20] INTEGER, [9/3/20] INTEGER, [9/4/20] INTEGER, [9/5/20] INTEGER, [9/6/20] INTEGER, [9/7/20] INTEGER, [9/8/20] INTEGER, [9/9/20] INTEGER, [9/10/20] INTEGER, [9/11/20] INTEGER, [9/12/20] INTEGER, [9/13/20] INTEGER, [9/14/20] INTEGER, [9/15/20] INTEGER, [9/16/20] INTEGER, [9/17/20] INTEGER, [9/18/20] INTEGER, [9/19/20] INTEGER, [9/20/20] INTEGER, [9/21/20] INTEGER, [9/22/20] INTEGER, [9/23/20] INTEGER, [9/24/20] INTEGER, [9/25/20] INTEGER, [9/26/20] INTEGER );