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 2021-10-22 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
2123928 2123928 2021-10-21 Russia Adygea Republic     20833 515 0   44.6939006 40.1520421 2021-10-22 04:21:14 Adygea Republic, Russia
2123929 2123929 2021-10-21 Russia Altai Krai     84244 4674 0   52.693224300000004 82.69314240000001 2021-10-22 04:21:14 Altai Krai, Russia
2123930 2123930 2021-10-21 Russia Altai Republic     22373 388 0   50.7114101 86.8572186 2021-10-22 04:21:14 Altai Republic, Russia
2123931 2123931 2021-10-21 Russia Amur Oblast     38216 474 0   52.8032368 128.437295 2021-10-22 04:21:14 Amur Oblast, Russia
2123932 2123932 2021-10-21 Russia Arkhangelsk Oblast     96276 1232 0   63.5589686 43.1221646 2021-10-22 04:21:14 Arkhangelsk Oblast, Russia
2123933 2123933 2021-10-21 Russia Astrakhan Oblast     63787 1868 0   47.1878186 47.608851 2021-10-22 04:21:14 Astrakhan Oblast, Russia
2123934 2123934 2021-10-21 Russia Bashkortostan Republic     79475 2268 0   54.8573563 57.1439682 2021-10-22 04:21:14 Bashkortostan Republic, Russia
2123935 2123935 2021-10-21 Russia Belgorod Oblast     59118 1261 0   50.7080119 37.5837615 2021-10-22 04:21:14 Belgorod Oblast, Russia
2123936 2123936 2021-10-21 Russia Bryansk Oblast     71805 1704 0   52.887331499999995 33.41585300000001 2021-10-22 04:21:14 Bryansk Oblast, Russia
2123937 2123937 2021-10-21 Russia Buryatia Republic     61368 1929 0   52.718242599999996 109.492143 2021-10-22 04:21:14 Buryatia Republic, Russia
2123938 2123938 2021-10-21 Russia Chechen Republic     24167 673 0   43.39761470000001 45.6985005 2021-10-22 04:21:14 Chechen Republic, Russia
2123939 2123939 2021-10-21 Russia Chelyabinsk Oblast     104500 3956 0   54.4223954 61.1865846 2021-10-22 04:21:14 Chelyabinsk Oblast, Russia
2123940 2123940 2021-10-21 Russia Chukotka Autonomous Okrug     2199 19 0   66.0006475 169.4900869 2021-10-22 04:21:14 Chukotka Autonomous Okrug, Russia
2123941 2123941 2021-10-21 Russia Chuvashia Republic     36233 2585 0   55.4259922 47.0849429 2021-10-22 04:21:14 Chuvashia Republic, Russia
2123942 2123942 2021-10-21 Russia Dagestan Republic     54467 2684 0   43.05749160000001 47.1332224 2021-10-22 04:21:14 Dagestan Republic, Russia
2123943 2123943 2021-10-21 Russia Ingushetia Republic     22901 353 0   43.11542075 45.01713552 2021-10-22 04:21:14 Ingushetia Republic, Russia
2123944 2123944 2021-10-21 Russia Irkutsk Oblast     117282 5124 0   56.6370122 104.71922099999999 2021-10-22 04:21:14 Irkutsk Oblast, Russia
2123945 2123945 2021-10-21 Russia Ivanovo Oblast     53111 1752 0   56.9167446 41.43521370000001 2021-10-22 04:21:14 Ivanovo Oblast, Russia
2123946 2123946 2021-10-21 Russia Jewish Autonomous Okrug     8815 285 0   48.57527615 132.66307460000002 2021-10-22 04:21:14 Jewish Autonomous Okrug, Russia
2123947 2123947 2021-10-21 Russia Kabardino-Balkarian Republic     33883 880 0   43.480604799999995 43.5978976 2021-10-22 04:21:14 Kabardino-Balkarian Republic, Russia
2123948 2123948 2021-10-21 Russia Kaliningrad Oblast     60875 828 0   54.7293041 21.1489473 2021-10-22 04:21:14 Kaliningrad Oblast, Russia
2123949 2123949 2021-10-21 Russia Kalmykia Republic     31697 638 0   46.2313018 45.3275745 2021-10-22 04:21:14 Kalmykia Republic, Russia
2123950 2123950 2021-10-21 Russia Kaluga Oblast     51240 804 0   54.438277299999996 35.5272854 2021-10-22 04:21:14 Kaluga Oblast, Russia
2123951 2123951 2021-10-21 Russia Kamchatka Krai     20577 413 0   57.191488199999995 160.03838190000005 2021-10-22 04:21:14 Kamchatka Krai, Russia
2123952 2123952 2021-10-21 Russia Karachay-Cherkess Republic     26725 725 0   43.7368326 41.7267991 2021-10-22 04:21:14 Karachay-Cherkess Republic, Russia
2123953 2123953 2021-10-21 Russia Karelia Republic     71233 938 0   62.61940309999999 33.4920267 2021-10-22 04:21:14 Karelia Republic, Russia
2123954 2123954 2021-10-21 Russia Kemerovo Oblast     60585 1409 0   54.53357809999999 87.342861 2021-10-22 04:21:14 Kemerovo Oblast, Russia
2123955 2123955 2021-10-21 Russia Khabarovsk Krai     90331 876 0   51.6312684 136.121524 2021-10-22 04:21:14 Khabarovsk Krai, Russia
2123956 2123956 2021-10-21 Russia Khakassia Republic     41847 1247 0   53.72258845 91.44293627 2021-10-22 04:21:14 Khakassia Republic, Russia
2123957 2123957 2021-10-21 Russia Khanty-Mansi Autonomous Okrug     79576 1235 0   61.0259025 69.0982628 2021-10-22 04:21:14 Khanty-Mansi Autonomous Okrug, Russia
2123958 2123958 2021-10-21 Russia Kirov Oblast     61268 574 0   57.9665589 49.4074599 2021-10-22 04:21:14 Kirov Oblast, Russia
2123959 2123959 2021-10-21 Russia Komi Republic     75727 1897 0   63.9881421 54.3326073 2021-10-22 04:21:14 Komi Republic, Russia
2123960 2123960 2021-10-21 Russia Kostroma Oblast     36769 851 0   58.424756 44.253327299999995 2021-10-22 04:21:14 Kostroma Oblast, Russia
2123961 2123961 2021-10-21 Russia Krasnodar Krai     78858 6975 0   45.768401399999995 39.0261044 2021-10-22 04:21:14 Krasnodar Krai, Russia
2123962 2123962 2021-10-21 Russia Krasnoyarsk Krai     125088 6299 0   63.3233807 97.09799740000001 2021-10-22 04:21:14 Krasnoyarsk Krai, Russia
2123963 2123963 2021-10-21 Russia Kurgan Oblast     36759 779 0   55.7655302 64.5632681 2021-10-22 04:21:14 Kurgan Oblast, Russia
2123964 2123964 2021-10-21 Russia Kursk Oblast     62947 1553 0   51.6568453 36.4852695 2021-10-22 04:21:14 Kursk Oblast, Russia
2123965 2123965 2021-10-21 Russia Leningrad Oblast     74920 2517 0   60.185329599999996 32.3925325 2021-10-22 04:21:14 Leningrad Oblast, Russia
2123966 2123966 2021-10-21 Russia Lipetsk Oblast     58918 1906 0   52.693517799999995 39.112266399999996 2021-10-22 04:21:14 Lipetsk Oblast, Russia
2123967 2123967 2021-10-21 Russia Magadan Oblast     11444 272 0   62.48858785 153.9903764 2021-10-22 04:21:14 Magadan Oblast, Russia
2123968 2123968 2021-10-21 Russia Mari El Republic     21279 663 0   56.576750399999995 47.881751200000004 2021-10-22 04:21:14 Mari El Republic, Russia
2123969 2123969 2021-10-21 Russia Mordovia Republic     30286 653 0   54.4419829 44.466114399999995 2021-10-22 04:21:14 Mordovia Republic, Russia
2123970 2123970 2021-10-21 Russia Moscow     1745681 30458 0   55.7504461 37.6174943 2021-10-22 04:21:14 Moscow, Russia
2123971 2123971 2021-10-21 Russia Moscow Oblast     490915 8397 0   55.50431579999999 38.0353929 2021-10-22 04:21:14 Moscow Oblast, Russia
2123972 2123972 2021-10-21 Russia Murmansk Oblast     76471 2238 0   68.00004179999999 33.9999151 2021-10-22 04:21:14 Murmansk Oblast, Russia
2123973 2123973 2021-10-21 Russia Nenets Autonomous Okrug     2594 56 0   68.27557185 57.1686375 2021-10-22 04:21:14 Nenets Autonomous Okrug, Russia
2123974 2123974 2021-10-21 Russia Nizhny Novgorod Oblast     183417 7325 0   55.47180329999999 44.091159399999995 2021-10-22 04:21:14 Nizhny Novgorod Oblast, Russia
2123975 2123975 2021-10-21 Russia North Ossetia - Alania Republic     24573 678 0   42.79336110000001 44.6324493 2021-10-22 04:21:14 North Ossetia - Alania Republic, Russia
2123976 2123976 2021-10-21 Russia Novgorod Oblast     48017 484 0   58.2843833 32.516975699999996 2021-10-22 04:21:14 Novgorod Oblast, Russia
2123977 2123977 2021-10-21 Russia Novosibirsk Oblast     67861 3249 0   54.9720169 79.48139240000002 2021-10-22 04:21:14 Novosibirsk Oblast, Russia
2123978 2123978 2021-10-21 Russia Omsk Oblast     92515 2371 0   56.09352629999999 73.5099936 2021-10-22 04:21:14 Omsk Oblast, Russia
2123979 2123979 2021-10-21 Russia Orel Oblast     50354 1043 0   52.96854329999999 36.0692477 2021-10-22 04:21:14 Orel Oblast, Russia
2123980 2123980 2021-10-21 Russia Orenburg Oblast     85293 2373 0   52.02692620000001 54.7276647 2021-10-22 04:21:14 Orenburg Oblast, Russia
2123981 2123981 2021-10-21 Russia Penza Oblast     76648 3254 0   53.1655415 44.78791810000001 2021-10-22 04:21:14 Penza Oblast, Russia
2123982 2123982 2021-10-21 Russia Perm Krai     113189 5484 0   58.5951603 56.3159546 2021-10-22 04:21:14 Perm Krai, Russia
2123983 2123983 2021-10-21 Russia Primorsky Krai     73592 1226 0   45.0819456 134.726645 2021-10-22 04:21:14 Primorsky Krai, Russia
2123984 2123984 2021-10-21 Russia Pskov Oblast     54933 869 0   57.535872899999994 28.8586826 2021-10-22 04:21:14 Pskov Oblast, Russia
2123985 2123985 2021-10-21 Russia Rostov Oblast     149986 7417 0   47.6222451 40.7957942 2021-10-22 04:21:14 Rostov Oblast, Russia
2123986 2123986 2021-10-21 Russia Ryazan Oblast     45766 1299 0   54.42267320000001 40.57052460000001 2021-10-22 04:21:14 Ryazan Oblast, Russia
2123987 2123987 2021-10-21 Russia Saint Petersburg     676510 23162 0   59.960673899999996 30.158655100000004 2021-10-22 04:21:14 Saint Petersburg, Russia
2123988 2123988 2021-10-21 Russia Sakha (Yakutiya) Republic     59252 1365 0   66.941626 129.642371 2021-10-22 04:21:14 Sakha (Yakutiya) Republic, Russia
2123989 2123989 2021-10-21 Russia Sakhalin Oblast     34155 344 0   49.7219665 143.448533 2021-10-22 04:21:14 Sakhalin Oblast, Russia
2123990 2123990 2021-10-21 Russia Samara Oblast     120782 4370 0   53.2128813 50.8914633 2021-10-22 04:21:14 Samara Oblast, Russia
2123991 2123991 2021-10-21 Russia Saratov Oblast     96433 3563 0   51.652055499999996 46.86319520000001 2021-10-22 04:21:14 Saratov Oblast, Russia
2123992 2123992 2021-10-21 Russia Smolensk Oblast     56251 1860 0   55.03434960000001 33.0192065 2021-10-22 04:21:14 Smolensk Oblast, Russia
2123993 2123993 2021-10-21 Russia Stavropol Krai     93580 3685 0   44.86325770000001 43.4406913 2021-10-22 04:21:14 Stavropol Krai, Russia
2123994 2123994 2021-10-21 Russia Sverdlovsk Oblast     150715 7160 0   58.6414755 61.802154599999994 2021-10-22 04:21:14 Sverdlovsk Oblast, Russia
2123995 2123995 2021-10-21 Russia Tambov Oblast     46516 1029 0   52.9019574 41.3578918 2021-10-22 04:21:14 Tambov Oblast, Russia
2123996 2123996 2021-10-21 Russia Tatarstan Republic     29104 885 0   55.7648572 52.43104273 2021-10-22 04:21:14 Tatarstan Republic, Russia
2123997 2123997 2021-10-21 Russia Tomsk Oblast     46057 583 0   58.6124279 82.04753149999998 2021-10-22 04:21:14 Tomsk Oblast, Russia
2123998 2123998 2021-10-21 Russia Tula Oblast     57880 3288 0   53.9570701 37.369090899999996 2021-10-22 04:21:14 Tula Oblast, Russia
2123999 2123999 2021-10-21 Russia Tver Oblast     72812 1777 0   57.1134475 35.174442799999994 2021-10-22 04:21:14 Tver Oblast, Russia
2124000 2124000 2021-10-21 Russia Tyumen Oblast     67488 2214 0   58.8206488 70.36588370000001 2021-10-22 04:21:14 Tyumen Oblast, Russia
2124001 2124001 2021-10-21 Russia Tyva Republic     27891 282 0   51.401714899999995 93.8582593 2021-10-22 04:21:14 Tyva Republic, Russia
2124002 2124002 2021-10-21 Russia Udmurt Republic     59800 2405 0   57.1961165 52.69598320000001 2021-10-22 04:21:14 Udmurt Republic, Russia
2124003 2124003 2021-10-21 Russia Ulyanovsk Oblast     90491 2858 0   54.146317700000004 47.2324921 2021-10-22 04:21:14 Ulyanovsk Oblast, Russia
2124004 2124004 2021-10-21 Russia Vladimir Oblast     59669 2149 0   56.0503336 40.656163299999996 2021-10-22 04:21:14 Vladimir Oblast, Russia
2124005 2124005 2021-10-21 Russia Volgograd Oblast     99883 3273 0   49.604833899999996 44.29035820000001 2021-10-22 04:21:14 Volgograd Oblast, Russia
2124006 2124006 2021-10-21 Russia Vologda Oblast     74816 2100 0   60.0391461 43.1215213 2021-10-22 04:21:14 Vologda Oblast, Russia
2124007 2124007 2021-10-21 Russia Voronezh Oblast     146693 4758 0   50.9800393 40.15065070000001 2021-10-22 04:21:14 Voronezh Oblast, Russia
2124008 2124008 2021-10-21 Russia Yamalo-Nenets Autonomous Okrug     52837 728 0   67.1471631 74.3415488 2021-10-22 04:21:14 Yamalo-Nenets Autonomous Okrug, Russia
2124009 2124009 2021-10-21 Russia Yaroslavl Oblast     66298 1321 0   57.77819760000001 39.002109499999996 2021-10-22 04:21:14 Yaroslavl Oblast, Russia
2124010 2124010 2021-10-21 Russia Zabaykalsky Krai     73656 1275 0   52.248521000000004 115.956325 2021-10-22 04:21:14 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]);