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-06 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
1740724 1740724 2021-12-05 Russia Adygea Republic     24701 676 0   44.6939006 40.1520421 2021-12-06 04:22:34 Adygea Republic, Russia
1740725 1740725 2021-12-05 Russia Altai Krai     106652 5890 0   52.693224300000004 82.69314240000001 2021-12-06 04:22:34 Altai Krai, Russia
1740726 1740726 2021-12-05 Russia Altai Republic     24509 472 0   50.7114101 86.8572186 2021-12-06 04:22:34 Altai Republic, Russia
1740727 1740727 2021-12-05 Russia Amur Oblast     47811 544 0   52.8032368 128.437295 2021-12-06 04:22:34 Amur Oblast, Russia
1740728 1740728 2021-12-05 Russia Arkhangelsk Oblast     115526 1393 0   63.5589686 43.1221646 2021-12-06 04:22:34 Arkhangelsk Oblast, Russia
1740729 1740729 2021-12-05 Russia Astrakhan Oblast     75209 2217 0   47.1878186 47.608851 2021-12-06 04:22:34 Astrakhan Oblast, Russia
1740730 1740730 2021-12-05 Russia Bashkortostan Republic     109650 3728 0   54.8573563 57.1439682 2021-12-06 04:22:34 Bashkortostan Republic, Russia
1740731 1740731 2021-12-05 Russia Belgorod Oblast     74526 1574 0   50.7080119 37.5837615 2021-12-06 04:22:34 Belgorod Oblast, Russia
1740732 1740732 2021-12-05 Russia Bryansk Oblast     90732 2392 0   52.887331499999995 33.41585300000001 2021-12-06 04:22:34 Bryansk Oblast, Russia
1740733 1740733 2021-12-05 Russia Buryatia Republic     70700 2221 0   52.718242599999996 109.492143 2021-12-06 04:22:34 Buryatia Republic, Russia
1740734 1740734 2021-12-05 Russia Chechen Republic     28993 850 0   43.39761470000001 45.6985005 2021-12-06 04:22:34 Chechen Republic, Russia
1740735 1740735 2021-12-05 Russia Chelyabinsk Oblast     130058 5286 0   54.4223954 61.1865846 2021-12-06 04:22:34 Chelyabinsk Oblast, Russia
1740736 1740736 2021-12-05 Russia Chukotka Autonomous Okrug     2872 27 0   66.0006475 169.4900869 2021-12-06 04:22:34 Chukotka Autonomous Okrug, Russia
1740737 1740737 2021-12-05 Russia Chuvashia Republic     43695 3397 0   55.4259922 47.0849429 2021-12-06 04:22:34 Chuvashia Republic, Russia
1740738 1740738 2021-12-05 Russia Dagestan Republic     62165 3005 0   43.05749160000001 47.1332224 2021-12-06 04:22:34 Dagestan Republic, Russia
1740739 1740739 2021-12-05 Russia Ingushetia Republic     26571 433 0   43.11542075 45.01713552 2021-12-06 04:22:34 Ingushetia Republic, Russia
1740740 1740740 2021-12-05 Russia Irkutsk Oblast     141738 6340 0   56.6370122 104.71922099999999 2021-12-06 04:22:34 Irkutsk Oblast, Russia
1740741 1740741 2021-12-05 Russia Ivanovo Oblast     63061 2184 0   56.9167446 41.43521370000001 2021-12-06 04:22:34 Ivanovo Oblast, Russia
1740742 1740742 2021-12-05 Russia Jewish Autonomous Okrug     10751 348 0   48.57527615 132.66307460000002 2021-12-06 04:22:34 Jewish Autonomous Okrug, Russia
1740743 1740743 2021-12-05 Russia Kabardino-Balkarian Republic     39462 1231 0   43.480604799999995 43.5978976 2021-12-06 04:22:34 Kabardino-Balkarian Republic, Russia
1740744 1740744 2021-12-05 Russia Kaliningrad Oblast     77205 1081 0   54.7293041 21.1489473 2021-12-06 04:22:34 Kaliningrad Oblast, Russia
1740745 1740745 2021-12-05 Russia Kalmykia Republic     33555 699 0   46.2313018 45.3275745 2021-12-06 04:22:34 Kalmykia Republic, Russia
1740746 1740746 2021-12-05 Russia Kaluga Oblast     60211 1063 0   54.438277299999996 35.5272854 2021-12-06 04:22:34 Kaluga Oblast, Russia
1740747 1740747 2021-12-05 Russia Kamchatka Krai     22651 486 0   57.191488199999995 160.03838190000005 2021-12-06 04:22:34 Kamchatka Krai, Russia
1740748 1740748 2021-12-05 Russia Karachay-Cherkess Republic     30482 878 0   43.7368326 41.7267991 2021-12-06 04:22:34 Karachay-Cherkess Republic, Russia
1740749 1740749 2021-12-05 Russia Karelia Republic     84403 1093 0   62.61940309999999 33.4920267 2021-12-06 04:22:34 Karelia Republic, Russia
1740750 1740750 2021-12-05 Russia Kemerovo Oblast     75877 1594 0   54.53357809999999 87.342861 2021-12-06 04:22:34 Kemerovo Oblast, Russia
1740751 1740751 2021-12-05 Russia Khabarovsk Krai     112727 1084 0   51.6312684 136.121524 2021-12-06 04:22:34 Khabarovsk Krai, Russia
1740752 1740752 2021-12-05 Russia Khakassia Republic     50566 1675 0   53.72258845 91.44293627 2021-12-06 04:22:34 Khakassia Republic, Russia
1740753 1740753 2021-12-05 Russia Khanty-Mansi Autonomous Okrug     90844 1771 0   61.0259025 69.0982628 2021-12-06 04:22:34 Khanty-Mansi Autonomous Okrug, Russia
1740754 1740754 2021-12-05 Russia Kirov Oblast     72895 692 0   57.9665589 49.4074599 2021-12-06 04:22:34 Kirov Oblast, Russia
1740755 1740755 2021-12-05 Russia Komi Republic     91412 2347 0   63.9881421 54.3326073 2021-12-06 04:22:34 Komi Republic, Russia
1740756 1740756 2021-12-05 Russia Kostroma Oblast     45553 999 0   58.424756 44.253327299999995 2021-12-06 04:22:34 Kostroma Oblast, Russia
1740757 1740757 2021-12-05 Russia Krasnodar Krai     102839 9117 0   45.768401399999995 39.0261044 2021-12-06 04:22:34 Krasnodar Krai, Russia
1740758 1740758 2021-12-05 Russia Krasnoyarsk Krai     156325 7658 0   63.3233807 97.09799740000001 2021-12-06 04:22:34 Krasnoyarsk Krai, Russia
1740759 1740759 2021-12-05 Russia Kurgan Oblast     46045 898 0   55.7655302 64.5632681 2021-12-06 04:22:34 Kurgan Oblast, Russia
1740760 1740760 2021-12-05 Russia Kursk Oblast     77946 1838 0   51.6568453 36.4852695 2021-12-06 04:22:34 Kursk Oblast, Russia
1740761 1740761 2021-12-05 Russia Leningrad Oblast     92340 2817 0   60.185329599999996 32.3925325 2021-12-06 04:22:34 Leningrad Oblast, Russia
1740762 1740762 2021-12-05 Russia Lipetsk Oblast     76475 2488 0   52.693517799999995 39.112266399999996 2021-12-06 04:22:34 Lipetsk Oblast, Russia
1740763 1740763 2021-12-05 Russia Magadan Oblast     12956 317 0   62.48858785 153.9903764 2021-12-06 04:22:34 Magadan Oblast, Russia
1740764 1740764 2021-12-05 Russia Mari El Republic     26912 808 0   56.576750399999995 47.881751200000004 2021-12-06 04:22:34 Mari El Republic, Russia
1740765 1740765 2021-12-05 Russia Mordovia Republic     37425 915 0   54.4419829 44.466114399999995 2021-12-06 04:22:34 Mordovia Republic, Russia
1740766 1740766 2021-12-05 Russia Moscow     1963240 34668 0   55.7504461 37.6174943 2021-12-06 04:22:34 Moscow, Russia
1740767 1740767 2021-12-05 Russia Moscow Oblast     599033 10713 0   55.50431579999999 38.0353929 2021-12-06 04:22:34 Moscow Oblast, Russia
1740768 1740768 2021-12-05 Russia Murmansk Oblast     87615 2593 0   68.00004179999999 33.9999151 2021-12-06 04:22:34 Murmansk Oblast, Russia
1740769 1740769 2021-12-05 Russia Nenets Autonomous Okrug     3277 80 0   68.27557185 57.1686375 2021-12-06 04:22:34 Nenets Autonomous Okrug, Russia
1740770 1740770 2021-12-05 Russia Nizhny Novgorod Oblast     217778 9056 0   55.47180329999999 44.091159399999995 2021-12-06 04:22:34 Nizhny Novgorod Oblast, Russia
1740771 1740771 2021-12-05 Russia North Ossetia - Alania Republic     28943 783 0   42.79336110000001 44.6324493 2021-12-06 04:22:34 North Ossetia - Alania Republic, Russia
1740772 1740772 2021-12-05 Russia Novgorod Oblast     60713 642 0   58.2843833 32.516975699999996 2021-12-06 04:22:34 Novgorod Oblast, Russia
1740773 1740773 2021-12-05 Russia Novosibirsk Oblast     84714 3875 0   54.9720169 79.48139240000002 2021-12-06 04:22:34 Novosibirsk Oblast, Russia
1740774 1740774 2021-12-05 Russia Omsk Oblast     117465 2887 0   56.09352629999999 73.5099936 2021-12-06 04:22:34 Omsk Oblast, Russia
1740775 1740775 2021-12-05 Russia Orel Oblast     64739 1325 0   52.96854329999999 36.0692477 2021-12-06 04:22:34 Orel Oblast, Russia
1740776 1740776 2021-12-05 Russia Orenburg Oblast     102555 3216 0   52.02692620000001 54.7276647 2021-12-06 04:22:34 Orenburg Oblast, Russia
1740777 1740777 2021-12-05 Russia Penza Oblast     93629 4317 0   53.1655415 44.78791810000001 2021-12-06 04:22:34 Penza Oblast, Russia
1740778 1740778 2021-12-05 Russia Perm Krai     144236 6960 0   58.5951603 56.3159546 2021-12-06 04:22:34 Perm Krai, Russia
1740779 1740779 2021-12-05 Russia Primorsky Krai     90324 1424 0   45.0819456 134.726645 2021-12-06 04:22:34 Primorsky Krai, Russia
1740780 1740780 2021-12-05 Russia Pskov Oblast     66934 1111 0   57.535872899999994 28.8586826 2021-12-06 04:22:34 Pskov Oblast, Russia
1740781 1740781 2021-12-05 Russia Rostov Oblast     178804 8903 0   47.6222451 40.7957942 2021-12-06 04:22:34 Rostov Oblast, Russia
1740782 1740782 2021-12-05 Russia Ryazan Oblast     56616 2066 0   54.42267320000001 40.57052460000001 2021-12-06 04:22:34 Ryazan Oblast, Russia
1740783 1740783 2021-12-05 Russia Saint Petersburg     799871 26498 0   59.960673899999996 30.158655100000004 2021-12-06 04:22:34 Saint Petersburg, Russia
1740784 1740784 2021-12-05 Russia Sakha (Yakutiya) Republic     71735 1705 0   66.941626 129.642371 2021-12-06 04:22:34 Sakha (Yakutiya) Republic, Russia
1740785 1740785 2021-12-05 Russia Sakhalin Oblast     38440 454 0   49.7219665 143.448533 2021-12-06 04:22:34 Sakhalin Oblast, Russia
1740786 1740786 2021-12-05 Russia Samara Oblast     184298 5665 0   53.2128813 50.8914633 2021-12-06 04:22:34 Samara Oblast, Russia
1740787 1740787 2021-12-05 Russia Saratov Oblast     123075 4720 0   51.652055499999996 46.86319520000001 2021-12-06 04:22:34 Saratov Oblast, Russia
1740788 1740788 2021-12-05 Russia Smolensk Oblast     79529 2178 0   55.03434960000001 33.0192065 2021-12-06 04:22:34 Smolensk Oblast, Russia
1740789 1740789 2021-12-05 Russia Stavropol Krai     115165 5387 0   44.86325770000001 43.4406913 2021-12-06 04:22:34 Stavropol Krai, Russia
1740790 1740790 2021-12-05 Russia Sverdlovsk Oblast     182747 8594 0   58.6414755 61.802154599999994 2021-12-06 04:22:34 Sverdlovsk Oblast, Russia
1740791 1740791 2021-12-05 Russia Tambov Oblast     55707 1468 0   52.9019574 41.3578918 2021-12-06 04:22:34 Tambov Oblast, Russia
1740792 1740792 2021-12-05 Russia Tatarstan Republic     39226 1291 0   55.7648572 52.43104273 2021-12-06 04:22:34 Tatarstan Republic, Russia
1740793 1740793 2021-12-05 Russia Tomsk Oblast     56986 637 0   58.6124279 82.04753149999998 2021-12-06 04:22:34 Tomsk Oblast, Russia
1740794 1740794 2021-12-05 Russia Tula Oblast     69181 3954 0   53.9570701 37.369090899999996 2021-12-06 04:22:34 Tula Oblast, Russia
1740795 1740795 2021-12-05 Russia Tver Oblast     90228 2159 0   57.1134475 35.174442799999994 2021-12-06 04:22:34 Tver Oblast, Russia
1740796 1740796 2021-12-05 Russia Tyumen Oblast     82432 2939 0   58.8206488 70.36588370000001 2021-12-06 04:22:34 Tyumen Oblast, Russia
1740797 1740797 2021-12-05 Russia Tyva Republic     30877 307 0   51.401714899999995 93.8582593 2021-12-06 04:22:34 Tyva Republic, Russia
1740798 1740798 2021-12-05 Russia Udmurt Republic     75888 3099 0   57.1961165 52.69598320000001 2021-12-06 04:22:34 Udmurt Republic, Russia
1740799 1740799 2021-12-05 Russia Ulyanovsk Oblast     113113 3450 0   54.146317700000004 47.2324921 2021-12-06 04:22:34 Ulyanovsk Oblast, Russia
1740800 1740800 2021-12-05 Russia Vladimir Oblast     74003 2672 0   56.0503336 40.656163299999996 2021-12-06 04:22:34 Vladimir Oblast, Russia
1740801 1740801 2021-12-05 Russia Volgograd Oblast     120012 4757 0   49.604833899999996 44.29035820000001 2021-12-06 04:22:34 Volgograd Oblast, Russia
1740802 1740802 2021-12-05 Russia Vologda Oblast     91987 2644 0   60.0391461 43.1215213 2021-12-06 04:22:34 Vologda Oblast, Russia
1740803 1740803 2021-12-05 Russia Voronezh Oblast     180962 5968 0   50.9800393 40.15065070000001 2021-12-06 04:22:34 Voronezh Oblast, Russia
1740804 1740804 2021-12-05 Russia Yamalo-Nenets Autonomous Okrug     59097 881 0   67.1471631 74.3415488 2021-12-06 04:22:34 Yamalo-Nenets Autonomous Okrug, Russia
1740805 1740805 2021-12-05 Russia Yaroslavl Oblast     78787 1582 0   57.77819760000001 39.002109499999996 2021-12-06 04:22:34 Yaroslavl Oblast, Russia
1740806 1740806 2021-12-05 Russia Zabaykalsky Krai     89309 1670 0   52.248521000000004 115.956325 2021-12-06 04:22:34 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]);