johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where deaths = 5063 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3989414 | 3989414 | 2022-09-15 | US | Puerto Rico | Unassigned | 72999 | 31628 | 5063 | 0 | 18.459681 | -67.336525 | 2022-09-16 04:21:19 | Unassigned, Puerto Rico, US | |
1160854 | 1160854 | 2022-08-18 | Australia | Victoria | 2531624 | 5063 | 0 | -37.8136 | 144.9631 | 2022-08-19 04:20:54 | Victoria, Australia | |||
160708 | 160708 | 2022-03-29 | US | Pennsylvania | Philadelphia | 42101 | 307693 | 5063 | 0 | 40.00338507 | -75.1379271 | 2022-03-30 04:20:45 | Philadelphia, Pennsylvania, US | |
129963 | 129963 | 2022-01-09 | US | Texas | Tarrant | 48439 | 427300 | 5063 | 0 | 32.77143818 | -97.29101614 | 2022-01-10 04:22:07 | Tarrant, Texas, US | |
1218798 | 1218798 | 2022-01-08 | US | Texas | Tarrant | 48439 | 424248 | 5063 | 0 | 32.77143818 | -97.29101614 | 2022-01-09 04:21:46 | Tarrant, Texas, US | |
1392891 | 1392891 | 2022-01-07 | US | Texas | Tarrant | 48439 | 419850 | 5063 | 0 | 32.77143818 | -97.29101614 | 2022-01-08 04:21:53 | Tarrant, Texas, US | |
1145234 | 1145234 | 2021-12-01 | Spain | Pais Vasco | 280444 | 5063 | 0 | 42.9896 | -2.6189 | 2021-12-02 04:22:37 | Pais Vasco, Spain | |||
1014616 | 1014616 | 2021-11-21 | Slovenia | 400685 | 5063 | 0 | 46.1512 | 14.9955 | 2021-11-22 04:22:20 | Slovenia | ||||
1385727 | 1385727 | 2021-09-13 | Mexico | Queretaro | 89557 | 5063 | 0 | 20.5888 | -100.3899 | 2021-09-14 04:21:41 | Queretaro, Mexico | |||
3105144 | 3105144 | 2021-08-24 | Algeria | 192626 | 5063 | 0 | 28.0339 | 1.6596 | 2021-08-25 04:21:41 | Algeria | ||||
589332 | 589332 | 2021-08-08 | Azerbaijan | 351825 | 5063 | 0 | 40.1431 | 47.5769 | 2021-08-09 04:21:24 | Azerbaijan | ||||
51352 | 51352 | 2021-05-29 | US | California | Orange | 6059 | 272059 | 5063 | 0 | 33.70147516 | -117.76459979999998 | 2021-05-30 04:20:55 | Orange, California, US | |
1153219 | 1153219 | 2021-02-18 | Mexico | Sinaloa | 33176 | 5063 | 0 | 28113 | 25.1721 | -107.4795 | 2021-02-19 05:24:16 | Sinaloa, Mexico | ||
1759443 | 1759443 | 2021-01-24 | Panama | 311244 | 5063 | 259095 | 47086 | 8.538 | -80.7821 | 2021-01-25 05:22:16 | Panama | |||
3491683 | 3491683 | 2020-07-13 | Ecuador | 68459 | 5063 | 30369 | 33027 | -1.8312 | -78.1834 | 2020-07-14 04:34:46 | Ecuador |
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]);