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-01-23 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
2833016 2833016 2022-01-22 Russia Adygea Republic     28795 805 0   44.6939006 40.1520421 2022-01-23 04:21:13 Adygea Republic, Russia
2833017 2833017 2022-01-22 Russia Altai Krai     126561 7124 0   52.693224300000004 82.69314240000001 2022-01-23 04:21:13 Altai Krai, Russia
2833018 2833018 2022-01-22 Russia Altai Republic     25871 544 0   50.7114101 86.8572186 2022-01-23 04:21:13 Altai Republic, Russia
2833019 2833019 2022-01-22 Russia Amur Oblast     57937 637 0   52.8032368 128.437295 2022-01-23 04:21:13 Amur Oblast, Russia
2833020 2833020 2022-01-22 Russia Arkhangelsk Oblast     128117 1556 0   63.5589686 43.1221646 2022-01-23 04:21:13 Arkhangelsk Oblast, Russia
2833021 2833021 2022-01-22 Russia Astrakhan Oblast     84963 2595 0   47.1878186 47.608851 2022-01-23 04:21:13 Astrakhan Oblast, Russia
2833022 2833022 2022-01-22 Russia Bashkortostan Republic     126973 4630 0   54.8573563 57.1439682 2022-01-23 04:21:13 Bashkortostan Republic, Russia
2833023 2833023 2022-01-22 Russia Belgorod Oblast     84487 1874 0   50.7080119 37.5837615 2022-01-23 04:21:13 Belgorod Oblast, Russia
2833024 2833024 2022-01-22 Russia Bryansk Oblast     100148 3135 0   52.887331499999995 33.41585300000001 2022-01-23 04:21:13 Bryansk Oblast, Russia
2833025 2833025 2022-01-22 Russia Buryatia Republic     79445 2564 0   52.718242599999996 109.492143 2022-01-23 04:21:13 Buryatia Republic, Russia
2833026 2833026 2022-01-22 Russia Chechen Republic     32623 986 0   43.39761470000001 45.6985005 2022-01-23 04:21:13 Chechen Republic, Russia
2833027 2833027 2022-01-22 Russia Chelyabinsk Oblast     152078 6412 0   54.4223954 61.1865846 2022-01-23 04:21:13 Chelyabinsk Oblast, Russia
2833028 2833028 2022-01-22 Russia Chukotka Autonomous Okrug     3011 39 0   66.0006475 169.4900869 2022-01-23 04:21:13 Chukotka Autonomous Okrug, Russia
2833029 2833029 2022-01-22 Russia Chuvashia Republic     47993 4171 0   55.4259922 47.0849429 2022-01-23 04:21:13 Chuvashia Republic, Russia
2833030 2833030 2022-01-22 Russia Dagestan Republic     68938 3301 0   43.05749160000001 47.1332224 2022-01-23 04:21:13 Dagestan Republic, Russia
2833031 2833031 2022-01-22 Russia Ingushetia Republic     30224 499 0   43.11542075 45.01713552 2022-01-23 04:21:13 Ingushetia Republic, Russia
2833032 2833032 2022-01-22 Russia Irkutsk Oblast     164076 7281 0   56.6370122 104.71922099999999 2022-01-23 04:21:13 Irkutsk Oblast, Russia
2833033 2833033 2022-01-22 Russia Ivanovo Oblast     70687 2664 0   56.9167446 41.43521370000001 2022-01-23 04:21:13 Ivanovo Oblast, Russia
2833034 2833034 2022-01-22 Russia Jewish Autonomous Okrug     12062 442 0   48.57527615 132.66307460000002 2022-01-23 04:21:13 Jewish Autonomous Okrug, Russia
2833035 2833035 2022-01-22 Russia Kabardino-Balkarian Republic     43822 1547 0   43.480604799999995 43.5978976 2022-01-23 04:21:13 Kabardino-Balkarian Republic, Russia
2833036 2833036 2022-01-22 Russia Kaliningrad Oblast     86504 1377 0   54.7293041 21.1489473 2022-01-23 04:21:13 Kaliningrad Oblast, Russia
2833037 2833037 2022-01-22 Russia Kalmykia Republic     34495 763 0   46.2313018 45.3275745 2022-01-23 04:21:13 Kalmykia Republic, Russia
2833038 2833038 2022-01-22 Russia Kaluga Oblast     68060 1273 0   54.438277299999996 35.5272854 2022-01-23 04:21:13 Kaluga Oblast, Russia
2833039 2833039 2022-01-22 Russia Kamchatka Krai     24616 524 0   57.191488199999995 160.03838190000005 2022-01-23 04:21:13 Kamchatka Krai, Russia
2833040 2833040 2022-01-22 Russia Karachay-Cherkess Republic     33624 926 0   43.7368326 41.7267991 2022-01-23 04:21:13 Karachay-Cherkess Republic, Russia
2833041 2833041 2022-01-22 Russia Karelia Republic     93750 1279 0   62.61940309999999 33.4920267 2022-01-23 04:21:13 Karelia Republic, Russia
2833042 2833042 2022-01-22 Russia Kemerovo Oblast     90733 1831 0   54.53357809999999 87.342861 2022-01-23 04:21:13 Kemerovo Oblast, Russia
2833043 2833043 2022-01-22 Russia Khabarovsk Krai     130764 1316 0   51.6312684 136.121524 2022-01-23 04:21:13 Khabarovsk Krai, Russia
2833044 2833044 2022-01-22 Russia Khakassia Republic     55581 2102 0   53.72258845 91.44293627 2022-01-23 04:21:13 Khakassia Republic, Russia
2833045 2833045 2022-01-22 Russia Khanty-Mansi Autonomous Okrug     101098 2128 0   61.0259025 69.0982628 2022-01-23 04:21:13 Khanty-Mansi Autonomous Okrug, Russia
2833046 2833046 2022-01-22 Russia Kirov Oblast     83264 801 0   57.9665589 49.4074599 2022-01-23 04:21:13 Kirov Oblast, Russia
2833047 2833047 2022-01-22 Russia Komi Republic     100119 2745 0   63.9881421 54.3326073 2022-01-23 04:21:13 Komi Republic, Russia
2833048 2833048 2022-01-22 Russia Kostroma Oblast     49847 1153 0   58.424756 44.253327299999995 2022-01-23 04:21:13 Kostroma Oblast, Russia
2833049 2833049 2022-01-22 Russia Krasnodar Krai     129872 9996 0   45.768401399999995 39.0261044 2022-01-23 04:21:13 Krasnodar Krai, Russia
2833050 2833050 2022-01-22 Russia Krasnoyarsk Krai     179963 9251 0   63.3233807 97.09799740000001 2022-01-23 04:21:13 Krasnoyarsk Krai, Russia
2833051 2833051 2022-01-22 Russia Kurgan Oblast     52554 1037 0   55.7655302 64.5632681 2022-01-23 04:21:13 Kurgan Oblast, Russia
2833052 2833052 2022-01-22 Russia Kursk Oblast     84236 2143 0   51.6568453 36.4852695 2022-01-23 04:21:13 Kursk Oblast, Russia
2833053 2833053 2022-01-22 Russia Leningrad Oblast     107775 3109 0   60.185329599999996 32.3925325 2022-01-23 04:21:13 Leningrad Oblast, Russia
2833054 2833054 2022-01-22 Russia Lipetsk Oblast     87543 2967 0   52.693517799999995 39.112266399999996 2022-01-23 04:21:13 Lipetsk Oblast, Russia
2833055 2833055 2022-01-22 Russia Magadan Oblast     14032 356 0   62.48858785 153.9903764 2022-01-23 04:21:13 Magadan Oblast, Russia
2833056 2833056 2022-01-22 Russia Mari El Republic     30494 961 0   56.576750399999995 47.881751200000004 2022-01-23 04:21:13 Mari El Republic, Russia
2833057 2833057 2022-01-22 Russia Mordovia Republic     41858 1110 0   54.4419829 44.466114399999995 2022-01-23 04:21:13 Mordovia Republic, Russia
2833058 2833058 2022-01-22 Russia Moscow     2157008 38295 0   55.7504461 37.6174943 2022-01-23 04:21:13 Moscow, Russia
2833059 2833059 2022-01-22 Russia Moscow Oblast     685978 12997 0   55.50431579999999 38.0353929 2022-01-23 04:21:13 Moscow Oblast, Russia
2833060 2833060 2022-01-22 Russia Murmansk Oblast     94506 2877 0   68.00004179999999 33.9999151 2022-01-23 04:21:13 Murmansk Oblast, Russia
2833061 2833061 2022-01-22 Russia Nenets Autonomous Okrug     3613 89 0   68.27557185 57.1686375 2022-01-23 04:21:13 Nenets Autonomous Okrug, Russia
2833062 2833062 2022-01-22 Russia Nizhny Novgorod Oblast     241392 10339 0   55.47180329999999 44.091159399999995 2022-01-23 04:21:13 Nizhny Novgorod Oblast, Russia
2833063 2833063 2022-01-22 Russia North Ossetia - Alania Republic     32520 1057 0   42.79336110000001 44.6324493 2022-01-23 04:21:13 North Ossetia - Alania Republic, Russia
2833064 2833064 2022-01-22 Russia Novgorod Oblast     68115 813 0   58.2843833 32.516975699999996 2022-01-23 04:21:13 Novgorod Oblast, Russia
2833065 2833065 2022-01-22 Russia Novosibirsk Oblast     100347 4517 0   54.9720169 79.48139240000002 2022-01-23 04:21:13 Novosibirsk Oblast, Russia
2833066 2833066 2022-01-22 Russia Omsk Oblast     136343 3415 0   56.09352629999999 73.5099936 2022-01-23 04:21:13 Omsk Oblast, Russia
2833067 2833067 2022-01-22 Russia Orel Oblast     73850 1596 0   52.96854329999999 36.0692477 2022-01-23 04:21:13 Orel Oblast, Russia
2833068 2833068 2022-01-22 Russia Orenburg Oblast     110847 3564 0   52.02692620000001 54.7276647 2022-01-23 04:21:13 Orenburg Oblast, Russia
2833069 2833069 2022-01-22 Russia Penza Oblast     105760 4826 0   53.1655415 44.78791810000001 2022-01-23 04:21:13 Penza Oblast, Russia
2833070 2833070 2022-01-22 Russia Perm Krai     169004 7709 0   58.5951603 56.3159546 2022-01-23 04:21:13 Perm Krai, Russia
2833071 2833071 2022-01-22 Russia Primorsky Krai     108588 1663 0   45.0819456 134.726645 2022-01-23 04:21:13 Primorsky Krai, Russia
2833072 2833072 2022-01-22 Russia Pskov Oblast     73596 1381 0   57.535872899999994 28.8586826 2022-01-23 04:21:13 Pskov Oblast, Russia
2833073 2833073 2022-01-22 Russia Rostov Oblast     203386 9947 0   47.6222451 40.7957942 2022-01-23 04:21:13 Rostov Oblast, Russia
2833074 2833074 2022-01-22 Russia Ryazan Oblast     63772 2785 0   54.42267320000001 40.57052460000001 2022-01-23 04:21:13 Ryazan Oblast, Russia
2833075 2833075 2022-01-22 Russia Saint Petersburg     912224 29351 0   59.960673899999996 30.158655100000004 2022-01-23 04:21:13 Saint Petersburg, Russia
2833076 2833076 2022-01-22 Russia Sakha (Yakutiya) Republic     81889 1843 0   66.941626 129.642371 2022-01-23 04:21:13 Sakha (Yakutiya) Republic, Russia
2833077 2833077 2022-01-22 Russia Sakhalin Oblast     44818 608 0   49.7219665 143.448533 2022-01-23 04:21:13 Sakhalin Oblast, Russia
2833078 2833078 2022-01-22 Russia Samara Oblast     207250 6598 0   53.2128813 50.8914633 2022-01-23 04:21:13 Samara Oblast, Russia
2833079 2833079 2022-01-22 Russia Saratov Oblast     137894 5277 0   51.652055499999996 46.86319520000001 2022-01-23 04:21:13 Saratov Oblast, Russia
2833080 2833080 2022-01-22 Russia Smolensk Oblast     87860 2517 0   55.03434960000001 33.0192065 2022-01-23 04:21:13 Smolensk Oblast, Russia
2833081 2833081 2022-01-22 Russia Stavropol Krai     133837 6361 0   44.86325770000001 43.4406913 2022-01-23 04:21:13 Stavropol Krai, Russia
2833082 2833082 2022-01-22 Russia Sverdlovsk Oblast     209627 9864 0   58.6414755 61.802154599999994 2022-01-23 04:21:13 Sverdlovsk Oblast, Russia
2833083 2833083 2022-01-22 Russia Tambov Oblast     64886 1871 0   52.9019574 41.3578918 2022-01-23 04:21:13 Tambov Oblast, Russia
2833084 2833084 2022-01-22 Russia Tatarstan Republic     45015 1550 0   55.7648572 52.43104273 2022-01-23 04:21:13 Tatarstan Republic, Russia
2833085 2833085 2022-01-22 Russia Tomsk Oblast     64586 694 0   58.6124279 82.04753149999998 2022-01-23 04:21:13 Tomsk Oblast, Russia
2833086 2833086 2022-01-22 Russia Tula Oblast     79977 4503 0   53.9570701 37.369090899999996 2022-01-23 04:21:13 Tula Oblast, Russia
2833087 2833087 2022-01-22 Russia Tver Oblast     103603 2434 0   57.1134475 35.174442799999994 2022-01-23 04:21:13 Tver Oblast, Russia
2833088 2833088 2022-01-22 Russia Tyumen Oblast     95612 3662 0   58.8206488 70.36588370000001 2022-01-23 04:21:13 Tyumen Oblast, Russia
2833089 2833089 2022-01-22 Russia Tyva Republic     32173 332 0   51.401714899999995 93.8582593 2022-01-23 04:21:13 Tyva Republic, Russia
2833090 2833090 2022-01-22 Russia Udmurt Republic     81498 3295 0   57.1961165 52.69598320000001 2022-01-23 04:21:13 Udmurt Republic, Russia
2833091 2833091 2022-01-22 Russia Ulyanovsk Oblast     123123 4019 0   54.146317700000004 47.2324921 2022-01-23 04:21:13 Ulyanovsk Oblast, Russia
2833092 2833092 2022-01-22 Russia Vladimir Oblast     85656 3043 0   56.0503336 40.656163299999996 2022-01-23 04:21:13 Vladimir Oblast, Russia
2833093 2833093 2022-01-22 Russia Volgograd Oblast     134329 5880 0   49.604833899999996 44.29035820000001 2022-01-23 04:21:13 Volgograd Oblast, Russia
2833094 2833094 2022-01-22 Russia Vologda Oblast     102702 3132 0   60.0391461 43.1215213 2022-01-23 04:21:13 Vologda Oblast, Russia
2833095 2833095 2022-01-22 Russia Voronezh Oblast     201242 7197 0   50.9800393 40.15065070000001 2022-01-23 04:21:13 Voronezh Oblast, Russia
2833096 2833096 2022-01-22 Russia Yamalo-Nenets Autonomous Okrug     64145 976 0   67.1471631 74.3415488 2022-01-23 04:21:13 Yamalo-Nenets Autonomous Okrug, Russia
2833097 2833097 2022-01-22 Russia Yaroslavl Oblast     90124 2043 0   57.77819760000001 39.002109499999996 2022-01-23 04:21:13 Yaroslavl Oblast, Russia
2833098 2833098 2022-01-22 Russia Zabaykalsky Krai     98511 1995 0   52.248521000000004 115.956325 2022-01-23 04:21:13 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]);