johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where active = 1855 and country_or_region = "Russia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 5
country_or_region 1
- Russia · 6 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296398 | 3296398 | 2021-07-30 | Russia | Kursk Oblast | 46260 | 1086 | 43319 | 1855 | 51.6568453 | 36.4852695 | 2021-07-31 04:21:35 | Kursk Oblast, Russia | ||
860908 | 860908 | 2020-12-11 | Russia | Orel Oblast | 17810 | 221 | 15734 | 1855 | 52.96854329999999 | 36.0692477 | 2020-12-12 05:26:19 | Orel Oblast, Russia | ||
3782117 | 3782117 | 2020-10-13 | Russia | Kursk Oblast | 9021 | 60 | 7106 | 1855 | 51.6568453 | 36.4852695 | 2020-10-14 04:24:05 | Kursk Oblast, Russia | ||
427551 | 427551 | 2020-09-07 | Russia | Leningrad Oblast | 7049 | 83 | 5111 | 1855 | 60.1853296 | 32.3925325 | 2020-09-08 04:28:25 | Leningrad Oblast, Russia | ||
813829 | 813829 | 2020-09-05 | Russia | Ulyanovsk Oblast | 12550 | 111 | 10584 | 1855 | 54.1463177 | 47.2324921 | 2020-09-06 04:28:33 | Ulyanovsk Oblast, Russia | ||
1195833 | 1195833 | 2020-06-17 | Russia | Karachay-Cherkess Republic | 2446 | 9 | 582 | 1855 | 43.7368326 | 41.7267991 | 2020-06-18 04:33:18 | Karachay-Cherkess Republic, 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]);