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-03-05 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
2665983 2665983 2022-03-04 Russia Adygea Republic     44797 902 0   44.6939006 40.1520421 2022-03-05 04:21:10 Adygea Republic, Russia
2665984 2665984 2022-03-04 Russia Altai Krai     242772 8040 0   52.693224300000004 82.69314240000001 2022-03-05 04:21:10 Altai Krai, Russia
2665985 2665985 2022-03-04 Russia Altai Republic     32120 587 0   50.7114101 86.8572186 2022-03-05 04:21:10 Altai Republic, Russia
2665986 2665986 2022-03-04 Russia Amur Oblast     93691 714 0   52.8032368 128.437295 2022-03-05 04:21:10 Amur Oblast, Russia
2665987 2665987 2022-03-04 Russia Arkhangelsk Oblast     215746 1586 0   63.5589686 43.1221646 2022-03-05 04:21:10 Arkhangelsk Oblast, Russia
2665988 2665988 2022-03-04 Russia Astrakhan Oblast     110966 2848 0   47.1878186 47.608851 2022-03-05 04:21:10 Astrakhan Oblast, Russia
2665989 2665989 2022-03-04 Russia Bashkortostan Republic     235486 5284 0   54.8573563 57.1439682 2022-03-05 04:21:10 Bashkortostan Republic, Russia
2665990 2665990 2022-03-04 Russia Belgorod Oblast     118563 2049 0   50.7080119 37.5837615 2022-03-05 04:21:10 Belgorod Oblast, Russia
2665991 2665991 2022-03-04 Russia Bryansk Oblast     147451 3524 0   52.887331499999995 33.41585300000001 2022-03-05 04:21:10 Bryansk Oblast, Russia
2665992 2665992 2022-03-04 Russia Buryatia Republic     125753 2874 0   52.718242599999996 109.492143 2022-03-05 04:21:10 Buryatia Republic, Russia
2665993 2665993 2022-03-04 Russia Chechen Republic     42330 1071 0   43.39761470000001 45.6985005 2022-03-05 04:21:10 Chechen Republic, Russia
2665994 2665994 2022-03-04 Russia Chelyabinsk Oblast     288816 7023 0   54.4223954 61.1865846 2022-03-05 04:21:10 Chelyabinsk Oblast, Russia
2665995 2665995 2022-03-04 Russia Chukotka Autonomous Okrug     5111 41 0   66.0006475 169.4900869 2022-03-05 04:21:10 Chukotka Autonomous Okrug, Russia
2665996 2665996 2022-03-04 Russia Chuvashia Republic     74000 4439 0   55.4259922 47.0849429 2022-03-05 04:21:10 Chuvashia Republic, Russia
2665997 2665997 2022-03-04 Russia Dagestan Republic     89829 3543 0   43.05749160000001 47.1332224 2022-03-05 04:21:10 Dagestan Republic, Russia
2665998 2665998 2022-03-04 Russia Ingushetia Republic     39373 541 0   43.11542075 45.01713552 2022-03-05 04:21:10 Ingushetia Republic, Russia
2665999 2665999 2022-03-04 Russia Irkutsk Oblast     251882 7905 0   56.6370122 104.71922099999999 2022-03-05 04:21:10 Irkutsk Oblast, Russia
2666000 2666000 2022-03-04 Russia Ivanovo Oblast     100233 2878 0   56.9167446 41.43521370000001 2022-03-05 04:21:10 Ivanovo Oblast, Russia
2666001 2666001 2022-03-04 Russia Jewish Autonomous Okrug     15579 483 0   48.57527615 132.66307460000002 2022-03-05 04:21:10 Jewish Autonomous Okrug, Russia
2666002 2666002 2022-03-04 Russia Kabardino-Balkarian Republic     58471 1777 0   43.480604799999995 43.5978976 2022-03-05 04:21:10 Kabardino-Balkarian Republic, Russia
2666003 2666003 2022-03-04 Russia Kaliningrad Oblast     150197 1637 0   54.7293041 21.1489473 2022-03-05 04:21:10 Kaliningrad Oblast, Russia
2666004 2666004 2022-03-04 Russia Kalmykia Republic     47495 816 0   46.2313018 45.3275745 2022-03-05 04:21:10 Kalmykia Republic, Russia
2666005 2666005 2022-03-04 Russia Kaluga Oblast     96466 1364 0   54.438277299999996 35.5272854 2022-03-05 04:21:10 Kaluga Oblast, Russia
2666006 2666006 2022-03-04 Russia Kamchatka Krai     36974 588 0   57.191488199999995 160.03838190000005 2022-03-05 04:21:10 Kamchatka Krai, Russia
2666007 2666007 2022-03-04 Russia Karachay-Cherkess Republic     43484 971 0   43.7368326 41.7267991 2022-03-05 04:21:10 Karachay-Cherkess Republic, Russia
2666008 2666008 2022-03-04 Russia Karelia Republic     126471 1406 0   62.61940309999999 33.4920267 2022-03-05 04:21:10 Karelia Republic, Russia
2666009 2666009 2022-03-04 Russia Kemerovo Oblast     146808 2140 0   54.53357809999999 87.342861 2022-03-05 04:21:10 Kemerovo Oblast, Russia
2666010 2666010 2022-03-04 Russia Khabarovsk Krai     178672 1445 0   51.6312684 136.121524 2022-03-05 04:21:10 Khabarovsk Krai, Russia
2666011 2666011 2022-03-04 Russia Khakassia Republic     84245 2252 0   53.72258845 91.44293627 2022-03-05 04:21:10 Khakassia Republic, Russia
2666012 2666012 2022-03-04 Russia Khanty-Mansi Autonomous Okrug     196140 2399 0   61.0259025 69.0982628 2022-03-05 04:21:10 Khanty-Mansi Autonomous Okrug, Russia
2666013 2666013 2022-03-04 Russia Kirov Oblast     140821 895 0   57.9665589 49.4074599 2022-03-05 04:21:10 Kirov Oblast, Russia
2666014 2666014 2022-03-04 Russia Komi Republic     160235 2929 0   63.9881421 54.3326073 2022-03-05 04:21:10 Komi Republic, Russia
2666015 2666015 2022-03-04 Russia Kostroma Oblast     81469 1236 0   58.424756 44.253327299999995 2022-03-05 04:21:10 Kostroma Oblast, Russia
2666016 2666016 2022-03-04 Russia Krasnodar Krai     231370 10453 0   45.768401399999995 39.0261044 2022-03-05 04:21:10 Krasnodar Krai, Russia
2666017 2666017 2022-03-04 Russia Krasnoyarsk Krai     345905 10074 0   63.3233807 97.09799740000001 2022-03-05 04:21:10 Krasnoyarsk Krai, Russia
2666018 2666018 2022-03-04 Russia Kurgan Oblast     90511 1214 0   55.7655302 64.5632681 2022-03-05 04:21:10 Kurgan Oblast, Russia
2666019 2666019 2022-03-04 Russia Kursk Oblast     106860 2300 0   51.6568453 36.4852695 2022-03-05 04:21:10 Kursk Oblast, Russia
2666020 2666020 2022-03-04 Russia Leningrad Oblast     172477 3345 0   60.185329599999996 32.3925325 2022-03-05 04:21:10 Leningrad Oblast, Russia
2666021 2666021 2022-03-04 Russia Lipetsk Oblast     130407 3314 0   52.693517799999995 39.112266399999996 2022-03-05 04:21:10 Lipetsk Oblast, Russia
2666022 2666022 2022-03-04 Russia Magadan Oblast     18824 378 0   62.48858785 153.9903764 2022-03-05 04:21:10 Magadan Oblast, Russia
2666023 2666023 2022-03-04 Russia Mari El Republic     43252 1047 0   56.576750399999995 47.881751200000004 2022-03-05 04:21:10 Mari El Republic, Russia
2666024 2666024 2022-03-04 Russia Mordovia Republic     60850 1279 0   54.4419829 44.466114399999995 2022-03-05 04:21:10 Mordovia Republic, Russia
2666025 2666025 2022-03-04 Russia Moscow     2706980 41602 0   55.7504461 37.6174943 2022-03-05 04:21:10 Moscow, Russia
2666026 2666026 2022-03-04 Russia Moscow Oblast     944700 14290 0   55.50431579999999 38.0353929 2022-03-05 04:21:10 Moscow Oblast, Russia
2666027 2666027 2022-03-04 Russia Murmansk Oblast     127486 3122 0   68.00004179999999 33.9999151 2022-03-05 04:21:10 Murmansk Oblast, Russia
2666028 2666028 2022-03-04 Russia Nenets Autonomous Okrug     6799 93 0   68.27557185 57.1686375 2022-03-05 04:21:10 Nenets Autonomous Okrug, Russia
2666029 2666029 2022-03-04 Russia Nizhny Novgorod Oblast     373658 11152 0   55.47180329999999 44.091159399999995 2022-03-05 04:21:10 Nizhny Novgorod Oblast, Russia
2666030 2666030 2022-03-04 Russia North Ossetia - Alania Republic     39216 1212 0   42.79336110000001 44.6324493 2022-03-05 04:21:10 North Ossetia - Alania Republic, Russia
2666031 2666031 2022-03-04 Russia Novgorod Oblast     93915 945 0   58.2843833 32.516975699999996 2022-03-05 04:21:10 Novgorod Oblast, Russia
2666032 2666032 2022-03-04 Russia Novosibirsk Oblast     230281 5046 0   54.9720169 79.48139240000002 2022-03-05 04:21:10 Novosibirsk Oblast, Russia
2666033 2666033 2022-03-04 Russia Omsk Oblast     193627 3905 0   56.09352629999999 73.5099936 2022-03-05 04:21:10 Omsk Oblast, Russia
2666034 2666034 2022-03-04 Russia Orel Oblast     100610 1760 0   52.96854329999999 36.0692477 2022-03-05 04:21:10 Orel Oblast, Russia
2666035 2666035 2022-03-04 Russia Orenburg Oblast     193058 3747 0   52.02692620000001 54.7276647 2022-03-05 04:21:10 Orenburg Oblast, Russia
2666036 2666036 2022-03-04 Russia Penza Oblast     160023 5292 0   53.1655415 44.78791810000001 2022-03-05 04:21:10 Penza Oblast, Russia
2666037 2666037 2022-03-04 Russia Perm Krai     329484 8405 0   58.5951603 56.3159546 2022-03-05 04:21:10 Perm Krai, Russia
2666038 2666038 2022-03-04 Russia Primorsky Krai     156233 1827 0   45.0819456 134.726645 2022-03-05 04:21:10 Primorsky Krai, Russia
2666039 2666039 2022-03-04 Russia Pskov Oblast     99179 1596 0   57.535872899999994 28.8586826 2022-03-05 04:21:10 Pskov Oblast, Russia
2666040 2666040 2022-03-04 Russia Rostov Oblast     331640 10400 0   47.6222451 40.7957942 2022-03-05 04:21:10 Rostov Oblast, Russia
2666041 2666041 2022-03-04 Russia Ryazan Oblast     104513 3070 0   54.42267320000001 40.57052460000001 2022-03-05 04:21:10 Ryazan Oblast, Russia
2666042 2666042 2022-03-04 Russia Saint Petersburg     1452714 32168 0   59.960673899999996 30.158655100000004 2022-03-05 04:21:10 Saint Petersburg, Russia
2666043 2666043 2022-03-04 Russia Sakha (Yakutiya) Republic     161184 2013 0   66.941626 129.642371 2022-03-05 04:21:10 Sakha (Yakutiya) Republic, Russia
2666044 2666044 2022-03-04 Russia Sakhalin Oblast     60715 759 0   49.7219665 143.448533 2022-03-05 04:21:10 Sakhalin Oblast, Russia
2666045 2666045 2022-03-04 Russia Samara Oblast     341799 7165 0   53.2128813 50.8914633 2022-03-05 04:21:10 Samara Oblast, Russia
2666046 2666046 2022-03-04 Russia Saratov Oblast     212348 5673 0   51.652055499999996 46.86319520000001 2022-03-05 04:21:10 Saratov Oblast, Russia
2666047 2666047 2022-03-04 Russia Smolensk Oblast     120032 2791 0   55.03434960000001 33.0192065 2022-03-05 04:21:10 Smolensk Oblast, Russia
2666048 2666048 2022-03-04 Russia Stavropol Krai     185723 6828 0   44.86325770000001 43.4406913 2022-03-05 04:21:10 Stavropol Krai, Russia
2666049 2666049 2022-03-04 Russia Sverdlovsk Oblast     369719 10331 0   58.6414755 61.802154599999994 2022-03-05 04:21:10 Sverdlovsk Oblast, Russia
2666050 2666050 2022-03-04 Russia Tambov Oblast     101668 2215 0   52.9019574 41.3578918 2022-03-05 04:21:10 Tambov Oblast, Russia
2666051 2666051 2022-03-04 Russia Tatarstan Republic     123009 1742 0   55.7648572 52.43104273 2022-03-05 04:21:10 Tatarstan Republic, Russia
2666052 2666052 2022-03-04 Russia Tomsk Oblast     105472 752 0   58.6124279 82.04753149999998 2022-03-05 04:21:10 Tomsk Oblast, Russia
2666053 2666053 2022-03-04 Russia Tula Oblast     140423 4885 0   53.9570701 37.369090899999996 2022-03-05 04:21:10 Tula Oblast, Russia
2666054 2666054 2022-03-04 Russia Tver Oblast     148550 2579 0   57.1134475 35.174442799999994 2022-03-05 04:21:10 Tver Oblast, Russia
2666055 2666055 2022-03-04 Russia Tyumen Oblast     170179 3959 0   58.8206488 70.36588370000001 2022-03-05 04:21:10 Tyumen Oblast, Russia
2666056 2666056 2022-03-04 Russia Tyva Republic     44085 341 0   51.401714899999995 93.8582593 2022-03-05 04:21:10 Tyva Republic, Russia
2666057 2666057 2022-03-04 Russia Udmurt Republic     153056 3630 0   57.1961165 52.69598320000001 2022-03-05 04:21:10 Udmurt Republic, Russia
2666058 2666058 2022-03-04 Russia Ulyanovsk Oblast     175493 4378 0   54.146317700000004 47.2324921 2022-03-05 04:21:10 Ulyanovsk Oblast, Russia
2666059 2666059 2022-03-04 Russia Vladimir Oblast     138608 3231 0   56.0503336 40.656163299999996 2022-03-05 04:21:10 Vladimir Oblast, Russia
2666060 2666060 2022-03-04 Russia Volgograd Oblast     189487 6416 0   49.604833899999996 44.29035820000001 2022-03-05 04:21:10 Volgograd Oblast, Russia
2666061 2666061 2022-03-04 Russia Vologda Oblast     168709 3428 0   60.0391461 43.1215213 2022-03-05 04:21:10 Vologda Oblast, Russia
2666062 2666062 2022-03-04 Russia Voronezh Oblast     339981 7695 0   50.9800393 40.15065070000001 2022-03-05 04:21:10 Voronezh Oblast, Russia
2666063 2666063 2022-03-04 Russia Yamalo-Nenets Autonomous Okrug     127996 1013 0   67.1471631 74.3415488 2022-03-05 04:21:10 Yamalo-Nenets Autonomous Okrug, Russia
2666064 2666064 2022-03-04 Russia Yaroslavl Oblast     139507 2502 0   57.77819760000001 39.002109499999996 2022-03-05 04:21:10 Yaroslavl Oblast, Russia
2666065 2666065 2022-03-04 Russia Zabaykalsky Krai     149171 2181 0   52.248521000000004 115.956325 2022-03-05 04:21:10 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]);