johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
497 rows where active = 344 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 41
- Georgia 37
- Virginia 29
- Oklahoma 23
- Kentucky 22
- Iowa 20
- Kansas 20
- Illinois 19
- Puerto Rico 16
- Alabama 14
- Indiana 14
- North Carolina 14
- Arkansas 13
- Minnesota 13
- Missouri 13
- Wisconsin 13
- Michigan 12
- Nebraska 12
- Tennessee 12
- Louisiana 11
- New York 9
- North Dakota 9
- Oregon 9
- Pennsylvania 9
- Colorado 8
- Mississippi 8
- Ohio 8
- Idaho 7
- Washington 7
- Maryland 6
- …
country_or_region 1
- US · 497 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3669736 | 3669736 | 2021-03-06 | US | Nebraska | Stanton | 31167 | 353 | 9 | 0 | 344 | 41.9169835 | -97.19394708 | 2021-03-07 05:21:54 | Stanton, Nebraska, US |
1618357 | 1618357 | 2021-03-05 | US | Nebraska | Stanton | 31167 | 353 | 9 | 0 | 344 | 41.9169835 | -97.19394708 | 2021-03-06 04:23:41 | Stanton, Nebraska, US |
1093400 | 1093400 | 2021-03-03 | US | Virginia | Falls Church | 51610 | 352 | 8 | 0 | 344 | 38.88485255 | -77.17560759 | 2021-03-04 05:24:24 | Falls Church, Virginia, US |
1000099 | 1000099 | 2021-03-01 | US | Michigan | Montmorency | 26119 | 361 | 17 | 0 | 344 | 45.0275929 | -84.12696227 | 2021-03-02 05:23:30 | Montmorency, Michigan, US |
3069324 | 3069324 | 2021-02-27 | US | Virginia | Falls Church | 51610 | 351 | 7 | 0 | 344 | 38.88485255 | -77.17560759 | 2021-02-28 05:22:20 | Falls Church, Virginia, US |
281092 | 281092 | 2021-02-24 | US | Idaho | Bear Lake | 16007 | 346 | 2 | 0 | 344 | 42.28269683 | -111.32892379999998 | 2021-02-25 05:24:57 | Bear Lake, Idaho, US |
282137 | 282137 | 2021-02-24 | US | Missouri | Shelby | 29205 | 351 | 7 | 0 | 344 | 39.79742518 | -92.07634971 | 2021-02-25 05:24:57 | Shelby, Missouri, US |
1936870 | 1936870 | 2021-02-23 | US | Alaska | Ketchikan Gateway | 2130 | 346 | 2 | 0 | 344 | 55.57445008 | -130.975561 | 2021-02-24 05:29:16 | Ketchikan Gateway, Alaska, US |
1937360 | 1937360 | 2021-02-23 | US | Idaho | Bear Lake | 16007 | 346 | 2 | 0 | 344 | 42.28269683 | -111.32892379999998 | 2021-02-24 05:29:16 | Bear Lake, Idaho, US |
531125 | 531125 | 2021-02-22 | US | Alaska | Ketchikan Gateway | 2130 | 346 | 2 | 0 | 344 | 55.57445008 | -130.975561 | 2021-02-23 05:23:41 | Ketchikan Gateway, Alaska, US |
531615 | 531615 | 2021-02-22 | US | Idaho | Bear Lake | 16007 | 346 | 2 | 0 | 344 | 42.28269683 | -111.32892379999998 | 2021-02-23 05:23:41 | Bear Lake, Idaho, US |
533247 | 533247 | 2021-02-22 | US | Oklahoma | Ellis | 40045 | 347 | 3 | 0 | 344 | 36.2180194 | -99.75324573 | 2021-02-23 05:23:41 | Ellis, Oklahoma, US |
533791 | 533791 | 2021-02-22 | US | Texas | Garza | 48169 | 554 | 19 | 0 | 344 | 33.17969345 | -101.2984114 | 2021-02-23 05:23:41 | Garza, Texas, US |
534112 | 534112 | 2021-02-22 | US | Virginia | Surry | 51181 | 349 | 5 | 0 | 344 | 37.11781893 | -76.88450012 | 2021-02-23 05:23:41 | Surry, Virginia, US |
184581 | 184581 | 2021-02-21 | US | Oklahoma | Ellis | 40045 | 347 | 3 | 0 | 344 | 36.2180194 | -99.75324573 | 2021-02-22 05:24:21 | Ellis, Oklahoma, US |
185125 | 185125 | 2021-02-21 | US | Texas | Garza | 48169 | 554 | 19 | 0 | 344 | 33.17969345 | -101.2984114 | 2021-02-22 05:24:21 | Garza, Texas, US |
185446 | 185446 | 2021-02-21 | US | Virginia | Surry | 51181 | 349 | 5 | 0 | 344 | 37.11781893 | -76.88450012 | 2021-02-22 05:24:21 | Surry, Virginia, US |
745399 | 745399 | 2021-02-20 | US | Texas | Garza | 48169 | 554 | 19 | 0 | 344 | 33.17969345 | -101.2984114 | 2021-02-21 05:24:33 | Garza, Texas, US |
473434 | 473434 | 2021-02-19 | US | Montana | Sweet Grass | 30097 | 351 | 7 | 0 | 344 | 45.81367654 | -109.9425686 | 2021-02-20 05:22:51 | Sweet Grass, Montana, US |
3052717 | 3052717 | 2021-02-16 | US | Oklahoma | Ellis | 40045 | 346 | 2 | 0 | 344 | 36.2180194 | -99.75324573 | 2021-02-17 05:23:10 | Ellis, Oklahoma, US |
1339917 | 1339917 | 2021-02-15 | US | Michigan | Lake | 26085 | 355 | 11 | 0 | 344 | 43.99050893 | -85.802173 | 2021-02-16 05:24:38 | Lake, Michigan, US |
1340816 | 1340816 | 2021-02-15 | US | Oklahoma | Ellis | 40045 | 346 | 2 | 0 | 344 | 36.2180194 | -99.75324573 | 2021-02-16 05:24:38 | Ellis, Oklahoma, US |
2285068 | 2285068 | 2021-02-14 | US | Michigan | Lake | 26085 | 355 | 11 | 0 | 344 | 43.99050893 | -85.802173 | 2021-02-15 05:24:49 | Lake, Michigan, US |
2285967 | 2285967 | 2021-02-14 | US | Oklahoma | Ellis | 40045 | 346 | 2 | 0 | 344 | 36.2180194 | -99.75324573 | 2021-02-15 05:24:49 | Ellis, Oklahoma, US |
2286042 | 2286042 | 2021-02-14 | US | Oregon | Lake | 41037 | 350 | 6 | 0 | 344 | 42.79246693 | -120.3850163 | 2021-02-15 05:24:49 | Lake, Oregon, US |
2679468 | 2679468 | 2021-02-13 | US | Michigan | Lake | 26085 | 355 | 11 | 0 | 344 | 43.99050893 | -85.802173 | 2021-02-14 05:23:43 | Lake, Michigan, US |
2680442 | 2680442 | 2021-02-13 | US | Oregon | Lake | 41037 | 350 | 6 | 0 | 344 | 42.79246693 | -120.3850163 | 2021-02-14 05:23:43 | Lake, Oregon, US |
3541101 | 3541101 | 2021-02-12 | US | Michigan | Lake | 26085 | 355 | 11 | 0 | 344 | 43.99050893 | -85.802173 | 2021-02-13 05:22:12 | Lake, Michigan, US |
3542000 | 3542000 | 2021-02-12 | US | Oklahoma | Ellis | 40045 | 345 | 1 | 0 | 344 | 36.2180194 | -99.75324573 | 2021-02-13 05:22:12 | Ellis, Oklahoma, US |
2639364 | 2639364 | 2021-02-11 | US | Michigan | Lake | 26085 | 355 | 11 | 0 | 344 | 43.99050893 | -85.802173 | 2021-02-12 05:23:29 | Lake, Michigan, US |
2640588 | 2640588 | 2021-02-11 | US | South Dakota | Hanson | 46061 | 348 | 4 | 0 | 344 | 43.6746384 | -97.78715148 | 2021-02-12 05:23:29 | Hanson, South Dakota, US |
3980219 | 3980219 | 2021-02-10 | US | Michigan | Lake | 26085 | 355 | 11 | 0 | 344 | 43.99050893 | -85.802173 | 2021-02-11 05:23:55 | Lake, Michigan, US |
1529212 | 1529212 | 2021-02-09 | US | Kansas | Ness | 20135 | 359 | 15 | 0 | 344 | 38.47974157 | -99.91547333 | 2021-02-10 05:22:41 | Ness, Kansas, US |
615003 | 615003 | 2021-02-08 | US | Kansas | Ness | 20135 | 359 | 15 | 0 | 344 | 38.47974157 | -99.91547333 | 2021-02-09 05:23:30 | Ness, Kansas, US |
1673772 | 1673772 | 2021-02-07 | US | Kansas | Ness | 20135 | 359 | 15 | 0 | 344 | 38.47974157 | -99.91547333 | 2021-02-08 05:22:39 | Ness, Kansas, US |
976233 | 976233 | 2021-02-06 | US | Kansas | Ness | 20135 | 359 | 15 | 0 | 344 | 38.47974157 | -99.91547333 | 2021-02-07 05:23:00 | Ness, Kansas, US |
976448 | 976448 | 2021-02-06 | US | Louisiana | Tensas | 22107 | 350 | 6 | 0 | 344 | 32.00760749 | -91.32915234 | 2021-02-07 05:23:00 | Tensas, Louisiana, US |
1589491 | 1589491 | 2021-02-05 | US | Kansas | Ness | 20135 | 359 | 15 | 0 | 344 | 38.47974157 | -99.91547333 | 2021-02-06 05:23:55 | Ness, Kansas, US |
1589706 | 1589706 | 2021-02-05 | US | Louisiana | Tensas | 22107 | 350 | 6 | 0 | 344 | 32.00760749 | -91.32915234 | 2021-02-06 05:23:55 | Tensas, Louisiana, US |
791913 | 791913 | 2021-02-04 | US | Louisiana | Tensas | 22107 | 350 | 6 | 0 | 344 | 32.00760749 | -91.32915234 | 2021-02-05 05:22:38 | Tensas, Louisiana, US |
792147 | 792147 | 2021-02-04 | US | Minnesota | Unassigned | 90027 | 412 | 68 | 0 | 344 | 48.77754106 | 0.0 | 2021-02-05 05:22:38 | Unassigned, Minnesota, US |
340873 | 340873 | 2021-02-03 | US | Colorado | Clear Creek | 8019 | 365 | 2 | 0 | 344 | 39.68864463 | -105.6463118 | 2021-02-04 05:22:26 | Clear Creek, Colorado, US |
341712 | 341712 | 2021-02-03 | US | Kentucky | Menifee | 21165 | 354 | 10 | 0 | 344 | 37.94090733 | -83.59985712 | 2021-02-04 05:22:26 | Menifee, Kentucky, US |
341805 | 341805 | 2021-02-03 | US | Louisiana | Tensas | 22107 | 350 | 6 | 0 | 344 | 32.00760749 | -91.32915234 | 2021-02-04 05:22:26 | Tensas, Louisiana, US |
1687391 | 1687391 | 2021-02-02 | US | South Dakota | Potter | 46107 | 347 | 3 | 0 | 344 | 45.06583079 | -99.95498503 | 2021-02-03 05:22:52 | Potter, South Dakota, US |
1460218 | 1460218 | 2021-01-31 | US | Arkansas | Calhoun | 5013 | 346 | 2 | 0 | 344 | 33.55598792 | -92.49974403 | 2021-02-01 05:22:53 | Calhoun, Arkansas, US |
3155700 | 3155700 | 2021-01-27 | US | Nebraska | Nuckolls | 31129 | 345 | 1 | 0 | 344 | 40.17637905 | -98.04743961 | 2021-01-28 05:22:24 | Nuckolls, Nebraska, US |
3156708 | 3156708 | 2021-01-27 | US | Texas | Hartley | 48205 | 511 | 2 | 0 | 344 | 35.84008013 | -102.6029022 | 2021-01-28 05:22:24 | Hartley, Texas, US |
1760547 | 1760547 | 2021-01-24 | US | Kansas | Barber | 20007 | 350 | 6 | 0 | 344 | 37.2288586 | -98.68460053 | 2021-01-25 05:22:16 | Barber, Kansas, US |
2428154 | 2428154 | 2021-01-23 | US | Kansas | Barber | 20007 | 350 | 6 | 0 | 344 | 37.2288586 | -98.68460053 | 2021-01-24 05:22:35 | Barber, Kansas, US |
2428803 | 2428803 | 2021-01-23 | US | Missouri | Holt | 29087 | 354 | 10 | 0 | 344 | 40.09799248 | -95.2163888 | 2021-01-24 05:22:35 | Holt, Missouri, US |
2468056 | 2468056 | 2021-01-22 | US | Kansas | Barber | 20007 | 350 | 6 | 0 | 344 | 37.2288586 | -98.68460053 | 2021-01-23 05:22:03 | Barber, Kansas, US |
2469185 | 2469185 | 2021-01-22 | US | North Dakota | Bowman | 38011 | 348 | 4 | 0 | 344 | 46.11285362 | -103.5203343 | 2021-01-23 05:22:03 | Bowman, North Dakota, US |
438452 | 438452 | 2021-01-21 | US | Texas | Hall | 48191 | 509 | 12 | 0 | 344 | 34.5307555 | -100.6813852 | 2021-01-22 05:22:10 | Hall, Texas, US |
1096671 | 1096671 | 2021-01-20 | US | Oklahoma | Roger Mills | 40129 | 350 | 6 | 0 | 344 | 35.68711719 | -99.69666167 | 2021-01-21 05:22:01 | Roger Mills, Oklahoma, US |
1096854 | 1096854 | 2021-01-20 | US | Puerto Rico | San German | 72125 | 344 | 0 | 0 | 344 | 18.111484 | -67.03858100000001 | 2021-01-21 05:22:01 | San German, Puerto Rico, US |
1097183 | 1097183 | 2021-01-20 | US | Texas | Hall | 48191 | 509 | 12 | 0 | 344 | 34.5307555 | -100.6813852 | 2021-01-21 05:22:01 | Hall, Texas, US |
910761 | 910761 | 2021-01-19 | US | Oklahoma | Roger Mills | 40129 | 350 | 6 | 0 | 344 | 35.68711719 | -99.69666167 | 2021-01-20 05:21:54 | Roger Mills, Oklahoma, US |
910944 | 910944 | 2021-01-19 | US | Puerto Rico | San German | 72125 | 344 | 0 | 0 | 344 | 18.111484 | -67.03858100000001 | 2021-01-20 05:21:54 | San German, Puerto Rico, US |
3504386 | 3504386 | 2021-01-17 | US | Illinois | Putnam | 17155 | 345 | 1 | 0 | 344 | 41.2013541 | -89.2869272 | 2021-01-18 05:22:34 | Putnam, Illinois, US |
3504703 | 3504703 | 2021-01-17 | US | Kansas | Trego | 20195 | 350 | 6 | 0 | 344 | 38.91467218 | -99.87284448 | 2021-01-18 05:22:34 | Trego, Kansas, US |
3102786 | 3102786 | 2021-01-16 | US | Kansas | Trego | 20195 | 350 | 6 | 0 | 344 | 38.91467218 | -99.87284448 | 2021-01-17 05:22:17 | Trego, Kansas, US |
3516431 | 3516431 | 2021-01-15 | US | Illinois | Putnam | 17155 | 345 | 1 | 0 | 344 | 41.2013541 | -89.2869272 | 2021-01-16 05:22:40 | Putnam, Illinois, US |
3516748 | 3516748 | 2021-01-15 | US | Kansas | Trego | 20195 | 350 | 6 | 0 | 344 | 38.91467218 | -99.87284448 | 2021-01-16 05:22:40 | Trego, Kansas, US |
3516851 | 3516851 | 2021-01-15 | US | Kentucky | Owsley | 21189 | 354 | 10 | 0 | 344 | 37.42823949 | -83.68811419 | 2021-01-16 05:22:40 | Owsley, Kentucky, US |
3517924 | 3517924 | 2021-01-15 | US | Oklahoma | Beaver | 40007 | 347 | 3 | 0 | 344 | 36.7496847 | -100.4758872 | 2021-01-16 05:22:40 | Beaver, Oklahoma, US |
3880604 | 3880604 | 2021-01-14 | US | Illinois | Putnam | 17155 | 345 | 1 | 0 | 344 | 41.2013541 | -89.2869272 | 2021-01-15 05:22:24 | Putnam, Illinois, US |
3882096 | 3882096 | 2021-01-14 | US | Oklahoma | Beaver | 40007 | 347 | 3 | 0 | 344 | 36.7496847 | -100.4758872 | 2021-01-15 05:22:24 | Beaver, Oklahoma, US |
3310723 | 3310723 | 2021-01-13 | US | Oklahoma | Beaver | 40007 | 347 | 3 | 0 | 344 | 36.7496847 | -100.4758872 | 2021-01-14 05:22:32 | Beaver, Oklahoma, US |
776972 | 776972 | 2021-01-12 | US | Oregon | Tillamook | 41057 | 346 | 2 | 0 | 344 | 45.46248721 | -123.712066 | 2021-01-13 05:22:15 | Tillamook, Oregon, US |
3901384 | 3901384 | 2021-01-09 | US | Kentucky | Lyon | 21143 | 351 | 7 | 0 | 344 | 37.02080035 | -88.07886257 | 2021-01-10 05:22:12 | Lyon, Kentucky, US |
2865651 | 2865651 | 2021-01-06 | US | Idaho | Lewis | 16061 | 349 | 5 | 0 | 344 | 46.23315327 | -116.434146 | 2021-01-07 05:22:03 | Lewis, Idaho, US |
3036962 | 3036962 | 2021-01-05 | US | Pennsylvania | Forest | 42053 | 348 | 4 | 0 | 344 | 41.51095103 | -79.23229292 | 2021-01-06 05:22:16 | Forest, Pennsylvania, US |
1062827 | 1062827 | 2021-01-04 | US | Illinois | Gallatin | 17059 | 347 | 3 | 0 | 344 | 37.76430935 | -88.22953869 | 2021-01-05 05:21:49 | Gallatin, Illinois, US |
3698846 | 3698846 | 2020-12-31 | US | Virginia | Lunenburg | 51111 | 347 | 3 | 0 | 344 | 36.94618528 | -78.24133319 | 2021-01-01 05:23:07 | Lunenburg, Virginia, US |
3698856 | 3698856 | 2020-12-31 | US | Virginia | Nelson | 51125 | 348 | 4 | 0 | 344 | 37.78790447 | -78.88498513 | 2021-01-01 05:23:07 | Nelson, Virginia, US |
769733 | 769733 | 2020-12-29 | US | Virginia | Williamsburg | 51830 | 352 | 8 | 0 | 344 | 37.28131268 | -76.70905141 | 2020-12-30 05:22:34 | Williamsburg, Virginia, US |
769825 | 769825 | 2020-12-29 | US | West Virginia | Tyler | 54095 | 346 | 2 | 0 | 344 | 39.46811972 | -80.88772676 | 2020-12-30 05:22:34 | Tyler, West Virginia, US |
3764997 | 3764997 | 2020-12-28 | US | Virginia | Williamsburg | 51830 | 352 | 8 | 0 | 344 | 37.28131268 | -76.70905141 | 2020-12-29 05:22:37 | Williamsburg, Virginia, US |
3781317 | 3781317 | 2020-12-27 | US | Virginia | Williamsburg | 51830 | 352 | 8 | 0 | 344 | 37.28131268 | -76.70905141 | 2020-12-28 05:22:06 | Williamsburg, Virginia, US |
2226815 | 2226815 | 2020-12-26 | US | Virginia | Charlotte | 51037 | 350 | 6 | 0 | 344 | 37.01909701 | -78.66314092 | 2020-12-27 05:22:55 | Charlotte, Virginia, US |
205562 | 205562 | 2020-12-25 | US | Virginia | Charlotte | 51037 | 350 | 6 | 0 | 344 | 37.01909701 | -78.66314092 | 2020-12-26 05:22:28 | Charlotte, Virginia, US |
205724 | 205724 | 2020-12-25 | US | West Virginia | Gilmer | 54021 | 345 | 1 | 0 | 344 | 38.9251277 | -80.85952723 | 2020-12-26 05:22:28 | Gilmer, West Virginia, US |
3692358 | 3692358 | 2020-12-24 | US | Georgia | Twiggs | 13289 | 363 | 19 | 0 | 344 | 32.67435595 | -83.43078662 | 2020-12-25 05:22:48 | Twiggs, Georgia, US |
3693540 | 3693540 | 2020-12-24 | US | Nebraska | Furnas | 31065 | 348 | 4 | 0 | 344 | 40.17642064 | -99.91247454 | 2020-12-25 05:22:48 | Furnas, Nebraska, US |
2408708 | 2408708 | 2020-12-23 | US | Missouri | Clark | 29045 | 348 | 4 | 0 | 344 | 40.41040752 | -91.73661677 | 2020-12-24 05:23:04 | Clark, Missouri, US |
2410113 | 2410113 | 2020-12-23 | US | Vermont | Windsor | 50027 | 347 | 3 | 0 | 344 | 43.58010937 | -72.58595157 | 2020-12-24 05:23:04 | Windsor, Vermont, US |
3773051 | 3773051 | 2020-12-22 | US | Texas | Newton | 48351 | 260 | 17 | 0 | 344 | 30.78548982 | -93.74408813 | 2020-12-23 05:22:03 | Newton, Texas, US |
3773159 | 3773159 | 2020-12-22 | US | Vermont | Windsor | 50027 | 347 | 3 | 0 | 344 | 43.58010937 | -72.58595157 | 2020-12-23 05:22:03 | Windsor, Vermont, US |
930732 | 930732 | 2020-12-21 | US | Texas | Coke | 48081 | 290 | 10 | 0 | 344 | 31.88911733 | -100.5297533 | 2020-12-22 05:22:33 | Coke, Texas, US |
930883 | 930883 | 2020-12-21 | US | Texas | Reagan | 48383 | 251 | 6 | 0 | 344 | 31.36607041 | -101.5232659 | 2020-12-22 05:22:33 | Reagan, Texas, US |
2120349 | 2120349 | 2020-12-20 | US | Colorado | Park | 8093 | 380 | 5 | 0 | 344 | 39.120926 | -105.7182065 | 2020-12-21 05:27:58 | Park, Colorado, US |
2121001 | 2121001 | 2020-12-20 | US | Kansas | Haskell | 20081 | 345 | 1 | 0 | 344 | 37.5620394 | -100.8710738 | 2020-12-21 05:27:58 | Haskell, Kansas, US |
2121160 | 2121160 | 2020-12-20 | US | Kentucky | Owen | 21187 | 347 | 3 | 0 | 344 | 38.51679143 | -84.82404619 | 2020-12-21 05:27:58 | Owen, Kentucky, US |
2122904 | 2122904 | 2020-12-20 | US | Texas | Reagan | 48383 | 249 | 6 | 0 | 344 | 31.36607041 | -101.5232659 | 2020-12-21 05:27:58 | Reagan, Texas, US |
2932508 | 2932508 | 2020-12-19 | US | Kansas | Haskell | 20081 | 345 | 1 | 0 | 344 | 37.5620394 | -100.8710738 | 2020-12-20 05:27:32 | Haskell, Kansas, US |
2933153 | 2933153 | 2020-12-19 | US | Missouri | Ozark | 29153 | 348 | 4 | 0 | 344 | 36.64916339 | -92.44459066 | 2020-12-20 05:27:32 | Ozark, Missouri, US |
2933371 | 2933371 | 2020-12-19 | US | New Hampshire | Sullivan | 33019 | 349 | 5 | 0 | 344 | 43.36094111 | -72.22203125 | 2020-12-20 05:27:32 | Sullivan, New Hampshire, US |
2933771 | 2933771 | 2020-12-19 | US | Oklahoma | Jefferson | 40067 | 346 | 2 | 0 | 344 | 34.11130184 | -97.83182974 | 2020-12-20 05:27:32 | Jefferson, Oklahoma, US |
2934411 | 2934411 | 2020-12-19 | US | Texas | Reagan | 48383 | 249 | 6 | 0 | 344 | 31.36607041 | -101.5232659 | 2020-12-20 05:27:32 | Reagan, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);