johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where deaths = 5747 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3213984 | 3213984 | 2022-10-12 | Australia | Victoria | 2628125 | 5747 | 0 | -37.8136 | 144.9631 | 2022-10-13 04:22:39 | Victoria, Australia | |||
1608157 | 1608157 | 2022-07-20 | Germany | Brandenburg | 861297 | 5747 | 0 | 52.4125 | 12.5316 | 2022-07-21 04:21:10 | Brandenburg, Germany | |||
2155333 | 2155333 | 2022-07-16 | Venezuela | 529730 | 5747 | 0 | 6.4238 | -66.5897 | 2022-07-17 04:21:15 | Venezuela | ||||
593440 | 593440 | 2022-07-01 | Chile | Valparaiso | 367933 | 5747 | 0 | -33.0472 | -71.6127 | 2022-07-02 04:21:16 | Valparaiso, Chile | |||
1413051 | 1413051 | 2021-05-24 | Italy | Sicilia | 223270 | 5747 | 204507 | 13016 | 38.11569725 | 13.362356699999998 | 2021-05-25 04:21:08 | Sicilia, Italy | ||
2983238 | 2983238 | 2021-04-10 | Italy | Campania | 355186 | 5747 | 258061 | 91378 | 40.83956555 | 14.25084984 | 2021-04-11 04:20:56 | Campania, Italy | ||
1290296 | 1290296 | 2021-03-29 | Spain | Castilla - La Mancha | 175310 | 5747 | 6392 | 163171 | 39.2796 | -3.0977 | 2021-03-30 04:26:23 | Castilla - La Mancha, Spain | ||
1222669 | 1222669 | 2021-03-27 | US | Texas | Harris | 48201 | 441276 | 5747 | 0 | 29.85864939 | -95.39339521 | 2021-03-28 05:28:10 | Harris, Texas, US | |
1857743 | 1857743 | 2021-02-25 | Brazil | Mato Grosso | 248444 | 5747 | 231331 | 9693 | -12.6819 | -56.9211 | 2021-02-26 05:22:40 | Mato Grosso, Brazil | ||
12076 | 12076 | 2021-01-26 | Brazil | Espirito Santo | 288360 | 5747 | 269532 | 12990 | -19.1834 | -40.3089 | 2021-01-27 05:23:41 | Espirito Santo, Brazil | ||
2406829 | 2406829 | 2020-12-23 | Italy | Veneto | 225945 | 5747 | 116872 | 103326 | 45.43490485 | 12.33845213 | 2020-12-24 05:23:04 | Veneto, Italy | ||
1177215 | 1177215 | 2020-10-22 | Bangladesh | 394827 | 5747 | 310532 | 78548 | 23.685 | 90.3563 | 2020-10-23 04:24:46 | Bangladesh | |||
2740633 | 2740633 | 2020-08-03 | Turkey | 233851 | 5747 | 217497 | 10607 | 38.9637 | 35.2433 | 2020-08-04 04:41:59 | Turkey |
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]);