johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where deaths = 10991 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 6
- India 2
- Italy 2
- US 2
- Nepal 1
- Switzerland 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3042008 | 3042008 | 2022-10-27 | United Kingdom | Wales | 888547 | 10991 | 0 | 52.1307 | -3.7837 | 2022-10-28 04:22:31 | Wales, United Kingdom | |||
3950458 | 3950458 | 2022-08-17 | Italy | Campania | 2155360 | 10991 | 0 | 40.83956555 | 14.25084984 | 2022-08-18 04:21:11 | Campania, Italy | |||
3647514 | 3647514 | 2022-08-14 | India | Gujarat | 1265453 | 10991 | 0 | 22.694884 | 71.590923 | 2022-08-15 04:20:59 | Gujarat, India | |||
3530578 | 3530578 | 2022-06-04 | US | Texas | Harris | 48201 | 1053267 | 10991 | 0 | 29.85864939 | -95.39339521 | 2022-06-05 04:20:55 | Harris, Texas, US | |
3136664 | 3136664 | 2022-06-03 | US | Texas | Harris | 48201 | 1051613 | 10991 | 0 | 29.85864939 | -95.39339521 | 2022-06-04 04:20:58 | Harris, Texas, US | |
2809079 | 2809079 | 2021-09-16 | Switzerland | 820982 | 10991 | 0 | 46.8182 | 8.2275 | 2021-09-17 04:21:46 | Switzerland | ||||
1374609 | 1374609 | 2021-09-15 | Nepal | 780824 | 10991 | 0 | 28.1667 | 84.25 | 2021-09-16 04:22:19 | Nepal | ||||
2020714 | 2020714 | 2021-04-20 | Italy | Piemonte | 335463 | 10991 | 303708 | 20764 | 45.0732745 | 7.680687483 | 2021-04-21 04:21:14 | Piemonte, Italy | ||
1452538 | 1452538 | 2020-10-27 | India | Karnataka | 809638 | 10991 | 727298 | 71349 | 14.70518 | 76.166436 | 2020-10-28 04:24:39 | Karnataka, 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]);