johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where active = 1090 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 · 17 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3137759 | 3137759 | 2021-07-23 | Russia | Karachay-Cherkess Republic | 21926 | 255 | 20581 | 1090 | 43.7368326 | 41.7267991 | 2021-07-24 00:21:36 | Karachay-Cherkess Republic, Russia | ||
2020975 | 2020975 | 2021-04-20 | Russia | Tver Oblast | 39197 | 832 | 37275 | 1090 | 57.1134475 | 35.174442799999994 | 2021-04-21 04:21:14 | Tver Oblast, Russia | ||
3421109 | 3421109 | 2021-03-19 | Russia | Buryatia Republic | 35291 | 752 | 33449 | 1090 | 52.7182426 | 109.492143 | 2021-03-20 05:25:46 | Buryatia Republic, Russia | ||
471607 | 471607 | 2021-02-19 | Russia | Dagestan Republic | 29351 | 1316 | 26945 | 1090 | 43.05749160000001 | 47.1332224 | 2021-02-20 05:22:51 | Dagestan Republic, Russia | ||
1062041 | 1062041 | 2021-01-04 | Russia | Chuvashia Republic | 16805 | 570 | 15145 | 1090 | 55.4259922 | 47.0849429 | 2021-01-05 05:21:49 | Chuvashia Republic, Russia | ||
1046062 | 1046062 | 2020-09-30 | Russia | Tatarstan Republic | 7230 | 48 | 6092 | 1090 | 55.7648572 | 52.43104273 | 2020-10-01 04:23:42 | Tatarstan Republic, Russia | ||
2614264 | 2614264 | 2020-09-26 | Russia | Orenburg Oblast | 12438 | 82 | 11266 | 1090 | 52.0269262 | 54.7276647 | 2020-09-27 04:23:00 | Orenburg Oblast, Russia | ||
1243959 | 1243959 | 2020-09-08 | Russia | Karachay-Cherkess Republic | 5586 | 28 | 4468 | 1090 | 43.7368326 | 41.7267991 | 2020-09-09 04:28:48 | Karachay-Cherkess Republic, Russia | ||
813755 | 813755 | 2020-09-05 | Russia | Altai Krai | 12033 | 123 | 10820 | 1090 | 52.6932243 | 82.69314240000001 | 2020-09-06 04:28:33 | Altai Krai, Russia | ||
3562782 | 3562782 | 2020-08-25 | Russia | Kursk Oblast | 6941 | 53 | 5798 | 1090 | 51.6568453 | 36.4852695 | 2020-08-26 04:28:11 | Kursk Oblast, Russia | ||
2991498 | 2991498 | 2020-08-24 | Russia | Novgorod Oblast | 4195 | 72 | 3033 | 1090 | 58.2843833 | 32.5169757 | 2020-08-25 04:28:02 | Novgorod Oblast, Russia | ||
2299695 | 2299695 | 2020-08-22 | Russia | Tatarstan Republic | 6250 | 32 | 5128 | 1090 | 55.7648572 | 52.43104273 | 2020-08-23 04:27:48 | Tatarstan Republic, Russia | ||
3178222 | 3178222 | 2020-08-18 | Russia | Kursk Oblast | 6711 | 51 | 5570 | 1090 | 51.6568453 | 36.4852695 | 2020-08-19 04:27:00 | Kursk Oblast, Russia | ||
3436161 | 3436161 | 2020-07-11 | Russia | Ryazan Oblast | 5621 | 21 | 4510 | 1090 | 54.42267320000001 | 40.57052460000001 | 2020-07-12 04:34:30 | Ryazan Oblast, Russia | ||
2234348 | 2234348 | 2020-07-03 | Russia | Altai Krai | 4207 | 40 | 3077 | 1090 | 52.6932243 | 82.69314240000001 | 2020-07-04 04:33:51 | Altai Krai, Russia | ||
1136364 | 1136364 | 2020-06-26 | Russia | Zabaykalsky Krai | 2854 | 41 | 1723 | 1090 | 52.248521 | 115.956325 | 2020-06-27 04:33:35 | Zabaykalsky Krai, Russia | ||
2700991 | 2700991 | 2020-06-24 | Russia | Zabaykalsky Krai | 2738 | 40 | 1608 | 1090 | 52.248521 | 115.956325 | 2020-06-25 05:26:54 | Zabaykalsky Krai, 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]);