johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where deaths = 4235 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 11
- Trinidad and Tobago 6
- US 4
- Italy 2
- Mexico 2
- United Kingdom 2
- Azerbaijan 1
- Brazil 1
- Ethiopia 1
- India 1
- Lithuania 1
- Switzerland 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2757264 | 2757264 | 2022-10-18 | Trinidad and Tobago | 184261 | 4235 | 0 | 10.6918 | -61.2225 | 2022-10-19 04:22:26 | Trinidad and Tobago | ||||
2025098 | 2025098 | 2022-10-17 | Trinidad and Tobago | 184261 | 4235 | 0 | 10.6918 | -61.2225 | 2022-10-18 04:22:42 | Trinidad and Tobago | ||||
2159876 | 2159876 | 2022-10-16 | Trinidad and Tobago | 184261 | 4235 | 0 | 10.6918 | -61.2225 | 2022-10-17 04:20:31 | Trinidad and Tobago | ||||
516073 | 516073 | 2022-10-15 | Trinidad and Tobago | 184261 | 4235 | 0 | 10.6918 | -61.2225 | 2022-10-16 04:22:39 | Trinidad and Tobago | ||||
2033130 | 2033130 | 2022-10-14 | Trinidad and Tobago | 184261 | 4235 | 0 | 10.6918 | -61.2225 | 2022-10-15 04:22:00 | Trinidad and Tobago | ||||
3753818 | 3753818 | 2022-10-13 | Trinidad and Tobago | 184261 | 4235 | 0 | 10.6918 | -61.2225 | 2022-10-14 04:22:28 | Trinidad and Tobago | ||||
2264944 | 2264944 | 2022-03-14 | US | Illinois | Unassigned | 90017 | 120 | 4235 | 0 | 42.36542373 | 0.0 | 2022-03-15 04:20:47 | Unassigned, Illinois, US | |
3629010 | 3629010 | 2022-03-13 | US | Illinois | Unassigned | 90017 | 106 | 4235 | 0 | 42.36542373 | 0.0 | 2022-03-14 04:20:46 | Unassigned, Illinois, US | |
951918 | 951918 | 2022-03-12 | US | Illinois | Unassigned | 90017 | 106 | 4235 | 0 | 42.36542373 | 0.0 | 2022-03-13 04:20:49 | Unassigned, Illinois, US | |
2331026 | 2331026 | 2022-02-04 | United Kingdom | Northern Ireland | 560282 | 4235 | 0 | 54.7877 | -6.4923 | 2022-02-05 04:21:05 | Northern Ireland, United Kingdom | |||
3970439 | 3970439 | 2021-06-11 | Ethiopia | 273892 | 4235 | 249471 | 20186 | 9.145 | 40.4897 | 2021-06-12 04:22:22 | Ethiopia | |||
1806809 | 1806809 | 2021-05-27 | Lithuania | 273180 | 4235 | 251709 | 16888 | 55.1694 | 23.8813 | 2021-05-28 04:20:36 | Lithuania | |||
3242031 | 3242031 | 2021-04-21 | Azerbaijan | 305933 | 4235 | 269965 | 31733 | 40.1431 | 47.5769 | 2021-04-22 04:20:53 | Azerbaijan | |||
3712381 | 3712381 | 2021-04-03 | US | New York | New York | 36061 | 125259 | 4235 | 0 | 40.76727260000001 | -73.97152637 | 2021-04-04 04:20:49 | New York, New York, US | |
54799 | 54799 | 2021-03-07 | Italy | Sicilia | 156388 | 4235 | 135433 | 16720 | 38.11569725 | 13.362356699999998 | 2021-03-08 05:24:48 | Sicilia, Italy | ||
1338372 | 1338372 | 2021-02-15 | Mexico | San Luis Potosi | 54787 | 4235 | 0 | 50552 | 22.1565 | -100.9855 | 2021-02-16 05:24:38 | San Luis Potosi, Mexico | ||
2466891 | 2466891 | 2021-01-22 | Mexico | Hidalgo | 29756 | 4235 | 0 | 25521 | 20.0911 | -98.7624 | 2021-01-23 05:22:03 | Hidalgo, Mexico | ||
3836808 | 3836808 | 2020-11-21 | Switzerland | 290601 | 4235 | 180700 | 105666 | 46.8182 | 8.2275 | 2020-11-22 05:25:45 | Switzerland | |||
2601768 | 2601768 | 2020-10-10 | Brazil | Amazonas | 147038 | 4235 | 120012 | 22791 | -3.4168 | -65.8561 | 2020-10-11 04:23:46 | Amazonas, Brazil | ||
2665421 | 2665421 | 2020-09-04 | United Kingdom | Scotland | 21048 | 4235 | 0 | 18552 | 56.4907 | -4.2026 | 2020-09-05 04:28:19 | Scotland, United Kingdom | ||
206198 | 206198 | 2020-08-19 | India | Delhi | 156139 | 4235 | 140767 | 11137 | 28.646519 | 77.10898 | 2020-08-20 04:27:43 | Delhi, India | ||
1510487 | 1510487 | 2020-06-22 | Italy | Emilia-Romagna | 28243 | 4235 | 22854 | 1154 | 44.49436681 | 11.341720800000001 | 2020-06-23 04:33:22 | Emilia-Romagna, Italy |
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]);