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

5 rows where 1/25/20 = 2

View and edit SQL

Suggested facets: Province/State, 1/22/20, 1/23/20, 1/26/20, 1/27/20, 1/28/20, 1/29/20, 2/2/20, 2/3/20, 2/6/20, 2/7/20, 2/8/20, 2/12/20, 2/21/20, 2/22/20, 2/23/20, 2/24/20, 2/25/20, 2/26/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
77 Macau China 22.1667 113.55 1 2 2 2 5 6 7 7 7 7 7 8 8 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 11 12 15 17 17 18 24 24 25 30 31 33 37 37 38 41 41 41 43 43 44 44 44 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46
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
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
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
261   Vietnam 14.058323999999999 108.277199 0 2 2 2 2 2 2 2 2 2 6 6 8 8 8 10 10 13 13 14 15 15 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 18 30 30 31 38 39 47 53 56 61 66 75 85 91 94 113 123 134 141 153 163 174 188 203 212 218 233 237 240 241 245 249 251 255 257 258 262 265 266 267 268 268 268 268 268 268 268 268 270 270 270 270 270 270 270 270 270 271 271 271 271 288 288 288 288 288 288 288 312 314 318 320 324 324 324 324 324 325 325 326 327 327 327 328 328 328 328 328 328 328 328 329 331 332 332 332 332 333 334 334 334 334 335 342 349 349 349 349 349 352 352 353 355 355 355 355 355 355 355 355 355 369 369 369 369 370 370 372 373 373 381 381 382 382 383 384 401 408 412 415 417 420 431 446 459 509 558 590 621 652 672 717 750 789 812 841 847 866 883 911 930 951 964 983 989 994 1007 1009 1014 1016 1022 1029 1034 1036 1038 1040 1040 1044 1044 1046 1046 1049 1049 1049 1049 1054 1059 1059 1060 1060 1063 1063 1063 1063 1066 1068 1068 1068 1068 1068 1069 1069 1069 1069

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