johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

83 rows where country_or_region = "Russia" and "last_update" is on date 2020-08-01 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

country_or_region 1

  • Russia · 83 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
3264441 3264441 2020-07-31 Russia Adygea Republic     2747 20 2112 615 44.6939006 40.1520421 2020-08-01 04:36:27 Adygea Republic, Russia
3264447 3264447 2020-07-31 Russia Altai Krai     9109 66 7193 1850 52.693224300000004 82.69314240000001 2020-08-01 04:36:27 Altai Krai, Russia
3264448 3264448 2020-07-31 Russia Altai Republic     1551 5 1127 419 50.7114101 86.8572186 2020-08-01 04:36:27 Altai Republic, Russia
3264453 3264453 2020-07-31 Russia Amur Oblast     2752 47 1986 719 52.8032368 128.437295 2020-08-01 04:36:27 Amur Oblast, Russia
3264469 3264469 2020-07-31 Russia Arkhangelsk Oblast     8710 182 7622 906 63.5589686 43.1221646 2020-08-01 04:36:27 Arkhangelsk Oblast, Russia
3264473 3264473 2020-07-31 Russia Astrakhan Oblast     4569 47 3627 895 47.1878186 47.608851 2020-08-01 04:36:27 Astrakhan Oblast, Russia
3264487 3264487 2020-07-31 Russia Bashkortostan Republic     6745 22 5173 1550 54.8573563 57.1439682 2020-08-01 04:36:27 Bashkortostan Republic, Russia
3264491 3264491 2020-07-31 Russia Belgorod Oblast     5952 47 5547 358 50.7080119 37.5837615 2020-08-01 04:36:27 Belgorod Oblast, Russia
3264504 3264504 2020-07-31 Russia Bryansk Oblast     7370 35 5919 1416 52.887331499999995 33.41585300000001 2020-08-01 04:36:27 Bryansk Oblast, Russia
3264505 3264505 2020-07-31 Russia Buryatia Republic     4081 40 3315 726 52.718242599999996 109.492143 2020-08-01 04:36:27 Buryatia Republic, Russia
3264528 3264528 2020-07-31 Russia Chechen Republic     2060 32 1363 665 43.39761470000001 45.6985005 2020-08-01 04:36:27 Chechen Republic, Russia
3264529 3264529 2020-07-31 Russia Chelyabinsk Oblast     11197 93 6686 4418 54.4223954 61.1865846 2020-08-01 04:36:27 Chelyabinsk Oblast, Russia
3264539 3264539 2020-07-31 Russia Chukotka Autonomous Okrug     152 1 148 3 66.0006475 169.4900869 2020-08-01 04:36:27 Chukotka Autonomous Okrug, Russia
3264540 3264540 2020-07-31 Russia Chuvashia Republic     6734 54 3725 2955 55.4259922 47.0849429 2020-08-01 04:36:27 Chuvashia Republic, Russia
3264551 3264551 2020-07-31 Russia Dagestan Republic     9266 445 8229 592 43.05749160000001 47.1332224 2020-08-01 04:36:27 Dagestan Republic, Russia
3264622 3264622 2020-07-31 Russia Ingushetia Republic     3688 73 2965 650 43.11542075 45.01713552 2020-08-01 04:36:27 Ingushetia Republic, Russia
3264624 3264624 2020-07-31 Russia Irkutsk Oblast     13422 174 8599 4649 56.6370122 104.71922099999999 2020-08-01 04:36:27 Irkutsk Oblast, Russia
3264629 3264629 2020-07-31 Russia Ivanovo Oblast     6426 94 5052 1280 56.9167446 41.43521370000001 2020-08-01 04:36:27 Ivanovo Oblast, Russia
3264634 3264634 2020-07-31 Russia Jewish Autonomous Okrug     534 8 470 56 48.57527615 132.66307460000002 2020-08-01 04:36:27 Jewish Autonomous Okrug, Russia
3264641 3264641 2020-07-31 Russia Kabardino-Balkarian Republic     5977 70 5520 387 43.480604799999995 43.5978976 2020-08-01 04:36:27 Kabardino-Balkarian Republic, Russia
3264644 3264644 2020-07-31 Russia Kaliningrad Oblast     2875 45 2361 469 54.7293041 21.1489473 2020-08-01 04:36:27 Kaliningrad Oblast, Russia
3264646 3264646 2020-07-31 Russia Kalmykia Republic     2621 38 1945 638 46.2313018 45.3275745 2020-08-01 04:36:27 Kalmykia Republic, Russia
3264647 3264647 2020-07-31 Russia Kaluga Oblast     7204 56 5944 1204 54.438277299999996 35.5272854 2020-08-01 04:36:27 Kaluga Oblast, Russia
3264648 3264648 2020-07-31 Russia Kamchatka Krai     3362 42 2987 333 57.191488199999995 160.03838190000005 2020-08-01 04:36:27 Kamchatka Krai, Russia
3264650 3264650 2020-07-31 Russia Karachay-Cherkess Republic     4442 23 3170 1249 43.7368326 41.7267991 2020-08-01 04:36:27 Karachay-Cherkess Republic, Russia
3264651 3264651 2020-07-31 Russia Karelia Republic     2275 12 1390 873 62.61940309999999 33.4920267 2020-08-01 04:36:27 Karelia Republic, Russia
3264653 3264653 2020-07-31 Russia Kemerovo Oblast     3555 18 2438 1099 54.53357809999999 87.342861 2020-08-01 04:36:27 Kemerovo Oblast, Russia
3264655 3264655 2020-07-31 Russia Khabarovsk Krai     7540 59 4721 2760 51.6312684 136.121524 2020-08-01 04:36:27 Khabarovsk Krai, Russia
3264656 3264656 2020-07-31 Russia Khakassia Republic     2836 32 2491 313 53.72258845 91.44293627 2020-08-01 04:36:27 Khakassia Republic, Russia
3264657 3264657 2020-07-31 Russia Khanty-Mansi Autonomous Okrug     16333 128 12790 3415 61.0259025 69.0982628 2020-08-01 04:36:27 Khanty-Mansi Autonomous Okrug, Russia
3264664 3264664 2020-07-31 Russia Kirov Oblast     4789 69 4469 251 57.9665589 49.4074599 2020-08-01 04:36:27 Kirov Oblast, Russia
3264667 3264667 2020-07-31 Russia Komi Republic     5303 57 4023 1223 63.9881421 54.3326073 2020-08-01 04:36:27 Komi Republic, Russia
3264668 3264668 2020-07-31 Russia Kostroma Oblast     2206 26 1677 503 58.424756 44.253327299999995 2020-08-01 04:36:27 Kostroma Oblast, Russia
3264669 3264669 2020-07-31 Russia Krasnodar Krai     8266 113 7131 1022 45.768401399999995 39.0261044 2020-08-01 04:36:27 Krasnodar Krai, Russia
3264670 3264670 2020-07-31 Russia Krasnoyarsk Krai     13145 331 11710 1104 63.3233807 97.09799740000001 2020-08-01 04:36:27 Krasnoyarsk Krai, Russia
3264673 3264673 2020-07-31 Russia Kurgan Oblast     2234 9 1619 606 55.7655302 64.5632681 2020-08-01 04:36:27 Kurgan Oblast, Russia
3264674 3264674 2020-07-31 Russia Kursk Oblast     6215 50 4786 1379 51.6568453 36.4852695 2020-08-01 04:36:27 Kursk Oblast, Russia
3264683 3264683 2020-07-31 Russia Leningrad Oblast     5876 56 4529 1291 60.185329599999996 32.3925325 2020-08-01 04:36:27 Leningrad Oblast, Russia
3264688 3264688 2020-07-31 Russia Lipetsk Oblast     4550 22 3647 881 52.693517799999995 39.112266399999996 2020-08-01 04:36:27 Lipetsk Oblast, Russia
3264699 3264699 2020-07-31 Russia Magadan Oblast     1317 13 966 338 62.48858785 153.9903764 2020-08-01 04:36:27 Magadan Oblast, Russia
3264707 3264707 2020-07-31 Russia Mari El Republic     3770 34 3213 523 56.576750399999995 47.881751200000004 2020-08-01 04:36:27 Mari El Republic, Russia
3264728 3264728 2020-07-31 Russia Mordovia Republic     4490 34 3429 1027 54.4419829 44.466114399999995 2020-08-01 04:36:27 Mordovia Republic, Russia
3264730 3264730 2020-07-31 Russia Moscow     241359 4460 179168 57731 55.7504461 37.6174943 2020-08-01 04:36:27 Moscow, Russia
3264731 3264731 2020-07-31 Russia Moscow Oblast     63449 1106 46653 15690 55.50431579999999 38.0353929 2020-08-01 04:36:27 Moscow Oblast, Russia
3264733 3264733 2020-07-31 Russia Murmansk Oblast     10232 77 6202 3953 68.00004179999999 33.9999151 2020-08-01 04:36:27 Murmansk Oblast, Russia
3264742 3264742 2020-07-31 Russia Nenets Autonomous Okrug     274 0 83 191 68.27557185 57.1686375 2020-08-01 04:36:27 Nenets Autonomous Okrug, Russia
3264750 3264750 2020-07-31 Russia Nizhny Novgorod Oblast     23792 384 19479 3929 55.47180329999999 44.091159399999995 2020-08-01 04:36:27 Nizhny Novgorod Oblast, Russia
3264756 3264756 2020-07-31 Russia North Ossetia - Alania Republic     4544 67 4098 379 42.79336110000001 44.6324493 2020-08-01 04:36:27 North Ossetia - Alania Republic, Russia
3264763 3264763 2020-07-31 Russia Novgorod Oblast     3746 71 2534 1141 58.2843833 32.516975699999996 2020-08-01 04:36:27 Novgorod Oblast, Russia
3264764 3264764 2020-07-31 Russia Novosibirsk Oblast     9346 230 7642 1474 54.9720169 79.48139240000002 2020-08-01 04:36:27 Novosibirsk Oblast, Russia
3264774 3264774 2020-07-31 Russia Omsk Oblast     6768 68 4300 2400 56.09352629999999 73.5099936 2020-08-01 04:36:27 Omsk Oblast, Russia
3264777 3264777 2020-07-31 Russia Orel Oblast     5645 89 4313 1243 52.96854329999999 36.0692477 2020-08-01 04:36:27 Orel Oblast, Russia
3264778 3264778 2020-07-31 Russia Orenburg Oblast     6915 47 5363 1505 52.02692620000001 54.7276647 2020-08-01 04:36:27 Orenburg Oblast, Russia
3264789 3264789 2020-07-31 Russia Penza Oblast     6499 81 5550 868 53.1655415 44.78791810000001 2020-08-01 04:36:27 Penza Oblast, Russia
3264790 3264790 2020-07-31 Russia Perm Krai     5864 166 4267 1431 58.5951603 56.3159546 2020-08-01 04:36:27 Perm Krai, Russia
3264797 3264797 2020-07-31 Russia Primorsky Krai     6816 81 5244 1491 45.0819456 134.726645 2020-08-01 04:36:27 Primorsky Krai, Russia
3264799 3264799 2020-07-31 Russia Pskov Oblast     3728 54 2564 1110 57.535872899999994 28.8586826 2020-08-01 04:36:27 Pskov Oblast, Russia
3264824 3264824 2020-07-31 Russia Rostov Oblast     12941 225 10382 2334 47.6222451 40.7957942 2020-08-01 04:36:27 Rostov Oblast, Russia
3264825 3264825 2020-07-31 Russia Ryazan Oblast     6295 30 5846 419 54.42267320000001 40.57052460000001 2020-08-01 04:36:27 Ryazan Oblast, Russia
3264832 3264832 2020-07-31 Russia Saint Petersburg     31461 2043 23370 6048 59.960673899999996 30.158655100000004 2020-08-01 04:36:27 Saint Petersburg, Russia
3264835 3264835 2020-07-31 Russia Sakha (Yakutiya) Republic     5787 58 5348 381 66.941626 129.642371 2020-08-01 04:36:27 Sakha (Yakutiya) Republic, Russia
3264836 3264836 2020-07-31 Russia Sakhalin Oblast     2559 0 1031 1528 49.7219665 143.448533 2020-08-01 04:36:27 Sakhalin Oblast, Russia
3264837 3264837 2020-07-31 Russia Samara Oblast     6840 89 4980 1771 53.2128813 50.8914633 2020-08-01 04:36:27 Samara Oblast, Russia
3264844 3264844 2020-07-31 Russia Saratov Oblast     9406 59 5642 3705 51.652055499999996 46.86319520000001 2020-08-01 04:36:27 Saratov Oblast, Russia
3264865 3264865 2020-07-31 Russia Smolensk Oblast     5656 101 4102 1453 55.03434960000001 33.0192065 2020-08-01 04:36:27 Smolensk Oblast, Russia
3264870 3264870 2020-07-31 Russia Stavropol Krai     8223 156 5482 2585 44.86325770000001 43.4406913 2020-08-01 04:36:27 Stavropol Krai, Russia
3264874 3264874 2020-07-31 Russia Sverdlovsk Oblast     20582 270 16981 3331 58.6414755 61.802154599999994 2020-08-01 04:36:27 Sverdlovsk Oblast, Russia
3264878 3264878 2020-07-31 Russia Tambov Oblast     5990 30 4862 1098 52.9019574 41.3578918 2020-08-01 04:36:27 Tambov Oblast, Russia
3264882 3264882 2020-07-31 Russia Tatarstan Republic     5602 22 4559 1021 55.7648572 52.43104273 2020-08-01 04:36:27 Tatarstan Republic, Russia
3264894 3264894 2020-07-31 Russia Tomsk Oblast     4150 36 2651 1463 58.6124279 82.04753149999998 2020-08-01 04:36:27 Tomsk Oblast, Russia
3264899 3264899 2020-07-31 Russia Tula Oblast     8323 234 6905 1184 53.9570701 37.369090899999996 2020-08-01 04:36:27 Tula Oblast, Russia
3264902 3264902 2020-07-31 Russia Tver Oblast     4597 142 3837 618 57.1134475 35.174442799999994 2020-08-01 04:36:27 Tver Oblast, Russia
3264903 3264903 2020-07-31 Russia Tyumen Oblast     5844 25 4602 1217 58.8206488 70.36588370000001 2020-08-01 04:36:27 Tyumen Oblast, Russia
3264904 3264904 2020-07-31 Russia Tyva Republic     6109 57 4130 1922 51.401714899999995 93.8582593 2020-08-01 04:36:27 Tyva Republic, Russia
3264906 3264906 2020-07-31 Russia Udmurt Republic     2360 25 1918 417 57.1961165 52.69598320000001 2020-08-01 04:36:27 Udmurt Republic, Russia
3264907 3264907 2020-07-31 Russia Ulyanovsk Oblast     9095 73 6435 2587 54.146317700000004 47.2324921 2020-08-01 04:36:27 Ulyanovsk Oblast, Russia
3264936 3264936 2020-07-31 Russia Vladimir Oblast     5586 139 5163 284 56.0503336 40.656163299999996 2020-08-01 04:36:27 Vladimir Oblast, Russia
3264937 3264937 2020-07-31 Russia Volgograd Oblast     9142 62 5565 3515 49.604833899999996 44.29035820000001 2020-08-01 04:36:27 Volgograd Oblast, Russia
3264938 3264938 2020-07-31 Russia Vologda Oblast     2406 25 1968 413 60.0391461 43.1215213 2020-08-01 04:36:27 Vologda Oblast, Russia
3264940 3264940 2020-07-31 Russia Voronezh Oblast     11153 82 9118 1953 50.9800393 40.15065070000001 2020-08-01 04:36:27 Voronezh Oblast, Russia
3264948 3264948 2020-07-31 Russia Yamalo-Nenets Autonomous Okrug     11016 77 8023 2916 67.1471631 74.3415488 2020-08-01 04:36:27 Yamalo-Nenets Autonomous Okrug, Russia
3264950 3264950 2020-07-31 Russia Yaroslavl Oblast     6034 29 5344 661 57.77819760000001 39.002109499999996 2020-08-01 04:36:27 Yaroslavl Oblast, Russia
3264954 3264954 2020-07-31 Russia Zabaykalsky Krai     4081 47 3699 335 52.248521000000004 115.956325 2020-08-01 04:36:27 Zabaykalsky Krai, Russia

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);