johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where deaths = 13726 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- Switzerland 3
- Brazil 2
- Italy 1
- Mexico 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2331713 | 2331713 | 2022-05-08 | Switzerland | 3636226 | 13726 | 0 | 46.8182 | 8.2275 | 2022-05-09 04:20:54 | Switzerland | ||||
360675 | 360675 | 2022-05-07 | Switzerland | 3636226 | 13726 | 0 | 46.8182 | 8.2275 | 2022-05-08 04:20:49 | Switzerland | ||||
1398026 | 1398026 | 2022-05-06 | Switzerland | 3636226 | 13726 | 0 | 46.8182 | 8.2275 | 2022-05-07 04:21:09 | Switzerland | ||||
3718168 | 3718168 | 2022-02-21 | Italy | Veneto | 1303219 | 13726 | 0 | 45.43490485 | 12.33845213 | 2022-02-22 04:21:01 | Veneto, Italy | |||
1362072 | 1362072 | 2022-02-08 | Brazil | Espirito Santo | 946853 | 13726 | 0 | -19.1834 | -40.3089 | 2022-02-09 04:21:04 | Espirito Santo, Brazil | |||
1227700 | 1227700 | 2022-01-24 | Mexico | Guanajuato | 235117 | 13726 | 0 | 21.019000000000002 | -101.2574 | 2022-01-25 04:21:05 | Guanajuato, Mexico | |||
809314 | 809314 | 2021-09-20 | Brazil | Mato Grosso | 531912 | 13726 | 0 | -12.6819 | -56.9211 | 2021-09-21 04:21:26 | Mato Grosso, Brazil | |||
1873196 | 1873196 | 2021-05-15 | Russia | Saint Petersburg | 426615 | 13726 | 388915 | 23974 | 59.9606739 | 30.158655100000004 | 2021-05-16 04:20:49 | Saint Petersburg, Russia |
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]);