daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where confirmed = 12199 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-13 | US | Puerto Rico | Canovanas | 72029 | 12199 | 0 | 0 | 18.328802 | -65.887612 | 2022-12-14 04:21:04 | Canovanas, Puerto Rico, US | |
2022-12-07 | US | Tennessee | Marshall | 47117 | 12199 | 131 | 0 | 35.45798777 | -86.76420988 | 2022-12-08 04:21:07 | Marshall, Tennessee, US | |
2022-10-30 | US | Puerto Rico | San Sebastian | 72131 | 12199 | 0 | 0 | 18.328646 | -66.971214 | 2022-10-31 04:21:36 | San Sebastian, Puerto Rico, US | |
2022-09-11 | US | Virginia | York | 51199 | 12199 | 117 | 0 | 37.24374789 | -76.54412815 | 2022-09-12 04:20:58 | York, Virginia, US | |
2022-09-10 | US | Virginia | York | 51199 | 12199 | 117 | 0 | 37.24374789 | -76.54412815 | 2022-09-11 04:20:50 | York, Virginia, US | |
2022-09-09 | US | Virginia | York | 51199 | 12199 | 117 | 0 | 37.24374789 | -76.54412815 | 2022-09-10 04:21:10 | York, Virginia, US | |
2022-06-11 | US | Texas | Hardin | 48199 | 12199 | 251 | 0 | 30.33364686 | -94.38931817 | 2022-06-12 04:20:53 | Hardin, Texas, US | |
2022-04-28 | US | New York | Montgomery | 36057 | 12199 | 204 | 0 | 42.90123494 | -74.44011632 | 2022-04-29 04:20:59 | Montgomery, New York, US | |
2022-03-08 | US | Wisconsin | Polk | 55095 | 12199 | 119 | 0 | 45.46130348 | -92.44182875 | 2022-03-09 04:20:59 | Polk, Wisconsin, US | |
2022-02-22 | US | New York | Fulton | 36035 | 12199 | 165 | 0 | 43.11363907 | -74.41798804 | 2022-02-23 04:21:09 | Fulton, New York, US | |
2022-02-21 | US | Ohio | Washington | 39167 | 12199 | 205 | 0 | 39.45690571 | -81.49121382 | 2022-02-22 04:21:01 | Washington, Ohio, US | |
2021-12-06 | US | Virginia | Lynchburg | 51680 | 12199 | 195 | 0 | 37.40021399 | -79.19888138 | 2021-12-07 04:22:34 | Lynchburg, Virginia, US | |
2021-12-01 | US | North Carolina | Stanly | 37167 | 12199 | 198 | 0 | 35.31647813 | -80.25093221 | 2021-12-02 04:22:37 | Stanly, North Carolina, US | |
2021-11-29 | US | Texas | Starr | 48427 | 12199 | 333 | 0 | 26.56150059 | -98.73892358 | 2021-11-30 04:22:53 | Starr, Texas, US | |
2021-11-21 | US | Mississippi | Lauderdale | 28075 | 12199 | 324 | 0 | 32.40419769 | -88.66229662 | 2021-11-22 04:22:20 | Lauderdale, Mississippi, US | |
2021-11-20 | US | Mississippi | Lauderdale | 28075 | 12199 | 324 | 0 | 32.40419769 | -88.66229662 | 2021-11-21 04:22:13 | Lauderdale, Mississippi, US | |
2021-11-19 | US | Mississippi | Lauderdale | 28075 | 12199 | 324 | 0 | 32.40419769 | -88.66229662 | 2021-11-20 04:22:17 | Lauderdale, Mississippi, US | |
2021-11-17 | US | Pennsylvania | Crawford | 42039 | 12199 | 204 | 0 | 41.68447709 | -80.10760592 | 2021-11-18 04:21:33 | Crawford, Pennsylvania, US | |
2021-10-15 | US | New York | Chautauqua | 36013 | 12199 | 171 | 0 | 42.22769210000001 | -79.36691763 | 2021-10-16 04:21:15 | Chautauqua, New York, US | |
2021-09-26 | US | Alabama | DeKalb | 1049 | 12199 | 237 | 0 | 34.45946862 | -85.80782906 | 2021-09-27 04:21:16 | DeKalb, Alabama, US | |
2021-06-28 | France | Martinique | 12199 | 99 | 98 | 12002 | 14.6415 | -61.0242 | 2021-06-29 04:21:28 | Martinique, France | ||
2021-06-27 | US | Arizona | Cochise | 4003 | 12199 | 293 | 0 | 31.87934684 | -109.7516088 | 2021-06-28 04:21:29 | Cochise, Arizona, US | |
2021-06-27 | France | Martinique | 12199 | 99 | 98 | 12002 | 14.6415 | -61.0242 | 2021-06-28 04:21:29 | Martinique, France | ||
2021-06-26 | France | Martinique | 12199 | 99 | 98 | 12002 | 14.6415 | -61.0242 | 2021-06-27 04:21:39 | Martinique, France | ||
2021-06-25 | France | Martinique | 12199 | 99 | 98 | 12002 | 14.6415 | -61.0242 | 2021-06-26 04:21:43 | Martinique, France | ||
2021-06-24 | France | Martinique | 12199 | 99 | 98 | 12002 | 14.6415 | -61.0242 | 2021-06-25 04:21:33 | Martinique, France | ||
2021-06-23 | France | Martinique | 12199 | 99 | 98 | 12002 | 14.6415 | -61.0242 | 2021-06-24 04:21:55 | Martinique, France | ||
2021-06-22 | France | Martinique | 12199 | 99 | 98 | 12002 | 14.6415 | -61.0242 | 2021-06-23 04:21:46 | Martinique, France | ||
2021-06-21 | France | Martinique | 12199 | 99 | 98 | 12002 | 14.6415 | -61.0242 | 2021-06-22 04:21:34 | Martinique, France | ||
2021-06-14 | Bahamas | 12199 | 237 | 11136 | 826 | 25.025885 | -78.035889 | 2021-06-15 04:22:22 | Bahamas | |||
2021-04-15 | US | Illinois | Kendall | 17093 | 12199 | 90 | 0 | 41.59081014 | -88.42869583 | 2021-04-16 04:20:46 | Kendall, Illinois, US | |
2021-03-14 | US | Indiana | Clark | 18019 | 12199 | 183 | 0 | 38.48015445 | -85.70510334 | 2021-03-15 05:25:51 | Clark, Indiana, US | |
2021-02-27 | India | Nagaland | 12199 | 91 | 12098 | 10 | 26.06702 | 94.470302 | 2021-02-28 05:22:20 | Nagaland, India | ||
2021-02-25 | US | Tennessee | Maury | 47119 | 12199 | 160 | 0 | 11998 | 35.6187413 | -87.07462444 | 2021-02-26 05:22:40 | Maury, Tennessee, US |
2021-01-02 | US | New York | Albany | 36001 | 12199 | 208 | 0 | 11991 | 42.60060306 | -73.97723916 | 2021-01-03 05:22:52 | Albany, New York, US |
2020-12-20 | US | Illinois | Peoria | 17143 | 12199 | 171 | 0 | 12028 | 40.78702156 | -89.76078901 | 2020-12-21 05:27:58 | Peoria, Illinois, US |
2020-12-06 | US | South Carolina | Lexington | 45063 | 12199 | 236 | 0 | 11963 | 33.89665987 | -81.27146426 | 2020-12-07 05:26:14 | Lexington, South Carolina, US |
2020-11-20 | US | Michigan | Genesee | 26049 | 12199 | 393 | 0 | 11806 | 43.02244215 | -83.70589709 | 2020-11-21 05:25:51 | Genesee, Michigan, US |
2020-11-15 | Russia | Tver Oblast | 12199 | 351 | 7134 | 4714 | 57.1134475 | 35.174442799999994 | 2020-11-16 05:25:57 | Tver Oblast, Russia | ||
2020-11-12 | US | Florida | Pasco | 12101 | 12199 | 251 | 0 | 11948 | 28.30810945 | -82.40227529 | 2020-11-13 05:25:30 | Pasco, Florida, US |
2020-11-10 | US | Washington | Pierce | 53053 | 12199 | 240 | 0 | 11959 | 47.03892768 | -122.1405958 | 2020-11-11 05:25:30 | Pierce, Washington, US |
2020-10-01 | US | New York | Orange | 36071 | 12199 | 498 | 0 | 11701 | 41.40337468 | -74.30240757 | 2020-10-02 04:23:51 | Orange, New York, US |
2020-08-04 | Germany | Hessen | 12199 | 521 | 11038 | 640 | 50.6521 | 9.1624 | 2020-08-05 04:34:43 | Hessen, Germany |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;