johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where deaths = 6852 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
307901 | 307901 | 2022-12-13 | Japan | Osaka | 2370146 | 6852 | 0 | 34.620965 | 135.507481 | 2022-12-14 04:21:04 | Osaka, Japan | |||
3714258 | 3714258 | 2022-12-06 | Mexico | Guerrero | 116332 | 6852 | 0 | 17.4392 | -99.5451 | 2022-12-07 04:20:58 | Guerrero, Mexico | |||
2414963 | 2414963 | 2022-12-05 | Mexico | Guerrero | 116273 | 6852 | 0 | 17.4392 | -99.5451 | 2022-12-06 04:21:03 | Guerrero, Mexico | |||
2159817 | 2159817 | 2022-10-16 | Slovenia | 1215720 | 6852 | 0 | 46.1512 | 14.9955 | 2022-10-17 04:20:31 | Slovenia | ||||
3429074 | 3429074 | 2022-07-14 | Mexico | Yucatan | 128086 | 6852 | 0 | 20.7099 | -89.0943 | 2022-07-15 04:20:53 | Yucatan, Mexico | |||
2665470 | 2665470 | 2022-03-04 | Algeria | 265186 | 6852 | 0 | 28.0339 | 1.6596 | 2022-03-05 04:21:10 | Algeria | ||||
1113776 | 1113776 | 2022-01-11 | Russia | Altai Krai | 122891 | 6852 | 0 | 52.693224300000004 | 82.69314240000001 | 2022-01-12 04:21:44 | Altai Krai, Russia | |||
1256995 | 1256995 | 2021-12-20 | US | New York | Bronx | 36005 | 224238 | 6852 | 0 | 40.85209301 | -73.86282755 | 2021-12-21 03:21:27 | Bronx, New York, US | |
2905938 | 2905938 | 2021-12-19 | US | New York | Bronx | 36005 | 222771 | 6852 | 0 | 40.85209301 | -73.86282755 | 2021-12-20 04:21:43 | Bronx, New York, US | |
2398647 | 2398647 | 2021-12-17 | Colombia | Cundinamarca | 266876 | 6852 | 0 | 5.026 | -74.03 | 2021-12-18 02:22:20 | Cundinamarca, Colombia | |||
1716185 | 1716185 | 2021-12-16 | Colombia | Cundinamarca | 266847 | 6852 | 0 | 5.026 | -74.03 | 2021-12-17 04:22:14 | Cundinamarca, Colombia | |||
3639529 | 3639529 | 2021-11-08 | Italy | Puglia | 274354 | 6852 | 0 | 41.12559576 | 16.86736689 | 2021-11-09 04:21:36 | Puglia, Italy | |||
986957 | 986957 | 2021-10-04 | Italy | Sicilia | 299805 | 6852 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-05 04:21:27 | Sicilia, Italy | |||
1913164 | 1913164 | 2021-05-20 | India | Kerala | 2263959 | 6852 | 1938887 | 318220 | 10.450898 | 76.405749 | 2021-05-21 04:20:43 | Kerala, India | ||
3254303 | 3254303 | 2021-03-02 | Peru | Callao | 58532 | 6852 | 0 | 51680 | -11.954609 | -77.136042 | 2021-03-03 05:23:28 | Callao, Peru |
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]);