johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where deaths = 5954 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1074104 | 1074104 | 2022-12-28 | Russia | Bashkortostan Republic | 342460 | 5954 | 0 | 54.8573563 | 57.1439682 | 2022-12-29 04:21:01 | Bashkortostan Republic, Russia | |||
2953641 | 2953641 | 2022-12-20 | US | New York | New York | 36061 | 569357 | 5954 | 0 | 40.7672726 | -73.97152637 | 2022-12-21 04:21:03 | New York, New York, US | |
3745155 | 3745155 | 2022-09-07 | Latvia | 904090 | 5954 | 0 | 56.8796 | 24.6032 | 2022-09-08 04:21:02 | Latvia | ||||
3940299 | 3940299 | 2022-06-30 | Russia | Penza Oblast | 187935 | 5954 | 0 | 53.1655415 | 44.7879181 | 2022-07-01 04:21:10 | Penza Oblast, Russia | |||
2242631 | 2242631 | 2022-06-28 | US | Texas | Tarrant | 48439 | 584194 | 5954 | 0 | 32.77143818 | -97.29101614 | 2022-06-29 04:20:59 | Tarrant, Texas, US | |
2150873 | 2150873 | 2022-06-27 | US | Texas | Tarrant | 48439 | 583477 | 5954 | 0 | 32.77143818 | -97.29101614 | 2022-06-28 04:20:58 | Tarrant, Texas, US | |
2084208 | 2084208 | 2022-05-15 | Russia | Saratov Oblast | 250502 | 5954 | 0 | 51.6520555 | 46.8631952 | 2022-05-16 04:20:47 | Saratov Oblast, Russia | |||
3354918 | 3354918 | 2022-05-14 | Russia | Saratov Oblast | 250373 | 5954 | 0 | 51.6520555 | 46.8631952 | 2022-05-15 04:20:53 | Saratov Oblast, Russia | |||
3820546 | 3820546 | 2022-02-16 | Mexico | Yucatan | 105882 | 5954 | 0 | 20.7099 | -89.0943 | 2022-02-17 04:20:56 | Yucatan, Mexico | |||
86798 | 86798 | 2021-11-09 | Algeria | 207385 | 5954 | 0 | 28.0339 | 1.6596 | 2021-11-10 04:21:38 | Algeria | ||||
3281099 | 3281099 | 2021-09-05 | Russia | Nizhny Novgorod Oblast | 158041 | 5954 | 0 | 55.47180329999999 | 44.091159399999995 | 2021-09-06 04:21:22 | Nizhny Novgorod Oblast, Russia | |||
2517930 | 2517930 | 2021-08-18 | Brazil | Sergipe | 276954 | 5954 | 0 | -10.5741 | -37.3857 | 2021-08-19 04:21:15 | Sergipe, Brazil | |||
1872889 | 1872889 | 2021-05-15 | Honduras | 225964 | 5954 | 82561 | 137449 | 15.2 | -86.2419 | 2021-05-16 04:20:49 | Honduras | |||
983222 | 983222 | 2021-04-17 | Serbia | 660299 | 5954 | 0 | 654345 | 44.0165 | 21.0059 | 2021-04-18 04:20:41 | Serbia | |||
606402 | 606402 | 2021-04-09 | US | Florida | Miami-Dade | 12086 | 457918 | 5954 | 0 | 25.6112362 | -80.55170587 | 2021-04-10 04:20:59 | Miami-Dade, Florida, US | |
1672613 | 1672613 | 2021-02-07 | Peru | Callao | 50895 | 5954 | 0 | 44941 | -11.954609 | -77.136042 | 2021-02-08 05:22:39 | Callao, Peru | ||
1632573 | 1632573 | 2020-12-05 | Saudi Arabia | 358526 | 5954 | 348562 | 4010 | 23.885942 | 45.079162 | 2020-12-06 05:26:18 | Saudi Arabia | |||
891870 | 891870 | 2020-11-05 | Brazil | Rio Grande do Sul | 254828 | 5954 | 236990 | 10379 | -30.0346 | -51.2177 | 2020-11-06 05:24:55 | Rio Grande do Sul, Brazil | ||
837587 | 837587 | 2020-08-17 | Iraq | 180133 | 5954 | 128945 | 45234 | 33.223191 | 43.679291 | 2020-08-18 04:27:56 | Iraq |
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]);