johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 41584 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1024637 | 1024637 | 2022-11-04 | US | New York | Schenectady | 36093 | 41584 | 341 | 0 | 42.81668777 | -74.05278291 | 2022-11-05 04:21:52 | Schenectady, New York, US | |
2161747 | 2161747 | 2022-10-16 | US | New Mexico | Sandoval | 35043 | 41584 | 482 | 0 | 35.68862401 | -106.8687803 | 2022-10-17 04:20:31 | Sandoval, New Mexico, US | |
517944 | 517944 | 2022-10-15 | US | New Mexico | Sandoval | 35043 | 41584 | 482 | 0 | 35.68862401 | -106.8687803 | 2022-10-16 04:22:39 | Sandoval, New Mexico, US | |
2035001 | 2035001 | 2022-10-14 | US | New Mexico | Sandoval | 35043 | 41584 | 482 | 0 | 35.68862401 | -106.8687803 | 2022-10-15 04:22:00 | Sandoval, New Mexico, US | |
3161200 | 3161200 | 2022-06-09 | US | Wisconsin | Marathon | 55073 | 41584 | 505 | 0 | 44.89792533 | -89.75863384 | 2022-06-10 04:20:55 | Marathon, Wisconsin, US | |
1647183 | 1647183 | 2022-03-03 | US | South Carolina | Florence | 45041 | 41584 | 613 | 0 | 34.02361754 | -79.70189312 | 2022-03-04 04:21:09 | Florence, South Carolina, US | |
1464228 | 1464228 | 2022-02-10 | Pakistan | Azad Jammu and Kashmir | 41584 | 766 | 0 | 34.027401 | 73.947253 | 2022-02-11 04:21:09 | Azad Jammu and Kashmir, Pakistan | |||
3466294 | 3466294 | 2022-01-18 | US | Nebraska | Sarpy | 31153 | 41584 | 131 | 0 | 41.11314181 | -96.11156432 | 2022-01-19 04:21:23 | Sarpy, Nebraska, US | |
1287654 | 1287654 | 2022-01-04 | US | Michigan | Kalamazoo | 26077 | 41584 | 550 | 0 | 42.24542231 | -85.53038622 | 2022-01-05 04:21:59 | Kalamazoo, Michigan, US | |
1701998 | 1701998 | 2022-01-03 | US | Michigan | Kalamazoo | 26077 | 41584 | 550 | 0 | 42.24542231 | -85.53038622 | 2022-01-04 04:22:17 | Kalamazoo, Michigan, US | |
276291 | 276291 | 2021-11-03 | Mexico | Zacatecas | 41584 | 3368 | 0 | 22.7709 | -102.5832 | 2021-11-04 04:22:20 | Zacatecas, Mexico | |||
1237953 | 1237953 | 2021-09-27 | US | North Carolina | Cumberland | 37051 | 41584 | 419 | 0 | 35.04762133 | -78.82623165 | 2021-09-28 04:21:28 | Cumberland, North Carolina, US | |
2573385 | 2573385 | 2021-04-13 | US | Minnesota | Dakota | 27037 | 41584 | 415 | 0 | 44.67172617 | -93.06299363 | 2021-04-14 04:20:41 | Dakota, Minnesota, US | |
704911 | 704911 | 2021-03-16 | US | Ohio | Summit | 39153 | 41584 | 916 | 0 | 41.12464734 | -81.53123079 | 2021-03-17 05:25:07 | Summit, Ohio, US | |
3149807 | 3149807 | 2020-12-16 | Russia | Krasnoyarsk Krai | 41584 | 1430 | 34543 | 5611 | 63.3233807 | 97.0979974 | 2020-12-17 05:28:12 | Krasnoyarsk Krai, Russia |
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]);