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-09-11 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
3449027 3449027 2021-09-10 Russia Adygea Republic     18625 367 0   44.6939006 40.1520421 2021-09-11 04:21:30 Adygea Republic, Russia
3449028 3449028 2021-09-10 Russia Altai Krai     72843 3788 0   52.693224300000004 82.69314240000001 2021-09-11 04:21:30 Altai Krai, Russia
3449029 3449029 2021-09-10 Russia Altai Republic     20966 329 0   50.7114101 86.8572186 2021-09-11 04:21:30 Altai Republic, Russia
3449030 3449030 2021-09-10 Russia Amur Oblast     33123 411 0   52.8032368 128.437295 2021-09-11 04:21:30 Amur Oblast, Russia
3449031 3449031 2021-09-10 Russia Arkhangelsk Oblast     84082 1160 0   63.5589686 43.1221646 2021-09-11 04:21:30 Arkhangelsk Oblast, Russia
3449032 3449032 2021-09-10 Russia Astrakhan Oblast     55166 1533 0   47.1878186 47.608851 2021-09-11 04:21:30 Astrakhan Oblast, Russia
3449033 3449033 2021-09-10 Russia Bashkortostan Republic     60071 1264 0   54.8573563 57.1439682 2021-09-11 04:21:30 Bashkortostan Republic, Russia
3449034 3449034 2021-09-10 Russia Belgorod Oblast     50556 1054 0   50.7080119 37.5837615 2021-09-11 04:21:30 Belgorod Oblast, Russia
3449035 3449035 2021-09-10 Russia Bryansk Oblast     62134 1235 0   52.887331499999995 33.41585300000001 2021-09-11 04:21:30 Bryansk Oblast, Russia
3449036 3449036 2021-09-10 Russia Buryatia Republic     57176 1801 0   52.718242599999996 109.492143 2021-09-11 04:21:30 Buryatia Republic, Russia
3449037 3449037 2021-09-10 Russia Chechen Republic     21363 539 0   43.39761470000001 45.6985005 2021-09-11 04:21:30 Chechen Republic, Russia
3449038 3449038 2021-09-10 Russia Chelyabinsk Oblast     88673 2949 0   54.4223954 61.1865846 2021-09-11 04:21:30 Chelyabinsk Oblast, Russia
3449039 3449039 2021-09-10 Russia Chukotka Autonomous Okrug     1586 11 0   66.0006475 169.4900869 2021-09-11 04:21:30 Chukotka Autonomous Okrug, Russia
3449040 3449040 2021-09-10 Russia Chuvashia Republic     32433 2113 0   55.4259922 47.0849429 2021-09-11 04:21:30 Chuvashia Republic, Russia
3449041 3449041 2021-09-10 Russia Dagestan Republic     49434 2340 0   43.05749160000001 47.1332224 2021-09-11 04:21:30 Dagestan Republic, Russia
3449042 3449042 2021-09-10 Russia Ingushetia Republic     20282 291 0   43.11542075 45.01713552 2021-09-11 04:21:30 Ingushetia Republic, Russia
3449043 3449043 2021-09-10 Russia Irkutsk Oblast     101593 4565 0   56.6370122 104.71922099999999 2021-09-11 04:21:30 Irkutsk Oblast, Russia
3449044 3449044 2021-09-10 Russia Ivanovo Oblast     46388 1517 0   56.9167446 41.43521370000001 2021-09-11 04:21:30 Ivanovo Oblast, Russia
3449045 3449045 2021-09-10 Russia Jewish Autonomous Okrug     7335 229 0   48.57527615 132.66307460000002 2021-09-11 04:21:30 Jewish Autonomous Okrug, Russia
3449046 3449046 2021-09-10 Russia Kabardino-Balkarian Republic     30491 739 0   43.480604799999995 43.5978976 2021-09-11 04:21:30 Kabardino-Balkarian Republic, Russia
3449047 3449047 2021-09-10 Russia Kaliningrad Oblast     50567 669 0   54.7293041 21.1489473 2021-09-11 04:21:30 Kaliningrad Oblast, Russia
3449048 3449048 2021-09-10 Russia Kalmykia Republic     28969 561 0   46.2313018 45.3275745 2021-09-11 04:21:30 Kalmykia Republic, Russia
3449049 3449049 2021-09-10 Russia Kaluga Oblast     46028 629 0   54.438277299999996 35.5272854 2021-09-11 04:21:30 Kaluga Oblast, Russia
3449050 3449050 2021-09-10 Russia Kamchatka Krai     18880 276 0   57.191488199999995 160.03838190000005 2021-09-11 04:21:30 Kamchatka Krai, Russia
3449051 3449051 2021-09-10 Russia Karachay-Cherkess Republic     24500 505 0   43.7368326 41.7267991 2021-09-11 04:21:30 Karachay-Cherkess Republic, Russia
3449052 3449052 2021-09-10 Russia Karelia Republic     62359 802 0   62.61940309999999 33.4920267 2021-09-11 04:21:30 Karelia Republic, Russia
3449053 3449053 2021-09-10 Russia Kemerovo Oblast     53403 1189 0   54.53357809999999 87.342861 2021-09-11 04:21:30 Kemerovo Oblast, Russia
3449054 3449054 2021-09-10 Russia Khabarovsk Krai     78195 726 0   51.6312684 136.121524 2021-09-11 04:21:30 Khabarovsk Krai, Russia
3449055 3449055 2021-09-10 Russia Khakassia Republic     36516 1011 0   53.72258845 91.44293627 2021-09-11 04:21:30 Khakassia Republic, Russia
3449056 3449056 2021-09-10 Russia Khanty-Mansi Autonomous Okrug     71994 1080 0   61.0259025 69.0982628 2021-09-11 04:21:30 Khanty-Mansi Autonomous Okrug, Russia
3449057 3449057 2021-09-10 Russia Kirov Oblast     55164 497 0   57.9665589 49.4074599 2021-09-11 04:21:30 Kirov Oblast, Russia
3449058 3449058 2021-09-10 Russia Komi Republic     65613 1562 0   63.9881421 54.3326073 2021-09-11 04:21:30 Komi Republic, Russia
3449059 3449059 2021-09-10 Russia Kostroma Oblast     31850 716 0   58.424756 44.253327299999995 2021-09-11 04:21:30 Kostroma Oblast, Russia
3449060 3449060 2021-09-10 Russia Krasnodar Krai     69386 5563 0   45.768401399999995 39.0261044 2021-09-11 04:21:30 Krasnodar Krai, Russia
3449061 3449061 2021-09-10 Russia Krasnoyarsk Krai     108972 5393 0   63.3233807 97.09799740000001 2021-09-11 04:21:30 Krasnoyarsk Krai, Russia
3449062 3449062 2021-09-10 Russia Kurgan Oblast     31009 639 0   55.7655302 64.5632681 2021-09-11 04:21:30 Kurgan Oblast, Russia
3449063 3449063 2021-09-10 Russia Kursk Oblast     53945 1332 0   51.6568453 36.4852695 2021-09-11 04:21:30 Kursk Oblast, Russia
3449064 3449064 2021-09-10 Russia Leningrad Oblast     64977 2426 0   60.185329599999996 32.3925325 2021-09-11 04:21:30 Leningrad Oblast, Russia
3449065 3449065 2021-09-10 Russia Lipetsk Oblast     48839 1494 0   52.693517799999995 39.112266399999996 2021-09-11 04:21:30 Lipetsk Oblast, Russia
3449066 3449066 2021-09-10 Russia Magadan Oblast     10597 242 0   62.48858785 153.9903764 2021-09-11 04:21:30 Magadan Oblast, Russia
3449067 3449067 2021-09-10 Russia Mari El Republic     18543 538 0   56.576750399999995 47.881751200000004 2021-09-11 04:21:30 Mari El Republic, Russia
3449068 3449068 2021-09-10 Russia Mordovia Republic     26711 508 0   54.4419829 44.466114399999995 2021-09-11 04:21:30 Mordovia Republic, Russia
3449069 3449069 2021-09-10 Russia Moscow     1582641 27935 0   55.7504461 37.6174943 2021-09-11 04:21:30 Moscow, Russia
3449070 3449070 2021-09-10 Russia Moscow Oblast     429257 7943 0   55.50431579999999 38.0353929 2021-09-11 04:21:30 Moscow Oblast, Russia
3449071 3449071 2021-09-10 Russia Murmansk Oblast     69612 1915 0   68.00004179999999 33.9999151 2021-09-11 04:21:30 Murmansk Oblast, Russia
3449072 3449072 2021-09-10 Russia Nenets Autonomous Okrug     2052 38 0   68.27557185 57.1686375 2021-09-11 04:21:30 Nenets Autonomous Okrug, Russia
3449073 3449073 2021-09-10 Russia Nizhny Novgorod Oblast     160034 6062 0   55.47180329999999 44.091159399999995 2021-09-11 04:21:30 Nizhny Novgorod Oblast, Russia
3449074 3449074 2021-09-10 Russia North Ossetia - Alania Republic     21571 463 0   42.79336110000001 44.6324493 2021-09-11 04:21:30 North Ossetia - Alania Republic, Russia
3449075 3449075 2021-09-10 Russia Novgorod Oblast     41691 403 0   58.2843833 32.516975699999996 2021-09-11 04:21:30 Novgorod Oblast, Russia
3449076 3449076 2021-09-10 Russia Novosibirsk Oblast     60178 2765 0   54.9720169 79.48139240000002 2021-09-11 04:21:30 Novosibirsk Oblast, Russia
3449077 3449077 2021-09-10 Russia Omsk Oblast     77073 2006 0   56.09352629999999 73.5099936 2021-09-11 04:21:30 Omsk Oblast, Russia
3449078 3449078 2021-09-10 Russia Orel Oblast     44021 960 0   52.96854329999999 36.0692477 2021-09-11 04:21:30 Orel Oblast, Russia
3449079 3449079 2021-09-10 Russia Orenburg Oblast     70535 1676 0   52.02692620000001 54.7276647 2021-09-11 04:21:30 Orenburg Oblast, Russia
3449080 3449080 2021-09-10 Russia Penza Oblast     65833 2317 0   53.1655415 44.78791810000001 2021-09-11 04:21:30 Penza Oblast, Russia
3449081 3449081 2021-09-10 Russia Perm Krai     92378 4326 0   58.5951603 56.3159546 2021-09-11 04:21:30 Perm Krai, Russia
3449082 3449082 2021-09-10 Russia Primorsky Krai     64566 1080 0   45.0819456 134.726645 2021-09-11 04:21:30 Primorsky Krai, Russia
3449083 3449083 2021-09-10 Russia Pskov Oblast     47788 709 0   57.535872899999994 28.8586826 2021-09-11 04:21:30 Pskov Oblast, Russia
3449084 3449084 2021-09-10 Russia Rostov Oblast     129167 6265 0   47.6222451 40.7957942 2021-09-11 04:21:30 Rostov Oblast, Russia
3449085 3449085 2021-09-10 Russia Ryazan Oblast     39974 1002 0   54.42267320000001 40.57052460000001 2021-09-11 04:21:30 Ryazan Oblast, Russia
3449086 3449086 2021-09-10 Russia Saint Petersburg     588903 20936 0   59.960673899999996 30.158655100000004 2021-09-11 04:21:30 Saint Petersburg, Russia
3449087 3449087 2021-09-10 Russia Sakha (Yakutiya) Republic     50525 1098 0   66.941626 129.642371 2021-09-11 04:21:30 Sakha (Yakutiya) Republic, Russia
3449088 3449088 2021-09-10 Russia Sakhalin Oblast     31531 253 0   49.7219665 143.448533 2021-09-11 04:21:30 Sakhalin Oblast, Russia
3449089 3449089 2021-09-10 Russia Samara Oblast     94767 3458 0   53.2128813 50.8914633 2021-09-11 04:21:30 Samara Oblast, Russia
3449090 3449090 2021-09-10 Russia Saratov Oblast     83235 2517 0   51.652055499999996 46.86319520000001 2021-09-11 04:21:30 Saratov Oblast, Russia
3449091 3449091 2021-09-10 Russia Smolensk Oblast     46875 1574 0   55.03434960000001 33.0192065 2021-09-11 04:21:30 Smolensk Oblast, Russia
3449092 3449092 2021-09-10 Russia Stavropol Krai     78791 2540 0   44.86325770000001 43.4406913 2021-09-11 04:21:30 Stavropol Krai, Russia
3449093 3449093 2021-09-10 Russia Sverdlovsk Oblast     128698 5538 0   58.6414755 61.802154599999994 2021-09-11 04:21:30 Sverdlovsk Oblast, Russia
3449094 3449094 2021-09-10 Russia Tambov Oblast     41461 822 0   52.9019574 41.3578918 2021-09-11 04:21:30 Tambov Oblast, Russia
3449095 3449095 2021-09-10 Russia Tatarstan Republic     25957 704 0   55.7648572 52.43104273 2021-09-11 04:21:30 Tatarstan Republic, Russia
3449096 3449096 2021-09-10 Russia Tomsk Oblast     41844 550 0   58.6124279 82.04753149999998 2021-09-11 04:21:30 Tomsk Oblast, Russia
3449097 3449097 2021-09-10 Russia Tula Oblast     52423 2811 0   53.9570701 37.369090899999996 2021-09-11 04:21:30 Tula Oblast, Russia
3449098 3449098 2021-09-10 Russia Tver Oblast     62553 1578 0   57.1134475 35.174442799999994 2021-09-11 04:21:30 Tver Oblast, Russia
3449099 3449099 2021-09-10 Russia Tyumen Oblast     57238 1636 0   58.8206488 70.36588370000001 2021-09-11 04:21:30 Tyumen Oblast, Russia
3449100 3449100 2021-09-10 Russia Tyva Republic     25480 273 0   51.401714899999995 93.8582593 2021-09-11 04:21:30 Tyva Republic, Russia
3449101 3449101 2021-09-10 Russia Udmurt Republic     48612 1706 0   57.1961165 52.69598320000001 2021-09-11 04:21:30 Udmurt Republic, Russia
3449102 3449102 2021-09-10 Russia Ulyanovsk Oblast     77062 2390 0   54.146317700000004 47.2324921 2021-09-11 04:21:30 Ulyanovsk Oblast, Russia
3449103 3449103 2021-09-10 Russia Vladimir Oblast     50870 1782 0   56.0503336 40.656163299999996 2021-09-11 04:21:30 Vladimir Oblast, Russia
3449104 3449104 2021-09-10 Russia Volgograd Oblast     85204 2445 0   49.604833899999996 44.29035820000001 2021-09-11 04:21:30 Volgograd Oblast, Russia
3449105 3449105 2021-09-10 Russia Vologda Oblast     64006 1708 0   60.0391461 43.1215213 2021-09-11 04:21:30 Vologda Oblast, Russia
3449106 3449106 2021-09-10 Russia Voronezh Oblast     123207 4168 0   50.9800393 40.15065070000001 2021-09-11 04:21:30 Voronezh Oblast, Russia
3449107 3449107 2021-09-10 Russia Yamalo-Nenets Autonomous Okrug     48565 647 0   67.1471631 74.3415488 2021-09-11 04:21:30 Yamalo-Nenets Autonomous Okrug, Russia
3449108 3449108 2021-09-10 Russia Yaroslavl Oblast     57682 1079 0   57.77819760000001 39.002109499999996 2021-09-11 04:21:30 Yaroslavl Oblast, Russia
3449109 3449109 2021-09-10 Russia Zabaykalsky Krai     65439 1097 0   52.248521000000004 115.956325 2021-09-11 04:21:30 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]);