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-03-12 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
356512 356512 2022-03-11 Russia Adygea Republic     46414 934 0   44.6939006 40.1520421 2022-03-12 04:20:50 Adygea Republic, Russia
356513 356513 2022-03-11 Russia Altai Krai     251755 8213 0   52.693224300000004 82.69314240000001 2022-03-12 04:20:50 Altai Krai, Russia
356514 356514 2022-03-11 Russia Altai Republic     32822 588 0   50.7114101 86.8572186 2022-03-12 04:20:50 Altai Republic, Russia
356515 356515 2022-03-11 Russia Amur Oblast     98102 728 0   52.8032368 128.437295 2022-03-12 04:20:50 Amur Oblast, Russia
356516 356516 2022-03-11 Russia Arkhangelsk Oblast     219913 1596 0   63.5589686 43.1221646 2022-03-12 04:20:50 Arkhangelsk Oblast, Russia
356517 356517 2022-03-11 Russia Astrakhan Oblast     112606 2879 0   47.1878186 47.608851 2022-03-12 04:20:50 Astrakhan Oblast, Russia
356518 356518 2022-03-11 Russia Bashkortostan Republic     256447 5381 0   54.8573563 57.1439682 2022-03-12 04:20:50 Bashkortostan Republic, Russia
356519 356519 2022-03-11 Russia Belgorod Oblast     121189 2078 0   50.7080119 37.5837615 2022-03-12 04:20:50 Belgorod Oblast, Russia
356520 356520 2022-03-11 Russia Bryansk Oblast     151876 3595 0   52.887331499999995 33.41585300000001 2022-03-12 04:20:50 Bryansk Oblast, Russia
356521 356521 2022-03-11 Russia Buryatia Republic     130101 2909 0   52.718242599999996 109.492143 2022-03-12 04:20:50 Buryatia Republic, Russia
356522 356522 2022-03-11 Russia Chechen Republic     42533 1073 0   43.39761470000001 45.6985005 2022-03-12 04:20:50 Chechen Republic, Russia
356523 356523 2022-03-11 Russia Chelyabinsk Oblast     303188 7141 0   54.4223954 61.1865846 2022-03-12 04:20:50 Chelyabinsk Oblast, Russia
356524 356524 2022-03-11 Russia Chukotka Autonomous Okrug     5229 41 0   66.0006475 169.4900869 2022-03-12 04:20:50 Chukotka Autonomous Okrug, Russia
356525 356525 2022-03-11 Russia Chuvashia Republic     75011 4479 0   55.4259922 47.0849429 2022-03-12 04:20:50 Chuvashia Republic, Russia
356526 356526 2022-03-11 Russia Dagestan Republic     90800 3559 0   43.05749160000001 47.1332224 2022-03-12 04:20:50 Dagestan Republic, Russia
356527 356527 2022-03-11 Russia Ingushetia Republic     39703 546 0   43.11542075 45.01713552 2022-03-12 04:20:50 Ingushetia Republic, Russia
356528 356528 2022-03-11 Russia Irkutsk Oblast     265832 8013 0   56.6370122 104.71922099999999 2022-03-12 04:20:50 Irkutsk Oblast, Russia
356529 356529 2022-03-11 Russia Ivanovo Oblast     103715 2923 0   56.9167446 41.43521370000001 2022-03-12 04:20:50 Ivanovo Oblast, Russia
356530 356530 2022-03-11 Russia Jewish Autonomous Okrug     16405 488 0   48.57527615 132.66307460000002 2022-03-12 04:20:50 Jewish Autonomous Okrug, Russia
356531 356531 2022-03-11 Russia Kabardino-Balkarian Republic     59636 1796 0   43.480604799999995 43.5978976 2022-03-12 04:20:50 Kabardino-Balkarian Republic, Russia
356532 356532 2022-03-11 Russia Kaliningrad Oblast     156572 1678 0   54.7293041 21.1489473 2022-03-12 04:20:50 Kaliningrad Oblast, Russia
356533 356533 2022-03-11 Russia Kalmykia Republic     48388 822 0   46.2313018 45.3275745 2022-03-12 04:20:50 Kalmykia Republic, Russia
356534 356534 2022-03-11 Russia Kaluga Oblast     98191 1374 0   54.438277299999996 35.5272854 2022-03-12 04:20:50 Kaluga Oblast, Russia
356535 356535 2022-03-11 Russia Kamchatka Krai     38174 603 0   57.191488199999995 160.03838190000005 2022-03-12 04:20:50 Kamchatka Krai, Russia
356536 356536 2022-03-11 Russia Karachay-Cherkess Republic     44455 977 0   43.7368326 41.7267991 2022-03-12 04:20:50 Karachay-Cherkess Republic, Russia
356537 356537 2022-03-11 Russia Karelia Republic     128722 1420 0   62.61940309999999 33.4920267 2022-03-12 04:20:50 Karelia Republic, Russia
356538 356538 2022-03-11 Russia Kemerovo Oblast     151112 2181 0   54.53357809999999 87.342861 2022-03-12 04:20:50 Kemerovo Oblast, Russia
356539 356539 2022-03-11 Russia Khabarovsk Krai     186602 1465 0   51.6312684 136.121524 2022-03-12 04:20:50 Khabarovsk Krai, Russia
356540 356540 2022-03-11 Russia Khakassia Republic     85332 2285 0   53.72258845 91.44293627 2022-03-12 04:20:50 Khakassia Republic, Russia
356541 356541 2022-03-11 Russia Khanty-Mansi Autonomous Okrug     201144 2448 0   61.0259025 69.0982628 2022-03-12 04:20:50 Khanty-Mansi Autonomous Okrug, Russia
356542 356542 2022-03-11 Russia Kirov Oblast     145556 912 0   57.9665589 49.4074599 2022-03-12 04:20:50 Kirov Oblast, Russia
356543 356543 2022-03-11 Russia Komi Republic     163953 2984 0   63.9881421 54.3326073 2022-03-12 04:20:50 Komi Republic, Russia
356544 356544 2022-03-11 Russia Kostroma Oblast     84256 1255 0   58.424756 44.253327299999995 2022-03-12 04:20:50 Kostroma Oblast, Russia
356545 356545 2022-03-11 Russia Krasnodar Krai     238317 10519 0   45.768401399999995 39.0261044 2022-03-12 04:20:50 Krasnodar Krai, Russia
356546 356546 2022-03-11 Russia Krasnoyarsk Krai     352046 10207 0   63.3233807 97.09799740000001 2022-03-12 04:20:50 Krasnoyarsk Krai, Russia
356547 356547 2022-03-11 Russia Kurgan Oblast     95206 1269 0   55.7655302 64.5632681 2022-03-12 04:20:50 Kurgan Oblast, Russia
356548 356548 2022-03-11 Russia Kursk Oblast     109896 2323 0   51.6568453 36.4852695 2022-03-12 04:20:50 Kursk Oblast, Russia
356549 356549 2022-03-11 Russia Leningrad Oblast     176395 3396 0   60.185329599999996 32.3925325 2022-03-12 04:20:50 Leningrad Oblast, Russia
356550 356550 2022-03-11 Russia Lipetsk Oblast     135273 3376 0   52.693517799999995 39.112266399999996 2022-03-12 04:20:50 Lipetsk Oblast, Russia
356551 356551 2022-03-11 Russia Magadan Oblast     19138 382 0   62.48858785 153.9903764 2022-03-12 04:20:50 Magadan Oblast, Russia
356552 356552 2022-03-11 Russia Mari El Republic     43809 1069 0   56.576750399999995 47.881751200000004 2022-03-12 04:20:50 Mari El Republic, Russia
356553 356553 2022-03-11 Russia Mordovia Republic     62476 1298 0   54.4419829 44.466114399999995 2022-03-12 04:20:50 Mordovia Republic, Russia
356554 356554 2022-03-11 Russia Moscow     2718243 42060 0   55.7504461 37.6174943 2022-03-12 04:20:50 Moscow, Russia
356555 356555 2022-03-11 Russia Moscow Oblast     949506 14448 0   55.50431579999999 38.0353929 2022-03-12 04:20:50 Moscow Oblast, Russia
356556 356556 2022-03-11 Russia Murmansk Oblast     130416 3160 0   68.00004179999999 33.9999151 2022-03-12 04:20:50 Murmansk Oblast, Russia
356557 356557 2022-03-11 Russia Nenets Autonomous Okrug     6993 96 0   68.27557185 57.1686375 2022-03-12 04:20:50 Nenets Autonomous Okrug, Russia
356558 356558 2022-03-11 Russia Nizhny Novgorod Oblast     389584 11224 0   55.47180329999999 44.091159399999995 2022-03-12 04:20:50 Nizhny Novgorod Oblast, Russia
356559 356559 2022-03-11 Russia North Ossetia - Alania Republic     39637 1226 0   42.79336110000001 44.6324493 2022-03-12 04:20:50 North Ossetia - Alania Republic, Russia
356560 356560 2022-03-11 Russia Novgorod Oblast     95054 969 0   58.2843833 32.516975699999996 2022-03-12 04:20:50 Novgorod Oblast, Russia
356561 356561 2022-03-11 Russia Novosibirsk Oblast     242829 5141 0   54.9720169 79.48139240000002 2022-03-12 04:20:50 Novosibirsk Oblast, Russia
356562 356562 2022-03-11 Russia Omsk Oblast     197078 3978 0   56.09352629999999 73.5099936 2022-03-12 04:20:50 Omsk Oblast, Russia
356563 356563 2022-03-11 Russia Orel Oblast     103515 1779 0   52.96854329999999 36.0692477 2022-03-12 04:20:50 Orel Oblast, Russia
356564 356564 2022-03-11 Russia Orenburg Oblast     200126 3780 0   52.02692620000001 54.7276647 2022-03-12 04:20:50 Orenburg Oblast, Russia
356565 356565 2022-03-11 Russia Penza Oblast     168782 5399 0   53.1655415 44.78791810000001 2022-03-12 04:20:50 Penza Oblast, Russia
356566 356566 2022-03-11 Russia Perm Krai     343790 8505 0   58.5951603 56.3159546 2022-03-12 04:20:50 Perm Krai, Russia
356567 356567 2022-03-11 Russia Primorsky Krai     163130 1846 0   45.0819456 134.726645 2022-03-12 04:20:50 Primorsky Krai, Russia
356568 356568 2022-03-11 Russia Pskov Oblast     103168 1638 0   57.535872899999994 28.8586826 2022-03-12 04:20:50 Pskov Oblast, Russia
356569 356569 2022-03-11 Russia Rostov Oblast     344313 10497 0   47.6222451 40.7957942 2022-03-12 04:20:50 Rostov Oblast, Russia
356570 356570 2022-03-11 Russia Ryazan Oblast     109226 3143 0   54.42267320000001 40.57052460000001 2022-03-12 04:20:50 Ryazan Oblast, Russia
356571 356571 2022-03-11 Russia Saint Petersburg     1472833 32547 0   59.960673899999996 30.158655100000004 2022-03-12 04:20:50 Saint Petersburg, Russia
356572 356572 2022-03-11 Russia Sakha (Yakutiya) Republic     165479 2050 0   66.941626 129.642371 2022-03-12 04:20:50 Sakha (Yakutiya) Republic, Russia
356573 356573 2022-03-11 Russia Sakhalin Oblast     62512 784 0   49.7219665 143.448533 2022-03-12 04:20:50 Sakhalin Oblast, Russia
356574 356574 2022-03-11 Russia Samara Oblast     359549 7268 0   53.2128813 50.8914633 2022-03-12 04:20:50 Samara Oblast, Russia
356575 356575 2022-03-11 Russia Saratov Oblast     224462 5728 0   51.652055499999996 46.86319520000001 2022-03-12 04:20:50 Saratov Oblast, Russia
356576 356576 2022-03-11 Russia Smolensk Oblast     123744 2836 0   55.03434960000001 33.0192065 2022-03-12 04:20:50 Smolensk Oblast, Russia
356577 356577 2022-03-11 Russia Stavropol Krai     188494 6886 0   44.86325770000001 43.4406913 2022-03-12 04:20:50 Stavropol Krai, Russia
356578 356578 2022-03-11 Russia Sverdlovsk Oblast     395616 10401 0   58.6414755 61.802154599999994 2022-03-12 04:20:50 Sverdlovsk Oblast, Russia
356579 356579 2022-03-11 Russia Tambov Oblast     105723 2267 0   52.9019574 41.3578918 2022-03-12 04:20:50 Tambov Oblast, Russia
356580 356580 2022-03-11 Russia Tatarstan Republic     129356 1777 0   55.7648572 52.43104273 2022-03-12 04:20:50 Tatarstan Republic, Russia
356581 356581 2022-03-11 Russia Tomsk Oblast     114521 762 0   58.6124279 82.04753149999998 2022-03-12 04:20:50 Tomsk Oblast, Russia
356582 356582 2022-03-11 Russia Tula Oblast     143804 4932 0   53.9570701 37.369090899999996 2022-03-12 04:20:50 Tula Oblast, Russia
356583 356583 2022-03-11 Russia Tver Oblast     152212 2623 0   57.1134475 35.174442799999994 2022-03-12 04:20:50 Tver Oblast, Russia
356584 356584 2022-03-11 Russia Tyumen Oblast     176494 4041 0   58.8206488 70.36588370000001 2022-03-12 04:20:50 Tyumen Oblast, Russia
356585 356585 2022-03-11 Russia Tyva Republic     44225 342 0   51.401714899999995 93.8582593 2022-03-12 04:20:50 Tyva Republic, Russia
356586 356586 2022-03-11 Russia Udmurt Republic     157642 3693 0   57.1961165 52.69598320000001 2022-03-12 04:20:50 Udmurt Republic, Russia
356587 356587 2022-03-11 Russia Ulyanovsk Oblast     183492 4449 0   54.146317700000004 47.2324921 2022-03-12 04:20:50 Ulyanovsk Oblast, Russia
356588 356588 2022-03-11 Russia Vladimir Oblast     142155 3273 0   56.0503336 40.656163299999996 2022-03-12 04:20:50 Vladimir Oblast, Russia
356589 356589 2022-03-11 Russia Volgograd Oblast     196904 6524 0   49.604833899999996 44.29035820000001 2022-03-12 04:20:50 Volgograd Oblast, Russia
356590 356590 2022-03-11 Russia Vologda Oblast     175559 3488 0   60.0391461 43.1215213 2022-03-12 04:20:50 Vologda Oblast, Russia
356591 356591 2022-03-11 Russia Voronezh Oblast     350254 7873 0   50.9800393 40.15065070000001 2022-03-12 04:20:50 Voronezh Oblast, Russia
356592 356592 2022-03-11 Russia Yamalo-Nenets Autonomous Okrug     131734 1019 0   67.1471631 74.3415488 2022-03-12 04:20:50 Yamalo-Nenets Autonomous Okrug, Russia
356593 356593 2022-03-11 Russia Yaroslavl Oblast     146515 2567 0   57.77819760000001 39.002109499999996 2022-03-12 04:20:50 Yaroslavl Oblast, Russia
356594 356594 2022-03-11 Russia Zabaykalsky Krai     156666 2215 0   52.248521000000004 115.956325 2022-03-12 04:20: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]);