johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where deaths = 213 and province_or_state = "Kamchatka Krai" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1568310 | 1568310 | 2021-04-22 | Russia | Kamchatka Krai | 14380 | 213 | 13729 | 438 | 57.1914882 | 160.03838190000005 | 2021-04-23 04:20:52 | Kamchatka Krai, Russia | ||
3242531 | 3242531 | 2021-04-21 | Russia | Kamchatka Krai | 14371 | 213 | 13719 | 439 | 57.1914882 | 160.03838190000005 | 2021-04-22 04:20:53 | Kamchatka Krai, Russia | ||
2020927 | 2020927 | 2021-04-20 | Russia | Kamchatka Krai | 14362 | 213 | 13704 | 445 | 57.1914882 | 160.03838190000005 | 2021-04-21 04:21:14 | Kamchatka Krai, Russia | ||
2411048 | 2411048 | 2021-04-19 | Russia | Kamchatka Krai | 14352 | 213 | 13691 | 448 | 57.1914882 | 160.03838190000005 | 2021-04-20 04:20:41 | Kamchatka Krai, Russia | ||
3129725 | 3129725 | 2021-04-18 | Russia | Kamchatka Krai | 14343 | 213 | 13676 | 454 | 57.1914882 | 160.03838190000005 | 2021-04-19 04:20:57 | Kamchatka Krai, Russia | ||
983153 | 983153 | 2021-04-17 | Russia | Kamchatka Krai | 14333 | 213 | 13655 | 465 | 57.1914882 | 160.03838190000005 | 2021-04-18 04:20:41 | Kamchatka Krai, Russia | ||
170248 | 170248 | 2021-04-16 | Russia | Kamchatka Krai | 14323 | 213 | 13636 | 474 | 57.1914882 | 160.03838190000005 | 2021-04-17 04:20:40 | Kamchatka Krai, Russia | ||
2549079 | 2549079 | 2021-04-15 | Russia | Kamchatka Krai | 14312 | 213 | 13619 | 480 | 57.1914882 | 160.03838190000005 | 2021-04-16 04:20:46 | Kamchatka Krai, Russia | ||
1842149 | 1842149 | 2021-04-14 | Russia | Kamchatka Krai | 14301 | 213 | 13593 | 495 | 57.1914882 | 160.03838190000005 | 2021-04-15 04:20:54 | Kamchatka Krai, Russia | ||
2571883 | 2571883 | 2021-04-13 | Russia | Kamchatka Krai | 14289 | 213 | 13574 | 502 | 57.1914882 | 160.03838190000005 | 2021-04-14 04:20:41 | Kamchatka Krai, Russia | ||
36634 | 36634 | 2021-04-12 | Russia | Kamchatka Krai | 14276 | 213 | 13548 | 515 | 57.1914882 | 160.03838190000005 | 2021-04-13 04:20:37 | Kamchatka Krai, Russia | ||
3883793 | 3883793 | 2021-04-11 | Russia | Kamchatka Krai | 14265 | 213 | 13521 | 531 | 57.1914882 | 160.03838190000005 | 2021-04-12 04:21:00 | Kamchatka Krai, Russia | ||
2983461 | 2983461 | 2021-04-10 | Russia | Kamchatka Krai | 14253 | 213 | 13496 | 544 | 57.1914882 | 160.03838190000005 | 2021-04-11 04:20:56 | Kamchatka Krai, Russia | ||
605893 | 605893 | 2021-04-09 | Russia | Kamchatka Krai | 14241 | 213 | 13474 | 554 | 57.1914882 | 160.03838190000005 | 2021-04-10 04:20:59 | Kamchatka Krai, Russia |
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]);