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 2022-10-29 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
1366666 1366666 2022-10-28 Russia Adygea Republic     54113 1019 0   44.6939006 40.1520421 2022-10-29 04:21:13 Adygea Republic, Russia
1366667 1366667 2022-10-28 Russia Altai Krai     310203 8817 0   52.6932243 82.6931424 2022-10-29 04:21:13 Altai Krai, Russia
1366668 1366668 2022-10-28 Russia Altai Republic     39803 627 0   50.7114101 86.8572186 2022-10-29 04:21:13 Altai Republic, Russia
1366669 1366669 2022-10-28 Russia Amur Oblast     123860 766 0   52.8032368 128.437295 2022-10-29 04:21:13 Amur Oblast, Russia
1366670 1366670 2022-10-28 Russia Arkhangelsk Oblast     267563 1784 0   63.5589686 43.1221646 2022-10-29 04:21:13 Arkhangelsk Oblast, Russia
1366671 1366671 2022-10-28 Russia Astrakhan Oblast     131923 3096 0   47.1878186 47.608851 2022-10-29 04:21:13 Astrakhan Oblast, Russia
1366672 1366672 2022-10-28 Russia Bashkortostan Republic     329797 5887 0   54.8573563 57.1439682 2022-10-29 04:21:13 Bashkortostan Republic, Russia
1366673 1366673 2022-10-28 Russia Belgorod Oblast     161794 2303 0   50.7080119 37.5837615 2022-10-29 04:21:13 Belgorod Oblast, Russia
1366674 1366674 2022-10-28 Russia Bryansk Oblast     183177 4110 0   52.8873315 33.415853 2022-10-29 04:21:13 Bryansk Oblast, Russia
1366675 1366675 2022-10-28 Russia Buryatia Republic     152003 3086 0   52.7182426 109.492143 2022-10-29 04:21:13 Buryatia Republic, Russia
1366676 1366676 2022-10-28 Russia Chechen Republic     46438 1076 0   43.3976147 45.6985005 2022-10-29 04:21:13 Chechen Republic, Russia
1366677 1366677 2022-10-28 Russia Chelyabinsk Oblast     388735 8059 0   54.4223954 61.1865846 2022-10-29 04:21:13 Chelyabinsk Oblast, Russia
1366678 1366678 2022-10-28 Russia Chukotka Autonomous Okrug     6692 44 0   66.0006475 169.4900869 2022-10-29 04:21:13 Chukotka Autonomous Okrug, Russia
1366679 1366679 2022-10-28 Russia Chuvashia Republic     101944 4689 0   55.4259922 47.0849429 2022-10-29 04:21:13 Chuvashia Republic, Russia
1366680 1366680 2022-10-28 Russia Dagestan Republic     101894 3616 0   43.0574916 47.1332224 2022-10-29 04:21:13 Dagestan Republic, Russia
1366681 1366681 2022-10-28 Russia Ingushetia Republic     43248 553 0   43.11542075 45.01713552 2022-10-29 04:21:13 Ingushetia Republic, Russia
1366682 1366682 2022-10-28 Russia Irkutsk Oblast     349738 8585 0   56.6370122 104.719221 2022-10-29 04:21:13 Irkutsk Oblast, Russia
1366683 1366683 2022-10-28 Russia Ivanovo Oblast     129679 3184 0   56.9167446 41.4352137 2022-10-29 04:21:13 Ivanovo Oblast, Russia
1366684 1366684 2022-10-28 Russia Jewish Autonomous Okrug     21947 561 0   48.57527615 132.6630746 2022-10-29 04:21:13 Jewish Autonomous Okrug, Russia
1366685 1366685 2022-10-28 Russia Kabardino-Balkarian Republic     72990 1917 0   43.4806048 43.5978976 2022-10-29 04:21:13 Kabardino-Balkarian Republic, Russia
1366686 1366686 2022-10-28 Russia Kaliningrad Oblast     190020 1987 0   54.7293041 21.1489473 2022-10-29 04:21:13 Kaliningrad Oblast, Russia
1366687 1366687 2022-10-28 Russia Kalmykia Republic     58818 843 0   46.2313018 45.3275745 2022-10-29 04:21:13 Kalmykia Republic, Russia
1366688 1366688 2022-10-28 Russia Kaluga Oblast     120597 1453 0   54.4382773 35.5272854 2022-10-29 04:21:13 Kaluga Oblast, Russia
1366689 1366689 2022-10-28 Russia Kamchatka Krai     44220 625 0   57.1914882 160.0383819 2022-10-29 04:21:13 Kamchatka Krai, Russia
1366690 1366690 2022-10-28 Russia Karachay-Cherkess Republic     50831 991 0   43.7368326 41.7267991 2022-10-29 04:21:13 Karachay-Cherkess Republic, Russia
1366691 1366691 2022-10-28 Russia Karelia Republic     159879 1526 0   62.6194031 33.4920267 2022-10-29 04:21:13 Karelia Republic, Russia
1366692 1366692 2022-10-28 Russia Kemerovo Oblast     208528 2723 0   54.5335781 87.342861 2022-10-29 04:21:13 Kemerovo Oblast, Russia
1366693 1366693 2022-10-28 Russia Khabarovsk Krai     222982 1564 0   51.6312684 136.121524 2022-10-29 04:21:13 Khabarovsk Krai, Russia
1366694 1366694 2022-10-28 Russia Khakassia Republic     101927 2421 0   53.72258845 91.44293627 2022-10-29 04:21:13 Khakassia Republic, Russia
1366695 1366695 2022-10-28 Russia Khanty-Mansi Autonomous Okrug     248957 2587 0   61.0259025 69.0982628 2022-10-29 04:21:13 Khanty-Mansi Autonomous Okrug, Russia
1366696 1366696 2022-10-28 Russia Kirov Oblast     163568 1079 0   57.9665589 49.4074599 2022-10-29 04:21:13 Kirov Oblast, Russia
1366697 1366697 2022-10-28 Russia Komi Republic     189288 3229 0   63.9881421 54.3326073 2022-10-29 04:21:13 Komi Republic, Russia
1366698 1366698 2022-10-28 Russia Kostroma Oblast     101848 1429 0   58.424756 44.2533273 2022-10-29 04:21:13 Kostroma Oblast, Russia
1366699 1366699 2022-10-28 Russia Krasnodar Krai     339647 11089 0   45.7684014 39.0261044 2022-10-29 04:21:13 Krasnodar Krai, Russia
1366700 1366700 2022-10-28 Russia Krasnoyarsk Krai     420609 11114 0   63.3233807 97.0979974 2022-10-29 04:21:13 Krasnoyarsk Krai, Russia
1366701 1366701 2022-10-28 Russia Kurgan Oblast     121065 1489 0   55.7655302 64.5632681 2022-10-29 04:21:13 Kurgan Oblast, Russia
1366702 1366702 2022-10-28 Russia Kursk Oblast     147846 2522 0   51.6568453 36.4852695 2022-10-29 04:21:13 Kursk Oblast, Russia
1366703 1366703 2022-10-28 Russia Leningrad Oblast     235872 3499 0   60.1853296 32.3925325 2022-10-29 04:21:13 Leningrad Oblast, Russia
1366704 1366704 2022-10-28 Russia Lipetsk Oblast     174397 3908 0   52.6935178 39.1122664 2022-10-29 04:21:13 Lipetsk Oblast, Russia
1366705 1366705 2022-10-28 Russia Magadan Oblast     21688 392 0   62.48858785 153.9903764 2022-10-29 04:21:13 Magadan Oblast, Russia
1366706 1366706 2022-10-28 Russia Mari El Republic     48964 1087 0   56.5767504 47.8817512 2022-10-29 04:21:13 Mari El Republic, Russia
1366707 1366707 2022-10-28 Russia Mordovia Republic     81811 1396 0   54.4419829 44.4661144 2022-10-29 04:21:13 Mordovia Republic, Russia
1366708 1366708 2022-10-28 Russia Moscow     3228799 46583 0   55.7504461 37.6174943 2022-10-29 04:21:13 Moscow, Russia
1366709 1366709 2022-10-28 Russia Moscow Oblast     1117513 15397 0   55.5043158 38.0353929 2022-10-29 04:21:13 Moscow Oblast, Russia
1366710 1366710 2022-10-28 Russia Murmansk Oblast     144037 3387 0   68.0000418 33.9999151 2022-10-29 04:21:13 Murmansk Oblast, Russia
1366711 1366711 2022-10-28 Russia Nenets Autonomous Okrug     8228 102 0   68.27557185 57.1686375 2022-10-29 04:21:13 Nenets Autonomous Okrug, Russia
1366712 1366712 2022-10-28 Russia Nizhny Novgorod Oblast     494446 11736 0   55.4718033 44.0911594 2022-10-29 04:21:13 Nizhny Novgorod Oblast, Russia
1366713 1366713 2022-10-28 Russia North Ossetia - Alania Republic     45522 1266 0   42.7933611 44.6324493 2022-10-29 04:21:13 North Ossetia - Alania Republic, Russia
1366714 1366714 2022-10-28 Russia Novgorod Oblast     115673 1053 0   58.2843833 32.5169757 2022-10-29 04:21:13 Novgorod Oblast, Russia
1366715 1366715 2022-10-28 Russia Novosibirsk Oblast     303598 5728 0   54.9720169 79.4813924 2022-10-29 04:21:13 Novosibirsk Oblast, Russia
1366716 1366716 2022-10-28 Russia Omsk Oblast     229047 4511 0   56.0935263 73.5099936 2022-10-29 04:21:13 Omsk Oblast, Russia
1366717 1366717 2022-10-28 Russia Orel Oblast     133266 1959 0   52.9685433 36.0692477 2022-10-29 04:21:13 Orel Oblast, Russia
1366718 1366718 2022-10-28 Russia Orenburg Oblast     239608 4028 0   52.0269262 54.7276647 2022-10-29 04:21:13 Orenburg Oblast, Russia
1366719 1366719 2022-10-28 Russia Penza Oblast     217405 6116 0   53.1655415 44.7879181 2022-10-29 04:21:13 Penza Oblast, Russia
1366720 1366720 2022-10-28 Russia Perm Krai     443620 9050 0   58.5951603 56.3159546 2022-10-29 04:21:13 Perm Krai, Russia
1366721 1366721 2022-10-28 Russia Primorsky Krai     205709 1966 0   45.0819456 134.726645 2022-10-29 04:21:13 Primorsky Krai, Russia
1366722 1366722 2022-10-28 Russia Pskov Oblast     125025 1934 0   57.5358729 28.8586826 2022-10-29 04:21:13 Pskov Oblast, Russia
1366723 1366723 2022-10-28 Russia Rostov Oblast     435975 11065 0   47.6222451 40.7957942 2022-10-29 04:21:13 Rostov Oblast, Russia
1366724 1366724 2022-10-28 Russia Ryazan Oblast     147554 3460 0   54.4226732 40.5705246 2022-10-29 04:21:13 Ryazan Oblast, Russia
1366725 1366725 2022-10-28 Russia Saint Petersburg     1784497 35723 0   59.9606739 30.1586551 2022-10-29 04:21:13 Saint Petersburg, Russia
1366726 1366726 2022-10-28 Russia Sakha (Yakutiya) Republic     212543 2137 0   66.941626 129.642371 2022-10-29 04:21:13 Sakha (Yakutiya) Republic, Russia
1366727 1366727 2022-10-28 Russia Sakhalin Oblast     68597 830 0   49.7219665 143.448533 2022-10-29 04:21:13 Sakhalin Oblast, Russia
1366728 1366728 2022-10-28 Russia Samara Oblast     478512 8097 0   53.2128813 50.8914633 2022-10-29 04:21:13 Samara Oblast, Russia
1366729 1366729 2022-10-28 Russia Saratov Oblast     296249 6001 0   51.6520555 46.8631952 2022-10-29 04:21:13 Saratov Oblast, Russia
1366730 1366730 2022-10-28 Russia Smolensk Oblast     145326 3131 0   55.0343496 33.0192065 2022-10-29 04:21:13 Smolensk Oblast, Russia
1366731 1366731 2022-10-28 Russia Stavropol Krai     241483 7118 0   44.8632577 43.4406913 2022-10-29 04:21:13 Stavropol Krai, Russia
1366732 1366732 2022-10-28 Russia Sverdlovsk Oblast     543544 10850 0   58.6414755 61.8021546 2022-10-29 04:21:13 Sverdlovsk Oblast, Russia
1366733 1366733 2022-10-28 Russia Tambov Oblast     136419 2499 0   52.9019574 41.3578918 2022-10-29 04:21:13 Tambov Oblast, Russia
1366734 1366734 2022-10-28 Russia Tatarstan Republic     187043 2005 0   55.7648572 52.43104273 2022-10-29 04:21:13 Tatarstan Republic, Russia
1366735 1366735 2022-10-28 Russia Tomsk Oblast     155822 917 0   58.6124279 82.0475315 2022-10-29 04:21:13 Tomsk Oblast, Russia
1366736 1366736 2022-10-28 Russia Tula Oblast     186043 5332 0   53.9570701 37.3690909 2022-10-29 04:21:13 Tula Oblast, Russia
1366737 1366737 2022-10-28 Russia Tver Oblast     178409 2770 0   57.1134475 35.1744428 2022-10-29 04:21:13 Tver Oblast, Russia
1366738 1366738 2022-10-28 Russia Tyumen Oblast     247583 4359 0   58.8206488 70.3658837 2022-10-29 04:21:13 Tyumen Oblast, Russia
1366739 1366739 2022-10-28 Russia Tyva Republic     52221 357 0   51.4017149 93.8582593 2022-10-29 04:21:13 Tyva Republic, Russia
1366740 1366740 2022-10-28 Russia Udmurt Republic     221935 3923 0   57.1961165 52.6959832 2022-10-29 04:21:13 Udmurt Republic, Russia
1366741 1366741 2022-10-28 Russia Ulyanovsk Oblast     224873 4799 0   54.1463177 47.2324921 2022-10-29 04:21:13 Ulyanovsk Oblast, Russia
1366742 1366742 2022-10-28 Russia Vladimir Oblast     176594 3551 0   56.0503336 40.6561633 2022-10-29 04:21:13 Vladimir Oblast, Russia
1366743 1366743 2022-10-28 Russia Volgograd Oblast     261836 6909 0   49.6048339 44.2903582 2022-10-29 04:21:13 Volgograd Oblast, Russia
1366744 1366744 2022-10-28 Russia Vologda Oblast     213957 3888 0   60.0391461 43.1215213 2022-10-29 04:21:13 Vologda Oblast, Russia
1366745 1366745 2022-10-28 Russia Voronezh Oblast     465325 8535 0   50.9800393 40.1506507 2022-10-29 04:21:13 Voronezh Oblast, Russia
1366746 1366746 2022-10-28 Russia Yamalo-Nenets Autonomous Okrug     148482 1049 0   67.1471631 74.3415488 2022-10-29 04:21:13 Yamalo-Nenets Autonomous Okrug, Russia
1366747 1366747 2022-10-28 Russia Yaroslavl Oblast     184695 2862 0   57.7781976 39.0021095 2022-10-29 04:21:13 Yaroslavl Oblast, Russia
1366748 1366748 2022-10-28 Russia Zabaykalsky Krai     187263 2364 0   52.248521 115.956325 2022-10-29 04:21:13 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]);