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-09-04 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
3974748 3974748 2021-09-03 Russia Adygea Republic     18242 353 0   44.6939006 40.1520421 2021-09-04 04:21:28 Adygea Republic, Russia
3974749 3974749 2021-09-03 Russia Altai Krai     71167 3636 0   52.693224300000004 82.69314240000001 2021-09-04 04:21:28 Altai Krai, Russia
3974750 3974750 2021-09-03 Russia Altai Republic     20764 317 0   50.7114101 86.8572186 2021-09-04 04:21:28 Altai Republic, Russia
3974751 3974751 2021-09-03 Russia Amur Oblast     32278 399 0   52.8032368 128.437295 2021-09-04 04:21:28 Amur Oblast, Russia
3974752 3974752 2021-09-03 Russia Arkhangelsk Oblast     82325 1140 0   63.5589686 43.1221646 2021-09-04 04:21:28 Arkhangelsk Oblast, Russia
3974753 3974753 2021-09-03 Russia Astrakhan Oblast     53157 1469 0   47.1878186 47.608851 2021-09-04 04:21:28 Astrakhan Oblast, Russia
3974754 3974754 2021-09-03 Russia Bashkortostan Republic     57958 1159 0   54.8573563 57.1439682 2021-09-04 04:21:28 Bashkortostan Republic, Russia
3974755 3974755 2021-09-03 Russia Belgorod Oblast     49524 1019 0   50.7080119 37.5837615 2021-09-04 04:21:28 Belgorod Oblast, Russia
3974756 3974756 2021-09-03 Russia Bryansk Oblast     61064 1158 0   52.887331499999995 33.41585300000001 2021-09-04 04:21:28 Bryansk Oblast, Russia
3974757 3974757 2021-09-03 Russia Buryatia Republic     56592 1794 0   52.718242599999996 109.492143 2021-09-04 04:21:28 Buryatia Republic, Russia
3974758 3974758 2021-09-03 Russia Chechen Republic     20803 500 0   43.39761470000001 45.6985005 2021-09-04 04:21:28 Chechen Republic, Russia
3974759 3974759 2021-09-03 Russia Chelyabinsk Oblast     86083 2801 0   54.4223954 61.1865846 2021-09-04 04:21:28 Chelyabinsk Oblast, Russia
3974760 3974760 2021-09-03 Russia Chukotka Autonomous Okrug     1514 11 0   66.0006475 169.4900869 2021-09-04 04:21:28 Chukotka Autonomous Okrug, Russia
3974761 3974761 2021-09-03 Russia Chuvashia Republic     31916 2043 0   55.4259922 47.0849429 2021-09-04 04:21:28 Chuvashia Republic, Russia
3974762 3974762 2021-09-03 Russia Dagestan Republic     48282 2259 0   43.05749160000001 47.1332224 2021-09-04 04:21:28 Dagestan Republic, Russia
3974763 3974763 2021-09-03 Russia Ingushetia Republic     19843 283 0   43.11542075 45.01713552 2021-09-04 04:21:28 Ingushetia Republic, Russia
3974764 3974764 2021-09-03 Russia Irkutsk Oblast     98938 4474 0   56.6370122 104.71922099999999 2021-09-04 04:21:28 Irkutsk Oblast, Russia
3974765 3974765 2021-09-03 Russia Ivanovo Oblast     45572 1489 0   56.9167446 41.43521370000001 2021-09-04 04:21:28 Ivanovo Oblast, Russia
3974766 3974766 2021-09-03 Russia Jewish Autonomous Okrug     7078 210 0   48.57527615 132.66307460000002 2021-09-04 04:21:28 Jewish Autonomous Okrug, Russia
3974767 3974767 2021-09-03 Russia Kabardino-Balkarian Republic     29965 715 0   43.480604799999995 43.5978976 2021-09-04 04:21:28 Kabardino-Balkarian Republic, Russia
3974768 3974768 2021-09-03 Russia Kaliningrad Oblast     49273 624 0   54.7293041 21.1489473 2021-09-04 04:21:28 Kaliningrad Oblast, Russia
3974769 3974769 2021-09-03 Russia Kalmykia Republic     28364 544 0   46.2313018 45.3275745 2021-09-04 04:21:28 Kalmykia Republic, Russia
3974770 3974770 2021-09-03 Russia Kaluga Oblast     45311 600 0   54.438277299999996 35.5272854 2021-09-04 04:21:28 Kaluga Oblast, Russia
3974771 3974771 2021-09-03 Russia Kamchatka Krai     18546 264 0   57.191488199999995 160.03838190000005 2021-09-04 04:21:28 Kamchatka Krai, Russia
3974772 3974772 2021-09-03 Russia Karachay-Cherkess Republic     24169 478 0   43.7368326 41.7267991 2021-09-04 04:21:28 Karachay-Cherkess Republic, Russia
3974773 3974773 2021-09-03 Russia Karelia Republic     61427 784 0   62.61940309999999 33.4920267 2021-09-04 04:21:28 Karelia Republic, Russia
3974774 3974774 2021-09-03 Russia Kemerovo Oblast     52216 1152 0   54.53357809999999 87.342861 2021-09-04 04:21:28 Kemerovo Oblast, Russia
3974775 3974775 2021-09-03 Russia Khabarovsk Krai     76127 703 0   51.6312684 136.121524 2021-09-04 04:21:28 Khabarovsk Krai, Russia
3974776 3974776 2021-09-03 Russia Khakassia Republic     35734 979 0   53.72258845 91.44293627 2021-09-04 04:21:28 Khakassia Republic, Russia
3974777 3974777 2021-09-03 Russia Khanty-Mansi Autonomous Okrug     71001 1068 0   61.0259025 69.0982628 2021-09-04 04:21:28 Khanty-Mansi Autonomous Okrug, Russia
3974778 3974778 2021-09-03 Russia Kirov Oblast     54377 485 0   57.9665589 49.4074599 2021-09-04 04:21:28 Kirov Oblast, Russia
3974779 3974779 2021-09-03 Russia Komi Republic     64070 1507 0   63.9881421 54.3326073 2021-09-04 04:21:28 Komi Republic, Russia
3974780 3974780 2021-09-03 Russia Kostroma Oblast     31293 695 0   58.424756 44.253327299999995 2021-09-04 04:21:28 Kostroma Oblast, Russia
3974781 3974781 2021-09-03 Russia Krasnodar Krai     67706 5332 0   45.768401399999995 39.0261044 2021-09-04 04:21:28 Krasnodar Krai, Russia
3974782 3974782 2021-09-03 Russia Krasnoyarsk Krai     106311 5224 0   63.3233807 97.09799740000001 2021-09-04 04:21:28 Krasnoyarsk Krai, Russia
3974783 3974783 2021-09-03 Russia Kurgan Oblast     30158 617 0   55.7655302 64.5632681 2021-09-04 04:21:28 Kurgan Oblast, Russia
3974784 3974784 2021-09-03 Russia Kursk Oblast     52760 1293 0   51.6568453 36.4852695 2021-09-04 04:21:28 Kursk Oblast, Russia
3974785 3974785 2021-09-03 Russia Leningrad Oblast     63674 2416 0   60.185329599999996 32.3925325 2021-09-04 04:21:28 Leningrad Oblast, Russia
3974786 3974786 2021-09-03 Russia Lipetsk Oblast     47483 1427 0   52.693517799999995 39.112266399999996 2021-09-04 04:21:28 Lipetsk Oblast, Russia
3974787 3974787 2021-09-03 Russia Magadan Oblast     10420 230 0   62.48858785 153.9903764 2021-09-04 04:21:28 Magadan Oblast, Russia
3974788 3974788 2021-09-03 Russia Mari El Republic     18144 503 0   56.576750399999995 47.881751200000004 2021-09-04 04:21:28 Mari El Republic, Russia
3974789 3974789 2021-09-03 Russia Mordovia Republic     26241 491 0   54.4419829 44.466114399999995 2021-09-04 04:21:28 Mordovia Republic, Russia
3974790 3974790 2021-09-03 Russia Moscow     1572264 27593 0   55.7504461 37.6174943 2021-09-04 04:21:28 Moscow, Russia
3974791 3974791 2021-09-03 Russia Moscow Oblast     424121 7837 0   55.50431579999999 38.0353929 2021-09-04 04:21:28 Moscow Oblast, Russia
3974792 3974792 2021-09-03 Russia Murmansk Oblast     68614 1855 0   68.00004179999999 33.9999151 2021-09-04 04:21:28 Murmansk Oblast, Russia
3974793 3974793 2021-09-03 Russia Nenets Autonomous Okrug     1969 36 0   68.27557185 57.1686375 2021-09-04 04:21:28 Nenets Autonomous Okrug, Russia
3974794 3974794 2021-09-03 Russia Nizhny Novgorod Oblast     157251 5920 0   55.47180329999999 44.091159399999995 2021-09-04 04:21:28 Nizhny Novgorod Oblast, Russia
3974795 3974795 2021-09-03 Russia North Ossetia - Alania Republic     21080 409 0   42.79336110000001 44.6324493 2021-09-04 04:21:28 North Ossetia - Alania Republic, Russia
3974796 3974796 2021-09-03 Russia Novgorod Oblast     40828 376 0   58.2843833 32.516975699999996 2021-09-04 04:21:28 Novgorod Oblast, Russia
3974797 3974797 2021-09-03 Russia Novosibirsk Oblast     59008 2688 0   54.9720169 79.48139240000002 2021-09-04 04:21:28 Novosibirsk Oblast, Russia
3974798 3974798 2021-09-03 Russia Omsk Oblast     74430 1937 0   56.09352629999999 73.5099936 2021-09-04 04:21:28 Omsk Oblast, Russia
3974799 3974799 2021-09-03 Russia Orel Oblast     43474 948 0   52.96854329999999 36.0692477 2021-09-04 04:21:28 Orel Oblast, Russia
3974800 3974800 2021-09-03 Russia Orenburg Oblast     68158 1587 0   52.02692620000001 54.7276647 2021-09-04 04:21:28 Orenburg Oblast, Russia
3974801 3974801 2021-09-03 Russia Penza Oblast     64226 2209 0   53.1655415 44.78791810000001 2021-09-04 04:21:28 Penza Oblast, Russia
3974802 3974802 2021-09-03 Russia Perm Krai     89172 4168 0   58.5951603 56.3159546 2021-09-04 04:21:28 Perm Krai, Russia
3974803 3974803 2021-09-03 Russia Primorsky Krai     62979 1055 0   45.0819456 134.726645 2021-09-04 04:21:28 Primorsky Krai, Russia
3974804 3974804 2021-09-03 Russia Pskov Oblast     47160 690 0   57.535872899999994 28.8586826 2021-09-04 04:21:28 Pskov Oblast, Russia
3974805 3974805 2021-09-03 Russia Rostov Oblast     125842 6071 0   47.6222451 40.7957942 2021-09-04 04:21:28 Rostov Oblast, Russia
3974806 3974806 2021-09-03 Russia Ryazan Oblast     39245 959 0   54.42267320000001 40.57052460000001 2021-09-04 04:21:28 Ryazan Oblast, Russia
3974807 3974807 2021-09-03 Russia Saint Petersburg     580422 20692 0   59.960673899999996 30.158655100000004 2021-09-04 04:21:28 Saint Petersburg, Russia
3974808 3974808 2021-09-03 Russia Sakha (Yakutiya) Republic     49479 1064 0   66.941626 129.642371 2021-09-04 04:21:28 Sakha (Yakutiya) Republic, Russia
3974809 3974809 2021-09-03 Russia Sakhalin Oblast     30886 225 0   49.7219665 143.448533 2021-09-04 04:21:28 Sakhalin Oblast, Russia
3974810 3974810 2021-09-03 Russia Samara Oblast     91538 3293 0   53.2128813 50.8914633 2021-09-04 04:21:28 Samara Oblast, Russia
3974811 3974811 2021-09-03 Russia Saratov Oblast     81558 2379 0   51.652055499999996 46.86319520000001 2021-09-04 04:21:28 Saratov Oblast, Russia
3974812 3974812 2021-09-03 Russia Smolensk Oblast     45932 1519 0   55.03434960000001 33.0192065 2021-09-04 04:21:28 Smolensk Oblast, Russia
3974813 3974813 2021-09-03 Russia Stavropol Krai     76298 2394 0   44.86325770000001 43.4406913 2021-09-04 04:21:28 Stavropol Krai, Russia
3974814 3974814 2021-09-03 Russia Sverdlovsk Oblast     125135 5295 0   58.6414755 61.802154599999994 2021-09-04 04:21:28 Sverdlovsk Oblast, Russia
3974815 3974815 2021-09-03 Russia Tambov Oblast     40821 797 0   52.9019574 41.3578918 2021-09-04 04:21:28 Tambov Oblast, Russia
3974816 3974816 2021-09-03 Russia Tatarstan Republic     25610 688 0   55.7648572 52.43104273 2021-09-04 04:21:28 Tatarstan Republic, Russia
3974817 3974817 2021-09-03 Russia Tomsk Oblast     41131 548 0   58.6124279 82.04753149999998 2021-09-04 04:21:28 Tomsk Oblast, Russia
3974818 3974818 2021-09-03 Russia Tula Oblast     51689 2740 0   53.9570701 37.369090899999996 2021-09-04 04:21:28 Tula Oblast, Russia
3974819 3974819 2021-09-03 Russia Tver Oblast     61227 1549 0   57.1134475 35.174442799999994 2021-09-04 04:21:28 Tver Oblast, Russia
3974820 3974820 2021-09-03 Russia Tyumen Oblast     55627 1493 0   58.8206488 70.36588370000001 2021-09-04 04:21:28 Tyumen Oblast, Russia
3974821 3974821 2021-09-03 Russia Tyva Republic     25040 250 0   51.401714899999995 93.8582593 2021-09-04 04:21:28 Tyva Republic, Russia
3974822 3974822 2021-09-03 Russia Udmurt Republic     47027 1604 0   57.1961165 52.69598320000001 2021-09-04 04:21:28 Udmurt Republic, Russia
3974823 3974823 2021-09-03 Russia Ulyanovsk Oblast     75145 2326 0   54.146317700000004 47.2324921 2021-09-04 04:21:28 Ulyanovsk Oblast, Russia
3974824 3974824 2021-09-03 Russia Vladimir Oblast     49742 1721 0   56.0503336 40.656163299999996 2021-09-04 04:21:28 Vladimir Oblast, Russia
3974825 3974825 2021-09-03 Russia Volgograd Oblast     82768 2337 0   49.604833899999996 44.29035820000001 2021-09-04 04:21:28 Volgograd Oblast, Russia
3974826 3974826 2021-09-03 Russia Vologda Oblast     62459 1645 0   60.0391461 43.1215213 2021-09-04 04:21:28 Vologda Oblast, Russia
3974827 3974827 2021-09-03 Russia Voronezh Oblast     119957 4061 0   50.9800393 40.15065070000001 2021-09-04 04:21:28 Voronezh Oblast, Russia
3974828 3974828 2021-09-03 Russia Yamalo-Nenets Autonomous Okrug     47873 630 0   67.1471631 74.3415488 2021-09-04 04:21:28 Yamalo-Nenets Autonomous Okrug, Russia
3974829 3974829 2021-09-03 Russia Yaroslavl Oblast     56358 1037 0   57.77819760000001 39.002109499999996 2021-09-04 04:21:28 Yaroslavl Oblast, Russia
3974830 3974830 2021-09-03 Russia Zabaykalsky Krai     64300 1071 0   52.248521000000004 115.956325 2021-09-04 04:21:28 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]);