johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where confirmed = 24874 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3941018 | 3941018 | 2022-06-30 | US | Idaho | Twin Falls | 16083 | 24874 | 295 | 0 | 42.35440512 | -114.6685381 | 2022-07-01 04:21:10 | Twin Falls, Idaho, US | |
2490976 | 2490976 | 2022-06-29 | US | Idaho | Twin Falls | 16083 | 24874 | 295 | 0 | 42.35440512 | -114.6685381 | 2022-06-30 04:21:01 | Twin Falls, Idaho, US | |
1466288 | 1466288 | 2022-02-10 | US | New Mexico | McKinley | 35031 | 24874 | 559 | 0 | 35.58007720000001 | -108.262245 | 2022-02-11 04:21:09 | McKinley, New Mexico, US | |
1716542 | 1716542 | 2021-12-16 | Russia | Altai Republic | 24874 | 488 | 0 | 50.7114101 | 86.8572186 | 2021-12-17 04:22:14 | Altai Republic, Russia | |||
1148123 | 1148123 | 2021-12-01 | US | Texas | Parker | 48367 | 24874 | 347 | 0 | 32.77757172 | -97.80500621 | 2021-12-02 04:22:37 | Parker, Texas, US | |
1953373 | 1953373 | 2021-05-21 | US | Georgia | Richmond | 13245 | 24874 | 514 | 0 | 33.35777107 | -82.07026432 | 2021-05-22 04:20:45 | Richmond, Georgia, US | |
648430 | 648430 | 2021-05-05 | US | Ohio | Lorain | 39093 | 24874 | 495 | 0 | 41.29553751 | -82.15083537 | 2021-05-06 04:20:38 | Lorain, Ohio, US | |
2626122 | 2626122 | 2021-01-10 | Russia | Tula Oblast | 24874 | 854 | 21971 | 2049 | 53.9570701 | 37.3690909 | 2021-01-11 05:21:50 | Tula Oblast, Russia | ||
3848455 | 3848455 | 2020-12-13 | US | District of Columbia | District of Columbia | 11001 | 24874 | 715 | 0 | 24159 | 38.90417773 | -77.01655992 | 2020-12-14 05:26:27 | District of Columbia, District of Columbia ,US |
1972441 | 1972441 | 2020-11-25 | Colombia | Narino | 24874 | 838 | 22811 | 1225 | 1.2892 | -77.3579 | 2020-11-26 05:27:44 | Narino, Colombia |
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]);