johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where deaths = 9911 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2529483 | 2529483 | 2022-10-06 | Mexico | Sinaloa | 175950 | 9911 | 0 | 25.1721 | -107.4795 | 2022-10-07 04:23:08 | Sinaloa, Mexico | |||
1810877 | 1810877 | 2022-10-05 | Mexico | Sinaloa | 175950 | 9911 | 0 | 25.1721 | -107.4795 | 2022-10-06 04:21:22 | Sinaloa, Mexico | |||
130851 | 130851 | 2022-10-04 | Mexico | Sinaloa | 175950 | 9911 | 0 | 25.1721 | -107.4795 | 2022-10-05 04:23:06 | Sinaloa, Mexico | |||
2685798 | 2685798 | 2022-10-03 | Mexico | Sinaloa | 175950 | 9911 | 0 | 25.1721 | -107.4795 | 2022-10-04 04:22:55 | Sinaloa, Mexico | |||
2259865 | 2259865 | 2022-10-02 | Mexico | Sinaloa | 175944 | 9911 | 0 | 25.1721 | -107.4795 | 2022-10-03 04:23:11 | Sinaloa, Mexico | |||
2995391 | 2995391 | 2022-10-01 | Mexico | Sinaloa | 175944 | 9911 | 0 | 25.1721 | -107.4795 | 2022-10-02 04:21:23 | Sinaloa, Mexico | |||
853717 | 853717 | 2022-09-30 | Mexico | Sinaloa | 175899 | 9911 | 0 | 25.1721 | -107.4795 | 2022-10-01 04:23:01 | Sinaloa, Mexico | |||
1560194 | 1560194 | 2022-09-28 | Mexico | Sinaloa | 175479 | 9911 | 0 | 25.1721 | -107.4795 | 2022-09-29 04:22:34 | Sinaloa, Mexico | |||
3994737 | 3994737 | 2022-09-27 | Mexico | Sinaloa | 175479 | 9911 | 0 | 25.1721 | -107.4795 | 2022-09-28 04:23:01 | Sinaloa, Mexico | |||
2769065 | 2769065 | 2022-09-26 | Mexico | Sinaloa | 175479 | 9911 | 0 | 25.1721 | -107.4795 | 2022-09-27 04:23:01 | Sinaloa, Mexico | |||
1976718 | 1976718 | 2022-09-25 | Mexico | Sinaloa | 175470 | 9911 | 0 | 25.1721 | -107.4795 | 2022-09-26 04:20:52 | Sinaloa, Mexico | |||
2649885 | 2649885 | 2022-09-24 | Mexico | Sinaloa | 175470 | 9911 | 0 | 25.1721 | -107.4795 | 2022-09-25 04:23:31 | Sinaloa, Mexico | |||
2279318 | 2279318 | 2021-09-08 | Peru | Callao | 99764 | 9911 | 0 | -11.954609 | -77.136042 | 2021-09-09 04:21:27 | Callao, Peru | |||
642097 | 642097 | 2021-09-07 | Peru | Callao | 99764 | 9911 | 0 | -11.954609 | -77.136042 | 2021-09-08 04:21:31 | Callao, Peru | |||
3091676 | 3091676 | 2021-05-30 | US | New York | Queens | 36081 | 276330 | 9911 | 0 | 40.71088124 | -73.81684712 | 2021-05-31 03:08:59 | Queens, New York, US | |
53045 | 53045 | 2021-05-29 | US | New York | Queens | 36081 | 276253 | 9911 | 0 | 40.71088124 | -73.81684712 | 2021-05-30 04:20:55 | Queens, New York, US | |
3703079 | 3703079 | 2021-04-27 | US | Illinois | Cook | 17031 | 530975 | 9911 | 0 | 41.84144849 | -87.81658794 | 2021-04-28 04:20:32 | Cook, Illinois, US | |
2207652 | 2207652 | 2021-03-04 | Italy | Veneto | 338237 | 9911 | 301725 | 26601 | 45.43490485 | 12.33845213 | 2021-03-05 05:26:29 | Veneto, Italy |
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]);