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-05-07 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
3113666 3113666 2021-05-06 Russia Adygea Republic     14473 178 13930 365 44.6939006 40.1520421 2021-05-07 04:20:40 Adygea Republic, Russia
3113667 3113667 2021-05-06 Russia Altai Krai     50081 2097 44998 2986 52.6932243 82.69314240000001 2021-05-07 04:20:40 Altai Krai, Russia
3113668 3113668 2021-05-06 Russia Altai Republic     16830 240 16527 63 50.7114101 86.8572186 2021-05-07 04:20:40 Altai Republic, Russia
3113669 3113669 2021-05-06 Russia Amur Oblast     22377 285 21565 527 52.8032368 128.437295 2021-05-07 04:20:40 Amur Oblast, Russia
3113670 3113670 2021-05-06 Russia Arkhangelsk Oblast     62286 948 58859 2479 63.5589686 43.1221646 2021-05-07 04:20:40 Arkhangelsk Oblast, Russia
3113671 3113671 2021-05-06 Russia Astrakhan Oblast     33127 738 31568 821 47.1878186 47.608851 2021-05-07 04:20:40 Astrakhan Oblast, Russia
3113672 3113672 2021-05-06 Russia Bashkortostan Republic     35950 464 33463 2023 54.8573563 57.1439682 2021-05-07 04:20:40 Bashkortostan Republic, Russia
3113673 3113673 2021-05-06 Russia Belgorod Oblast     37212 644 34811 1757 50.7080119 37.5837615 2021-05-07 04:20:40 Belgorod Oblast, Russia
3113674 3113674 2021-05-06 Russia Bryansk Oblast     38595 311 37753 531 52.8873315 33.41585300000001 2021-05-07 04:20:40 Bryansk Oblast, Russia
3113675 3113675 2021-05-06 Russia Buryatia Republic     37301 858 36029 414 52.7182426 109.492143 2021-05-07 04:20:40 Buryatia Republic, Russia
3113676 3113676 2021-05-06 Russia Chechen Republic     12054 126 11742 186 43.39761470000001 45.6985005 2021-05-07 04:20:40 Chechen Republic, Russia
3113677 3113677 2021-05-06 Russia Chelyabinsk Oblast     59511 1463 55138 2910 54.4223954 61.1865846 2021-05-07 04:20:40 Chelyabinsk Oblast, Russia
3113678 3113678 2021-05-06 Russia Chukotka Autonomous Okrug     750 7 733 10 66.0006475 169.4900869 2021-05-07 04:20:40 Chukotka Autonomous Okrug, Russia
3113679 3113679 2021-05-06 Russia Chuvashia Republic     24521 1383 22353 785 55.4259922 47.0849429 2021-05-07 04:20:40 Chuvashia Republic, Russia
3113680 3113680 2021-05-06 Russia Dagestan Republic     32591 1460 30209 922 43.05749160000001 47.1332224 2021-05-07 04:20:40 Dagestan Republic, Russia
3113681 3113681 2021-05-06 Russia Ingushetia Republic     15498 187 13595 1716 43.11542075 45.01713552 2021-05-07 04:20:40 Ingushetia Republic, Russia
3113682 3113682 2021-05-06 Russia Irkutsk Oblast     66967 2288 63880 799 56.6370122 104.719221 2021-05-07 04:20:40 Irkutsk Oblast, Russia
3113683 3113683 2021-05-06 Russia Ivanovo Oblast     34783 1159 32923 701 56.9167446 41.43521370000001 2021-05-07 04:20:40 Ivanovo Oblast, Russia
3113684 3113684 2021-05-06 Russia Jewish Autonomous Okrug     4470 133 4290 47 48.57527615 132.66307460000002 2021-05-07 04:20:40 Jewish Autonomous Okrug, Russia
3113685 3113685 2021-05-06 Russia Kabardino-Balkarian Republic     23896 453 23071 372 43.4806048 43.5978976 2021-05-07 04:20:40 Kabardino-Balkarian Republic, Russia
3113686 3113686 2021-05-06 Russia Kaliningrad Oblast     32138 429 30538 1171 54.7293041 21.1489473 2021-05-07 04:20:40 Kaliningrad Oblast, Russia
3113687 3113687 2021-05-06 Russia Kalmykia Republic     20489 352 19809 328 46.2313018 45.3275745 2021-05-07 04:20:40 Kalmykia Republic, Russia
3113688 3113688 2021-05-06 Russia Kaluga Oblast     34379 317 32598 1464 54.4382773 35.5272854 2021-05-07 04:20:40 Kaluga Oblast, Russia
3113689 3113689 2021-05-06 Russia Kamchatka Krai     14503 230 13850 423 57.1914882 160.03838190000005 2021-05-07 04:20:40 Kamchatka Krai, Russia
3113690 3113690 2021-05-06 Russia Karachay-Cherkess Republic     20134 78 19917 139 43.7368326 41.7267991 2021-05-07 04:20:40 Karachay-Cherkess Republic, Russia
3113691 3113691 2021-05-06 Russia Karelia Republic     45968 483 44123 1362 62.61940309999999 33.4920267 2021-05-07 04:20:40 Karelia Republic, Russia
3113692 3113692 2021-05-06 Russia Kemerovo Oblast     35481 677 34266 538 54.53357809999999 87.342861 2021-05-07 04:20:40 Kemerovo Oblast, Russia
3113693 3113693 2021-05-06 Russia Khabarovsk Krai     51814 385 49751 1678 51.6312684 136.121524 2021-05-07 04:20:40 Khabarovsk Krai, Russia
3113694 3113694 2021-05-06 Russia Khakassia Republic     22473 532 21595 346 53.72258845 91.44293627 2021-05-07 04:20:40 Khakassia Republic, Russia
3113695 3113695 2021-05-06 Russia Khanty-Mansi Autonomous Okrug     56308 793 55022 493 61.0259025 69.0982628 2021-05-07 04:20:40 Khanty-Mansi Autonomous Okrug, Russia
3113696 3113696 2021-05-06 Russia Kirov Oblast     42477 353 39878 2246 57.9665589 49.4074599 2021-05-07 04:20:40 Kirov Oblast, Russia
3113697 3113697 2021-05-06 Russia Komi Republic     43432 904 42179 349 63.9881421 54.3326073 2021-05-07 04:20:40 Komi Republic, Russia
3113698 3113698 2021-05-06 Russia Kostroma Oblast     20762 441 18049 2272 58.424756 44.2533273 2021-05-07 04:20:40 Kostroma Oblast, Russia
3113699 3113699 2021-05-06 Russia Krasnodar Krai     46081 2740 40546 2795 45.7684014 39.0261044 2021-05-07 04:20:40 Krasnodar Krai, Russia
3113700 3113700 2021-05-06 Russia Krasnoyarsk Krai     71013 3559 65399 2055 63.3233807 97.0979974 2021-05-07 04:20:40 Krasnoyarsk Krai, Russia
3113701 3113701 2021-05-06 Russia Kurgan Oblast     20569 401 19150 1018 55.7655302 64.5632681 2021-05-07 04:20:40 Kurgan Oblast, Russia
3113702 3113702 2021-05-06 Russia Kursk Oblast     36851 725 34685 1441 51.6568453 36.4852695 2021-05-07 04:20:40 Kursk Oblast, Russia
3113703 3113703 2021-05-06 Russia Leningrad Oblast     43099 1201 40354 1544 60.1853296 32.3925325 2021-05-07 04:20:40 Leningrad Oblast, Russia
3113704 3113704 2021-05-06 Russia Lipetsk Oblast     30213 671 27243 2299 52.6935178 39.1122664 2021-05-07 04:20:40 Lipetsk Oblast, Russia
3113705 3113705 2021-05-06 Russia Magadan Oblast     8353 101 8179 73 62.48858785 153.9903764 2021-05-07 04:20:40 Magadan Oblast, Russia
3113706 3113706 2021-05-06 Russia Mari El Republic     13148 231 12571 346 56.5767504 47.8817512 2021-05-07 04:20:40 Mari El Republic, Russia
3113707 3113707 2021-05-06 Russia Mordovia Republic     20242 248 18190 1804 54.4419829 44.4661144 2021-05-07 04:20:40 Mordovia Republic, Russia
3113708 3113708 2021-05-06 Russia Moscow     1107949 18662 1001798 87489 55.7504461 37.6174943 2021-05-07 04:20:40 Moscow, Russia
3113709 3113709 2021-05-06 Russia Moscow Oblast     253647 5901 208299 39447 55.50431579999999 38.0353929 2021-05-07 04:20:40 Moscow Oblast, Russia
3113710 3113710 2021-05-06 Russia Murmansk Oblast     50466 1168 47791 1507 68.00004179999999 33.9999151 2021-05-07 04:20:40 Murmansk Oblast, Russia
3113711 3113711 2021-05-06 Russia Nenets Autonomous Okrug     1097 4 1085 8 68.27557185 57.1686375 2021-05-07 04:20:40 Nenets Autonomous Okrug, Russia
3113712 3113712 2021-05-06 Russia Nizhny Novgorod Oblast     114764 3256 110249 1259 55.47180329999999 44.0911594 2021-05-07 04:20:40 Nizhny Novgorod Oblast, Russia
3113713 3113713 2021-05-06 Russia North Ossetia - Alania Republic     16782 198 16121 463 42.79336110000001 44.6324493 2021-05-07 04:20:40 North Ossetia - Alania Republic, Russia
3113714 3113714 2021-05-06 Russia Novgorod Oblast     30117 126 28499 1492 58.2843833 32.5169757 2021-05-07 04:20:40 Novgorod Oblast, Russia
3113715 3113715 2021-05-06 Russia Novosibirsk Oblast     41552 1777 37946 1829 54.9720169 79.48139240000002 2021-05-07 04:20:40 Novosibirsk Oblast, Russia
3113716 3113716 2021-05-06 Russia Omsk Oblast     46034 1393 43606 1035 56.09352629999999 73.5099936 2021-05-07 04:20:40 Omsk Oblast, Russia
3113717 3113717 2021-05-06 Russia Orel Oblast     34429 603 32395 1431 52.96854329999999 36.0692477 2021-05-07 04:20:40 Orel Oblast, Russia
3113718 3113718 2021-05-06 Russia Orenburg Oblast     42702 882 38805 3015 52.02692620000001 54.7276647 2021-05-07 04:20:40 Orenburg Oblast, Russia
3113719 3113719 2021-05-06 Russia Penza Oblast     45410 676 42732 2002 53.1655415 44.78791810000001 2021-05-07 04:20:40 Penza Oblast, Russia
3113720 3113720 2021-05-06 Russia Perm Krai     55054 2228 49790 3036 58.5951603 56.3159546 2021-05-07 04:20:40 Perm Krai, Russia
3113721 3113721 2021-05-06 Russia Primorsky Krai     43680 717 41054 1909 45.0819456 134.726645 2021-05-07 04:20:40 Primorsky Krai, Russia
3113722 3113722 2021-05-06 Russia Pskov Oblast     36585 358 28489 7738 57.5358729 28.8586826 2021-05-07 04:20:40 Pskov Oblast, Russia
3113723 3113723 2021-05-06 Russia Rostov Oblast     89282 4106 79934 5242 47.6222451 40.7957942 2021-05-07 04:20:40 Rostov Oblast, Russia
3113724 3113724 2021-05-06 Russia Ryazan Oblast     28089 465 26546 1078 54.42267320000001 40.57052460000001 2021-05-07 04:20:40 Ryazan Oblast, Russia
3113725 3113725 2021-05-06 Russia Saint Petersburg     420034 13420 380006 26608 59.9606739 30.158655100000004 2021-05-07 04:20:40 Saint Petersburg, Russia
3113726 3113726 2021-05-06 Russia Sakha (Yakutiya) Republic     35785 612 33138 2035 66.941626 129.642371 2021-05-07 04:20:40 Sakha (Yakutiya) Republic, Russia
3113727 3113727 2021-05-06 Russia Sakhalin Oblast     22600 42 22167 391 49.7219665 143.448533 2021-05-07 04:20:40 Sakhalin Oblast, Russia
3113728 3113728 2021-05-06 Russia Samara Oblast     62295 1568 59490 1237 53.2128813 50.8914633 2021-05-07 04:20:40 Samara Oblast, Russia
3113729 3113729 2021-05-06 Russia Saratov Oblast     59788 955 54311 4522 51.6520555 46.86319520000001 2021-05-07 04:20:40 Saratov Oblast, Russia
3113730 3113730 2021-05-06 Russia Smolensk Oblast     29738 914 28088 736 55.03434960000001 33.0192065 2021-05-07 04:20:40 Smolensk Oblast, Russia
3113731 3113731 2021-05-06 Russia Stavropol Krai     53360 1387 50439 1534 44.86325770000001 43.4406913 2021-05-07 04:20:40 Stavropol Krai, Russia
3113732 3113732 2021-05-06 Russia Sverdlovsk Oblast     86803 3161 80533 3109 58.6414755 61.8021546 2021-05-07 04:20:40 Sverdlovsk Oblast, Russia
3113733 3113733 2021-05-06 Russia Tambov Oblast     31805 485 29267 2053 52.9019574 41.3578918 2021-05-07 04:20:40 Tambov Oblast, Russia
3113734 3113734 2021-05-06 Russia Tatarstan Republic     20670 468 17670 2532 55.7648572 52.43104273 2021-05-07 04:20:40 Tatarstan Republic, Russia
3113735 3113735 2021-05-06 Russia Tomsk Oblast     32265 407 31254 604 58.6124279 82.04753149999998 2021-05-07 04:20:40 Tomsk Oblast, Russia
3113736 3113736 2021-05-06 Russia Tula Oblast     38824 1896 36401 527 53.9570701 37.3690909 2021-05-07 04:20:40 Tula Oblast, Russia
3113737 3113737 2021-05-06 Russia Tver Oblast     40316 910 38295 1111 57.1134475 35.174442799999994 2021-05-07 04:20:40 Tver Oblast, Russia
3113738 3113738 2021-05-06 Russia Tyumen Oblast     35436 478 33789 1169 58.8206488 70.36588370000001 2021-05-07 04:20:40 Tyumen Oblast, Russia
3113739 3113739 2021-05-06 Russia Tyva Republic     15839 202 15500 137 51.4017149 93.8582593 2021-05-07 04:20:40 Tyva Republic, Russia
3113740 3113740 2021-05-06 Russia Udmurt Republic     33006 853 29813 2340 57.1961165 52.69598320000001 2021-05-07 04:20:40 Udmurt Republic, Russia
3113741 3113741 2021-05-06 Russia Ulyanovsk Oblast     53938 1222 51164 1552 54.1463177 47.2324921 2021-05-07 04:20:40 Ulyanovsk Oblast, Russia
3113742 3113742 2021-05-06 Russia Vladimir Oblast     32271 1129 29812 1330 56.0503336 40.6561633 2021-05-07 04:20:40 Vladimir Oblast, Russia
3113743 3113743 2021-05-06 Russia Volgograd Oblast     57492 1144 54897 1451 49.6048339 44.29035820000001 2021-05-07 04:20:40 Volgograd Oblast, Russia
3113744 3113744 2021-05-06 Russia Vologda Oblast     45071 1026 42151 1894 60.0391461 43.1215213 2021-05-07 04:20:40 Vologda Oblast, Russia
3113745 3113745 2021-05-06 Russia Voronezh Oblast     81463 2699 76858 1906 50.9800393 40.15065070000001 2021-05-07 04:20:40 Voronezh Oblast, Russia
3113746 3113746 2021-05-06 Russia Yamalo-Nenets Autonomous Okrug     38649 416 37439 794 67.1471631 74.3415488 2021-05-07 04:20:40 Yamalo-Nenets Autonomous Okrug, Russia
3113747 3113747 2021-05-06 Russia Yaroslavl Oblast     39114 544 37361 1209 57.77819760000001 39.0021095 2021-05-07 04:20:40 Yaroslavl Oblast, Russia
3113748 3113748 2021-05-06 Russia Zabaykalsky Krai     42471 635 41018 818 52.248521 115.956325 2021-05-07 04:20:40 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]);