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-05-21 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
1169385 1169385 2022-05-20 Russia Adygea Republic     49353 1000 0   44.6939006 40.1520421 2022-05-21 04:20:58 Adygea Republic, Russia
1169386 1169386 2022-05-20 Russia Altai Krai     268054 8632 0   52.6932243 82.6931424 2022-05-21 04:20:58 Altai Krai, Russia
1169387 1169387 2022-05-20 Russia Altai Republic     34317 614 0   50.7114101 86.8572186 2022-05-21 04:20:58 Altai Republic, Russia
1169388 1169388 2022-05-20 Russia Amur Oblast     107442 764 0   52.8032368 128.437295 2022-05-21 04:20:58 Amur Oblast, Russia
1169389 1169389 2022-05-20 Russia Arkhangelsk Oblast     229669 1760 0   63.5589686 43.1221646 2022-05-21 04:20:58 Arkhangelsk Oblast, Russia
1169390 1169390 2022-05-20 Russia Astrakhan Oblast     116746 3004 0   47.1878186 47.608851 2022-05-21 04:20:58 Astrakhan Oblast, Russia
1169391 1169391 2022-05-20 Russia Bashkortostan Republic     287586 5655 0   54.8573563 57.1439682 2022-05-21 04:20:58 Bashkortostan Republic, Russia
1169392 1169392 2022-05-20 Russia Belgorod Oblast     130525 2255 0   50.7080119 37.5837615 2022-05-21 04:20:58 Belgorod Oblast, Russia
1169393 1169393 2022-05-20 Russia Bryansk Oblast     161667 4010 0   52.8873315 33.415853 2022-05-21 04:20:58 Bryansk Oblast, Russia
1169394 1169394 2022-05-20 Russia Buryatia Republic     136437 3023 0   52.7182426 109.492143 2022-05-21 04:20:58 Buryatia Republic, Russia
1169395 1169395 2022-05-20 Russia Chechen Republic     43593 1076 0   43.3976147 45.6985005 2022-05-21 04:20:58 Chechen Republic, Russia
1169396 1169396 2022-05-20 Russia Chelyabinsk Oblast     329322 7658 0   54.4223954 61.1865846 2022-05-21 04:20:58 Chelyabinsk Oblast, Russia
1169397 1169397 2022-05-20 Russia Chukotka Autonomous Okrug     5680 42 0   66.0006475 169.4900869 2022-05-21 04:20:58 Chukotka Autonomous Okrug, Russia
1169398 1169398 2022-05-20 Russia Chuvashia Republic     79505 4633 0   55.4259922 47.0849429 2022-05-21 04:20:58 Chuvashia Republic, Russia
1169399 1169399 2022-05-20 Russia Dagestan Republic     93138 3593 0   43.0574916 47.1332224 2022-05-21 04:20:58 Dagestan Republic, Russia
1169400 1169400 2022-05-20 Russia Ingushetia Republic     40886 550 0   43.11542075 45.01713552 2022-05-21 04:20:58 Ingushetia Republic, Russia
1169401 1169401 2022-05-20 Russia Irkutsk Oblast     293147 8450 0   56.6370122 104.719221 2022-05-21 04:20:58 Irkutsk Oblast, Russia
1169402 1169402 2022-05-20 Russia Ivanovo Oblast     111211 3109 0   56.9167446 41.4352137 2022-05-21 04:20:58 Ivanovo Oblast, Russia
1169403 1169403 2022-05-20 Russia Jewish Autonomous Okrug     18725 544 0   48.57527615 132.6630746 2022-05-21 04:20:58 Jewish Autonomous Okrug, Russia
1169404 1169404 2022-05-20 Russia Kabardino-Balkarian Republic     61833 1871 0   43.4806048 43.5978976 2022-05-21 04:20:58 Kabardino-Balkarian Republic, Russia
1169405 1169405 2022-05-20 Russia Kaliningrad Oblast     168566 1908 0   54.7293041 21.1489473 2022-05-21 04:20:58 Kaliningrad Oblast, Russia
1169406 1169406 2022-05-20 Russia Kalmykia Republic     51451 842 0   46.2313018 45.3275745 2022-05-21 04:20:58 Kalmykia Republic, Russia
1169407 1169407 2022-05-20 Russia Kaluga Oblast     103711 1453 0   54.4382773 35.5272854 2022-05-21 04:20:58 Kaluga Oblast, Russia
1169408 1169408 2022-05-20 Russia Kamchatka Krai     39820 615 0   57.1914882 160.0383819 2022-05-21 04:20:58 Kamchatka Krai, Russia
1169409 1169409 2022-05-20 Russia Karachay-Cherkess Republic     45980 984 0   43.7368326 41.7267991 2022-05-21 04:20:58 Karachay-Cherkess Republic, Russia
1169410 1169410 2022-05-20 Russia Karelia Republic     135061 1506 0   62.6194031 33.4920267 2022-05-21 04:20:58 Karelia Republic, Russia
1169411 1169411 2022-05-20 Russia Kemerovo Oblast     163401 2354 0   54.5335781 87.342861 2022-05-21 04:20:58 Kemerovo Oblast, Russia
1169412 1169412 2022-05-20 Russia Khabarovsk Krai     201712 1549 0   51.6312684 136.121524 2022-05-21 04:20:58 Khabarovsk Krai, Russia
1169413 1169413 2022-05-20 Russia Khakassia Republic     87729 2409 0   53.72258845 91.44293627 2022-05-21 04:20:58 Khakassia Republic, Russia
1169414 1169414 2022-05-20 Russia Khanty-Mansi Autonomous Okrug     210349 2544 0   61.0259025 69.0982628 2022-05-21 04:20:58 Khanty-Mansi Autonomous Okrug, Russia
1169415 1169415 2022-05-20 Russia Kirov Oblast     151570 1041 0   57.9665589 49.4074599 2022-05-21 04:20:58 Kirov Oblast, Russia
1169416 1169416 2022-05-20 Russia Komi Republic     171510 3173 0   63.9881421 54.3326073 2022-05-21 04:20:58 Komi Republic, Russia
1169417 1169417 2022-05-20 Russia Kostroma Oblast     88892 1380 0   58.424756 44.2533273 2022-05-21 04:20:58 Kostroma Oblast, Russia
1169418 1169418 2022-05-20 Russia Krasnodar Krai     260112 10904 0   45.7684014 39.0261044 2022-05-21 04:20:58 Krasnodar Krai, Russia
1169419 1169419 2022-05-20 Russia Krasnoyarsk Krai     365231 10815 0   63.3233807 97.0979974 2022-05-21 04:20:58 Krasnoyarsk Krai, Russia
1169420 1169420 2022-05-20 Russia Kurgan Oblast     104310 1431 0   55.7655302 64.5632681 2022-05-21 04:20:58 Kurgan Oblast, Russia
1169421 1169421 2022-05-20 Russia Kursk Oblast     117894 2476 0   51.6568453 36.4852695 2022-05-21 04:20:58 Kursk Oblast, Russia
1169422 1169422 2022-05-20 Russia Leningrad Oblast     187140 3479 0   60.1853296 32.3925325 2022-05-21 04:20:58 Leningrad Oblast, Russia
1169423 1169423 2022-05-20 Russia Lipetsk Oblast     150806 3751 0   52.6935178 39.1122664 2022-05-21 04:20:58 Lipetsk Oblast, Russia
1169424 1169424 2022-05-20 Russia Magadan Oblast     19787 390 0   62.48858785 153.9903764 2022-05-21 04:20:58 Magadan Oblast, Russia
1169425 1169425 2022-05-20 Russia Mari El Republic     44583 1087 0   56.5767504 47.8817512 2022-05-21 04:20:58 Mari El Republic, Russia
1169426 1169426 2022-05-20 Russia Mordovia Republic     67838 1385 0   54.4419829 44.4661144 2022-05-21 04:20:58 Mordovia Republic, Russia
1169427 1169427 2022-05-20 Russia Moscow     2767561 43584 0   55.7504461 37.6174943 2022-05-21 04:20:58 Moscow, Russia
1169428 1169428 2022-05-20 Russia Moscow Oblast     973669 15069 0   55.5043158 38.0353929 2022-05-21 04:20:58 Moscow Oblast, Russia
1169429 1169429 2022-05-20 Russia Murmansk Oblast     134497 3321 0   68.0000418 33.9999151 2022-05-21 04:20:58 Murmansk Oblast, Russia
1169430 1169430 2022-05-20 Russia Nenets Autonomous Okrug     7357 100 0   68.27557185 57.1686375 2022-05-21 04:20:58 Nenets Autonomous Okrug, Russia
1169431 1169431 2022-05-20 Russia Nizhny Novgorod Oblast     419826 11502 0   55.4718033 44.0911594 2022-05-21 04:20:58 Nizhny Novgorod Oblast, Russia
1169432 1169432 2022-05-20 Russia North Ossetia - Alania Republic     40805 1252 0   42.7933611 44.6324493 2022-05-21 04:20:58 North Ossetia - Alania Republic, Russia
1169433 1169433 2022-05-20 Russia Novgorod Oblast     99576 1025 0   58.2843833 32.5169757 2022-05-21 04:20:58 Novgorod Oblast, Russia
1169434 1169434 2022-05-20 Russia Novosibirsk Oblast     257883 5651 0   54.9720169 79.4813924 2022-05-21 04:20:58 Novosibirsk Oblast, Russia
1169435 1169435 2022-05-20 Russia Omsk Oblast     207132 4376 0   56.0935263 73.5099936 2022-05-21 04:20:58 Omsk Oblast, Russia
1169436 1169436 2022-05-20 Russia Orel Oblast     112509 1918 0   52.9685433 36.0692477 2022-05-21 04:20:58 Orel Oblast, Russia
1169437 1169437 2022-05-20 Russia Orenburg Oblast     216115 3996 0   52.0269262 54.7276647 2022-05-21 04:20:58 Orenburg Oblast, Russia
1169438 1169438 2022-05-20 Russia Penza Oblast     186295 5875 0   53.1655415 44.7879181 2022-05-21 04:20:58 Penza Oblast, Russia
1169439 1169439 2022-05-20 Russia Perm Krai     369062 8785 0   58.5951603 56.3159546 2022-05-21 04:20:58 Perm Krai, Russia
1169440 1169440 2022-05-20 Russia Primorsky Krai     174829 1960 0   45.0819456 134.726645 2022-05-21 04:20:58 Primorsky Krai, Russia
1169441 1169441 2022-05-20 Russia Pskov Oblast     110288 1839 0   57.5358729 28.8586826 2022-05-21 04:20:58 Pskov Oblast, Russia
1169442 1169442 2022-05-20 Russia Rostov Oblast     375118 10915 0   47.6222451 40.7957942 2022-05-21 04:20:58 Rostov Oblast, Russia
1169443 1169443 2022-05-20 Russia Ryazan Oblast     120686 3373 0   54.4226732 40.5705246 2022-05-21 04:20:58 Ryazan Oblast, Russia
1169444 1169444 2022-05-20 Russia Saint Petersburg     1526265 33726 0   59.9606739 30.1586551 2022-05-21 04:20:58 Saint Petersburg, Russia
1169445 1169445 2022-05-20 Russia Sakha (Yakutiya) Republic     179721 2114 0   66.941626 129.642371 2022-05-21 04:20:58 Sakha (Yakutiya) Republic, Russia
1169446 1169446 2022-05-20 Russia Sakhalin Oblast     64767 826 0   49.7219665 143.448533 2022-05-21 04:20:58 Sakhalin Oblast, Russia
1169447 1169447 2022-05-20 Russia Samara Oblast     383339 7852 0   53.2128813 50.8914633 2022-05-21 04:20:58 Samara Oblast, Russia
1169448 1169448 2022-05-20 Russia Saratov Oblast     251127 5959 0   51.6520555 46.8631952 2022-05-21 04:20:58 Saratov Oblast, Russia
1169449 1169449 2022-05-20 Russia Smolensk Oblast     130911 3050 0   55.0343496 33.0192065 2022-05-21 04:20:58 Smolensk Oblast, Russia
1169450 1169450 2022-05-20 Russia Stavropol Krai     197174 7054 0   44.8632577 43.4406913 2022-05-21 04:20:58 Stavropol Krai, Russia
1169451 1169451 2022-05-20 Russia Sverdlovsk Oblast     442966 10739 0   58.6414755 61.8021546 2022-05-21 04:20:58 Sverdlovsk Oblast, Russia
1169452 1169452 2022-05-20 Russia Tambov Oblast     116556 2407 0   52.9019574 41.3578918 2022-05-21 04:20:58 Tambov Oblast, Russia
1169453 1169453 2022-05-20 Russia Tatarstan Republic     148484 1993 0   55.7648572 52.43104273 2022-05-21 04:20:58 Tatarstan Republic, Russia
1169454 1169454 2022-05-20 Russia Tomsk Oblast     131060 835 0   58.6124279 82.0475315 2022-05-21 04:20:58 Tomsk Oblast, Russia
1169455 1169455 2022-05-20 Russia Tula Oblast     156165 5189 0   53.9570701 37.3690909 2022-05-21 04:20:58 Tula Oblast, Russia
1169456 1169456 2022-05-20 Russia Tver Oblast     162180 2739 0   57.1134475 35.1744428 2022-05-21 04:20:58 Tver Oblast, Russia
1169457 1169457 2022-05-20 Russia Tyumen Oblast     191511 4321 0   58.8206488 70.3658837 2022-05-21 04:20:58 Tyumen Oblast, Russia
1169458 1169458 2022-05-20 Russia Tyva Republic     44445 351 0   51.4017149 93.8582593 2022-05-21 04:20:58 Tyva Republic, Russia
1169459 1169459 2022-05-20 Russia Udmurt Republic     166584 3835 0   57.1961165 52.6959832 2022-05-21 04:20:58 Udmurt Republic, Russia
1169460 1169460 2022-05-20 Russia Ulyanovsk Oblast     202532 4675 0   54.1463177 47.2324921 2022-05-21 04:20:58 Ulyanovsk Oblast, Russia
1169461 1169461 2022-05-20 Russia Vladimir Oblast     151315 3458 0   56.0503336 40.6561633 2022-05-21 04:20:58 Vladimir Oblast, Russia
1169462 1169462 2022-05-20 Russia Volgograd Oblast     219930 6875 0   49.6048339 44.2903582 2022-05-21 04:20:58 Volgograd Oblast, Russia
1169463 1169463 2022-05-20 Russia Vologda Oblast     190565 3828 0   60.0391461 43.1215213 2022-05-21 04:20:58 Vologda Oblast, Russia
1169464 1169464 2022-05-20 Russia Voronezh Oblast     383533 8281 0   50.9800393 40.1506507 2022-05-21 04:20:58 Voronezh Oblast, Russia
1169465 1169465 2022-05-20 Russia Yamalo-Nenets Autonomous Okrug     136925 1041 0   67.1471631 74.3415488 2022-05-21 04:20:58 Yamalo-Nenets Autonomous Okrug, Russia
1169466 1169466 2022-05-20 Russia Yaroslavl Oblast     160902 2793 0   57.7781976 39.0021095 2022-05-21 04:20:58 Yaroslavl Oblast, Russia
1169467 1169467 2022-05-20 Russia Zabaykalsky Krai     168585 2341 0   52.248521 115.956325 2022-05-21 04:20:58 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]);