johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where country_or_region = "Iceland" and deaths = 35 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, day (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1660345 | 1660345 | 2021-12-12 | Iceland | 19159 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-13 04:22:02 | Iceland | ||||
1664361 | 1664361 | 2021-12-11 | Iceland | 19159 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-12 04:22:12 | Iceland | ||||
3655513 | 3655513 | 2021-12-10 | Iceland | 19159 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-11 04:22:45 | Iceland | ||||
1077844 | 1077844 | 2021-12-09 | Iceland | 19052 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-10 04:22:28 | Iceland | ||||
550693 | 550693 | 2021-12-08 | Iceland | 18896 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-09 04:22:49 | Iceland | ||||
404213 | 404213 | 2021-12-07 | Iceland | 18765 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-08 04:22:46 | Iceland | ||||
1030295 | 1030295 | 2021-12-06 | Iceland | 18642 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-07 04:22:34 | Iceland | ||||
1740458 | 1740458 | 2021-12-05 | Iceland | 18333 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-06 04:22:34 | Iceland | ||||
137890 | 137890 | 2021-12-04 | Iceland | 18333 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-05 04:22:25 | Iceland | ||||
2195543 | 2195543 | 2021-12-03 | Iceland | 18333 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-04 04:22:18 | Iceland | ||||
249 | 249 | 2021-12-02 | Iceland | 18198 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-03 04:23:05 | Iceland | ||||
1144848 | 1144848 | 2021-12-01 | Iceland | 18055 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-02 04:22:37 | Iceland | ||||
3401360 | 3401360 | 2021-11-30 | Iceland | 17894 | 35 | 0 | 64.9631 | -19.0208 | 2021-12-01 04:22:29 | Iceland | ||||
149903 | 149903 | 2021-11-29 | Iceland | 17770 | 35 | 0 | 64.9631 | -19.0208 | 2021-11-30 04:22:53 | Iceland | ||||
1231549 | 1231549 | 2021-11-28 | Iceland | 17446 | 35 | 0 | 64.9631 | -19.0208 | 2021-11-29 04:22:30 | Iceland | ||||
1358256 | 1358256 | 2021-11-27 | Iceland | 17446 | 35 | 0 | 64.9631 | -19.0208 | 2021-11-28 04:22:43 | Iceland | ||||
758247 | 758247 | 2021-11-26 | Iceland | 17446 | 35 | 0 | 64.9631 | -19.0208 | 2021-11-27 04:22:45 | Iceland | ||||
1802664 | 1802664 | 2021-11-25 | Iceland | 17294 | 35 | 0 | 64.9631 | -19.0208 | 2021-11-26 04:22:33 | Iceland | ||||
904098 | 904098 | 2021-11-24 | Iceland | 17152 | 35 | 0 | 64.9631 | -19.0208 | 2021-11-25 04:22:33 | Iceland |
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]);