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-04-17 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
304054 304054 2022-04-16 Russia Adygea Republic     48871 990 0   44.6939006 40.1520421 2022-04-17 04:20:59 Adygea Republic, Russia
304055 304055 2022-04-16 Russia Altai Krai     264752 8547 0   52.693224300000004 82.69314240000001 2022-04-17 04:20:59 Altai Krai, Russia
304056 304056 2022-04-16 Russia Altai Republic     33996 605 0   50.7114101 86.8572186 2022-04-17 04:20:59 Altai Republic, Russia
304057 304057 2022-04-16 Russia Amur Oblast     105840 761 0   52.8032368 128.437295 2022-04-17 04:20:59 Amur Oblast, Russia
304058 304058 2022-04-16 Russia Arkhangelsk Oblast     227147 1688 0   63.5589686 43.1221646 2022-04-17 04:20:59 Arkhangelsk Oblast, Russia
304059 304059 2022-04-16 Russia Astrakhan Oblast     115566 2978 0   47.1878186 47.608851 2022-04-17 04:20:59 Astrakhan Oblast, Russia
304060 304060 2022-04-16 Russia Bashkortostan Republic     283142 5576 0   54.8573563 57.1439682 2022-04-17 04:20:59 Bashkortostan Republic, Russia
304061 304061 2022-04-16 Russia Belgorod Oblast     128568 2205 0   50.7080119 37.5837615 2022-04-17 04:20:59 Belgorod Oblast, Russia
304062 304062 2022-04-16 Russia Bryansk Oblast     160188 3914 0   52.887331499999995 33.41585300000001 2022-04-17 04:20:59 Bryansk Oblast, Russia
304063 304063 2022-04-16 Russia Buryatia Republic     135423 2989 0   52.718242599999996 109.492143 2022-04-17 04:20:59 Buryatia Republic, Russia
304064 304064 2022-04-16 Russia Chechen Republic     43266 1076 0   43.39761470000001 45.6985005 2022-04-17 04:20:59 Chechen Republic, Russia
304065 304065 2022-04-16 Russia Chelyabinsk Oblast     323499 7530 0   54.4223954 61.1865846 2022-04-17 04:20:59 Chelyabinsk Oblast, Russia
304066 304066 2022-04-16 Russia Chukotka Autonomous Okrug     5593 42 0   66.0006475 169.4900869 2022-04-17 04:20:59 Chukotka Autonomous Okrug, Russia
304067 304067 2022-04-16 Russia Chuvashia Republic     77980 4578 0   55.4259922 47.0849429 2022-04-17 04:20:59 Chuvashia Republic, Russia
304068 304068 2022-04-16 Russia Dagestan Republic     92644 3589 0   43.05749160000001 47.1332224 2022-04-17 04:20:59 Dagestan Republic, Russia
304069 304069 2022-04-16 Russia Ingushetia Republic     40601 549 0   43.11542075 45.01713552 2022-04-17 04:20:59 Ingushetia Republic, Russia
304070 304070 2022-04-16 Russia Irkutsk Oblast     290135 8358 0   56.6370122 104.71922099999999 2022-04-17 04:20:59 Irkutsk Oblast, Russia
304071 304071 2022-04-16 Russia Ivanovo Oblast     109382 3061 0   56.9167446 41.43521370000001 2022-04-17 04:20:59 Ivanovo Oblast, Russia
304072 304072 2022-04-16 Russia Jewish Autonomous Okrug     18371 537 0   48.57527615 132.66307460000002 2022-04-17 04:20:59 Jewish Autonomous Okrug, Russia
304073 304073 2022-04-16 Russia Kabardino-Balkarian Republic     61253 1851 0   43.480604799999995 43.5978976 2022-04-17 04:20:59 Kabardino-Balkarian Republic, Russia
304074 304074 2022-04-16 Russia Kaliningrad Oblast     167169 1846 0   54.7293041 21.1489473 2022-04-17 04:20:59 Kaliningrad Oblast, Russia
304075 304075 2022-04-16 Russia Kalmykia Republic     50740 836 0   46.2313018 45.3275745 2022-04-17 04:20:59 Kalmykia Republic, Russia
304076 304076 2022-04-16 Russia Kaluga Oblast     102368 1442 0   54.438277299999996 35.5272854 2022-04-17 04:20:59 Kaluga Oblast, Russia
304077 304077 2022-04-16 Russia Kamchatka Krai     39372 609 0   57.191488199999995 160.03838190000005 2022-04-17 04:20:59 Kamchatka Krai, Russia
304078 304078 2022-04-16 Russia Karachay-Cherkess Republic     45614 979 0   43.7368326 41.7267991 2022-04-17 04:20:59 Karachay-Cherkess Republic, Russia
304079 304079 2022-04-16 Russia Karelia Republic     132961 1485 0   62.61940309999999 33.4920267 2022-04-17 04:20:59 Karelia Republic, Russia
304080 304080 2022-04-16 Russia Kemerovo Oblast     159889 2280 0   54.53357809999999 87.342861 2022-04-17 04:20:59 Kemerovo Oblast, Russia
304081 304081 2022-04-16 Russia Khabarovsk Krai     199066 1527 0   51.6312684 136.121524 2022-04-17 04:20:59 Khabarovsk Krai, Russia
304082 304082 2022-04-16 Russia Khakassia Republic     87178 2392 0   53.72258845 91.44293627 2022-04-17 04:20:59 Khakassia Republic, Russia
304083 304083 2022-04-16 Russia Khanty-Mansi Autonomous Okrug     208538 2534 0   61.0259025 69.0982628 2022-04-17 04:20:59 Khanty-Mansi Autonomous Okrug, Russia
304084 304084 2022-04-16 Russia Kirov Oblast     150028 998 0   57.9665589 49.4074599 2022-04-17 04:20:59 Kirov Oblast, Russia
304085 304085 2022-04-16 Russia Komi Republic     169935 3097 0   63.9881421 54.3326073 2022-04-17 04:20:59 Komi Republic, Russia
304086 304086 2022-04-16 Russia Kostroma Oblast     87887 1346 0   58.424756 44.253327299999995 2022-04-17 04:20:59 Kostroma Oblast, Russia
304087 304087 2022-04-16 Russia Krasnodar Krai     255818 10790 0   45.768401399999995 39.0261044 2022-04-17 04:20:59 Krasnodar Krai, Russia
304088 304088 2022-04-16 Russia Krasnoyarsk Krai     362400 10706 0   63.3233807 97.09799740000001 2022-04-17 04:20:59 Krasnoyarsk Krai, Russia
304089 304089 2022-04-16 Russia Kurgan Oblast     102906 1403 0   55.7655302 64.5632681 2022-04-17 04:20:59 Kurgan Oblast, Russia
304090 304090 2022-04-16 Russia Kursk Oblast     115717 2427 0   51.6568453 36.4852695 2022-04-17 04:20:59 Kursk Oblast, Russia
304091 304091 2022-04-16 Russia Leningrad Oblast     184174 3466 0   60.185329599999996 32.3925325 2022-04-17 04:20:59 Leningrad Oblast, Russia
304092 304092 2022-04-16 Russia Lipetsk Oblast     147986 3639 0   52.693517799999995 39.112266399999996 2022-04-17 04:20:59 Lipetsk Oblast, Russia
304093 304093 2022-04-16 Russia Magadan Oblast     19715 388 0   62.48858785 153.9903764 2022-04-17 04:20:59 Magadan Oblast, Russia
304094 304094 2022-04-16 Russia Mari El Republic     44400 1083 0   56.576750399999995 47.881751200000004 2022-04-17 04:20:59 Mari El Republic, Russia
304095 304095 2022-04-16 Russia Mordovia Republic     66449 1366 0   54.4419829 44.466114399999995 2022-04-17 04:20:59 Mordovia Republic, Russia
304096 304096 2022-04-16 Russia Moscow     2752710 42998 0   55.7504461 37.6174943 2022-04-17 04:20:59 Moscow, Russia
304097 304097 2022-04-16 Russia Moscow Oblast     966194 14948 0   55.50431579999999 38.0353929 2022-04-17 04:20:59 Moscow Oblast, Russia
304098 304098 2022-04-16 Russia Murmansk Oblast     133967 3300 0   68.00004179999999 33.9999151 2022-04-17 04:20:59 Murmansk Oblast, Russia
304099 304099 2022-04-16 Russia Nenets Autonomous Okrug     7270 100 0   68.27557185 57.1686375 2022-04-17 04:20:59 Nenets Autonomous Okrug, Russia
304100 304100 2022-04-16 Russia Nizhny Novgorod Oblast     414057 11413 0   55.47180329999999 44.091159399999995 2022-04-17 04:20:59 Nizhny Novgorod Oblast, Russia
304101 304101 2022-04-16 Russia North Ossetia - Alania Republic     40585 1248 0   42.79336110000001 44.6324493 2022-04-17 04:20:59 North Ossetia - Alania Republic, Russia
304102 304102 2022-04-16 Russia Novgorod Oblast     98261 1009 0   58.2843833 32.516975699999996 2022-04-17 04:20:59 Novgorod Oblast, Russia
304103 304103 2022-04-16 Russia Novosibirsk Oblast     254385 5532 0   54.9720169 79.48139240000002 2022-04-17 04:20:59 Novosibirsk Oblast, Russia
304104 304104 2022-04-16 Russia Omsk Oblast     205159 4301 0   56.09352629999999 73.5099936 2022-04-17 04:20:59 Omsk Oblast, Russia
304105 304105 2022-04-16 Russia Orel Oblast     110366 1877 0   52.96854329999999 36.0692477 2022-04-17 04:20:59 Orel Oblast, Russia
304106 304106 2022-04-16 Russia Orenburg Oblast     213706 3935 0   52.02692620000001 54.7276647 2022-04-17 04:20:59 Orenburg Oblast, Russia
304107 304107 2022-04-16 Russia Penza Oblast     182733 5704 0   53.1655415 44.78791810000001 2022-04-17 04:20:59 Penza Oblast, Russia
304108 304108 2022-04-16 Russia Perm Krai     364126 8720 0   58.5951603 56.3159546 2022-04-17 04:20:59 Perm Krai, Russia
304109 304109 2022-04-16 Russia Primorsky Krai     172658 1927 0   45.0819456 134.726645 2022-04-17 04:20:59 Primorsky Krai, Russia
304110 304110 2022-04-16 Russia Pskov Oblast     108564 1793 0   57.535872899999994 28.8586826 2022-04-17 04:20:59 Pskov Oblast, Russia
304111 304111 2022-04-16 Russia Rostov Oblast     370267 10830 0   47.6222451 40.7957942 2022-04-17 04:20:59 Rostov Oblast, Russia
304112 304112 2022-04-16 Russia Ryazan Oblast     118148 3339 0   54.42267320000001 40.57052460000001 2022-04-17 04:20:59 Ryazan Oblast, Russia
304113 304113 2022-04-16 Russia Saint Petersburg     1511478 33300 0   59.960673899999996 30.158655100000004 2022-04-17 04:20:59 Saint Petersburg, Russia
304114 304114 2022-04-16 Russia Sakha (Yakutiya) Republic     176634 2105 0   66.941626 129.642371 2022-04-17 04:20:59 Sakha (Yakutiya) Republic, Russia
304115 304115 2022-04-16 Russia Sakhalin Oblast     64465 826 0   49.7219665 143.448533 2022-04-17 04:20:59 Sakhalin Oblast, Russia
304116 304116 2022-04-16 Russia Samara Oblast     379523 7746 0   53.2128813 50.8914633 2022-04-17 04:20:59 Samara Oblast, Russia
304117 304117 2022-04-16 Russia Saratov Oblast     246084 5902 0   51.652055499999996 46.86319520000001 2022-04-17 04:20:59 Saratov Oblast, Russia
304118 304118 2022-04-16 Russia Smolensk Oblast     129058 3006 0   55.03434960000001 33.0192065 2022-04-17 04:20:59 Smolensk Oblast, Russia
304119 304119 2022-04-16 Russia Stavropol Krai     194923 7000 0   44.86325770000001 43.4406913 2022-04-17 04:20:59 Stavropol Krai, Russia
304120 304120 2022-04-16 Russia Sverdlovsk Oblast     435995 10670 0   58.6414755 61.802154599999994 2022-04-17 04:20:59 Sverdlovsk Oblast, Russia
304121 304121 2022-04-16 Russia Tambov Oblast     113985 2364 0   52.9019574 41.3578918 2022-04-17 04:20:59 Tambov Oblast, Russia
304122 304122 2022-04-16 Russia Tatarstan Republic     141370 1938 0   55.7648572 52.43104273 2022-04-17 04:20:59 Tatarstan Republic, Russia
304123 304123 2022-04-16 Russia Tomsk Oblast     128530 810 0   58.6124279 82.04753149999998 2022-04-17 04:20:59 Tomsk Oblast, Russia
304124 304124 2022-04-16 Russia Tula Oblast     152735 5135 0   53.9570701 37.369090899999996 2022-04-17 04:20:59 Tula Oblast, Russia
304125 304125 2022-04-16 Russia Tver Oblast     159533 2711 0   57.1134475 35.174442799999994 2022-04-17 04:20:59 Tver Oblast, Russia
304126 304126 2022-04-16 Russia Tyumen Oblast     189037 4277 0   58.8206488 70.36588370000001 2022-04-17 04:20:59 Tyumen Oblast, Russia
304127 304127 2022-04-16 Russia Tyva Republic     44398 351 0   51.401714899999995 93.8582593 2022-04-17 04:20:59 Tyva Republic, Russia
304128 304128 2022-04-16 Russia Udmurt Republic     165046 3801 0   57.1961165 52.69598320000001 2022-04-17 04:20:59 Udmurt Republic, Russia
304129 304129 2022-04-16 Russia Ulyanovsk Oblast     200591 4611 0   54.146317700000004 47.2324921 2022-04-17 04:20:59 Ulyanovsk Oblast, Russia
304130 304130 2022-04-16 Russia Vladimir Oblast     149619 3410 0   56.0503336 40.656163299999996 2022-04-17 04:20:59 Vladimir Oblast, Russia
304131 304131 2022-04-16 Russia Volgograd Oblast     213265 6791 0   49.604833899999996 44.29035820000001 2022-04-17 04:20:59 Volgograd Oblast, Russia
304132 304132 2022-04-16 Russia Vologda Oblast     187614 3726 0   60.0391461 43.1215213 2022-04-17 04:20:59 Vologda Oblast, Russia
304133 304133 2022-04-16 Russia Voronezh Oblast     376339 8165 0   50.9800393 40.15065070000001 2022-04-17 04:20:59 Voronezh Oblast, Russia
304134 304134 2022-04-16 Russia Yamalo-Nenets Autonomous Okrug     136209 1039 0   67.1471631 74.3415488 2022-04-17 04:20:59 Yamalo-Nenets Autonomous Okrug, Russia
304135 304135 2022-04-16 Russia Yaroslavl Oblast     157624 2728 0   57.77819760000001 39.002109499999996 2022-04-17 04:20:59 Yaroslavl Oblast, Russia
304136 304136 2022-04-16 Russia Zabaykalsky Krai     167365 2325 0   52.248521000000004 115.956325 2022-04-17 04:20:59 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]);