johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where deaths = 9229 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3908053 | 3908053 | 2022-08-11 | Lithuania | 1197416 | 9229 | 0 | 55.1694 | 23.8813 | 2022-08-12 04:20:54 | Lithuania | ||||
1070229 | 1070229 | 2022-08-07 | Taiwan* | 4738861 | 9229 | 0 | 23.7 | 121.0 | 2022-08-08 04:21:08 | Taiwan* | ||||
2419167 | 2419167 | 2022-07-15 | Saudi Arabia | 802586 | 9229 | 0 | 23.885942 | 45.079162 | 2022-07-16 04:21:05 | Saudi Arabia | ||||
1846143 | 1846143 | 2022-04-18 | Peru | Lambayeque | 105508 | 9229 | 0 | -6.3530489999999995 | -79.824113 | 2022-04-19 04:21:00 | Lambayeque, Peru | |||
3417087 | 3417087 | 2022-04-17 | Peru | Lambayeque | 105508 | 9229 | 0 | -6.3530489999999995 | -79.824113 | 2022-04-18 04:21:12 | Lambayeque, Peru | |||
304036 | 304036 | 2022-04-16 | Peru | Lambayeque | 105508 | 9229 | 0 | -6.3530489999999995 | -79.824113 | 2022-04-17 04:20:59 | Lambayeque, Peru | |||
2669981 | 2669981 | 2022-04-15 | Peru | Lambayeque | 105508 | 9229 | 0 | -6.3530489999999995 | -79.824113 | 2022-04-16 04:20:48 | Lambayeque, Peru | |||
1223766 | 1223766 | 2022-04-14 | Peru | Lambayeque | 105508 | 9229 | 0 | -6.3530489999999995 | -79.824113 | 2022-04-15 04:20:57 | Lambayeque, Peru | |||
2442924 | 2442924 | 2022-04-13 | Peru | Lambayeque | 105508 | 9229 | 0 | -6.3530489999999995 | -79.824113 | 2022-04-13 23:21:06 | Lambayeque, Peru | |||
1948681 | 1948681 | 2022-04-12 | Peru | Lambayeque | 105508 | 9229 | 0 | -6.3530489999999995 | -79.824113 | 2022-04-13 04:21:03 | Lambayeque, Peru | |||
3206434 | 3206434 | 2022-04-11 | Peru | Lambayeque | 105508 | 9229 | 0 | -6.3530489999999995 | -79.824113 | 2022-04-12 04:20:49 | Lambayeque, Peru | |||
3655825 | 3655825 | 2021-12-10 | Russia | Nizhny Novgorod Oblast | 220931 | 9229 | 0 | 55.47180329999999 | 44.091159399999995 | 2021-12-11 04:22:45 | Nizhny Novgorod Oblast, Russia | |||
1599965 | 1599965 | 2020-12-10 | Brazil | Pernambuco | 195118 | 9229 | 170601 | 15288 | -8.8137 | -36.9541 | 2020-12-11 05:26:59 | Pernambuco, 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]);