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-15 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
2462976 2462976 2021-09-14 Russia Adygea Republic     18835 380 0   44.6939006 40.1520421 2021-09-15 03:22:37 Adygea Republic, Russia
2462977 2462977 2021-09-14 Russia Altai Krai     73779 3867 0   52.693224300000004 82.69314240000001 2021-09-15 03:22:37 Altai Krai, Russia
2462978 2462978 2021-09-14 Russia Altai Republic     21080 334 0   50.7114101 86.8572186 2021-09-15 03:22:37 Altai Republic, Russia
2462979 2462979 2021-09-14 Russia Amur Oblast     33593 421 0   52.8032368 128.437295 2021-09-15 03:22:37 Amur Oblast, Russia
2462980 2462980 2021-09-14 Russia Arkhangelsk Oblast     85108 1161 0   63.5589686 43.1221646 2021-09-15 03:22:37 Arkhangelsk Oblast, Russia
2462981 2462981 2021-09-14 Russia Astrakhan Oblast     56257 1566 0   47.1878186 47.608851 2021-09-15 03:22:37 Astrakhan Oblast, Russia
2462982 2462982 2021-09-14 Russia Bashkortostan Republic     61302 1326 0   54.8573563 57.1439682 2021-09-15 03:22:37 Bashkortostan Republic, Russia
2462983 2462983 2021-09-14 Russia Belgorod Oblast     51155 1066 0   50.7080119 37.5837615 2021-09-15 03:22:37 Belgorod Oblast, Russia
2462984 2462984 2021-09-14 Russia Bryansk Oblast     62747 1275 0   52.887331499999995 33.41585300000001 2021-09-15 03:22:37 Bryansk Oblast, Russia
2462985 2462985 2021-09-14 Russia Buryatia Republic     57489 1804 0   52.718242599999996 109.492143 2021-09-15 03:22:37 Buryatia Republic, Russia
2462986 2462986 2021-09-14 Russia Chechen Republic     21598 553 0   43.39761470000001 45.6985005 2021-09-15 03:22:37 Chechen Republic, Russia
2462987 2462987 2021-09-14 Russia Chelyabinsk Oblast     90135 3035 0   54.4223954 61.1865846 2021-09-15 03:22:37 Chelyabinsk Oblast, Russia
2462988 2462988 2021-09-14 Russia Chukotka Autonomous Okrug     1634 13 0   66.0006475 169.4900869 2021-09-15 03:22:37 Chukotka Autonomous Okrug, Russia
2462989 2462989 2021-09-14 Russia Chuvashia Republic     32723 2150 0   55.4259922 47.0849429 2021-09-15 03:22:37 Chuvashia Republic, Russia
2462990 2462990 2021-09-14 Russia Dagestan Republic     49982 2381 0   43.05749160000001 47.1332224 2021-09-15 03:22:37 Dagestan Republic, Russia
2462991 2462991 2021-09-14 Russia Ingushetia Republic     20519 297 0   43.11542075 45.01713552 2021-09-15 03:22:37 Ingushetia Republic, Russia
2462992 2462992 2021-09-14 Russia Irkutsk Oblast     103083 4620 0   56.6370122 104.71922099999999 2021-09-15 03:22:37 Irkutsk Oblast, Russia
2462993 2462993 2021-09-14 Russia Ivanovo Oblast     46843 1532 0   56.9167446 41.43521370000001 2021-09-15 03:22:37 Ivanovo Oblast, Russia
2462994 2462994 2021-09-14 Russia Jewish Autonomous Okrug     7475 237 0   48.57527615 132.66307460000002 2021-09-15 03:22:37 Jewish Autonomous Okrug, Russia
2462995 2462995 2021-09-14 Russia Kabardino-Balkarian Republic     30773 749 0   43.480604799999995 43.5978976 2021-09-15 03:22:37 Kabardino-Balkarian Republic, Russia
2462996 2462996 2021-09-14 Russia Kaliningrad Oblast     51337 685 0   54.7293041 21.1489473 2021-09-15 03:22:37 Kaliningrad Oblast, Russia
2462997 2462997 2021-09-14 Russia Kalmykia Republic     29303 571 0   46.2313018 45.3275745 2021-09-15 03:22:37 Kalmykia Republic, Russia
2462998 2462998 2021-09-14 Russia Kaluga Oblast     46430 644 0   54.438277299999996 35.5272854 2021-09-15 03:22:37 Kaluga Oblast, Russia
2462999 2462999 2021-09-14 Russia Kamchatka Krai     19063 286 0   57.191488199999995 160.03838190000005 2021-09-15 03:22:37 Kamchatka Krai, Russia
2463000 2463000 2021-09-14 Russia Karachay-Cherkess Republic     24683 526 0   43.7368326 41.7267991 2021-09-15 03:22:37 Karachay-Cherkess Republic, Russia
2463001 2463001 2021-09-14 Russia Karelia Republic     62928 811 0   62.61940309999999 33.4920267 2021-09-15 03:22:37 Karelia Republic, Russia
2463002 2463002 2021-09-14 Russia Kemerovo Oblast     54077 1209 0   54.53357809999999 87.342861 2021-09-15 03:22:37 Kemerovo Oblast, Russia
2463003 2463003 2021-09-14 Russia Khabarovsk Krai     79387 738 0   51.6312684 136.121524 2021-09-15 03:22:37 Khabarovsk Krai, Russia
2463004 2463004 2021-09-14 Russia Khakassia Republic     36934 1020 0   53.72258845 91.44293627 2021-09-15 03:22:37 Khakassia Republic, Russia
2463005 2463005 2021-09-14 Russia Khanty-Mansi Autonomous Okrug     72581 1084 0   61.0259025 69.0982628 2021-09-15 03:22:37 Khanty-Mansi Autonomous Okrug, Russia
2463006 2463006 2021-09-14 Russia Kirov Oblast     55624 504 0   57.9665589 49.4074599 2021-09-15 03:22:37 Kirov Oblast, Russia
2463007 2463007 2021-09-14 Russia Komi Republic     66482 1591 0   63.9881421 54.3326073 2021-09-15 03:22:37 Komi Republic, Russia
2463008 2463008 2021-09-14 Russia Kostroma Oblast     32167 730 0   58.424756 44.253327299999995 2021-09-15 03:22:37 Kostroma Oblast, Russia
2463009 2463009 2021-09-14 Russia Krasnodar Krai     70325 5695 0   45.768401399999995 39.0261044 2021-09-15 03:22:37 Krasnodar Krai, Russia
2463010 2463010 2021-09-14 Russia Krasnoyarsk Krai     110391 5483 0   63.3233807 97.09799740000001 2021-09-15 03:22:37 Krasnoyarsk Krai, Russia
2463011 2463011 2021-09-14 Russia Kurgan Oblast     31471 650 0   55.7655302 64.5632681 2021-09-15 03:22:37 Kurgan Oblast, Russia
2463012 2463012 2021-09-14 Russia Kursk Oblast     54629 1355 0   51.6568453 36.4852695 2021-09-15 03:22:37 Kursk Oblast, Russia
2463013 2463013 2021-09-14 Russia Leningrad Oblast     65705 2433 0   60.185329599999996 32.3925325 2021-09-15 03:22:37 Leningrad Oblast, Russia
2463014 2463014 2021-09-14 Russia Lipetsk Oblast     49619 1525 0   52.693517799999995 39.112266399999996 2021-09-15 03:22:37 Lipetsk Oblast, Russia
2463015 2463015 2021-09-14 Russia Magadan Oblast     10693 245 0   62.48858785 153.9903764 2021-09-15 03:22:37 Magadan Oblast, Russia
2463016 2463016 2021-09-14 Russia Mari El Republic     18768 545 0   56.576750399999995 47.881751200000004 2021-09-15 03:22:37 Mari El Republic, Russia
2463017 2463017 2021-09-14 Russia Mordovia Republic     26984 518 0   54.4419829 44.466114399999995 2021-09-15 03:22:37 Mordovia Republic, Russia
2463018 2463018 2021-09-14 Russia Moscow     1589804 28111 0   55.7504461 37.6174943 2021-09-15 03:22:37 Moscow, Russia
2463019 2463019 2021-09-14 Russia Moscow Oblast     432174 7984 0   55.50431579999999 38.0353929 2021-09-15 03:22:37 Moscow Oblast, Russia
2463020 2463020 2021-09-14 Russia Murmansk Oblast     70178 1949 0   68.00004179999999 33.9999151 2021-09-15 03:22:37 Murmansk Oblast, Russia
2463021 2463021 2021-09-14 Russia Nenets Autonomous Okrug     2099 39 0   68.27557185 57.1686375 2021-09-15 03:22:37 Nenets Autonomous Okrug, Russia
2463022 2463022 2021-09-14 Russia Nizhny Novgorod Oblast     161716 6166 0   55.47180329999999 44.091159399999995 2021-09-15 03:22:37 Nizhny Novgorod Oblast, Russia
2463023 2463023 2021-09-14 Russia North Ossetia - Alania Republic     21841 508 0   42.79336110000001 44.6324493 2021-09-15 03:22:37 North Ossetia - Alania Republic, Russia
2463024 2463024 2021-09-14 Russia Novgorod Oblast     42191 407 0   58.2843833 32.516975699999996 2021-09-15 03:22:37 Novgorod Oblast, Russia
2463025 2463025 2021-09-14 Russia Novosibirsk Oblast     60857 2805 0   54.9720169 79.48139240000002 2021-09-15 03:22:37 Novosibirsk Oblast, Russia
2463026 2463026 2021-09-14 Russia Omsk Oblast     78558 2054 0   56.09352629999999 73.5099936 2021-09-15 03:22:37 Omsk Oblast, Russia
2463027 2463027 2021-09-14 Russia Orel Oblast     44351 966 0   52.96854329999999 36.0692477 2021-09-15 03:22:37 Orel Oblast, Russia
2463028 2463028 2021-09-14 Russia Orenburg Oblast     71881 1724 0   52.02692620000001 54.7276647 2021-09-15 03:22:37 Orenburg Oblast, Russia
2463029 2463029 2021-09-14 Russia Penza Oblast     66758 2389 0   53.1655415 44.78791810000001 2021-09-15 03:22:37 Penza Oblast, Russia
2463030 2463030 2021-09-14 Russia Perm Krai     94158 4419 0   58.5951603 56.3159546 2021-09-15 03:22:37 Perm Krai, Russia
2463031 2463031 2021-09-14 Russia Primorsky Krai     65460 1093 0   45.0819456 134.726645 2021-09-15 03:22:37 Primorsky Krai, Russia
2463032 2463032 2021-09-14 Russia Pskov Oblast     48170 721 0   57.535872899999994 28.8586826 2021-09-15 03:22:37 Pskov Oblast, Russia
2463033 2463033 2021-09-14 Russia Rostov Oblast     131049 6371 0   47.6222451 40.7957942 2021-09-15 03:22:37 Rostov Oblast, Russia
2463034 2463034 2021-09-14 Russia Ryazan Oblast     40379 1020 0   54.42267320000001 40.57052460000001 2021-09-15 03:22:37 Ryazan Oblast, Russia
2463035 2463035 2021-09-14 Russia Saint Petersburg     593773 21093 0   59.960673899999996 30.158655100000004 2021-09-15 03:22:37 Saint Petersburg, Russia
2463036 2463036 2021-09-14 Russia Sakha (Yakutiya) Republic     51162 1120 0   66.941626 129.642371 2021-09-15 03:22:37 Sakha (Yakutiya) Republic, Russia
2463037 2463037 2021-09-14 Russia Sakhalin Oblast     31890 262 0   49.7219665 143.448533 2021-09-15 03:22:37 Sakhalin Oblast, Russia
2463038 2463038 2021-09-14 Russia Samara Oblast     96642 3550 0   53.2128813 50.8914633 2021-09-15 03:22:37 Samara Oblast, Russia
2463039 2463039 2021-09-14 Russia Saratov Oblast     84219 2599 0   51.652055499999996 46.86319520000001 2021-09-15 03:22:37 Saratov Oblast, Russia
2463040 2463040 2021-09-14 Russia Smolensk Oblast     47414 1595 0   55.03434960000001 33.0192065 2021-09-15 03:22:37 Smolensk Oblast, Russia
2463041 2463041 2021-09-14 Russia Stavropol Krai     80208 2625 0   44.86325770000001 43.4406913 2021-09-15 03:22:37 Stavropol Krai, Russia
2463042 2463042 2021-09-14 Russia Sverdlovsk Oblast     130715 5681 0   58.6414755 61.802154599999994 2021-09-15 03:22:37 Sverdlovsk Oblast, Russia
2463043 2463043 2021-09-14 Russia Tambov Oblast     41827 835 0   52.9019574 41.3578918 2021-09-15 03:22:37 Tambov Oblast, Russia
2463044 2463044 2021-09-14 Russia Tatarstan Republic     26166 709 0   55.7648572 52.43104273 2021-09-15 03:22:37 Tatarstan Republic, Russia
2463045 2463045 2021-09-14 Russia Tomsk Oblast     42217 552 0   58.6124279 82.04753149999998 2021-09-15 03:22:37 Tomsk Oblast, Russia
2463046 2463046 2021-09-14 Russia Tula Oblast     52835 2850 0   53.9570701 37.369090899999996 2021-09-15 03:22:37 Tula Oblast, Russia
2463047 2463047 2021-09-14 Russia Tver Oblast     63346 1590 0   57.1134475 35.174442799999994 2021-09-15 03:22:37 Tver Oblast, Russia
2463048 2463048 2021-09-14 Russia Tyumen Oblast     58140 1733 0   58.8206488 70.36588370000001 2021-09-15 03:22:37 Tyumen Oblast, Russia
2463049 2463049 2021-09-14 Russia Tyva Republic     25720 277 0   51.401714899999995 93.8582593 2021-09-15 03:22:37 Tyva Republic, Russia
2463050 2463050 2021-09-14 Russia Udmurt Republic     49516 1764 0   57.1961165 52.69598320000001 2021-09-15 03:22:37 Udmurt Republic, Russia
2463051 2463051 2021-09-14 Russia Ulyanovsk Oblast     78189 2433 0   54.146317700000004 47.2324921 2021-09-15 03:22:37 Ulyanovsk Oblast, Russia
2463052 2463052 2021-09-14 Russia Vladimir Oblast     51502 1829 0   56.0503336 40.656163299999996 2021-09-15 03:22:37 Vladimir Oblast, Russia
2463053 2463053 2021-09-14 Russia Volgograd Oblast     86579 2508 0   49.604833899999996 44.29035820000001 2021-09-15 03:22:37 Volgograd Oblast, Russia
2463054 2463054 2021-09-14 Russia Vologda Oblast     64893 1741 0   60.0391461 43.1215213 2021-09-15 03:22:37 Vologda Oblast, Russia
2463055 2463055 2021-09-14 Russia Voronezh Oblast     125085 4242 0   50.9800393 40.15065070000001 2021-09-15 03:22:37 Voronezh Oblast, Russia
2463056 2463056 2021-09-14 Russia Yamalo-Nenets Autonomous Okrug     48945 651 0   67.1471631 74.3415488 2021-09-15 03:22:37 Yamalo-Nenets Autonomous Okrug, Russia
2463057 2463057 2021-09-14 Russia Yaroslavl Oblast     58426 1103 0   57.77819760000001 39.002109499999996 2021-09-15 03:22:37 Yaroslavl Oblast, Russia
2463058 2463058 2021-09-14 Russia Zabaykalsky Krai     66101 1110 0   52.248521000000004 115.956325 2021-09-15 03:22:37 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]);