daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,267 rows where deaths = 217 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 | Tennessee | Loudon | 47105 | 17938 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-30 04:21:04 | Loudon, Tennessee, US | |
2022-12-29 | US | Pennsylvania | Clarion | 42031 | 9672 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-30 04:21:04 | Clarion, Pennsylvania, US | |
2022-12-28 | US | Tennessee | Loudon | 47105 | 17938 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-29 04:21:01 | Loudon, Tennessee, US | |
2022-12-28 | US | Pennsylvania | Clarion | 42031 | 9672 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-29 04:21:01 | Clarion, Pennsylvania, US | |
2022-12-27 | US | Tennessee | Loudon | 47105 | 17938 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-28 04:21:04 | Loudon, Tennessee, US | |
2022-12-27 | US | Pennsylvania | Clarion | 42031 | 9648 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-28 04:21:04 | Clarion, Pennsylvania, US | |
2022-12-26 | US | Tennessee | Loudon | 47105 | 17938 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-27 04:21:07 | Loudon, Tennessee, US | |
2022-12-26 | US | Pennsylvania | Clarion | 42031 | 9648 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-27 04:21:07 | Clarion, Pennsylvania, US | |
2022-12-25 | US | Tennessee | Loudon | 47105 | 17938 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-26 04:21:06 | Loudon, Tennessee, US | |
2022-12-25 | US | Pennsylvania | Clarion | 42031 | 9648 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-26 04:21:06 | Clarion, Pennsylvania, US | |
2022-12-24 | US | Tennessee | Loudon | 47105 | 17938 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-25 04:21:04 | Loudon, Tennessee, US | |
2022-12-24 | US | Pennsylvania | Clarion | 42031 | 9648 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-25 04:21:04 | Clarion, Pennsylvania, US | |
2022-12-23 | US | Tennessee | Loudon | 47105 | 17935 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-24 04:21:02 | Loudon, Tennessee, US | |
2022-12-23 | US | Pennsylvania | Clarion | 42031 | 9648 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-24 04:21:02 | Clarion, Pennsylvania, US | |
2022-12-22 | US | Tennessee | Loudon | 47105 | 17925 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-23 04:21:04 | Loudon, Tennessee, US | |
2022-12-22 | US | Pennsylvania | Clarion | 42031 | 9648 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-23 04:21:04 | Clarion, Pennsylvania, US | |
2022-12-21 | US | Tennessee | Loudon | 47105 | 17910 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-22 04:20:56 | Loudon, Tennessee, US | |
2022-12-21 | US | Pennsylvania | Clarion | 42031 | 9648 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-22 04:20:56 | Clarion, Pennsylvania, US | |
2022-12-20 | US | Tennessee | Loudon | 47105 | 17894 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-21 04:21:03 | Loudon, Tennessee, US | |
2022-12-20 | US | Pennsylvania | Clarion | 42031 | 9612 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-21 04:21:03 | Clarion, Pennsylvania, US | |
2022-12-19 | US | Tennessee | Loudon | 47105 | 17886 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-20 04:21:04 | Loudon, Tennessee, US | |
2022-12-19 | US | Pennsylvania | Clarion | 42031 | 9612 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-20 04:21:04 | Clarion, Pennsylvania, US | |
2022-12-18 | US | Tennessee | Loudon | 47105 | 17878 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-19 04:21:03 | Loudon, Tennessee, US | |
2022-12-18 | US | Pennsylvania | Clarion | 42031 | 9612 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-19 04:21:03 | Clarion, Pennsylvania, US | |
2022-12-17 | US | Tennessee | Loudon | 47105 | 17876 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-18 04:21:03 | Loudon, Tennessee, US | |
2022-12-17 | US | Pennsylvania | Clarion | 42031 | 9612 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-18 04:21:03 | Clarion, Pennsylvania, US | |
2022-12-16 | US | Tennessee | Loudon | 47105 | 17868 | 217 | 0 | 35.73939663 | -84.31145275 | 2022-12-17 04:21:04 | Loudon, Tennessee, US | |
2022-12-16 | US | Pennsylvania | Clarion | 42031 | 9612 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-17 04:21:04 | Clarion, Pennsylvania, US | |
2022-12-16 | Japan | Toyama | 186505 | 217 | 0 | 36.637464 | 137.269346 | 2022-12-17 04:21:04 | Toyama, Japan | |||
2022-12-15 | US | Pennsylvania | Clarion | 42031 | 9612 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-16 04:21:01 | Clarion, Pennsylvania, US | |
2022-12-14 | US | Pennsylvania | Clarion | 42031 | 9612 | 217 | 0 | 41.19265812 | -79.42413524 | 2022-12-15 04:20:58 | Clarion, Pennsylvania, US | |
2022-12-12 | US | Missouri | Newton | 29145 | 13372 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-13 04:21:01 | Newton, Missouri, US | |
2022-12-12 | US | Mississippi | Warren | 28149 | 12204 | 217 | 0 | 32.35810271 | -90.83352619 | 2022-12-13 04:21:01 | Warren, Mississippi, US | |
2022-12-11 | US | Missouri | Newton | 29145 | 13372 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-12 04:21:01 | Newton, Missouri, US | |
2022-12-11 | US | Mississippi | Warren | 28149 | 12204 | 217 | 0 | 32.35810271 | -90.83352619 | 2022-12-12 04:21:01 | Warren, Mississippi, US | |
2022-12-10 | US | Missouri | Newton | 29145 | 13372 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-11 04:20:50 | Newton, Missouri, US | |
2022-12-10 | US | Mississippi | Warren | 28149 | 12204 | 217 | 0 | 32.35810271 | -90.83352619 | 2022-12-11 04:20:50 | Warren, Mississippi, US | |
2022-12-09 | US | Missouri | Newton | 29145 | 13372 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-10 04:21:02 | Newton, Missouri, US | |
2022-12-09 | US | Mississippi | Warren | 28149 | 12204 | 217 | 0 | 32.35810271 | -90.83352619 | 2022-12-10 04:21:02 | Warren, Mississippi, US | |
2022-12-08 | US | Missouri | Newton | 29145 | 13372 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-09 04:21:05 | Newton, Missouri, US | |
2022-12-08 | US | Mississippi | Warren | 28149 | 12204 | 217 | 0 | 32.35810271 | -90.83352619 | 2022-12-09 04:21:05 | Warren, Mississippi, US | |
2022-12-07 | US | Missouri | Newton | 29145 | 13372 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-08 04:21:07 | Newton, Missouri, US | |
2022-12-07 | US | Mississippi | Warren | 28149 | 12204 | 217 | 0 | 32.35810271 | -90.83352619 | 2022-12-08 04:21:07 | Warren, Mississippi, US | |
2022-12-06 | US | Missouri | Newton | 29145 | 13372 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-07 04:20:58 | Newton, Missouri, US | |
2022-12-06 | US | Mississippi | Warren | 28149 | 12204 | 217 | 0 | 32.35810271 | -90.83352619 | 2022-12-07 04:20:58 | Warren, Mississippi, US | |
2022-12-05 | US | New Mexico | Otero | 35035 | 16407 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-12-06 04:21:03 | Otero, New Mexico, US | |
2022-12-05 | US | Missouri | Newton | 29145 | 13317 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-06 04:21:03 | Newton, Missouri, US | |
2022-12-04 | US | New Mexico | Otero | 35035 | 16331 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-12-05 04:20:58 | Otero, New Mexico, US | |
2022-12-04 | US | Missouri | Newton | 29145 | 13317 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-05 04:20:58 | Newton, Missouri, US | |
2022-12-03 | US | New Mexico | Otero | 35035 | 16331 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-12-04 04:20:56 | Otero, New Mexico, US | |
2022-12-03 | US | Missouri | Newton | 29145 | 13317 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-04 04:20:56 | Newton, Missouri, US | |
2022-12-03 | Japan | Tokushima | 109306 | 217 | 0 | 33.919178 | 134.242091 | 2022-12-04 04:20:56 | Tokushima, Japan | |||
2022-12-02 | US | New Mexico | Otero | 35035 | 16331 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-12-03 04:21:02 | Otero, New Mexico, US | |
2022-12-02 | US | Missouri | Newton | 29145 | 13317 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-03 04:21:02 | Newton, Missouri, US | |
2022-12-01 | US | New Mexico | Otero | 35035 | 16308 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-12-02 04:21:07 | Otero, New Mexico, US | |
2022-12-01 | US | Missouri | Newton | 29145 | 13317 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-02 04:21:07 | Newton, Missouri, US | |
2022-11-30 | US | New Mexico | Otero | 35035 | 16296 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-12-01 04:21:03 | Otero, New Mexico, US | |
2022-11-30 | US | Missouri | Newton | 29145 | 13317 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-12-01 04:21:03 | Newton, Missouri, US | |
2022-11-29 | US | New Mexico | Otero | 35035 | 16273 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-30 04:21:07 | Otero, New Mexico, US | |
2022-11-29 | US | Missouri | Newton | 29145 | 13317 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-30 04:21:07 | Newton, Missouri, US | |
2022-11-28 | US | New Mexico | Otero | 35035 | 16245 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-29 04:21:05 | Otero, New Mexico, US | |
2022-11-28 | US | Missouri | Newton | 29145 | 13277 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-29 04:21:05 | Newton, Missouri, US | |
2022-11-27 | US | New Mexico | Otero | 35035 | 16187 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-28 04:21:02 | Otero, New Mexico, US | |
2022-11-27 | US | Missouri | Newton | 29145 | 13277 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-28 04:21:02 | Newton, Missouri, US | |
2022-11-26 | US | New Mexico | Otero | 35035 | 16187 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-27 04:21:05 | Otero, New Mexico, US | |
2022-11-26 | US | Missouri | Newton | 29145 | 13277 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-27 04:21:05 | Newton, Missouri, US | |
2022-11-25 | US | New Mexico | Otero | 35035 | 16187 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-26 04:21:11 | Otero, New Mexico, US | |
2022-11-25 | US | Missouri | Newton | 29145 | 13277 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-26 04:21:11 | Newton, Missouri, US | |
2022-11-24 | US | New Mexico | Otero | 35035 | 16187 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-25 04:21:06 | Otero, New Mexico, US | |
2022-11-24 | US | Missouri | Newton | 29145 | 13277 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-25 04:21:06 | Newton, Missouri, US | |
2022-11-23 | US | New Mexico | Otero | 35035 | 16187 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-24 04:21:09 | Otero, New Mexico, US | |
2022-11-23 | US | Missouri | Newton | 29145 | 13277 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-24 04:21:09 | Newton, Missouri, US | |
2022-11-22 | US | New Mexico | Otero | 35035 | 16175 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-23 04:21:06 | Otero, New Mexico, US | |
2022-11-22 | US | Missouri | Newton | 29145 | 13277 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-23 04:21:06 | Newton, Missouri, US | |
2022-11-21 | US | New Mexico | Otero | 35035 | 16161 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-22 04:20:47 | Otero, New Mexico, US | |
2022-11-21 | US | Missouri | Newton | 29145 | 13253 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-22 04:20:47 | Newton, Missouri, US | |
2022-11-20 | US | New Mexico | Otero | 35035 | 16114 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-21 04:21:05 | Otero, New Mexico, US | |
2022-11-20 | US | Missouri | Newton | 29145 | 13253 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-21 04:21:05 | Newton, Missouri, US | |
2022-11-19 | US | New Mexico | Otero | 35035 | 16114 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-20 04:21:08 | Otero, New Mexico, US | |
2022-11-19 | US | Missouri | Newton | 29145 | 13253 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-20 04:21:08 | Newton, Missouri, US | |
2022-11-18 | US | New Mexico | Otero | 35035 | 16114 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-19 04:21:14 | Otero, New Mexico, US | |
2022-11-18 | US | Missouri | Newton | 29145 | 13253 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-19 04:21:14 | Newton, Missouri, US | |
2022-11-17 | US | New Mexico | Otero | 35035 | 16097 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-18 04:21:15 | Otero, New Mexico, US | |
2022-11-17 | US | Missouri | Newton | 29145 | 13253 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-18 04:21:15 | Newton, Missouri, US | |
2022-11-16 | US | New Mexico | Otero | 35035 | 16086 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-17 04:21:11 | Otero, New Mexico, US | |
2022-11-16 | US | Missouri | Newton | 29145 | 13253 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-17 04:21:11 | Newton, Missouri, US | |
2022-11-15 | US | New Mexico | Otero | 35035 | 16066 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-16 04:21:09 | Otero, New Mexico, US | |
2022-11-15 | US | Missouri | Newton | 29145 | 13253 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-16 04:21:09 | Newton, Missouri, US | |
2022-11-14 | US | New Mexico | Otero | 35035 | 16057 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-15 04:21:16 | Otero, New Mexico, US | |
2022-11-14 | US | Missouri | Newton | 29145 | 13228 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-15 04:21:16 | Newton, Missouri, US | |
2022-11-13 | US | New Mexico | Otero | 35035 | 16029 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-14 04:21:09 | Otero, New Mexico, US | |
2022-11-13 | US | Missouri | Newton | 29145 | 13228 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-14 04:21:09 | Newton, Missouri, US | |
2022-11-12 | US | New Mexico | Otero | 35035 | 16029 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-13 04:21:14 | Otero, New Mexico, US | |
2022-11-12 | US | Missouri | Newton | 29145 | 13228 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-13 04:21:14 | Newton, Missouri, US | |
2022-11-12 | Japan | Iwate | 130223 | 217 | 0 | 39.593287 | 141.361777 | 2022-11-13 04:21:14 | Iwate, Japan | |||
2022-11-11 | US | New Mexico | Otero | 35035 | 16029 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-12 04:20:41 | Otero, New Mexico, US | |
2022-11-11 | US | Missouri | Newton | 29145 | 13228 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-12 04:20:41 | Newton, Missouri, US | |
2022-11-11 | Japan | Iwate | 129184 | 217 | 0 | 39.593287 | 141.361777 | 2022-11-12 04:20:41 | Iwate, Japan | |||
2022-11-10 | US | New Mexico | Otero | 35035 | 16029 | 217 | 0 | 32.61348406 | -105.7417604 | 2022-11-11 04:21:22 | Otero, New Mexico, US | |
2022-11-10 | US | Missouri | Newton | 29145 | 13228 | 217 | 0 | 36.90519407 | -94.3394104 | 2022-11-11 04:21:22 | Newton, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;