johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where confirmed = 54848 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2345195 | 2345195 | 2022-08-31 | US | Minnesota | St. Louis | 27137 | 54848 | 563 | 0 | 47.6048407 | -92.46879855 | 2022-09-01 04:21:03 | St. Louis, Minnesota, US | |
3775675 | 3775675 | 2022-08-30 | US | Minnesota | St. Louis | 27137 | 54848 | 563 | 0 | 47.6048407 | -92.46879855 | 2022-08-31 04:20:57 | St. Louis, Minnesota, US | |
1682271 | 1682271 | 2022-08-29 | US | Minnesota | St. Louis | 27137 | 54848 | 563 | 0 | 47.6048407 | -92.46879855 | 2022-08-30 04:21:03 | St. Louis, Minnesota, US | |
1878755 | 1878755 | 2022-08-28 | US | Minnesota | St. Louis | 27137 | 54848 | 563 | 0 | 47.6048407 | -92.46879855 | 2022-08-29 04:21:06 | St. Louis, Minnesota, US | |
2097882 | 2097882 | 2022-08-27 | US | Minnesota | St. Louis | 27137 | 54848 | 563 | 0 | 47.6048407 | -92.46879855 | 2022-08-28 04:21:02 | St. Louis, Minnesota, US | |
1533697 | 1533697 | 2022-08-26 | US | Minnesota | St. Louis | 27137 | 54848 | 563 | 0 | 47.6048407 | -92.46879855 | 2022-08-27 04:20:57 | St. Louis, Minnesota, US | |
2830584 | 2830584 | 2022-08-25 | US | Minnesota | St. Louis | 27137 | 54848 | 563 | 0 | 47.6048407 | -92.46879855 | 2022-08-26 04:21:02 | St. Louis, Minnesota, US | |
2331372 | 2331372 | 2022-05-08 | Japan | Fukushima | 54848 | 216 | 0 | 37.378867 | 140.223295 | 2022-05-09 04:20:54 | Fukushima, Japan | |||
2654320 | 2654320 | 2020-09-23 | US | California | Orange | 6059 | 54848 | 1176 | 0 | 53672 | 33.70147516 | -117.7645998 | 2020-09-24 04:23:00 | Orange, California, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);