johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where deaths = 5900 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2431129 | 2431129 | 2022-11-09 | Russia | Bashkortostan Republic | 332493 | 5900 | 0 | 54.8573563 | 57.1439682 | 2022-11-10 04:21:16 | Bashkortostan Republic, Russia | |||
479495 | 479495 | 2022-11-08 | Germany | Sachsen-Anhalt | 909239 | 5900 | 0 | 51.9503 | 11.6923 | 2022-11-09 04:21:22 | Sachsen-Anhalt, Germany | |||
2008735 | 2008735 | 2022-08-04 | Latvia | 869576 | 5900 | 0 | 56.8796 | 24.6032 | 2022-08-05 04:20:52 | Latvia | ||||
1098162 | 1098162 | 2022-08-03 | Latvia | 867809 | 5900 | 0 | 56.8796 | 24.6032 | 2022-08-04 04:20:58 | Latvia | ||||
2445987 | 2445987 | 2022-04-13 | US | Texas | Tarrant | 48439 | 566023 | 5900 | 0 | 32.77143818 | -97.29101614 | 2022-04-13 23:21:06 | Tarrant, Texas, US | |
1951744 | 1951744 | 2022-04-12 | US | Texas | Tarrant | 48439 | 565870 | 5900 | 0 | 32.77143818 | -97.29101614 | 2022-04-13 04:21:03 | Tarrant, Texas, US | |
3820060 | 3820060 | 2021-12-23 | Ukraine | Lviv Oblast | 218027 | 5900 | 0 | 49.8397 | 24.0297 | 2021-12-24 04:21:34 | Lviv Oblast, Ukraine | |||
3496336 | 3496336 | 2021-12-15 | Pakistan | Khyber Pakhtunkhwa | 180825 | 5900 | 0 | 34.485332 | 72.09169 | 2021-12-16 04:22:11 | Khyber Pakhtunkhwa, Pakistan | |||
3797528 | 3797528 | 2021-10-25 | Ukraine | Kiev | 251786 | 5900 | 0 | 50.4501 | 30.5234 | 2021-10-26 04:22:09 | Kiev, Ukraine | |||
684477 | 684477 | 2021-10-24 | US | Nevada | Clark | 32003 | 329006 | 5900 | 0 | 36.21458855 | -115.0130241 | 2021-10-25 04:22:31 | Clark, Nevada, US | |
772485 | 772485 | 2021-10-23 | US | Nevada | Clark | 32003 | 329006 | 5900 | 0 | 36.21458855 | -115.0130241 | 2021-10-24 04:21:22 | Clark, Nevada, US | |
656132 | 656132 | 2021-10-22 | US | Nevada | Clark | 32003 | 329006 | 5900 | 0 | 36.21458855 | -115.0130241 | 2021-10-23 04:21:32 | Clark, Nevada, US | |
3125366 | 3125366 | 2021-06-28 | Colombia | Santander | 188588 | 5900 | 172929 | 9759 | 6.6437 | -73.6536 | 2021-06-29 04:21:28 | Santander, Colombia | ||
1736503 | 1736503 | 2021-06-12 | Italy | Sicilia | 229157 | 5900 | 216559 | 6698 | 38.11569725 | 13.362356699999998 | 2021-06-13 04:22:44 | Sicilia, Italy | ||
2256023 | 2256023 | 2021-05-19 | Spain | Castilla - La Mancha | 189827 | 5900 | 6392 | 177535 | 39.2796 | -3.0977 | 2021-05-20 04:21:05 | Castilla - La Mancha, Spain | ||
2391061 | 2391061 | 2021-05-18 | Spain | Castilla - La Mancha | 189406 | 5900 | 6392 | 177114 | 39.2796 | -3.0977 | 2021-05-19 04:20:42 | Castilla - La Mancha, Spain | ||
3574886 | 3574886 | 2021-05-17 | Spain | Castilla - La Mancha | 189406 | 5900 | 6392 | 177114 | 39.2796 | -3.0977 | 2021-05-18 04:20:33 | Castilla - La Mancha, Spain | ||
2939616 | 2939616 | 2021-05-16 | Spain | Castilla - La Mancha | 189406 | 5900 | 6392 | 177114 | 39.2796 | -3.0977 | 2021-05-17 04:20:34 | Castilla - La Mancha, Spain | ||
1873246 | 1873246 | 2021-05-15 | Spain | Castilla - La Mancha | 189406 | 5900 | 6392 | 177114 | 39.2796 | -3.0977 | 2021-05-16 04:20:49 | Castilla - La Mancha, Spain | ||
1082215 | 1082215 | 2021-05-14 | Spain | Castilla - La Mancha | 189406 | 5900 | 6392 | 177114 | 39.2796 | -3.0977 | 2021-05-15 04:20:58 | Castilla - La Mancha, Spain | ||
955014 | 955014 | 2021-04-25 | Paraguay | 267082 | 5900 | 219647 | 41535 | -23.4425 | -58.4438 | 2021-04-26 04:21:04 | Paraguay | |||
3710852 | 3710852 | 2021-04-03 | US | Florida | Miami-Dade | 12086 | 449891 | 5900 | 0 | 25.6112362 | -80.55170587 | 2021-04-04 04:20:49 | Miami-Dade, Florida, US | |
3859999 | 3859999 | 2020-12-04 | Peru | Piura | 41047 | 5900 | 0 | 35147 | -5.133361 | -80.335861 | 2020-12-05 05:27:36 | Piura, Peru | ||
3440554 | 3440554 | 2020-11-11 | Brazil | Goias | 265131 | 5900 | 255595 | 3392 | -15.827 | -49.8362 | 2020-11-12 05:25:55 | Goias, Brazil | ||
3389326 | 3389326 | 2020-10-02 | India | Andhra Pradesh | 706790 | 5900 | 643993 | 56897 | 15.9129 | 79.74 | 2020-10-03 04:23:40 | Andhra Pradesh, India |
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]);