johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
132 rows where active = 1315 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 13
- Georgia 11
- North Carolina 8
- Arkansas 6
- Kentucky 6
- Minnesota 6
- Missouri 6
- Tennessee 6
- Illinois 5
- Kansas 5
- Ohio 5
- Rhode Island 5
- Wisconsin 5
- Pennsylvania 4
- Alabama 3
- Indiana 3
- Iowa 3
- Oklahoma 3
- Puerto Rico 3
- South Carolina 3
- Virginia 3
- California 2
- Mississippi 2
- Nebraska 2
- New York 2
- Washington 2
- Arizona 1
- Colorado 1
- Florida 1
- Louisiana 1
- …
country_or_region 1
- US · 132 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1092171 | 1092171 | 2021-03-03 | US | Nebraska | Otoe | 31131 | 1322 | 7 | 0 | 1315 | 40.64843556 | -96.13374142 | 2021-03-04 05:24:24 | Otoe, Nebraska, US |
3256477 | 3256477 | 2021-03-02 | US | North Carolina | Madison | 37115 | 1352 | 37 | 0 | 1315 | 35.85402722 | -82.71346418 | 2021-03-03 05:23:28 | Madison, North Carolina, US |
2369722 | 2369722 | 2021-02-28 | US | New York | Essex | 36031 | 1341 | 26 | 0 | 1315 | 44.11630765 | -73.77297842 | 2021-03-01 05:23:01 | Essex, New York, US |
3069521 | 3069521 | 2021-02-27 | US | Wisconsin | Burnett | 55013 | 1338 | 23 | 0 | 1315 | 45.86303537 | -92.36711412 | 2021-02-28 05:22:20 | Burnett, Wisconsin, US |
2186621 | 2186621 | 2021-02-26 | US | Texas | Childress | 48075 | 1451 | 16 | 0 | 1315 | 34.529304100000004 | -100.2077916 | 2021-02-27 05:22:28 | Childress, Texas, US |
1858744 | 1858744 | 2021-02-25 | US | Georgia | Bacon | 13005 | 1349 | 34 | 0 | 1315 | 31.55456473 | -82.45936528 | 2021-02-26 05:22:40 | Bacon, Georgia, US |
1859295 | 1859295 | 2021-02-25 | US | Kansas | Jackson | 20085 | 1329 | 14 | 0 | 1315 | 39.41673394 | -95.79356799 | 2021-02-26 05:22:40 | Jackson, Kansas, US |
281473 | 281473 | 2021-02-24 | US | Kansas | Jackson | 20085 | 1329 | 14 | 0 | 1315 | 39.41673394 | -95.79356799 | 2021-02-25 05:24:57 | Jackson, Kansas, US |
281885 | 281885 | 2021-02-24 | US | Minnesota | Cottonwood | 27033 | 1335 | 20 | 0 | 1315 | 44.00715262 | -95.18138802 | 2021-02-25 05:24:57 | Cottonwood, Minnesota, US |
1937832 | 1937832 | 2021-02-23 | US | Kentucky | Clinton | 21053 | 1341 | 26 | 0 | 1315 | 36.72581156 | -85.13377529 | 2021-02-24 05:29:16 | Clinton, Kentucky, US |
474898 | 474898 | 2021-02-19 | US | West Virginia | McDowell | 54047 | 1334 | 19 | 0 | 1315 | 37.38002939 | -81.65083669 | 2021-02-20 05:22:51 | McDowell, West Virginia, US |
3051873 | 3051873 | 2021-02-16 | US | Minnesota | Chippewa | 27023 | 1350 | 35 | 0 | 1315 | 45.02343421 | -95.56403693 | 2021-02-17 05:23:10 | Chippewa, Minnesota, US |
1339972 | 1339972 | 2021-02-15 | US | Minnesota | Chippewa | 27023 | 1350 | 35 | 0 | 1315 | 45.02343421 | -95.56403693 | 2021-02-16 05:24:38 | Chippewa, Minnesota, US |
2678671 | 2678671 | 2021-02-13 | US | Georgia | Oglethorpe | 13221 | 1337 | 22 | 0 | 1315 | 33.878629600000004 | -83.08278123 | 2021-02-14 05:23:43 | Oglethorpe, Georgia, US |
3540304 | 3540304 | 2021-02-12 | US | Georgia | Oglethorpe | 13221 | 1337 | 22 | 0 | 1315 | 33.878629600000004 | -83.08278123 | 2021-02-13 05:22:12 | Oglethorpe, Georgia, US |
2638567 | 2638567 | 2021-02-11 | US | Georgia | Oglethorpe | 13221 | 1336 | 21 | 0 | 1315 | 33.878629600000004 | -83.08278123 | 2021-02-12 05:23:29 | Oglethorpe, Georgia, US |
2640486 | 2640486 | 2021-02-11 | US | Puerto Rico | Rio Grande | 72119 | 1315 | 0 | 0 | 1315 | 18.346329 | -65.813742 | 2021-02-12 05:23:29 | Rio Grande, Puerto Rico, US |
2641072 | 2641072 | 2021-02-11 | US | Virginia | King George | 51099 | 1326 | 11 | 0 | 1315 | 38.26818502 | -77.15852768 | 2021-02-12 05:23:29 | King George, Virginia, US |
3981967 | 3981967 | 2021-02-10 | US | Virginia | Richmond | 51159 | 1323 | 8 | 0 | 1315 | 37.937575 | -76.72920628 | 2021-02-11 05:23:55 | Richmond, Virginia, US |
1528645 | 1528645 | 2021-02-09 | US | Georgia | Bleckley | 13023 | 1359 | 44 | 0 | 1315 | 32.43829035 | -83.33035166 | 2021-02-10 05:22:41 | Bleckley, Georgia, US |
1531418 | 1531418 | 2021-02-09 | US | Wisconsin | Buffalo | 55011 | 1322 | 7 | 0 | 1315 | 44.37835084 | -91.75332578 | 2021-02-10 05:22:41 | Buffalo, Wisconsin, US |
614669 | 614669 | 2021-02-08 | US | Illinois | Greene | 17061 | 1345 | 30 | 0 | 1315 | 39.35907414 | -90.388865 | 2021-02-09 05:23:30 | Greene, Illinois, US |
617209 | 617209 | 2021-02-08 | US | Wisconsin | Buffalo | 55011 | 1322 | 7 | 0 | 1315 | 44.37835084 | -91.75332578 | 2021-02-09 05:23:30 | Buffalo, Wisconsin, US |
1673652 | 1673652 | 2021-02-07 | US | Iowa | Iowa | 19095 | 1338 | 23 | 0 | 1315 | 41.68630265 | -92.0643373 | 2021-02-08 05:22:39 | Iowa, Iowa, US |
1687162 | 1687162 | 2021-02-02 | US | Pennsylvania | Forest | 42053 | 1332 | 17 | 0 | 1315 | 41.51095103 | -79.23229292 | 2021-02-03 05:22:52 | Forest, Pennsylvania, US |
1687618 | 1687618 | 2021-02-02 | US | Texas | Hutchinson | 48233 | 2406 | 62 | 0 | 1315 | 35.84006574 | -101.3546643 | 2021-02-03 05:22:52 | Hutchinson, Texas, US |
2212163 | 2212163 | 2021-01-30 | US | Arkansas | Madison | 5087 | 1333 | 18 | 0 | 1315 | 36.01038185 | -93.72524943 | 2021-01-31 05:22:42 | Madison, Arkansas, US |
1899072 | 1899072 | 2021-01-29 | US | Missouri | Madison | 29123 | 1328 | 13 | 0 | 1315 | 37.47865134 | -90.3467143 | 2021-01-30 05:22:49 | Madison, Missouri, US |
1899889 | 1899889 | 2021-01-29 | US | Puerto Rico | Gurabo | 72063 | 1315 | 0 | 0 | 1315 | 18.266461 | -65.97970500000001 | 2021-01-30 05:22:49 | Gurabo, Puerto Rico, US |
3156815 | 3156815 | 2021-01-27 | US | Texas | Shelby | 48419 | 1445 | 47 | 0 | 1315 | 31.79211404 | -94.14550696 | 2021-01-28 05:22:24 | Shelby, Texas, US |
2468738 | 2468738 | 2021-01-22 | US | Missouri | Osage | 29151 | 1324 | 9 | 0 | 1315 | 38.46036182 | -91.8613635 | 2021-01-23 05:22:03 | Osage, Missouri, US |
437723 | 437723 | 2021-01-21 | US | North Carolina | Warren | 37185 | 1327 | 12 | 0 | 1315 | 36.39728256 | -78.10652228 | 2021-01-22 05:22:10 | Warren, North Carolina, US |
1095313 | 1095313 | 2021-01-20 | US | Iowa | Poweshiek | 19157 | 1339 | 24 | 0 | 1315 | 41.68625425 | -92.53155731 | 2021-01-21 05:22:01 | Poweshiek, Iowa, US |
1095521 | 1095521 | 2021-01-20 | US | Kentucky | McCreary | 21147 | 1324 | 9 | 0 | 1315 | 36.73874143 | -84.48102924 | 2021-01-21 05:22:01 | McCreary, Kentucky, US |
240494 | 240494 | 2021-01-18 | US | Texas | Zapata | 48505 | 1573 | 20 | 0 | 1315 | 27.00156391 | -99.16987152 | 2021-01-19 05:22:15 | Zapata, Texas, US |
3506611 | 3506611 | 2021-01-17 | US | Texas | Zapata | 48505 | 1573 | 20 | 0 | 1315 | 27.00156391 | -99.16987152 | 2021-01-18 05:22:34 | Zapata, Texas, US |
3506734 | 3506734 | 2021-01-17 | US | Virginia | Page | 51139 | 1351 | 36 | 0 | 1315 | 38.61807452 | -78.48797204 | 2021-01-18 05:22:34 | Page, Virginia, US |
3518383 | 3518383 | 2021-01-15 | US | Tennessee | Sequatchie | 47153 | 1299 | 18 | 0 | 1315 | 35.36979721 | -85.41022136 | 2021-01-16 05:22:40 | Sequatchie, Tennessee, US |
3880094 | 3880094 | 2021-01-14 | US | Arkansas | Sharp | 5135 | 1353 | 38 | 0 | 1315 | 36.16258158 | -91.47819342 | 2021-01-15 05:22:24 | Sharp, Arkansas, US |
776096 | 776096 | 2021-01-12 | US | Minnesota | Renville | 27129 | 1354 | 39 | 0 | 1315 | 44.72836381 | -94.94553734 | 2021-01-13 05:22:15 | Renville, Minnesota, US |
191423 | 191423 | 2021-01-11 | US | Kentucky | Allen | 21003 | 1334 | 19 | 0 | 1315 | 36.75197631 | -86.19457544 | 2021-01-12 05:22:15 | Allen, Kentucky, US |
2627121 | 2627121 | 2021-01-10 | US | Kansas | Atchison | 20005 | 1325 | 10 | 0 | 1315 | 39.53185661 | -95.30870026 | 2021-01-11 05:21:50 | Atchison, Kansas, US |
2627306 | 2627306 | 2021-01-10 | US | Kentucky | Meade | 21163 | 1319 | 4 | 0 | 1315 | 37.96163597 | -86.21028219 | 2021-01-11 05:21:50 | Meade, Kentucky, US |
3901037 | 3901037 | 2021-01-09 | US | Indiana | Franklin | 18047 | 1346 | 31 | 0 | 1315 | 39.4142482 | -85.06062647 | 2021-01-10 05:22:12 | Franklin, Indiana, US |
3901209 | 3901209 | 2021-01-09 | US | Kansas | Atchison | 20005 | 1325 | 10 | 0 | 1315 | 39.53185661 | -95.30870026 | 2021-01-10 05:22:12 | Atchison, Kansas, US |
3903105 | 3903105 | 2021-01-09 | US | Texas | Limestone | 48293 | 1533 | 32 | 0 | 1315 | 31.5454767 | -96.58095444 | 2021-01-10 05:22:12 | Limestone, Texas, US |
155232 | 155232 | 2021-01-08 | US | Kansas | Atchison | 20005 | 1325 | 10 | 0 | 1315 | 39.53185661 | -95.30870026 | 2021-01-09 05:22:18 | Atchison, Kansas, US |
157056 | 157056 | 2021-01-08 | US | Texas | Fayette | 48149 | 1421 | 39 | 0 | 1315 | 29.87788372 | -96.92076062 | 2021-01-09 05:22:18 | Fayette, Texas, US |
3035075 | 3035075 | 2021-01-05 | US | Georgia | Cook | 13075 | 1340 | 25 | 0 | 1315 | 31.16068491 | -83.42947229 | 2021-01-06 05:22:16 | Cook, Georgia, US |
1062664 | 1062664 | 2021-01-04 | US | Georgia | Jefferson | 13163 | 1355 | 40 | 0 | 1315 | 33.05867328 | -82.41609057 | 2021-01-05 05:21:49 | Jefferson, Georgia, US |
3231434 | 3231434 | 2021-01-03 | US | Illinois | Hancock | 17067 | 1335 | 20 | 0 | 1315 | 40.40423981 | -91.16313899 | 2021-01-04 05:22:02 | Hancock, Illinois, US |
2228550 | 2228550 | 2021-01-02 | US | Illinois | Richland | 17159 | 1346 | 31 | 0 | 1315 | 38.71240969 | -88.08475366 | 2021-01-03 05:22:52 | Richland, Illinois, US |
1139806 | 1139806 | 2021-01-01 | US | Tennessee | Decatur | 47039 | 1364 | 20 | 0 | 1315 | 35.60048904 | -88.11043779 | 2021-01-02 05:22:33 | Decatur, Tennessee, US |
3698412 | 3698412 | 2020-12-31 | US | Tennessee | Decatur | 47039 | 1358 | 20 | 0 | 1315 | 35.60048904 | -88.11043779 | 2021-01-01 05:23:07 | Decatur, Tennessee, US |
1012582 | 1012582 | 2020-12-30 | US | North Carolina | Avery | 37011 | 1330 | 15 | 0 | 1315 | 36.07569796 | -81.92308483 | 2020-12-31 05:22:49 | Avery, North Carolina, US |
1012769 | 1012769 | 2020-12-30 | US | Ohio | Hocking | 39073 | 1358 | 43 | 0 | 1315 | 39.49537927 | -82.47991446 | 2020-12-31 05:22:49 | Hocking, Ohio, US |
205802 | 205802 | 2020-12-25 | US | Wisconsin | Lafayette | 55065 | 1321 | 6 | 0 | 1315 | 42.66005229 | -90.1317729 | 2020-12-26 05:22:28 | Lafayette, Wisconsin, US |
1901627 | 1901627 | 2020-12-18 | US | Arkansas | Chicot | 5017 | 1344 | 29 | 0 | 1315 | 33.26458973 | -91.29539209 | 2020-12-19 05:27:52 | Chicot, Arkansas, US |
1903063 | 1903063 | 2020-12-18 | US | Missouri | Henry | 29083 | 1333 | 18 | 0 | 1315 | 38.38482826 | -93.79293734 | 2020-12-19 05:27:52 | Henry, Missouri, US |
1903181 | 1903181 | 2020-12-18 | US | Montana | Roosevelt | 30085 | 1357 | 42 | 0 | 1315 | 48.29607488 | -105.0079268 | 2020-12-19 05:27:52 | Roosevelt, Montana, US |
2130825 | 2130825 | 2020-12-17 | US | South Carolina | Union | 45087 | 1350 | 35 | 0 | 1315 | 34.68835752 | -81.61730349 | 2020-12-18 05:28:18 | Union, South Carolina, US |
3150346 | 3150346 | 2020-12-16 | US | Georgia | Butts | 13035 | 1362 | 47 | 0 | 1315 | 33.283094500000004 | -83.95435040000002 | 2020-12-17 05:28:12 | Butts, Georgia, US |
3152650 | 3152650 | 2020-12-16 | US | Texas | DeWitt | 48123 | 1157 | 46 | 0 | 1315 | 29.08101855 | -97.3568117 | 2020-12-17 05:28:12 | DeWitt, Texas, US |
1034864 | 1034864 | 2020-12-15 | US | Arkansas | Lee | 5077 | 1335 | 20 | 0 | 1315 | 34.78498904 | -90.78383866 | 2020-12-16 05:28:04 | Lee, Arkansas, US |
3849669 | 3849669 | 2020-12-13 | US | Missouri | Cooper | 29053 | 1325 | 10 | 0 | 1315 | 38.844478 | -92.80896081 | 2020-12-14 05:26:27 | Cooper, Missouri, US |
3850050 | 3850050 | 2020-12-13 | US | New York | Tioga | 36107 | 1367 | 52 | 0 | 1315 | 42.16852837 | -76.30835812 | 2020-12-14 05:26:27 | Tioga, New York, US |
863168 | 863168 | 2020-12-11 | US | Ohio | Perry | 39127 | 1340 | 25 | 0 | 1315 | 39.73508655 | -82.23804971 | 2020-12-12 05:26:19 | Perry, Ohio, US |
863582 | 863582 | 2020-12-11 | US | Tennessee | Bledsoe | 47007 | 1337 | 6 | 0 | 1315 | 35.59942968 | -85.20611967 | 2020-12-12 05:26:19 | Bledsoe, Tennessee, US |
2349152 | 2349152 | 2020-12-07 | US | Minnesota | Martin | 27091 | 1338 | 23 | 0 | 1315 | 43.67429718 | -94.55099908 | 2020-12-08 05:27:42 | Martin, Minnesota, US |
1008757 | 1008757 | 2020-12-06 | US | Ohio | Highland | 39071 | 1342 | 27 | 0 | 1315 | 39.1839264 | -83.60331456 | 2020-12-07 05:26:14 | Highland, Ohio, US |
739419 | 739419 | 2020-12-02 | US | Indiana | Posey | 18129 | 1336 | 21 | 0 | 1315 | 38.02097333 | -87.86480429 | 2020-12-03 05:28:22 | Posey, Indiana, US |
3568080 | 3568080 | 2020-11-29 | US | Louisiana | Pointe Coupee | 22077 | 1364 | 49 | 0 | 1315 | 30.71409502 | -91.60209535 | 2020-11-30 05:26:13 | Pointe Coupee, Louisiana, US |
3570008 | 3570008 | 2020-11-29 | US | Washington | Okanogan | 53047 | 1337 | 22 | 0 | 1315 | 48.54855019 | -119.7387224 | 2020-11-30 05:26:13 | Okanogan, Washington, US |
2937512 | 2937512 | 2020-11-28 | US | North Carolina | Bladen | 37017 | 1334 | 19 | 0 | 1315 | 34.61296243 | -78.56180059 | 2020-11-29 05:25:55 | Bladen, North Carolina, US |
924718 | 924718 | 2020-11-26 | US | Illinois | Shelby | 17173 | 1338 | 23 | 0 | 1315 | 39.39133527 | -88.80611122 | 2020-11-27 05:26:53 | Shelby, Illinois, US |
1976005 | 1976005 | 2020-11-25 | US | Washington | Adams | 53001 | 1327 | 12 | 0 | 1315 | 46.98299757 | -118.5601734 | 2020-11-26 05:27:44 | Adams, Washington, US |
1352876 | 1352876 | 2020-11-24 | US | Oklahoma | Logan | 40083 | 1318 | 3 | 0 | 1315 | 35.91899576 | -97.44352845 | 2020-11-25 05:27:20 | Logan, Oklahoma, US |
824111 | 824111 | 2020-11-19 | US | Oklahoma | Garvin | 40049 | 1325 | 10 | 0 | 1315 | 34.70418038 | -97.30811132 | 2020-11-20 05:26:28 | Garvin, Oklahoma, US |
124733 | 124733 | 2020-11-18 | US | Nebraska | Adams | 31001 | 1336 | 21 | 0 | 1315 | 40.52449420000001 | -98.50117804 | 2020-11-19 05:25:23 | Adams, Nebraska, US |
125474 | 125474 | 2020-11-18 | US | Puerto Rico | Toa Alta | 72135 | 1315 | 0 | 0 | 1315 | 18.362406 | -66.246616 | 2020-11-19 05:25:23 | Toa Alta, Puerto Rico, US |
3172778 | 3172778 | 2020-11-16 | US | Texas | Lavaca | 48285 | 1229 | 39 | 0 | 1315 | 29.38508402 | -96.93186692 | 2020-11-17 05:25:54 | Lavaca, Texas, US |
2883346 | 2883346 | 2020-11-15 | US | Texas | Lavaca | 48285 | 1218 | 39 | 0 | 1315 | 29.38508402 | -96.93186692 | 2020-11-16 05:25:57 | Lavaca, Texas, US |
2916065 | 2916065 | 2020-11-14 | US | Georgia | Upson | 13293 | 1392 | 77 | 0 | 1315 | 32.87920671 | -84.30024826 | 2020-11-15 05:26:53 | Upson, Georgia, US |
2918324 | 2918324 | 2020-11-14 | US | Texas | Lavaca | 48285 | 1212 | 39 | 0 | 1315 | 29.38508402 | -96.93186692 | 2020-11-15 05:26:53 | Lavaca, Texas, US |
2787668 | 2787668 | 2020-11-13 | US | Pennsylvania | Huntingdon | 42061 | 1349 | 34 | 0 | 1315 | 40.42162652 | -77.97673273 | 2020-11-14 05:25:37 | Huntingdon, Pennsylvania, US |
274654 | 274654 | 2020-11-10 | US | Ohio | Scioto | 39145 | 1333 | 18 | 0 | 1315 | 38.80270163 | -82.98907345 | 2020-11-11 05:25:30 | Scioto, Ohio, US |
1992179 | 1992179 | 2020-11-09 | US | Wisconsin | Lincoln | 55069 | 1329 | 14 | 0 | 1315 | 45.33737523 | -89.73411273 | 2020-11-10 05:40:07 | Lincoln, Wisconsin, US |
1729673 | 1729673 | 2020-11-08 | US | Iowa | Henry | 19087 | 1322 | 7 | 0 | 1315 | 40.98767962 | -91.54436349 | 2020-11-09 05:25:45 | Henry, Iowa, US |
1730372 | 1730372 | 2020-11-08 | US | Missouri | Dunklin | 29069 | 1328 | 13 | 0 | 1315 | 36.27167174 | -90.09122243 | 2020-11-09 05:25:45 | Dunklin, Missouri, US |
378081 | 378081 | 2020-11-06 | US | Missouri | Howell | 29091 | 1329 | 14 | 0 | 1315 | 36.77383887 | -91.88683935 | 2020-11-07 05:24:52 | Howell, Missouri, US |
379239 | 379239 | 2020-11-06 | US | Texas | Deaf Smith | 48117 | 1454 | 29 | 0 | 1315 | 34.96522957 | -102.6054267 | 2020-11-07 05:24:52 | Deaf Smith, Texas, US |
3409841 | 3409841 | 2020-11-01 | US | Alabama | Tallapoosa | 1123 | 1402 | 87 | 0 | 1315 | 32.86698258 | -85.79833053 | 2020-11-02 05:25:04 | Tallapoosa, Alabama, US |
211641 | 211641 | 2020-10-29 | US | Kentucky | Henderson | 21101 | 1343 | 28 | 0 | 1315 | 37.79344553 | -87.57392021 | 2020-10-30 04:24:49 | Henderson, Kentucky, US |
1177841 | 1177841 | 2020-10-22 | US | Alabama | Clarke | 1025 | 1332 | 17 | 0 | 1315 | 31.68099859 | -87.83548597 | 2020-10-23 04:24:46 | Clarke, Alabama, US |
1177970 | 1177970 | 2020-10-22 | US | Arkansas | Greene | 5055 | 1331 | 16 | 0 | 1315 | 36.11735460000001 | -90.55832668 | 2020-10-23 04:24:46 | Greene, Arkansas, US |
1180339 | 1180339 | 2020-10-22 | US | South Dakota | Codington | 46029 | 1325 | 10 | 0 | 1315 | 44.97788119 | -97.18827677 | 2020-10-23 04:24:46 | Codington, South Dakota, US |
2192121 | 2192121 | 2020-10-21 | US | Arkansas | White | 5145 | 1347 | 32 | 0 | 1315 | 35.25688493 | -91.74908296 | 2020-10-22 04:24:27 | White, Arkansas, US |
82034 | 82034 | 2020-10-14 | US | Tennessee | Lawrence | 47099 | 1347 | 17 | 0 | 1315 | 35.21675201 | -87.39787695 | 2020-10-15 04:24:28 | Lawrence, Tennessee, US |
3782504 | 3782504 | 2020-10-13 | US | Colorado | Eagle | 8037 | 1380 | 10 | 0 | 1315 | 39.62754308 | -106.6933637 | 2020-10-14 04:24:05 | Eagle, Colorado, US |
2294238 | 2294238 | 2020-10-12 | US | South Carolina | Chesterfield | 45025 | 1353 | 38 | 0 | 1315 | 34.64137396 | -80.15640140000002 | 2020-10-13 04:24:02 | Chesterfield, South Carolina, 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]);