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-12-18 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
2399002 2399002 2021-12-17 Russia Adygea Republic     26020 698 0   44.6939006 40.1520421 2021-12-18 02:22:20 Adygea Republic, Russia
2399003 2399003 2021-12-17 Russia Altai Krai     112820 6212 0   52.693224300000004 82.69314240000001 2021-12-18 02:22:20 Altai Krai, Russia
2399004 2399004 2021-12-17 Russia Altai Republic     24908 490 0   50.7114101 86.8572186 2021-12-18 02:22:20 Altai Republic, Russia
2399005 2399005 2021-12-17 Russia Amur Oblast     50967 577 0   52.8032368 128.437295 2021-12-18 02:22:20 Amur Oblast, Russia
2399006 2399006 2021-12-17 Russia Arkhangelsk Oblast     119524 1469 0   63.5589686 43.1221646 2021-12-18 02:22:20 Arkhangelsk Oblast, Russia
2399007 2399007 2021-12-17 Russia Astrakhan Oblast     78121 2290 0   47.1878186 47.608851 2021-12-18 02:22:20 Astrakhan Oblast, Russia
2399008 2399008 2021-12-17 Russia Bashkortostan Republic     116309 4095 0   54.8573563 57.1439682 2021-12-18 02:22:20 Bashkortostan Republic, Russia
2399009 2399009 2021-12-17 Russia Belgorod Oblast     78316 1660 0   50.7080119 37.5837615 2021-12-18 02:22:20 Belgorod Oblast, Russia
2399010 2399010 2021-12-17 Russia Bryansk Oblast     93517 2642 0   52.887331499999995 33.41585300000001 2021-12-18 02:22:20 Bryansk Oblast, Russia
2399011 2399011 2021-12-17 Russia Buryatia Republic     73482 2317 0   52.718242599999996 109.492143 2021-12-18 02:22:20 Buryatia Republic, Russia
2399012 2399012 2021-12-17 Russia Chechen Republic     29949 879 0   43.39761470000001 45.6985005 2021-12-18 02:22:20 Chechen Republic, Russia
2399013 2399013 2021-12-17 Russia Chelyabinsk Oblast     137546 5640 0   54.4223954 61.1865846 2021-12-18 02:22:20 Chelyabinsk Oblast, Russia
2399014 2399014 2021-12-17 Russia Chukotka Autonomous Okrug     2932 32 0   66.0006475 169.4900869 2021-12-18 02:22:20 Chukotka Autonomous Okrug, Russia
2399015 2399015 2021-12-17 Russia Chuvashia Republic     45327 3620 0   55.4259922 47.0849429 2021-12-18 02:22:20 Chuvashia Republic, Russia
2399016 2399016 2021-12-17 Russia Dagestan Republic     64008 3093 0   43.05749160000001 47.1332224 2021-12-18 02:22:20 Dagestan Republic, Russia
2399017 2399017 2021-12-17 Russia Ingushetia Republic     27567 452 0   43.11542075 45.01713552 2021-12-18 02:22:20 Ingushetia Republic, Russia
2399018 2399018 2021-12-17 Russia Irkutsk Oblast     148913 6634 0   56.6370122 104.71922099999999 2021-12-18 02:22:20 Irkutsk Oblast, Russia
2399019 2399019 2021-12-17 Russia Ivanovo Oblast     65456 2340 0   56.9167446 41.43521370000001 2021-12-18 02:22:20 Ivanovo Oblast, Russia
2399020 2399020 2021-12-17 Russia Jewish Autonomous Okrug     11184 379 0   48.57527615 132.66307460000002 2021-12-18 02:22:20 Jewish Autonomous Okrug, Russia
2399021 2399021 2021-12-17 Russia Kabardino-Balkarian Republic     40646 1340 0   43.480604799999995 43.5978976 2021-12-18 02:22:20 Kabardino-Balkarian Republic, Russia
2399022 2399022 2021-12-17 Russia Kaliningrad Oblast     79562 1167 0   54.7293041 21.1489473 2021-12-18 02:22:20 Kaliningrad Oblast, Russia
2399023 2399023 2021-12-17 Russia Kalmykia Republic     33772 714 0   46.2313018 45.3275745 2021-12-18 02:22:20 Kalmykia Republic, Russia
2399024 2399024 2021-12-17 Russia Kaluga Oblast     62612 1135 0   54.438277299999996 35.5272854 2021-12-18 02:22:20 Kaluga Oblast, Russia
2399025 2399025 2021-12-17 Russia Kamchatka Krai     23255 502 0   57.191488199999995 160.03838190000005 2021-12-18 02:22:20 Kamchatka Krai, Russia
2399026 2399026 2021-12-17 Russia Karachay-Cherkess Republic     31320 897 0   43.7368326 41.7267991 2021-12-18 02:22:20 Karachay-Cherkess Republic, Russia
2399027 2399027 2021-12-17 Russia Karelia Republic     87261 1142 0   62.61940309999999 33.4920267 2021-12-18 02:22:20 Karelia Republic, Russia
2399028 2399028 2021-12-17 Russia Kemerovo Oblast     80148 1647 0   54.53357809999999 87.342861 2021-12-18 02:22:20 Kemerovo Oblast, Russia
2399029 2399029 2021-12-17 Russia Khabarovsk Krai     118739 1160 0   51.6312684 136.121524 2021-12-18 02:22:20 Khabarovsk Krai, Russia
2399030 2399030 2021-12-17 Russia Khakassia Republic     52262 1812 0   53.72258845 91.44293627 2021-12-18 02:22:20 Khakassia Republic, Russia
2399031 2399031 2021-12-17 Russia Khanty-Mansi Autonomous Okrug     93317 1879 0   61.0259025 69.0982628 2021-12-18 02:22:20 Khanty-Mansi Autonomous Okrug, Russia
2399032 2399032 2021-12-17 Russia Kirov Oblast     75860 721 0   57.9665589 49.4074599 2021-12-18 02:22:20 Kirov Oblast, Russia
2399033 2399033 2021-12-17 Russia Komi Republic     94504 2494 0   63.9881421 54.3326073 2021-12-18 02:22:20 Komi Republic, Russia
2399034 2399034 2021-12-17 Russia Kostroma Oblast     47518 1053 0   58.424756 44.253327299999995 2021-12-18 02:22:20 Kostroma Oblast, Russia
2399035 2399035 2021-12-17 Russia Krasnodar Krai     111174 9454 0   45.768401399999995 39.0261044 2021-12-18 02:22:20 Krasnodar Krai, Russia
2399036 2399036 2021-12-17 Russia Krasnoyarsk Krai     164916 8099 0   63.3233807 97.09799740000001 2021-12-18 02:22:20 Krasnoyarsk Krai, Russia
2399037 2399037 2021-12-17 Russia Kurgan Oblast     48276 954 0   55.7655302 64.5632681 2021-12-18 02:22:20 Kurgan Oblast, Russia
2399038 2399038 2021-12-17 Russia Kursk Oblast     79987 1929 0   51.6568453 36.4852695 2021-12-18 02:22:20 Kursk Oblast, Russia
2399039 2399039 2021-12-17 Russia Leningrad Oblast     96728 2949 0   60.185329599999996 32.3925325 2021-12-18 02:22:20 Leningrad Oblast, Russia
2399040 2399040 2021-12-17 Russia Lipetsk Oblast     80608 2638 0   52.693517799999995 39.112266399999996 2021-12-18 02:22:20 Lipetsk Oblast, Russia
2399041 2399041 2021-12-17 Russia Magadan Oblast     13347 331 0   62.48858785 153.9903764 2021-12-18 02:22:20 Magadan Oblast, Russia
2399042 2399042 2021-12-17 Russia Mari El Republic     28327 898 0   56.576750399999995 47.881751200000004 2021-12-18 02:22:20 Mari El Republic, Russia
2399043 2399043 2021-12-17 Russia Mordovia Republic     39085 971 0   54.4419829 44.466114399999995 2021-12-18 02:22:20 Mordovia Republic, Russia
2399044 2399044 2021-12-17 Russia Moscow     1997784 35726 0   55.7504461 37.6174943 2021-12-18 02:22:20 Moscow, Russia
2399045 2399045 2021-12-17 Russia Moscow Oblast     620908 11382 0   55.50431579999999 38.0353929 2021-12-18 02:22:20 Moscow Oblast, Russia
2399046 2399046 2021-12-17 Russia Murmansk Oblast     89573 2674 0   68.00004179999999 33.9999151 2021-12-18 02:22:20 Murmansk Oblast, Russia
2399047 2399047 2021-12-17 Russia Nenets Autonomous Okrug     3407 84 0   68.27557185 57.1686375 2021-12-18 02:22:20 Nenets Autonomous Okrug, Russia
2399048 2399048 2021-12-17 Russia Nizhny Novgorod Oblast     225108 9450 0   55.47180329999999 44.091159399999995 2021-12-18 02:22:20 Nizhny Novgorod Oblast, Russia
2399049 2399049 2021-12-17 Russia North Ossetia - Alania Republic     29902 872 0   42.79336110000001 44.6324493 2021-12-18 02:22:20 North Ossetia - Alania Republic, Russia
2399050 2399050 2021-12-17 Russia Novgorod Oblast     63102 718 0   58.2843833 32.516975699999996 2021-12-18 02:22:20 Novgorod Oblast, Russia
2399051 2399051 2021-12-17 Russia Novosibirsk Oblast     89396 4042 0   54.9720169 79.48139240000002 2021-12-18 02:22:20 Novosibirsk Oblast, Russia
2399052 2399052 2021-12-17 Russia Omsk Oblast     124270 3026 0   56.09352629999999 73.5099936 2021-12-18 02:22:20 Omsk Oblast, Russia
2399053 2399053 2021-12-17 Russia Orel Oblast     67734 1405 0   52.96854329999999 36.0692477 2021-12-18 02:22:20 Orel Oblast, Russia
2399054 2399054 2021-12-17 Russia Orenburg Oblast     105531 3329 0   52.02692620000001 54.7276647 2021-12-18 02:22:20 Orenburg Oblast, Russia
2399055 2399055 2021-12-17 Russia Penza Oblast     97759 4488 0   53.1655415 44.78791810000001 2021-12-18 02:22:20 Penza Oblast, Russia
2399056 2399056 2021-12-17 Russia Perm Krai     152350 7202 0   58.5951603 56.3159546 2021-12-18 02:22:20 Perm Krai, Russia
2399057 2399057 2021-12-17 Russia Primorsky Krai     95824 1481 0   45.0819456 134.726645 2021-12-18 02:22:20 Primorsky Krai, Russia
2399058 2399058 2021-12-17 Russia Pskov Oblast     69055 1181 0   57.535872899999994 28.8586826 2021-12-18 02:22:20 Pskov Oblast, Russia
2399059 2399059 2021-12-17 Russia Rostov Oblast     186610 9269 0   47.6222451 40.7957942 2021-12-18 02:22:20 Rostov Oblast, Russia
2399060 2399060 2021-12-17 Russia Ryazan Oblast     59176 2302 0   54.42267320000001 40.57052460000001 2021-12-18 02:22:20 Ryazan Oblast, Russia
2399061 2399061 2021-12-17 Russia Saint Petersburg     825296 27191 0   59.960673899999996 30.158655100000004 2021-12-18 02:22:20 Saint Petersburg, Russia
2399062 2399062 2021-12-17 Russia Sakha (Yakutiya) Republic     74429 1743 0   66.941626 129.642371 2021-12-18 02:22:20 Sakha (Yakutiya) Republic, Russia
2399063 2399063 2021-12-17 Russia Sakhalin Oblast     40224 489 0   49.7219665 143.448533 2021-12-18 02:22:20 Sakhalin Oblast, Russia
2399064 2399064 2021-12-17 Russia Samara Oblast     192899 6016 0   53.2128813 50.8914633 2021-12-18 02:22:20 Samara Oblast, Russia
2399065 2399065 2021-12-17 Russia Saratov Oblast     128548 4901 0   51.652055499999996 46.86319520000001 2021-12-18 02:22:20 Saratov Oblast, Russia
2399066 2399066 2021-12-17 Russia Smolensk Oblast     82100 2265 0   55.03434960000001 33.0192065 2021-12-18 02:22:20 Smolensk Oblast, Russia
2399067 2399067 2021-12-17 Russia Stavropol Krai     120594 5730 0   44.86325770000001 43.4406913 2021-12-18 02:22:20 Stavropol Krai, Russia
2399068 2399068 2021-12-17 Russia Sverdlovsk Oblast     190617 8989 0   58.6414755 61.802154599999994 2021-12-18 02:22:20 Sverdlovsk Oblast, Russia
2399069 2399069 2021-12-17 Russia Tambov Oblast     58249 1586 0   52.9019574 41.3578918 2021-12-18 02:22:20 Tambov Oblast, Russia
2399070 2399070 2021-12-17 Russia Tatarstan Republic     41388 1363 0   55.7648572 52.43104273 2021-12-18 02:22:20 Tatarstan Republic, Russia
2399071 2399071 2021-12-17 Russia Tomsk Oblast     59594 656 0   58.6124279 82.04753149999998 2021-12-18 02:22:20 Tomsk Oblast, Russia
2399072 2399072 2021-12-17 Russia Tula Oblast     72015 4087 0   53.9570701 37.369090899999996 2021-12-18 02:22:20 Tula Oblast, Russia
2399073 2399073 2021-12-17 Russia Tver Oblast     94488 2246 0   57.1134475 35.174442799999994 2021-12-18 02:22:20 Tver Oblast, Russia
2399074 2399074 2021-12-17 Russia Tyumen Oblast     86080 3195 0   58.8206488 70.36588370000001 2021-12-18 02:22:20 Tyumen Oblast, Russia
2399075 2399075 2021-12-17 Russia Tyva Republic     31342 317 0   51.401714899999995 93.8582593 2021-12-18 02:22:20 Tyva Republic, Russia
2399076 2399076 2021-12-17 Russia Udmurt Republic     77858 3176 0   57.1961165 52.69598320000001 2021-12-18 02:22:20 Udmurt Republic, Russia
2399077 2399077 2021-12-17 Russia Ulyanovsk Oblast     116824 3602 0   54.146317700000004 47.2324921 2021-12-18 02:22:20 Ulyanovsk Oblast, Russia
2399078 2399078 2021-12-17 Russia Vladimir Oblast     77577 2881 0   56.0503336 40.656163299999996 2021-12-18 02:22:20 Vladimir Oblast, Russia
2399079 2399079 2021-12-17 Russia Volgograd Oblast     124779 5194 0   49.604833899999996 44.29035820000001 2021-12-18 02:22:20 Volgograd Oblast, Russia
2399080 2399080 2021-12-17 Russia Vologda Oblast     96189 2793 0   60.0391461 43.1215213 2021-12-18 02:22:20 Vologda Oblast, Russia
2399081 2399081 2021-12-17 Russia Voronezh Oblast     188479 6469 0   50.9800393 40.15065070000001 2021-12-18 02:22:20 Voronezh Oblast, Russia
2399082 2399082 2021-12-17 Russia Yamalo-Nenets Autonomous Okrug     60584 921 0   67.1471631 74.3415488 2021-12-18 02:22:20 Yamalo-Nenets Autonomous Okrug, Russia
2399083 2399083 2021-12-17 Russia Yaroslavl Oblast     82044 1717 0   57.77819760000001 39.002109499999996 2021-12-18 02:22:20 Yaroslavl Oblast, Russia
2399084 2399084 2021-12-17 Russia Zabaykalsky Krai     92959 1729 0   52.248521000000004 115.956325 2021-12-18 02:22:20 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]);