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-06-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
825765 825765 2021-06-06 Russia Adygea Republic     14723 208 14203 312 44.6939006 40.1520421 2021-06-07 04:22:51 Adygea Republic, Russia
825766 825766 2021-06-06 Russia Altai Krai     51977 2341 46819 2817 52.6932243 82.69314240000001 2021-06-07 04:22:51 Altai Krai, Russia
825767 825767 2021-06-06 Russia Altai Republic     17188 247 16704 237 50.7114101 86.8572186 2021-06-07 04:22:51 Altai Republic, Russia
825768 825768 2021-06-06 Russia Amur Oblast     22838 293 22212 333 52.8032368 128.437295 2021-06-07 04:22:51 Amur Oblast, Russia
825769 825769 2021-06-06 Russia Arkhangelsk Oblast     64196 997 61578 1621 63.5589686 43.1221646 2021-06-07 04:22:51 Arkhangelsk Oblast, Russia
825770 825770 2021-06-06 Russia Astrakhan Oblast     34518 792 33013 713 47.1878186 47.608851 2021-06-07 04:22:51 Astrakhan Oblast, Russia
825771 825771 2021-06-06 Russia Bashkortostan Republic     38743 531 36777 1435 54.8573563 57.1439682 2021-06-07 04:22:51 Bashkortostan Republic, Russia
825772 825772 2021-06-06 Russia Belgorod Oblast     39151 704 36759 1688 50.7080119 37.5837615 2021-06-07 04:22:51 Belgorod Oblast, Russia
825773 825773 2021-06-06 Russia Bryansk Oblast     40758 367 39849 542 52.8873315 33.41585300000001 2021-06-07 04:22:51 Bryansk Oblast, Russia
825774 825774 2021-06-06 Russia Buryatia Republic     39046 912 37455 679 52.7182426 109.492143 2021-06-07 04:22:51 Buryatia Republic, Russia
825775 825775 2021-06-06 Russia Chechen Republic     12356 138 12090 128 43.39761470000001 45.6985005 2021-06-07 04:22:51 Chechen Republic, Russia
825776 825776 2021-06-06 Russia Chelyabinsk Oblast     62343 1678 58142 2523 54.4223954 61.1865846 2021-06-07 04:22:51 Chelyabinsk Oblast, Russia
825777 825777 2021-06-06 Russia Chukotka Autonomous Okrug     773 7 738 28 66.0006475 169.4900869 2021-06-07 04:22:51 Chukotka Autonomous Okrug, Russia
825778 825778 2021-06-06 Russia Chuvashia Republic     26060 1447 23832 781 55.4259922 47.0849429 2021-06-07 04:22:51 Chuvashia Republic, Russia
825779 825779 2021-06-06 Russia Dagestan Republic     33920 1493 31404 1023 43.05749160000001 47.1332224 2021-06-07 04:22:51 Dagestan Republic, Russia
825780 825780 2021-06-06 Russia Ingushetia Republic     15842 190 15416 236 43.11542075 45.01713552 2021-06-07 04:22:51 Ingushetia Republic, Russia
825781 825781 2021-06-06 Russia Irkutsk Oblast     70536 2496 67505 535 56.6370122 104.719221 2021-06-07 04:22:51 Irkutsk Oblast, Russia
825782 825782 2021-06-06 Russia Ivanovo Oblast     36632 1226 34658 748 56.9167446 41.43521370000001 2021-06-07 04:22:51 Ivanovo Oblast, Russia
825783 825783 2021-06-06 Russia Jewish Autonomous Okrug     4508 144 4324 40 48.57527615 132.66307460000002 2021-06-07 04:22:51 Jewish Autonomous Okrug, Russia
825784 825784 2021-06-06 Russia Kabardino-Balkarian Republic     24409 471 23693 245 43.4806048 43.5978976 2021-06-07 04:22:51 Kabardino-Balkarian Republic, Russia
825785 825785 2021-06-06 Russia Kaliningrad Oblast     33883 507 32757 619 54.7293041 21.1489473 2021-06-07 04:22:51 Kaliningrad Oblast, Russia
825786 825786 2021-06-06 Russia Kalmykia Republic     20917 383 20263 271 46.2313018 45.3275745 2021-06-07 04:22:51 Kalmykia Republic, Russia
825787 825787 2021-06-06 Russia Kaluga Oblast     35974 344 34393 1237 54.4382773 35.5272854 2021-06-07 04:22:51 Kaluga Oblast, Russia
825788 825788 2021-06-06 Russia Kamchatka Krai     14748 238 14080 430 57.1914882 160.03838190000005 2021-06-07 04:22:51 Kamchatka Krai, Russia
825789 825789 2021-06-06 Russia Karachay-Cherkess Republic     20523 147 20178 198 43.7368326 41.7267991 2021-06-07 04:22:51 Karachay-Cherkess Republic, Russia
825790 825790 2021-06-06 Russia Karelia Republic     47608 563 45884 1161 62.61940309999999 33.4920267 2021-06-07 04:22:51 Karelia Republic, Russia
825791 825791 2021-06-06 Russia Kemerovo Oblast     37308 735 36054 519 54.53357809999999 87.342861 2021-06-07 04:22:51 Kemerovo Oblast, Russia
825792 825792 2021-06-06 Russia Khabarovsk Krai     52843 422 50801 1620 51.6312684 136.121524 2021-06-07 04:22:51 Khabarovsk Krai, Russia
825793 825793 2021-06-06 Russia Khakassia Republic     23315 556 22294 465 53.72258845 91.44293627 2021-06-07 04:22:51 Khakassia Republic, Russia
825794 825794 2021-06-06 Russia Khanty-Mansi Autonomous Okrug     57818 800 56465 553 61.0259025 69.0982628 2021-06-07 04:22:51 Khanty-Mansi Autonomous Okrug, Russia
825795 825795 2021-06-06 Russia Kirov Oblast     44259 372 41794 2093 57.9665589 49.4074599 2021-06-07 04:22:51 Kirov Oblast, Russia
825796 825796 2021-06-06 Russia Komi Republic     44354 968 42944 442 63.9881421 54.3326073 2021-06-07 04:22:51 Komi Republic, Russia
825797 825797 2021-06-06 Russia Kostroma Oblast     21724 488 19012 2224 58.424756 44.2533273 2021-06-07 04:22:51 Kostroma Oblast, Russia
825798 825798 2021-06-06 Russia Krasnodar Krai     49007 3095 43942 1970 45.7684014 39.0261044 2021-06-07 04:22:51 Krasnodar Krai, Russia
825799 825799 2021-06-06 Russia Krasnoyarsk Krai     74074 3781 68150 2143 63.3233807 97.0979974 2021-06-07 04:22:51 Krasnoyarsk Krai, Russia
825800 825800 2021-06-06 Russia Kurgan Oblast     21567 422 20579 566 55.7655302 64.5632681 2021-06-07 04:22:51 Kurgan Oblast, Russia
825801 825801 2021-06-06 Russia Kursk Oblast     38819 837 37218 764 51.6568453 36.4852695 2021-06-07 04:22:51 Kursk Oblast, Russia
825802 825802 2021-06-06 Russia Leningrad Oblast     45787 1505 42922 1360 60.1853296 32.3925325 2021-06-07 04:22:51 Leningrad Oblast, Russia
825803 825803 2021-06-06 Russia Lipetsk Oblast     32001 781 29048 2172 52.6935178 39.1122664 2021-06-07 04:22:51 Lipetsk Oblast, Russia
825804 825804 2021-06-06 Russia Magadan Oblast     8493 111 8284 98 62.48858785 153.9903764 2021-06-07 04:22:51 Magadan Oblast, Russia
825805 825805 2021-06-06 Russia Mari El Republic     13643 257 13172 214 56.5767504 47.8817512 2021-06-07 04:22:51 Mari El Republic, Russia
825806 825806 2021-06-06 Russia Mordovia Republic     21135 289 18772 2074 54.4419829 44.4661144 2021-06-07 04:22:51 Mordovia Republic, Russia
825807 825807 2021-06-06 Russia Moscow     1198007 20469 1076346 101192 55.7504461 37.6174943 2021-06-07 04:22:51 Moscow, Russia
825808 825808 2021-06-06 Russia Moscow Oblast     275797 6208 226784 42805 55.50431579999999 38.0353929 2021-06-07 04:22:51 Moscow Oblast, Russia
825809 825809 2021-06-06 Russia Murmansk Oblast     51630 1227 48412 1991 68.00004179999999 33.9999151 2021-06-07 04:22:51 Murmansk Oblast, Russia
825810 825810 2021-06-06 Russia Nenets Autonomous Okrug     1112 4 1100 8 68.27557185 57.1686375 2021-06-07 04:22:51 Nenets Autonomous Okrug, Russia
825811 825811 2021-06-06 Russia Nizhny Novgorod Oblast     119042 3713 113223 2106 55.47180329999999 44.0911594 2021-06-07 04:22:51 Nizhny Novgorod Oblast, Russia
825812 825812 2021-06-06 Russia North Ossetia - Alania Republic     17054 218 16408 428 42.79336110000001 44.6324493 2021-06-07 04:22:51 North Ossetia - Alania Republic, Russia
825813 825813 2021-06-06 Russia Novgorod Oblast     31193 174 30387 632 58.2843833 32.5169757 2021-06-07 04:22:51 Novgorod Oblast, Russia
825814 825814 2021-06-06 Russia Novosibirsk Oblast     43835 1907 39674 2254 54.9720169 79.48139240000002 2021-06-07 04:22:51 Novosibirsk Oblast, Russia
825815 825815 2021-06-06 Russia Omsk Oblast     47895 1443 45524 928 56.09352629999999 73.5099936 2021-06-07 04:22:51 Omsk Oblast, Russia
825816 825816 2021-06-06 Russia Orel Oblast     35933 675 34146 1112 52.96854329999999 36.0692477 2021-06-07 04:22:51 Orel Oblast, Russia
825817 825817 2021-06-06 Russia Orenburg Oblast     44669 1005 41168 2496 52.02692620000001 54.7276647 2021-06-07 04:22:51 Orenburg Oblast, Russia
825818 825818 2021-06-06 Russia Penza Oblast     47709 842 44827 2040 53.1655415 44.78791810000001 2021-06-07 04:22:51 Penza Oblast, Russia
825819 825819 2021-06-06 Russia Perm Krai     58043 2482 52380 3181 58.5951603 56.3159546 2021-06-07 04:22:51 Perm Krai, Russia
825820 825820 2021-06-06 Russia Primorsky Krai     44668 736 41677 2255 45.0819456 134.726645 2021-06-07 04:22:51 Primorsky Krai, Russia
825821 825821 2021-06-06 Russia Pskov Oblast     38021 416 32752 4853 57.5358729 28.8586826 2021-06-07 04:22:51 Pskov Oblast, Russia
825822 825822 2021-06-06 Russia Rostov Oblast     95153 4507 85939 4707 47.6222451 40.7957942 2021-06-07 04:22:51 Rostov Oblast, Russia
825823 825823 2021-06-06 Russia Ryazan Oblast     29567 546 28063 958 54.42267320000001 40.57052460000001 2021-06-07 04:22:51 Ryazan Oblast, Russia
825824 825824 2021-06-06 Russia Saint Petersburg     444727 14580 411822 18325 59.9606739 30.158655100000004 2021-06-07 04:22:51 Saint Petersburg, Russia
825825 825825 2021-06-06 Russia Sakha (Yakutiya) Republic     39076 693 34867 3516 66.941626 129.642371 2021-06-07 04:22:51 Sakha (Yakutiya) Republic, Russia
825826 825826 2021-06-06 Russia Sakhalin Oblast     23166 53 22661 452 49.7219665 143.448533 2021-06-07 04:22:51 Sakhalin Oblast, Russia
825827 825827 2021-06-06 Russia Samara Oblast     65206 2023 62235 948 53.2128813 50.8914633 2021-06-07 04:22:51 Samara Oblast, Russia
825828 825828 2021-06-06 Russia Saratov Oblast     63392 1130 60254 2008 51.6520555 46.86319520000001 2021-06-07 04:22:51 Saratov Oblast, Russia
825829 825829 2021-06-06 Russia Smolensk Oblast     31518 1043 29703 772 55.03434960000001 33.0192065 2021-06-07 04:22:51 Smolensk Oblast, Russia
825830 825830 2021-06-06 Russia Stavropol Krai     55198 1542 52291 1365 44.86325770000001 43.4406913 2021-06-07 04:22:51 Stavropol Krai, Russia
825831 825831 2021-06-06 Russia Sverdlovsk Oblast     89886 3500 83787 2599 58.6414755 61.8021546 2021-06-07 04:22:51 Sverdlovsk Oblast, Russia
825832 825832 2021-06-06 Russia Tambov Oblast     33189 550 31425 1214 52.9019574 41.3578918 2021-06-07 04:22:51 Tambov Oblast, Russia
825833 825833 2021-06-06 Russia Tatarstan Republic     21666 505 18685 2476 55.7648572 52.43104273 2021-06-07 04:22:51 Tatarstan Republic, Russia
825834 825834 2021-06-06 Russia Tomsk Oblast     33037 440 31846 751 58.6124279 82.04753149999998 2021-06-07 04:22:51 Tomsk Oblast, Russia
825835 825835 2021-06-06 Russia Tula Oblast     40451 2068 37936 447 53.9570701 37.3690909 2021-06-07 04:22:51 Tula Oblast, Russia
825836 825836 2021-06-06 Russia Tver Oblast     42599 1077 39921 1601 57.1134475 35.174442799999994 2021-06-07 04:22:51 Tver Oblast, Russia
825837 825837 2021-06-06 Russia Tyumen Oblast     37098 598 35573 927 58.8206488 70.36588370000001 2021-06-07 04:22:51 Tyumen Oblast, Russia
825838 825838 2021-06-06 Russia Tyva Republic     15990 203 15713 74 51.4017149 93.8582593 2021-06-07 04:22:51 Tyva Republic, Russia
825839 825839 2021-06-06 Russia Udmurt Republic     34362 976 31254 2132 57.1961165 52.69598320000001 2021-06-07 04:22:51 Udmurt Republic, Russia
825840 825840 2021-06-06 Russia Ulyanovsk Oblast     56439 1440 53855 1144 54.1463177 47.2324921 2021-06-07 04:22:51 Ulyanovsk Oblast, Russia
825841 825841 2021-06-06 Russia Vladimir Oblast     33834 1211 31487 1136 56.0503336 40.6561633 2021-06-07 04:22:51 Vladimir Oblast, Russia
825842 825842 2021-06-06 Russia Volgograd Oblast     60331 1358 57557 1416 49.6048339 44.29035820000001 2021-06-07 04:22:51 Volgograd Oblast, Russia
825843 825843 2021-06-06 Russia Vologda Oblast     46372 1109 43202 2061 60.0391461 43.1215213 2021-06-07 04:22:51 Vologda Oblast, Russia
825844 825844 2021-06-06 Russia Voronezh Oblast     85805 3032 81208 1565 50.9800393 40.15065070000001 2021-06-07 04:22:51 Voronezh Oblast, Russia
825845 825845 2021-06-06 Russia Yamalo-Nenets Autonomous Okrug     39231 420 38082 729 67.1471631 74.3415488 2021-06-07 04:22:51 Yamalo-Nenets Autonomous Okrug, Russia
825846 825846 2021-06-06 Russia Yaroslavl Oblast     41531 626 39509 1396 57.77819760000001 39.0021095 2021-06-07 04:22:51 Yaroslavl Oblast, Russia
825847 825847 2021-06-06 Russia Zabaykalsky Krai     43497 679 41804 1014 52.248521 115.956325 2021-06-07 04:22:51 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]);