johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where deaths = 7307 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- Afghanistan 2
- Panama 2
- Italy 1
- North Macedonia 1
- Peru 1
- Serbia 1
- US 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3496167 | 3496167 | 2021-12-15 | Italy | Sicilia | 337049 | 7307 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-16 04:22:11 | Sicilia, Italy | |||
757999 | 757999 | 2021-11-26 | Afghanistan | 157171 | 7307 | 0 | 33.93911 | 67.709953 | 2021-11-27 04:22:45 | Afghanistan | ||||
1802416 | 1802416 | 2021-11-25 | Afghanistan | 157144 | 7307 | 0 | 33.93911 | 67.709953 | 2021-11-26 04:22:33 | Afghanistan | ||||
714606 | 714606 | 2021-11-12 | North Macedonia | 208467 | 7307 | 0 | 41.6086 | 21.7453 | 2021-11-13 04:21:38 | North Macedonia | ||||
682492 | 682492 | 2021-10-24 | Panama | 471403 | 7307 | 0 | 8.538 | -80.7821 | 2021-10-25 04:22:31 | Panama | ||||
770500 | 770500 | 2021-10-23 | Panama | 471403 | 7307 | 0 | 8.538 | -80.7821 | 2021-10-24 04:21:22 | Panama | ||||
67337 | 67337 | 2021-09-01 | Serbia | 766279 | 7307 | 0 | 44.0165 | 21.0059 | 2021-09-02 04:21:15 | Serbia | ||||
2390931 | 2390931 | 2021-05-18 | Peru | Ica | 50877 | 7307 | 0 | 43570 | -14.235097 | -75.574821 | 2021-05-19 04:20:42 | Ica, Peru | ||
1990880 | 1990880 | 2020-11-09 | US | New York | Queens | 36081 | 81601 | 7307 | 0 | 74294 | 40.71088124 | -73.81684712 | 2020-11-10 05:40:07 | Queens, New York, US |
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]);