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-07-30 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: last_update (date)

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
1783701 1783701 2022-07-29 Russia Adygea Republic     49604 1003 0   44.6939006 40.1520421 2022-07-30 04:20:42 Adygea Republic, Russia
1783702 1783702 2022-07-29 Russia Altai Krai     272028 8698 0   52.6932243 82.6931424 2022-07-30 04:20:42 Altai Krai, Russia
1783703 1783703 2022-07-29 Russia Altai Republic     34965 622 0   50.7114101 86.8572186 2022-07-30 04:20:42 Altai Republic, Russia
1783704 1783704 2022-07-29 Russia Amur Oblast     109257 764 0   52.8032368 128.437295 2022-07-30 04:20:42 Amur Oblast, Russia
1783705 1783705 2022-07-29 Russia Arkhangelsk Oblast     233464 1766 0   63.5589686 43.1221646 2022-07-30 04:20:42 Arkhangelsk Oblast, Russia
1783706 1783706 2022-07-29 Russia Astrakhan Oblast     119695 3025 0   47.1878186 47.608851 2022-07-30 04:20:42 Astrakhan Oblast, Russia
1783707 1783707 2022-07-29 Russia Bashkortostan Republic     291905 5772 0   54.8573563 57.1439682 2022-07-30 04:20:42 Bashkortostan Republic, Russia
1783708 1783708 2022-07-29 Russia Belgorod Oblast     132243 2282 0   50.7080119 37.5837615 2022-07-30 04:20:42 Belgorod Oblast, Russia
1783709 1783709 2022-07-29 Russia Bryansk Oblast     163166 4043 0   52.8873315 33.415853 2022-07-30 04:20:42 Bryansk Oblast, Russia
1783710 1783710 2022-07-29 Russia Buryatia Republic     137783 3036 0   52.7182426 109.492143 2022-07-30 04:20:42 Buryatia Republic, Russia
1783711 1783711 2022-07-29 Russia Chechen Republic     44618 1076 0   43.3976147 45.6985005 2022-07-30 04:20:42 Chechen Republic, Russia
1783712 1783712 2022-07-29 Russia Chelyabinsk Oblast     336601 7825 0   54.4223954 61.1865846 2022-07-30 04:20:42 Chelyabinsk Oblast, Russia
1783713 1783713 2022-07-29 Russia Chukotka Autonomous Okrug     5804 42 0   66.0006475 169.4900869 2022-07-30 04:20:42 Chukotka Autonomous Okrug, Russia
1783714 1783714 2022-07-29 Russia Chuvashia Republic     82118 4653 0   55.4259922 47.0849429 2022-07-30 04:20:42 Chuvashia Republic, Russia
1783715 1783715 2022-07-29 Russia Dagestan Republic     93597 3594 0   43.0574916 47.1332224 2022-07-30 04:20:42 Dagestan Republic, Russia
1783716 1783716 2022-07-29 Russia Ingushetia Republic     41200 550 0   43.11542075 45.01713552 2022-07-30 04:20:42 Ingushetia Republic, Russia
1783717 1783717 2022-07-29 Russia Irkutsk Oblast     298179 8500 0   56.6370122 104.719221 2022-07-30 04:20:42 Irkutsk Oblast, Russia
1783718 1783718 2022-07-29 Russia Ivanovo Oblast     113120 3144 0   56.9167446 41.4352137 2022-07-30 04:20:42 Ivanovo Oblast, Russia
1783719 1783719 2022-07-29 Russia Jewish Autonomous Okrug     19276 555 0   48.57527615 132.6630746 2022-07-30 04:20:42 Jewish Autonomous Okrug, Russia
1783720 1783720 2022-07-29 Russia Kabardino-Balkarian Republic     62416 1884 0   43.4806048 43.5978976 2022-07-30 04:20:42 Kabardino-Balkarian Republic, Russia
1783721 1783721 2022-07-29 Russia Kaliningrad Oblast     170575 1935 0   54.7293041 21.1489473 2022-07-30 04:20:42 Kaliningrad Oblast, Russia
1783722 1783722 2022-07-29 Russia Kalmykia Republic     52329 843 0   46.2313018 45.3275745 2022-07-30 04:20:42 Kalmykia Republic, Russia
1783723 1783723 2022-07-29 Russia Kaluga Oblast     105294 1453 0   54.4382773 35.5272854 2022-07-30 04:20:42 Kaluga Oblast, Russia
1783724 1783724 2022-07-29 Russia Kamchatka Krai     40432 617 0   57.1914882 160.0383819 2022-07-30 04:20:42 Kamchatka Krai, Russia
1783725 1783725 2022-07-29 Russia Karachay-Cherkess Republic     46190 984 0   43.7368326 41.7267991 2022-07-30 04:20:42 Karachay-Cherkess Republic, Russia
1783726 1783726 2022-07-29 Russia Karelia Republic     138434 1520 0   62.6194031 33.4920267 2022-07-30 04:20:42 Karelia Republic, Russia
1783727 1783727 2022-07-29 Russia Kemerovo Oblast     167510 2514 0   54.5335781 87.342861 2022-07-30 04:20:42 Kemerovo Oblast, Russia
1783728 1783728 2022-07-29 Russia Khabarovsk Krai     204122 1560 0   51.6312684 136.121524 2022-07-30 04:20:42 Khabarovsk Krai, Russia
1783729 1783729 2022-07-29 Russia Khakassia Republic     88436 2415 0   53.72258845 91.44293627 2022-07-30 04:20:42 Khakassia Republic, Russia
1783730 1783730 2022-07-29 Russia Khanty-Mansi Autonomous Okrug     212340 2557 0   61.0259025 69.0982628 2022-07-30 04:20:42 Khanty-Mansi Autonomous Okrug, Russia
1783731 1783731 2022-07-29 Russia Kirov Oblast     152811 1053 0   57.9665589 49.4074599 2022-07-30 04:20:42 Kirov Oblast, Russia
1783732 1783732 2022-07-29 Russia Komi Republic     173281 3201 0   63.9881421 54.3326073 2022-07-30 04:20:42 Komi Republic, Russia
1783733 1783733 2022-07-29 Russia Kostroma Oblast     89610 1409 0   58.424756 44.2533273 2022-07-30 04:20:42 Kostroma Oblast, Russia
1783734 1783734 2022-07-29 Russia Krasnodar Krai     265426 10979 0   45.7684014 39.0261044 2022-07-30 04:20:42 Krasnodar Krai, Russia
1783735 1783735 2022-07-29 Russia Krasnoyarsk Krai     368118 10912 0   63.3233807 97.0979974 2022-07-30 04:20:42 Krasnoyarsk Krai, Russia
1783736 1783736 2022-07-29 Russia Kurgan Oblast     105583 1444 0   55.7655302 64.5632681 2022-07-30 04:20:42 Kurgan Oblast, Russia
1783737 1783737 2022-07-29 Russia Kursk Oblast     120343 2497 0   51.6568453 36.4852695 2022-07-30 04:20:42 Kursk Oblast, Russia
1783738 1783738 2022-07-29 Russia Leningrad Oblast     191027 3493 0   60.1853296 32.3925325 2022-07-30 04:20:42 Leningrad Oblast, Russia
1783739 1783739 2022-07-29 Russia Lipetsk Oblast     153813 3806 0   52.6935178 39.1122664 2022-07-30 04:20:42 Lipetsk Oblast, Russia
1783740 1783740 2022-07-29 Russia Magadan Oblast     19892 390 0   62.48858785 153.9903764 2022-07-30 04:20:42 Magadan Oblast, Russia
1783741 1783741 2022-07-29 Russia Mari El Republic     44916 1087 0   56.5767504 47.8817512 2022-07-30 04:20:42 Mari El Republic, Russia
1783742 1783742 2022-07-29 Russia Mordovia Republic     69084 1393 0   54.4419829 44.4661144 2022-07-30 04:20:42 Mordovia Republic, Russia
1783743 1783743 2022-07-29 Russia Moscow     2815256 44444 0   55.7504461 37.6174943 2022-07-30 04:20:42 Moscow, Russia
1783744 1783744 2022-07-29 Russia Moscow Oblast     993534 15201 0   55.5043158 38.0353929 2022-07-30 04:20:42 Moscow Oblast, Russia
1783745 1783745 2022-07-29 Russia Murmansk Oblast     135226 3337 0   68.0000418 33.9999151 2022-07-30 04:20:42 Murmansk Oblast, Russia
1783746 1783746 2022-07-29 Russia Nenets Autonomous Okrug     7423 101 0   68.27557185 57.1686375 2022-07-30 04:20:42 Nenets Autonomous Okrug, Russia
1783747 1783747 2022-07-29 Russia Nizhny Novgorod Oblast     426160 11597 0   55.4718033 44.0911594 2022-07-30 04:20:42 Nizhny Novgorod Oblast, Russia
1783748 1783748 2022-07-29 Russia North Ossetia - Alania Republic     41136 1255 0   42.7933611 44.6324493 2022-07-30 04:20:42 North Ossetia - Alania Republic, Russia
1783749 1783749 2022-07-29 Russia Novgorod Oblast     101427 1036 0   58.2843833 32.5169757 2022-07-30 04:20:42 Novgorod Oblast, Russia
1783750 1783750 2022-07-29 Russia Novosibirsk Oblast     261633 5697 0   54.9720169 79.4813924 2022-07-30 04:20:42 Novosibirsk Oblast, Russia
1783751 1783751 2022-07-29 Russia Omsk Oblast     210097 4430 0   56.0935263 73.5099936 2022-07-30 04:20:42 Omsk Oblast, Russia
1783752 1783752 2022-07-29 Russia Orel Oblast     114587 1933 0   52.9685433 36.0692477 2022-07-30 04:20:42 Orel Oblast, Russia
1783753 1783753 2022-07-29 Russia Orenburg Oblast     218154 4026 0   52.0269262 54.7276647 2022-07-30 04:20:42 Orenburg Oblast, Russia
1783754 1783754 2022-07-29 Russia Penza Oblast     189040 5987 0   53.1655415 44.7879181 2022-07-30 04:20:42 Penza Oblast, Russia
1783755 1783755 2022-07-29 Russia Perm Krai     373443 8851 0   58.5951603 56.3159546 2022-07-30 04:20:42 Perm Krai, Russia
1783756 1783756 2022-07-29 Russia Primorsky Krai     177077 1966 0   45.0819456 134.726645 2022-07-30 04:20:42 Primorsky Krai, Russia
1783757 1783757 2022-07-29 Russia Pskov Oblast     111897 1881 0   57.5358729 28.8586826 2022-07-30 04:20:42 Pskov Oblast, Russia
1783758 1783758 2022-07-29 Russia Rostov Oblast     382152 10967 0   47.6222451 40.7957942 2022-07-30 04:20:42 Rostov Oblast, Russia
1783759 1783759 2022-07-29 Russia Ryazan Oblast     123518 3416 0   54.4226732 40.5705246 2022-07-30 04:20:42 Ryazan Oblast, Russia
1783760 1783760 2022-07-29 Russia Saint Petersburg     1550709 34319 0   59.9606739 30.1586551 2022-07-30 04:20:42 Saint Petersburg, Russia
1783761 1783761 2022-07-29 Russia Sakha (Yakutiya) Republic     182533 2122 0   66.941626 129.642371 2022-07-30 04:20:42 Sakha (Yakutiya) Republic, Russia
1783762 1783762 2022-07-29 Russia Sakhalin Oblast     65174 828 0   49.7219665 143.448533 2022-07-30 04:20:42 Sakhalin Oblast, Russia
1783763 1783763 2022-07-29 Russia Samara Oblast     387742 7927 0   53.2128813 50.8914633 2022-07-30 04:20:42 Samara Oblast, Russia
1783764 1783764 2022-07-29 Russia Saratov Oblast     256605 6001 0   51.6520555 46.8631952 2022-07-30 04:20:42 Saratov Oblast, Russia
1783765 1783765 2022-07-29 Russia Smolensk Oblast     132367 3085 0   55.0343496 33.0192065 2022-07-30 04:20:42 Smolensk Oblast, Russia
1783766 1783766 2022-07-29 Russia Stavropol Krai     201121 7093 0   44.8632577 43.4406913 2022-07-30 04:20:42 Stavropol Krai, Russia
1783767 1783767 2022-07-29 Russia Sverdlovsk Oblast     451314 10776 0   58.6414755 61.8021546 2022-07-30 04:20:42 Sverdlovsk Oblast, Russia
1783768 1783768 2022-07-29 Russia Tambov Oblast     117803 2446 0   52.9019574 41.3578918 2022-07-30 04:20:42 Tambov Oblast, Russia
1783769 1783769 2022-07-29 Russia Tatarstan Republic     153754 1996 0   55.7648572 52.43104273 2022-07-30 04:20:42 Tatarstan Republic, Russia
1783770 1783770 2022-07-29 Russia Tomsk Oblast     133336 870 0   58.6124279 82.0475315 2022-07-30 04:20:42 Tomsk Oblast, Russia
1783771 1783771 2022-07-29 Russia Tula Oblast     159536 5249 0   53.9570701 37.3690909 2022-07-30 04:20:42 Tula Oblast, Russia
1783772 1783772 2022-07-29 Russia Tver Oblast     164103 2756 0   57.1134475 35.1744428 2022-07-30 04:20:42 Tver Oblast, Russia
1783773 1783773 2022-07-29 Russia Tyumen Oblast     193434 4339 0   58.8206488 70.3658837 2022-07-30 04:20:42 Tyumen Oblast, Russia
1783774 1783774 2022-07-29 Russia Tyva Republic     44511 353 0   51.4017149 93.8582593 2022-07-30 04:20:42 Tyva Republic, Russia
1783775 1783775 2022-07-29 Russia Udmurt Republic     168084 3847 0   57.1961165 52.6959832 2022-07-30 04:20:42 Udmurt Republic, Russia
1783776 1783776 2022-07-29 Russia Ulyanovsk Oblast     204318 4725 0   54.1463177 47.2324921 2022-07-30 04:20:42 Ulyanovsk Oblast, Russia
1783777 1783777 2022-07-29 Russia Vladimir Oblast     152767 3498 0   56.0503336 40.6561633 2022-07-30 04:20:42 Vladimir Oblast, Russia
1783778 1783778 2022-07-29 Russia Volgograd Oblast     227362 6896 0   49.6048339 44.2903582 2022-07-30 04:20:42 Volgograd Oblast, Russia
1783779 1783779 2022-07-29 Russia Vologda Oblast     193377 3877 0   60.0391461 43.1215213 2022-07-30 04:20:42 Vologda Oblast, Russia
1783780 1783780 2022-07-29 Russia Voronezh Oblast     391900 8356 0   50.9800393 40.1506507 2022-07-30 04:20:42 Voronezh Oblast, Russia
1783781 1783781 2022-07-29 Russia Yamalo-Nenets Autonomous Okrug     137714 1043 0   67.1471631 74.3415488 2022-07-30 04:20:42 Yamalo-Nenets Autonomous Okrug, Russia
1783782 1783782 2022-07-29 Russia Yaroslavl Oblast     164676 2830 0   57.7781976 39.0021095 2022-07-30 04:20:42 Yaroslavl Oblast, Russia
1783783 1783783 2022-07-29 Russia Zabaykalsky Krai     169721 2349 0   52.248521 115.956325 2022-07-30 04:20:42 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]);