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-20 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
2903901 2903901 2021-12-19 Russia Adygea Republic     26213 702 0   44.6939006 40.1520421 2021-12-20 04:21:43 Adygea Republic, Russia
2903902 2903902 2021-12-19 Russia Altai Krai     113818 6267 0   52.693224300000004 82.69314240000001 2021-12-20 04:21:43 Altai Krai, Russia
2903903 2903903 2021-12-19 Russia Altai Republic     24976 493 0   50.7114101 86.8572186 2021-12-20 04:21:43 Altai Republic, Russia
2903904 2903904 2021-12-19 Russia Amur Oblast     51485 582 0   52.8032368 128.437295 2021-12-20 04:21:43 Amur Oblast, Russia
2903905 2903905 2021-12-19 Russia Arkhangelsk Oblast     120132 1484 0   63.5589686 43.1221646 2021-12-20 04:21:43 Arkhangelsk Oblast, Russia
2903906 2903906 2021-12-19 Russia Astrakhan Oblast     78599 2307 0   47.1878186 47.608851 2021-12-20 04:21:43 Astrakhan Oblast, Russia
2903907 2903907 2021-12-19 Russia Bashkortostan Republic     117293 4146 0   54.8573563 57.1439682 2021-12-20 04:21:43 Bashkortostan Republic, Russia
2903908 2903908 2021-12-19 Russia Belgorod Oblast     78893 1671 0   50.7080119 37.5837615 2021-12-20 04:21:43 Belgorod Oblast, Russia
2903909 2903909 2021-12-19 Russia Bryansk Oblast     93967 2681 0   52.887331499999995 33.41585300000001 2021-12-20 04:21:43 Bryansk Oblast, Russia
2903910 2903910 2021-12-19 Russia Buryatia Republic     73934 2331 0   52.718242599999996 109.492143 2021-12-20 04:21:43 Buryatia Republic, Russia
2903911 2903911 2021-12-19 Russia Chechen Republic     30095 889 0   43.39761470000001 45.6985005 2021-12-20 04:21:43 Chechen Republic, Russia
2903912 2903912 2021-12-19 Russia Chelyabinsk Oblast     138757 5696 0   54.4223954 61.1865846 2021-12-20 04:21:43 Chelyabinsk Oblast, Russia
2903913 2903913 2021-12-19 Russia Chukotka Autonomous Okrug     2935 32 0   66.0006475 169.4900869 2021-12-20 04:21:43 Chukotka Autonomous Okrug, Russia
2903914 2903914 2021-12-19 Russia Chuvashia Republic     45545 3659 0   55.4259922 47.0849429 2021-12-20 04:21:43 Chuvashia Republic, Russia
2903915 2903915 2021-12-19 Russia Dagestan Republic     64321 3106 0   43.05749160000001 47.1332224 2021-12-20 04:21:43 Dagestan Republic, Russia
2903916 2903916 2021-12-19 Russia Ingushetia Republic     27732 453 0   43.11542075 45.01713552 2021-12-20 04:21:43 Ingushetia Republic, Russia
2903917 2903917 2021-12-19 Russia Irkutsk Oblast     150087 6675 0   56.6370122 104.71922099999999 2021-12-20 04:21:43 Irkutsk Oblast, Russia
2903918 2903918 2021-12-19 Russia Ivanovo Oblast     65845 2356 0   56.9167446 41.43521370000001 2021-12-20 04:21:43 Ivanovo Oblast, Russia
2903919 2903919 2021-12-19 Russia Jewish Autonomous Okrug     11251 387 0   48.57527615 132.66307460000002 2021-12-20 04:21:43 Jewish Autonomous Okrug, Russia
2903920 2903920 2021-12-19 Russia Kabardino-Balkarian Republic     40836 1358 0   43.480604799999995 43.5978976 2021-12-20 04:21:43 Kabardino-Balkarian Republic, Russia
2903921 2903921 2021-12-19 Russia Kaliningrad Oblast     79938 1184 0   54.7293041 21.1489473 2021-12-20 04:21:43 Kaliningrad Oblast, Russia
2903922 2903922 2021-12-19 Russia Kalmykia Republic     33807 717 0   46.2313018 45.3275745 2021-12-20 04:21:43 Kalmykia Republic, Russia
2903923 2903923 2021-12-19 Russia Kaluga Oblast     63008 1147 0   54.438277299999996 35.5272854 2021-12-20 04:21:43 Kaluga Oblast, Russia
2903924 2903924 2021-12-19 Russia Kamchatka Krai     23354 504 0   57.191488199999995 160.03838190000005 2021-12-20 04:21:43 Kamchatka Krai, Russia
2903925 2903925 2021-12-19 Russia Karachay-Cherkess Republic     31454 898 0   43.7368326 41.7267991 2021-12-20 04:21:43 Karachay-Cherkess Republic, Russia
2903926 2903926 2021-12-19 Russia Karelia Republic     87640 1150 0   62.61940309999999 33.4920267 2021-12-20 04:21:43 Karelia Republic, Russia
2903927 2903927 2021-12-19 Russia Kemerovo Oblast     80853 1656 0   54.53357809999999 87.342861 2021-12-20 04:21:43 Kemerovo Oblast, Russia
2903928 2903928 2021-12-19 Russia Khabarovsk Krai     119696 1171 0   51.6312684 136.121524 2021-12-20 04:21:43 Khabarovsk Krai, Russia
2903929 2903929 2021-12-19 Russia Khakassia Republic     52519 1843 0   53.72258845 91.44293627 2021-12-20 04:21:43 Khakassia Republic, Russia
2903930 2903930 2021-12-19 Russia Khanty-Mansi Autonomous Okrug     93719 1898 0   61.0259025 69.0982628 2021-12-20 04:21:43 Khanty-Mansi Autonomous Okrug, Russia
2903931 2903931 2021-12-19 Russia Kirov Oblast     76324 724 0   57.9665589 49.4074599 2021-12-20 04:21:43 Kirov Oblast, Russia
2903932 2903932 2021-12-19 Russia Komi Republic     94953 2520 0   63.9881421 54.3326073 2021-12-20 04:21:43 Komi Republic, Russia
2903933 2903933 2021-12-19 Russia Kostroma Oblast     47791 1062 0   58.424756 44.253327299999995 2021-12-20 04:21:43 Kostroma Oblast, Russia
2903934 2903934 2021-12-19 Russia Krasnodar Krai     112688 9499 0   45.768401399999995 39.0261044 2021-12-20 04:21:43 Krasnodar Krai, Russia
2903935 2903935 2021-12-19 Russia Krasnoyarsk Krai     166221 8171 0   63.3233807 97.09799740000001 2021-12-20 04:21:43 Krasnoyarsk Krai, Russia
2903936 2903936 2021-12-19 Russia Kurgan Oblast     48619 960 0   55.7655302 64.5632681 2021-12-20 04:21:43 Kurgan Oblast, Russia
2903937 2903937 2021-12-19 Russia Kursk Oblast     80329 1944 0   51.6568453 36.4852695 2021-12-20 04:21:43 Kursk Oblast, Russia
2903938 2903938 2021-12-19 Russia Leningrad Oblast     97440 2953 0   60.185329599999996 32.3925325 2021-12-20 04:21:43 Leningrad Oblast, Russia
2903939 2903939 2021-12-19 Russia Lipetsk Oblast     81244 2660 0   52.693517799999995 39.112266399999996 2021-12-20 04:21:43 Lipetsk Oblast, Russia
2903940 2903940 2021-12-19 Russia Magadan Oblast     13406 335 0   62.48858785 153.9903764 2021-12-20 04:21:43 Magadan Oblast, Russia
2903941 2903941 2021-12-19 Russia Mari El Republic     28541 908 0   56.576750399999995 47.881751200000004 2021-12-20 04:21:43 Mari El Republic, Russia
2903942 2903942 2021-12-19 Russia Mordovia Republic     39318 980 0   54.4419829 44.466114399999995 2021-12-20 04:21:43 Mordovia Republic, Russia
2903943 2903943 2021-12-19 Russia Moscow     2003080 35886 0   55.7504461 37.6174943 2021-12-20 04:21:43 Moscow, Russia
2903944 2903944 2021-12-19 Russia Moscow Oblast     624416 11491 0   55.50431579999999 38.0353929 2021-12-20 04:21:43 Moscow Oblast, Russia
2903945 2903945 2021-12-19 Russia Murmansk Oblast     89910 2690 0   68.00004179999999 33.9999151 2021-12-20 04:21:43 Murmansk Oblast, Russia
2903946 2903946 2021-12-19 Russia Nenets Autonomous Okrug     3424 84 0   68.27557185 57.1686375 2021-12-20 04:21:43 Nenets Autonomous Okrug, Russia
2903947 2903947 2021-12-19 Russia Nizhny Novgorod Oblast     226383 9497 0   55.47180329999999 44.091159399999995 2021-12-20 04:21:43 Nizhny Novgorod Oblast, Russia
2903948 2903948 2021-12-19 Russia North Ossetia - Alania Republic     30056 889 0   42.79336110000001 44.6324493 2021-12-20 04:21:43 North Ossetia - Alania Republic, Russia
2903949 2903949 2021-12-19 Russia Novgorod Oblast     63457 729 0   58.2843833 32.516975699999996 2021-12-20 04:21:43 Novgorod Oblast, Russia
2903950 2903950 2021-12-19 Russia Novosibirsk Oblast     90168 4071 0   54.9720169 79.48139240000002 2021-12-20 04:21:43 Novosibirsk Oblast, Russia
2903951 2903951 2021-12-19 Russia Omsk Oblast     125329 3046 0   56.09352629999999 73.5099936 2021-12-20 04:21:43 Omsk Oblast, Russia
2903952 2903952 2021-12-19 Russia Orel Oblast     68185 1418 0   52.96854329999999 36.0692477 2021-12-20 04:21:43 Orel Oblast, Russia
2903953 2903953 2021-12-19 Russia Orenburg Oblast     105952 3346 0   52.02692620000001 54.7276647 2021-12-20 04:21:43 Orenburg Oblast, Russia
2903954 2903954 2021-12-19 Russia Penza Oblast     98381 4501 0   53.1655415 44.78791810000001 2021-12-20 04:21:43 Penza Oblast, Russia
2903955 2903955 2021-12-19 Russia Perm Krai     153627 7237 0   58.5951603 56.3159546 2021-12-20 04:21:43 Perm Krai, Russia
2903956 2903956 2021-12-19 Russia Primorsky Krai     96736 1488 0   45.0819456 134.726645 2021-12-20 04:21:43 Primorsky Krai, Russia
2903957 2903957 2021-12-19 Russia Pskov Oblast     69393 1191 0   57.535872899999994 28.8586826 2021-12-20 04:21:43 Pskov Oblast, Russia
2903958 2903958 2021-12-19 Russia Rostov Oblast     187878 9314 0   47.6222451 40.7957942 2021-12-20 04:21:43 Rostov Oblast, Russia
2903959 2903959 2021-12-19 Russia Ryazan Oblast     59563 2343 0   54.42267320000001 40.57052460000001 2021-12-20 04:21:43 Ryazan Oblast, Russia
2903960 2903960 2021-12-19 Russia Saint Petersburg     829248 27329 0   59.960673899999996 30.158655100000004 2021-12-20 04:21:43 Saint Petersburg, Russia
2903961 2903961 2021-12-19 Russia Sakha (Yakutiya) Republic     74725 1750 0   66.941626 129.642371 2021-12-20 04:21:43 Sakha (Yakutiya) Republic, Russia
2903962 2903962 2021-12-19 Russia Sakhalin Oblast     40531 495 0   49.7219665 143.448533 2021-12-20 04:21:43 Sakhalin Oblast, Russia
2903963 2903963 2021-12-19 Russia Samara Oblast     194080 6058 0   53.2128813 50.8914633 2021-12-20 04:21:43 Samara Oblast, Russia
2903964 2903964 2021-12-19 Russia Saratov Oblast     129233 4918 0   51.652055499999996 46.86319520000001 2021-12-20 04:21:43 Saratov Oblast, Russia
2903965 2903965 2021-12-19 Russia Smolensk Oblast     82545 2277 0   55.03434960000001 33.0192065 2021-12-20 04:21:43 Smolensk Oblast, Russia
2903966 2903966 2021-12-19 Russia Stavropol Krai     121521 5792 0   44.86325770000001 43.4406913 2021-12-20 04:21:43 Stavropol Krai, Russia
2903967 2903967 2021-12-19 Russia Sverdlovsk Oblast     191864 9058 0   58.6414755 61.802154599999994 2021-12-20 04:21:43 Sverdlovsk Oblast, Russia
2903968 2903968 2021-12-19 Russia Tambov Oblast     58665 1606 0   52.9019574 41.3578918 2021-12-20 04:21:43 Tambov Oblast, Russia
2903969 2903969 2021-12-19 Russia Tatarstan Republic     41568 1372 0   55.7648572 52.43104273 2021-12-20 04:21:43 Tatarstan Republic, Russia
2903970 2903970 2021-12-19 Russia Tomsk Oblast     59974 658 0   58.6124279 82.04753149999998 2021-12-20 04:21:43 Tomsk Oblast, Russia
2903971 2903971 2021-12-19 Russia Tula Oblast     72478 4112 0   53.9570701 37.369090899999996 2021-12-20 04:21:43 Tula Oblast, Russia
2903972 2903972 2021-12-19 Russia Tver Oblast     95149 2261 0   57.1134475 35.174442799999994 2021-12-20 04:21:43 Tver Oblast, Russia
2903973 2903973 2021-12-19 Russia Tyumen Oblast     86677 3221 0   58.8206488 70.36588370000001 2021-12-20 04:21:43 Tyumen Oblast, Russia
2903974 2903974 2021-12-19 Russia Tyva Republic     31376 317 0   51.401714899999995 93.8582593 2021-12-20 04:21:43 Tyva Republic, Russia
2903975 2903975 2021-12-19 Russia Udmurt Republic     78080 3184 0   57.1961165 52.69598320000001 2021-12-20 04:21:43 Udmurt Republic, Russia
2903976 2903976 2021-12-19 Russia Ulyanovsk Oblast     117425 3625 0   54.146317700000004 47.2324921 2021-12-20 04:21:43 Ulyanovsk Oblast, Russia
2903977 2903977 2021-12-19 Russia Vladimir Oblast     78154 2884 0   56.0503336 40.656163299999996 2021-12-20 04:21:43 Vladimir Oblast, Russia
2903978 2903978 2021-12-19 Russia Volgograd Oblast     125502 5265 0   49.604833899999996 44.29035820000001 2021-12-20 04:21:43 Volgograd Oblast, Russia
2903979 2903979 2021-12-19 Russia Vologda Oblast     96832 2825 0   60.0391461 43.1215213 2021-12-20 04:21:43 Vologda Oblast, Russia
2903980 2903980 2021-12-19 Russia Voronezh Oblast     189510 6545 0   50.9800393 40.15065070000001 2021-12-20 04:21:43 Voronezh Oblast, Russia
2903981 2903981 2021-12-19 Russia Yamalo-Nenets Autonomous Okrug     60812 928 0   67.1471631 74.3415488 2021-12-20 04:21:43 Yamalo-Nenets Autonomous Okrug, Russia
2903982 2903982 2021-12-19 Russia Yaroslavl Oblast     82570 1737 0   57.77819760000001 39.002109499999996 2021-12-20 04:21:43 Yaroslavl Oblast, Russia
2903983 2903983 2021-12-19 Russia Zabaykalsky Krai     93513 1739 0   52.248521000000004 115.956325 2021-12-20 04:21:43 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]);