johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where deaths = 6039 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3276913 | 3276913 | 2022-10-23 | Latvia | 947539 | 6039 | 0 | 56.8796 | 24.6032 | 2022-10-24 04:22:29 | Latvia | ||||
2267951 | 2267951 | 2022-10-22 | Latvia | 947539 | 6039 | 0 | 56.8796 | 24.6032 | 2022-10-23 04:22:46 | Latvia | ||||
1592251 | 1592251 | 2022-10-21 | Latvia | 947539 | 6039 | 0 | 56.8796 | 24.6032 | 2022-10-22 04:22:53 | Latvia | ||||
2713212 | 2713212 | 2022-09-03 | Russia | Penza Oblast | 195604 | 6039 | 0 | 53.1655415 | 44.7879181 | 2022-09-04 04:21:22 | Penza Oblast, Russia | |||
3206369 | 3206369 | 2022-04-11 | Mexico | Tabasco | 189697 | 6039 | 0 | 17.8409 | -92.6189 | 2022-04-12 04:20:49 | Tabasco, Mexico | |||
1576255 | 1576255 | 2022-04-10 | Mexico | Tabasco | 189692 | 6039 | 0 | 17.8409 | -92.6189 | 2022-04-11 04:21:02 | Tabasco, Mexico | |||
1652497 | 1652497 | 2022-04-09 | Mexico | Tabasco | 189691 | 6039 | 0 | 17.8409 | -92.6189 | 2022-04-10 04:20:52 | Tabasco, Mexico | |||
2115819 | 2115819 | 2022-04-08 | Mexico | Tabasco | 189691 | 6039 | 0 | 17.8409 | -92.6189 | 2022-04-09 04:20:42 | Tabasco, Mexico | |||
3320343 | 3320343 | 2022-04-07 | Mexico | Tabasco | 189695 | 6039 | 0 | 17.8409 | -92.6189 | 2022-04-08 04:20:48 | Tabasco, Mexico | |||
2800879 | 2800879 | 2022-04-06 | Mexico | Tabasco | 189688 | 6039 | 0 | 17.8409 | -92.6189 | 2022-04-07 04:20:53 | Tabasco, Mexico | |||
3303275 | 3303275 | 2022-01-30 | US | Texas | Dallas | 48113 | 542113 | 6039 | 0 | 32.76670599 | -96.77796049999999 | 2022-01-31 04:21:09 | Dallas, Texas, US | |
3299901 | 3299901 | 2022-01-30 | Belarus | 740988 | 6039 | 0 | 53.7098 | 27.9534 | 2022-01-31 04:21:09 | Belarus | ||||
1668708 | 1668708 | 2021-12-29 | Russia | Stavropol Krai | 125237 | 6039 | 0 | 44.86325770000001 | 43.4406913 | 2021-12-30 04:21:25 | Stavropol Krai, Russia | |||
3816996 | 3816996 | 2021-12-23 | US | California | San Bernardino | 6071 | 388434 | 6039 | 0 | 34.84060306 | -116.1774685 | 2021-12-24 04:21:34 | San Bernardino, California, US | |
161765 | 161765 | 2021-11-19 | Brazil | Sergipe | 278676 | 6039 | 0 | -10.5741 | -37.3857 | 2021-11-20 04:22:17 | Sergipe, Brazil | |||
3809567 | 3809567 | 2021-09-11 | Uruguay | 386562 | 6039 | 0 | -32.5228 | -55.7658 | 2021-09-12 04:21:13 | Uruguay | ||||
103619 | 103619 | 2021-08-15 | Spain | Castilla - La Mancha | 221956 | 6039 | 0 | 39.2796 | -3.0977 | 2021-08-16 04:21:31 | Castilla - La Mancha, Spain | |||
507977 | 507977 | 2021-08-14 | Spain | Castilla - La Mancha | 221956 | 6039 | 0 | 39.2796 | -3.0977 | 2021-08-15 04:21:41 | Castilla - La Mancha, Spain | |||
1483849 | 1483849 | 2021-08-13 | Spain | Castilla - La Mancha | 221956 | 6039 | 0 | 39.2796 | -3.0977 | 2021-08-14 04:21:25 | Castilla - La Mancha, Spain | |||
3385383 | 3385383 | 2021-07-29 | Italy | Sicilia | 241335 | 6039 | 225821 | 9475 | 38.11569725 | 13.362356699999998 | 2021-07-30 04:21:34 | Sicilia, Italy | ||
2020704 | 2020704 | 2021-04-20 | Italy | Campania | 373499 | 6039 | 275673 | 91787 | 40.83956555 | 14.25084984 | 2021-04-21 04:21:14 | Campania, Italy | ||
1203952 | 1203952 | 2021-03-22 | Pakistan | Punjab | 200969 | 6039 | 178898 | 16032 | 30.811346 | 72.13913199999998 | 2021-03-23 05:26:18 | Punjab, Pakistan | ||
2055796 | 2055796 | 2021-03-15 | Germany | Hessen | 198778 | 6039 | 182124 | 10954 | 50.6521 | 9.1624 | 2021-03-16 05:25:13 | Hessen, Germany | ||
206587 | 206587 | 2020-08-19 | Turkey | 253108 | 6039 | 233915 | 13154 | 38.9637 | 35.2433 | 2020-08-20 04:27:43 | 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]);