johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where active = 642 and country_or_region = "Russia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 9
country_or_region 1
- Russia · 10 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468400 | 3468400 | 2021-08-03 | Russia | Magadan Oblast | 9578 | 162 | 8774 | 642 | 62.48858785 | 153.9903764 | 2021-08-04 04:21:25 | Magadan Oblast, Russia | ||
1495821 | 1495821 | 2021-07-03 | Russia | Kurgan Oblast | 22607 | 451 | 21514 | 642 | 55.7655302 | 64.5632681 | 2021-07-04 04:21:38 | Kurgan Oblast, Russia | ||
1564322 | 1564322 | 2021-06-14 | Russia | Novgorod Oblast | 31469 | 182 | 30645 | 642 | 58.2843833 | 32.5169757 | 2021-06-15 04:22:22 | Novgorod Oblast, Russia | ||
1806996 | 1806996 | 2021-05-27 | Russia | Tomsk Oblast | 32760 | 431 | 31687 | 642 | 58.6124279 | 82.04753149999998 | 2021-05-28 04:20:36 | Tomsk Oblast, Russia | ||
1771593 | 1771593 | 2021-05-23 | Russia | Tomsk Oblast | 32662 | 426 | 31594 | 642 | 58.6124279 | 82.04753149999998 | 2021-05-24 04:20:53 | Tomsk Oblast, Russia | ||
2626070 | 2626070 | 2021-01-10 | Russia | Jewish Autonomous Okrug | 3895 | 77 | 3176 | 642 | 48.57527615 | 132.66307460000002 | 2021-01-11 05:21:50 | Jewish Autonomous Okrug, Russia | ||
3778086 | 3778086 | 2020-12-27 | Russia | Altai Republic | 13624 | 95 | 12887 | 642 | 50.7114101 | 86.8572186 | 2020-12-28 05:22:06 | Altai Republic, Russia | ||
2729200 | 2729200 | 2020-09-15 | Russia | Kabardino-Balkarian Republic | 7023 | 83 | 6298 | 642 | 43.4806048 | 43.5978976 | 2020-09-16 04:22:53 | Kabardino-Balkarian Republic, Russia | ||
609876 | 609876 | 2020-08-29 | Russia | Chechen Republic | 2258 | 38 | 1578 | 642 | 43.39761470000001 | 45.6985005 | 2020-08-30 04:28:22 | Chechen Republic, Russia | ||
146231 | 146231 | 2020-08-15 | Russia | Yaroslavl Oblast | 6616 | 32 | 5942 | 642 | 57.77819760000001 | 39.0021095 | 2020-08-16 04:27:42 | Yaroslavl 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]);