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-11-26 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
1802930 1802930 2021-11-25 Russia Adygea Republic     23732 656 0   44.6939006 40.1520421 2021-11-26 04:22:33 Adygea Republic, Russia
1802931 1802931 2021-11-25 Russia Altai Krai     101430 5614 0   52.693224300000004 82.69314240000001 2021-11-26 04:22:33 Altai Krai, Russia
1802932 1802932 2021-11-25 Russia Altai Republic     24159 451 0   50.7114101 86.8572186 2021-11-26 04:22:33 Altai Republic, Russia
1802933 1802933 2021-11-25 Russia Amur Oblast     45226 517 0   52.8032368 128.437295 2021-11-26 04:22:33 Amur Oblast, Russia
1802934 1802934 2021-11-25 Russia Arkhangelsk Oblast     111656 1341 0   63.5589686 43.1221646 2021-11-26 04:22:33 Arkhangelsk Oblast, Russia
1802935 1802935 2021-11-25 Russia Astrakhan Oblast     72733 2163 0   47.1878186 47.608851 2021-11-26 04:22:33 Astrakhan Oblast, Russia
1802936 1802936 2021-11-25 Russia Bashkortostan Republic     103023 3380 0   54.8573563 57.1439682 2021-11-26 04:22:33 Bashkortostan Republic, Russia
1802937 1802937 2021-11-25 Russia Belgorod Oblast     71130 1482 0   50.7080119 37.5837615 2021-11-26 04:22:33 Belgorod Oblast, Russia
1802938 1802938 2021-11-25 Russia Bryansk Oblast     88159 2201 0   52.887331499999995 33.41585300000001 2021-11-26 04:22:33 Bryansk Oblast, Russia
1802939 1802939 2021-11-25 Russia Buryatia Republic     68386 2142 0   52.718242599999996 109.492143 2021-11-26 04:22:33 Buryatia Republic, Russia
1802940 1802940 2021-11-25 Russia Chechen Republic     28105 808 0   43.39761470000001 45.6985005 2021-11-26 04:22:33 Chechen Republic, Russia
1802941 1802941 2021-11-25 Russia Chelyabinsk Oblast     123563 4988 0   54.4223954 61.1865846 2021-11-26 04:22:33 Chelyabinsk Oblast, Russia
1802942 1802942 2021-11-25 Russia Chukotka Autonomous Okrug     2808 25 0   66.0006475 169.4900869 2021-11-26 04:22:33 Chukotka Autonomous Okrug, Russia
1802943 1802943 2021-11-25 Russia Chuvashia Republic     42181 3211 0   55.4259922 47.0849429 2021-11-26 04:22:33 Chuvashia Republic, Russia
1802944 1802944 2021-11-25 Russia Dagestan Republic     60376 2911 0   43.05749160000001 47.1332224 2021-11-26 04:22:33 Dagestan Republic, Russia
1802945 1802945 2021-11-25 Russia Ingushetia Republic     25731 414 0   43.11542075 45.01713552 2021-11-26 04:22:33 Ingushetia Republic, Russia
1802946 1802946 2021-11-25 Russia Irkutsk Oblast     135725 6069 0   56.6370122 104.71922099999999 2021-11-26 04:22:33 Irkutsk Oblast, Russia
1802947 1802947 2021-11-25 Russia Ivanovo Oblast     61005 2084 0   56.9167446 41.43521370000001 2021-11-26 04:22:33 Ivanovo Oblast, Russia
1802948 1802948 2021-11-25 Russia Jewish Autonomous Okrug     10369 331 0   48.57527615 132.66307460000002 2021-11-26 04:22:33 Jewish Autonomous Okrug, Russia
1802949 1802949 2021-11-25 Russia Kabardino-Balkarian Republic     38369 1143 0   43.480604799999995 43.5978976 2021-11-26 04:22:33 Kabardino-Balkarian Republic, Russia
1802950 1802950 2021-11-25 Russia Kaliningrad Oblast     74282 990 0   54.7293041 21.1489473 2021-11-26 04:22:33 Kaliningrad Oblast, Russia
1802951 1802951 2021-11-25 Russia Kalmykia Republic     33298 689 0   46.2313018 45.3275745 2021-11-26 04:22:33 Kalmykia Republic, Russia
1802952 1802952 2021-11-25 Russia Kaluga Oblast     58131 1007 0   54.438277299999996 35.5272854 2021-11-26 04:22:33 Kaluga Oblast, Russia
1802953 1802953 2021-11-25 Russia Kamchatka Krai     22169 482 0   57.191488199999995 160.03838190000005 2021-11-26 04:22:33 Kamchatka Krai, Russia
1802954 1802954 2021-11-25 Russia Karachay-Cherkess Republic     29679 845 0   43.7368326 41.7267991 2021-11-26 04:22:33 Karachay-Cherkess Republic, Russia
1802955 1802955 2021-11-25 Russia Karelia Republic     81938 1061 0   62.61940309999999 33.4920267 2021-11-26 04:22:33 Karelia Republic, Russia
1802956 1802956 2021-11-25 Russia Kemerovo Oblast     72134 1557 0   54.53357809999999 87.342861 2021-11-26 04:22:33 Kemerovo Oblast, Russia
1802957 1802957 2021-11-25 Russia Khabarovsk Krai     107169 1021 0   51.6312684 136.121524 2021-11-26 04:22:33 Khabarovsk Krai, Russia
1802958 1802958 2021-11-25 Russia Khakassia Republic     48919 1574 0   53.72258845 91.44293627 2021-11-26 04:22:33 Khakassia Republic, Russia
1802959 1802959 2021-11-25 Russia Khanty-Mansi Autonomous Okrug     88514 1649 0   61.0259025 69.0982628 2021-11-26 04:22:33 Khanty-Mansi Autonomous Okrug, Russia
1802960 1802960 2021-11-25 Russia Kirov Oblast     70326 667 0   57.9665589 49.4074599 2021-11-26 04:22:33 Kirov Oblast, Russia
1802961 1802961 2021-11-25 Russia Komi Republic     88415 2255 0   63.9881421 54.3326073 2021-11-26 04:22:33 Komi Republic, Russia
1802962 1802962 2021-11-25 Russia Kostroma Oblast     43693 972 0   58.424756 44.253327299999995 2021-11-26 04:22:33 Kostroma Oblast, Russia
1802963 1802963 2021-11-25 Russia Krasnodar Krai     95193 8688 0   45.768401399999995 39.0261044 2021-11-26 04:22:33 Krasnodar Krai, Russia
1802964 1802964 2021-11-25 Russia Krasnoyarsk Krai     149089 7321 0   63.3233807 97.09799740000001 2021-11-26 04:22:33 Krasnoyarsk Krai, Russia
1802965 1802965 2021-11-25 Russia Kurgan Oblast     44058 857 0   55.7655302 64.5632681 2021-11-26 04:22:33 Kurgan Oblast, Russia
1802966 1802966 2021-11-25 Russia Kursk Oblast     74891 1760 0   51.6568453 36.4852695 2021-11-26 04:22:33 Kursk Oblast, Russia
1802967 1802967 2021-11-25 Russia Leningrad Oblast     88541 2752 0   60.185329599999996 32.3925325 2021-11-26 04:22:33 Leningrad Oblast, Russia
1802968 1802968 2021-11-25 Russia Lipetsk Oblast     72651 2366 0   52.693517799999995 39.112266399999996 2021-11-26 04:22:33 Lipetsk Oblast, Russia
1802969 1802969 2021-11-25 Russia Magadan Oblast     12607 310 0   62.48858785 153.9903764 2021-11-26 04:22:33 Magadan Oblast, Russia
1802970 1802970 2021-11-25 Russia Mari El Republic     25679 744 0   56.576750399999995 47.881751200000004 2021-11-26 04:22:33 Mari El Republic, Russia
1802971 1802971 2021-11-25 Russia Mordovia Republic     35857 860 0   54.4419829 44.466114399999995 2021-11-26 04:22:33 Mordovia Republic, Russia
1802972 1802972 2021-11-25 Russia Moscow     1930050 33727 0   55.7504461 37.6174943 2021-11-26 04:22:33 Moscow, Russia
1802973 1802973 2021-11-25 Russia Moscow Oblast     579390 10176 0   55.50431579999999 38.0353929 2021-11-26 04:22:33 Moscow Oblast, Russia
1802974 1802974 2021-11-25 Russia Murmansk Oblast     85421 2520 0   68.00004179999999 33.9999151 2021-11-26 04:22:33 Murmansk Oblast, Russia
1802975 1802975 2021-11-25 Russia Nenets Autonomous Okrug     3159 72 0   68.27557185 57.1686375 2021-11-26 04:22:33 Nenets Autonomous Okrug, Russia
1802976 1802976 2021-11-25 Russia Nizhny Novgorod Oblast     210751 8694 0   55.47180329999999 44.091159399999995 2021-11-26 04:22:33 Nizhny Novgorod Oblast, Russia
1802977 1802977 2021-11-25 Russia North Ossetia - Alania Republic     28058 738 0   42.79336110000001 44.6324493 2021-11-26 04:22:33 North Ossetia - Alania Republic, Russia
1802978 1802978 2021-11-25 Russia Novgorod Oblast     58102 583 0   58.2843833 32.516975699999996 2021-11-26 04:22:33 Novgorod Oblast, Russia
1802979 1802979 2021-11-25 Russia Novosibirsk Oblast     80755 3719 0   54.9720169 79.48139240000002 2021-11-26 04:22:33 Novosibirsk Oblast, Russia
1802980 1802980 2021-11-25 Russia Omsk Oblast     111643 2758 0   56.09352629999999 73.5099936 2021-11-26 04:22:33 Omsk Oblast, Russia
1802981 1802981 2021-11-25 Russia Orel Oblast     61755 1260 0   52.96854329999999 36.0692477 2021-11-26 04:22:33 Orel Oblast, Russia
1802982 1802982 2021-11-25 Russia Orenburg Oblast     99233 3087 0   52.02692620000001 54.7276647 2021-11-26 04:22:33 Orenburg Oblast, Russia
1802983 1802983 2021-11-25 Russia Penza Oblast     89935 4119 0   53.1655415 44.78791810000001 2021-11-26 04:22:33 Penza Oblast, Russia
1802984 1802984 2021-11-25 Russia Perm Krai     137307 6722 0   58.5951603 56.3159546 2021-11-26 04:22:33 Perm Krai, Russia
1802985 1802985 2021-11-25 Russia Primorsky Krai     85736 1379 0   45.0819456 134.726645 2021-11-26 04:22:33 Primorsky Krai, Russia
1802986 1802986 2021-11-25 Russia Pskov Oblast     64856 1048 0   57.535872899999994 28.8586826 2021-11-26 04:22:33 Pskov Oblast, Russia
1802987 1802987 2021-11-25 Russia Rostov Oblast     172285 8540 0   47.6222451 40.7957942 2021-11-26 04:22:33 Rostov Oblast, Russia
1802988 1802988 2021-11-25 Russia Ryazan Oblast     54311 1870 0   54.42267320000001 40.57052460000001 2021-11-26 04:22:33 Ryazan Oblast, Russia
1802989 1802989 2021-11-25 Russia Saint Petersburg     777333 25867 0   59.960673899999996 30.158655100000004 2021-11-26 04:22:33 Saint Petersburg, Russia
1802990 1802990 2021-11-25 Russia Sakha (Yakutiya) Republic     69190 1674 0   66.941626 129.642371 2021-11-26 04:22:33 Sakha (Yakutiya) Republic, Russia
1802991 1802991 2021-11-25 Russia Sakhalin Oblast     37269 427 0   49.7219665 143.448533 2021-11-26 04:22:33 Sakhalin Oblast, Russia
1802992 1802992 2021-11-25 Russia Samara Oblast     174767 5331 0   53.2128813 50.8914633 2021-11-26 04:22:33 Samara Oblast, Russia
1802993 1802993 2021-11-25 Russia Saratov Oblast     117246 4497 0   51.652055499999996 46.86319520000001 2021-11-26 04:22:33 Saratov Oblast, Russia
1802994 1802994 2021-11-25 Russia Smolensk Oblast     76175 2100 0   55.03434960000001 33.0192065 2021-11-26 04:22:33 Smolensk Oblast, Russia
1802995 1802995 2021-11-25 Russia Stavropol Krai     110362 5033 0   44.86325770000001 43.4406913 2021-11-26 04:22:33 Stavropol Krai, Russia
1802996 1802996 2021-11-25 Russia Sverdlovsk Oblast     175691 8262 0   58.6414755 61.802154599999994 2021-11-26 04:22:33 Sverdlovsk Oblast, Russia
1802997 1802997 2021-11-25 Russia Tambov Oblast     53611 1371 0   52.9019574 41.3578918 2021-11-26 04:22:33 Tambov Oblast, Russia
1802998 1802998 2021-11-25 Russia Tatarstan Republic     36808 1205 0   55.7648572 52.43104273 2021-11-26 04:22:33 Tatarstan Republic, Russia
1802999 1802999 2021-11-25 Russia Tomsk Oblast     54584 622 0   58.6124279 82.04753149999998 2021-11-26 04:22:33 Tomsk Oblast, Russia
1803000 1803000 2021-11-25 Russia Tula Oblast     66713 3841 0   53.9570701 37.369090899999996 2021-11-26 04:22:33 Tula Oblast, Russia
1803001 1803001 2021-11-25 Russia Tver Oblast     86517 2061 0   57.1134475 35.174442799999994 2021-11-26 04:22:33 Tver Oblast, Russia
1803002 1803002 2021-11-25 Russia Tyumen Oblast     79289 2769 0   58.8206488 70.36588370000001 2021-11-26 04:22:33 Tyumen Oblast, Russia
1803003 1803003 2021-11-25 Russia Tyva Republic     30311 294 0   51.401714899999995 93.8582593 2021-11-26 04:22:33 Tyva Republic, Russia
1803004 1803004 2021-11-25 Russia Udmurt Republic     73327 3007 0   57.1961165 52.69598320000001 2021-11-26 04:22:33 Udmurt Republic, Russia
1803005 1803005 2021-11-25 Russia Ulyanovsk Oblast     108821 3306 0   54.146317700000004 47.2324921 2021-11-26 04:22:33 Ulyanovsk Oblast, Russia
1803006 1803006 2021-11-25 Russia Vladimir Oblast     70881 2447 0   56.0503336 40.656163299999996 2021-11-26 04:22:33 Vladimir Oblast, Russia
1803007 1803007 2021-11-25 Russia Volgograd Oblast     115565 4396 0   49.604833899999996 44.29035820000001 2021-11-26 04:22:33 Volgograd Oblast, Russia
1803008 1803008 2021-11-25 Russia Vologda Oblast     88177 2511 0   60.0391461 43.1215213 2021-11-26 04:22:33 Vologda Oblast, Russia
1803009 1803009 2021-11-25 Russia Voronezh Oblast     173483 5592 0   50.9800393 40.15065070000001 2021-11-26 04:22:33 Voronezh Oblast, Russia
1803010 1803010 2021-11-25 Russia Yamalo-Nenets Autonomous Okrug     57787 843 0   67.1471631 74.3415488 2021-11-26 04:22:33 Yamalo-Nenets Autonomous Okrug, Russia
1803011 1803011 2021-11-25 Russia Yaroslavl Oblast     76014 1526 0   57.77819760000001 39.002109499999996 2021-11-26 04:22:33 Yaroslavl Oblast, Russia
1803012 1803012 2021-11-25 Russia Zabaykalsky Krai     85984 1582 0   52.248521000000004 115.956325 2021-11-26 04:22:33 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]);