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-08-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
3555833 3555833 2021-08-21 Russia Adygea Republic     17504 317 0   44.6939006 40.1520421 2021-08-22 04:21:29 Adygea Republic, Russia
3555834 3555834 2021-08-21 Russia Altai Krai     67852 3374 0   52.693224300000004 82.69314240000001 2021-08-22 04:21:29 Altai Krai, Russia
3555835 3555835 2021-08-21 Russia Altai Republic     20357 299 0   50.7114101 86.8572186 2021-08-22 04:21:29 Altai Republic, Russia
3555836 3555836 2021-08-21 Russia Amur Oblast     30599 375 0   52.8032368 128.437295 2021-08-22 04:21:29 Amur Oblast, Russia
3555837 3555837 2021-08-21 Russia Arkhangelsk Oblast     78902 1106 0   63.5589686 43.1221646 2021-08-22 04:21:29 Arkhangelsk Oblast, Russia
3555838 3555838 2021-08-21 Russia Astrakhan Oblast     49417 1326 0   47.1878186 47.608851 2021-08-22 04:21:29 Astrakhan Oblast, Russia
3555839 3555839 2021-08-21 Russia Bashkortostan Republic     54047 975 0   54.8573563 57.1439682 2021-08-22 04:21:29 Bashkortostan Republic, Russia
3555840 3555840 2021-08-21 Russia Belgorod Oblast     47666 973 0   50.7080119 37.5837615 2021-08-22 04:21:29 Belgorod Oblast, Russia
3555841 3555841 2021-08-21 Russia Bryansk Oblast     58832 1006 0   52.887331499999995 33.41585300000001 2021-08-22 04:21:29 Bryansk Oblast, Russia
3555842 3555842 2021-08-21 Russia Buryatia Republic     55360 1767 0   52.718242599999996 109.492143 2021-08-22 04:21:29 Buryatia Republic, Russia
3555843 3555843 2021-08-21 Russia Chechen Republic     19011 433 0   43.39761470000001 45.6985005 2021-08-22 04:21:29 Chechen Republic, Russia
3555844 3555844 2021-08-21 Russia Chelyabinsk Oblast     81182 2530 0   54.4223954 61.1865846 2021-08-22 04:21:29 Chelyabinsk Oblast, Russia
3555845 3555845 2021-08-21 Russia Chukotka Autonomous Okrug     1394 10 0   66.0006475 169.4900869 2021-08-22 04:21:29 Chukotka Autonomous Okrug, Russia
3555846 3555846 2021-08-21 Russia Chuvashia Republic     30908 1907 0   55.4259922 47.0849429 2021-08-22 04:21:29 Chuvashia Republic, Russia
3555847 3555847 2021-08-21 Russia Dagestan Republic     45890 2076 0   43.05749160000001 47.1332224 2021-08-22 04:21:29 Dagestan Republic, Russia
3555848 3555848 2021-08-21 Russia Ingushetia Republic     18950 265 0   43.11542075 45.01713552 2021-08-22 04:21:29 Ingushetia Republic, Russia
3555849 3555849 2021-08-21 Russia Irkutsk Oblast     93795 4289 0   56.6370122 104.71922099999999 2021-08-22 04:21:29 Irkutsk Oblast, Russia
3555850 3555850 2021-08-21 Russia Ivanovo Oblast     43976 1445 0   56.9167446 41.43521370000001 2021-08-22 04:21:29 Ivanovo Oblast, Russia
3555851 3555851 2021-08-21 Russia Jewish Autonomous Okrug     6572 194 0   48.57527615 132.66307460000002 2021-08-22 04:21:29 Jewish Autonomous Okrug, Russia
3555852 3555852 2021-08-21 Russia Kabardino-Balkarian Republic     28859 681 0   43.480604799999995 43.5978976 2021-08-22 04:21:29 Kabardino-Balkarian Republic, Russia
3555853 3555853 2021-08-21 Russia Kaliningrad Oblast     46912 617 0   54.7293041 21.1489473 2021-08-22 04:21:29 Kaliningrad Oblast, Russia
3555854 3555854 2021-08-21 Russia Kalmykia Republic     27084 511 0   46.2313018 45.3275745 2021-08-22 04:21:29 Kalmykia Republic, Russia
3555855 3555855 2021-08-21 Russia Kaluga Oblast     43831 549 0   54.438277299999996 35.5272854 2021-08-22 04:21:29 Kaluga Oblast, Russia
3555856 3555856 2021-08-21 Russia Kamchatka Krai     17905 244 0   57.191488199999995 160.03838190000005 2021-08-22 04:21:29 Kamchatka Krai, Russia
3555857 3555857 2021-08-21 Russia Karachay-Cherkess Republic     23543 418 0   43.7368326 41.7267991 2021-08-22 04:21:29 Karachay-Cherkess Republic, Russia
3555858 3555858 2021-08-21 Russia Karelia Republic     59291 754 0   62.61940309999999 33.4920267 2021-08-22 04:21:29 Karelia Republic, Russia
3555859 3555859 2021-08-21 Russia Kemerovo Oblast     49906 1087 0   54.53357809999999 87.342861 2021-08-22 04:21:29 Kemerovo Oblast, Russia
3555860 3555860 2021-08-21 Russia Khabarovsk Krai     72077 670 0   51.6312684 136.121524 2021-08-22 04:21:29 Khabarovsk Krai, Russia
3555861 3555861 2021-08-21 Russia Khakassia Republic     33889 872 0   53.72258845 91.44293627 2021-08-22 04:21:29 Khakassia Republic, Russia
3555862 3555862 2021-08-21 Russia Khanty-Mansi Autonomous Okrug     69015 1035 0   61.0259025 69.0982628 2021-08-22 04:21:29 Khanty-Mansi Autonomous Okrug, Russia
3555863 3555863 2021-08-21 Russia Kirov Oblast     52894 464 0   57.9665589 49.4074599 2021-08-22 04:21:29 Kirov Oblast, Russia
3555864 3555864 2021-08-21 Russia Komi Republic     60880 1388 0   63.9881421 54.3326073 2021-08-22 04:21:29 Komi Republic, Russia
3555865 3555865 2021-08-21 Russia Kostroma Oblast     29961 663 0   58.424756 44.253327299999995 2021-08-22 04:21:29 Kostroma Oblast, Russia
3555866 3555866 2021-08-21 Russia Krasnodar Krai     64452 4899 0   45.768401399999995 39.0261044 2021-08-22 04:21:29 Krasnodar Krai, Russia
3555867 3555867 2021-08-21 Russia Krasnoyarsk Krai     100653 4941 0   63.3233807 97.09799740000001 2021-08-22 04:21:29 Krasnoyarsk Krai, Russia
3555868 3555868 2021-08-21 Russia Kurgan Oblast     28501 570 0   55.7655302 64.5632681 2021-08-22 04:21:29 Kurgan Oblast, Russia
3555869 3555869 2021-08-21 Russia Kursk Oblast     50471 1217 0   51.6568453 36.4852695 2021-08-22 04:21:29 Kursk Oblast, Russia
3555870 3555870 2021-08-21 Russia Leningrad Oblast     60982 2390 0   60.185329599999996 32.3925325 2021-08-22 04:21:29 Leningrad Oblast, Russia
3555871 3555871 2021-08-21 Russia Lipetsk Oblast     44714 1312 0   52.693517799999995 39.112266399999996 2021-08-22 04:21:29 Lipetsk Oblast, Russia
3555872 3555872 2021-08-21 Russia Magadan Oblast     10081 203 0   62.48858785 153.9903764 2021-08-22 04:21:29 Magadan Oblast, Russia
3555873 3555873 2021-08-21 Russia Mari El Republic     17364 448 0   56.576750399999995 47.881751200000004 2021-08-22 04:21:29 Mari El Republic, Russia
3555874 3555874 2021-08-21 Russia Mordovia Republic     25337 457 0   54.4419829 44.466114399999995 2021-08-22 04:21:29 Mordovia Republic, Russia
3555875 3555875 2021-08-21 Russia Moscow     1553163 26927 0   55.7504461 37.6174943 2021-08-22 04:21:29 Moscow, Russia
3555876 3555876 2021-08-21 Russia Moscow Oblast     413120 7633 0   55.50431579999999 38.0353929 2021-08-22 04:21:29 Moscow Oblast, Russia
3555877 3555877 2021-08-21 Russia Murmansk Oblast     66483 1742 0   68.00004179999999 33.9999151 2021-08-22 04:21:29 Murmansk Oblast, Russia
3555878 3555878 2021-08-21 Russia Nenets Autonomous Okrug     1817 24 0   68.27557185 57.1686375 2021-08-22 04:21:29 Nenets Autonomous Okrug, Russia
3555879 3555879 2021-08-21 Russia Nizhny Novgorod Oblast     151791 5596 0   55.47180329999999 44.091159399999995 2021-08-22 04:21:29 Nizhny Novgorod Oblast, Russia
3555880 3555880 2021-08-21 Russia North Ossetia - Alania Republic     20166 331 0   42.79336110000001 44.6324493 2021-08-22 04:21:29 North Ossetia - Alania Republic, Russia
3555881 3555881 2021-08-21 Russia Novgorod Oblast     39227 314 0   58.2843833 32.516975699999996 2021-08-22 04:21:29 Novgorod Oblast, Russia
3555882 3555882 2021-08-21 Russia Novosibirsk Oblast     56740 2554 0   54.9720169 79.48139240000002 2021-08-22 04:21:29 Novosibirsk Oblast, Russia
3555883 3555883 2021-08-21 Russia Omsk Oblast     69391 1826 0   56.09352629999999 73.5099936 2021-08-22 04:21:29 Omsk Oblast, Russia
3555884 3555884 2021-08-21 Russia Orel Oblast     42261 916 0   52.96854329999999 36.0692477 2021-08-22 04:21:29 Orel Oblast, Russia
3555885 3555885 2021-08-21 Russia Orenburg Oblast     63684 1442 0   52.02692620000001 54.7276647 2021-08-22 04:21:29 Orenburg Oblast, Russia
3555886 3555886 2021-08-21 Russia Penza Oblast     61181 1999 0   53.1655415 44.78791810000001 2021-08-22 04:21:29 Penza Oblast, Russia
3555887 3555887 2021-08-21 Russia Perm Krai     83019 3821 0   58.5951603 56.3159546 2021-08-22 04:21:29 Perm Krai, Russia
3555888 3555888 2021-08-21 Russia Primorsky Krai     59904 1005 0   45.0819456 134.726645 2021-08-22 04:21:29 Primorsky Krai, Russia
3555889 3555889 2021-08-21 Russia Pskov Oblast     45918 644 0   57.535872899999994 28.8586826 2021-08-22 04:21:29 Pskov Oblast, Russia
3555890 3555890 2021-08-21 Russia Rostov Oblast     119572 5717 0   47.6222451 40.7957942 2021-08-22 04:21:29 Rostov Oblast, Russia
3555891 3555891 2021-08-21 Russia Ryazan Oblast     37736 895 0   54.42267320000001 40.57052460000001 2021-08-22 04:21:29 Ryazan Oblast, Russia
3555892 3555892 2021-08-21 Russia Saint Petersburg     565704 20226 0   59.960673899999996 30.158655100000004 2021-08-22 04:21:29 Saint Petersburg, Russia
3555893 3555893 2021-08-21 Russia Sakha (Yakutiya) Republic     47602 997 0   66.941626 129.642371 2021-08-22 04:21:29 Sakha (Yakutiya) Republic, Russia
3555894 3555894 2021-08-21 Russia Sakhalin Oblast     29620 190 0   49.7219665 143.448533 2021-08-22 04:21:29 Sakhalin Oblast, Russia
3555895 3555895 2021-08-21 Russia Samara Oblast     85845 3001 0   53.2128813 50.8914633 2021-08-22 04:21:29 Samara Oblast, Russia
3555896 3555896 2021-08-21 Russia Saratov Oblast     78400 2128 0   51.652055499999996 46.86319520000001 2021-08-22 04:21:29 Saratov Oblast, Russia
3555897 3555897 2021-08-21 Russia Smolensk Oblast     44219 1439 0   55.03434960000001 33.0192065 2021-08-22 04:21:29 Smolensk Oblast, Russia
3555898 3555898 2021-08-21 Russia Stavropol Krai     71671 2130 0   44.86325770000001 43.4406913 2021-08-22 04:21:29 Stavropol Krai, Russia
3555899 3555899 2021-08-21 Russia Sverdlovsk Oblast     118344 4878 0   58.6414755 61.802154599999994 2021-08-22 04:21:29 Sverdlovsk Oblast, Russia
3555900 3555900 2021-08-21 Russia Tambov Oblast     39638 757 0   52.9019574 41.3578918 2021-08-22 04:21:29 Tambov Oblast, Russia
3555901 3555901 2021-08-21 Russia Tatarstan Republic     24978 664 0   55.7648572 52.43104273 2021-08-22 04:21:29 Tatarstan Republic, Russia
3555902 3555902 2021-08-21 Russia Tomsk Oblast     39719 532 0   58.6124279 82.04753149999998 2021-08-22 04:21:29 Tomsk Oblast, Russia
3555903 3555903 2021-08-21 Russia Tula Oblast     50162 2616 0   53.9570701 37.369090899999996 2021-08-22 04:21:29 Tula Oblast, Russia
3555904 3555904 2021-08-21 Russia Tver Oblast     58615 1497 0   57.1134475 35.174442799999994 2021-08-22 04:21:29 Tver Oblast, Russia
3555905 3555905 2021-08-21 Russia Tyumen Oblast     52377 1267 0   58.8206488 70.36588370000001 2021-08-22 04:21:29 Tyumen Oblast, Russia
3555906 3555906 2021-08-21 Russia Tyva Republic     24059 245 0   51.401714899999995 93.8582593 2021-08-22 04:21:29 Tyva Republic, Russia
3555907 3555907 2021-08-21 Russia Udmurt Republic     44094 1415 0   57.1961165 52.69598320000001 2021-08-22 04:21:29 Udmurt Republic, Russia
3555908 3555908 2021-08-21 Russia Ulyanovsk Oblast     71452 2212 0   54.146317700000004 47.2324921 2021-08-22 04:21:29 Ulyanovsk Oblast, Russia
3555909 3555909 2021-08-21 Russia Vladimir Oblast     47402 1617 0   56.0503336 40.656163299999996 2021-08-22 04:21:29 Vladimir Oblast, Russia
3555910 3555910 2021-08-21 Russia Volgograd Oblast     78199 2136 0   49.604833899999996 44.29035820000001 2021-08-22 04:21:29 Volgograd Oblast, Russia
3555911 3555911 2021-08-21 Russia Vologda Oblast     59529 1548 0   60.0391461 43.1215213 2021-08-22 04:21:29 Vologda Oblast, Russia
3555912 3555912 2021-08-21 Russia Voronezh Oblast     113919 3760 0   50.9800393 40.15065070000001 2021-08-22 04:21:29 Voronezh Oblast, Russia
3555913 3555913 2021-08-21 Russia Yamalo-Nenets Autonomous Okrug     46368 570 0   67.1471631 74.3415488 2021-08-22 04:21:29 Yamalo-Nenets Autonomous Okrug, Russia
3555914 3555914 2021-08-21 Russia Yaroslavl Oblast     53862 960 0   57.77819760000001 39.002109499999996 2021-08-22 04:21:29 Yaroslavl Oblast, Russia
3555915 3555915 2021-08-21 Russia Zabaykalsky Krai     61754 1029 0   52.248521000000004 115.956325 2021-08-22 04:21:29 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]);