johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where deaths = 5760 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2027008 | 2027008 | 2022-10-17 | US | New York | New York | 36061 | 539100 | 5760 | 0 | 40.7672726 | -73.97152637 | 2022-10-18 04:22:42 | New York, New York, US | |
1624315 | 1624315 | 2022-09-22 | Japan | Tokyo | 3125077 | 5760 | 0 | 35.711343 | 139.446921 | 2022-09-23 04:23:13 | Tokyo, Japan | |||
2151850 | 2151850 | 2022-07-16 | Russia | Bashkortostan Republic | 291172 | 5760 | 0 | 54.8573563 | 57.1439682 | 2022-07-17 04:21:15 | Bashkortostan Republic, Russia | |||
3077963 | 3077963 | 2022-07-04 | Germany | Rheinland-Pfalz | 1258378 | 5760 | 0 | 50.1183 | 7.309 | 2022-07-05 04:20:45 | Rheinland-Pfalz, Germany | |||
3916078 | 3916078 | 2022-05-01 | Latvia | 822013 | 5760 | 0 | 56.8796 | 24.6032 | 2022-05-02 04:21:10 | Latvia | ||||
2840882 | 2840882 | 2022-04-30 | Latvia | 822013 | 5760 | 0 | 56.8796 | 24.6032 | 2022-05-01 04:20:57 | Latvia | ||||
1157195 | 1157195 | 2022-04-29 | Latvia | 822013 | 5760 | 0 | 56.8796 | 24.6032 | 2022-04-30 04:21:05 | Latvia | ||||
2029008 | 2029008 | 2022-04-24 | Russia | Penza Oblast | 183854 | 5760 | 0 | 53.1655415 | 44.78791810000001 | 2022-04-25 04:20:56 | Penza Oblast, Russia | |||
2657888 | 2657888 | 2022-01-31 | Mexico | Queretaro | 125673 | 5760 | 0 | 20.5888 | -100.3899 | 2022-02-01 04:21:11 | Queretaro, Mexico | |||
3300305 | 3300305 | 2022-01-30 | Mexico | Queretaro | 125257 | 5760 | 0 | 20.5888 | -100.3899 | 2022-01-31 04:21:09 | Queretaro, Mexico | |||
3062096 | 3062096 | 2022-01-29 | Mexico | Queretaro | 124893 | 5760 | 0 | 20.5888 | -100.3899 | 2022-01-30 04:21:26 | Queretaro, Mexico | |||
786029 | 786029 | 2021-12-13 | Ukraine | Lviv Oblast | 215204 | 5760 | 0 | 49.8397 | 24.0297 | 2021-12-14 04:22:38 | Lviv Oblast, Ukraine | |||
1235865 | 1235865 | 2021-09-27 | Russia | Krasnoyarsk Krai | 114968 | 5760 | 0 | 63.3233807 | 97.09799740000001 | 2021-09-28 04:21:28 | Krasnoyarsk Krai, Russia | |||
3974268 | 3974268 | 2021-09-03 | Azerbaijan | 436257 | 5760 | 0 | 40.1431 | 47.5769 | 2021-09-04 04:21:28 | Azerbaijan | ||||
998416 | 998416 | 2021-03-01 | Israel | 779958 | 5760 | 735624 | 38574 | 31.046051 | 34.851612 | 2021-03-02 05:23:30 | Israel | |||
237333 | 237333 | 2021-01-18 | Mexico | Nuevo Leon | 94796 | 5760 | 0 | 89036 | 25.5922 | -99.9962 | 2021-01-19 05:22:15 | Nuevo Leon, Mexico | ||
3484084 | 3484084 | 2020-08-20 | Canada | Quebec | 61282 | 5760 | 54383 | 1139 | 52.9399 | -73.5491 | 2020-08-21 04:27:41 | Quebec, Canada | ||
1459284 | 1459284 | 2020-04-24 | Germany | 154999 | 5760 | 109800 | 39439 | 51.165690999999995 | 10.451526 | 2020-04-25 06:30:33 | Germany |
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]);