johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 5269 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3798168 | 3798168 | 2022-08-20 | Russia | Tula Oblast | 166284 | 5269 | 0 | 53.9570701 | 37.3690909 | 2022-08-21 04:20:44 | Tula Oblast, Russia | |||
1421430 | 1421430 | 2022-06-08 | Sweden | Stockholm | 574412 | 5269 | 0 | 59.6025 | 18.1384 | 2022-06-09 04:20:54 | Stockholm, Sweden | |||
3726544 | 3726544 | 2022-06-07 | Sweden | Stockholm | 574412 | 5269 | 0 | 59.6025 | 18.1384 | 2022-06-08 04:20:55 | Stockholm, Sweden | |||
3887946 | 3887946 | 2022-06-06 | Sweden | Stockholm | 574412 | 5269 | 0 | 59.6025 | 18.1384 | 2022-06-07 04:21:08 | Stockholm, Sweden | |||
3507715 | 3507715 | 2022-06-05 | Sweden | Stockholm | 574412 | 5269 | 0 | 59.6025 | 18.1384 | 2022-06-06 04:20:57 | Stockholm, Sweden | |||
3527792 | 3527792 | 2022-06-04 | Sweden | Stockholm | 574412 | 5269 | 0 | 59.6025 | 18.1384 | 2022-06-05 04:20:55 | Stockholm, Sweden | |||
3133878 | 3133878 | 2022-06-03 | Sweden | Stockholm | 574412 | 5269 | 0 | 59.6025 | 18.1384 | 2022-06-04 04:20:58 | Stockholm, Sweden | |||
3578953 | 3578953 | 2022-06-02 | Sweden | Stockholm | 574412 | 5269 | 0 | 59.6025 | 18.1384 | 2022-06-03 04:20:58 | Stockholm, Sweden | |||
1157122 | 1157122 | 2022-04-29 | Italy | Liguria | 425640 | 5269 | 0 | 44.41149315 | 8.9326992 | 2022-04-30 04:21:05 | Liguria, Italy | |||
2171212 | 2171212 | 2022-01-01 | Ukraine | Zaporizhia Oblast | 182349 | 5269 | 0 | 47.8388 | 35.1396 | 2022-01-02 04:20:52 | Zaporizhia Oblast, Ukraine | |||
153009 | 153009 | 2021-11-29 | US | Texas | Bexar | 48029 | 331137 | 5269 | 0 | 29.44928723 | -98.52019748 | 2021-11-30 04:22:53 | Bexar, Texas, US | |
3007383 | 3007383 | 2021-10-11 | Lithuania | 354319 | 5269 | 0 | 55.1694 | 23.8813 | 2021-10-12 04:21:09 | Lithuania | ||||
2067592 | 2067592 | 2021-08-31 | Algeria | 196080 | 5269 | 0 | 28.0339 | 1.6596 | 2021-09-01 04:21:38 | Algeria | ||||
3109085 | 3109085 | 2021-08-24 | Ukraine | Kiev | 222731 | 5269 | 0 | 50.4501 | 30.5234 | 2021-08-25 04:21:41 | Kiev, Ukraine | |||
3169256 | 3169256 | 2021-08-23 | Ukraine | Kiev | 222599 | 5269 | 0 | 50.4501 | 30.5234 | 2021-08-24 04:21:19 | Kiev, Ukraine | |||
245138 | 245138 | 2021-08-17 | Costa Rica | 434081 | 5269 | 0 | 9.7489 | -83.7534 | 2021-08-18 04:21:35 | Costa Rica | ||||
1552068 | 1552068 | 2021-05-08 | Mexico | San Luis Potosi | 63073 | 5269 | 0 | 57804 | 22.1565 | -100.9855 | 2021-05-09 04:20:35 | San Luis Potosi, Mexico | ||
1936596 | 1936596 | 2021-02-23 | Pakistan | Punjab | 168891 | 5269 | 156821 | 6801 | 30.811346 | 72.13913199999998 | 2021-02-24 05:29:16 | Punjab, Pakistan | ||
202219 | 202219 | 2020-12-25 | India | Punjab | 164821 | 5269 | 154845 | 4707 | 30.841465000000003 | 75.40879 | 2020-12-26 05:22:28 | Punjab, India | ||
2918928 | 2918928 | 2020-11-04 | Brazil | Parana | 216266 | 5269 | 163730 | 47267 | -25.2521 | -52.0215 | 2020-11-05 06:05:03 | Parana, Brazil |
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]);