johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where deaths = 5653 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
593694 | 593694 | 2022-07-01 | Kenya | 333952 | 5653 | 0 | -0.0236 | 37.9062 | 2022-07-02 04:21:16 | Kenya | ||||
3896154 | 3896154 | 2022-05-19 | Russia | Bashkortostan Republic | 287512 | 5653 | 0 | 54.8573563 | 57.1439682 | 2022-05-20 04:20:57 | Bashkortostan Republic, Russia | |||
2528596 | 2528596 | 2022-03-02 | US | Texas | Tarrant | 48439 | 558677 | 5653 | 0 | 32.77143818 | -97.29101614 | 2022-03-03 04:21:01 | Tarrant, Texas, US | |
1281683 | 1281683 | 2022-01-05 | Belarus | 703507 | 5653 | 0 | 53.7098 | 27.9534 | 2022-01-06 04:22:09 | Belarus | ||||
1668553 | 1668553 | 2021-12-29 | Mexico | Oaxaca | 83925 | 5653 | 0 | 17.0732 | -96.7266 | 2021-12-30 04:21:25 | Oaxaca, Mexico | |||
1258886 | 1258886 | 2021-12-18 | Mexico | Queretaro | 99666 | 5653 | 0 | 20.5888 | -100.3899 | 2021-12-19 04:21:11 | Queretaro, Mexico | |||
447938 | 447938 | 2021-11-17 | US | California | Orange | 6059 | 331322 | 5653 | 0 | 33.70147516 | -117.76459979999998 | 2021-11-18 04:21:33 | Orange, California, US | |
538363 | 538363 | 2021-10-27 | Ukraine | Dnipropetrovsk Oblast | 180265 | 5653 | 0 | 48.4647 | 35.0462 | 2021-10-28 04:22:08 | Dnipropetrovsk Oblast, Ukraine | |||
3113574 | 3113574 | 2021-05-06 | Mexico | Michoacan | 47467 | 5653 | 0 | 41814 | 19.5665 | -101.7068 | 2021-05-07 04:20:40 | Michoacan, Mexico | ||
2247376 | 2247376 | 2021-04-07 | Italy | Campania | 348959 | 5653 | 252199 | 91107 | 40.83956555 | 14.25084984 | 2021-04-08 04:21:13 | Campania, Italy | ||
613651 | 613651 | 2021-02-08 | India | Punjab | 174838 | 5653 | 167073 | 2112 | 30.841465000000003 | 75.40879 | 2021-02-09 05:23:30 | Punjab, India | ||
2689626 | 2689626 | 2020-10-08 | India | Delhi | 300833 | 5653 | 272948 | 22232 | 28.646519 | 77.10898 | 2020-10-09 04:23:59 | Delhi, India |
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]);