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-01-29 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
3810118 3810118 2022-01-28 Russia Adygea Republic     29574 817 0   44.6939006 40.1520421 2022-01-29 04:21:10 Adygea Republic, Russia
3810119 3810119 2022-01-28 Russia Altai Krai     129603 7273 0   52.693224300000004 82.69314240000001 2022-01-29 04:21:10 Altai Krai, Russia
3810120 3810120 2022-01-28 Russia Altai Republic     26241 553 0   50.7114101 86.8572186 2022-01-29 04:21:10 Altai Republic, Russia
3810121 3810121 2022-01-28 Russia Amur Oblast     58862 655 0   52.8032368 128.437295 2022-01-29 04:21:10 Amur Oblast, Russia
3810122 3810122 2022-01-28 Russia Arkhangelsk Oblast     133899 1561 0   63.5589686 43.1221646 2022-01-29 04:21:10 Arkhangelsk Oblast, Russia
3810123 3810123 2022-01-28 Russia Astrakhan Oblast     87536 2640 0   47.1878186 47.608851 2022-01-29 04:21:10 Astrakhan Oblast, Russia
3810124 3810124 2022-01-28 Russia Bashkortostan Republic     129552 4711 0   54.8573563 57.1439682 2022-01-29 04:21:10 Bashkortostan Republic, Russia
3810125 3810125 2022-01-28 Russia Belgorod Oblast     86082 1907 0   50.7080119 37.5837615 2022-01-29 04:21:10 Belgorod Oblast, Russia
3810126 3810126 2022-01-28 Russia Bryansk Oblast     102127 3210 0   52.887331499999995 33.41585300000001 2022-01-29 04:21:10 Bryansk Oblast, Russia
3810127 3810127 2022-01-28 Russia Buryatia Republic     82595 2597 0   52.718242599999996 109.492143 2022-01-29 04:21:10 Buryatia Republic, Russia
3810128 3810128 2022-01-28 Russia Chechen Republic     34121 996 0   43.39761470000001 45.6985005 2022-01-29 04:21:10 Chechen Republic, Russia
3810129 3810129 2022-01-28 Russia Chelyabinsk Oblast     156819 6453 0   54.4223954 61.1865846 2022-01-29 04:21:10 Chelyabinsk Oblast, Russia
3810130 3810130 2022-01-28 Russia Chukotka Autonomous Okrug     3063 40 0   66.0006475 169.4900869 2022-01-29 04:21:10 Chukotka Autonomous Okrug, Russia
3810131 3810131 2022-01-28 Russia Chuvashia Republic     49889 4193 0   55.4259922 47.0849429 2022-01-29 04:21:10 Chuvashia Republic, Russia
3810132 3810132 2022-01-28 Russia Dagestan Republic     71034 3317 0   43.05749160000001 47.1332224 2022-01-29 04:21:10 Dagestan Republic, Russia
3810133 3810133 2022-01-28 Russia Ingushetia Republic     31018 504 0   43.11542075 45.01713552 2022-01-29 04:21:10 Ingushetia Republic, Russia
3810134 3810134 2022-01-28 Russia Irkutsk Oblast     167714 7382 0   56.6370122 104.71922099999999 2022-01-29 04:21:10 Irkutsk Oblast, Russia
3810135 3810135 2022-01-28 Russia Ivanovo Oblast     71742 2688 0   56.9167446 41.43521370000001 2022-01-29 04:21:10 Ivanovo Oblast, Russia
3810136 3810136 2022-01-28 Russia Jewish Autonomous Okrug     12193 450 0   48.57527615 132.66307460000002 2022-01-29 04:21:10 Jewish Autonomous Okrug, Russia
3810137 3810137 2022-01-28 Russia Kabardino-Balkarian Republic     44780 1569 0   43.480604799999995 43.5978976 2022-01-29 04:21:10 Kabardino-Balkarian Republic, Russia
3810138 3810138 2022-01-28 Russia Kaliningrad Oblast     90551 1418 0   54.7293041 21.1489473 2022-01-29 04:21:10 Kaliningrad Oblast, Russia
3810139 3810139 2022-01-28 Russia Kalmykia Republic     35944 771 0   46.2313018 45.3275745 2022-01-29 04:21:10 Kalmykia Republic, Russia
3810140 3810140 2022-01-28 Russia Kaluga Oblast     69564 1286 0   54.438277299999996 35.5272854 2022-01-29 04:21:10 Kaluga Oblast, Russia
3810141 3810141 2022-01-28 Russia Kamchatka Krai     25371 532 0   57.191488199999995 160.03838190000005 2022-01-29 04:21:10 Kamchatka Krai, Russia
3810142 3810142 2022-01-28 Russia Karachay-Cherkess Republic     34239 928 0   43.7368326 41.7267991 2022-01-29 04:21:10 Karachay-Cherkess Republic, Russia
3810143 3810143 2022-01-28 Russia Karelia Republic     96211 1304 0   62.61940309999999 33.4920267 2022-01-29 04:21:10 Karelia Republic, Russia
3810144 3810144 2022-01-28 Russia Kemerovo Oblast     92917 1879 0   54.53357809999999 87.342861 2022-01-29 04:21:10 Kemerovo Oblast, Russia
3810145 3810145 2022-01-28 Russia Khabarovsk Krai     132746 1335 0   51.6312684 136.121524 2022-01-29 04:21:10 Khabarovsk Krai, Russia
3810146 3810146 2022-01-28 Russia Khakassia Republic     57263 2123 0   53.72258845 91.44293627 2022-01-29 04:21:10 Khakassia Republic, Russia
3810147 3810147 2022-01-28 Russia Khanty-Mansi Autonomous Okrug     110010 2160 0   61.0259025 69.0982628 2022-01-29 04:21:10 Khanty-Mansi Autonomous Okrug, Russia
3810148 3810148 2022-01-28 Russia Kirov Oblast     86014 815 0   57.9665589 49.4074599 2022-01-29 04:21:10 Kirov Oblast, Russia
3810149 3810149 2022-01-28 Russia Komi Republic     102591 2772 0   63.9881421 54.3326073 2022-01-29 04:21:10 Komi Republic, Russia
3810150 3810150 2022-01-28 Russia Kostroma Oblast     51230 1163 0   58.424756 44.253327299999995 2022-01-29 04:21:10 Kostroma Oblast, Russia
3810151 3810151 2022-01-28 Russia Krasnodar Krai     135643 10036 0   45.768401399999995 39.0261044 2022-01-29 04:21:10 Krasnodar Krai, Russia
3810152 3810152 2022-01-28 Russia Krasnoyarsk Krai     183550 9404 0   63.3233807 97.09799740000001 2022-01-29 04:21:10 Krasnoyarsk Krai, Russia
3810153 3810153 2022-01-28 Russia Kurgan Oblast     53387 1046 0   55.7655302 64.5632681 2022-01-29 04:21:10 Kurgan Oblast, Russia
3810154 3810154 2022-01-28 Russia Kursk Oblast     85639 2172 0   51.6568453 36.4852695 2022-01-29 04:21:10 Kursk Oblast, Russia
3810155 3810155 2022-01-28 Russia Leningrad Oblast     112856 3142 0   60.185329599999996 32.3925325 2022-01-29 04:21:10 Leningrad Oblast, Russia
3810156 3810156 2022-01-28 Russia Lipetsk Oblast     89744 3012 0   52.693517799999995 39.112266399999996 2022-01-29 04:21:10 Lipetsk Oblast, Russia
3810157 3810157 2022-01-28 Russia Magadan Oblast     14360 356 0   62.48858785 153.9903764 2022-01-29 04:21:10 Magadan Oblast, Russia
3810158 3810158 2022-01-28 Russia Mari El Republic     31692 971 0   56.576750399999995 47.881751200000004 2022-01-29 04:21:10 Mari El Republic, Russia
3810159 3810159 2022-01-28 Russia Mordovia Republic     42989 1135 0   54.4419829 44.466114399999995 2022-01-29 04:21:10 Mordovia Republic, Russia
3810160 3810160 2022-01-28 Russia Moscow     2283416 38734 0   55.7504461 37.6174943 2022-01-29 04:21:10 Moscow, Russia
3810161 3810161 2022-01-28 Russia Moscow Oblast     727285 13221 0   55.50431579999999 38.0353929 2022-01-29 04:21:10 Moscow Oblast, Russia
3810162 3810162 2022-01-28 Russia Murmansk Oblast     96657 2914 0   68.00004179999999 33.9999151 2022-01-29 04:21:10 Murmansk Oblast, Russia
3810163 3810163 2022-01-28 Russia Nenets Autonomous Okrug     3742 89 0   68.27557185 57.1686375 2022-01-29 04:21:10 Nenets Autonomous Okrug, Russia
3810164 3810164 2022-01-28 Russia Nizhny Novgorod Oblast     248556 10458 0   55.47180329999999 44.091159399999995 2022-01-29 04:21:10 Nizhny Novgorod Oblast, Russia
3810165 3810165 2022-01-28 Russia North Ossetia - Alania Republic     33147 1098 0   42.79336110000001 44.6324493 2022-01-29 04:21:10 North Ossetia - Alania Republic, Russia
3810166 3810166 2022-01-28 Russia Novgorod Oblast     70074 831 0   58.2843833 32.516975699999996 2022-01-29 04:21:10 Novgorod Oblast, Russia
3810167 3810167 2022-01-28 Russia Novosibirsk Oblast     102168 4593 0   54.9720169 79.48139240000002 2022-01-29 04:21:10 Novosibirsk Oblast, Russia
3810168 3810168 2022-01-28 Russia Omsk Oblast     140132 3493 0   56.09352629999999 73.5099936 2022-01-29 04:21:10 Omsk Oblast, Russia
3810169 3810169 2022-01-28 Russia Orel Oblast     76221 1611 0   52.96854329999999 36.0692477 2022-01-29 04:21:10 Orel Oblast, Russia
3810170 3810170 2022-01-28 Russia Orenburg Oblast     114630 3582 0   52.02692620000001 54.7276647 2022-01-29 04:21:10 Orenburg Oblast, Russia
3810171 3810171 2022-01-28 Russia Penza Oblast     107116 4858 0   53.1655415 44.78791810000001 2022-01-29 04:21:10 Penza Oblast, Russia
3810172 3810172 2022-01-28 Russia Perm Krai     177210 7771 0   58.5951603 56.3159546 2022-01-29 04:21:10 Perm Krai, Russia
3810173 3810173 2022-01-28 Russia Primorsky Krai     110952 1692 0   45.0819456 134.726645 2022-01-29 04:21:10 Primorsky Krai, Russia
3810174 3810174 2022-01-28 Russia Pskov Oblast     74712 1414 0   57.535872899999994 28.8586826 2022-01-29 04:21:10 Pskov Oblast, Russia
3810175 3810175 2022-01-28 Russia Rostov Oblast     209950 9998 0   47.6222451 40.7957942 2022-01-29 04:21:10 Rostov Oblast, Russia
3810176 3810176 2022-01-28 Russia Ryazan Oblast     65674 2843 0   54.42267320000001 40.57052460000001 2022-01-29 04:21:10 Ryazan Oblast, Russia
3810177 3810177 2022-01-28 Russia Saint Petersburg     976259 29713 0   59.960673899999996 30.158655100000004 2022-01-29 04:21:10 Saint Petersburg, Russia
3810178 3810178 2022-01-28 Russia Sakha (Yakutiya) Republic     91584 1861 0   66.941626 129.642371 2022-01-29 04:21:10 Sakha (Yakutiya) Republic, Russia
3810179 3810179 2022-01-28 Russia Sakhalin Oblast     45950 632 0   49.7219665 143.448533 2022-01-29 04:21:10 Sakhalin Oblast, Russia
3810180 3810180 2022-01-28 Russia Samara Oblast     215124 6665 0   53.2128813 50.8914633 2022-01-29 04:21:10 Samara Oblast, Russia
3810181 3810181 2022-01-28 Russia Saratov Oblast     141382 5327 0   51.652055499999996 46.86319520000001 2022-01-29 04:21:10 Saratov Oblast, Russia
3810182 3810182 2022-01-28 Russia Smolensk Oblast     89333 2561 0   55.03434960000001 33.0192065 2022-01-29 04:21:10 Smolensk Oblast, Russia
3810183 3810183 2022-01-28 Russia Stavropol Krai     139638 6421 0   44.86325770000001 43.4406913 2022-01-29 04:21:10 Stavropol Krai, Russia
3810184 3810184 2022-01-28 Russia Sverdlovsk Oblast     218412 9957 0   58.6414755 61.802154599999994 2022-01-29 04:21:10 Sverdlovsk Oblast, Russia
3810185 3810185 2022-01-28 Russia Tambov Oblast     66490 1917 0   52.9019574 41.3578918 2022-01-29 04:21:10 Tambov Oblast, Russia
3810186 3810186 2022-01-28 Russia Tatarstan Republic     47030 1576 0   55.7648572 52.43104273 2022-01-29 04:21:10 Tatarstan Republic, Russia
3810187 3810187 2022-01-28 Russia Tomsk Oblast     65952 702 0   58.6124279 82.04753149999998 2022-01-29 04:21:10 Tomsk Oblast, Russia
3810188 3810188 2022-01-28 Russia Tula Oblast     82665 4568 0   53.9570701 37.369090899999996 2022-01-29 04:21:10 Tula Oblast, Russia
3810189 3810189 2022-01-28 Russia Tver Oblast     106265 2447 0   57.1134475 35.174442799999994 2022-01-29 04:21:10 Tver Oblast, Russia
3810190 3810190 2022-01-28 Russia Tyumen Oblast     98984 3717 0   58.8206488 70.36588370000001 2022-01-29 04:21:10 Tyumen Oblast, Russia
3810191 3810191 2022-01-28 Russia Tyva Republic     33661 332 0   51.401714899999995 93.8582593 2022-01-29 04:21:10 Tyva Republic, Russia
3810192 3810192 2022-01-28 Russia Udmurt Republic     85195 3303 0   57.1961165 52.69598320000001 2022-01-29 04:21:10 Udmurt Republic, Russia
3810193 3810193 2022-01-28 Russia Ulyanovsk Oblast     126126 4055 0   54.146317700000004 47.2324921 2022-01-29 04:21:10 Ulyanovsk Oblast, Russia
3810194 3810194 2022-01-28 Russia Vladimir Oblast     87916 3076 0   56.0503336 40.656163299999996 2022-01-29 04:21:10 Vladimir Oblast, Russia
3810195 3810195 2022-01-28 Russia Volgograd Oblast     138511 5963 0   49.604833899999996 44.29035820000001 2022-01-29 04:21:10 Volgograd Oblast, Russia
3810196 3810196 2022-01-28 Russia Vologda Oblast     105207 3181 0   60.0391461 43.1215213 2022-01-29 04:21:10 Vologda Oblast, Russia
3810197 3810197 2022-01-28 Russia Voronezh Oblast     207557 7266 0   50.9800393 40.15065070000001 2022-01-29 04:21:10 Voronezh Oblast, Russia
3810198 3810198 2022-01-28 Russia Yamalo-Nenets Autonomous Okrug     68441 979 0   67.1471631 74.3415488 2022-01-29 04:21:10 Yamalo-Nenets Autonomous Okrug, Russia
3810199 3810199 2022-01-28 Russia Yaroslavl Oblast     92084 2075 0   57.77819760000001 39.002109499999996 2022-01-29 04:21:10 Yaroslavl Oblast, Russia
3810200 3810200 2022-01-28 Russia Zabaykalsky Krai     100344 2026 0   52.248521000000004 115.956325 2022-01-29 04:21:10 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]);