Data source: Big Local News · About: big-local-datasette

6 rows where 1/25/20 = 3

View and edit SQL

Suggested facets: Province/State, Country/Region, 1/22/20, 1/23/20, 1/24/20, 1/26/20, 1/27/20, 1/28/20, 1/29/20, 2/9/20, 2/10/20, 2/11/20, 2/12/20, 2/14/20, 2/15/20, 2/17/20, 2/18/20

1/25/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
78 Ningxia China 37.2692 106.1655 1 1 2 3 4 7 11 12 17 21 26 28 31 34 34 40 43 45 45 49 53 58 64 67 70 70 70 70 71 71 71 71 71 71 71 71 72 72 73 73 74 74 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75 75
87 Xinjiang China 41.1129 85.2401 0 2 2 3 4 5 10 13 14 17 18 21 24 29 32 36 39 42 45 49 55 59 63 65 70 71 75 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 76 82 93 106 123 131 140 158 171 191 213 254 311 400 496 608 639 668 696 724 746 773 799 824 839 853 866 875 883 891 898 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902 902
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
172   Malaysia 4.210483999999999 101.97576600000001 0 0 0 3 4 4 4 7 8 8 8 8 8 10 12 12 12 16 16 18 18 18 19 19 22 22 22 22 22 22 22 22 22 22 22 22 23 23 25 29 29 36 50 50 83 93 99 117 129 149 149 197 238 428 566 673 790 900 1030 1183 1306 1518 1624 1796 2031 2161 2320 2470 2626 2766 2908 3116 3333 3483 3662 3793 3963 4119 4228 4346 4530 4683 4817 4987 5072 5182 5251 5305 5389 5425 5482 5532 5603 5691 5742 5780 5820 5851 5945 6002 6071 6176 6298 6353 6383 6428 6467 6535 6589 6656 6726 6742 6779 6819 6855 6872 6894 6941 6978 7009 7059 7137 7185 7245 7417 7604 7619 7629 7732 7762 7819 7857 7877 7970 8247 8266 8303 8322 8329 8336 8338 8369 8402 8445 8453 8494 8505 8515 8529 8535 8556 8572 8587 8590 8596 8600 8606 8616 8634 8637 8639 8640 8643 8648 8658 8663 8668 8674 8677 8683 8696 8704 8718 8725 8729 8734 8737 8755 8764 8779 8800 8815 8831 8840 8861 8884 8897 8904 8943 8956 8964 8976 8985 8999 9001 9002 9023 9038 9063 9070 9083 9094 9103 9114 9129 9149 9175 9200 9212 9219 9235 9240 9249 9257 9267 9274 9285 9291 9296 9306 9317 9334 9340 9354 9360 9374 9385 9391 9397 9459 9559 9583 9628 9810 9868 9915 9946 9969 10031 10052 10147 10167 10219 10276 10358 10505 10576 10687 10769
221   Singapore 1.2833 103.8333 0 1 3 3 4 5 7 7 10 13 16 18 18 24 28 28 30 33 40 45 47 50 58 67 72 75 77 81 84 84 85 85 89 89 91 93 93 93 102 106 108 110 110 117 130 138 150 150 160 178 178 200 212 226 243 266 313 345 385 432 455 509 558 631 683 732 802 844 879 926 1000 1049 1114 1189 1309 1375 1481 1623 1910 2108 2299 2532 2918 3252 3699 4427 5050 5992 6588 8014 9125 10141 11178 12075 12693 13624 14423 14951 15641 16169 17101 17548 18205 18778 19410 20198 20939 21707 22460 23336 23822 24671 25346 26098 26891 27356 28038 28343 28794 29364 29812 30426 31068 31616 31960 32343 32876 33249 33860 34366 34884 35292 35836 36405 36922 37183 37527 37910 38296 38514 38965 39387 39850 40197 40604 40818 40969 41216 41473 41615 41833 42095 42313 42432 42623 42736 42955 43246 43459 43661 43907 44122 44310 44479 44664 44800 44983 45140 45298 45423 45614 45783 45961 46283 46630 46878 47126 47453 47655 47912 48035 48434 48744 49098 49375 49888 50369 50838 51197 51531 51809 52205 52512 52825 53051 53346 54254 54555 54797 54929 55104 55292 55353 55395 55497 55580 55661 55747 55838 55938 56031 56099 56216 56266 56353 56404 56435 56495 56572 56666 56717 56771 56812 56852 56860 56908 56948 56982 57022 57044 57091 57166 57229 57315 57357 57406 57454 57488 57514 57532 57543 57558 57576 57606 57627 57639 57654 57665 57685
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);