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-06-15 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
947036 947036 2022-06-14 Russia Adygea Republic     49456 1002 0   44.6939006 40.1520421 2022-06-15 04:20:54 Adygea Republic, Russia
947037 947037 2022-06-14 Russia Altai Krai     269614 8663 0   52.6932243 82.6931424 2022-06-15 04:20:54 Altai Krai, Russia
947038 947038 2022-06-14 Russia Altai Republic     34512 618 0   50.7114101 86.8572186 2022-06-15 04:20:54 Altai Republic, Russia
947039 947039 2022-06-14 Russia Amur Oblast     108412 764 0   52.8032368 128.437295 2022-06-15 04:20:54 Amur Oblast, Russia
947040 947040 2022-06-14 Russia Arkhangelsk Oblast     230997 1763 0   63.5589686 43.1221646 2022-06-15 04:20:54 Arkhangelsk Oblast, Russia
947041 947041 2022-06-14 Russia Astrakhan Oblast     117540 3010 0   47.1878186 47.608851 2022-06-15 04:20:54 Astrakhan Oblast, Russia
947042 947042 2022-06-14 Russia Bashkortostan Republic     289609 5715 0   54.8573563 57.1439682 2022-06-15 04:20:54 Bashkortostan Republic, Russia
947043 947043 2022-06-14 Russia Belgorod Oblast     131348 2273 0   50.7080119 37.5837615 2022-06-15 04:20:54 Belgorod Oblast, Russia
947044 947044 2022-06-14 Russia Bryansk Oblast     162132 4034 0   52.8873315 33.415853 2022-06-15 04:20:54 Bryansk Oblast, Russia
947045 947045 2022-06-14 Russia Buryatia Republic     136964 3033 0   52.7182426 109.492143 2022-06-15 04:20:54 Buryatia Republic, Russia
947046 947046 2022-06-14 Russia Chechen Republic     43952 1076 0   43.3976147 45.6985005 2022-06-15 04:20:54 Chechen Republic, Russia
947047 947047 2022-06-14 Russia Chelyabinsk Oblast     331968 7725 0   54.4223954 61.1865846 2022-06-15 04:20:54 Chelyabinsk Oblast, Russia
947048 947048 2022-06-14 Russia Chukotka Autonomous Okrug     5711 42 0   66.0006475 169.4900869 2022-06-15 04:20:54 Chukotka Autonomous Okrug, Russia
947049 947049 2022-06-14 Russia Chuvashia Republic     80512 4646 0   55.4259922 47.0849429 2022-06-15 04:20:54 Chuvashia Republic, Russia
947050 947050 2022-06-14 Russia Dagestan Republic     93346 3594 0   43.0574916 47.1332224 2022-06-15 04:20:54 Dagestan Republic, Russia
947051 947051 2022-06-14 Russia Ingushetia Republic     41019 550 0   43.11542075 45.01713552 2022-06-15 04:20:54 Ingushetia Republic, Russia
947052 947052 2022-06-14 Russia Irkutsk Oblast     294879 8475 0   56.6370122 104.719221 2022-06-15 04:20:54 Irkutsk Oblast, Russia
947053 947053 2022-06-14 Russia Ivanovo Oblast     112026 3128 0   56.9167446 41.4352137 2022-06-15 04:20:54 Ivanovo Oblast, Russia
947054 947054 2022-06-14 Russia Jewish Autonomous Okrug     18907 552 0   48.57527615 132.6630746 2022-06-15 04:20:54 Jewish Autonomous Okrug, Russia
947055 947055 2022-06-14 Russia Kabardino-Balkarian Republic     62027 1881 0   43.4806048 43.5978976 2022-06-15 04:20:54 Kabardino-Balkarian Republic, Russia
947056 947056 2022-06-14 Russia Kaliningrad Oblast     169119 1921 0   54.7293041 21.1489473 2022-06-15 04:20:54 Kaliningrad Oblast, Russia
947057 947057 2022-06-14 Russia Kalmykia Republic     51680 843 0   46.2313018 45.3275745 2022-06-15 04:20:54 Kalmykia Republic, Russia
947058 947058 2022-06-14 Russia Kaluga Oblast     104293 1453 0   54.4382773 35.5272854 2022-06-15 04:20:54 Kaluga Oblast, Russia
947059 947059 2022-06-14 Russia Kamchatka Krai     40057 616 0   57.1914882 160.0383819 2022-06-15 04:20:54 Kamchatka Krai, Russia
947060 947060 2022-06-14 Russia Karachay-Cherkess Republic     46057 984 0   43.7368326 41.7267991 2022-06-15 04:20:54 Karachay-Cherkess Republic, Russia
947061 947061 2022-06-14 Russia Karelia Republic     136495 1513 0   62.6194031 33.4920267 2022-06-15 04:20:54 Karelia Republic, Russia
947062 947062 2022-06-14 Russia Kemerovo Oblast     165242 2427 0   54.5335781 87.342861 2022-06-15 04:20:54 Kemerovo Oblast, Russia
947063 947063 2022-06-14 Russia Khabarovsk Krai     203383 1558 0   51.6312684 136.121524 2022-06-15 04:20:54 Khabarovsk Krai, Russia
947064 947064 2022-06-14 Russia Khakassia Republic     88034 2411 0   53.72258845 91.44293627 2022-06-15 04:20:54 Khakassia Republic, Russia
947065 947065 2022-06-14 Russia Khanty-Mansi Autonomous Okrug     211015 2553 0   61.0259025 69.0982628 2022-06-15 04:20:54 Khanty-Mansi Autonomous Okrug, Russia
947066 947066 2022-06-14 Russia Kirov Oblast     151920 1048 0   57.9665589 49.4074599 2022-06-15 04:20:54 Kirov Oblast, Russia
947067 947067 2022-06-14 Russia Komi Republic     172363 3192 0   63.9881421 54.3326073 2022-06-15 04:20:54 Komi Republic, Russia
947068 947068 2022-06-14 Russia Kostroma Oblast     89257 1395 0   58.424756 44.2533273 2022-06-15 04:20:54 Kostroma Oblast, Russia
947069 947069 2022-06-14 Russia Krasnodar Krai     261949 10945 0   45.7684014 39.0261044 2022-06-15 04:20:54 Krasnodar Krai, Russia
947070 947070 2022-06-14 Russia Krasnoyarsk Krai     366468 10856 0   63.3233807 97.0979974 2022-06-15 04:20:54 Krasnoyarsk Krai, Russia
947071 947071 2022-06-14 Russia Kurgan Oblast     104858 1438 0   55.7655302 64.5632681 2022-06-15 04:20:54 Kurgan Oblast, Russia
947072 947072 2022-06-14 Russia Kursk Oblast     118774 2485 0   51.6568453 36.4852695 2022-06-15 04:20:54 Kursk Oblast, Russia
947073 947073 2022-06-14 Russia Leningrad Oblast     188321 3489 0   60.1853296 32.3925325 2022-06-15 04:20:54 Leningrad Oblast, Russia
947074 947074 2022-06-14 Russia Lipetsk Oblast     152078 3779 0   52.6935178 39.1122664 2022-06-15 04:20:54 Lipetsk Oblast, Russia
947075 947075 2022-06-14 Russia Magadan Oblast     19823 390 0   62.48858785 153.9903764 2022-06-15 04:20:54 Magadan Oblast, Russia
947076 947076 2022-06-14 Russia Mari El Republic     44659 1087 0   56.5767504 47.8817512 2022-06-15 04:20:54 Mari El Republic, Russia
947077 947077 2022-06-14 Russia Mordovia Republic     68432 1389 0   54.4419829 44.4661144 2022-06-15 04:20:54 Mordovia Republic, Russia
947078 947078 2022-06-14 Russia Moscow     2773862 43921 0   55.7504461 37.6174943 2022-06-15 04:20:54 Moscow, Russia
947079 947079 2022-06-14 Russia Moscow Oblast     978347 15100 0   55.5043158 38.0353929 2022-06-15 04:20:54 Moscow Oblast, Russia
947080 947080 2022-06-14 Russia Murmansk Oblast     134809 3328 0   68.0000418 33.9999151 2022-06-15 04:20:54 Murmansk Oblast, Russia
947081 947081 2022-06-14 Russia Nenets Autonomous Okrug     7385 101 0   68.27557185 57.1686375 2022-06-15 04:20:54 Nenets Autonomous Okrug, Russia
947082 947082 2022-06-14 Russia Nizhny Novgorod Oblast     422561 11547 0   55.4718033 44.0911594 2022-06-15 04:20:54 Nizhny Novgorod Oblast, Russia
947083 947083 2022-06-14 Russia North Ossetia - Alania Republic     40926 1252 0   42.7933611 44.6324493 2022-06-15 04:20:54 North Ossetia - Alania Republic, Russia
947084 947084 2022-06-14 Russia Novgorod Oblast     100206 1035 0   58.2843833 32.5169757 2022-06-15 04:20:54 Novgorod Oblast, Russia
947085 947085 2022-06-14 Russia Novosibirsk Oblast     259303 5679 0   54.9720169 79.4813924 2022-06-15 04:20:54 Novosibirsk Oblast, Russia
947086 947086 2022-06-14 Russia Omsk Oblast     208150 4403 0   56.0935263 73.5099936 2022-06-15 04:20:54 Omsk Oblast, Russia
947087 947087 2022-06-14 Russia Orel Oblast     113459 1926 0   52.9685433 36.0692477 2022-06-15 04:20:54 Orel Oblast, Russia
947088 947088 2022-06-14 Russia Orenburg Oblast     216941 4021 0   52.0269262 54.7276647 2022-06-15 04:20:54 Orenburg Oblast, Russia
947089 947089 2022-06-14 Russia Penza Oblast     187367 5933 0   53.1655415 44.7879181 2022-06-15 04:20:54 Penza Oblast, Russia
947090 947090 2022-06-14 Russia Perm Krai     370780 8827 0   58.5951603 56.3159546 2022-06-15 04:20:54 Perm Krai, Russia
947091 947091 2022-06-14 Russia Primorsky Krai     175471 1966 0   45.0819456 134.726645 2022-06-15 04:20:54 Primorsky Krai, Russia
947092 947092 2022-06-14 Russia Pskov Oblast     110953 1853 0   57.5358729 28.8586826 2022-06-15 04:20:54 Pskov Oblast, Russia
947093 947093 2022-06-14 Russia Rostov Oblast     377835 10949 0   47.6222451 40.7957942 2022-06-15 04:20:54 Rostov Oblast, Russia
947094 947094 2022-06-14 Russia Ryazan Oblast     121858 3395 0   54.4226732 40.5705246 2022-06-15 04:20:54 Ryazan Oblast, Russia
947095 947095 2022-06-14 Russia Saint Petersburg     1532867 33986 0   59.9606739 30.1586551 2022-06-15 04:20:54 Saint Petersburg, Russia
947096 947096 2022-06-14 Russia Sakha (Yakutiya) Republic     180810 2117 0   66.941626 129.642371 2022-06-15 04:20:54 Sakha (Yakutiya) Republic, Russia
947097 947097 2022-06-14 Russia Sakhalin Oblast     64918 826 0   49.7219665 143.448533 2022-06-15 04:20:54 Sakhalin Oblast, Russia
947098 947098 2022-06-14 Russia Samara Oblast     385063 7885 0   53.2128813 50.8914633 2022-06-15 04:20:54 Samara Oblast, Russia
947099 947099 2022-06-14 Russia Saratov Oblast     253811 5983 0   51.6520555 46.8631952 2022-06-15 04:20:54 Saratov Oblast, Russia
947100 947100 2022-06-14 Russia Smolensk Oblast     131547 3065 0   55.0343496 33.0192065 2022-06-15 04:20:54 Smolensk Oblast, Russia
947101 947101 2022-06-14 Russia Stavropol Krai     198652 7074 0   44.8632577 43.4406913 2022-06-15 04:20:54 Stavropol Krai, Russia
947102 947102 2022-06-14 Russia Sverdlovsk Oblast     446078 10752 0   58.6414755 61.8021546 2022-06-15 04:20:54 Sverdlovsk Oblast, Russia
947103 947103 2022-06-14 Russia Tambov Oblast     117267 2429 0   52.9019574 41.3578918 2022-06-15 04:20:54 Tambov Oblast, Russia
947104 947104 2022-06-14 Russia Tatarstan Republic     151554 1995 0   55.7648572 52.43104273 2022-06-15 04:20:54 Tatarstan Republic, Russia
947105 947105 2022-06-14 Russia Tomsk Oblast     132034 851 0   58.6124279 82.0475315 2022-06-15 04:20:54 Tomsk Oblast, Russia
947106 947106 2022-06-14 Russia Tula Oblast     157398 5216 0   53.9570701 37.3690909 2022-06-15 04:20:54 Tula Oblast, Russia
947107 947107 2022-06-14 Russia Tver Oblast     163027 2745 0   57.1134475 35.1744428 2022-06-15 04:20:54 Tver Oblast, Russia
947108 947108 2022-06-14 Russia Tyumen Oblast     191872 4330 0   58.8206488 70.3658837 2022-06-15 04:20:54 Tyumen Oblast, Russia
947109 947109 2022-06-14 Russia Tyva Republic     44487 353 0   51.4017149 93.8582593 2022-06-15 04:20:54 Tyva Republic, Russia
947110 947110 2022-06-14 Russia Udmurt Republic     167194 3846 0   57.1961165 52.6959832 2022-06-15 04:20:54 Udmurt Republic, Russia
947111 947111 2022-06-14 Russia Ulyanovsk Oblast     203372 4710 0   54.1463177 47.2324921 2022-06-15 04:20:54 Ulyanovsk Oblast, Russia
947112 947112 2022-06-14 Russia Vladimir Oblast     152057 3474 0   56.0503336 40.6561633 2022-06-15 04:20:54 Vladimir Oblast, Russia
947113 947113 2022-06-14 Russia Volgograd Oblast     223275 6886 0   49.6048339 44.2903582 2022-06-15 04:20:54 Volgograd Oblast, Russia
947114 947114 2022-06-14 Russia Vologda Oblast     191813 3859 0   60.0391461 43.1215213 2022-06-15 04:20:54 Vologda Oblast, Russia
947115 947115 2022-06-14 Russia Voronezh Oblast     386738 8319 0   50.9800393 40.1506507 2022-06-15 04:20:54 Voronezh Oblast, Russia
947116 947116 2022-06-14 Russia Yamalo-Nenets Autonomous Okrug     137172 1042 0   67.1471631 74.3415488 2022-06-15 04:20:54 Yamalo-Nenets Autonomous Okrug, Russia
947117 947117 2022-06-14 Russia Yaroslavl Oblast     162451 2810 0   57.7781976 39.0021095 2022-06-15 04:20:54 Yaroslavl Oblast, Russia
947118 947118 2022-06-14 Russia Zabaykalsky Krai     169111 2347 0   52.248521 115.956325 2022-06-15 04:20:54 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]);