johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6 rows where active = 2241 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
778575 | 778575 | 2021-07-08 | Russia | Kirov Oblast | 47653 | 399 | 45013 | 2241 | 57.9665589 | 49.4074599 | 2021-07-09 04:21:21 | Kirov Oblast, Russia | ||
1732727 | 1732727 | 2021-03-14 | Russia | Orel Oblast | 31374 | 475 | 28658 | 2241 | 52.96854329999999 | 36.0692477 | 2021-03-15 05:25:51 | Orel Oblast, Russia | ||
998627 | 998627 | 2021-03-01 | Russia | Belgorod Oblast | 31541 | 487 | 28813 | 2241 | 50.7080119 | 37.5837615 | 2021-03-02 05:23:30 | Belgorod Oblast, Russia | ||
546975 | 546975 | 2020-09-12 | Russia | Murmansk Oblast | 13628 | 180 | 11207 | 2241 | 68.00004179999999 | 33.9999151 | 2020-09-13 04:30:52 | Murmansk Oblast, Russia | ||
2708752 | 2708752 | 2020-07-17 | Russia | Samara Oblast | 6197 | 73 | 3883 | 2241 | 53.2128813 | 50.8914633 | 2020-07-18 04:34:45 | Samara Oblast, Russia | ||
2222872 | 2222872 | 2020-07-08 | Russia | Samara Oblast | 5576 | 59 | 3276 | 2241 | 53.2128813 | 50.8914633 | 2020-07-09 04:34:23 | Samara Oblast, 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]);