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-07-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
2693872 2693872 2021-07-06 Russia Adygea Republic     15196 255 14511 430 44.6939006 40.1520421 2021-07-07 04:21:20 Adygea Republic, Russia
2693873 2693873 2021-07-06 Russia Altai Krai     55575 2513 47369 5693 52.6932243 82.69314240000001 2021-07-07 04:21:20 Altai Krai, Russia
2693874 2693874 2021-07-06 Russia Altai Republic     18086 256 17150 680 50.7114101 86.8572186 2021-07-07 04:21:20 Altai Republic, Russia
2693875 2693875 2021-07-06 Russia Amur Oblast     24651 309 23491 851 52.8032368 128.437295 2021-07-07 04:21:20 Amur Oblast, Russia
2693876 2693876 2021-07-06 Russia Arkhangelsk Oblast     68463 1051 65325 2087 63.5589686 43.1221646 2021-07-07 04:21:20 Arkhangelsk Oblast, Russia
2693877 2693877 2021-07-06 Russia Astrakhan Oblast     37117 884 34632 1601 47.1878186 47.608851 2021-07-07 04:21:20 Astrakhan Oblast, Russia
2693878 2693878 2021-07-06 Russia Bashkortostan Republic     42352 623 39453 2276 54.8573563 57.1439682 2021-07-07 04:21:20 Bashkortostan Republic, Russia
2693879 2693879 2021-07-06 Russia Belgorod Oblast     41349 775 39277 1297 50.7080119 37.5837615 2021-07-07 04:21:20 Belgorod Oblast, Russia
2693880 2693880 2021-07-06 Russia Bryansk Oblast     46441 578 43214 2649 52.8873315 33.41585300000001 2021-07-07 04:21:20 Bryansk Oblast, Russia
2693881 2693881 2021-07-06 Russia Buryatia Republic     46216 1363 42029 2824 52.7182426 109.492143 2021-07-07 04:21:20 Buryatia Republic, Russia
2693882 2693882 2021-07-06 Russia Chechen Republic     13150 171 12430 549 43.39761470000001 45.6985005 2021-07-07 04:21:20 Chechen Republic, Russia
2693883 2693883 2021-07-06 Russia Chelyabinsk Oblast     66193 1832 61857 2504 54.4223954 61.1865846 2021-07-07 04:21:20 Chelyabinsk Oblast, Russia
2693884 2693884 2021-07-06 Russia Chukotka Autonomous Okrug     856 8 765 83 66.0006475 169.4900869 2021-07-07 04:21:20 Chukotka Autonomous Okrug, Russia
2693885 2693885 2021-07-06 Russia Chuvashia Republic     27645 1582 25267 796 55.4259922 47.0849429 2021-07-07 04:21:20 Chuvashia Republic, Russia
2693886 2693886 2021-07-06 Russia Dagestan Republic     36814 1563 33256 1995 43.05749160000001 47.1332224 2021-07-07 04:21:20 Dagestan Republic, Russia
2693887 2693887 2021-07-06 Russia Ingushetia Republic     16365 197 15744 424 43.11542075 45.01713552 2021-07-07 04:21:20 Ingushetia Republic, Russia
2693888 2693888 2021-07-06 Russia Irkutsk Oblast     75853 2903 69401 3549 56.6370122 104.719221 2021-07-07 04:21:20 Irkutsk Oblast, Russia
2693889 2693889 2021-07-06 Russia Ivanovo Oblast     38729 1311 36256 1162 56.9167446 41.43521370000001 2021-07-07 04:21:20 Ivanovo Oblast, Russia
2693890 2693890 2021-07-06 Russia Jewish Autonomous Okrug     4861 153 4394 314 48.57527615 132.66307460000002 2021-07-07 04:21:20 Jewish Autonomous Okrug, Russia
2693891 2693891 2021-07-06 Russia Kabardino-Balkarian Republic     25178 508 24029 641 43.4806048 43.5978976 2021-07-07 04:21:20 Kabardino-Balkarian Republic, Russia
2693892 2693892 2021-07-06 Russia Kaliningrad Oblast     37490 550 35912 1028 54.7293041 21.1489473 2021-07-07 04:21:20 Kaliningrad Oblast, Russia
2693893 2693893 2021-07-06 Russia Kalmykia Republic     22092 421 20872 799 46.2313018 45.3275745 2021-07-07 04:21:20 Kalmykia Republic, Russia
2693894 2693894 2021-07-06 Russia Kaluga Oblast     37947 390 36172 1385 54.4382773 35.5272854 2021-07-07 04:21:20 Kaluga Oblast, Russia
2693895 2693895 2021-07-06 Russia Kamchatka Krai     15541 238 14200 1103 57.1914882 160.03838190000005 2021-07-07 04:21:20 Kamchatka Krai, Russia
2693896 2693896 2021-07-06 Russia Karachay-Cherkess Republic     21065 193 20400 472 43.7368326 41.7267991 2021-07-07 04:21:20 Karachay-Cherkess Republic, Russia
2693897 2693897 2021-07-06 Russia Karelia Republic     51176 646 48166 2364 62.61940309999999 33.4920267 2021-07-07 04:21:20 Karelia Republic, Russia
2693898 2693898 2021-07-06 Russia Kemerovo Oblast     40962 848 38637 1477 54.53357809999999 87.342861 2021-07-07 04:21:20 Kemerovo Oblast, Russia
2693899 2693899 2021-07-06 Russia Khabarovsk Krai     57303 507 53271 3525 51.6312684 136.121524 2021-07-07 04:21:20 Khabarovsk Krai, Russia
2693900 2693900 2021-07-06 Russia Khakassia Republic     25925 612 23903 1410 53.72258845 91.44293627 2021-07-07 04:21:20 Khakassia Republic, Russia
2693901 2693901 2021-07-06 Russia Khanty-Mansi Autonomous Okrug     60738 822 58285 1631 61.0259025 69.0982628 2021-07-07 04:21:20 Khanty-Mansi Autonomous Okrug, Russia
2693902 2693902 2021-07-06 Russia Kirov Oblast     47441 397 44807 2237 57.9665589 49.4074599 2021-07-07 04:21:20 Kirov Oblast, Russia
2693903 2693903 2021-07-06 Russia Komi Republic     48126 1047 45051 2028 63.9881421 54.3326073 2021-07-07 04:21:20 Komi Republic, Russia
2693904 2693904 2021-07-06 Russia Kostroma Oblast     23881 532 20227 3122 58.424756 44.2533273 2021-07-07 04:21:20 Kostroma Oblast, Russia
2693905 2693905 2021-07-06 Russia Krasnodar Krai     53112 3550 45713 3849 45.7684014 39.0261044 2021-07-07 04:21:20 Krasnodar Krai, Russia
2693906 2693906 2021-07-06 Russia Krasnoyarsk Krai     79439 4012 70938 4489 63.3233807 97.0979974 2021-07-07 04:21:20 Krasnoyarsk Krai, Russia
2693907 2693907 2021-07-06 Russia Kurgan Oblast     22842 455 21691 696 55.7655302 64.5632681 2021-07-07 04:21:20 Kurgan Oblast, Russia
2693908 2693908 2021-07-06 Russia Kursk Oblast     41686 959 39845 882 51.6568453 36.4852695 2021-07-07 04:21:20 Kursk Oblast, Russia
2693909 2693909 2021-07-06 Russia Leningrad Oblast     49994 1818 45263 2913 60.1853296 32.3925325 2021-07-07 04:21:20 Leningrad Oblast, Russia
2693910 2693910 2021-07-06 Russia Lipetsk Oblast     34191 933 30544 2714 52.6935178 39.1122664 2021-07-07 04:21:20 Lipetsk Oblast, Russia
2693911 2693911 2021-07-06 Russia Magadan Oblast     8821 117 8449 255 62.48858785 153.9903764 2021-07-07 04:21:20 Magadan Oblast, Russia
2693912 2693912 2021-07-06 Russia Mari El Republic     14623 311 13918 394 56.5767504 47.8817512 2021-07-07 04:21:20 Mari El Republic, Russia
2693913 2693913 2021-07-06 Russia Mordovia Republic     22293 343 19960 1990 54.4419829 44.4661144 2021-07-07 04:21:20 Mordovia Republic, Russia
2693914 2693914 2021-07-06 Russia Moscow     1399830 23115 1194207 182508 55.7504461 37.6174943 2021-07-07 04:21:20 Moscow, Russia
2693915 2693915 2021-07-06 Russia Moscow Oblast     329791 6629 266389 56773 55.50431579999999 38.0353929 2021-07-07 04:21:20 Moscow Oblast, Russia
2693916 2693916 2021-07-06 Russia Murmansk Oblast     55433 1353 49559 4521 68.00004179999999 33.9999151 2021-07-07 04:21:20 Murmansk Oblast, Russia
2693917 2693917 2021-07-06 Russia Nenets Autonomous Okrug     1255 10 1159 86 68.27557185 57.1686375 2021-07-07 04:21:20 Nenets Autonomous Okrug, Russia
2693918 2693918 2021-07-06 Russia Nizhny Novgorod Oblast     127348 4373 117522 5453 55.47180329999999 44.0911594 2021-07-07 04:21:20 Nizhny Novgorod Oblast, Russia
2693919 2693919 2021-07-06 Russia North Ossetia - Alania Republic     17476 231 16674 571 42.79336110000001 44.6324493 2021-07-07 04:21:20 North Ossetia - Alania Republic, Russia
2693920 2693920 2021-07-06 Russia Novgorod Oblast     32723 187 31732 804 58.2843833 32.5169757 2021-07-07 04:21:20 Novgorod Oblast, Russia
2693921 2693921 2021-07-06 Russia Novosibirsk Oblast     47870 2108 42156 3606 54.9720169 79.48139240000002 2021-07-07 04:21:20 Novosibirsk Oblast, Russia
2693922 2693922 2021-07-06 Russia Omsk Oblast     52479 1525 49447 1507 56.09352629999999 73.5099936 2021-07-07 04:21:20 Omsk Oblast, Russia
2693923 2693923 2021-07-06 Russia Orel Oblast     37983 760 35972 1251 52.96854329999999 36.0692477 2021-07-07 04:21:20 Orel Oblast, Russia
2693924 2693924 2021-07-06 Russia Orenburg Oblast     48912 1134 43428 4350 52.02692620000001 54.7276647 2021-07-07 04:21:20 Orenburg Oblast, Russia
2693925 2693925 2021-07-06 Russia Penza Oblast     50695 1148 45638 3909 53.1655415 44.78791810000001 2021-07-07 04:21:20 Penza Oblast, Russia
2693926 2693926 2021-07-06 Russia Perm Krai     63079 2764 56201 4114 58.5951603 56.3159546 2021-07-07 04:21:20 Perm Krai, Russia
2693927 2693927 2021-07-06 Russia Primorsky Krai     48146 816 43137 4193 45.0819456 134.726645 2021-07-07 04:21:20 Primorsky Krai, Russia
2693928 2693928 2021-07-06 Russia Pskov Oblast     40411 487 33672 6252 57.5358729 28.8586826 2021-07-07 04:21:20 Pskov Oblast, Russia
2693929 2693929 2021-07-06 Russia Rostov Oblast     100884 4720 90893 5271 47.6222451 40.7957942 2021-07-07 04:21:20 Rostov Oblast, Russia
2693930 2693930 2021-07-06 Russia Ryazan Oblast     31752 648 30015 1089 54.42267320000001 40.57052460000001 2021-07-07 04:21:20 Ryazan Oblast, Russia
2693931 2693931 2021-07-06 Russia Saint Petersburg     480149 16975 457742 5432 59.9606739 30.158655100000004 2021-07-07 04:21:20 Saint Petersburg, Russia
2693932 2693932 2021-07-06 Russia Sakha (Yakutiya) Republic     41896 792 38171 2933 66.941626 129.642371 2021-07-07 04:21:20 Sakha (Yakutiya) Republic, Russia
2693933 2693933 2021-07-06 Russia Sakhalin Oblast     25017 73 23814 1130 49.7219665 143.448533 2021-07-07 04:21:20 Sakhalin Oblast, Russia
2693934 2693934 2021-07-06 Russia Samara Oblast     68758 2349 65508 901 53.2128813 50.8914633 2021-07-07 04:21:20 Samara Oblast, Russia
2693935 2693935 2021-07-06 Russia Saratov Oblast     67272 1401 63655 2216 51.6520555 46.86319520000001 2021-07-07 04:21:20 Saratov Oblast, Russia
2693936 2693936 2021-07-06 Russia Smolensk Oblast     36115 1155 32077 2883 55.03434960000001 33.0192065 2021-07-07 04:21:20 Smolensk Oblast, Russia
2693937 2693937 2021-07-06 Russia Stavropol Krai     58163 1712 54287 2164 44.86325770000001 43.4406913 2021-07-07 04:21:20 Stavropol Krai, Russia
2693938 2693938 2021-07-06 Russia Sverdlovsk Oblast     95792 3926 89238 2628 58.6414755 61.8021546 2021-07-07 04:21:20 Sverdlovsk Oblast, Russia
2693939 2693939 2021-07-06 Russia Tambov Oblast     35285 621 33613 1051 52.9019574 41.3578918 2021-07-07 04:21:20 Tambov Oblast, Russia
2693940 2693940 2021-07-06 Russia Tatarstan Republic     22680 552 20329 1799 55.7648572 52.43104273 2021-07-07 04:21:20 Tatarstan Republic, Russia
2693941 2693941 2021-07-06 Russia Tomsk Oblast     34575 481 32754 1340 58.6124279 82.04753149999998 2021-07-07 04:21:20 Tomsk Oblast, Russia
2693942 2693942 2021-07-06 Russia Tula Oblast     43692 2255 39653 1784 53.9570701 37.3690909 2021-07-07 04:21:20 Tula Oblast, Russia
2693943 2693943 2021-07-06 Russia Tver Oblast     47163 1205 41515 4443 57.1134475 35.174442799999994 2021-07-07 04:21:20 Tver Oblast, Russia
2693944 2693944 2021-07-06 Russia Tyumen Oblast     40213 716 38402 1095 58.8206488 70.36588370000001 2021-07-07 04:21:20 Tyumen Oblast, Russia
2693945 2693945 2021-07-06 Russia Tyva Republic     17140 225 16418 497 51.4017149 93.8582593 2021-07-07 04:21:20 Tyva Republic, Russia
2693946 2693946 2021-07-06 Russia Udmurt Republic     36316 1076 32464 2776 57.1961165 52.69598320000001 2021-07-07 04:21:20 Udmurt Republic, Russia
2693947 2693947 2021-07-06 Russia Ulyanovsk Oblast     59688 1733 56917 1038 54.1463177 47.2324921 2021-07-07 04:21:20 Ulyanovsk Oblast, Russia
2693948 2693948 2021-07-06 Russia Vladimir Oblast     37557 1292 34959 1306 56.0503336 40.6561633 2021-07-07 04:21:20 Vladimir Oblast, Russia
2693949 2693949 2021-07-06 Russia Volgograd Oblast     63969 1559 59716 2694 49.6048339 44.29035820000001 2021-07-07 04:21:20 Volgograd Oblast, Russia
2693950 2693950 2021-07-06 Russia Vologda Oblast     49131 1187 44566 3378 60.0391461 43.1215213 2021-07-07 04:21:20 Vologda Oblast, Russia
2693951 2693951 2021-07-06 Russia Voronezh Oblast     92620 3238 87753 1629 50.9800393 40.15065070000001 2021-07-07 04:21:20 Voronezh Oblast, Russia
2693952 2693952 2021-07-06 Russia Yamalo-Nenets Autonomous Okrug     40626 435 38966 1225 67.1471631 74.3415488 2021-07-07 04:21:20 Yamalo-Nenets Autonomous Okrug, Russia
2693953 2693953 2021-07-06 Russia Yaroslavl Oblast     44749 733 41345 2671 57.77819760000001 39.0021095 2021-07-07 04:21:20 Yaroslavl Oblast, Russia
2693954 2693954 2021-07-06 Russia Zabaykalsky Krai     48619 770 44779 3070 52.248521 115.956325 2021-07-07 04:21:20 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]);