johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where confirmed = 42464 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3570800 | 3570800 | 2022-09-19 | Russia | Ingushetia Republic | 42464 | 550 | 0 | 43.11542075 | 45.01713552 | 2022-09-20 04:22:48 | Ingushetia Republic, Russia | |||
2343660 | 2343660 | 2022-08-31 | Russia | North Ossetia - Alania Republic | 42464 | 1258 | 0 | 42.7933611 | 44.6324493 | 2022-09-01 04:21:03 | North Ossetia - Alania Republic, Russia | |||
649884 | 649884 | 2021-08-09 | Germany | Saarland | 42464 | 1030 | 0 | 49.3964 | 7.023 | 2021-08-10 04:21:27 | Saarland, Germany | |||
3113595 | 3113595 | 2021-05-06 | Mongolia | 42464 | 145 | 28533 | 14515 | 46.8625 | 103.8467 | 2021-05-07 04:20:40 | Mongolia | |||
3232623 | 3232623 | 2021-01-03 | US | New Jersey | Union | 34039 | 42464 | 1561 | 0 | 40903 | 40.65835409 | -74.30680092 | 2021-01-04 05:22:02 | Union, New Jersey, US |
2582279 | 2582279 | 2020-09-27 | Spain | Pais Vasco | 42464 | 1838 | 16160 | 24466 | 42.9896 | -2.6189 | 2020-09-28 04:23:00 | Pais Vasco, Spain | ||
2614331 | 2614331 | 2020-09-26 | Spain | Pais Vasco | 42464 | 1838 | 16160 | 24466 | 42.9896 | -2.6189 | 2020-09-27 04:23:00 | Pais Vasco, Spain | ||
2813046 | 2813046 | 2020-09-25 | Spain | Pais Vasco | 42464 | 1838 | 16160 | 24466 | 42.9896 | -2.6189 | 2020-09-26 04:23:00 | Pais Vasco, Spain |
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]);