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 2020-12-22 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
927873 927873 2020-12-21 Russia Adygea Republic     10128 80 8068 1980 44.6939006 40.1520421 2020-12-22 05:22:33 Adygea Republic, Russia
927874 927874 2020-12-21 Russia Altai Krai     30765 761 28139 1865 52.6932243 82.69314240000001 2020-12-22 05:22:33 Altai Krai, Russia
927875 927875 2020-12-21 Russia Altai Republic     13122 77 12480 565 50.7114101 86.8572186 2020-12-22 05:22:33 Altai Republic, Russia
927876 927876 2020-12-21 Russia Amur Oblast     14479 105 12907 1467 52.8032368 128.437295 2020-12-22 05:22:33 Amur Oblast, Russia
927877 927877 2020-12-21 Russia Arkhangelsk Oblast     39577 394 30316 8867 63.5589686 43.1221646 2020-12-22 05:22:33 Arkhangelsk Oblast, Russia
927878 927878 2020-12-21 Russia Astrakhan Oblast     17221 338 11816 5067 47.1878186 47.608851 2020-12-22 05:22:33 Astrakhan Oblast, Russia
927879 927879 2020-12-21 Russia Bashkortostan Republic     17418 125 13712 3581 54.8573563 57.1439682 2020-12-22 05:22:33 Bashkortostan Republic, Russia
927880 927880 2020-12-21 Russia Belgorod Oblast     19964 206 18056 1702 50.7080119 37.5837615 2020-12-22 05:22:33 Belgorod Oblast, Russia
927881 927881 2020-12-21 Russia Bryansk Oblast     21121 207 18868 2046 52.8873315 33.41585300000001 2020-12-22 05:22:33 Bryansk Oblast, Russia
927882 927882 2020-12-21 Russia Buryatia Republic     23754 542 21326 1886 52.7182426 109.492143 2020-12-22 05:22:33 Buryatia Republic, Russia
927883 927883 2020-12-21 Russia Chechen Republic     7298 87 3401 3810 43.39761470000001 45.6985005 2020-12-22 05:22:33 Chechen Republic, Russia
927884 927884 2020-12-21 Russia Chelyabinsk Oblast     31609 453 22921 8235 54.4223954 61.1865846 2020-12-22 05:22:33 Chelyabinsk Oblast, Russia
927885 927885 2020-12-21 Russia Chukotka Autonomous Okrug     492 4 427 61 66.0006475 169.4900869 2020-12-22 05:22:33 Chukotka Autonomous Okrug, Russia
927886 927886 2020-12-21 Russia Chuvashia Republic     15206 423 13552 1231 55.4259922 47.0849429 2020-12-22 05:22:33 Chuvashia Republic, Russia
927887 927887 2020-12-21 Russia Dagestan Republic     21889 1067 18820 2002 43.05749160000001 47.1332224 2020-12-22 05:22:33 Dagestan Republic, Russia
927888 927888 2020-12-21 Russia Ingushetia Republic     11245 124 9412 1709 43.11542075 45.01713552 2020-12-22 05:22:33 Ingushetia Republic, Russia
927889 927889 2020-12-21 Russia Irkutsk Oblast     37839 1093 32966 3780 56.6370122 104.719221 2020-12-22 05:22:33 Irkutsk Oblast, Russia
927890 927890 2020-12-21 Russia Ivanovo Oblast     19401 422 14199 4780 56.9167446 41.43521370000001 2020-12-22 05:22:33 Ivanovo Oblast, Russia
927891 927891 2020-12-21 Russia Jewish Autonomous Okrug     3542 62 2437 1043 48.57527615 132.66307460000002 2020-12-22 05:22:33 Jewish Autonomous Okrug, Russia
927892 927892 2020-12-21 Russia Kabardino-Balkarian Republic     14801 250 12701 1850 43.4806048 43.5978976 2020-12-22 05:22:33 Kabardino-Balkarian Republic, Russia
927893 927893 2020-12-21 Russia Kaliningrad Oblast     15682 150 12205 3327 54.7293041 21.1489473 2020-12-22 05:22:33 Kaliningrad Oblast, Russia
927894 927894 2020-12-21 Russia Kalmykia Republic     13741 186 11275 2280 46.2313018 45.3275745 2020-12-22 05:22:33 Kalmykia Republic, Russia
927895 927895 2020-12-21 Russia Kaluga Oblast     19346 147 18064 1135 54.4382773 35.5272854 2020-12-22 05:22:33 Kaluga Oblast, Russia
927896 927896 2020-12-21 Russia Kamchatka Krai     9328 82 8228 1018 57.1914882 160.03838190000005 2020-12-22 05:22:33 Kamchatka Krai, Russia
927897 927897 2020-12-21 Russia Karachay-Cherkess Republic     14212 38 12654 1520 43.7368326 41.7267991 2020-12-22 05:22:33 Karachay-Cherkess Republic, Russia
927898 927898 2020-12-21 Russia Karelia Republic     23813 139 16586 7088 62.61940309999999 33.4920267 2020-12-22 05:22:33 Karelia Republic, Russia
927899 927899 2020-12-21 Russia Kemerovo Oblast     24300 447 21114 2739 54.53357809999999 87.342861 2020-12-22 05:22:33 Kemerovo Oblast, Russia
927900 927900 2020-12-21 Russia Khabarovsk Krai     31675 196 26749 4730 51.6312684 136.121524 2020-12-22 05:22:33 Khabarovsk Krai, Russia
927901 927901 2020-12-21 Russia Khakassia Republic     15843 207 12809 2827 53.72258845 91.44293627 2020-12-22 05:22:33 Khakassia Republic, Russia
927902 927902 2020-12-21 Russia Khanty-Mansi Autonomous Okrug     39064 502 34972 3590 61.0259025 69.0982628 2020-12-22 05:22:33 Khanty-Mansi Autonomous Okrug, Russia
927903 927903 2020-12-21 Russia Kirov Oblast     23175 218 16485 6472 57.9665589 49.4074599 2020-12-22 05:22:33 Kirov Oblast, Russia
927904 927904 2020-12-21 Russia Komi Republic     27508 518 24246 2744 63.9881421 54.3326073 2020-12-22 05:22:33 Komi Republic, Russia
927905 927905 2020-12-21 Russia Kostroma Oblast     13900 207 10238 3455 58.424756 44.2533273 2020-12-22 05:22:33 Kostroma Oblast, Russia
927906 927906 2020-12-21 Russia Krasnodar Krai     25849 795 17450 7604 45.7684014 39.0261044 2020-12-22 05:22:33 Krasnodar Krai, Russia
927907 927907 2020-12-21 Russia Krasnoyarsk Krai     43246 1509 36666 5071 63.3233807 97.0979974 2020-12-22 05:22:33 Krasnoyarsk Krai, Russia
927908 927908 2020-12-21 Russia Kurgan Oblast     10934 148 9647 1139 55.7655302 64.5632681 2020-12-22 05:22:33 Kurgan Oblast, Russia
927909 927909 2020-12-21 Russia Kursk Oblast     18967 268 17167 1532 51.6568453 36.4852695 2020-12-22 05:22:33 Kursk Oblast, Russia
927910 927910 2020-12-21 Russia Leningrad Oblast     21545 200 19353 1992 60.1853296 32.3925325 2020-12-22 05:22:33 Leningrad Oblast, Russia
927911 927911 2020-12-21 Russia Lipetsk Oblast     14407 204 10915 3288 52.6935178 39.1122664 2020-12-22 05:22:33 Lipetsk Oblast, Russia
927912 927912 2020-12-21 Russia Magadan Oblast     6607 60 6085 462 62.48858785 153.9903764 2020-12-22 05:22:33 Magadan Oblast, Russia
927913 927913 2020-12-21 Russia Mari El Republic     8670 112 7696 862 56.5767504 47.8817512 2020-12-22 05:22:33 Mari El Republic, Russia
927914 927914 2020-12-21 Russia Mordovia Republic     12617 81 10329 2207 54.4419829 44.4661144 2020-12-22 05:22:33 Mordovia Republic, Russia
927915 927915 2020-12-21 Russia Moscow     743697 10469 572541 160687 55.7504461 37.6174943 2020-12-22 05:22:33 Moscow, Russia
927916 927916 2020-12-21 Russia Moscow Oblast     139706 2697 98816 38193 55.50431579999999 38.0353929 2020-12-22 05:22:33 Moscow Oblast, Russia
927917 927917 2020-12-21 Russia Murmansk Oblast     33389 595 30576 2218 68.00004179999999 33.9999151 2020-12-22 05:22:33 Murmansk Oblast, Russia
927918 927918 2020-12-21 Russia Nenets Autonomous Okrug     749 0 678 71 68.27557185 57.1686375 2020-12-22 05:22:33 Nenets Autonomous Okrug, Russia
927919 927919 2020-12-21 Russia Nizhny Novgorod Oblast     64804 1486 57794 5524 55.47180329999999 44.0911594 2020-12-22 05:22:33 Nizhny Novgorod Oblast, Russia
927920 927920 2020-12-21 Russia North Ossetia - Alania Republic     11131 85 9884 1162 42.79336110000001 44.6324493 2020-12-22 05:22:33 North Ossetia - Alania Republic, Russia
927921 927921 2020-12-21 Russia Novgorod Oblast     16213 97 11690 4426 58.2843833 32.5169757 2020-12-22 05:22:33 Novgorod Oblast, Russia
927922 927922 2020-12-21 Russia Novosibirsk Oblast     26305 888 22005 3412 54.9720169 79.48139240000002 2020-12-22 05:22:33 Novosibirsk Oblast, Russia
927923 927923 2020-12-21 Russia Omsk Oblast     27658 795 25042 1821 56.09352629999999 73.5099936 2020-12-22 05:22:33 Omsk Oblast, Russia
927924 927924 2020-12-21 Russia Orel Oblast     19582 242 17360 1980 52.96854329999999 36.0692477 2020-12-22 05:22:33 Orel Oblast, Russia
927925 927925 2020-12-21 Russia Orenburg Oblast     26959 297 23506 3156 52.02692620000001 54.7276647 2020-12-22 05:22:33 Orenburg Oblast, Russia
927926 927926 2020-12-21 Russia Penza Oblast     24058 293 19736 4029 53.1655415 44.78791810000001 2020-12-22 05:22:33 Penza Oblast, Russia
927927 927927 2020-12-21 Russia Perm Krai     27318 989 21372 4957 58.5951603 56.3159546 2020-12-22 05:22:33 Perm Krai, Russia
927928 927928 2020-12-21 Russia Primorsky Krai     26900 328 18961 7611 45.0819456 134.726645 2020-12-22 05:22:33 Primorsky Krai, Russia
927929 927929 2020-12-21 Russia Pskov Oblast     19223 95 9758 9370 57.5358729 28.8586826 2020-12-22 05:22:33 Pskov Oblast, Russia
927930 927930 2020-12-21 Russia Rostov Oblast     47783 1836 38427 7520 47.6222451 40.7957942 2020-12-22 05:22:33 Rostov Oblast, Russia
927931 927931 2020-12-21 Russia Ryazan Oblast     16771 126 15291 1354 54.42267320000001 40.57052460000001 2020-12-22 05:22:33 Ryazan Oblast, Russia
927932 927932 2020-12-21 Russia Saint Petersburg     204565 6917 119002 78646 59.9606739 30.158655100000004 2020-12-22 05:22:33 Saint Petersburg, Russia
927933 927933 2020-12-21 Russia Sakha (Yakutiya) Republic     24447 352 21907 2188 66.941626 129.642371 2020-12-22 05:22:33 Sakha (Yakutiya) Republic, Russia
927934 927934 2020-12-21 Russia Sakhalin Oblast     14270 12 11057 3201 49.7219665 143.448533 2020-12-22 05:22:33 Sakhalin Oblast, Russia
927935 927935 2020-12-21 Russia Samara Oblast     28335 540 26102 1693 53.2128813 50.8914633 2020-12-22 05:22:33 Samara Oblast, Russia
927936 927936 2020-12-21 Russia Saratov Oblast     32612 357 28023 4232 51.6520555 46.86319520000001 2020-12-22 05:22:33 Saratov Oblast, Russia
927937 927937 2020-12-21 Russia Smolensk Oblast     15451 307 11589 3555 55.03434960000001 33.0192065 2020-12-22 05:22:33 Smolensk Oblast, Russia
927938 927938 2020-12-21 Russia Stavropol Krai     32646 673 29231 2742 44.86325770000001 43.4406913 2020-12-22 05:22:33 Stavropol Krai, Russia
927939 927939 2020-12-21 Russia Sverdlovsk Oblast     54539 1343 46846 6350 58.6414755 61.8021546 2020-12-22 05:22:33 Sverdlovsk Oblast, Russia
927940 927940 2020-12-21 Russia Tambov Oblast     16097 161 14115 1821 52.9019574 41.3578918 2020-12-22 05:22:33 Tambov Oblast, Russia
927941 927941 2020-12-21 Russia Tatarstan Republic     12274 170 10509 1595 55.7648572 52.43104273 2020-12-22 05:22:33 Tatarstan Republic, Russia
927942 927942 2020-12-21 Russia Tomsk Oblast     22544 206 17956 4382 58.6124279 82.04753149999998 2020-12-22 05:22:33 Tomsk Oblast, Russia
927943 927943 2020-12-21 Russia Tula Oblast     20768 644 18171 1953 53.9570701 37.3690909 2020-12-22 05:22:33 Tula Oblast, Russia
927944 927944 2020-12-21 Russia Tver Oblast     19902 432 14407 5063 57.1134475 35.174442799999994 2020-12-22 05:22:33 Tver Oblast, Russia
927945 927945 2020-12-21 Russia Tyumen Oblast     21753 180 20387 1186 58.8206488 70.36588370000001 2020-12-22 05:22:33 Tyumen Oblast, Russia
927946 927946 2020-12-21 Russia Tyva Republic     14213 157 12988 1068 51.4017149 93.8582593 2020-12-22 05:22:33 Tyva Republic, Russia
927947 927947 2020-12-21 Russia Udmurt Republic     17497 360 13961 3176 57.1961165 52.69598320000001 2020-12-22 05:22:33 Udmurt Republic, Russia
927948 927948 2020-12-21 Russia Ulyanovsk Oblast     33487 435 30424 2628 54.1463177 47.2324921 2020-12-22 05:22:33 Ulyanovsk Oblast, Russia
927949 927949 2020-12-21 Russia Vladimir Oblast     16764 414 15065 1285 56.0503336 40.6561633 2020-12-22 05:22:33 Vladimir Oblast, Russia
927950 927950 2020-12-21 Russia Volgograd Oblast     32671 409 30955 1307 49.6048339 44.29035820000001 2020-12-22 05:22:33 Volgograd Oblast, Russia
927951 927951 2020-12-21 Russia Vologda Oblast     19822 331 15081 4410 60.0391461 43.1215213 2020-12-22 05:22:33 Vologda Oblast, Russia
927952 927952 2020-12-21 Russia Voronezh Oblast     42331 961 40669 701 50.9800393 40.15065070000001 2020-12-22 05:22:33 Voronezh Oblast, Russia
927953 927953 2020-12-21 Russia Yamalo-Nenets Autonomous Okrug     30352 307 22568 7477 67.1471631 74.3415488 2020-12-22 05:22:33 Yamalo-Nenets Autonomous Okrug, Russia
927954 927954 2020-12-21 Russia Yaroslavl Oblast     20397 150 19098 1149 57.77819760000001 39.0021095 2020-12-22 05:22:33 Yaroslavl Oblast, Russia
927955 927955 2020-12-21 Russia Zabaykalsky Krai     24759 353 22505 1901 52.248521 115.956325 2020-12-22 05:22:33 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]);