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-12-24 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
690562 690562 2022-12-23 Russia Adygea Republic     54430 1026 0   44.6939006 40.1520421 2022-12-24 04:21:02 Adygea Republic, Russia
690563 690563 2022-12-23 Russia Altai Krai     315390 8848 0   52.6932243 82.6931424 2022-12-24 04:21:02 Altai Krai, Russia
690564 690564 2022-12-23 Russia Altai Republic     40037 630 0   50.7114101 86.8572186 2022-12-24 04:21:02 Altai Republic, Russia
690565 690565 2022-12-23 Russia Amur Oblast     126445 766 0   52.8032368 128.437295 2022-12-24 04:21:02 Amur Oblast, Russia
690566 690566 2022-12-23 Russia Arkhangelsk Oblast     271714 1791 0   63.5589686 43.1221646 2022-12-24 04:21:02 Arkhangelsk Oblast, Russia
690567 690567 2022-12-23 Russia Astrakhan Oblast     132699 3106 0   47.1878186 47.608851 2022-12-24 04:21:02 Astrakhan Oblast, Russia
690568 690568 2022-12-23 Russia Bashkortostan Republic     340902 5950 0   54.8573563 57.1439682 2022-12-24 04:21:02 Bashkortostan Republic, Russia
690569 690569 2022-12-23 Russia Belgorod Oblast     164467 2324 0   50.7080119 37.5837615 2022-12-24 04:21:02 Belgorod Oblast, Russia
690570 690570 2022-12-23 Russia Bryansk Oblast     184339 4132 0   52.8873315 33.415853 2022-12-24 04:21:02 Bryansk Oblast, Russia
690571 690571 2022-12-23 Russia Buryatia Republic     153552 3099 0   52.7182426 109.492143 2022-12-24 04:21:02 Buryatia Republic, Russia
690572 690572 2022-12-23 Russia Chechen Republic     46830 1076 0   43.3976147 45.6985005 2022-12-24 04:21:02 Chechen Republic, Russia
690573 690573 2022-12-23 Russia Chelyabinsk Oblast     394505 8181 0   54.4223954 61.1865846 2022-12-24 04:21:02 Chelyabinsk Oblast, Russia
690574 690574 2022-12-23 Russia Chukotka Autonomous Okrug     6870 45 0   66.0006475 169.4900869 2022-12-24 04:21:02 Chukotka Autonomous Okrug, Russia
690575 690575 2022-12-23 Russia Chuvashia Republic     106858 4694 0   55.4259922 47.0849429 2022-12-24 04:21:02 Chuvashia Republic, Russia
690576 690576 2022-12-23 Russia Dagestan Republic     102327 3619 0   43.0574916 47.1332224 2022-12-24 04:21:02 Dagestan Republic, Russia
690577 690577 2022-12-23 Russia Ingushetia Republic     43377 553 0   43.11542075 45.01713552 2022-12-24 04:21:02 Ingushetia Republic, Russia
690578 690578 2022-12-23 Russia Irkutsk Oblast     356582 8666 0   56.6370122 104.719221 2022-12-24 04:21:02 Irkutsk Oblast, Russia
690579 690579 2022-12-23 Russia Ivanovo Oblast     131237 3221 0   56.9167446 41.4352137 2022-12-24 04:21:02 Ivanovo Oblast, Russia
690580 690580 2022-12-23 Russia Jewish Autonomous Okrug     22242 562 0   48.57527615 132.6630746 2022-12-24 04:21:02 Jewish Autonomous Okrug, Russia
690581 690581 2022-12-23 Russia Kabardino-Balkarian Republic     73562 1923 0   43.4806048 43.5978976 2022-12-24 04:21:02 Kabardino-Balkarian Republic, Russia
690582 690582 2022-12-23 Russia Kaliningrad Oblast     192929 2031 0   54.7293041 21.1489473 2022-12-24 04:21:02 Kaliningrad Oblast, Russia
690583 690583 2022-12-23 Russia Kalmykia Republic     59289 843 0   46.2313018 45.3275745 2022-12-24 04:21:02 Kalmykia Republic, Russia
690584 690584 2022-12-23 Russia Kaluga Oblast     122250 1453 0   54.4382773 35.5272854 2022-12-24 04:21:02 Kaluga Oblast, Russia
690585 690585 2022-12-23 Russia Kamchatka Krai     44564 625 0   57.1914882 160.0383819 2022-12-24 04:21:02 Kamchatka Krai, Russia
690586 690586 2022-12-23 Russia Karachay-Cherkess Republic     51051 991 0   43.7368326 41.7267991 2022-12-24 04:21:02 Karachay-Cherkess Republic, Russia
690587 690587 2022-12-23 Russia Karelia Republic     162372 1526 0   62.6194031 33.4920267 2022-12-24 04:21:02 Karelia Republic, Russia
690588 690588 2022-12-23 Russia Kemerovo Oblast     212603 2838 0   54.5335781 87.342861 2022-12-24 04:21:02 Kemerovo Oblast, Russia
690589 690589 2022-12-23 Russia Khabarovsk Krai     225849 1565 0   51.6312684 136.121524 2022-12-24 04:21:02 Khabarovsk Krai, Russia
690590 690590 2022-12-23 Russia Khakassia Republic     103015 2425 0   53.72258845 91.44293627 2022-12-24 04:21:02 Khakassia Republic, Russia
690591 690591 2022-12-23 Russia Khanty-Mansi Autonomous Okrug     253139 2595 0   61.0259025 69.0982628 2022-12-24 04:21:02 Khanty-Mansi Autonomous Okrug, Russia
690592 690592 2022-12-23 Russia Kirov Oblast     165296 1094 0   57.9665589 49.4074599 2022-12-24 04:21:02 Kirov Oblast, Russia
690593 690593 2022-12-23 Russia Komi Republic     192300 3249 0   63.9881421 54.3326073 2022-12-24 04:21:02 Komi Republic, Russia
690594 690594 2022-12-23 Russia Kostroma Oblast     102734 1460 0   58.424756 44.2533273 2022-12-24 04:21:02 Kostroma Oblast, Russia
690595 690595 2022-12-23 Russia Krasnodar Krai     343563 11131 0   45.7684014 39.0261044 2022-12-24 04:21:02 Krasnodar Krai, Russia
690596 690596 2022-12-23 Russia Krasnoyarsk Krai     425843 11206 0   63.3233807 97.0979974 2022-12-24 04:21:02 Krasnoyarsk Krai, Russia
690597 690597 2022-12-23 Russia Kurgan Oblast     123549 1524 0   55.7655302 64.5632681 2022-12-24 04:21:02 Kurgan Oblast, Russia
690598 690598 2022-12-23 Russia Kursk Oblast     149901 2534 0   51.6568453 36.4852695 2022-12-24 04:21:02 Kursk Oblast, Russia
690599 690599 2022-12-23 Russia Leningrad Oblast     239885 3508 0   60.1853296 32.3925325 2022-12-24 04:21:02 Leningrad Oblast, Russia
690600 690600 2022-12-23 Russia Lipetsk Oblast     176133 3937 0   52.6935178 39.1122664 2022-12-24 04:21:02 Lipetsk Oblast, Russia
690601 690601 2022-12-23 Russia Magadan Oblast     22146 394 0   62.48858785 153.9903764 2022-12-24 04:21:02 Magadan Oblast, Russia
690602 690602 2022-12-23 Russia Mari El Republic     51246 1087 0   56.5767504 47.8817512 2022-12-24 04:21:02 Mari El Republic, Russia
690603 690603 2022-12-23 Russia Mordovia Republic     82927 1396 0   54.4419829 44.4661144 2022-12-24 04:21:02 Mordovia Republic, Russia
690604 690604 2022-12-23 Russia Moscow     3288969 47354 0   55.7504461 37.6174943 2022-12-24 04:21:02 Moscow, Russia
690605 690605 2022-12-23 Russia Moscow Oblast     1126831 15454 0   55.5043158 38.0353929 2022-12-24 04:21:02 Moscow Oblast, Russia
690606 690606 2022-12-23 Russia Murmansk Oblast     145430 3400 0   68.0000418 33.9999151 2022-12-24 04:21:02 Murmansk Oblast, Russia
690607 690607 2022-12-23 Russia Nenets Autonomous Okrug     8323 103 0   68.27557185 57.1686375 2022-12-24 04:21:02 Nenets Autonomous Okrug, Russia
690608 690608 2022-12-23 Russia Nizhny Novgorod Oblast     500518 11804 0   55.4718033 44.0911594 2022-12-24 04:21:02 Nizhny Novgorod Oblast, Russia
690609 690609 2022-12-23 Russia North Ossetia - Alania Republic     45835 1267 0   42.7933611 44.6324493 2022-12-24 04:21:02 North Ossetia - Alania Republic, Russia
690610 690610 2022-12-23 Russia Novgorod Oblast     116552 1070 0   58.2843833 32.5169757 2022-12-24 04:21:02 Novgorod Oblast, Russia
690611 690611 2022-12-23 Russia Novosibirsk Oblast     309162 5742 0   54.9720169 79.4813924 2022-12-24 04:21:02 Novosibirsk Oblast, Russia
690612 690612 2022-12-23 Russia Omsk Oblast     231172 4546 0   56.0935263 73.5099936 2022-12-24 04:21:02 Omsk Oblast, Russia
690613 690613 2022-12-23 Russia Orel Oblast     134670 1973 0   52.9685433 36.0692477 2022-12-24 04:21:02 Orel Oblast, Russia
690614 690614 2022-12-23 Russia Orenburg Oblast     240799 4030 0   52.0269262 54.7276647 2022-12-24 04:21:02 Orenburg Oblast, Russia
690615 690615 2022-12-23 Russia Penza Oblast     221068 6178 0   53.1655415 44.7879181 2022-12-24 04:21:02 Penza Oblast, Russia
690616 690616 2022-12-23 Russia Perm Krai     453581 9160 0   58.5951603 56.3159546 2022-12-24 04:21:02 Perm Krai, Russia
690617 690617 2022-12-23 Russia Primorsky Krai     208207 1966 0   45.0819456 134.726645 2022-12-24 04:21:02 Primorsky Krai, Russia
690618 690618 2022-12-23 Russia Pskov Oblast     125880 1953 0   57.5358729 28.8586826 2022-12-24 04:21:02 Pskov Oblast, Russia
690619 690619 2022-12-23 Russia Rostov Oblast     438401 11079 0   47.6222451 40.7957942 2022-12-24 04:21:02 Rostov Oblast, Russia
690620 690620 2022-12-23 Russia Ryazan Oblast     149363 3484 0   54.4226732 40.5705246 2022-12-24 04:21:02 Ryazan Oblast, Russia
690621 690621 2022-12-23 Russia Saint Petersburg     1821035 36461 0   59.9606739 30.1586551 2022-12-24 04:21:02 Saint Petersburg, Russia
690622 690622 2022-12-23 Russia Sakha (Yakutiya) Republic     216589 2140 0   66.941626 129.642371 2022-12-24 04:21:02 Sakha (Yakutiya) Republic, Russia
690623 690623 2022-12-23 Russia Sakhalin Oblast     69471 830 0   49.7219665 143.448533 2022-12-24 04:21:02 Sakhalin Oblast, Russia
690624 690624 2022-12-23 Russia Samara Oblast     489686 8179 0   53.2128813 50.8914633 2022-12-24 04:21:02 Samara Oblast, Russia
690625 690625 2022-12-23 Russia Saratov Oblast     301419 6001 0   51.6520555 46.8631952 2022-12-24 04:21:02 Saratov Oblast, Russia
690626 690626 2022-12-23 Russia Smolensk Oblast     146045 3173 0   55.0343496 33.0192065 2022-12-24 04:21:02 Smolensk Oblast, Russia
690627 690627 2022-12-23 Russia Stavropol Krai     244514 7126 0   44.8632577 43.4406913 2022-12-24 04:21:02 Stavropol Krai, Russia
690628 690628 2022-12-23 Russia Sverdlovsk Oblast     561960 10899 0   58.6414755 61.8021546 2022-12-24 04:21:02 Sverdlovsk Oblast, Russia
690629 690629 2022-12-23 Russia Tambov Oblast     137445 2517 0   52.9019574 41.3578918 2022-12-24 04:21:02 Tambov Oblast, Russia
690630 690630 2022-12-23 Russia Tatarstan Republic     192673 2008 0   55.7648572 52.43104273 2022-12-24 04:21:02 Tatarstan Republic, Russia
690631 690631 2022-12-23 Russia Tomsk Oblast     158322 949 0   58.6124279 82.0475315 2022-12-24 04:21:02 Tomsk Oblast, Russia
690632 690632 2022-12-23 Russia Tula Oblast     187881 5353 0   53.9570701 37.3690909 2022-12-24 04:21:02 Tula Oblast, Russia
690633 690633 2022-12-23 Russia Tver Oblast     179530 2771 0   57.1134475 35.1744428 2022-12-24 04:21:02 Tver Oblast, Russia
690634 690634 2022-12-23 Russia Tyumen Oblast     252933 4362 0   58.8206488 70.3658837 2022-12-24 04:21:02 Tyumen Oblast, Russia
690635 690635 2022-12-23 Russia Tyva Republic     52342 357 0   51.4017149 93.8582593 2022-12-24 04:21:02 Tyva Republic, Russia
690636 690636 2022-12-23 Russia Udmurt Republic     230876 3951 0   57.1961165 52.6959832 2022-12-24 04:21:02 Udmurt Republic, Russia
690637 690637 2022-12-23 Russia Ulyanovsk Oblast     226400 4808 0   54.1463177 47.2324921 2022-12-24 04:21:02 Ulyanovsk Oblast, Russia
690638 690638 2022-12-23 Russia Vladimir Oblast     178360 3574 0   56.0503336 40.6561633 2022-12-24 04:21:02 Vladimir Oblast, Russia
690639 690639 2022-12-23 Russia Volgograd Oblast     264400 6912 0   49.6048339 44.2903582 2022-12-24 04:21:02 Volgograd Oblast, Russia
690640 690640 2022-12-23 Russia Vologda Oblast     216326 3892 0   60.0391461 43.1215213 2022-12-24 04:21:02 Vologda Oblast, Russia
690641 690641 2022-12-23 Russia Voronezh Oblast     470420 8599 0   50.9800393 40.1506507 2022-12-24 04:21:02 Voronezh Oblast, Russia
690642 690642 2022-12-23 Russia Yamalo-Nenets Autonomous Okrug     149936 1052 0   67.1471631 74.3415488 2022-12-24 04:21:02 Yamalo-Nenets Autonomous Okrug, Russia
690643 690643 2022-12-23 Russia Yaroslavl Oblast     188739 2883 0   57.7781976 39.0021095 2022-12-24 04:21:02 Yaroslavl Oblast, Russia
690644 690644 2022-12-23 Russia Zabaykalsky Krai     190142 2374 0   52.248521 115.956325 2022-12-24 04:21:02 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]);