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-12-26 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
3605257 3605257 2021-12-25 Russia Adygea Republic     26766 718 0   44.6939006 40.1520421 2021-12-26 04:21:50 Adygea Republic, Russia
3605258 3605258 2021-12-25 Russia Altai Krai     116730 6428 0   52.693224300000004 82.69314240000001 2021-12-26 04:21:50 Altai Krai, Russia
3605259 3605259 2021-12-25 Russia Altai Republic     25149 504 0   50.7114101 86.8572186 2021-12-26 04:21:50 Altai Republic, Russia
3605260 3605260 2021-12-25 Russia Amur Oblast     52987 596 0   52.8032368 128.437295 2021-12-26 04:21:50 Amur Oblast, Russia
3605261 3605261 2021-12-25 Russia Arkhangelsk Oblast     121851 1495 0   63.5589686 43.1221646 2021-12-26 04:21:50 Arkhangelsk Oblast, Russia
3605262 3605262 2021-12-25 Russia Astrakhan Oblast     80000 2358 0   47.1878186 47.608851 2021-12-26 04:21:50 Astrakhan Oblast, Russia
3605263 3605263 2021-12-25 Russia Bashkortostan Republic     119941 4275 0   54.8573563 57.1439682 2021-12-26 04:21:50 Bashkortostan Republic, Russia
3605264 3605264 2021-12-25 Russia Belgorod Oblast     80359 1708 0   50.7080119 37.5837615 2021-12-26 04:21:50 Belgorod Oblast, Russia
3605265 3605265 2021-12-25 Russia Bryansk Oblast     95265 2796 0   52.887331499999995 33.41585300000001 2021-12-26 04:21:50 Bryansk Oblast, Russia
3605266 3605266 2021-12-25 Russia Buryatia Republic     75171 2372 0   52.718242599999996 109.492143 2021-12-26 04:21:50 Buryatia Republic, Russia
3605267 3605267 2021-12-25 Russia Chechen Republic     30531 914 0   43.39761470000001 45.6985005 2021-12-26 04:21:50 Chechen Republic, Russia
3605268 3605268 2021-12-25 Russia Chelyabinsk Oblast     142153 5868 0   54.4223954 61.1865846 2021-12-26 04:21:50 Chelyabinsk Oblast, Russia
3605269 3605269 2021-12-25 Russia Chukotka Autonomous Okrug     2950 33 0   66.0006475 169.4900869 2021-12-26 04:21:50 Chukotka Autonomous Okrug, Russia
3605270 3605270 2021-12-25 Russia Chuvashia Republic     46095 3771 0   55.4259922 47.0849429 2021-12-26 04:21:50 Chuvashia Republic, Russia
3605271 3605271 2021-12-25 Russia Dagestan Republic     65179 3156 0   43.05749160000001 47.1332224 2021-12-26 04:21:50 Dagestan Republic, Russia
3605272 3605272 2021-12-25 Russia Ingushetia Republic     28205 470 0   43.11542075 45.01713552 2021-12-26 04:21:50 Ingushetia Republic, Russia
3605273 3605273 2021-12-25 Russia Irkutsk Oblast     153509 6816 0   56.6370122 104.71922099999999 2021-12-26 04:21:50 Irkutsk Oblast, Russia
3605274 3605274 2021-12-25 Russia Ivanovo Oblast     66969 2443 0   56.9167446 41.43521370000001 2021-12-26 04:21:50 Ivanovo Oblast, Russia
3605275 3605275 2021-12-25 Russia Jewish Autonomous Okrug     11428 404 0   48.57527615 132.66307460000002 2021-12-26 04:21:50 Jewish Autonomous Okrug, Russia
3605276 3605276 2021-12-25 Russia Kabardino-Balkarian Republic     41407 1395 0   43.480604799999995 43.5978976 2021-12-26 04:21:50 Kabardino-Balkarian Republic, Russia
3605277 3605277 2021-12-25 Russia Kaliningrad Oblast     81066 1225 0   54.7293041 21.1489473 2021-12-26 04:21:50 Kaliningrad Oblast, Russia
3605278 3605278 2021-12-25 Russia Kalmykia Republic     33913 724 0   46.2313018 45.3275745 2021-12-26 04:21:50 Kalmykia Republic, Russia
3605279 3605279 2021-12-25 Russia Kaluga Oblast     64179 1179 0   54.438277299999996 35.5272854 2021-12-26 04:21:50 Kaluga Oblast, Russia
3605280 3605280 2021-12-25 Russia Kamchatka Krai     23610 505 0   57.191488199999995 160.03838190000005 2021-12-26 04:21:50 Kamchatka Krai, Russia
3605281 3605281 2021-12-25 Russia Karachay-Cherkess Republic     31853 901 0   43.7368326 41.7267991 2021-12-26 04:21:50 Karachay-Cherkess Republic, Russia
3605282 3605282 2021-12-25 Russia Karelia Republic     88854 1173 0   62.61940309999999 33.4920267 2021-12-26 04:21:50 Karelia Republic, Russia
3605283 3605283 2021-12-25 Russia Kemerovo Oblast     82947 1685 0   54.53357809999999 87.342861 2021-12-26 04:21:50 Kemerovo Oblast, Russia
3605284 3605284 2021-12-25 Russia Khabarovsk Krai     122487 1207 0   51.6312684 136.121524 2021-12-26 04:21:50 Khabarovsk Krai, Russia
3605285 3605285 2021-12-25 Russia Khakassia Republic     53221 1920 0   53.72258845 91.44293627 2021-12-26 04:21:50 Khakassia Republic, Russia
3605286 3605286 2021-12-25 Russia Khanty-Mansi Autonomous Okrug     94847 1946 0   61.0259025 69.0982628 2021-12-26 04:21:50 Khanty-Mansi Autonomous Okrug, Russia
3605287 3605287 2021-12-25 Russia Kirov Oblast     77655 736 0   57.9665589 49.4074599 2021-12-26 04:21:50 Kirov Oblast, Russia
3605288 3605288 2021-12-25 Russia Komi Republic     96204 2562 0   63.9881421 54.3326073 2021-12-26 04:21:50 Komi Republic, Russia
3605289 3605289 2021-12-25 Russia Kostroma Oblast     48373 1087 0   58.424756 44.253327299999995 2021-12-26 04:21:50 Kostroma Oblast, Russia
3605290 3605290 2021-12-25 Russia Krasnodar Krai     115921 9630 0   45.768401399999995 39.0261044 2021-12-26 04:21:50 Krasnodar Krai, Russia
3605291 3605291 2021-12-25 Russia Krasnoyarsk Krai     169908 8393 0   63.3233807 97.09799740000001 2021-12-26 04:21:50 Krasnoyarsk Krai, Russia
3605292 3605292 2021-12-25 Russia Kurgan Oblast     49616 982 0   55.7655302 64.5632681 2021-12-26 04:21:50 Kurgan Oblast, Russia
3605293 3605293 2021-12-25 Russia Kursk Oblast     81294 1988 0   51.6568453 36.4852695 2021-12-26 04:21:50 Kursk Oblast, Russia
3605294 3605294 2021-12-25 Russia Leningrad Oblast     99548 2974 0   60.185329599999996 32.3925325 2021-12-26 04:21:50 Leningrad Oblast, Russia
3605295 3605295 2021-12-25 Russia Lipetsk Oblast     82908 2735 0   52.693517799999995 39.112266399999996 2021-12-26 04:21:50 Lipetsk Oblast, Russia
3605296 3605296 2021-12-25 Russia Magadan Oblast     13551 343 0   62.48858785 153.9903764 2021-12-26 04:21:50 Magadan Oblast, Russia
3605297 3605297 2021-12-25 Russia Mari El Republic     29062 920 0   56.576750399999995 47.881751200000004 2021-12-26 04:21:50 Mari El Republic, Russia
3605298 3605298 2021-12-25 Russia Mordovia Republic     39929 1002 0   54.4419829 44.466114399999995 2021-12-26 04:21:50 Mordovia Republic, Russia
3605299 3605299 2021-12-25 Russia Moscow     2017422 36349 0   55.7504461 37.6174943 2021-12-26 04:21:50 Moscow, Russia
3605300 3605300 2021-12-25 Russia Moscow Oblast     633173 11813 0   55.50431579999999 38.0353929 2021-12-26 04:21:50 Moscow Oblast, Russia
3605301 3605301 2021-12-25 Russia Murmansk Oblast     90908 2737 0   68.00004179999999 33.9999151 2021-12-26 04:21:50 Murmansk Oblast, Russia
3605302 3605302 2021-12-25 Russia Nenets Autonomous Okrug     3473 85 0   68.27557185 57.1686375 2021-12-26 04:21:50 Nenets Autonomous Okrug, Russia
3605303 3605303 2021-12-25 Russia Nizhny Novgorod Oblast     229324 9652 0   55.47180329999999 44.091159399999995 2021-12-26 04:21:50 Nizhny Novgorod Oblast, Russia
3605304 3605304 2021-12-25 Russia North Ossetia - Alania Republic     30517 929 0   42.79336110000001 44.6324493 2021-12-26 04:21:50 North Ossetia - Alania Republic, Russia
3605305 3605305 2021-12-25 Russia Novgorod Oblast     64423 744 0   58.2843833 32.516975699999996 2021-12-26 04:21:50 Novgorod Oblast, Russia
3605306 3605306 2021-12-25 Russia Novosibirsk Oblast     92439 4151 0   54.9720169 79.48139240000002 2021-12-26 04:21:50 Novosibirsk Oblast, Russia
3605307 3605307 2021-12-25 Russia Omsk Oblast     128098 3107 0   56.09352629999999 73.5099936 2021-12-26 04:21:50 Omsk Oblast, Russia
3605308 3605308 2021-12-25 Russia Orel Oblast     69418 1455 0   52.96854329999999 36.0692477 2021-12-26 04:21:50 Orel Oblast, Russia
3605309 3605309 2021-12-25 Russia Orenburg Oblast     107092 3402 0   52.02692620000001 54.7276647 2021-12-26 04:21:50 Orenburg Oblast, Russia
3605310 3605310 2021-12-25 Russia Penza Oblast     100215 4571 0   53.1655415 44.78791810000001 2021-12-26 04:21:50 Penza Oblast, Russia
3605311 3605311 2021-12-25 Russia Perm Krai     157198 7352 0   58.5951603 56.3159546 2021-12-26 04:21:50 Perm Krai, Russia
3605312 3605312 2021-12-25 Russia Primorsky Krai     99438 1518 0   45.0819456 134.726645 2021-12-26 04:21:50 Primorsky Krai, Russia
3605313 3605313 2021-12-25 Russia Pskov Oblast     70365 1225 0   57.535872899999994 28.8586826 2021-12-26 04:21:50 Pskov Oblast, Russia
3605314 3605314 2021-12-25 Russia Rostov Oblast     191144 9466 0   47.6222451 40.7957942 2021-12-26 04:21:50 Rostov Oblast, Russia
3605315 3605315 2021-12-25 Russia Ryazan Oblast     60632 2436 0   54.42267320000001 40.57052460000001 2021-12-26 04:21:50 Ryazan Oblast, Russia
3605316 3605316 2021-12-25 Russia Saint Petersburg     841834 27681 0   59.960673899999996 30.158655100000004 2021-12-26 04:21:50 Saint Petersburg, Russia
3605317 3605317 2021-12-25 Russia Sakha (Yakutiya) Republic     75441 1770 0   66.941626 129.642371 2021-12-26 04:21:50 Sakha (Yakutiya) Republic, Russia
3605318 3605318 2021-12-25 Russia Sakhalin Oblast     41394 514 0   49.7219665 143.448533 2021-12-26 04:21:50 Sakhalin Oblast, Russia
3605319 3605319 2021-12-25 Russia Samara Oblast     197413 6168 0   53.2128813 50.8914633 2021-12-26 04:21:50 Samara Oblast, Russia
3605320 3605320 2021-12-25 Russia Saratov Oblast     131244 4978 0   51.652055499999996 46.86319520000001 2021-12-26 04:21:50 Saratov Oblast, Russia
3605321 3605321 2021-12-25 Russia Smolensk Oblast     83877 2324 0   55.03434960000001 33.0192065 2021-12-26 04:21:50 Smolensk Oblast, Russia
3605322 3605322 2021-12-25 Russia Stavropol Krai     124093 5955 0   44.86325770000001 43.4406913 2021-12-26 04:21:50 Stavropol Krai, Russia
3605323 3605323 2021-12-25 Russia Sverdlovsk Oblast     195399 9239 0   58.6414755 61.802154599999994 2021-12-26 04:21:50 Sverdlovsk Oblast, Russia
3605324 3605324 2021-12-25 Russia Tambov Oblast     59891 1659 0   52.9019574 41.3578918 2021-12-26 04:21:50 Tambov Oblast, Russia
3605325 3605325 2021-12-25 Russia Tatarstan Republic     42162 1405 0   55.7648572 52.43104273 2021-12-26 04:21:50 Tatarstan Republic, Russia
3605326 3605326 2021-12-25 Russia Tomsk Oblast     60971 666 0   58.6124279 82.04753149999998 2021-12-26 04:21:50 Tomsk Oblast, Russia
3605327 3605327 2021-12-25 Russia Tula Oblast     73848 4183 0   53.9570701 37.369090899999996 2021-12-26 04:21:50 Tula Oblast, Russia
3605328 3605328 2021-12-25 Russia Tver Oblast     97043 2314 0   57.1134475 35.174442799999994 2021-12-26 04:21:50 Tver Oblast, Russia
3605329 3605329 2021-12-25 Russia Tyumen Oblast     88432 3302 0   58.8206488 70.36588370000001 2021-12-26 04:21:50 Tyumen Oblast, Russia
3605330 3605330 2021-12-25 Russia Tyva Republic     31480 317 0   51.401714899999995 93.8582593 2021-12-26 04:21:50 Tyva Republic, Russia
3605331 3605331 2021-12-25 Russia Udmurt Republic     78586 3211 0   57.1961165 52.69598320000001 2021-12-26 04:21:50 Udmurt Republic, Russia
3605332 3605332 2021-12-25 Russia Ulyanovsk Oblast     119151 3693 0   54.146317700000004 47.2324921 2021-12-26 04:21:50 Ulyanovsk Oblast, Russia
3605333 3605333 2021-12-25 Russia Vladimir Oblast     79797 2906 0   56.0503336 40.656163299999996 2021-12-26 04:21:50 Vladimir Oblast, Russia
3605334 3605334 2021-12-25 Russia Volgograd Oblast     127522 5414 0   49.604833899999996 44.29035820000001 2021-12-26 04:21:50 Volgograd Oblast, Russia
3605335 3605335 2021-12-25 Russia Vologda Oblast     98628 2903 0   60.0391461 43.1215213 2021-12-26 04:21:50 Vologda Oblast, Russia
3605336 3605336 2021-12-25 Russia Voronezh Oblast     192088 6752 0   50.9800393 40.15065070000001 2021-12-26 04:21:50 Voronezh Oblast, Russia
3605337 3605337 2021-12-25 Russia Yamalo-Nenets Autonomous Okrug     61458 946 0   67.1471631 74.3415488 2021-12-26 04:21:50 Yamalo-Nenets Autonomous Okrug, Russia
3605338 3605338 2021-12-25 Russia Yaroslavl Oblast     84118 1806 0   57.77819760000001 39.002109499999996 2021-12-26 04:21:50 Yaroslavl Oblast, Russia
3605339 3605339 2021-12-25 Russia Zabaykalsky Krai     94982 1788 0   52.248521000000004 115.956325 2021-12-26 04:21:50 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]);