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-08-02 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
3617268 3617268 2022-08-01 Russia Adygea Republic     49653 1003 0   44.6939006 40.1520421 2022-08-02 04:20:53 Adygea Republic, Russia
3617269 3617269 2022-08-01 Russia Altai Krai     272312 8699 0   52.6932243 82.6931424 2022-08-02 04:20:53 Altai Krai, Russia
3617270 3617270 2022-08-01 Russia Altai Republic     35060 622 0   50.7114101 86.8572186 2022-08-02 04:20:53 Altai Republic, Russia
3617271 3617271 2022-08-01 Russia Amur Oblast     109328 764 0   52.8032368 128.437295 2022-08-02 04:20:53 Amur Oblast, Russia
3617272 3617272 2022-08-01 Russia Arkhangelsk Oblast     233672 1767 0   63.5589686 43.1221646 2022-08-02 04:20:53 Arkhangelsk Oblast, Russia
3617273 3617273 2022-08-01 Russia Astrakhan Oblast     120048 3026 0   47.1878186 47.608851 2022-08-02 04:20:53 Astrakhan Oblast, Russia
3617274 3617274 2022-08-01 Russia Bashkortostan Republic     292151 5775 0   54.8573563 57.1439682 2022-08-02 04:20:53 Bashkortostan Republic, Russia
3617275 3617275 2022-08-01 Russia Belgorod Oblast     132362 2282 0   50.7080119 37.5837615 2022-08-02 04:20:53 Belgorod Oblast, Russia
3617276 3617276 2022-08-01 Russia Bryansk Oblast     163469 4043 0   52.8873315 33.415853 2022-08-02 04:20:53 Bryansk Oblast, Russia
3617277 3617277 2022-08-01 Russia Buryatia Republic     137955 3037 0   52.7182426 109.492143 2022-08-02 04:20:53 Buryatia Republic, Russia
3617278 3617278 2022-08-01 Russia Chechen Republic     44650 1076 0   43.3976147 45.6985005 2022-08-02 04:20:53 Chechen Republic, Russia
3617279 3617279 2022-08-01 Russia Chelyabinsk Oblast     337181 7828 0   54.4223954 61.1865846 2022-08-02 04:20:53 Chelyabinsk Oblast, Russia
3617280 3617280 2022-08-01 Russia Chukotka Autonomous Okrug     5815 42 0   66.0006475 169.4900869 2022-08-02 04:20:53 Chukotka Autonomous Okrug, Russia
3617281 3617281 2022-08-01 Russia Chuvashia Republic     82288 4653 0   55.4259922 47.0849429 2022-08-02 04:20:53 Chuvashia Republic, Russia
3617282 3617282 2022-08-01 Russia Dagestan Republic     93649 3594 0   43.0574916 47.1332224 2022-08-02 04:20:53 Dagestan Republic, Russia
3617283 3617283 2022-08-01 Russia Ingushetia Republic     41219 550 0   43.11542075 45.01713552 2022-08-02 04:20:53 Ingushetia Republic, Russia
3617284 3617284 2022-08-01 Russia Irkutsk Oblast     298799 8501 0   56.6370122 104.719221 2022-08-02 04:20:53 Irkutsk Oblast, Russia
3617285 3617285 2022-08-01 Russia Ivanovo Oblast     113195 3144 0   56.9167446 41.4352137 2022-08-02 04:20:53 Ivanovo Oblast, Russia
3617286 3617286 2022-08-01 Russia Jewish Autonomous Okrug     19292 555 0   48.57527615 132.6630746 2022-08-02 04:20:53 Jewish Autonomous Okrug, Russia
3617287 3617287 2022-08-01 Russia Kabardino-Balkarian Republic     62526 1885 0   43.4806048 43.5978976 2022-08-02 04:20:53 Kabardino-Balkarian Republic, Russia
3617288 3617288 2022-08-01 Russia Kaliningrad Oblast     170835 1935 0   54.7293041 21.1489473 2022-08-02 04:20:53 Kaliningrad Oblast, Russia
3617289 3617289 2022-08-01 Russia Kalmykia Republic     52427 843 0   46.2313018 45.3275745 2022-08-02 04:20:53 Kalmykia Republic, Russia
3617290 3617290 2022-08-01 Russia Kaluga Oblast     105499 1453 0   54.4382773 35.5272854 2022-08-02 04:20:53 Kaluga Oblast, Russia
3617291 3617291 2022-08-01 Russia Kamchatka Krai     40465 617 0   57.1914882 160.0383819 2022-08-02 04:20:53 Kamchatka Krai, Russia
3617292 3617292 2022-08-01 Russia Karachay-Cherkess Republic     46214 984 0   43.7368326 41.7267991 2022-08-02 04:20:53 Karachay-Cherkess Republic, Russia
3617293 3617293 2022-08-01 Russia Karelia Republic     138578 1521 0   62.6194031 33.4920267 2022-08-02 04:20:53 Karelia Republic, Russia
3617294 3617294 2022-08-01 Russia Kemerovo Oblast     167774 2519 0   54.5335781 87.342861 2022-08-02 04:20:53 Kemerovo Oblast, Russia
3617295 3617295 2022-08-01 Russia Khabarovsk Krai     204188 1560 0   51.6312684 136.121524 2022-08-02 04:20:53 Khabarovsk Krai, Russia
3617296 3617296 2022-08-01 Russia Khakassia Republic     88507 2415 0   53.72258845 91.44293627 2022-08-02 04:20:53 Khakassia Republic, Russia
3617297 3617297 2022-08-01 Russia Khanty-Mansi Autonomous Okrug     212671 2557 0   61.0259025 69.0982628 2022-08-02 04:20:53 Khanty-Mansi Autonomous Okrug, Russia
3617298 3617298 2022-08-01 Russia Kirov Oblast     152931 1053 0   57.9665589 49.4074599 2022-08-02 04:20:53 Kirov Oblast, Russia
3617299 3617299 2022-08-01 Russia Komi Republic     173356 3202 0   63.9881421 54.3326073 2022-08-02 04:20:53 Komi Republic, Russia
3617300 3617300 2022-08-01 Russia Kostroma Oblast     89670 1409 0   58.424756 44.2533273 2022-08-02 04:20:53 Kostroma Oblast, Russia
3617301 3617301 2022-08-01 Russia Krasnodar Krai     266165 10980 0   45.7684014 39.0261044 2022-08-02 04:20:53 Krasnodar Krai, Russia
3617302 3617302 2022-08-01 Russia Krasnoyarsk Krai     368454 10915 0   63.3233807 97.0979974 2022-08-02 04:20:53 Krasnoyarsk Krai, Russia
3617303 3617303 2022-08-01 Russia Kurgan Oblast     105645 1444 0   55.7655302 64.5632681 2022-08-02 04:20:53 Kurgan Oblast, Russia
3617304 3617304 2022-08-01 Russia Kursk Oblast     120478 2498 0   51.6568453 36.4852695 2022-08-02 04:20:53 Kursk Oblast, Russia
3617305 3617305 2022-08-01 Russia Leningrad Oblast     191759 3493 0   60.1853296 32.3925325 2022-08-02 04:20:53 Leningrad Oblast, Russia
3617306 3617306 2022-08-01 Russia Lipetsk Oblast     153925 3808 0   52.6935178 39.1122664 2022-08-02 04:20:53 Lipetsk Oblast, Russia
3617307 3617307 2022-08-01 Russia Magadan Oblast     19900 390 0   62.48858785 153.9903764 2022-08-02 04:20:53 Magadan Oblast, Russia
3617308 3617308 2022-08-01 Russia Mari El Republic     44957 1087 0   56.5767504 47.8817512 2022-08-02 04:20:53 Mari El Republic, Russia
3617309 3617309 2022-08-01 Russia Mordovia Republic     69193 1393 0   54.4419829 44.4661144 2022-08-02 04:20:53 Mordovia Republic, Russia
3617310 3617310 2022-08-01 Russia Moscow     2825979 44478 0   55.7504461 37.6174943 2022-08-02 04:20:53 Moscow, Russia
3617311 3617311 2022-08-01 Russia Moscow Oblast     996813 15204 0   55.5043158 38.0353929 2022-08-02 04:20:53 Moscow Oblast, Russia
3617312 3617312 2022-08-01 Russia Murmansk Oblast     135268 3339 0   68.0000418 33.9999151 2022-08-02 04:20:53 Murmansk Oblast, Russia
3617313 3617313 2022-08-01 Russia Nenets Autonomous Okrug     7423 101 0   68.27557185 57.1686375 2022-08-02 04:20:53 Nenets Autonomous Okrug, Russia
3617314 3617314 2022-08-01 Russia Nizhny Novgorod Oblast     426621 11599 0   55.4718033 44.0911594 2022-08-02 04:20:53 Nizhny Novgorod Oblast, Russia
3617315 3617315 2022-08-01 Russia North Ossetia - Alania Republic     41157 1255 0   42.7933611 44.6324493 2022-08-02 04:20:53 North Ossetia - Alania Republic, Russia
3617316 3617316 2022-08-01 Russia Novgorod Oblast     101562 1036 0   58.2843833 32.5169757 2022-08-02 04:20:53 Novgorod Oblast, Russia
3617317 3617317 2022-08-01 Russia Novosibirsk Oblast     261839 5698 0   54.9720169 79.4813924 2022-08-02 04:20:53 Novosibirsk Oblast, Russia
3617318 3617318 2022-08-01 Russia Omsk Oblast     210480 4432 0   56.0935263 73.5099936 2022-08-02 04:20:53 Omsk Oblast, Russia
3617319 3617319 2022-08-01 Russia Orel Oblast     114728 1933 0   52.9685433 36.0692477 2022-08-02 04:20:53 Orel Oblast, Russia
3617320 3617320 2022-08-01 Russia Orenburg Oblast     218358 4026 0   52.0269262 54.7276647 2022-08-02 04:20:53 Orenburg Oblast, Russia
3617321 3617321 2022-08-01 Russia Penza Oblast     189192 5993 0   53.1655415 44.7879181 2022-08-02 04:20:53 Penza Oblast, Russia
3617322 3617322 2022-08-01 Russia Perm Krai     373877 8851 0   58.5951603 56.3159546 2022-08-02 04:20:53 Perm Krai, Russia
3617323 3617323 2022-08-01 Russia Primorsky Krai     177541 1966 0   45.0819456 134.726645 2022-08-02 04:20:53 Primorsky Krai, Russia
3617324 3617324 2022-08-01 Russia Pskov Oblast     112029 1882 0   57.5358729 28.8586826 2022-08-02 04:20:53 Pskov Oblast, Russia
3617325 3617325 2022-08-01 Russia Rostov Oblast     382763 10967 0   47.6222451 40.7957942 2022-08-02 04:20:53 Rostov Oblast, Russia
3617326 3617326 2022-08-01 Russia Ryazan Oblast     123801 3416 0   54.4226732 40.5705246 2022-08-02 04:20:53 Ryazan Oblast, Russia
3617327 3617327 2022-08-01 Russia Saint Petersburg     1555473 34342 0   59.9606739 30.1586551 2022-08-02 04:20:53 Saint Petersburg, Russia
3617328 3617328 2022-08-01 Russia Sakha (Yakutiya) Republic     182843 2122 0   66.941626 129.642371 2022-08-02 04:20:53 Sakha (Yakutiya) Republic, Russia
3617329 3617329 2022-08-01 Russia Sakhalin Oblast     65213 828 0   49.7219665 143.448533 2022-08-02 04:20:53 Sakhalin Oblast, Russia
3617330 3617330 2022-08-01 Russia Samara Oblast     388209 7931 0   53.2128813 50.8914633 2022-08-02 04:20:53 Samara Oblast, Russia
3617331 3617331 2022-08-01 Russia Saratov Oblast     256852 6001 0   51.6520555 46.8631952 2022-08-02 04:20:53 Saratov Oblast, Russia
3617332 3617332 2022-08-01 Russia Smolensk Oblast     132485 3085 0   55.0343496 33.0192065 2022-08-02 04:20:53 Smolensk Oblast, Russia
3617333 3617333 2022-08-01 Russia Stavropol Krai     201451 7093 0   44.8632577 43.4406913 2022-08-02 04:20:53 Stavropol Krai, Russia
3617334 3617334 2022-08-01 Russia Sverdlovsk Oblast     451793 10777 0   58.6414755 61.8021546 2022-08-02 04:20:53 Sverdlovsk Oblast, Russia
3617335 3617335 2022-08-01 Russia Tambov Oblast     117896 2449 0   52.9019574 41.3578918 2022-08-02 04:20:53 Tambov Oblast, Russia
3617336 3617336 2022-08-01 Russia Tatarstan Republic     153896 1996 0   55.7648572 52.43104273 2022-08-02 04:20:53 Tatarstan Republic, Russia
3617337 3617337 2022-08-01 Russia Tomsk Oblast     133472 870 0   58.6124279 82.0475315 2022-08-02 04:20:53 Tomsk Oblast, Russia
3617338 3617338 2022-08-01 Russia Tula Oblast     159912 5252 0   53.9570701 37.3690909 2022-08-02 04:20:53 Tula Oblast, Russia
3617339 3617339 2022-08-01 Russia Tver Oblast     164281 2757 0   57.1134475 35.1744428 2022-08-02 04:20:53 Tver Oblast, Russia
3617340 3617340 2022-08-01 Russia Tyumen Oblast     193828 4340 0   58.8206488 70.3658837 2022-08-02 04:20:53 Tyumen Oblast, Russia
3617341 3617341 2022-08-01 Russia Tyva Republic     44548 353 0   51.4017149 93.8582593 2022-08-02 04:20:53 Tyva Republic, Russia
3617342 3617342 2022-08-01 Russia Udmurt Republic     168209 3847 0   57.1961165 52.6959832 2022-08-02 04:20:53 Udmurt Republic, Russia
3617343 3617343 2022-08-01 Russia Ulyanovsk Oblast     204439 4725 0   54.1463177 47.2324921 2022-08-02 04:20:53 Ulyanovsk Oblast, Russia
3617344 3617344 2022-08-01 Russia Vladimir Oblast     152885 3500 0   56.0503336 40.6561633 2022-08-02 04:20:53 Vladimir Oblast, Russia
3617345 3617345 2022-08-01 Russia Volgograd Oblast     227636 6896 0   49.6048339 44.2903582 2022-08-02 04:20:53 Volgograd Oblast, Russia
3617346 3617346 2022-08-01 Russia Vologda Oblast     193504 3877 0   60.0391461 43.1215213 2022-08-02 04:20:53 Vologda Oblast, Russia
3617347 3617347 2022-08-01 Russia Voronezh Oblast     392541 8358 0   50.9800393 40.1506507 2022-08-02 04:20:53 Voronezh Oblast, Russia
3617348 3617348 2022-08-01 Russia Yamalo-Nenets Autonomous Okrug     137819 1043 0   67.1471631 74.3415488 2022-08-02 04:20:53 Yamalo-Nenets Autonomous Okrug, Russia
3617349 3617349 2022-08-01 Russia Yaroslavl Oblast     164826 2830 0   57.7781976 39.0021095 2022-08-02 04:20:53 Yaroslavl Oblast, Russia
3617350 3617350 2022-08-01 Russia Zabaykalsky Krai     169802 2349 0   52.248521 115.956325 2022-08-02 04:20:53 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]);