johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where active = 791 and country_or_region = "Russia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 12
country_or_region 1
- Russia · 15 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1893345 | 1893345 | 2021-06-30 | Russia | Kaliningrad Oblast | 36342 | 542 | 35009 | 791 | 54.7293041 | 21.1489473 | 2021-07-01 04:21:19 | Kaliningrad Oblast, Russia | ||
563177 | 563177 | 2021-06-22 | Russia | Kemerovo Oblast | 38682 | 782 | 37109 | 791 | 54.53357809999999 | 87.342861 | 2021-06-23 04:21:46 | Kemerovo Oblast, Russia | ||
83358 | 83358 | 2021-05-25 | Russia | Zabaykalsky Krai | 42996 | 661 | 41544 | 791 | 52.248521 | 115.956325 | 2021-05-26 04:20:35 | Zabaykalsky Krai, Russia | ||
3054385 | 3054385 | 2021-05-13 | Russia | Chuvashia Republic | 24878 | 1393 | 22694 | 791 | 55.4259922 | 47.0849429 | 2021-05-14 04:20:41 | Chuvashia Republic, Russia | ||
1425300 | 1425300 | 2021-05-09 | Russia | Irkutsk Oblast | 67331 | 2311 | 64229 | 791 | 56.6370122 | 104.719221 | 2021-05-10 04:20:38 | Irkutsk Oblast, Russia | ||
3675849 | 3675849 | 2021-05-04 | Russia | Irkutsk Oblast | 66715 | 2272 | 63652 | 791 | 56.6370122 | 104.719221 | 2021-05-05 04:20:43 | Irkutsk Oblast, Russia | ||
241445 | 241445 | 2021-04-02 | Russia | Buryatia Republic | 36096 | 790 | 34515 | 791 | 52.7182426 | 109.492143 | 2021-04-03 04:20:44 | Buryatia Republic, Russia | ||
3369523 | 3369523 | 2021-03-21 | Russia | Chuvashia Republic | 22342 | 1153 | 20398 | 791 | 55.4259922 | 47.0849429 | 2021-03-22 05:25:43 | Chuvashia Republic, Russia | ||
3421173 | 3421173 | 2021-03-19 | Russia | Tyva Republic | 15748 | 194 | 14763 | 791 | 51.4017149 | 93.8582593 | 2021-03-20 05:25:46 | Tyva Republic, Russia | ||
3117701 | 3117701 | 2020-10-06 | Russia | Lipetsk Oblast | 6366 | 47 | 5528 | 791 | 52.6935178 | 39.1122664 | 2020-10-07 04:23:40 | Lipetsk Oblast, Russia | ||
2849100 | 2849100 | 2020-09-18 | Russia | Zabaykalsky Krai | 5426 | 65 | 4570 | 791 | 52.248521 | 115.956325 | 2020-09-19 04:22:00 | Zabaykalsky Krai, Russia | ||
1173428 | 1173428 | 2020-09-10 | Russia | Tambov Oblast | 7012 | 46 | 6175 | 791 | 52.9019574 | 41.3578918 | 2020-09-11 04:46:23 | Tambov Oblast, Russia | ||
1612432 | 1612432 | 2020-08-14 | Russia | Belgorod Oblast | 6613 | 51 | 5771 | 791 | 50.7080119 | 37.5837615 | 2020-08-15 04:27:31 | Belgorod Oblast, Russia | ||
1920622 | 1920622 | 2020-08-10 | Russia | Tver Oblast | 4874 | 160 | 3923 | 791 | 57.1134475 | 35.174442799999994 | 2020-08-11 04:35:08 | Tver Oblast, Russia | ||
529886 | 529886 | 2020-07-04 | Russia | Karelia Republic | 1451 | 3 | 657 | 791 | 62.61940309999999 | 33.4920267 | 2020-07-05 04:33:46 | Karelia 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]);