johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where deaths = 4031 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- US 13
- Namibia 4
- Dominican Republic 2
- India 2
- United Kingdom 2
- Australia 1
- Brazil 1
- Germany 1
- Italy 1
- Mexico 1
- Oman 1
- Russia 1
- Trinidad and Tobago 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2559049 | 2559049 | 2022-11-29 | US | Ohio | Cuyahoga | 39035 | 330423 | 4031 | 0 | 41.424119 | -81.65918339 | 2022-11-30 04:21:07 | Cuyahoga, Ohio, US | |
1242123 | 1242123 | 2022-11-28 | US | Ohio | Cuyahoga | 39035 | 330423 | 4031 | 0 | 41.424119 | -81.65918339 | 2022-11-29 04:21:05 | Cuyahoga, Ohio, US | |
3554111 | 3554111 | 2022-11-27 | US | Ohio | Cuyahoga | 39035 | 330423 | 4031 | 0 | 41.424119 | -81.65918339 | 2022-11-28 04:21:02 | Cuyahoga, Ohio, US | |
2531635 | 2531635 | 2022-10-06 | US | New York | Nassau | 36059 | 499613 | 4031 | 0 | 40.74066522 | -73.58941873 | 2022-10-07 04:23:08 | Nassau, New York, US | |
2495708 | 2495708 | 2022-08-15 | US | Michigan | Oakland | 26125 | 336627 | 4031 | 0 | 42.66090111 | -83.38595416 | 2022-08-16 04:20:58 | Oakland, Michigan, US | |
3649258 | 3649258 | 2022-08-14 | US | Michigan | Oakland | 26125 | 336627 | 4031 | 0 | 42.66090111 | -83.38595416 | 2022-08-15 04:20:59 | Oakland, Michigan, US | |
1970264 | 1970264 | 2022-08-13 | US | Michigan | Oakland | 26125 | 336627 | 4031 | 0 | 42.66090111 | -83.38595416 | 2022-08-14 04:20:55 | Oakland, Michigan, US | |
2890073 | 2890073 | 2022-08-12 | US | Michigan | Oakland | 26125 | 336627 | 4031 | 0 | 42.66090111 | -83.38595416 | 2022-08-13 04:20:52 | Oakland, Michigan, US | |
3909678 | 3909678 | 2022-08-11 | US | Michigan | Oakland | 26125 | 336627 | 4031 | 0 | 42.66090111 | -83.38595416 | 2022-08-12 04:20:54 | Oakland, Michigan, US | |
1347995 | 1347995 | 2022-08-10 | US | Michigan | Oakland | 26125 | 336627 | 4031 | 0 | 42.66090111 | -83.38595416 | 2022-08-11 04:20:49 | Oakland, Michigan, US | |
1087750 | 1087750 | 2022-08-09 | US | Michigan | Oakland | 26125 | 336627 | 4031 | 0 | 42.66090111 | -83.38595416 | 2022-08-10 04:20:57 | Oakland, Michigan, US | |
3617053 | 3617053 | 2022-08-01 | Italy | Marche | 575959 | 4031 | 0 | 43.61675973 | 13.5188753 | 2022-08-02 04:20:53 | Marche, Italy | |||
2593713 | 2593713 | 2022-07-25 | Australia | New South Wales | 3116121 | 4031 | 0 | -33.8688 | 151.2093 | 2022-07-26 04:20:58 | New South Wales, Australia | |||
630251 | 630251 | 2022-07-12 | Trinidad and Tobago | 168427 | 4031 | 0 | 10.6918 | -61.2225 | 2022-07-13 04:20:58 | Trinidad and Tobago | ||||
1421298 | 1421298 | 2022-06-08 | Russia | Bryansk Oblast | 162044 | 4031 | 0 | 52.8873315 | 33.415853 | 2022-06-09 04:20:54 | Bryansk Oblast, Russia | |||
1109692 | 1109692 | 2022-05-21 | Namibia | 160640 | 4031 | 0 | -22.9576 | 18.4904 | 2022-05-22 04:20:52 | Namibia | ||||
1169316 | 1169316 | 2022-05-20 | Namibia | 160640 | 4031 | 0 | -22.9576 | 18.4904 | 2022-05-21 04:20:58 | Namibia | ||||
3896079 | 3896079 | 2022-05-19 | Namibia | 160640 | 4031 | 0 | -22.9576 | 18.4904 | 2022-05-20 04:20:57 | Namibia | ||||
1184863 | 1184863 | 2022-05-18 | Namibia | 160640 | 4031 | 0 | -22.9576 | 18.4904 | 2022-05-19 04:20:54 | Namibia | ||||
1700301 | 1700301 | 2022-01-03 | India | Telangana | 682971 | 4031 | 0 | 18.1124 | 79.0193 | 2022-01-04 04:22:17 | Telangana, India | |||
3608734 | 3608734 | 2021-12-25 | United Kingdom | Northern Ireland | 367181 | 4031 | 0 | 54.7877 | -6.4923 | 2021-12-26 04:21:50 | Northern Ireland, United Kingdom | |||
701100 | 701100 | 2021-11-04 | US | Pennsylvania | Philadelphia | 42101 | 184847 | 4031 | 0 | 40.00338507 | -75.1379271 | 2021-11-05 04:21:54 | Philadelphia, Pennsylvania, US | |
491537 | 491537 | 2021-10-14 | Germany | Rheinland-Pfalz | 185075 | 4031 | 0 | 50.1183 | 7.309 | 2021-10-15 04:21:26 | Rheinland-Pfalz, Germany | |||
601555 | 601555 | 2021-09-23 | Dominican Republic | 356321 | 4031 | 0 | 18.7357 | -70.1627 | 2021-09-24 04:21:44 | Dominican Republic | ||||
3011216 | 3011216 | 2021-09-22 | Dominican Republic | 356042 | 4031 | 0 | 18.7357 | -70.1627 | 2021-09-23 04:21:43 | Dominican Republic | ||||
2175694 | 2175694 | 2021-08-22 | Oman | 301299 | 4031 | 0 | 21.512583 | 55.92325500000001 | 2021-08-23 04:21:27 | Oman | ||||
1084984 | 1084984 | 2021-05-14 | US | Texas | Dallas | 48113 | 277639 | 4031 | 0 | 32.76670599 | -96.7779605 | 2021-05-15 04:20:58 | Dallas, Texas, US | |
3393495 | 3393495 | 2021-04-28 | Mexico | Tabasco | 64359 | 4031 | 0 | 60328 | 17.8409 | -92.6189 | 2021-04-29 04:20:55 | Tabasco, Mexico | ||
75035 | 75035 | 2020-12-03 | India | Gujarat | 214309 | 4031 | 195365 | 14913 | 22.694884 | 71.590923 | 2020-12-04 05:27:27 | Gujarat, India | ||
1515128 | 1515128 | 2020-09-28 | Brazil | Amazonas | 136708 | 4031 | 112632 | 20045 | -3.4168 | -65.8561 | 2020-09-29 04:23:42 | Amazonas, Brazil | ||
1270194 | 1270194 | 2020-06-05 | United Kingdom | Scotland | 82603 | 0 | 4031 | 0 | 0 | 56.4907 | -4.2026 | 2020-06-06 02:33:00 | Scotland, United Kingdom |
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]);