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 2022-08-05 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
2008878 2008878 2022-08-04 Russia Adygea Republic     49691 1003 0   44.6939006 40.1520421 2022-08-05 04:20:52 Adygea Republic, Russia
2008879 2008879 2022-08-04 Russia Altai Krai     272630 8701 0   52.6932243 82.6931424 2022-08-05 04:20:52 Altai Krai, Russia
2008880 2008880 2022-08-04 Russia Altai Republic     35173 622 0   50.7114101 86.8572186 2022-08-05 04:20:52 Altai Republic, Russia
2008881 2008881 2022-08-04 Russia Amur Oblast     109416 764 0   52.8032368 128.437295 2022-08-05 04:20:52 Amur Oblast, Russia
2008882 2008882 2022-08-04 Russia Arkhangelsk Oblast     233904 1767 0   63.5589686 43.1221646 2022-08-05 04:20:52 Arkhangelsk Oblast, Russia
2008883 2008883 2022-08-04 Russia Astrakhan Oblast     120407 3027 0   47.1878186 47.608851 2022-08-05 04:20:52 Astrakhan Oblast, Russia
2008884 2008884 2022-08-04 Russia Bashkortostan Republic     292419 5777 0   54.8573563 57.1439682 2022-08-05 04:20:52 Bashkortostan Republic, Russia
2008885 2008885 2022-08-04 Russia Belgorod Oblast     132502 2282 0   50.7080119 37.5837615 2022-08-05 04:20:52 Belgorod Oblast, Russia
2008886 2008886 2022-08-04 Russia Bryansk Oblast     163768 4046 0   52.8873315 33.415853 2022-08-05 04:20:52 Bryansk Oblast, Russia
2008887 2008887 2022-08-04 Russia Buryatia Republic     138109 3037 0   52.7182426 109.492143 2022-08-05 04:20:52 Buryatia Republic, Russia
2008888 2008888 2022-08-04 Russia Chechen Republic     44673 1076 0   43.3976147 45.6985005 2022-08-05 04:20:52 Chechen Republic, Russia
2008889 2008889 2022-08-04 Russia Chelyabinsk Oblast     337779 7831 0   54.4223954 61.1865846 2022-08-05 04:20:52 Chelyabinsk Oblast, Russia
2008890 2008890 2022-08-04 Russia Chukotka Autonomous Okrug     5829 42 0   66.0006475 169.4900869 2022-08-05 04:20:52 Chukotka Autonomous Okrug, Russia
2008891 2008891 2022-08-04 Russia Chuvashia Republic     82432 4654 0   55.4259922 47.0849429 2022-08-05 04:20:52 Chuvashia Republic, Russia
2008892 2008892 2022-08-04 Russia Dagestan Republic     93738 3594 0   43.0574916 47.1332224 2022-08-05 04:20:52 Dagestan Republic, Russia
2008893 2008893 2022-08-04 Russia Ingushetia Republic     41237 550 0   43.11542075 45.01713552 2022-08-05 04:20:52 Ingushetia Republic, Russia
2008894 2008894 2022-08-04 Russia Irkutsk Oblast     299242 8503 0   56.6370122 104.719221 2022-08-05 04:20:52 Irkutsk Oblast, Russia
2008895 2008895 2022-08-04 Russia Ivanovo Oblast     113286 3145 0   56.9167446 41.4352137 2022-08-05 04:20:52 Ivanovo Oblast, Russia
2008896 2008896 2022-08-04 Russia Jewish Autonomous Okrug     19321 555 0   48.57527615 132.6630746 2022-08-05 04:20:52 Jewish Autonomous Okrug, Russia
2008897 2008897 2022-08-04 Russia Kabardino-Balkarian Republic     62626 1886 0   43.4806048 43.5978976 2022-08-05 04:20:52 Kabardino-Balkarian Republic, Russia
2008898 2008898 2022-08-04 Russia Kaliningrad Oblast     171122 1935 0   54.7293041 21.1489473 2022-08-05 04:20:52 Kaliningrad Oblast, Russia
2008899 2008899 2022-08-04 Russia Kalmykia Republic     52560 843 0   46.2313018 45.3275745 2022-08-05 04:20:52 Kalmykia Republic, Russia
2008900 2008900 2022-08-04 Russia Kaluga Oblast     105654 1453 0   54.4382773 35.5272854 2022-08-05 04:20:52 Kaluga Oblast, Russia
2008901 2008901 2022-08-04 Russia Kamchatka Krai     40520 617 0   57.1914882 160.0383819 2022-08-05 04:20:52 Kamchatka Krai, Russia
2008902 2008902 2022-08-04 Russia Karachay-Cherkess Republic     46243 984 0   43.7368326 41.7267991 2022-08-05 04:20:52 Karachay-Cherkess Republic, Russia
2008903 2008903 2022-08-04 Russia Karelia Republic     138732 1521 0   62.6194031 33.4920267 2022-08-05 04:20:52 Karelia Republic, Russia
2008904 2008904 2022-08-04 Russia Kemerovo Oblast     168075 2526 0   54.5335781 87.342861 2022-08-05 04:20:52 Kemerovo Oblast, Russia
2008905 2008905 2022-08-04 Russia Khabarovsk Krai     204296 1560 0   51.6312684 136.121524 2022-08-05 04:20:52 Khabarovsk Krai, Russia
2008906 2008906 2022-08-04 Russia Khakassia Republic     88598 2415 0   53.72258845 91.44293627 2022-08-05 04:20:52 Khakassia Republic, Russia
2008907 2008907 2022-08-04 Russia Khanty-Mansi Autonomous Okrug     212891 2558 0   61.0259025 69.0982628 2022-08-05 04:20:52 Khanty-Mansi Autonomous Okrug, Russia
2008908 2008908 2022-08-04 Russia Kirov Oblast     153052 1053 0   57.9665589 49.4074599 2022-08-05 04:20:52 Kirov Oblast, Russia
2008909 2008909 2022-08-04 Russia Komi Republic     173453 3202 0   63.9881421 54.3326073 2022-08-05 04:20:52 Komi Republic, Russia
2008910 2008910 2022-08-04 Russia Kostroma Oblast     89734 1409 0   58.424756 44.2533273 2022-08-05 04:20:52 Kostroma Oblast, Russia
2008911 2008911 2022-08-04 Russia Krasnodar Krai     266954 10981 0   45.7684014 39.0261044 2022-08-05 04:20:52 Krasnodar Krai, Russia
2008912 2008912 2022-08-04 Russia Krasnoyarsk Krai     369055 10916 0   63.3233807 97.0979974 2022-08-05 04:20:52 Krasnoyarsk Krai, Russia
2008913 2008913 2022-08-04 Russia Kurgan Oblast     105725 1444 0   55.7655302 64.5632681 2022-08-05 04:20:52 Kurgan Oblast, Russia
2008914 2008914 2022-08-04 Russia Kursk Oblast     120667 2499 0   51.6568453 36.4852695 2022-08-05 04:20:52 Kursk Oblast, Russia
2008915 2008915 2022-08-04 Russia Leningrad Oblast     192406 3493 0   60.1853296 32.3925325 2022-08-05 04:20:52 Leningrad Oblast, Russia
2008916 2008916 2022-08-04 Russia Lipetsk Oblast     154069 3810 0   52.6935178 39.1122664 2022-08-05 04:20:52 Lipetsk Oblast, Russia
2008917 2008917 2022-08-04 Russia Magadan Oblast     19907 390 0   62.48858785 153.9903764 2022-08-05 04:20:52 Magadan Oblast, Russia
2008918 2008918 2022-08-04 Russia Mari El Republic     44995 1087 0   56.5767504 47.8817512 2022-08-05 04:20:52 Mari El Republic, Russia
2008919 2008919 2022-08-04 Russia Mordovia Republic     69288 1393 0   54.4419829 44.4661144 2022-08-05 04:20:52 Mordovia Republic, Russia
2008920 2008920 2022-08-04 Russia Moscow     2840437 44514 0   55.7504461 37.6174943 2022-08-05 04:20:52 Moscow, Russia
2008921 2008921 2022-08-04 Russia Moscow Oblast     999771 15211 0   55.5043158 38.0353929 2022-08-05 04:20:52 Moscow Oblast, Russia
2008922 2008922 2022-08-04 Russia Murmansk Oblast     135324 3339 0   68.0000418 33.9999151 2022-08-05 04:20:52 Murmansk Oblast, Russia
2008923 2008923 2022-08-04 Russia Nenets Autonomous Okrug     7427 101 0   68.27557185 57.1686375 2022-08-05 04:20:52 Nenets Autonomous Okrug, Russia
2008924 2008924 2022-08-04 Russia Nizhny Novgorod Oblast     427006 11602 0   55.4718033 44.0911594 2022-08-05 04:20:52 Nizhny Novgorod Oblast, Russia
2008925 2008925 2022-08-04 Russia North Ossetia - Alania Republic     41198 1255 0   42.7933611 44.6324493 2022-08-05 04:20:52 North Ossetia - Alania Republic, Russia
2008926 2008926 2022-08-04 Russia Novgorod Oblast     101728 1036 0   58.2843833 32.5169757 2022-08-05 04:20:52 Novgorod Oblast, Russia
2008927 2008927 2022-08-04 Russia Novosibirsk Oblast     262115 5699 0   54.9720169 79.4813924 2022-08-05 04:20:52 Novosibirsk Oblast, Russia
2008928 2008928 2022-08-04 Russia Omsk Oblast     210910 4434 0   56.0935263 73.5099936 2022-08-05 04:20:52 Omsk Oblast, Russia
2008929 2008929 2022-08-04 Russia Orel Oblast     114912 1934 0   52.9685433 36.0692477 2022-08-05 04:20:52 Orel Oblast, Russia
2008930 2008930 2022-08-04 Russia Orenburg Oblast     218560 4026 0   52.0269262 54.7276647 2022-08-05 04:20:52 Orenburg Oblast, Russia
2008931 2008931 2022-08-04 Russia Penza Oblast     189361 5998 0   53.1655415 44.7879181 2022-08-05 04:20:52 Penza Oblast, Russia
2008932 2008932 2022-08-04 Russia Perm Krai     374378 8852 0   58.5951603 56.3159546 2022-08-05 04:20:52 Perm Krai, Russia
2008933 2008933 2022-08-04 Russia Primorsky Krai     178156 1966 0   45.0819456 134.726645 2022-08-05 04:20:52 Primorsky Krai, Russia
2008934 2008934 2022-08-04 Russia Pskov Oblast     112144 1883 0   57.5358729 28.8586826 2022-08-05 04:20:52 Pskov Oblast, Russia
2008935 2008935 2022-08-04 Russia Rostov Oblast     383589 10969 0   47.6222451 40.7957942 2022-08-05 04:20:52 Rostov Oblast, Russia
2008936 2008936 2022-08-04 Russia Ryazan Oblast     124083 3416 0   54.4226732 40.5705246 2022-08-05 04:20:52 Ryazan Oblast, Russia
2008937 2008937 2022-08-04 Russia Saint Petersburg     1560703 34361 0   59.9606739 30.1586551 2022-08-05 04:20:52 Saint Petersburg, Russia
2008938 2008938 2022-08-04 Russia Sakha (Yakutiya) Republic     183501 2122 0   66.941626 129.642371 2022-08-05 04:20:52 Sakha (Yakutiya) Republic, Russia
2008939 2008939 2022-08-04 Russia Sakhalin Oblast     65257 828 0   49.7219665 143.448533 2022-08-05 04:20:52 Sakhalin Oblast, Russia
2008940 2008940 2022-08-04 Russia Samara Oblast     388824 7934 0   53.2128813 50.8914633 2022-08-05 04:20:52 Samara Oblast, Russia
2008941 2008941 2022-08-04 Russia Saratov Oblast     257126 6001 0   51.6520555 46.8631952 2022-08-05 04:20:52 Saratov Oblast, Russia
2008942 2008942 2022-08-04 Russia Smolensk Oblast     132606 3090 0   55.0343496 33.0192065 2022-08-05 04:20:52 Smolensk Oblast, Russia
2008943 2008943 2022-08-04 Russia Stavropol Krai     201816 7093 0   44.8632577 43.4406913 2022-08-05 04:20:52 Stavropol Krai, Russia
2008944 2008944 2022-08-04 Russia Sverdlovsk Oblast     452308 10781 0   58.6414755 61.8021546 2022-08-05 04:20:52 Sverdlovsk Oblast, Russia
2008945 2008945 2022-08-04 Russia Tambov Oblast     117973 2450 0   52.9019574 41.3578918 2022-08-05 04:20:52 Tambov Oblast, Russia
2008946 2008946 2022-08-04 Russia Tatarstan Republic     154043 1996 0   55.7648572 52.43104273 2022-08-05 04:20:52 Tatarstan Republic, Russia
2008947 2008947 2022-08-04 Russia Tomsk Oblast     133647 871 0   58.6124279 82.0475315 2022-08-05 04:20:52 Tomsk Oblast, Russia
2008948 2008948 2022-08-04 Russia Tula Oblast     160446 5255 0   53.9570701 37.3690909 2022-08-05 04:20:52 Tula Oblast, Russia
2008949 2008949 2022-08-04 Russia Tver Oblast     164491 2757 0   57.1134475 35.1744428 2022-08-05 04:20:52 Tver Oblast, Russia
2008950 2008950 2022-08-04 Russia Tyumen Oblast     194197 4340 0   58.8206488 70.3658837 2022-08-05 04:20:52 Tyumen Oblast, Russia
2008951 2008951 2022-08-04 Russia Tyva Republic     44618 353 0   51.4017149 93.8582593 2022-08-05 04:20:52 Tyva Republic, Russia
2008952 2008952 2022-08-04 Russia Udmurt Republic     168355 3848 0   57.1961165 52.6959832 2022-08-05 04:20:52 Udmurt Republic, Russia
2008953 2008953 2022-08-04 Russia Ulyanovsk Oblast     204556 4725 0   54.1463177 47.2324921 2022-08-05 04:20:52 Ulyanovsk Oblast, Russia
2008954 2008954 2022-08-04 Russia Vladimir Oblast     153012 3500 0   56.0503336 40.6561633 2022-08-05 04:20:52 Vladimir Oblast, Russia
2008955 2008955 2022-08-04 Russia Volgograd Oblast     227938 6897 0   49.6048339 44.2903582 2022-08-05 04:20:52 Volgograd Oblast, Russia
2008956 2008956 2022-08-04 Russia Vologda Oblast     193652 3878 0   60.0391461 43.1215213 2022-08-05 04:20:52 Vologda Oblast, Russia
2008957 2008957 2022-08-04 Russia Voronezh Oblast     393148 8361 0   50.9800393 40.1506507 2022-08-05 04:20:52 Voronezh Oblast, Russia
2008958 2008958 2022-08-04 Russia Yamalo-Nenets Autonomous Okrug     137923 1043 0   67.1471631 74.3415488 2022-08-05 04:20:52 Yamalo-Nenets Autonomous Okrug, Russia
2008959 2008959 2022-08-04 Russia Yaroslavl Oblast     164982 2830 0   57.7781976 39.0021095 2022-08-05 04:20:52 Yaroslavl Oblast, Russia
2008960 2008960 2022-08-04 Russia Zabaykalsky Krai     169879 2349 0   52.248521 115.956325 2022-08-05 04:20:52 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]);