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 2022-02-17 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
3820624 3820624 2022-02-16 Russia Adygea Republic     37338 855 0   44.6939006 40.1520421 2022-02-17 04:20:56 Adygea Republic, Russia
3820625 3820625 2022-02-16 Russia Altai Krai     191515 7684 0   52.693224300000004 82.69314240000001 2022-02-17 04:20:56 Altai Krai, Russia
3820626 3820626 2022-02-16 Russia Altai Republic     29644 579 0   50.7114101 86.8572186 2022-02-17 04:20:56 Altai Republic, Russia
3820627 3820627 2022-02-16 Russia Amur Oblast     72380 708 0   52.8032368 128.437295 2022-02-17 04:20:56 Amur Oblast, Russia
3820628 3820628 2022-02-16 Russia Arkhangelsk Oblast     187771 1575 0   63.5589686 43.1221646 2022-02-17 04:20:56 Arkhangelsk Oblast, Russia
3820629 3820629 2022-02-16 Russia Astrakhan Oblast     101581 2763 0   47.1878186 47.608851 2022-02-17 04:20:56 Astrakhan Oblast, Russia
3820630 3820630 2022-02-16 Russia Bashkortostan Republic     172767 4984 0   54.8573563 57.1439682 2022-02-17 04:20:56 Bashkortostan Republic, Russia
3820631 3820631 2022-02-16 Russia Belgorod Oblast     104725 1990 0   50.7080119 37.5837615 2022-02-17 04:20:56 Belgorod Oblast, Russia
3820632 3820632 2022-02-16 Russia Bryansk Oblast     128031 3365 0   52.887331499999995 33.41585300000001 2022-02-17 04:20:56 Bryansk Oblast, Russia
3820633 3820633 2022-02-16 Russia Buryatia Republic     110937 2739 0   52.718242599999996 109.492143 2022-02-17 04:20:56 Buryatia Republic, Russia
3820634 3820634 2022-02-16 Russia Chechen Republic     41370 1059 0   43.39761470000001 45.6985005 2022-02-17 04:20:56 Chechen Republic, Russia
3820635 3820635 2022-02-16 Russia Chelyabinsk Oblast     236383 6720 0   54.4223954 61.1865846 2022-02-17 04:20:56 Chelyabinsk Oblast, Russia
3820636 3820636 2022-02-16 Russia Chukotka Autonomous Okrug     4001 40 0   66.0006475 169.4900869 2022-02-17 04:20:56 Chukotka Autonomous Okrug, Russia
3820637 3820637 2022-02-16 Russia Chuvashia Republic     68702 4316 0   55.4259922 47.0849429 2022-02-17 04:20:56 Chuvashia Republic, Russia
3820638 3820638 2022-02-16 Russia Dagestan Republic     83668 3415 0   43.05749160000001 47.1332224 2022-02-17 04:20:56 Dagestan Republic, Russia
3820639 3820639 2022-02-16 Russia Ingushetia Republic     37025 529 0   43.11542075 45.01713552 2022-02-17 04:20:56 Ingushetia Republic, Russia
3820640 3820640 2022-02-16 Russia Irkutsk Oblast     211713 7655 0   56.6370122 104.71922099999999 2022-02-17 04:20:56 Irkutsk Oblast, Russia
3820641 3820641 2022-02-16 Russia Ivanovo Oblast     82857 2781 0   56.9167446 41.43521370000001 2022-02-17 04:20:56 Ivanovo Oblast, Russia
3820642 3820642 2022-02-16 Russia Jewish Autonomous Okrug     13427 470 0   48.57527615 132.66307460000002 2022-02-17 04:20:56 Jewish Autonomous Okrug, Russia
3820643 3820643 2022-02-16 Russia Kabardino-Balkarian Republic     51988 1650 0   43.480604799999995 43.5978976 2022-02-17 04:20:56 Kabardino-Balkarian Republic, Russia
3820644 3820644 2022-02-16 Russia Kaliningrad Oblast     121336 1533 0   54.7293041 21.1489473 2022-02-17 04:20:56 Kaliningrad Oblast, Russia
3820645 3820645 2022-02-16 Russia Kalmykia Republic     44131 801 0   46.2313018 45.3275745 2022-02-17 04:20:56 Kalmykia Republic, Russia
3820646 3820646 2022-02-16 Russia Kaluga Oblast     87828 1334 0   54.438277299999996 35.5272854 2022-02-17 04:20:56 Kaluga Oblast, Russia
3820647 3820647 2022-02-16 Russia Kamchatka Krai     31264 561 0   57.191488199999995 160.03838190000005 2022-02-17 04:20:56 Kamchatka Krai, Russia
3820648 3820648 2022-02-16 Russia Karachay-Cherkess Republic     40473 950 0   43.7368326 41.7267991 2022-02-17 04:20:56 Karachay-Cherkess Republic, Russia
3820649 3820649 2022-02-16 Russia Karelia Republic     114093 1370 0   62.61940309999999 33.4920267 2022-02-17 04:20:56 Karelia Republic, Russia
3820650 3820650 2022-02-16 Russia Kemerovo Oblast     122703 2038 0   54.53357809999999 87.342861 2022-02-17 04:20:56 Kemerovo Oblast, Russia
3820651 3820651 2022-02-16 Russia Khabarovsk Krai     154625 1387 0   51.6312684 136.121524 2022-02-17 04:20:56 Khabarovsk Krai, Russia
3820652 3820652 2022-02-16 Russia Khakassia Republic     74693 2187 0   53.72258845 91.44293627 2022-02-17 04:20:56 Khakassia Republic, Russia
3820653 3820653 2022-02-16 Russia Khanty-Mansi Autonomous Okrug     172044 2255 0   61.0259025 69.0982628 2022-02-17 04:20:56 Khanty-Mansi Autonomous Okrug, Russia
3820654 3820654 2022-02-16 Russia Kirov Oblast     114046 858 0   57.9665589 49.4074599 2022-02-17 04:20:56 Kirov Oblast, Russia
3820655 3820655 2022-02-16 Russia Komi Republic     134177 2843 0   63.9881421 54.3326073 2022-02-17 04:20:56 Komi Republic, Russia
3820656 3820656 2022-02-16 Russia Kostroma Oblast     66228 1199 0   58.424756 44.253327299999995 2022-02-17 04:20:56 Kostroma Oblast, Russia
3820657 3820657 2022-02-16 Russia Krasnodar Krai     191554 10235 0   45.768401399999995 39.0261044 2022-02-17 04:20:56 Krasnodar Krai, Russia
3820658 3820658 2022-02-16 Russia Krasnoyarsk Krai     271858 9713 0   63.3233807 97.09799740000001 2022-02-17 04:20:56 Krasnoyarsk Krai, Russia
3820659 3820659 2022-02-16 Russia Kurgan Oblast     71527 1100 0   55.7655302 64.5632681 2022-02-17 04:20:56 Kurgan Oblast, Russia
3820660 3820660 2022-02-16 Russia Kursk Oblast     98040 2241 0   51.6568453 36.4852695 2022-02-17 04:20:56 Kursk Oblast, Russia
3820661 3820661 2022-02-16 Russia Leningrad Oblast     151151 3248 0   60.185329599999996 32.3925325 2022-02-17 04:20:56 Leningrad Oblast, Russia
3820662 3820662 2022-02-16 Russia Lipetsk Oblast     114149 3175 0   52.693517799999995 39.112266399999996 2022-02-17 04:20:56 Lipetsk Oblast, Russia
3820663 3820663 2022-02-16 Russia Magadan Oblast     16984 363 0   62.48858785 153.9903764 2022-02-17 04:20:56 Magadan Oblast, Russia
3820664 3820664 2022-02-16 Russia Mari El Republic     40215 1000 0   56.576750399999995 47.881751200000004 2022-02-17 04:20:56 Mari El Republic, Russia
3820665 3820665 2022-02-16 Russia Mordovia Republic     52594 1218 0   54.4419829 44.466114399999995 2022-02-17 04:20:56 Mordovia Republic, Russia
3820666 3820666 2022-02-16 Russia Moscow     2632914 40273 0   55.7504461 37.6174943 2022-02-17 04:20:56 Moscow, Russia
3820667 3820667 2022-02-16 Russia Moscow Oblast     904601 13902 0   55.50431579999999 38.0353929 2022-02-17 04:20:56 Moscow Oblast, Russia
3820668 3820668 2022-02-16 Russia Murmansk Oblast     116191 3042 0   68.00004179999999 33.9999151 2022-02-17 04:20:56 Murmansk Oblast, Russia
3820669 3820669 2022-02-16 Russia Nenets Autonomous Okrug     5633 93 0   68.27557185 57.1686375 2022-02-17 04:20:56 Nenets Autonomous Okrug, Russia
3820670 3820670 2022-02-16 Russia Nizhny Novgorod Oblast     320054 10830 0   55.47180329999999 44.091159399999995 2022-02-17 04:20:56 Nizhny Novgorod Oblast, Russia
3820671 3820671 2022-02-16 Russia North Ossetia - Alania Republic     37002 1166 0   42.79336110000001 44.6324493 2022-02-17 04:20:56 North Ossetia - Alania Republic, Russia
3820672 3820672 2022-02-16 Russia Novgorod Oblast     84726 882 0   58.2843833 32.516975699999996 2022-02-17 04:20:56 Novgorod Oblast, Russia
3820673 3820673 2022-02-16 Russia Novosibirsk Oblast     160757 4825 0   54.9720169 79.48139240000002 2022-02-17 04:20:56 Novosibirsk Oblast, Russia
3820674 3820674 2022-02-16 Russia Omsk Oblast     177330 3739 0   56.09352629999999 73.5099936 2022-02-17 04:20:56 Omsk Oblast, Russia
3820675 3820675 2022-02-16 Russia Orel Oblast     91201 1695 0   52.96854329999999 36.0692477 2022-02-17 04:20:56 Orel Oblast, Russia
3820676 3820676 2022-02-16 Russia Orenburg Oblast     157968 3655 0   52.02692620000001 54.7276647 2022-02-17 04:20:56 Orenburg Oblast, Russia
3820677 3820677 2022-02-16 Russia Penza Oblast     132272 5045 0   53.1655415 44.78791810000001 2022-02-17 04:20:56 Penza Oblast, Russia
3820678 3820678 2022-02-16 Russia Perm Krai     261917 8059 0   58.5951603 56.3159546 2022-02-17 04:20:56 Perm Krai, Russia
3820679 3820679 2022-02-16 Russia Primorsky Krai     132336 1776 0   45.0819456 134.726645 2022-02-17 04:20:56 Primorsky Krai, Russia
3820680 3820680 2022-02-16 Russia Pskov Oblast     84116 1518 0   57.535872899999994 28.8586826 2022-02-17 04:20:56 Pskov Oblast, Russia
3820681 3820681 2022-02-16 Russia Rostov Oblast     275103 10192 0   47.6222451 40.7957942 2022-02-17 04:20:56 Rostov Oblast, Russia
3820682 3820682 2022-02-16 Russia Ryazan Oblast     88249 2961 0   54.42267320000001 40.57052460000001 2022-02-17 04:20:56 Ryazan Oblast, Russia
3820683 3820683 2022-02-16 Russia Saint Petersburg     1309175 30941 0   59.960673899999996 30.158655100000004 2022-02-17 04:20:56 Saint Petersburg, Russia
3820684 3820684 2022-02-16 Russia Sakha (Yakutiya) Republic     144414 1934 0   66.941626 129.642371 2022-02-17 04:20:56 Sakha (Yakutiya) Republic, Russia
3820685 3820685 2022-02-16 Russia Sakhalin Oblast     52574 699 0   49.7219665 143.448533 2022-02-17 04:20:56 Sakhalin Oblast, Russia
3820686 3820686 2022-02-16 Russia Samara Oblast     277328 6921 0   53.2128813 50.8914633 2022-02-17 04:20:56 Samara Oblast, Russia
3820687 3820687 2022-02-16 Russia Saratov Oblast     171997 5501 0   51.652055499999996 46.86319520000001 2022-02-17 04:20:56 Saratov Oblast, Russia
3820688 3820688 2022-02-16 Russia Smolensk Oblast     104957 2696 0   55.03434960000001 33.0192065 2022-02-17 04:20:56 Smolensk Oblast, Russia
3820689 3820689 2022-02-16 Russia Stavropol Krai     168510 6654 0   44.86325770000001 43.4406913 2022-02-17 04:20:56 Stavropol Krai, Russia
3820690 3820690 2022-02-16 Russia Sverdlovsk Oblast     298598 10163 0   58.6414755 61.802154599999994 2022-02-17 04:20:56 Sverdlovsk Oblast, Russia
3820691 3820691 2022-02-16 Russia Tambov Oblast     85126 2050 0   52.9019574 41.3578918 2022-02-17 04:20:56 Tambov Oblast, Russia
3820692 3820692 2022-02-16 Russia Tatarstan Republic     80629 1673 0   55.7648572 52.43104273 2022-02-17 04:20:56 Tatarstan Republic, Russia
3820693 3820693 2022-02-16 Russia Tomsk Oblast     82495 726 0   58.6124279 82.04753149999998 2022-02-17 04:20:56 Tomsk Oblast, Russia
3820694 3820694 2022-02-16 Russia Tula Oblast     123387 4756 0   53.9570701 37.369090899999996 2022-02-17 04:20:56 Tula Oblast, Russia
3820695 3820695 2022-02-16 Russia Tver Oblast     131831 2482 0   57.1134475 35.174442799999994 2022-02-17 04:20:56 Tver Oblast, Russia
3820696 3820696 2022-02-16 Russia Tyumen Oblast     140820 3822 0   58.8206488 70.36588370000001 2022-02-17 04:20:56 Tyumen Oblast, Russia
3820697 3820697 2022-02-16 Russia Tyva Republic     42563 339 0   51.401714899999995 93.8582593 2022-02-17 04:20:56 Tyva Republic, Russia
3820698 3820698 2022-02-16 Russia Udmurt Republic     120498 3421 0   57.1961165 52.69598320000001 2022-02-17 04:20:56 Udmurt Republic, Russia
3820699 3820699 2022-02-16 Russia Ulyanovsk Oblast     149398 4170 0   54.146317700000004 47.2324921 2022-02-17 04:20:56 Ulyanovsk Oblast, Russia
3820700 3820700 2022-02-16 Russia Vladimir Oblast     116972 3173 0   56.0503336 40.656163299999996 2022-02-17 04:20:56 Vladimir Oblast, Russia
3820701 3820701 2022-02-16 Russia Volgograd Oblast     167997 6173 0   49.604833899999996 44.29035820000001 2022-02-17 04:20:56 Volgograd Oblast, Russia
3820702 3820702 2022-02-16 Russia Vologda Oblast     137834 3285 0   60.0391461 43.1215213 2022-02-17 04:20:56 Vologda Oblast, Russia
3820703 3820703 2022-02-16 Russia Voronezh Oblast     281287 7440 0   50.9800393 40.15065070000001 2022-02-17 04:20:56 Voronezh Oblast, Russia
3820704 3820704 2022-02-16 Russia Yamalo-Nenets Autonomous Okrug     106288 998 0   67.1471631 74.3415488 2022-02-17 04:20:56 Yamalo-Nenets Autonomous Okrug, Russia
3820705 3820705 2022-02-16 Russia Yaroslavl Oblast     113271 2266 0   57.77819760000001 39.002109499999996 2022-02-17 04:20:56 Yaroslavl Oblast, Russia
3820706 3820706 2022-02-16 Russia Zabaykalsky Krai     121843 2099 0   52.248521000000004 115.956325 2022-02-17 04:20:56 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]);