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

7 rows where 1/26/20 = 4

View and edit SQL

Suggested facets: Province/State, Country/Region, 1/22/20, 1/23/20, 1/24/20, 1/25/20, 1/27/20, 1/28/20, 1/29/20, 1/30/20, 2/3/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, 2/26/20, 2/27/20, 2/28/20, 3/7/20

1/26/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
75 Jilin China 43.6661 126.1923 0 1 3 4 4 6 8 9 14 14 17 23 31 42 54 59 65 69 78 80 81 83 84 86 88 89 89 89 90 91 91 91 91 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 93 94 95 95 97 98 98 98 98 98 98 98 98 98 98 98 98 98 98 99 100 100 102 102 102 102 104 104 106 106 108 109 109 110 110 110 111 111 112 112 112 112 112 112 113 113 124 127 127 133 134 138 140 144 146 151 151 151 151 154 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 155 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157 157
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
152   Japan 36.204824 138.252924 2 2 2 2 4 4 7 7 11 15 20 20 20 22 23 23 23 24 24 26 27 28 33 43 54 60 67 79 85 95 112 137 149 160 173 192 218 236 245 259 278 298 333 365 420 466 499 527 585 640 696 733 795 826 843 893 928 968 1022 1059 1104 1144 1217 1314 1416 1530 1728 1907 2001 2255 2535 2818 3154 3525 3876 4110 4485 5020 5614 6250 6951 7473 7773 8277 8835 9398 9958 10548 10914 11258 11641 12037 12469 12854 13186 13405 13576 13860 14076 14284 14558 14861 15061 15229 15354 15455 15553 15640 15755 15824 15861 15948 15998 16096 16148 16202 16226 16259 16287 16321 16362 16385 16410 16451 16472 16502 16528 16598 16673 16716 16751 16787 16837 16867 16911 16958 17000 17039 17060 17111 17146 17187 17250 17293 17369 17439 17484 17530 17588 17658 17725 17780 17820 17879 17963 18055 18162 18254 18366 18476 18615 18838 19055 19185 19461 19668 19848 20055 20261 20617 21044 21430 21841 22125 22437 23172 23510 24104 24946 25446 25706 26463 27136 28114 28883 29684 30548 31142 32116 33382 35144 36234 37804 39116 40099 41347 42686 44167 45764 47342 48782 49617 50302 51288 52471 53818 55051 56074 56717 57636 58728 59900 60949 61916 62658 63158 63888 64779 65653 66499 67353 67958 68396 69023 69619 70278 70866 71467 71918 72213 72724 73264 73916 74558 75206 75646 75914 76446 76997 77488 78061 78662 79142 79462 79773 80009 80490 81054 81703
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
);