johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where active = 93 and country_or_region = "Russia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 4
country_or_region 1
- Russia · 9 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1736764 | 1736764 | 2021-06-12 | Russia | Tyva Republic | 16031 | 203 | 15735 | 93 | 51.4017149 | 93.8582593 | 2021-06-13 04:22:44 | Tyva Republic, Russia | ||
726718 | 726718 | 2021-05-22 | Russia | Magadan Oblast | 8421 | 107 | 8221 | 93 | 62.48858785 | 153.9903764 | 2021-05-23 04:20:51 | Magadan Oblast, Russia | ||
1913432 | 1913432 | 2021-05-20 | Russia | Magadan Oblast | 8412 | 106 | 8213 | 93 | 62.48858785 | 153.9903764 | 2021-05-21 04:20:43 | Magadan Oblast, Russia | ||
3254346 | 3254346 | 2021-03-02 | Russia | Jewish Autonomous Okrug | 4330 | 119 | 4118 | 93 | 48.57527615 | 132.66307460000002 | 2021-03-03 05:23:28 | Jewish Autonomous Okrug, Russia | ||
998638 | 998638 | 2021-03-01 | Russia | Jewish Autonomous Okrug | 4326 | 119 | 4114 | 93 | 48.57527615 | 132.66307460000002 | 2021-03-02 05:23:30 | Jewish Autonomous Okrug, Russia | ||
998665 | 998665 | 2021-03-01 | Russia | Nenets Autonomous Okrug | 1023 | 3 | 927 | 93 | 68.27557185 | 57.1686375 | 2021-03-02 05:23:30 | Nenets Autonomous Okrug, Russia | ||
3778129 | 3778129 | 2020-12-27 | Russia | Nenets Autonomous Okrug | 775 | 0 | 682 | 93 | 68.27557185 | 57.1686375 | 2020-12-28 05:22:06 | Nenets Autonomous Okrug, Russia | ||
2171744 | 2171744 | 2020-09-09 | Russia | Jewish Autonomous Okrug | 693 | 9 | 591 | 93 | 48.57527615 | 132.66307460000002 | 2020-09-10 04:29:01 | Jewish Autonomous Okrug, Russia | ||
217148 | 217148 | 2020-06-08 | Russia | Jewish Autonomous Okrug | 347 | 4 | 250 | 93 | 48.57527615 | 132.66307460000002 | 2020-06-09 03:33:03 | Jewish Autonomous Okrug, 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]);