daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,070 rows where deaths = 219 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Virginia | Alexandria | 51510 | 44038 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-30 04:21:04 | Alexandria, Virginia, US | |
2022-12-29 | US | Missouri | Newton | 29145 | 13487 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-30 04:21:04 | Newton, Missouri, US | |
2022-12-29 | US | Michigan | Sanilac | 26151 | 10374 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-30 04:21:04 | Sanilac, Michigan, US | |
2022-12-29 | US | California | Tehama | 6103 | 17524 | 219 | 0 | 40.12570935 | -122.2370171 | 2022-12-30 04:21:04 | Tehama, California, US | |
2022-12-28 | US | Virginia | Alexandria | 51510 | 44038 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-29 04:21:01 | Alexandria, Virginia, US | |
2022-12-28 | US | Missouri | Newton | 29145 | 13487 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-29 04:21:01 | Newton, Missouri, US | |
2022-12-28 | US | Michigan | Sanilac | 26151 | 10374 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-29 04:21:01 | Sanilac, Michigan, US | |
2022-12-27 | US | Virginia | Alexandria | 51510 | 44006 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-28 04:21:04 | Alexandria, Virginia, US | |
2022-12-27 | US | Missouri | Newton | 29145 | 13487 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-28 04:21:04 | Newton, Missouri, US | |
2022-12-27 | US | Michigan | Sanilac | 26151 | 10374 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-28 04:21:04 | Sanilac, Michigan, US | |
2022-12-26 | US | Virginia | Alexandria | 51510 | 43977 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-27 04:21:07 | Alexandria, Virginia, US | |
2022-12-26 | US | Missouri | Newton | 29145 | 13446 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-27 04:21:07 | Newton, Missouri, US | |
2022-12-26 | US | Michigan | Sanilac | 26151 | 10315 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-27 04:21:07 | Sanilac, Michigan, US | |
2022-12-26 | US | Michigan | Hillsdale | 26059 | 12413 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-27 04:21:07 | Hillsdale, Michigan, US | |
2022-12-25 | US | Virginia | Alexandria | 51510 | 43880 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-26 04:21:06 | Alexandria, Virginia, US | |
2022-12-25 | US | Missouri | Newton | 29145 | 13446 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-26 04:21:06 | Newton, Missouri, US | |
2022-12-25 | US | Michigan | Sanilac | 26151 | 10315 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-26 04:21:06 | Sanilac, Michigan, US | |
2022-12-25 | US | Michigan | Hillsdale | 26059 | 12413 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-26 04:21:06 | Hillsdale, Michigan, US | |
2022-12-24 | US | Virginia | Alexandria | 51510 | 43880 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-25 04:21:04 | Alexandria, Virginia, US | |
2022-12-24 | US | Missouri | Newton | 29145 | 13446 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-25 04:21:04 | Newton, Missouri, US | |
2022-12-24 | US | Michigan | Sanilac | 26151 | 10315 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-25 04:21:04 | Sanilac, Michigan, US | |
2022-12-24 | US | Michigan | Hillsdale | 26059 | 12413 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-25 04:21:04 | Hillsdale, Michigan, US | |
2022-12-23 | US | Virginia | Alexandria | 51510 | 43880 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-24 04:21:02 | Alexandria, Virginia, US | |
2022-12-23 | US | Missouri | Newton | 29145 | 13446 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-24 04:21:02 | Newton, Missouri, US | |
2022-12-23 | US | Michigan | Sanilac | 26151 | 10315 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-24 04:21:02 | Sanilac, Michigan, US | |
2022-12-23 | US | Michigan | Hillsdale | 26059 | 12413 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-24 04:21:02 | Hillsdale, Michigan, US | |
2022-12-22 | US | Virginia | Alexandria | 51510 | 43817 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-23 04:21:04 | Alexandria, Virginia, US | |
2022-12-22 | US | Missouri | Newton | 29145 | 13446 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-23 04:21:04 | Newton, Missouri, US | |
2022-12-22 | US | Michigan | Sanilac | 26151 | 10315 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-23 04:21:04 | Sanilac, Michigan, US | |
2022-12-22 | US | Michigan | Hillsdale | 26059 | 12413 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-23 04:21:04 | Hillsdale, Michigan, US | |
2022-12-21 | US | Missouri | Newton | 29145 | 13446 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-22 04:20:56 | Newton, Missouri, US | |
2022-12-21 | US | Michigan | Sanilac | 26151 | 10315 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-22 04:20:56 | Sanilac, Michigan, US | |
2022-12-21 | US | Michigan | Hillsdale | 26059 | 12413 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-22 04:20:56 | Hillsdale, Michigan, US | |
2022-12-20 | US | New Mexico | Otero | 35035 | 16651 | 219 | 0 | 32.61348406 | -105.7417604 | 2022-12-21 04:21:03 | Otero, New Mexico, US | |
2022-12-20 | US | Missouri | Newton | 29145 | 13446 | 219 | 0 | 36.90519407 | -94.3394104 | 2022-12-21 04:21:03 | Newton, Missouri, US | |
2022-12-20 | US | Michigan | Sanilac | 26151 | 10315 | 219 | 0 | 43.42406072 | -82.82055898 | 2022-12-21 04:21:03 | Sanilac, Michigan, US | |
2022-12-20 | US | Michigan | Hillsdale | 26059 | 12413 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-21 04:21:03 | Hillsdale, Michigan, US | |
2022-12-20 | US | Iowa | Wapello | 19179 | 10122 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-21 04:21:03 | Wapello, Iowa, US | |
2022-12-19 | US | New Mexico | Otero | 35035 | 16640 | 219 | 0 | 32.61348406 | -105.7417604 | 2022-12-20 04:21:04 | Otero, New Mexico, US | |
2022-12-19 | US | Michigan | Hillsdale | 26059 | 12353 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-20 04:21:04 | Hillsdale, Michigan, US | |
2022-12-19 | US | Iowa | Wapello | 19179 | 10122 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-20 04:21:04 | Wapello, Iowa, US | |
2022-12-19 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-20 04:21:04 | Iceland | ||||
2022-12-18 | US | Michigan | Hillsdale | 26059 | 12353 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-19 04:21:03 | Hillsdale, Michigan, US | |
2022-12-18 | US | Iowa | Wapello | 19179 | 10122 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-19 04:21:03 | Wapello, Iowa, US | |
2022-12-18 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-19 04:21:03 | Iceland | ||||
2022-12-17 | US | Michigan | Hillsdale | 26059 | 12353 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-18 04:21:03 | Hillsdale, Michigan, US | |
2022-12-17 | US | Iowa | Wapello | 19179 | 10122 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-18 04:21:03 | Wapello, Iowa, US | |
2022-12-17 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-18 04:21:03 | Iceland | ||||
2022-12-16 | US | Michigan | Hillsdale | 26059 | 12353 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-17 04:21:04 | Hillsdale, Michigan, US | |
2022-12-16 | US | Iowa | Wapello | 19179 | 10122 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-17 04:21:04 | Wapello, Iowa, US | |
2022-12-16 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-17 04:21:04 | Iceland | ||||
2022-12-15 | US | Michigan | Hillsdale | 26059 | 12353 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-16 04:21:01 | Hillsdale, Michigan, US | |
2022-12-15 | US | Iowa | Wapello | 19179 | 10122 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-16 04:21:01 | Wapello, Iowa, US | |
2022-12-15 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-16 04:21:01 | Iceland | ||||
2022-12-14 | US | Michigan | Hillsdale | 26059 | 12353 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-15 04:20:58 | Hillsdale, Michigan, US | |
2022-12-14 | US | Iowa | Wapello | 19179 | 10122 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-15 04:20:58 | Wapello, Iowa, US | |
2022-12-14 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-15 04:20:58 | Iceland | ||||
2022-12-13 | US | Michigan | Hillsdale | 26059 | 12353 | 219 | 0 | 41.88753639 | -84.59312019 | 2022-12-14 04:21:04 | Hillsdale, Michigan, US | |
2022-12-13 | US | Iowa | Wapello | 19179 | 10097 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-14 04:21:04 | Wapello, Iowa, US | |
2022-12-13 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-14 04:21:04 | Iceland | ||||
2022-12-12 | US | Iowa | Wapello | 19179 | 10097 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-13 04:21:01 | Wapello, Iowa, US | |
2022-12-12 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-13 04:21:01 | Iceland | ||||
2022-12-11 | US | Iowa | Wapello | 19179 | 10097 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-12 04:21:01 | Wapello, Iowa, US | |
2022-12-11 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-12 04:21:01 | Iceland | ||||
2022-12-10 | US | Iowa | Wapello | 19179 | 10097 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-11 04:20:50 | Wapello, Iowa, US | |
2022-12-10 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-11 04:20:50 | Iceland | ||||
2022-12-09 | US | Iowa | Wapello | 19179 | 10097 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-10 04:21:02 | Wapello, Iowa, US | |
2022-12-09 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-10 04:21:02 | Iceland | ||||
2022-12-08 | US | Iowa | Wapello | 19179 | 10097 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-09 04:21:05 | Wapello, Iowa, US | |
2022-12-08 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-09 04:21:05 | Iceland | ||||
2022-12-07 | US | Iowa | Wapello | 19179 | 10097 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-08 04:21:07 | Wapello, Iowa, US | |
2022-12-07 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-08 04:21:07 | Iceland | ||||
2022-12-06 | US | Iowa | Wapello | 19179 | 10077 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-07 04:20:58 | Wapello, Iowa, US | |
2022-12-06 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-07 04:20:58 | Iceland | ||||
2022-12-05 | US | Iowa | Wapello | 19179 | 10077 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-06 04:21:03 | Wapello, Iowa, US | |
2022-12-05 | Japan | Tokushima | 109806 | 219 | 0 | 33.919178 | 134.242091 | 2022-12-06 04:21:03 | Tokushima, Japan | |||
2022-12-05 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-06 04:21:03 | Iceland | ||||
2022-12-04 | US | Iowa | Wapello | 19179 | 10077 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-05 04:20:58 | Wapello, Iowa, US | |
2022-12-04 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-05 04:20:58 | Iceland | ||||
2022-12-03 | US | Iowa | Wapello | 19179 | 10077 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-04 04:20:56 | Wapello, Iowa, US | |
2022-12-03 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-04 04:20:56 | Iceland | ||||
2022-12-02 | US | Iowa | Wapello | 19179 | 10077 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-03 04:21:02 | Wapello, Iowa, US | |
2022-12-02 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-03 04:21:02 | Iceland | ||||
2022-12-01 | US | Iowa | Wapello | 19179 | 10077 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-02 04:21:07 | Wapello, Iowa, US | |
2022-12-01 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-02 04:21:07 | Iceland | ||||
2022-11-30 | US | Iowa | Wapello | 19179 | 10077 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-12-01 04:21:03 | Wapello, Iowa, US | |
2022-11-30 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-12-01 04:21:03 | Iceland | ||||
2022-11-29 | US | Virginia | Wise | 51195 | 13188 | 219 | 0 | 36.9746148 | -82.62410519 | 2022-11-30 04:21:07 | Wise, Virginia, US | |
2022-11-29 | US | Iowa | Wapello | 19179 | 10050 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-11-30 04:21:07 | Wapello, Iowa, US | |
2022-11-29 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-11-30 04:21:07 | Iceland | ||||
2022-11-28 | US | Iowa | Wapello | 19179 | 10050 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-11-29 04:21:05 | Wapello, Iowa, US | |
2022-11-28 | Iceland | 207101 | 219 | 0 | 64.9631 | -19.0208 | 2022-11-29 04:21:05 | Iceland | ||||
2022-11-27 | US | Iowa | Wapello | 19179 | 10050 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-11-28 04:21:02 | Wapello, Iowa, US | |
2022-11-27 | Iceland | 206803 | 219 | 0 | 64.9631 | -19.0208 | 2022-11-28 04:21:02 | Iceland | ||||
2022-11-26 | US | Iowa | Wapello | 19179 | 10050 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-11-27 04:21:05 | Wapello, Iowa, US | |
2022-11-26 | Iceland | 206803 | 219 | 0 | 64.9631 | -19.0208 | 2022-11-27 04:21:05 | Iceland | ||||
2022-11-25 | US | Iowa | Wapello | 19179 | 10050 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-11-26 04:21:11 | Wapello, Iowa, US | |
2022-11-25 | Iceland | 206803 | 219 | 0 | 64.9631 | -19.0208 | 2022-11-26 04:21:11 | Iceland | ||||
2022-11-24 | US | Iowa | Wapello | 19179 | 10050 | 219 | 0 | 41.03064984 | -92.40954728 | 2022-11-25 04:21:06 | Wapello, Iowa, US | |
2022-11-24 | Iceland | 206803 | 219 | 0 | 64.9631 | -19.0208 | 2022-11-25 04:21:06 | Iceland |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;