johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where confirmed = 43394 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2414955 | 2414955 | 2022-12-05 | Mexico | Campeche | 43394 | 2283 | 0 | 19.8301 | -90.5349 | 2022-12-06 04:21:03 | Campeche, Mexico | |||
2828797 | 2828797 | 2022-08-25 | Italy | Valle d'Aosta | 43394 | 547 | 0 | 45.73750286 | 7.320149366 | 2022-08-26 04:21:02 | Valle d'Aosta, Italy | |||
593803 | 593803 | 2022-07-01 | Pakistan | Azad Jammu and Kashmir | 43394 | 792 | 0 | 34.027401 | 73.947253 | 2022-07-02 04:21:16 | Azad Jammu and Kashmir, Pakistan | |||
3940204 | 3940204 | 2022-06-30 | Pakistan | Azad Jammu and Kashmir | 43394 | 792 | 0 | 34.027401 | 73.947253 | 2022-07-01 04:21:10 | Azad Jammu and Kashmir, Pakistan | |||
72858 | 72858 | 2022-02-07 | US | Minnesota | St. Louis | 27137 | 43394 | 492 | 0 | 47.604840700000004 | -92.46879855 | 2022-02-08 04:21:15 | St. Louis, Minnesota, US | |
53773 | 53773 | 2021-05-29 | US | Tennessee | Rutherford | 47149 | 43394 | 438 | 0 | 35.84591405 | -86.4107263 | 2021-05-30 04:20:55 | Rutherford, Tennessee, US | |
1983445 | 1983445 | 2021-03-25 | US | South Carolina | Richland | 45079 | 43394 | 524 | 0 | 34.01791263 | -80.90267209 | 2021-03-26 05:26:55 | Richland, South Carolina, US | |
1582293 | 1582293 | 2021-03-13 | US | Nevada | Washoe | 32031 | 43394 | 653 | 0 | 40.66562265 | -119.6631594 | 2021-03-14 05:25:37 | Washoe, Nevada, US | |
2497866 | 2497866 | 2020-11-03 | Colombia | Cundinamarca | 43394 | 1241 | 39759 | 2394 | 5.026 | -74.03 | 2020-11-04 05:25:09 | Cundinamarca, 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]);