johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where confirmed = 45200 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 3
- US 4
- Russia 3
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2967642 | 2967642 | 2022-10-10 | Russia | North Ossetia - Alania Republic | 45200 | 1265 | 0 | 42.7933611 | 44.6324493 | 2022-10-11 04:23:05 | North Ossetia - Alania Republic, Russia | |||
1436793 | 1436793 | 2022-03-28 | Russia | Karachay-Cherkess Republic | 45200 | 979 | 0 | 43.7368326 | 41.7267991 | 2022-03-29 04:20:46 | Karachay-Cherkess Republic, Russia | |||
1289360 | 1289360 | 2022-01-04 | US | Virginia | Henrico | 51087 | 45200 | 750 | 0 | 37.53460572 | -77.39326555 | 2022-01-05 04:21:59 | Henrico, Virginia, US | |
447905 | 447905 | 2021-11-17 | US | Arkansas | Washington | 5143 | 45200 | 491 | 0 | 35.976844 | -94.21800746 | 2021-11-18 04:21:33 | Washington, Arkansas, US | |
1274873 | 1274873 | 2021-10-03 | US | California | Solano | 6095 | 45200 | 322 | 0 | 38.26827353 | -121.9357113 | 2021-10-04 04:21:31 | Solano, California, US | |
1588368 | 1588368 | 2021-02-05 | Russia | Chelyabinsk Oblast | 45200 | 826 | 35636 | 8738 | 54.4223954 | 61.1865846 | 2021-02-06 05:23:55 | Chelyabinsk Oblast, Russia | ||
3785558 | 3785558 | 2020-10-13 | West Bank and Gaza | 45200 | 391 | 38841 | 5968 | 31.9522 | 35.2332 | 2020-10-14 04:24:05 | West Bank and Gaza | |||
815829 | 815829 | 2020-09-05 | US | New York | Suffolk | 36103 | 45200 | 2005 | 0 | 43195 | 40.88320119 | -72.8012172 | 2020-09-06 04:28:33 | Suffolk, New York, 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]);