johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5 rows where confirmed = 69695 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
157885 | 157885 | 2022-03-29 | Eswatini | 69695 | 1394 | 0 | -26.5225 | 31.4659 | 2022-03-30 04:20:45 | Eswatini | ||||
483785 | 483785 | 2021-07-19 | Russia | Chelyabinsk Oblast | 69695 | 1983 | 63586 | 4126 | 54.4223954 | 61.1865846 | 2021-07-20 04:21:48 | Chelyabinsk Oblast, Russia | ||
2259371 | 2259371 | 2021-05-19 | Ukraine | Vinnytsia Oblast | 69695 | 1625 | 59533 | 8537 | 49.2331 | 28.4682 | 2021-05-20 04:21:05 | Vinnytsia Oblast, Ukraine | ||
1085006 | 1085006 | 2021-05-14 | US | Texas | Fort Bend | 48157 | 69695 | 671 | 0 | 29.52704478 | -95.77219463 | 2021-05-15 04:20:58 | Fort Bend, Texas, US | |
217204 | 217204 | 2020-06-08 | Spain | Madrid | 69695 | 8691 | 40736 | 20268 | 40.4168 | -3.7038 | 2020-06-09 03:33:03 | Madrid, Spain |
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]);