johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
7 rows where confirmed = 27732 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
695057 | 695057 | 2022-03-17 | US | Connecticut | Middlesex | 9007 | 27732 | 476 | 0 | 41.45949668 | -72.53714864 | 2022-03-18 04:20:55 | Middlesex, Connecticut, US | |
2903916 | 2903916 | 2021-12-19 | Russia | Ingushetia Republic | 27732 | 453 | 0 | 43.11542075 | 45.01713552 | 2021-12-20 04:21:43 | Ingushetia Republic, Russia | |||
3793663 | 3793663 | 2021-10-25 | Chile | Atacama | 27732 | 358 | 0 | -27.5661 | -70.0503 | 2021-10-26 04:22:09 | Atacama, Chile | |||
2620430 | 2620430 | 2021-09-17 | US | North Dakota | Cass | 38017 | 27732 | 220 | 0 | 46.93201724 | -97.24447190000001 | 2021-09-18 04:21:24 | Cass, North Dakota, US | |
2483098 | 2483098 | 2021-01-28 | US | Indiana | St. Joseph | 18141 | 27732 | 470 | 0 | 27262 | 41.61756781 | -86.29040834 | 2021-01-29 05:22:23 | St. Joseph, Indiana, US |
2704831 | 2704831 | 2020-11-20 | US | Virginia | Fairfax | 51059 | 27732 | 614 | 0 | 27118 | 38.83677558 | -77.27565836 | 2020-11-21 05:25:51 | Fairfax, Virginia, US |
1177282 | 1177282 | 2020-10-22 | Chile | Biobio | 27732 | 432 | 25310 | 1990 | -37.4464 | -72.1416 | 2020-10-23 04:24:46 | Biobio, Chile |
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]);