johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
538 rows where active = 316 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 45
- Georgia 36
- Kansas 25
- Indiana 22
- Virginia 20
- Mississippi 19
- Iowa 18
- Minnesota 18
- North Carolina 17
- Puerto Rico 17
- South Dakota 17
- Colorado 16
- Kentucky 16
- Michigan 15
- Arkansas 14
- Missouri 14
- Ohio 14
- Illinois 13
- Nebraska 12
- New York 12
- Oklahoma 12
- Louisiana 11
- North Dakota 11
- Tennessee 11
- Alabama 10
- Idaho 10
- New Mexico 10
- Wisconsin 9
- West Virginia 8
- California 6
- …
country_or_region 1
- US · 538 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3670017 | 3670017 | 2021-03-06 | US | North Dakota | Hettinger | 38041 | 319 | 4 | 0 | 316 | 46.43375068 | -102.4632417 | 2021-03-07 05:21:54 | Hettinger, North Dakota, US |
3670022 | 3670022 | 2021-03-06 | US | North Dakota | McIntosh | 38051 | 323 | 7 | 0 | 316 | 46.11182017 | -99.44145858 | 2021-03-07 05:21:54 | McIntosh, North Dakota, US |
1618638 | 1618638 | 2021-03-05 | US | North Dakota | Hettinger | 38041 | 319 | 4 | 0 | 316 | 46.43375068 | -102.4632417 | 2021-03-06 04:23:41 | Hettinger, North Dakota, US |
1618643 | 1618643 | 2021-03-05 | US | North Dakota | McIntosh | 38051 | 323 | 7 | 0 | 316 | 46.11182017 | -99.44145858 | 2021-03-06 04:23:41 | McIntosh, North Dakota, US |
2210054 | 2210054 | 2021-03-04 | US | North Dakota | McIntosh | 38051 | 323 | 7 | 0 | 316 | 46.11182017 | -99.44145858 | 2021-03-05 05:26:29 | McIntosh, North Dakota, US |
3257026 | 3257026 | 2021-03-02 | US | South Dakota | Marshall | 46091 | 321 | 5 | 0 | 316 | 45.75870838 | -97.59855639 | 2021-03-03 05:23:28 | Marshall, South Dakota, US |
998867 | 998867 | 2021-03-01 | US | Alaska | Sitka | 2220 | 316 | 0 | 0 | 316 | 57.24124555 | -135.3206587 | 2021-03-02 05:23:30 | Sitka, Alaska, US |
999083 | 999083 | 2021-03-01 | US | Colorado | Saguache | 8109 | 329 | 4 | 0 | 316 | 38.08054629 | -106.282466 | 2021-03-02 05:23:30 | Saguache, Colorado, US |
999299 | 999299 | 2021-03-01 | US | Georgia | Schley | 13249 | 319 | 3 | 0 | 316 | 32.2654021 | -84.31258912 | 2021-03-02 05:23:30 | Schley, Georgia, US |
2368904 | 2368904 | 2021-02-28 | US | Kentucky | Hickman | 21105 | 323 | 7 | 0 | 316 | 36.67948079999999 | -88.97875928 | 2021-03-01 05:23:01 | Hickman, Kentucky, US |
3069510 | 3069510 | 2021-02-27 | US | West Virginia | Webster | 54101 | 319 | 3 | 0 | 316 | 38.49370949 | -80.4202023 | 2021-02-28 05:22:20 | Webster, West Virginia, US |
1860768 | 1860768 | 2021-02-25 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-26 05:22:40 | Rincon, Puerto Rico, US |
282946 | 282946 | 2021-02-24 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-25 05:24:57 | Rincon, Puerto Rico, US |
1939214 | 1939214 | 2021-02-23 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-24 05:29:16 | Rincon, Puerto Rico, US |
533469 | 533469 | 2021-02-22 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-23 05:23:41 | Rincon, Puerto Rico, US |
184803 | 184803 | 2021-02-21 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-22 05:24:21 | Rincon, Puerto Rico, US |
745077 | 745077 | 2021-02-20 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-21 05:24:33 | Rincon, Puerto Rico, US |
3050611 | 3050611 | 2021-02-16 | US | Alaska | Yukon-Koyukuk | 2290 | 320 | 4 | 0 | 316 | 65.50815459 | -151.3907387 | 2021-02-17 05:23:10 | Yukon-Koyukuk, Alaska, US |
1339182 | 1339182 | 2021-02-15 | US | Idaho | Adams | 16003 | 319 | 3 | 0 | 316 | 44.89333571 | -116.4545247 | 2021-02-16 05:24:38 | Adams, Idaho, US |
2284333 | 2284333 | 2021-02-14 | US | Idaho | Adams | 16003 | 319 | 3 | 0 | 316 | 44.89333571 | -116.4545247 | 2021-02-15 05:24:49 | Adams, Idaho, US |
2678733 | 2678733 | 2021-02-13 | US | Idaho | Adams | 16003 | 319 | 3 | 0 | 316 | 44.89333571 | -116.4545247 | 2021-02-14 05:23:43 | Adams, Idaho, US |
3979158 | 3979158 | 2021-02-10 | US | California | Trinity | 6105 | 335 | 3 | 0 | 316 | 40.64917670000001 | -123.114713 | 2021-02-11 05:23:55 | Trinity, California, US |
1530513 | 1530513 | 2021-02-09 | US | Oregon | Lake | 41037 | 322 | 6 | 0 | 316 | 42.79246693 | -120.3850163 | 2021-02-10 05:22:41 | Lake, Oregon, US |
1589161 | 1589161 | 2021-02-05 | US | Illinois | Hardin | 17069 | 326 | 10 | 0 | 316 | 37.51810645 | -88.26873022 | 2021-02-06 05:23:55 | Hardin, Illinois, US |
1591617 | 1591617 | 2021-02-05 | US | Washington | Lincoln | 53043 | 320 | 4 | 0 | 316 | 47.57705241 | -118.4194388 | 2021-02-06 05:23:55 | Lincoln, Washington, US |
791020 | 791020 | 2021-02-04 | US | Colorado | Phillips | 8095 | 349 | 13 | 0 | 316 | 40.59414277 | -102.3577703 | 2021-02-05 05:22:38 | Phillips, Colorado, US |
342463 | 342463 | 2021-02-03 | US | New Mexico | Hidalgo | 35023 | 325 | 9 | 0 | 316 | 31.91383467 | -108.7151824 | 2021-02-04 05:22:26 | Hidalgo, New Mexico, US |
343169 | 343169 | 2021-02-03 | US | South Dakota | Stanley | 46117 | 318 | 2 | 0 | 316 | 44.41381872 | -100.7349153 | 2021-02-04 05:22:26 | Stanley, South Dakota, US |
1687566 | 1687566 | 2021-02-02 | US | Texas | Donley | 48129 | 420 | 12 | 0 | 316 | 34.96517499 | -100.8140093 | 2021-02-03 05:22:52 | Donley, Texas, US |
1679536 | 1679536 | 2021-02-01 | US | Texas | Donley | 48129 | 420 | 12 | 0 | 316 | 34.96517499 | -100.8140093 | 2021-02-02 05:22:49 | Donley, Texas, US |
1462824 | 1462824 | 2021-01-31 | US | Texas | Donley | 48129 | 420 | 12 | 0 | 316 | 34.96517499 | -100.8140093 | 2021-02-01 05:22:53 | Donley, Texas, US |
2214732 | 2214732 | 2021-01-30 | US | Texas | Donley | 48129 | 420 | 12 | 0 | 316 | 34.96517499 | -100.8140093 | 2021-01-31 05:22:42 | Donley, Texas, US |
2214984 | 2214984 | 2021-01-30 | US | Virginia | Cumberland | 51049 | 320 | 4 | 0 | 316 | 37.51328851 | -78.24398086 | 2021-01-31 05:22:42 | Cumberland, Virginia, US |
1900209 | 1900209 | 2021-01-29 | US | Texas | Culberson | 48109 | 297 | 7 | 0 | 316 | 31.44506775 | -104.5185739 | 2021-01-30 05:22:49 | Culberson, Texas, US |
2485242 | 2485242 | 2021-01-28 | US | Vermont | Caledonia | 50005 | 320 | 4 | 0 | 316 | 44.46548598 | -72.10314651 | 2021-01-29 05:22:23 | Caledonia, Vermont, US |
2568123 | 2568123 | 2021-01-25 | US | Arkansas | Calhoun | 5013 | 318 | 2 | 0 | 316 | 33.55598792 | -92.49974403 | 2021-01-26 05:22:02 | Calhoun, Arkansas, US |
2569412 | 2569412 | 2021-01-25 | US | Minnesota | Red Lake | 27125 | 320 | 4 | 0 | 316 | 47.87197525 | -96.09561104 | 2021-01-26 05:22:02 | Red Lake, Minnesota, US |
2570767 | 2570767 | 2021-01-25 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-26 05:22:02 | Hartley, Texas, US |
1759755 | 1759755 | 2021-01-24 | US | Arkansas | Calhoun | 5013 | 318 | 2 | 0 | 316 | 33.55598792 | -92.49974403 | 2021-01-25 05:22:16 | Calhoun, Arkansas, US |
1761044 | 1761044 | 2021-01-24 | US | Minnesota | Red Lake | 27125 | 320 | 4 | 0 | 316 | 47.87197525 | -96.09561104 | 2021-01-25 05:22:16 | Red Lake, Minnesota, US |
1762351 | 1762351 | 2021-01-24 | US | Texas | Culberson | 48109 | 294 | 4 | 0 | 316 | 31.44506775 | -104.5185739 | 2021-01-25 05:22:16 | Culberson, Texas, US |
1762399 | 1762399 | 2021-01-24 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-25 05:22:16 | Hartley, Texas, US |
2428651 | 2428651 | 2021-01-23 | US | Minnesota | Red Lake | 27125 | 320 | 4 | 0 | 316 | 47.87197525 | -96.09561104 | 2021-01-24 05:22:35 | Red Lake, Minnesota, US |
2429763 | 2429763 | 2021-01-23 | US | South Dakota | Faulk | 46049 | 329 | 13 | 0 | 316 | 45.07082625 | -99.14535601 | 2021-01-24 05:22:35 | Faulk, South Dakota, US |
2430006 | 2430006 | 2021-01-23 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-24 05:22:35 | Hartley, Texas, US |
436265 | 436265 | 2021-01-21 | US | Idaho | Bear Lake | 16007 | 318 | 2 | 0 | 316 | 42.28269683 | -111.32892379999998 | 2021-01-22 05:22:10 | Bear Lake, Idaho, US |
438372 | 438372 | 2021-01-21 | US | Texas | Blanco | 48031 | 399 | 11 | 0 | 316 | 30.26640707 | -98.3999852 | 2021-01-22 05:22:10 | Blanco, Texas, US |
438459 | 438459 | 2021-01-21 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-22 05:22:10 | Hartley, Texas, US |
1097190 | 1097190 | 2021-01-20 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-21 05:22:01 | Hartley, Texas, US |
3504616 | 3504616 | 2021-01-17 | US | Kansas | Cheyenne | 20023 | 327 | 11 | 0 | 316 | 39.78580976 | -101.7318201 | 2021-01-18 05:22:34 | Cheyenne, Kansas, US |
3506636 | 3506636 | 2021-01-17 | US | Vermont | Orleans | 50019 | 321 | 5 | 0 | 316 | 44.82964024 | -72.24562697 | 2021-01-18 05:22:34 | Orleans, Vermont, US |
3506954 | 3506954 | 2021-01-17 | US | Wyoming | Hot Springs | 56017 | 318 | 2 | 0 | 316 | 43.71930657 | -108.4423174 | 2021-01-18 05:22:34 | Hot Springs, Wyoming, US |
3102699 | 3102699 | 2021-01-16 | US | Kansas | Cheyenne | 20023 | 327 | 11 | 0 | 316 | 39.78580976 | -101.7318201 | 2021-01-17 05:22:17 | Cheyenne, Kansas, US |
3104305 | 3104305 | 2021-01-16 | US | South Dakota | Hand | 46059 | 320 | 4 | 0 | 316 | 44.54708407 | -99.00386459 | 2021-01-17 05:22:17 | Hand, South Dakota, US |
3104719 | 3104719 | 2021-01-16 | US | Vermont | Orleans | 50019 | 321 | 5 | 0 | 316 | 44.82964024 | -72.24562697 | 2021-01-17 05:22:17 | Orleans, Vermont, US |
3516661 | 3516661 | 2021-01-15 | US | Kansas | Cheyenne | 20023 | 327 | 11 | 0 | 316 | 39.78580976 | -101.7318201 | 2021-01-16 05:22:40 | Cheyenne, Kansas, US |
3518267 | 3518267 | 2021-01-15 | US | South Dakota | Hand | 46059 | 320 | 4 | 0 | 316 | 44.54708407 | -99.00386459 | 2021-01-16 05:22:40 | Hand, South Dakota, US |
3518498 | 3518498 | 2021-01-15 | US | Texas | Hall | 48191 | 479 | 10 | 0 | 316 | 34.5307555 | -100.6813852 | 2021-01-16 05:22:40 | Hall, Texas, US |
3880834 | 3880834 | 2021-01-14 | US | Kansas | Cheyenne | 20023 | 327 | 11 | 0 | 316 | 39.78580976 | -101.7318201 | 2021-01-15 05:22:24 | Cheyenne, Kansas, US |
3881242 | 3881242 | 2021-01-14 | US | Michigan | Oscoda | 26135 | 335 | 19 | 0 | 316 | 44.68192279 | -84.12939244 | 2021-01-15 05:22:24 | Oscoda, Michigan, US |
3882158 | 3882158 | 2021-01-14 | US | Oklahoma | Roger Mills | 40129 | 322 | 6 | 0 | 316 | 35.68711719 | -99.69666167 | 2021-01-15 05:22:24 | Roger Mills, Oklahoma, US |
3882439 | 3882439 | 2021-01-14 | US | South Dakota | Hand | 46059 | 320 | 4 | 0 | 316 | 44.54708407 | -99.00386459 | 2021-01-15 05:22:24 | Hand, South Dakota, US |
3309461 | 3309461 | 2021-01-13 | US | Kansas | Cheyenne | 20023 | 327 | 11 | 0 | 316 | 39.78580976 | -101.7318201 | 2021-01-14 05:22:32 | Cheyenne, Kansas, US |
3309869 | 3309869 | 2021-01-13 | US | Michigan | Oscoda | 26135 | 335 | 19 | 0 | 316 | 44.68192279 | -84.12939244 | 2021-01-14 05:22:32 | Oscoda, Michigan, US |
3311304 | 3311304 | 2021-01-13 | US | Texas | Hartley | 48205 | 482 | 1 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-14 05:22:32 | Hartley, Texas, US |
777379 | 777379 | 2021-01-12 | US | Texas | Carson | 48065 | 597 | 11 | 0 | 316 | 35.40365929 | -101.3542669 | 2021-01-13 05:22:15 | Carson, Texas, US |
777449 | 777449 | 2021-01-12 | US | Texas | Hartley | 48205 | 482 | 1 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-13 05:22:15 | Hartley, Texas, US |
190666 | 190666 | 2021-01-11 | US | Colorado | Clear Creek | 8019 | 341 | 2 | 0 | 316 | 39.68864463 | -105.6463118 | 2021-01-12 05:22:15 | Clear Creek, Colorado, US |
192089 | 192089 | 2021-01-11 | US | Montana | Sweet Grass | 30097 | 322 | 6 | 0 | 316 | 45.81367654 | -109.9425686 | 2021-01-12 05:22:15 | Sweet Grass, Montana, US |
193171 | 193171 | 2021-01-11 | US | Texas | Haskell | 48207 | 328 | 13 | 0 | 316 | 33.17823584 | -99.73037358 | 2021-01-12 05:22:15 | Haskell, Texas, US |
2628974 | 2628974 | 2021-01-10 | US | Texas | Haskell | 48207 | 328 | 13 | 0 | 316 | 33.17823584 | -99.73037358 | 2021-01-11 05:21:50 | Haskell, Texas, US |
3901980 | 3901980 | 2021-01-09 | US | Montana | Sweet Grass | 30097 | 322 | 6 | 0 | 316 | 45.81367654 | -109.9425686 | 2021-01-10 05:22:12 | Sweet Grass, Montana, US |
3903062 | 3903062 | 2021-01-09 | US | Texas | Haskell | 48207 | 328 | 13 | 0 | 316 | 33.17823584 | -99.73037358 | 2021-01-10 05:22:12 | Haskell, Texas, US |
156741 | 156741 | 2021-01-08 | US | Puerto Rico | Penuelas | 72111 | 316 | 0 | 0 | 316 | 18.059645 | -66.721572 | 2021-01-09 05:22:18 | Penuelas, Puerto Rico, US |
156847 | 156847 | 2021-01-08 | US | South Dakota | Hanson | 46061 | 319 | 3 | 0 | 316 | 43.6746384 | -97.78715148 | 2021-01-09 05:22:18 | Hanson, South Dakota, US |
2542751 | 2542751 | 2021-01-07 | US | Kansas | Trego | 20195 | 321 | 5 | 0 | 316 | 38.91467218 | -99.87284448 | 2021-01-08 05:22:42 | Trego, Kansas, US |
2543065 | 2543065 | 2021-01-07 | US | Michigan | Montmorency | 26119 | 327 | 11 | 0 | 316 | 45.0275929 | -84.12696227 | 2021-01-08 05:22:42 | Montmorency, Michigan, US |
2543927 | 2543927 | 2021-01-07 | US | Oklahoma | Beaver | 40007 | 318 | 2 | 0 | 316 | 36.7496847 | -100.4758872 | 2021-01-08 05:22:42 | Beaver, Oklahoma, US |
2544271 | 2544271 | 2021-01-07 | US | South Dakota | Hanson | 46061 | 319 | 3 | 0 | 316 | 43.6746384 | -97.78715148 | 2021-01-08 05:22:42 | Hanson, South Dakota, US |
2866060 | 2866060 | 2021-01-06 | US | Kansas | Trego | 20195 | 321 | 5 | 0 | 316 | 38.91467218 | -99.87284448 | 2021-01-07 05:22:03 | Trego, Kansas, US |
2866905 | 2866905 | 2021-01-06 | US | New Mexico | Los Alamos | 35028 | 316 | 0 | 0 | 316 | 35.86631386 | -106.3134985 | 2021-01-07 05:22:03 | Los Alamos, New Mexico, US |
2867236 | 2867236 | 2021-01-06 | US | Oklahoma | Beaver | 40007 | 318 | 2 | 0 | 316 | 36.7496847 | -100.4758872 | 2021-01-07 05:22:03 | Beaver, Oklahoma, US |
2867580 | 2867580 | 2021-01-06 | US | South Dakota | Hanson | 46061 | 319 | 3 | 0 | 316 | 43.6746384 | -97.78715148 | 2021-01-07 05:22:03 | Hanson, South Dakota, US |
3035134 | 3035134 | 2021-01-05 | US | Georgia | Marion | 13197 | 326 | 10 | 0 | 316 | 32.3483402 | -84.52733571 | 2021-01-06 05:22:16 | Marion, Georgia, US |
3036415 | 3036415 | 2021-01-05 | US | Nebraska | Stanton | 31167 | 324 | 8 | 0 | 316 | 41.9169835 | -97.19394708 | 2021-01-06 05:22:16 | Stanton, Nebraska, US |
3036589 | 3036589 | 2021-01-05 | US | North Carolina | Camden | 37029 | 321 | 5 | 0 | 316 | 36.33804939 | -76.15568396 | 2021-01-06 05:22:16 | Camden, North Carolina, US |
3036823 | 3036823 | 2021-01-05 | US | Oklahoma | Beaver | 40007 | 318 | 2 | 0 | 316 | 36.7496847 | -100.4758872 | 2021-01-06 05:22:16 | Beaver, Oklahoma, US |
3037661 | 3037661 | 2021-01-05 | US | Virginia | Madison | 51113 | 320 | 4 | 0 | 316 | 38.41531222 | -78.28220331 | 2021-01-06 05:22:16 | Madison, Virginia, US |
1064368 | 1064368 | 2021-01-04 | US | Oklahoma | Beaver | 40007 | 318 | 2 | 0 | 316 | 36.7496847 | -100.4758872 | 2021-01-05 05:21:49 | Beaver, Oklahoma, US |
1065116 | 1065116 | 2021-01-04 | US | Vermont | Addison | 50001 | 320 | 4 | 0 | 316 | 44.03217337 | -73.14130877 | 2021-01-05 05:21:49 | Addison, Vermont, US |
3231049 | 3231049 | 2021-01-03 | US | Colorado | Conejos | 8021 | 366 | 4 | 0 | 316 | 37.201606 | -106.19174879999998 | 2021-01-04 05:22:02 | Conejos, Colorado, US |
2228118 | 2228118 | 2021-01-02 | US | Colorado | Conejos | 8021 | 363 | 4 | 0 | 316 | 37.201606 | -106.19174879999998 | 2021-01-03 05:22:52 | Conejos, Colorado, US |
2231013 | 2231013 | 2021-01-02 | US | West Virginia | Pendleton | 54071 | 318 | 2 | 0 | 316 | 38.68314479 | -79.35084086 | 2021-01-03 05:22:52 | Pendleton, West Virginia, US |
1013406 | 1013406 | 2020-12-30 | US | Texas | Hartley | 48205 | 443 | 0 | 0 | 316 | 35.84008013 | -102.6029022 | 2020-12-31 05:22:49 | Hartley, Texas, US |
204984 | 204984 | 2020-12-25 | US | Puerto Rico | Florida | 72054 | 316 | 0 | 0 | 316 | 18.373715 | -66.560488 | 2020-12-26 05:22:28 | Florida, Puerto Rico, US |
3692005 | 3692005 | 2020-12-24 | US | Arkansas | Woodruff | 5147 | 318 | 2 | 0 | 316 | 35.18902527 | -91.2439489 | 2020-12-25 05:22:48 | Woodruff, Arkansas, US |
2408912 | 2408912 | 2020-12-23 | US | Nebraska | Kimball | 31105 | 320 | 4 | 0 | 316 | 41.19774275 | -103.7148131 | 2020-12-24 05:23:04 | Kimball, Nebraska, US |
3772917 | 3772917 | 2020-12-22 | US | Texas | Coleman | 48083 | 364 | 13 | 0 | 316 | 31.76736834 | -99.45240766 | 2020-12-23 05:22:03 | Coleman, Texas, US |
929887 | 929887 | 2020-12-21 | US | New Mexico | Quay | 35037 | 322 | 6 | 0 | 316 | 35.10403332 | -103.5481727 | 2020-12-22 05:22:33 | Quay, New Mexico, US |
2121094 | 2121094 | 2020-12-20 | US | Kentucky | Crittenden | 21055 | 319 | 3 | 0 | 316 | 37.35839237 | -88.08826090000002 | 2020-12-21 05:27:58 | Crittenden, Kentucky, 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]);