johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where confirmed = 42967 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2375745 | 2375745 | 2022-09-29 | Russia | Ingushetia Republic | 42967 | 550 | 0 | 43.11542075 | 45.01713552 | 2022-09-30 04:23:09 | Ingushetia Republic, Russia | |||
1405125 | 1405125 | 2022-08-02 | Mexico | Chiapas | 42967 | 2426 | 0 | 16.7569 | -93.1292 | 2022-08-03 04:20:59 | Chiapas, Mexico | |||
3142141 | 3142141 | 2022-06-11 | US | California | Marin | 6041 | 42967 | 294 | 0 | 38.07122463 | -122.7210631 | 2022-06-12 04:20:53 | Marin, California, US | |
2665479 | 2665479 | 2022-03-04 | Australia | Northern Territory | 42967 | 28 | 0 | -12.4634 | 130.8456 | 2022-03-05 04:21:10 | Northern Territory, Australia | |||
1669506 | 1669506 | 2021-12-29 | US | Illinois | St. Clair | 17163 | 42967 | 637 | 0 | 38.46996033 | -89.93063427 | 2021-12-30 04:21:25 | St. Clair, Illinois, US | |
1310399 | 1310399 | 2021-05-26 | Russia | Novosibirsk Oblast | 42967 | 1858 | 38930 | 2179 | 54.9720169 | 79.48139240000002 | 2021-05-27 04:20:59 | Novosibirsk Oblast, Russia | ||
1010409 | 1010409 | 2020-12-30 | Mexico | Veracruz | 42967 | 6316 | 0 | 36651 | 19.1738 | -96.1342 | 2020-12-31 05:22:49 | Veracruz, Mexico | ||
176497 | 176497 | 2020-07-27 | US | New York | Suffolk | 36103 | 42967 | 1996 | 0 | 40971 | 40.88320119 | -72.8012172 | 2020-07-28 04:58:43 | Suffolk, 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]);