johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where recovered = 4573 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- Japan 3
- Russia 2
- El Salvador 1
- Iraq 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2104165 | 2104165 | 2021-06-01 | Japan | Shiga | 5136 | 80 | 4573 | 483 | 35.21582700000001 | 136.138064 | 2021-06-02 04:24:34 | Shiga, Japan | ||
2119745 | 2119745 | 2020-12-20 | Japan | Okinawa | 4967 | 77 | 4573 | 317 | 25.768923 | 126.668016 | 2020-12-21 05:27:58 | Okinawa, Japan | ||
2291478 | 2291478 | 2020-10-12 | Japan | Saitama | 5096 | 102 | 4573 | 421 | 35.997101 | 139.347635 | 2020-10-13 04:24:02 | Saitama, Japan | ||
666503 | 666503 | 2020-09-16 | Russia | North Ossetia - Alania Republic | 5343 | 68 | 4573 | 702 | 42.7933611 | 44.6324493 | 2020-09-17 04:22:00 | North Ossetia - Alania Republic, Russia | ||
3531641 | 3531641 | 2020-08-12 | Russia | Chuvashia Republic | 7144 | 65 | 4573 | 2506 | 55.4259922 | 47.0849429 | 2020-08-13 04:29:15 | Chuvashia Republic, Russia | ||
415675 | 415675 | 2020-07-05 | El Salvador | 7777 | 217 | 4573 | 2987 | 13.7942 | -88.8965 | 2020-07-06 04:33:57 | El Salvador | |||
1270065 | 1270065 | 2020-06-05 | Iraq | 9846 | 285 | 4573 | 4988 | 33.223191 | 43.679291 | 2020-06-06 02:33:00 | Iraq |
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]);