daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where active = 3045 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 24
country_or_region 1
- US · 37 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-02-24 | US | Missouri | Platte | 29165 | 3087 | 42 | 0 | 3045 | 39.38154439 | -94.77068479 | 2021-02-25 05:24:57 | Platte, Missouri, US |
2021-02-13 | US | Wisconsin | Green | 55045 | 3067 | 22 | 0 | 3045 | 42.6794956 | -89.60243287 | 2021-02-14 05:23:43 | Green, Wisconsin, US |
2021-02-11 | US | Ohio | Ottawa | 39123 | 3119 | 74 | 0 | 3045 | 41.53781826 | -83.0940185 | 2021-02-12 05:23:29 | Ottawa, Ohio, US |
2021-02-08 | US | New York | Columbia | 36021 | 3135 | 90 | 0 | 3045 | 42.24819348 | -73.63089095 | 2021-02-09 05:23:30 | Columbia, New York, US |
2021-02-07 | US | Colorado | Montrose | 8085 | 3249 | 55 | 0 | 3045 | 38.40214114 | -108.26390220000002 | 2021-02-08 05:22:39 | Montrose, Colorado, US |
2021-02-07 | US | North Carolina | Jackson | 37099 | 3091 | 46 | 0 | 3045 | 35.28814273 | -83.14093385 | 2021-02-08 05:22:39 | Jackson, North Carolina, US |
2021-01-30 | US | Kentucky | Greenup | 21089 | 3068 | 23 | 0 | 3045 | 38.54332505 | -82.9215658 | 2021-01-31 05:22:42 | Greenup, Kentucky, US |
2021-01-29 | US | Illinois | Christian | 17021 | 3106 | 61 | 0 | 3045 | 39.54581621 | -89.27780482 | 2021-01-30 05:22:49 | Christian, Illinois, US |
2021-01-22 | US | Alaska | Bethel | 2050 | 3059 | 14 | 0 | 3045 | 60.90980451 | -159.8561831 | 2021-01-23 05:22:03 | Bethel, Alaska, US |
2021-01-18 | US | Tennessee | Carroll | 47017 | 3162 | 59 | 0 | 3045 | 35.97366108 | -88.45189331 | 2021-01-19 05:22:15 | Carroll, Tennessee, US |
2021-01-17 | US | Indiana | Miami | 18103 | 3098 | 53 | 0 | 3045 | 40.76940965 | -86.04525048 | 2021-01-18 05:22:34 | Miami, Indiana, US |
2021-01-17 | US | Ohio | Crawford | 39033 | 3132 | 87 | 0 | 3045 | 40.85065156 | -82.91989099 | 2021-01-18 05:22:34 | Crawford, Ohio, US |
2021-01-11 | US | Virginia | Henry | 51089 | 3105 | 60 | 0 | 3045 | 36.68542395 | -79.87634026 | 2021-01-12 05:22:15 | Henry, Virginia, US |
2021-01-09 | US | Alabama | Russell | 1113 | 3052 | 7 | 0 | 3045 | 32.28725256 | -85.18415324 | 2021-01-10 05:22:12 | Russell, Alabama, US |
2021-01-08 | US | Michigan | Montcalm | 26117 | 3116 | 71 | 0 | 3045 | 43.31082541 | -85.15252824 | 2021-01-09 05:22:18 | Montcalm, Michigan, US |
2021-01-07 | US | Illinois | Morgan | 17137 | 3111 | 66 | 0 | 3045 | 39.71654544 | -90.20255104 | 2021-01-08 05:22:42 | Morgan, Illinois, US |
2021-01-02 | US | Florida | Unassigned | 90012 | 3045 | 0 | 0 | 3045 | 30.86747479 | 0.0 | 2021-01-03 05:22:52 | Unassigned, Florida, US |
2021-01-02 | US | Kentucky | Shelby | 21211 | 3074 | 29 | 0 | 3045 | 38.21476019 | -85.194223 | 2021-01-03 05:22:52 | Shelby, Kentucky, US |
2020-12-10 | US | Kansas | Saline | 20169 | 3087 | 42 | 0 | 3045 | 38.78369175 | -97.65185177 | 2020-12-11 05:26:59 | Saline, Kansas, US |
2020-12-09 | US | Kansas | Saline | 20169 | 3087 | 42 | 0 | 3045 | 38.78369175 | -97.65185177 | 2020-12-10 05:26:19 | Saline, Kansas, US |
2020-12-08 | US | Alabama | Autauga | 1001 | 3087 | 42 | 0 | 3045 | 32.53952745 | -86.64408227 | 2020-12-09 05:28:01 | Autauga, Alabama, US |
2020-12-06 | US | Oklahoma | Wagoner | 40145 | 3083 | 38 | 0 | 3045 | 35.96024096 | -95.51911308 | 2020-12-07 05:26:14 | Wagoner, Oklahoma, US |
2020-11-23 | US | Virginia | Portsmouth | 51740 | 3115 | 70 | 0 | 3045 | 36.85914825 | -76.35971629 | 2020-11-24 05:27:31 | Portsmouth, Virginia, US |
2020-11-08 | US | Alabama | Walker | 1127 | 3141 | 96 | 0 | 3045 | 33.80270512 | -87.30027177 | 2020-11-09 05:25:45 | Walker, Alabama, US |
2020-10-24 | US | Georgia | Paulding | 13223 | 3105 | 60 | 0 | 3045 | 33.91969522 | -84.86848792 | 2020-10-25 04:24:36 | Paulding, Georgia, US |
2020-10-14 | US | Pennsylvania | Westmoreland | 42129 | 3109 | 64 | 0 | 3045 | 40.31377979999999 | -79.46615476 | 2020-10-15 04:24:28 | Westmoreland, Pennsylvania, US |
2020-10-07 | US | South Carolina | Orangeburg | 45075 | 3172 | 127 | 0 | 3045 | 33.4391073 | -80.79886287 | 2020-10-08 04:23:56 | Orangeburg, South Carolina, US |
2020-09-27 | US | Ohio | Warren | 39165 | 3096 | 51 | 0 | 3045 | 39.42581994 | -84.16557457 | 2020-09-28 04:23:00 | Warren, Ohio, US |
2020-09-27 | US | Wisconsin | La Crosse | 55063 | 3047 | 2 | 0 | 3045 | 43.90632465 | -91.11451093 | 2020-09-28 04:23:00 | La Crosse, Wisconsin, US |
2020-09-20 | US | South Carolina | Sumter | 45085 | 3122 | 77 | 0 | 3045 | 33.91826534 | -80.37942316 | 2020-09-21 04:23:00 | Sumter, South Carolina, US |
2020-09-06 | US | Louisiana | St. Landry | 22097 | 3161 | 116 | 0 | 3045 | 30.59724262 | -92.00135806 | 2020-09-07 04:28:30 | St. Landry, Louisiana, US |
2020-08-18 | US | Florida | Columbia | 12023 | 3071 | 26 | 0 | 3045 | 30.22509788 | -82.62160164 | 2020-08-19 04:27:00 | Columbia, Florida, US |
2020-07-08 | US | Wisconsin | Brown | 55009 | 3087 | 42 | 0 | 3045 | 44.4526553 | -88.00411844 | 2020-07-09 04:34:23 | Brown, Wisconsin, US |
2020-07-02 | US | New Hampshire | Hillsborough | 33011 | 3295 | 250 | 0 | 3045 | 42.91537785 | -71.7200253 | 2020-07-03 04:33:54 | Hillsborough, New Hampshire, US |
2020-07-02 | US | Florida | Manatee | 12081 | 3175 | 130 | 0 | 3045 | 27.47196942 | -82.31831044 | 2020-07-03 04:33:54 | Manatee, Florida, US |
2020-05-19 | US | Iowa | Polk | 19153 | 3128 | 83 | 0 | 3045 | 41.68679484 | -93.57767461 | 2020-05-20 02:32:19 | Polk, Iowa, US |
2020-05-09 | US | Maryland | Baltimore City | 24510 | 3208 | 163 | 0 | 3045 | 39.30211911 | -76.61151012 | 2020-05-10 02:32:30 | Baltimore City, Maryland, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;