time_series_covid19_confirmed_global
Data source: Big Local News · About: big-local-datasette
12 rows where 1/22/20 = 1
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 234 | 234 | Taiwan* | 23.7 | 121.0 | 1 | 1 | 3 | 3 | 4 | 5 | 8 | 8 | 9 | 10 | 10 | 10 | 10 | 11 | 11 | 16 | 16 | 17 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 20 | 22 | 22 | 23 | 24 | 26 | 26 | 28 | 30 | 31 | 32 | 32 | 34 | 39 | 40 | 41 | 42 | 42 | 44 | 45 | 45 | 45 | 45 | 47 | 48 | 49 | 50 | 53 | 59 | 67 | 77 | 100 | 108 | 135 | 153 | 169 | 195 | 215 | 235 | 252 | 267 | 283 | 298 | 306 | 322 | 329 | 339 | 348 | 355 | 363 | 373 | 376 | 379 | 380 | 382 | 385 | 388 | 393 | 393 | 395 | 395 | 395 | 398 | 420 | 422 | 425 | 426 | 427 | 428 | 429 | 429 | 429 | 429 | 429 | 429 | 429 | 432 | 436 | 438 | 438 | 439 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 440 | 441 | 441 | 441 | 441 | 441 | 441 | 441 | 442 | 442 | 442 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 445 | 445 | 445 | 446 | 446 | 446 | 446 | 446 | 446 | 446 | 447 | 447 | 447 | 447 | 447 | 447 | 447 | 448 | 449 | 449 | 449 | 449 | 449 | 449 | 449 | 449 | 451 | 451 | 451 | 451 | 451 | 451 | 451 | 451 | 451 | 451 | 451 | 455 | 455 | 458 | 458 | 458 | 462 | 467 | 467 | 467 | 467 | 474 | 475 | 474 | 476 | 476 | 477 | 477 | 479 | 477 | 477 | 480 | 481 | 481 | 481 | 482 | 484 | 485 | 486 | 486 | 486 | 487 | 487 | 487 | 487 | 487 | 487 | 487 | 487 | 488 | 488 | 488 | 488 | 489 | 489 | 490 | 492 | 493 | 494 | 495 | 495 | 496 | 498 | 498 | 498 | 499 | 499 | 500 | 503 | 503 | 506 | 507 | 509 | 509 | 509 | 509 | 510 | 510 | |
| 243 | 243 | US | 40.0 | -100.0 | 1 | 1 | 2 | 2 | 5 | 5 | 5 | 6 | 6 | 8 | 8 | 8 | 11 | 11 | 11 | 12 | 12 | 12 | 12 | 12 | 13 | 13 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 16 | 16 | 16 | 16 | 16 | 16 | 17 | 17 | 25 | 32 | 54 | 74 | 107 | 184 | 237 | 403 | 519 | 589 | 782 | 1145 | 1584 | 2214 | 2971 | 3211 | 4679 | 6513 | 9153 | 13643 | 20007 | 25991 | 34804 | 45973 | 56571 | 68583 | 86495 | 105103 | 124701 | 143672 | 165615 | 192048 | 217730 | 248186 | 280173 | 313154 | 341245 | 371481 | 402917 | 434886 | 469478 | 503006 | 532447 | 559318 | 585240 | 613887 | 643833 | 675261 | 708179 | 735960 | 761620 | 790121 | 816100 | 845361 | 878645 | 912247 | 944231 | 971149 | 994204 | 1018950 | 1046653 | 1076323 | 1110394 | 1138570 | 1163016 | 1186303 | 1210960 | 1236037 | 1263804 | 1290687 | 1315641 | 1334685 | 1354141 | 1376823 | 1397811 | 1424941 | 1450023 | 1474187 | 1492437 | 1514460 | 1535031 | 1558734 | 1583861 | 1607949 | 1629327 | 1649389 | 1667937 | 1687244 | 1705634 | 1728330 | 1752689 | 1776531 | 1795916 | 1813448 | 1834439 | 1854437 | 1875699 | 1900769 | 1923078 | 1940659 | 1958249 | 1976464 | 1997257 | 2019935 | 2045136 | 2070461 | 2090161 | 2109973 | 2133693 | 2159245 | 2187044 | 2218476 | 2251036 | 2277433 | 2308050 | 2343205 | 2378183 | 2418044 | 2463274 | 2505748 | 2545202 | 2586113 | 2631972 | 2683112 | 2737612 | 2790743 | 2836480 | 2886342 | 2931382 | 2991455 | 3050023 | 3113250 | 3181074 | 3241100 | 3300020 | 3359307 | 3426658 | 3494087 | 3571354 | 3642859 | 3706333 | 3767978 | 3829433 | 3894014 | 3964927 | 4033597 | 4107256 | 4173596 | 4228323 | 4284833 | 4350802 | 4421427 | 4489400 | 4556331 | 4614540 | 4661823 | 4707373 | 4764691 | 4817408 | 4877251 | 4935332 | 4991268 | 5037976 | 5087617 | 5134340 | 5190563 | 5242056 | 5306406 | 5354024 | 5395799 | 5431045 | 5476283 | 5522710 | 5566781 | 5615216 | 5659837 | 5694522 | 5732164 | 5770344 | 5814518 | 5860493 | 5906565 | 5953475 | 5988770 | 6023072 | 6066374 | 6106154 | 6150016 | 6200518 | 6244970 | 6276365 | 6300622 | 6327009 | 6360212 | 6396100 | 6443652 | 6485123 | 6520122 | 6553652 | 6592584 | 6630604 | 6675338 | 6723933 | 6768119 | 6804814 | 6856884 | 6895918 | 6933548 | 6977658 | 7032712 | 7078089 |
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 );