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-09-29 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
1560281 1560281 2022-09-28 Russia Adygea Republic     53053 1010 0   44.6939006 40.1520421 2022-09-29 04:22:34 Adygea Republic, Russia
1560282 1560282 2022-09-28 Russia Altai Krai     300525 8765 0   52.6932243 82.6931424 2022-09-29 04:22:34 Altai Krai, Russia
1560283 1560283 2022-09-28 Russia Altai Republic     39279 626 0   50.7114101 86.8572186 2022-09-29 04:22:34 Altai Republic, Russia
1560284 1560284 2022-09-28 Russia Amur Oblast     121287 765 0   52.8032368 128.437295 2022-09-29 04:22:34 Amur Oblast, Russia
1560285 1560285 2022-09-28 Russia Arkhangelsk Oblast     261649 1774 0   63.5589686 43.1221646 2022-09-29 04:22:34 Arkhangelsk Oblast, Russia
1560286 1560286 2022-09-28 Russia Astrakhan Oblast     130998 3086 0   47.1878186 47.608851 2022-09-29 04:22:34 Astrakhan Oblast, Russia
1560287 1560287 2022-09-28 Russia Bashkortostan Republic     316584 5827 0   54.8573563 57.1439682 2022-09-29 04:22:34 Bashkortostan Republic, Russia
1560288 1560288 2022-09-28 Russia Belgorod Oblast     153548 2293 0   50.7080119 37.5837615 2022-09-29 04:22:34 Belgorod Oblast, Russia
1560289 1560289 2022-09-28 Russia Bryansk Oblast     180285 4077 0   52.8873315 33.415853 2022-09-29 04:22:34 Bryansk Oblast, Russia
1560290 1560290 2022-09-28 Russia Buryatia Republic     150619 3070 0   52.7182426 109.492143 2022-09-29 04:22:34 Buryatia Republic, Russia
1560291 1560291 2022-09-28 Russia Chechen Republic     46200 1076 0   43.3976147 45.6985005 2022-09-29 04:22:34 Chechen Republic, Russia
1560292 1560292 2022-09-28 Russia Chelyabinsk Oblast     371781 7920 0   54.4223954 61.1865846 2022-09-29 04:22:34 Chelyabinsk Oblast, Russia
1560293 1560293 2022-09-28 Russia Chukotka Autonomous Okrug     6500 44 0   66.0006475 169.4900869 2022-09-29 04:22:34 Chukotka Autonomous Okrug, Russia
1560294 1560294 2022-09-28 Russia Chuvashia Republic     99278 4676 0   55.4259922 47.0849429 2022-09-29 04:22:34 Chuvashia Republic, Russia
1560295 1560295 2022-09-28 Russia Dagestan Republic     101176 3611 0   43.0574916 47.1332224 2022-09-29 04:22:34 Dagestan Republic, Russia
1560296 1560296 2022-09-28 Russia Ingushetia Republic     42927 550 0   43.11542075 45.01713552 2022-09-29 04:22:34 Ingushetia Republic, Russia
1560297 1560297 2022-09-28 Russia Irkutsk Oblast     341334 8552 0   56.6370122 104.719221 2022-09-29 04:22:34 Irkutsk Oblast, Russia
1560298 1560298 2022-09-28 Russia Ivanovo Oblast     123855 3166 0   56.9167446 41.4352137 2022-09-29 04:22:34 Ivanovo Oblast, Russia
1560299 1560299 2022-09-28 Russia Jewish Autonomous Okrug     21630 559 0   48.57527615 132.6630746 2022-09-29 04:22:34 Jewish Autonomous Okrug, Russia
1560300 1560300 2022-09-28 Russia Kabardino-Balkarian Republic     71776 1906 0   43.4806048 43.5978976 2022-09-29 04:22:34 Kabardino-Balkarian Republic, Russia
1560301 1560301 2022-09-28 Russia Kaliningrad Oblast     186153 1967 0   54.7293041 21.1489473 2022-09-29 04:22:34 Kaliningrad Oblast, Russia
1560302 1560302 2022-09-28 Russia Kalmykia Republic     58116 843 0   46.2313018 45.3275745 2022-09-29 04:22:34 Kalmykia Republic, Russia
1560303 1560303 2022-09-28 Russia Kaluga Oblast     117714 1453 0   54.4382773 35.5272854 2022-09-29 04:22:34 Kaluga Oblast, Russia
1560304 1560304 2022-09-28 Russia Kamchatka Krai     43586 624 0   57.1914882 160.0383819 2022-09-29 04:22:34 Kamchatka Krai, Russia
1560305 1560305 2022-09-28 Russia Karachay-Cherkess Republic     49886 984 0   43.7368326 41.7267991 2022-09-29 04:22:34 Karachay-Cherkess Republic, Russia
1560306 1560306 2022-09-28 Russia Karelia Republic     154719 1525 0   62.6194031 33.4920267 2022-09-29 04:22:34 Karelia Republic, Russia
1560307 1560307 2022-09-28 Russia Kemerovo Oblast     201859 2647 0   54.5335781 87.342861 2022-09-29 04:22:34 Kemerovo Oblast, Russia
1560308 1560308 2022-09-28 Russia Khabarovsk Krai     219580 1561 0   51.6312684 136.121524 2022-09-29 04:22:34 Khabarovsk Krai, Russia
1560309 1560309 2022-09-28 Russia Khakassia Republic     99929 2416 0   53.72258845 91.44293627 2022-09-29 04:22:34 Khakassia Republic, Russia
1560310 1560310 2022-09-28 Russia Khanty-Mansi Autonomous Okrug     242045 2571 0   61.0259025 69.0982628 2022-09-29 04:22:34 Khanty-Mansi Autonomous Okrug, Russia
1560311 1560311 2022-09-28 Russia Kirov Oblast     159645 1068 0   57.9665589 49.4074599 2022-09-29 04:22:34 Kirov Oblast, Russia
1560312 1560312 2022-09-28 Russia Komi Republic     184723 3217 0   63.9881421 54.3326073 2022-09-29 04:22:34 Komi Republic, Russia
1560313 1560313 2022-09-28 Russia Kostroma Oblast     98650 1415 0   58.424756 44.2533273 2022-09-29 04:22:34 Kostroma Oblast, Russia
1560314 1560314 2022-09-28 Russia Krasnodar Krai     330609 11037 0   45.7684014 39.0261044 2022-09-29 04:22:34 Krasnodar Krai, Russia
1560315 1560315 2022-09-28 Russia Krasnoyarsk Krai     413897 11038 0   63.3233807 97.0979974 2022-09-29 04:22:34 Krasnoyarsk Krai, Russia
1560316 1560316 2022-09-28 Russia Kurgan Oblast     116813 1460 0   55.7655302 64.5632681 2022-09-29 04:22:34 Kurgan Oblast, Russia
1560317 1560317 2022-09-28 Russia Kursk Oblast     142338 2510 0   51.6568453 36.4852695 2022-09-29 04:22:34 Kursk Oblast, Russia
1560318 1560318 2022-09-28 Russia Leningrad Oblast     229604 3497 0   60.1853296 32.3925325 2022-09-29 04:22:34 Leningrad Oblast, Russia
1560319 1560319 2022-09-28 Russia Lipetsk Oblast     171121 3857 0   52.6935178 39.1122664 2022-09-29 04:22:34 Lipetsk Oblast, Russia
1560320 1560320 2022-09-28 Russia Magadan Oblast     21103 390 0   62.48858785 153.9903764 2022-09-29 04:22:34 Magadan Oblast, Russia
1560321 1560321 2022-09-28 Russia Mari El Republic     47672 1087 0   56.5767504 47.8817512 2022-09-29 04:22:34 Mari El Republic, Russia
1560322 1560322 2022-09-28 Russia Mordovia Republic     79087 1396 0   54.4419829 44.4661144 2022-09-29 04:22:34 Mordovia Republic, Russia
1560323 1560323 2022-09-28 Russia Moscow     3188991 45977 0   55.7504461 37.6174943 2022-09-29 04:22:34 Moscow, Russia
1560324 1560324 2022-09-28 Russia Moscow Oblast     1103569 15352 0   55.5043158 38.0353929 2022-09-29 04:22:34 Moscow Oblast, Russia
1560325 1560325 2022-09-28 Russia Murmansk Oblast     141755 3364 0   68.0000418 33.9999151 2022-09-29 04:22:34 Murmansk Oblast, Russia
1560326 1560326 2022-09-28 Russia Nenets Autonomous Okrug     8078 101 0   68.27557185 57.1686375 2022-09-29 04:22:34 Nenets Autonomous Okrug, Russia
1560327 1560327 2022-09-28 Russia Nizhny Novgorod Oblast     481876 11684 0   55.4718033 44.0911594 2022-09-29 04:22:34 Nizhny Novgorod Oblast, Russia
1560328 1560328 2022-09-28 Russia North Ossetia - Alania Republic     44593 1258 0   42.7933611 44.6324493 2022-09-29 04:22:34 North Ossetia - Alania Republic, Russia
1560329 1560329 2022-09-28 Russia Novgorod Oblast     113419 1040 0   58.2843833 32.5169757 2022-09-29 04:22:34 Novgorod Oblast, Russia
1560330 1560330 2022-09-28 Russia Novosibirsk Oblast     293662 5715 0   54.9720169 79.4813924 2022-09-29 04:22:34 Novosibirsk Oblast, Russia
1560331 1560331 2022-09-28 Russia Omsk Oblast     224765 4479 0   56.0935263 73.5099936 2022-09-29 04:22:34 Omsk Oblast, Russia
1560332 1560332 2022-09-28 Russia Orel Oblast     129195 1950 0   52.9685433 36.0692477 2022-09-29 04:22:34 Orel Oblast, Russia
1560333 1560333 2022-09-28 Russia Orenburg Oblast     236317 4028 0   52.0269262 54.7276647 2022-09-29 04:22:34 Orenburg Oblast, Russia
1560334 1560334 2022-09-28 Russia Penza Oblast     209375 6069 0   53.1655415 44.7879181 2022-09-29 04:22:34 Penza Oblast, Russia
1560335 1560335 2022-09-28 Russia Perm Krai     427995 8937 0   58.5951603 56.3159546 2022-09-29 04:22:34 Perm Krai, Russia
1560336 1560336 2022-09-28 Russia Primorsky Krai     202217 1966 0   45.0819456 134.726645 2022-09-29 04:22:34 Primorsky Krai, Russia
1560337 1560337 2022-09-28 Russia Pskov Oblast     122835 1912 0   57.5358729 28.8586826 2022-09-29 04:22:34 Pskov Oblast, Russia
1560338 1560338 2022-09-28 Russia Rostov Oblast     429958 11013 0   47.6222451 40.7957942 2022-09-29 04:22:34 Rostov Oblast, Russia
1560339 1560339 2022-09-28 Russia Ryazan Oblast     144496 3439 0   54.4226732 40.5705246 2022-09-29 04:22:34 Ryazan Oblast, Russia
1560340 1560340 2022-09-28 Russia Saint Petersburg     1752858 35215 0   59.9606739 30.1586551 2022-09-29 04:22:34 Saint Petersburg, Russia
1560341 1560341 2022-09-28 Russia Sakha (Yakutiya) Republic     209571 2134 0   66.941626 129.642371 2022-09-29 04:22:34 Sakha (Yakutiya) Republic, Russia
1560342 1560342 2022-09-28 Russia Sakhalin Oblast     67610 829 0   49.7219665 143.448533 2022-09-29 04:22:34 Sakhalin Oblast, Russia
1560343 1560343 2022-09-28 Russia Samara Oblast     458496 8023 0   53.2128813 50.8914633 2022-09-29 04:22:34 Samara Oblast, Russia
1560344 1560344 2022-09-28 Russia Saratov Oblast     286374 6001 0   51.6520555 46.8631952 2022-09-29 04:22:34 Saratov Oblast, Russia
1560345 1560345 2022-09-28 Russia Smolensk Oblast     143010 3106 0   55.0343496 33.0192065 2022-09-29 04:22:34 Smolensk Oblast, Russia
1560346 1560346 2022-09-28 Russia Stavropol Krai     234342 7106 0   44.8632577 43.4406913 2022-09-29 04:22:34 Stavropol Krai, Russia
1560347 1560347 2022-09-28 Russia Sverdlovsk Oblast     519077 10819 0   58.6414755 61.8021546 2022-09-29 04:22:34 Sverdlovsk Oblast, Russia
1560348 1560348 2022-09-28 Russia Tambov Oblast     133209 2475 0   52.9019574 41.3578918 2022-09-29 04:22:34 Tambov Oblast, Russia
1560349 1560349 2022-09-28 Russia Tatarstan Republic     178687 2004 0   55.7648572 52.43104273 2022-09-29 04:22:34 Tatarstan Republic, Russia
1560350 1560350 2022-09-28 Russia Tomsk Oblast     149594 900 0   58.6124279 82.0475315 2022-09-29 04:22:34 Tomsk Oblast, Russia
1560351 1560351 2022-09-28 Russia Tula Oblast     182617 5306 0   53.9570701 37.3690909 2022-09-29 04:22:34 Tula Oblast, Russia
1560352 1560352 2022-09-28 Russia Tver Oblast     176201 2765 0   57.1134475 35.1744428 2022-09-29 04:22:34 Tver Oblast, Russia
1560353 1560353 2022-09-28 Russia Tyumen Oblast     237188 4347 0   58.8206488 70.3658837 2022-09-29 04:22:34 Tyumen Oblast, Russia
1560354 1560354 2022-09-28 Russia Tyva Republic     52109 357 0   51.4017149 93.8582593 2022-09-29 04:22:34 Tyva Republic, Russia
1560355 1560355 2022-09-28 Russia Udmurt Republic     205742 3879 0   57.1961165 52.6959832 2022-09-29 04:22:34 Udmurt Republic, Russia
1560356 1560356 2022-09-28 Russia Ulyanovsk Oblast     221736 4775 0   54.1463177 47.2324921 2022-09-29 04:22:34 Ulyanovsk Oblast, Russia
1560357 1560357 2022-09-28 Russia Vladimir Oblast     169454 3527 0   56.0503336 40.6561633 2022-09-29 04:22:34 Vladimir Oblast, Russia
1560358 1560358 2022-09-28 Russia Volgograd Oblast     257612 6905 0   49.6048339 44.2903582 2022-09-29 04:22:34 Volgograd Oblast, Russia
1560359 1560359 2022-09-28 Russia Vologda Oblast     208851 3884 0   60.0391461 43.1215213 2022-09-29 04:22:34 Vologda Oblast, Russia
1560360 1560360 2022-09-28 Russia Voronezh Oblast     452892 8440 0   50.9800393 40.1506507 2022-09-29 04:22:34 Voronezh Oblast, Russia
1560361 1560361 2022-09-28 Russia Yamalo-Nenets Autonomous Okrug     146056 1044 0   67.1471631 74.3415488 2022-09-29 04:22:34 Yamalo-Nenets Autonomous Okrug, Russia
1560362 1560362 2022-09-28 Russia Yaroslavl Oblast     176325 2832 0   57.7781976 39.0021095 2022-09-29 04:22:34 Yaroslavl Oblast, Russia
1560363 1560363 2022-09-28 Russia Zabaykalsky Krai     183844 2354 0   52.248521 115.956325 2022-09-29 04:22:34 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]);