johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where deaths = 10104 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3436931 | 3436931 | 2022-04-22 | Mexico | Sonora | 165509 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-23 04:20:50 | Sonora, Mexico | |||
2892516 | 2892516 | 2022-04-21 | Mexico | Sonora | 165509 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-22 04:20:45 | Sonora, Mexico | |||
2307388 | 2307388 | 2022-04-20 | Mexico | Sonora | 165489 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-21 04:20:46 | Sonora, Mexico | |||
1846077 | 1846077 | 2022-04-18 | Mexico | Sonora | 165453 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-19 04:21:00 | Sonora, Mexico | |||
3417021 | 3417021 | 2022-04-17 | Mexico | Sonora | 165453 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-18 04:21:12 | Sonora, Mexico | |||
303970 | 303970 | 2022-04-16 | Mexico | Sonora | 165444 | 10104 | 0 | 29.2972 | -110.3309 | 2022-04-17 04:20:59 | Sonora, Mexico | |||
1656064 | 1656064 | 2022-04-09 | United Kingdom | Wales | 868195 | 10104 | 0 | 52.1307 | -3.7837 | 2022-04-10 04:20:52 | Wales, United Kingdom | |||
3350632 | 3350632 | 2022-04-01 | Italy | Sicilia | 980734 | 10104 | 0 | 38.11569725 | 13.362356699999998 | 2022-04-02 04:20:47 | Sicilia, Italy | |||
1992703 | 1992703 | 2022-03-01 | Lebanon | 1070696 | 10104 | 0 | 33.8547 | 35.8623 | 2022-03-02 04:21:07 | Lebanon | ||||
1362595 | 1362595 | 2022-02-08 | Russia | Rostov Oblast | 241842 | 10104 | 0 | 47.6222451 | 40.7957942 | 2022-02-09 04:21:04 | Rostov Oblast, Russia | |||
554721 | 554721 | 2022-01-16 | India | Haryana | 846898 | 10104 | 0 | 29.20004 | 76.332824 | 2022-01-17 04:21:08 | Haryana, India | |||
3828400 | 3828400 | 2021-12-21 | India | Gujarat | 828703 | 10104 | 0 | 22.694884 | 71.590923 | 2021-12-22 04:21:54 | Gujarat, India | |||
3974298 | 3974298 | 2021-09-03 | Brazil | Distrito Federal | 473731 | 10104 | 0 | -15.7998 | -47.8645 | 2021-09-04 04:21:28 | Distrito Federal, Brazil | |||
578751 | 578751 | 2021-07-13 | Germany | Sachsen | 286040 | 10104 | 275600 | 397 | 51.1045 | 13.2017 | 2021-07-14 04:21:35 | Sachsen, Germany | ||
1412699 | 1412699 | 2021-04-23 | United Kingdom | Scotland | 224851 | 10104 | 0 | 217204 | 56.4907 | -4.2026 | 2021-04-24 04:20:38 | 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]);