johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
439 rows where active = 449 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Georgia 35
- Puerto Rico 26
- Texas 25
- Virginia 22
- Missouri 21
- North Carolina 19
- Mississippi 18
- Illinois 16
- Pennsylvania 14
- Tennessee 14
- Indiana 13
- South Dakota 13
- Louisiana 12
- Iowa 11
- Kansas 11
- Kentucky 11
- Idaho 10
- North Dakota 10
- Arkansas 9
- Michigan 9
- Alabama 8
- Colorado 8
- Minnesota 8
- Washington 8
- Ohio 7
- South Carolina 7
- Wisconsin 7
- Oklahoma 6
- Oregon 6
- Florida 5
- …
country_or_region 1
- US · 439 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2367927 | 2367927 | 2021-02-28 | US | Alaska | Southeast Fairbanks | 2240 | 452 | 3 | 0 | 449 | 63.87692095 | -143.2127643 | 2021-03-01 05:23:01 | Southeast Fairbanks, Alaska, US |
3066429 | 3066429 | 2021-02-27 | US | Alaska | Southeast Fairbanks | 2240 | 452 | 3 | 0 | 449 | 63.87692095 | -143.2127643 | 2021-02-28 05:22:20 | Southeast Fairbanks, Alaska, US |
3067444 | 3067444 | 2021-02-27 | US | Kentucky | Nicholas | 21181 | 455 | 6 | 0 | 449 | 38.33342292 | -84.01889177 | 2021-02-28 05:22:20 | Nicholas, Kentucky, US |
2184013 | 2184013 | 2021-02-26 | US | Alaska | Southeast Fairbanks | 2240 | 452 | 3 | 0 | 449 | 63.87692095 | -143.2127643 | 2021-02-27 05:22:28 | Southeast Fairbanks, Alaska, US |
472053 | 472053 | 2021-02-19 | US | Colorado | Rio Blanco | 8103 | 481 | 4 | 0 | 449 | 39.97913541 | -108.2179009 | 2021-02-20 05:22:51 | Rio Blanco, Colorado, US |
1153762 | 1153762 | 2021-02-18 | US | Colorado | Rio Blanco | 8103 | 478 | 4 | 0 | 449 | 39.97913541 | -108.2179009 | 2021-02-19 05:24:16 | Rio Blanco, Colorado, US |
2286750 | 2286750 | 2021-02-14 | US | Virginia | Fairfax City | 51600 | 461 | 12 | 0 | 449 | 38.85157547 | -77.29779640000002 | 2021-02-15 05:24:49 | Fairfax City, Virginia, US |
3542661 | 3542661 | 2021-02-12 | US | Texas | Sabine | 48403 | 504 | 37 | 0 | 449 | 31.34318809 | -93.85440451 | 2021-02-13 05:22:12 | Sabine, Texas, US |
2639732 | 2639732 | 2021-02-11 | US | Montana | Pondera | 30073 | 452 | 3 | 0 | 449 | 48.22773388 | -112.2252703 | 2021-02-12 05:23:29 | Pondera, Montana, US |
2640924 | 2640924 | 2021-02-11 | US | Texas | Sabine | 48403 | 504 | 37 | 0 | 449 | 31.34318809 | -93.85440451 | 2021-02-12 05:23:29 | Sabine, Texas, US |
3980965 | 3980965 | 2021-02-10 | US | North Dakota | Eddy | 38027 | 451 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-11 05:23:55 | Eddy, North Dakota, US |
1529989 | 1529989 | 2021-02-09 | US | Nebraska | Morrill | 31123 | 464 | 15 | 0 | 449 | 41.71711774 | -103.0061405 | 2021-02-10 05:22:41 | Morrill, Nebraska, US |
1530285 | 1530285 | 2021-02-09 | US | North Dakota | Eddy | 38027 | 450 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-10 05:22:41 | Eddy, North Dakota, US |
616076 | 616076 | 2021-02-08 | US | North Dakota | Eddy | 38027 | 450 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-09 05:23:30 | Eddy, North Dakota, US |
1589887 | 1589887 | 2021-02-05 | US | Minnesota | Grant | 27051 | 457 | 8 | 0 | 449 | 45.93424769 | -96.01139609 | 2021-02-06 05:23:55 | Grant, Minnesota, US |
792771 | 792771 | 2021-02-04 | US | North Dakota | Eddy | 38027 | 449 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-05 05:22:38 | Eddy, North Dakota, US |
342663 | 342663 | 2021-02-03 | US | North Dakota | Eddy | 38027 | 448 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-04 05:22:26 | Eddy, North Dakota, US |
342821 | 342821 | 2021-02-03 | US | Oklahoma | Greer | 40055 | 462 | 13 | 0 | 449 | 34.93535801 | -99.5605612 | 2021-02-04 05:22:26 | Greer, Oklahoma, US |
343639 | 343639 | 2021-02-03 | US | Virginia | Mathews | 51115 | 455 | 6 | 0 | 449 | 37.44164146 | -76.34098896 | 2021-02-04 05:22:26 | Mathews, Virginia, US |
1685867 | 1685867 | 2021-02-02 | US | Kentucky | Bracken | 21023 | 452 | 3 | 0 | 449 | 38.69158994 | -84.08532444 | 2021-02-03 05:22:52 | Bracken, Kentucky, US |
1688035 | 1688035 | 2021-02-02 | US | Wisconsin | Florence | 55037 | 461 | 12 | 0 | 449 | 45.84963535 | -88.39804137 | 2021-02-03 05:22:52 | Florence, Wisconsin, US |
1678370 | 1678370 | 2021-02-01 | US | Missouri | Hickory | 29085 | 459 | 10 | 0 | 449 | 37.94163617 | -93.3203037 | 2021-02-02 05:22:49 | Hickory, Missouri, US |
1461658 | 1461658 | 2021-01-31 | US | Missouri | Hickory | 29085 | 459 | 10 | 0 | 449 | 37.94163617 | -93.3203037 | 2021-02-01 05:22:53 | Hickory, Missouri, US |
1461712 | 1461712 | 2021-01-31 | US | Missouri | Shannon | 29203 | 459 | 10 | 0 | 449 | 37.15772072 | -91.40190382 | 2021-02-01 05:22:53 | Shannon, Missouri, US |
2212499 | 2212499 | 2021-01-30 | US | Georgia | Marion | 13197 | 460 | 11 | 0 | 449 | 32.3483402 | -84.52733571 | 2021-01-31 05:22:42 | Marion, Georgia, US |
2213566 | 2213566 | 2021-01-30 | US | Missouri | Hickory | 29085 | 459 | 10 | 0 | 449 | 37.94163617 | -93.3203037 | 2021-01-31 05:22:42 | Hickory, Missouri, US |
2214522 | 2214522 | 2021-01-30 | US | South Dakota | Deuel | 46039 | 457 | 8 | 0 | 449 | 44.75994309 | -96.66943645 | 2021-01-31 05:22:42 | Deuel, South Dakota, US |
1899053 | 1899053 | 2021-01-29 | US | Missouri | Hickory | 29085 | 459 | 10 | 0 | 449 | 37.94163617 | -93.3203037 | 2021-01-30 05:22:49 | Hickory, Missouri, US |
1900009 | 1900009 | 2021-01-29 | US | South Dakota | Deuel | 46039 | 457 | 8 | 0 | 449 | 44.75994309 | -96.66943645 | 2021-01-30 05:22:49 | Deuel, South Dakota, US |
2484821 | 2484821 | 2021-01-28 | US | South Dakota | Corson | 46031 | 460 | 11 | 0 | 449 | 45.70889983 | -101.1970473 | 2021-01-29 05:22:23 | Corson, South Dakota, US |
2484825 | 2484825 | 2021-01-28 | US | South Dakota | Deuel | 46039 | 457 | 8 | 0 | 449 | 44.75994309 | -96.66943645 | 2021-01-29 05:22:23 | Deuel, South Dakota, US |
3156460 | 3156460 | 2021-01-27 | US | South Dakota | Deuel | 46039 | 457 | 8 | 0 | 449 | 44.75994309 | -96.66943645 | 2021-01-28 05:22:24 | Deuel, South Dakota, US |
13297 | 13297 | 2021-01-26 | US | Illinois | Calhoun | 17013 | 451 | 2 | 0 | 449 | 39.16840183 | -90.66330078 | 2021-01-27 05:23:41 | Calhoun, Illinois, US |
2568621 | 2568621 | 2021-01-25 | US | Illinois | Calhoun | 17013 | 450 | 1 | 0 | 449 | 39.16840183 | -90.66330078 | 2021-01-26 05:22:02 | Calhoun, Illinois, US |
1760253 | 1760253 | 2021-01-24 | US | Illinois | Calhoun | 17013 | 450 | 1 | 0 | 449 | 39.16840183 | -90.66330078 | 2021-01-25 05:22:16 | Calhoun, Illinois, US |
2427860 | 2427860 | 2021-01-23 | US | Illinois | Calhoun | 17013 | 450 | 1 | 0 | 449 | 39.16840183 | -90.66330078 | 2021-01-24 05:22:35 | Calhoun, Illinois, US |
436342 | 436342 | 2021-01-21 | US | Illinois | Henderson | 17071 | 456 | 7 | 0 | 449 | 40.81908672 | -90.92491462 | 2021-01-22 05:22:10 | Henderson, Illinois, US |
436663 | 436663 | 2021-01-21 | US | Kansas | Meade | 20119 | 456 | 7 | 0 | 449 | 37.23859987 | -100.364831 | 2021-01-22 05:22:10 | Meade, Kansas, US |
1095073 | 1095073 | 2021-01-20 | US | Illinois | Henderson | 17071 | 456 | 7 | 0 | 449 | 40.81908672 | -90.92491462 | 2021-01-21 05:22:01 | Henderson, Illinois, US |
1095394 | 1095394 | 2021-01-20 | US | Kansas | Meade | 20119 | 456 | 7 | 0 | 449 | 37.23859987 | -100.364831 | 2021-01-21 05:22:01 | Meade, Kansas, US |
909664 | 909664 | 2021-01-19 | US | Louisiana | Cameron | 22023 | 453 | 4 | 0 | 449 | 29.87592238 | -93.19310676 | 2021-01-20 05:21:54 | Cameron, Louisiana, US |
911283 | 911283 | 2021-01-19 | US | Texas | Hemphill | 48211 | 560 | 2 | 0 | 449 | 35.83764858 | -100.2703577 | 2021-01-20 05:21:54 | Hemphill, Texas, US |
911353 | 911353 | 2021-01-19 | US | Texas | Newton | 48351 | 394 | 20 | 0 | 449 | 30.78548982 | -93.74408813 | 2021-01-20 05:21:54 | Newton, Texas, US |
3103750 | 3103750 | 2021-01-16 | US | North Carolina | Gates | 37073 | 461 | 12 | 0 | 449 | 36.44667547 | -76.69749701 | 2021-01-17 05:22:17 | Gates, North Carolina, US |
3516048 | 3516048 | 2021-01-15 | US | Colorado | San Miguel | 8113 | 547 | 0 | 0 | 449 | 38.00450883 | -108.4020725 | 2021-01-16 05:22:40 | San Miguel, Colorado, US |
3516339 | 3516339 | 2021-01-15 | US | Idaho | Lincoln | 16063 | 458 | 9 | 0 | 449 | 43.0012336 | -114.1358773 | 2021-01-16 05:22:40 | Lincoln, Idaho, US |
3517093 | 3517093 | 2021-01-15 | US | Minnesota | Big Stone | 27011 | 452 | 3 | 0 | 449 | 45.42712824 | -96.41403739 | 2021-01-16 05:22:40 | Big Stone, Minnesota, US |
3880512 | 3880512 | 2021-01-14 | US | Idaho | Lincoln | 16063 | 458 | 9 | 0 | 449 | 43.0012336 | -114.1358773 | 2021-01-15 05:22:24 | Lincoln, Idaho, US |
3880549 | 3880549 | 2021-01-14 | US | Illinois | Edwards | 17047 | 456 | 7 | 0 | 449 | 38.41353228 | -88.05720863 | 2021-01-15 05:22:24 | Edwards, Illinois, US |
3881610 | 3881610 | 2021-01-14 | US | Nebraska | Boone | 31011 | 453 | 4 | 0 | 449 | 41.70759415 | -98.06737183 | 2021-01-15 05:22:24 | Boone, Nebraska, US |
3309139 | 3309139 | 2021-01-13 | US | Idaho | Lincoln | 16063 | 458 | 9 | 0 | 449 | 43.0012336 | -114.1358773 | 2021-01-14 05:22:32 | Lincoln, Idaho, US |
3311523 | 3311523 | 2021-01-13 | US | Virginia | Essex | 51057 | 452 | 3 | 0 | 449 | 37.93357639 | -76.94230311 | 2021-01-14 05:22:32 | Essex, Virginia, US |
774874 | 774874 | 2021-01-12 | US | Arkansas | Woodruff | 5147 | 453 | 4 | 0 | 449 | 35.18902527 | -91.2439489 | 2021-01-13 05:22:15 | Woodruff, Arkansas, US |
774967 | 774967 | 2021-01-12 | US | Colorado | Kit Carson | 8063 | 505 | 10 | 0 | 449 | 39.30497777 | -102.6022199 | 2021-01-13 05:22:15 | Kit Carson, Colorado, US |
775696 | 775696 | 2021-01-12 | US | Kansas | Washington | 20201 | 457 | 8 | 0 | 449 | 39.78420784 | -97.0875323 | 2021-01-13 05:22:15 | Washington, Kansas, US |
191417 | 191417 | 2021-01-11 | US | Kansas | Washington | 20201 | 457 | 8 | 0 | 449 | 39.78420784 | -97.0875323 | 2021-01-12 05:22:15 | Washington, Kansas, US |
193357 | 193357 | 2021-01-11 | US | Virginia | Amelia | 51007 | 456 | 7 | 0 | 449 | 37.34081025 | -77.98584649 | 2021-01-12 05:22:15 | Amelia, Virginia, US |
2544695 | 2544695 | 2021-01-07 | US | Virginia | Amelia | 51007 | 456 | 7 | 0 | 449 | 37.34081025 | -77.98584649 | 2021-01-08 05:22:42 | Amelia, Virginia, US |
2865490 | 2865490 | 2021-01-06 | US | Georgia | Crawford | 13079 | 457 | 8 | 0 | 449 | 32.71391813 | -83.98061238 | 2021-01-07 05:22:03 | Crawford, Georgia, US |
3037067 | 3037067 | 2021-01-05 | US | Puerto Rico | Salinas | 72123 | 449 | 0 | 0 | 449 | 18.010386999999994 | -66.256592 | 2021-01-06 05:22:16 | Salinas, Puerto Rico, US |
3037497 | 3037497 | 2021-01-05 | US | Texas | Refugio | 48391 | 508 | 17 | 0 | 449 | 28.3238976 | -97.15766311 | 2021-01-06 05:22:16 | Refugio, Texas, US |
3037504 | 3037504 | 2021-01-05 | US | Texas | San Augustine | 48405 | 345 | 24 | 0 | 449 | 31.39457611 | -94.17000399 | 2021-01-06 05:22:16 | San Augustine, Texas, US |
3037674 | 3037674 | 2021-01-05 | US | Virginia | Northumberland | 51133 | 459 | 10 | 0 | 449 | 37.89202088 | -76.41949732 | 2021-01-06 05:22:16 | Northumberland, Virginia, US |
1065049 | 1065049 | 2021-01-04 | US | Texas | San Augustine | 48405 | 345 | 24 | 0 | 449 | 31.39457611 | -94.17000399 | 2021-01-05 05:21:49 | San Augustine, Texas, US |
3233171 | 3233171 | 2021-01-03 | US | Puerto Rico | Ciales | 72039 | 449 | 0 | 0 | 449 | 18.28885 | -66.516475 | 2021-01-04 05:22:02 | Ciales, Puerto Rico, US |
3233652 | 3233652 | 2021-01-03 | US | Texas | San Augustine | 48405 | 345 | 24 | 0 | 449 | 31.39457611 | -94.17000399 | 2021-01-04 05:22:02 | San Augustine, Texas, US |
2229063 | 2229063 | 2021-01-02 | US | Maine | Franklin | 23007 | 454 | 5 | 0 | 449 | 44.97330019 | -70.44381045 | 2021-01-03 05:22:52 | Franklin, Maine, US |
2230240 | 2230240 | 2021-01-02 | US | Puerto Rico | Ciales | 72039 | 449 | 0 | 0 | 449 | 18.28885 | -66.516475 | 2021-01-03 05:22:52 | Ciales, Puerto Rico, US |
2230721 | 2230721 | 2021-01-02 | US | Texas | San Augustine | 48405 | 345 | 24 | 0 | 449 | 31.39457611 | -94.17000399 | 2021-01-03 05:22:52 | San Augustine, Texas, US |
2230963 | 2230963 | 2021-01-02 | US | Washington | Pend Oreille | 53051 | 453 | 4 | 0 | 449 | 48.53234021 | -117.2741804 | 2021-01-03 05:22:52 | Pend Oreille, Washington, US |
1138427 | 1138427 | 2021-01-01 | US | Maine | Franklin | 23007 | 454 | 5 | 0 | 449 | 44.97330019 | -70.44381045 | 2021-01-02 05:22:33 | Franklin, Maine, US |
1139607 | 1139607 | 2021-01-01 | US | Puerto Rico | Comerio | 72045 | 449 | 0 | 0 | 449 | 18.224687 | -66.221622 | 2021-01-02 05:22:33 | Comerio, Puerto Rico, US |
1140085 | 1140085 | 2021-01-01 | US | Texas | San Augustine | 48405 | 345 | 24 | 0 | 449 | 31.39457611 | -94.17000399 | 2021-01-02 05:22:33 | San Augustine, Texas, US |
1140327 | 1140327 | 2021-01-01 | US | Washington | Pend Oreille | 53051 | 453 | 4 | 0 | 449 | 48.53234021 | -117.2741804 | 2021-01-02 05:22:33 | Pend Oreille, Washington, US |
3698839 | 3698839 | 2020-12-31 | US | Virginia | King William | 51101 | 453 | 4 | 0 | 449 | 37.70965316 | -77.09384941 | 2021-01-01 05:23:07 | King William, Virginia, US |
3698933 | 3698933 | 2020-12-31 | US | Washington | Pend Oreille | 53051 | 453 | 4 | 0 | 449 | 48.53234021 | -117.2741804 | 2021-01-01 05:23:07 | Pend Oreille, Washington, US |
1011195 | 1011195 | 2020-12-30 | US | Georgia | Wheeler | 13309 | 468 | 19 | 0 | 449 | 32.12009104 | -82.72574721 | 2020-12-31 05:22:49 | Wheeler, Georgia, US |
1012222 | 1012222 | 2020-12-30 | US | Missouri | Maries | 29125 | 455 | 6 | 0 | 449 | 38.16193985 | -91.92249662 | 2020-12-31 05:22:49 | Maries, Missouri, US |
766819 | 766819 | 2020-12-29 | US | Arkansas | Monroe | 5095 | 456 | 7 | 0 | 449 | 34.6815935 | -91.20540287 | 2020-12-30 05:22:34 | Monroe, Arkansas, US |
767936 | 767936 | 2020-12-29 | US | Michigan | Crawford | 26039 | 455 | 6 | 0 | 449 | 44.68255561 | -84.61006219 | 2020-12-30 05:22:34 | Crawford, Michigan, US |
3764344 | 3764344 | 2020-12-28 | US | Puerto Rico | Quebradillas | 72115 | 449 | 0 | 0 | 449 | 18.439692 | -66.926113 | 2020-12-29 05:22:37 | Quebradillas, Puerto Rico, US |
3779086 | 3779086 | 2020-12-27 | US | Iowa | Fremont | 19071 | 454 | 5 | 0 | 449 | 40.74542720000001 | -95.60129045 | 2020-12-28 05:22:06 | Fremont, Iowa, US |
3779322 | 3779322 | 2020-12-27 | US | Kentucky | Leslie | 21131 | 450 | 1 | 0 | 449 | 37.09246661 | -83.37999606 | 2020-12-28 05:22:06 | Leslie, Kentucky, US |
3781173 | 3781173 | 2020-12-27 | US | Vermont | Bennington | 50003 | 452 | 3 | 0 | 449 | 43.03519828 | -73.09048868 | 2020-12-28 05:22:06 | Bennington, Vermont, US |
2224385 | 2224385 | 2020-12-26 | US | Georgia | Treutlen | 13283 | 464 | 15 | 0 | 449 | 32.40422134 | -82.56904553 | 2020-12-27 05:22:55 | Treutlen, Georgia, US |
2224691 | 2224691 | 2020-12-26 | US | Iowa | Fremont | 19071 | 454 | 5 | 0 | 449 | 40.74542720000001 | -95.60129045 | 2020-12-27 05:22:55 | Fremont, Iowa, US |
2224927 | 2224927 | 2020-12-26 | US | Kentucky | Leslie | 21131 | 450 | 1 | 0 | 449 | 37.09246661 | -83.37999606 | 2020-12-27 05:22:55 | Leslie, Kentucky, US |
203438 | 203438 | 2020-12-25 | US | Iowa | Fremont | 19071 | 454 | 5 | 0 | 449 | 40.74542720000001 | -95.60129045 | 2020-12-26 05:22:28 | Fremont, Iowa, US |
3692661 | 3692661 | 2020-12-24 | US | Iowa | Fremont | 19071 | 454 | 5 | 0 | 449 | 40.74542720000001 | -95.60129045 | 2020-12-25 05:22:48 | Fremont, Iowa, US |
3693657 | 3693657 | 2020-12-24 | US | New Mexico | Colfax | 35007 | 463 | 14 | 0 | 449 | 36.60569702 | -104.64726740000002 | 2020-12-25 05:22:48 | Colfax, New Mexico, US |
2409087 | 2409087 | 2020-12-23 | US | New York | Schuyler | 36097 | 458 | 9 | 0 | 449 | 42.39184015 | -76.8773299 | 2020-12-24 05:23:04 | Schuyler, New York, US |
3771218 | 3771218 | 2020-12-22 | US | Kansas | Stevens | 20189 | 454 | 5 | 0 | 449 | 37.1923008 | -101.3118967 | 2020-12-23 05:22:03 | Stevens, Kansas, US |
3771802 | 3771802 | 2020-12-22 | US | Missouri | Montgomery | 29139 | 457 | 8 | 0 | 449 | 38.94022054 | -91.47000721 | 2020-12-23 05:22:03 | Montgomery, Missouri, US |
929034 | 929034 | 2020-12-21 | US | Kansas | Stevens | 20189 | 454 | 5 | 0 | 449 | 37.1923008 | -101.3118967 | 2020-12-22 05:22:33 | Stevens, Kansas, US |
929618 | 929618 | 2020-12-21 | US | Missouri | Montgomery | 29139 | 455 | 6 | 0 | 449 | 38.94022054 | -91.47000721 | 2020-12-22 05:22:33 | Montgomery, Missouri, US |
930553 | 930553 | 2020-12-21 | US | South Dakota | Gregory | 46053 | 475 | 26 | 0 | 449 | 43.19419064 | -99.18883902 | 2020-12-22 05:22:33 | Gregory, South Dakota, US |
2933948 | 2933948 | 2020-12-19 | US | Puerto Rico | Fajardo | 72053 | 449 | 0 | 0 | 449 | 18.318373 | -65.666866 | 2020-12-20 05:27:32 | Fajardo, Puerto Rico, US |
2934613 | 2934613 | 2020-12-19 | US | Virginia | Rockbridge | 51163 | 452 | 3 | 0 | 449 | 37.81204314 | -79.44605905 | 2020-12-20 05:27:32 | Rockbridge, Virginia, US |
1903941 | 1903941 | 2020-12-18 | US | Puerto Rico | Utuado | 72141 | 449 | 0 | 0 | 449 | 18.271214 | -66.702984 | 2020-12-19 05:27:52 | Utuado, Puerto Rico, US |
2128826 | 2128826 | 2020-12-17 | US | Georgia | McIntosh | 13191 | 458 | 9 | 0 | 449 | 31.49683595 | -81.40163426 | 2020-12-18 05:28:18 | McIntosh, Georgia, 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]);