johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where deaths = 8450 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1608352 | 1608352 | 2022-07-20 | Mexico | Hidalgo | 106250 | 8450 | 0 | 20.0911 | -98.7624 | 2022-07-21 04:21:10 | Hidalgo, Mexico | |||
1169401 | 1169401 | 2022-05-20 | Russia | Irkutsk Oblast | 293147 | 8450 | 0 | 56.6370122 | 104.719221 | 2022-05-21 04:20:58 | Irkutsk Oblast, Russia | |||
3896164 | 3896164 | 2022-05-19 | Russia | Irkutsk Oblast | 293038 | 8450 | 0 | 56.6370122 | 104.719221 | 2022-05-20 04:20:57 | Irkutsk Oblast, Russia | |||
1184948 | 1184948 | 2022-05-18 | Russia | Irkutsk Oblast | 292949 | 8450 | 0 | 56.6370122 | 104.719221 | 2022-05-19 04:20:54 | Irkutsk Oblast, Russia | |||
3073902 | 3073902 | 2022-02-09 | Cuba | 1056846 | 8450 | 0 | 21.521757 | -77.78116700000002 | 2022-02-10 04:21:14 | Cuba | ||||
71174 | 71174 | 2022-02-07 | Mexico | Coahuila | 139337 | 8450 | 0 | 27.0587 | -101.7068 | 2022-02-08 04:21:15 | Coahuila, Mexico | |||
1668423 | 1668423 | 2021-12-29 | Italy | Campania | 557183 | 8450 | 0 | 40.83956555 | 14.25084984 | 2021-12-30 04:21:25 | Campania, Italy | |||
2963335 | 2963335 | 2021-12-24 | India | Odisha | 1053645 | 8450 | 0 | 20.505428 | 84.418059 | 2021-12-25 04:21:37 | Odisha, India | |||
2721103 | 2721103 | 2021-10-30 | Mexico | Sonora | 111992 | 8450 | 0 | 29.2972 | -110.3309 | 2021-10-31 04:22:08 | Sonora, Mexico | |||
2104093 | 2104093 | 2021-06-01 | India | Rajasthan | 940960 | 8450 | 895033 | 37477 | 26.583423 | 73.847973 | 2021-06-02 04:24:34 | Rajasthan, India | ||
726232 | 726232 | 2021-05-22 | Brazil | Distrito Federal | 397715 | 8450 | 378885 | 10380 | -15.7998 | -47.8645 | 2021-05-23 04:20:51 | Distrito Federal, Brazil | ||
3539571 | 3539571 | 2021-02-12 | Morocco | 477656 | 8450 | 457956 | 11250 | 31.7917 | -7.0926 | 2021-02-13 05:22:12 | Morocco | |||
442553 | 442553 | 2020-07-26 | Spain | Madrid | 73944 | 8450 | 40736 | 24758 | 40.4168 | -3.7038 | 2020-07-27 04:35:02 | Madrid, Spain | ||
1502797 | 1502797 | 2020-07-25 | Spain | Madrid | 73944 | 8450 | 40736 | 24758 | 40.4168 | -3.7038 | 2020-07-26 04:35:00 | Madrid, Spain | ||
2563767 | 2563767 | 2020-07-24 | Spain | Madrid | 73944 | 8450 | 40736 | 24758 | 40.4168 | -3.7038 | 2020-07-25 04:47:39 | Madrid, Spain | ||
61985 | 61985 | 2020-07-23 | Spain | Madrid | 73767 | 8450 | 40736 | 24581 | 40.4168 | -3.7038 | 2020-07-24 05:30:40 | Madrid, Spain |
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]);