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-01-23 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
2466986 2466986 2021-01-22 Russia Adygea Republic     12580 111 10641 1828 44.6939006 40.1520421 2021-01-23 05:22:03 Adygea Republic, Russia
2466987 2466987 2021-01-22 Russia Altai Krai     37316 1095 33898 2323 52.6932243 82.69314240000001 2021-01-23 05:22:03 Altai Krai, Russia
2466988 2466988 2021-01-22 Russia Altai Republic     15017 117 13913 987 50.7114101 86.8572186 2021-01-23 05:22:03 Altai Republic, Russia
2466989 2466989 2021-01-22 Russia Amur Oblast     18585 127 16679 1779 52.8032368 128.437295 2021-01-23 05:22:03 Amur Oblast, Russia
2466990 2466990 2021-01-22 Russia Arkhangelsk Oblast     49004 458 40897 7649 63.5589686 43.1221646 2021-01-23 05:22:03 Arkhangelsk Oblast, Russia
2466991 2466991 2021-01-22 Russia Astrakhan Oblast     22887 466 14465 7956 47.1878186 47.608851 2021-01-23 05:22:03 Astrakhan Oblast, Russia
2466992 2466992 2021-01-22 Russia Bashkortostan Republic     22738 172 17230 5336 54.8573563 57.1439682 2021-01-23 05:22:03 Bashkortostan Republic, Russia
2466993 2466993 2021-01-22 Russia Belgorod Oblast     25875 325 23557 1993 50.7080119 37.5837615 2021-01-23 05:22:03 Belgorod Oblast, Russia
2466994 2466994 2021-01-22 Russia Bryansk Oblast     27414 235 26122 1057 52.8873315 33.41585300000001 2021-01-23 05:22:03 Bryansk Oblast, Russia
2466995 2466995 2021-01-22 Russia Buryatia Republic     29069 645 26517 1907 52.7182426 109.492143 2021-01-23 05:22:03 Buryatia Republic, Russia
2466996 2466996 2021-01-22 Russia Chechen Republic     10459 103 8302 2054 43.39761470000001 45.6985005 2021-01-23 05:22:03 Chechen Republic, Russia
2466997 2466997 2021-01-22 Russia Chelyabinsk Oblast     41243 696 28641 11906 54.4223954 61.1865846 2021-01-23 05:22:03 Chelyabinsk Oblast, Russia
2466998 2466998 2021-01-22 Russia Chukotka Autonomous Okrug     600 4 535 61 66.0006475 169.4900869 2021-01-23 05:22:03 Chukotka Autonomous Okrug, Russia
2466999 2466999 2021-01-22 Russia Chuvashia Republic     18609 769 16704 1136 55.4259922 47.0849429 2021-01-23 05:22:03 Chuvashia Republic, Russia
2467000 2467000 2021-01-22 Russia Dagestan Republic     26918 1210 23657 2051 43.05749160000001 47.1332224 2021-01-23 05:22:03 Dagestan Republic, Russia
2467001 2467001 2021-01-22 Russia Ingushetia Republic     13564 156 11701 1707 43.11542075 45.01713552 2021-01-23 05:22:03 Ingushetia Republic, Russia
2467002 2467002 2021-01-22 Russia Irkutsk Oblast     46308 1470 41051 3787 56.6370122 104.719221 2021-01-23 05:22:03 Irkutsk Oblast, Russia
2467003 2467003 2021-01-22 Russia Ivanovo Oblast     25208 691 20977 3540 56.9167446 41.43521370000001 2021-01-23 05:22:03 Ivanovo Oblast, Russia
2467004 2467004 2021-01-22 Russia Jewish Autonomous Okrug     4044 98 3570 376 48.57527615 132.66307460000002 2021-01-23 05:22:03 Jewish Autonomous Okrug, Russia
2467005 2467005 2021-01-22 Russia Kabardino-Balkarian Republic     17973 305 16747 921 43.4806048 43.5978976 2021-01-23 05:22:03 Kabardino-Balkarian Republic, Russia
2467006 2467006 2021-01-22 Russia Kaliningrad Oblast     22333 214 19958 2161 54.7293041 21.1489473 2021-01-23 05:22:03 Kaliningrad Oblast, Russia
2467007 2467007 2021-01-22 Russia Kalmykia Republic     16743 236 14158 2349 46.2313018 45.3275745 2021-01-23 05:22:03 Kalmykia Republic, Russia
2467008 2467008 2021-01-22 Russia Kaluga Oblast     24597 209 22489 1899 54.4382773 35.5272854 2021-01-23 05:22:03 Kaluga Oblast, Russia
2467009 2467009 2021-01-22 Russia Kamchatka Krai     11715 83 10293 1339 57.1914882 160.03838190000005 2021-01-23 05:22:03 Kamchatka Krai, Russia
2467010 2467010 2021-01-22 Russia Karachay-Cherkess Republic     16926 49 15269 1608 43.7368326 41.7267991 2021-01-23 05:22:03 Karachay-Cherkess Republic, Russia
2467011 2467011 2021-01-22 Russia Karelia Republic     33687 209 28315 5163 62.61940309999999 33.4920267 2021-01-23 05:22:03 Karelia Republic, Russia
2467012 2467012 2021-01-22 Russia Kemerovo Oblast     28374 508 25909 1957 54.53357809999999 87.342861 2021-01-23 05:22:03 Kemerovo Oblast, Russia
2467013 2467013 2021-01-22 Russia Khabarovsk Krai     41894 233 38002 3659 51.6312684 136.121524 2021-01-23 05:22:03 Khabarovsk Krai, Russia
2467014 2467014 2021-01-22 Russia Khakassia Republic     19814 365 18001 1448 53.72258845 91.44293627 2021-01-23 05:22:03 Khakassia Republic, Russia
2467015 2467015 2021-01-22 Russia Khanty-Mansi Autonomous Okrug     45892 636 42434 2822 61.0259025 69.0982628 2021-01-23 05:22:03 Khanty-Mansi Autonomous Okrug, Russia
2467016 2467016 2021-01-22 Russia Kirov Oblast     30656 258 24636 5762 57.9665589 49.4074599 2021-01-23 05:22:03 Kirov Oblast, Russia
2467017 2467017 2021-01-22 Russia Komi Republic     35066 655 33637 774 63.9881421 54.3326073 2021-01-23 05:22:03 Komi Republic, Russia
2467018 2467018 2021-01-22 Russia Kostroma Oblast     16539 267 13178 3094 58.424756 44.2533273 2021-01-23 05:22:03 Kostroma Oblast, Russia
2467019 2467019 2021-01-22 Russia Krasnodar Krai     31959 1294 22405 8260 45.7684014 39.0261044 2021-01-23 05:22:03 Krasnodar Krai, Russia
2467020 2467020 2021-01-22 Russia Krasnoyarsk Krai     53570 2115 49328 2127 63.3233807 97.0979974 2021-01-23 05:22:03 Krasnoyarsk Krai, Russia
2467021 2467021 2021-01-22 Russia Kurgan Oblast     14353 202 12583 1568 55.7655302 64.5632681 2021-01-23 05:22:03 Kurgan Oblast, Russia
2467022 2467022 2021-01-22 Russia Kursk Oblast     24661 341 21766 2554 51.6568453 36.4852695 2021-01-23 05:22:03 Kursk Oblast, Russia
2467023 2467023 2021-01-22 Russia Leningrad Oblast     28710 362 25872 2476 60.1853296 32.3925325 2021-01-23 05:22:03 Leningrad Oblast, Russia
2467024 2467024 2021-01-22 Russia Lipetsk Oblast     19568 346 15379 3843 52.6935178 39.1122664 2021-01-23 05:22:03 Lipetsk Oblast, Russia
2467025 2467025 2021-01-22 Russia Magadan Oblast     7654 80 7208 366 62.48858785 153.9903764 2021-01-23 05:22:03 Magadan Oblast, Russia
2467026 2467026 2021-01-22 Russia Mari El Republic     10263 147 8924 1192 56.5767504 47.8817512 2021-01-23 05:22:03 Mari El Republic, Russia
2467027 2467027 2021-01-22 Russia Mordovia Republic     15333 123 12778 2432 54.4419829 44.4661144 2021-01-23 05:22:03 Mordovia Republic, Russia
2467028 2467028 2021-01-22 Russia Moscow     907389 12831 763500 131058 55.7504461 37.6174943 2021-01-23 05:22:03 Moscow, Russia
2467029 2467029 2021-01-22 Russia Moscow Oblast     183133 3449 143026 36658 55.50431579999999 38.0353929 2021-01-23 05:22:03 Moscow Oblast, Russia
2467030 2467030 2021-01-22 Russia Murmansk Oblast     41419 773 37471 3175 68.00004179999999 33.9999151 2021-01-23 05:22:03 Murmansk Oblast, Russia
2467031 2467031 2021-01-22 Russia Nenets Autonomous Okrug     860 0 754 106 68.27557185 57.1686375 2021-01-23 05:22:03 Nenets Autonomous Okrug, Russia
2467032 2467032 2021-01-22 Russia Nizhny Novgorod Oblast     80161 1989 72420 5752 55.47180329999999 44.0911594 2021-01-23 05:22:03 Nizhny Novgorod Oblast, Russia
2467033 2467033 2021-01-22 Russia North Ossetia - Alania Republic     13819 108 12289 1422 42.79336110000001 44.6324493 2021-01-23 05:22:03 North Ossetia - Alania Republic, Russia
2467034 2467034 2021-01-22 Russia Novgorod Oblast     22550 110 17801 4639 58.2843833 32.5169757 2021-01-23 05:22:03 Novgorod Oblast, Russia
2467035 2467035 2021-01-22 Russia Novosibirsk Oblast     31034 1148 28089 1797 54.9720169 79.48139240000002 2021-01-23 05:22:03 Novosibirsk Oblast, Russia
2467036 2467036 2021-01-22 Russia Omsk Oblast     35527 1039 32201 2287 56.09352629999999 73.5099936 2021-01-23 05:22:03 Omsk Oblast, Russia
2467037 2467037 2021-01-22 Russia Orel Oblast     25220 317 22277 2626 52.96854329999999 36.0692477 2021-01-23 05:22:03 Orel Oblast, Russia
2467038 2467038 2021-01-22 Russia Orenburg Oblast     32560 436 28832 3292 52.02692620000001 54.7276647 2021-01-23 05:22:03 Orenburg Oblast, Russia
2467039 2467039 2021-01-22 Russia Penza Oblast     30689 363 24300 6026 53.1655415 44.78791810000001 2021-01-23 05:22:03 Penza Oblast, Russia
2467040 2467040 2021-01-22 Russia Perm Krai     37183 1355 30599 5229 58.5951603 56.3159546 2021-01-23 05:22:03 Perm Krai, Russia
2467041 2467041 2021-01-22 Russia Primorsky Krai     34394 478 25818 8098 45.0819456 134.726645 2021-01-23 05:22:03 Primorsky Krai, Russia
2467042 2467042 2021-01-22 Russia Pskov Oblast     28129 118 16121 11890 57.5358729 28.8586826 2021-01-23 05:22:03 Pskov Oblast, Russia
2467043 2467043 2021-01-22 Russia Rostov Oblast     60269 2448 49861 7960 47.6222451 40.7957942 2021-01-23 05:22:03 Rostov Oblast, Russia
2467044 2467044 2021-01-22 Russia Ryazan Oblast     20925 217 19052 1656 54.42267320000001 40.57052460000001 2021-01-23 05:22:03 Ryazan Oblast, Russia
2467045 2467045 2021-01-22 Russia Saint Petersburg     313608 9181 202307 102120 59.9606739 30.158655100000004 2021-01-23 05:22:03 Saint Petersburg, Russia
2467046 2467046 2021-01-22 Russia Sakha (Yakutiya) Republic     29468 450 26110 2908 66.941626 129.642371 2021-01-23 05:22:03 Sakha (Yakutiya) Republic, Russia
2467047 2467047 2021-01-22 Russia Sakhalin Oblast     18714 22 15783 2909 49.7219665 143.448533 2021-01-23 05:22:03 Sakhalin Oblast, Russia
2467048 2467048 2021-01-22 Russia Samara Oblast     37730 770 34804 2156 53.2128813 50.8914633 2021-01-23 05:22:03 Samara Oblast, Russia
2467049 2467049 2021-01-22 Russia Saratov Oblast     40956 505 35383 5068 51.6520555 46.86319520000001 2021-01-23 05:22:03 Saratov Oblast, Russia
2467050 2467050 2021-01-22 Russia Smolensk Oblast     20685 414 17052 3219 55.03434960000001 33.0192065 2021-01-23 05:22:03 Smolensk Oblast, Russia
2467051 2467051 2021-01-22 Russia Stavropol Krai     40369 884 36328 3157 44.86325770000001 43.4406913 2021-01-23 05:22:03 Stavropol Krai, Russia
2467052 2467052 2021-01-22 Russia Sverdlovsk Oblast     67136 1890 59615 5631 58.6414755 61.8021546 2021-01-23 05:22:03 Sverdlovsk Oblast, Russia
2467053 2467053 2021-01-22 Russia Tambov Oblast     21148 244 19322 1582 52.9019574 41.3578918 2021-01-23 05:22:03 Tambov Oblast, Russia
2467054 2467054 2021-01-22 Russia Tatarstan Republic     15275 244 11659 3372 55.7648572 52.43104273 2021-01-23 05:22:03 Tatarstan Republic, Russia
2467055 2467055 2021-01-22 Russia Tomsk Oblast     27304 251 24310 2743 58.6124279 82.04753149999998 2021-01-23 05:22:03 Tomsk Oblast, Russia
2467056 2467056 2021-01-22 Russia Tula Oblast     27294 940 24405 1949 53.9570701 37.3690909 2021-01-23 05:22:03 Tula Oblast, Russia
2467057 2467057 2021-01-22 Russia Tver Oblast     27239 499 22874 3866 57.1134475 35.174442799999994 2021-01-23 05:22:03 Tver Oblast, Russia
2467058 2467058 2021-01-22 Russia Tyumen Oblast     26876 235 25257 1384 58.8206488 70.36588370000001 2021-01-23 05:22:03 Tyumen Oblast, Russia
2467059 2467059 2021-01-22 Russia Tyva Republic     15288 185 14084 1019 51.4017149 93.8582593 2021-01-23 05:22:03 Tyva Republic, Russia
2467060 2467060 2021-01-22 Russia Udmurt Republic     24027 460 20339 3228 57.1961165 52.69598320000001 2021-01-23 05:22:03 Udmurt Republic, Russia
2467061 2467061 2021-01-22 Russia Ulyanovsk Oblast     41813 560 38195 3058 54.1463177 47.2324921 2021-01-23 05:22:03 Ulyanovsk Oblast, Russia
2467062 2467062 2021-01-22 Russia Vladimir Oblast     22130 623 19424 2083 56.0503336 40.6561633 2021-01-23 05:22:03 Vladimir Oblast, Russia
2467063 2467063 2021-01-22 Russia Volgograd Oblast     41144 564 39205 1375 49.6048339 44.29035820000001 2021-01-23 05:22:03 Volgograd Oblast, Russia
2467064 2467064 2021-01-22 Russia Vologda Oblast     30211 573 25524 4114 60.0391461 43.1215213 2021-01-23 05:22:03 Vologda Oblast, Russia
2467065 2467065 2021-01-22 Russia Voronezh Oblast     54778 1427 49442 3909 50.9800393 40.15065070000001 2021-01-23 05:22:03 Voronezh Oblast, Russia
2467066 2467066 2021-01-22 Russia Yamalo-Nenets Autonomous Okrug     34944 369 29821 4754 67.1471631 74.3415488 2021-01-23 05:22:03 Yamalo-Nenets Autonomous Okrug, Russia
2467067 2467067 2021-01-22 Russia Yaroslavl Oblast     26447 275 24796 1376 57.77819760000001 39.0021095 2021-01-23 05:22:03 Yaroslavl Oblast, Russia
2467068 2467068 2021-01-22 Russia Zabaykalsky Krai     32299 447 30061 1791 52.248521 115.956325 2021-01-23 05:22:03 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]);