johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where country_or_region = "Iceland" and deaths = 28 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, day (date), last_update (date)
country_or_region 1
- Iceland · 21 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3761519 | 3761519 | 2020-12-28 | Iceland | 5726 | 28 | 5555 | 143 | 64.9631 | -19.0208 | 2020-12-29 05:22:37 | Iceland | |||
3777839 | 3777839 | 2020-12-27 | Iceland | 5683 | 28 | 5506 | 149 | 64.9631 | -19.0208 | 2020-12-28 05:22:06 | Iceland | |||
2223444 | 2223444 | 2020-12-26 | Iceland | 5683 | 28 | 5506 | 149 | 64.9631 | -19.0208 | 2020-12-27 05:22:55 | Iceland | |||
202191 | 202191 | 2020-12-25 | Iceland | 5683 | 28 | 5506 | 149 | 64.9631 | -19.0208 | 2020-12-26 05:22:28 | Iceland | |||
3691414 | 3691414 | 2020-12-24 | Iceland | 5683 | 28 | 5506 | 149 | 64.9631 | -19.0208 | 2020-12-25 05:22:48 | Iceland | |||
2406766 | 2406766 | 2020-12-23 | Iceland | 5683 | 28 | 5506 | 149 | 64.9631 | -19.0208 | 2020-12-24 05:23:04 | Iceland | |||
3769812 | 3769812 | 2020-12-22 | Iceland | 5667 | 28 | 5500 | 139 | 64.9631 | -19.0208 | 2020-12-23 05:22:03 | Iceland | |||
927628 | 927628 | 2020-12-21 | Iceland | 5656 | 28 | 5487 | 141 | 64.9631 | -19.0208 | 2020-12-22 05:22:33 | Iceland | |||
2119649 | 2119649 | 2020-12-20 | Iceland | 5642 | 28 | 5478 | 136 | 64.9631 | -19.0208 | 2020-12-21 05:27:58 | Iceland | |||
2931156 | 2931156 | 2020-12-19 | Iceland | 5621 | 28 | 5467 | 126 | 64.9631 | -19.0208 | 2020-12-20 05:27:32 | Iceland | |||
1901102 | 1901102 | 2020-12-18 | Iceland | 5604 | 28 | 5449 | 127 | 64.9631 | -19.0208 | 2020-12-19 05:27:52 | Iceland | |||
2127928 | 2127928 | 2020-12-17 | Iceland | 5588 | 28 | 5423 | 137 | 64.9631 | -19.0208 | 2020-12-18 05:28:18 | Iceland | |||
3149528 | 3149528 | 2020-12-16 | Iceland | 5578 | 28 | 5421 | 129 | 64.9631 | -19.0208 | 2020-12-17 05:28:12 | Iceland | |||
1034309 | 1034309 | 2020-12-15 | Iceland | 5571 | 28 | 5401 | 142 | 64.9631 | -19.0208 | 2020-12-16 05:28:04 | Iceland | |||
1751203 | 1751203 | 2020-12-14 | Iceland | 5564 | 28 | 5392 | 144 | 64.9631 | -19.0208 | 2020-12-15 05:26:38 | Iceland | |||
3847723 | 3847723 | 2020-12-13 | Iceland | 5557 | 28 | 5366 | 163 | 64.9631 | -19.0208 | 2020-12-14 05:26:27 | Iceland | |||
845505 | 845505 | 2020-12-12 | Iceland | 5552 | 28 | 5346 | 178 | 64.9631 | -19.0208 | 2020-12-13 05:27:20 | Iceland | |||
860612 | 860612 | 2020-12-11 | Iceland | 5539 | 28 | 5323 | 188 | 64.9631 | -19.0208 | 2020-12-12 05:26:19 | Iceland | |||
1600154 | 1600154 | 2020-12-10 | Iceland | 5524 | 28 | 5313 | 183 | 64.9631 | -19.0208 | 2020-12-11 05:26:59 | Iceland | |||
2975163 | 2975163 | 2020-12-09 | Iceland | 5516 | 28 | 5302 | 186 | 64.9631 | -19.0208 | 2020-12-10 05:26:19 | Iceland | |||
1818723 | 1818723 | 2020-12-08 | Iceland | 5506 | 28 | 5292 | 186 | 64.9631 | -19.0208 | 2020-12-09 05:28:01 | 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]);