daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
582 rows where confirmed = 912 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-20 | US | Kansas | Rush | 20165 | 912 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-21 04:21:03 | Rush, Kansas, US | |
2022-12-19 | US | Kansas | Rush | 20165 | 912 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-20 04:21:04 | Rush, Kansas, US | |
2022-12-18 | US | Kansas | Rush | 20165 | 912 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-19 04:21:03 | Rush, Kansas, US | |
2022-12-17 | US | Kansas | Rush | 20165 | 912 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-18 04:21:03 | Rush, Kansas, US | |
2022-12-16 | US | Kansas | Rush | 20165 | 912 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-17 04:21:04 | Rush, Kansas, US | |
2022-12-15 | US | Kansas | Rush | 20165 | 912 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-16 04:21:01 | Rush, Kansas, US | |
2022-12-14 | US | Kansas | Rush | 20165 | 912 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-15 04:20:58 | Rush, Kansas, US | |
2022-12-10 | China | Macau | 912 | 6 | 0 | 22.1667 | 113.55 | 2022-12-11 04:20:50 | Macau, China | |||
2022-12-06 | US | Texas | Upton | 48461 | 912 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-07 04:20:58 | Upton, Texas, US | |
2022-12-06 | US | Texas | Baylor | 48023 | 912 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-12-07 04:20:58 | Baylor, Texas, US | |
2022-12-05 | US | Texas | Upton | 48461 | 912 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-06 04:21:03 | Upton, Texas, US | |
2022-12-05 | US | Texas | Baylor | 48023 | 912 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-12-06 04:21:03 | Baylor, Texas, US | |
2022-12-04 | US | Texas | Upton | 48461 | 912 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-05 04:20:58 | Upton, Texas, US | |
2022-12-04 | US | Texas | Baylor | 48023 | 912 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-12-05 04:20:58 | Baylor, Texas, US | |
2022-12-03 | US | Texas | Upton | 48461 | 912 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-04 04:20:56 | Upton, Texas, US | |
2022-12-03 | US | Texas | Baylor | 48023 | 912 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-12-04 04:20:56 | Baylor, Texas, US | |
2022-12-02 | US | Texas | Upton | 48461 | 912 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-03 04:21:02 | Upton, Texas, US | |
2022-12-02 | US | Texas | Baylor | 48023 | 912 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-12-03 04:21:02 | Baylor, Texas, US | |
2022-12-01 | US | Texas | Upton | 48461 | 912 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-02 04:21:07 | Upton, Texas, US | |
2022-12-01 | US | Texas | Baylor | 48023 | 912 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-12-02 04:21:07 | Baylor, Texas, US | |
2022-11-30 | US | Texas | Upton | 48461 | 912 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-12-01 04:21:03 | Upton, Texas, US | |
2022-11-30 | US | Texas | Baylor | 48023 | 912 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-12-01 04:21:03 | Baylor, Texas, US | |
2022-11-29 | US | Texas | Upton | 48461 | 912 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-11-30 04:21:07 | Upton, Texas, US | |
2022-11-29 | US | South Dakota | Clark | 46025 | 912 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-11-30 04:21:07 | Clark, South Dakota, US | |
2022-11-28 | US | Texas | Upton | 48461 | 912 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-11-29 04:21:05 | Upton, Texas, US | |
2022-11-28 | US | South Dakota | Clark | 46025 | 912 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-11-29 04:21:05 | Clark, South Dakota, US | |
2022-11-28 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-29 04:21:05 | Petersburg, Alaska, US | |
2022-11-27 | US | South Dakota | Clark | 46025 | 912 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-11-28 04:21:02 | Clark, South Dakota, US | |
2022-11-27 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-28 04:21:02 | Petersburg, Alaska, US | |
2022-11-26 | US | South Dakota | Clark | 46025 | 912 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-11-27 04:21:05 | Clark, South Dakota, US | |
2022-11-26 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-27 04:21:05 | Petersburg, Alaska, US | |
2022-11-25 | US | South Dakota | Clark | 46025 | 912 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-11-26 04:21:11 | Clark, South Dakota, US | |
2022-11-25 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-26 04:21:11 | Petersburg, Alaska, US | |
2022-11-24 | US | South Dakota | Clark | 46025 | 912 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-11-25 04:21:06 | Clark, South Dakota, US | |
2022-11-24 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-25 04:21:06 | Petersburg, Alaska, US | |
2022-11-23 | US | South Dakota | Clark | 46025 | 912 | 12 | 0 | 44.85834507 | -97.72925109 | 2022-11-24 04:21:09 | Clark, South Dakota, US | |
2022-11-23 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-24 04:21:09 | Petersburg, Alaska, US | |
2022-11-22 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-23 04:21:06 | Petersburg, Alaska, US | |
2022-11-21 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-22 04:20:47 | Petersburg, Alaska, US | |
2022-11-20 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-21 04:21:05 | Petersburg, Alaska, US | |
2022-11-19 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-20 04:21:08 | Petersburg, Alaska, US | |
2022-11-18 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-19 04:21:14 | Petersburg, Alaska, US | |
2022-11-17 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-18 04:21:15 | Petersburg, Alaska, US | |
2022-11-16 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-17 04:21:11 | Petersburg, Alaska, US | |
2022-11-15 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-16 04:21:09 | Petersburg, Alaska, US | |
2022-11-14 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-15 04:21:16 | Petersburg, Alaska, US | |
2022-11-13 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-14 04:21:09 | Petersburg, Alaska, US | |
2022-11-12 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-13 04:21:14 | Petersburg, Alaska, US | |
2022-11-11 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-12 04:20:41 | Petersburg, Alaska, US | |
2022-11-10 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-11 04:21:22 | Petersburg, Alaska, US | |
2022-11-09 | US | New Mexico | Union | 35059 | 912 | 20 | 0 | 36.48126404 | -103.4709624 | 2022-11-10 04:21:16 | Union, New Mexico, US | |
2022-11-09 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-10 04:21:16 | Petersburg, Alaska, US | |
2022-11-08 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-09 04:21:22 | Petersburg, Alaska, US | |
2022-11-07 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-08 04:21:21 | Petersburg, Alaska, US | |
2022-11-06 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-07 04:21:26 | Petersburg, Alaska, US | |
2022-11-05 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-06 04:21:24 | Petersburg, Alaska, US | |
2022-11-04 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-05 04:21:52 | Petersburg, Alaska, US | |
2022-11-03 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-04 04:22:11 | Petersburg, Alaska, US | |
2022-11-02 | US | Alaska | Petersburg | 2195 | 912 | 7 | 0 | 57.13978948 | -132.9540995 | 2022-11-03 04:22:05 | Petersburg, Alaska, US | |
2022-10-04 | US | Kansas | Osborne | 20141 | 912 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-10-05 04:23:06 | Osborne, Kansas, US | |
2022-10-03 | US | Kansas | Osborne | 20141 | 912 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-10-04 04:22:55 | Osborne, Kansas, US | |
2022-10-02 | US | Kansas | Osborne | 20141 | 912 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-10-03 04:23:11 | Osborne, Kansas, US | |
2022-10-01 | US | Kansas | Osborne | 20141 | 912 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-10-02 04:21:23 | Osborne, Kansas, US | |
2022-09-30 | US | Kansas | Osborne | 20141 | 912 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-10-01 04:23:01 | Osborne, Kansas, US | |
2022-09-29 | US | Kansas | Osborne | 20141 | 912 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-09-30 04:23:09 | Osborne, Kansas, US | |
2022-09-28 | US | Kansas | Osborne | 20141 | 912 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-09-29 04:22:34 | Osborne, Kansas, US | |
2022-09-27 | US | North Dakota | Hettinger | 38041 | 912 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-09-28 04:23:01 | Hettinger, North Dakota, US | |
2022-09-20 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-21 04:23:22 | Logan, Kansas, US | |
2022-09-19 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-20 04:22:48 | Logan, Kansas, US | |
2022-09-18 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-19 04:21:49 | Logan, Kansas, US | |
2022-09-17 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-18 04:22:50 | Logan, Kansas, US | |
2022-09-16 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-17 04:20:19 | Logan, Kansas, US | |
2022-09-15 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-16 04:21:19 | Logan, Kansas, US | |
2022-09-14 | US | New York | Unassigned | 90036 | 912 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-15 04:21:02 | Unassigned, New York, US | |
2022-09-14 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-15 04:21:02 | Logan, Kansas, US | |
2022-09-13 | US | New York | Unassigned | 90036 | 912 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-14 04:20:44 | Unassigned, New York, US | |
2022-09-13 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-14 04:20:44 | Logan, Kansas, US | |
2022-09-12 | US | New York | Unassigned | 90036 | 912 | 2 | 0 | 44.74530905 | 0.0 | 2022-09-13 04:20:57 | Unassigned, New York, US | |
2022-09-12 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-13 04:20:57 | Logan, Kansas, US | |
2022-09-11 | US | Texas | Mason | 48319 | 912 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-12 04:20:58 | Mason, Texas, US | |
2022-09-11 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-12 04:20:58 | Logan, Kansas, US | |
2022-09-10 | US | Texas | Mason | 48319 | 912 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-11 04:20:50 | Mason, Texas, US | |
2022-09-10 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-11 04:20:50 | Logan, Kansas, US | |
2022-09-09 | US | Texas | Mason | 48319 | 912 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-10 04:21:10 | Mason, Texas, US | |
2022-09-09 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-10 04:21:10 | Logan, Kansas, US | |
2022-09-08 | US | Texas | Mason | 48319 | 912 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-09 04:21:11 | Mason, Texas, US | |
2022-09-08 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-09 04:21:11 | Logan, Kansas, US | |
2022-09-07 | US | Texas | Mason | 48319 | 912 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-08 04:21:02 | Mason, Texas, US | |
2022-09-07 | US | Kansas | Logan | 20109 | 912 | 13 | 0 | 38.91735806 | -101.148475 | 2022-09-08 04:21:02 | Logan, Kansas, US | |
2022-09-06 | US | Texas | Mason | 48319 | 912 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-09-07 04:20:59 | Mason, Texas, US | |
2022-09-06 | US | Kansas | Chautauqua | 20019 | 912 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-09-07 04:20:59 | Chautauqua, Kansas, US | |
2022-09-05 | US | Kansas | Chautauqua | 20019 | 912 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-09-06 04:21:02 | Chautauqua, Kansas, US | |
2022-09-04 | US | Kansas | Chautauqua | 20019 | 912 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-09-05 04:21:01 | Chautauqua, Kansas, US | |
2022-09-03 | US | Kansas | Chautauqua | 20019 | 912 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-09-04 04:21:22 | Chautauqua, Kansas, US | |
2022-09-02 | US | Kansas | Chautauqua | 20019 | 912 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-09-03 04:21:04 | Chautauqua, Kansas, US | |
2022-09-01 | US | Kansas | Chautauqua | 20019 | 912 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-09-02 04:21:07 | Chautauqua, Kansas, US | |
2022-08-31 | US | Kansas | Chautauqua | 20019 | 912 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-09-01 04:21:03 | Chautauqua, Kansas, US | |
2022-08-10 | US | New Mexico | Mora | 35033 | 912 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-08-11 04:20:49 | Mora, New Mexico, US | |
2022-08-10 | US | Minnesota | Traverse | 27155 | 912 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-08-11 04:20:49 | Traverse, Minnesota, US | |
2022-08-09 | US | New Mexico | Mora | 35033 | 912 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-08-10 04:20:57 | Mora, New Mexico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;