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-06-22 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
166231 166231 2022-06-21 Russia Adygea Republic     49470 1002 0   44.6939006 40.1520421 2022-06-22 04:20:54 Adygea Republic, Russia
166232 166232 2022-06-21 Russia Altai Krai     269988 8669 0   52.6932243 82.6931424 2022-06-22 04:20:54 Altai Krai, Russia
166233 166233 2022-06-21 Russia Altai Republic     34583 621 0   50.7114101 86.8572186 2022-06-22 04:20:54 Altai Republic, Russia
166234 166234 2022-06-21 Russia Amur Oblast     108548 764 0   52.8032368 128.437295 2022-06-22 04:20:54 Amur Oblast, Russia
166235 166235 2022-06-21 Russia Arkhangelsk Oblast     231369 1763 0   63.5589686 43.1221646 2022-06-22 04:20:54 Arkhangelsk Oblast, Russia
166236 166236 2022-06-21 Russia Astrakhan Oblast     117743 3013 0   47.1878186 47.608851 2022-06-22 04:20:54 Astrakhan Oblast, Russia
166237 166237 2022-06-21 Russia Bashkortostan Republic     289959 5727 0   54.8573563 57.1439682 2022-06-22 04:20:54 Bashkortostan Republic, Russia
166238 166238 2022-06-21 Russia Belgorod Oblast     131552 2276 0   50.7080119 37.5837615 2022-06-22 04:20:54 Belgorod Oblast, Russia
166239 166239 2022-06-21 Russia Bryansk Oblast     162207 4034 0   52.8873315 33.415853 2022-06-22 04:20:54 Bryansk Oblast, Russia
166240 166240 2022-06-21 Russia Buryatia Republic     137102 3035 0   52.7182426 109.492143 2022-06-22 04:20:54 Buryatia Republic, Russia
166241 166241 2022-06-21 Russia Chechen Republic     44027 1076 0   43.3976147 45.6985005 2022-06-22 04:20:54 Chechen Republic, Russia
166242 166242 2022-06-21 Russia Chelyabinsk Oblast     332616 7746 0   54.4223954 61.1865846 2022-06-22 04:20:54 Chelyabinsk Oblast, Russia
166243 166243 2022-06-21 Russia Chukotka Autonomous Okrug     5715 42 0   66.0006475 169.4900869 2022-06-22 04:20:54 Chukotka Autonomous Okrug, Russia
166244 166244 2022-06-21 Russia Chuvashia Republic     80778 4647 0   55.4259922 47.0849429 2022-06-22 04:20:54 Chuvashia Republic, Russia
166245 166245 2022-06-21 Russia Dagestan Republic     93395 3594 0   43.0574916 47.1332224 2022-06-22 04:20:54 Dagestan Republic, Russia
166246 166246 2022-06-21 Russia Ingushetia Republic     41043 550 0   43.11542075 45.01713552 2022-06-22 04:20:54 Ingushetia Republic, Russia
166247 166247 2022-06-21 Russia Irkutsk Oblast     295306 8477 0   56.6370122 104.719221 2022-06-22 04:20:54 Irkutsk Oblast, Russia
166248 166248 2022-06-21 Russia Ivanovo Oblast     112237 3132 0   56.9167446 41.4352137 2022-06-22 04:20:54 Ivanovo Oblast, Russia
166249 166249 2022-06-21 Russia Jewish Autonomous Okrug     18951 553 0   48.57527615 132.6630746 2022-06-22 04:20:54 Jewish Autonomous Okrug, Russia
166250 166250 2022-06-21 Russia Kabardino-Balkarian Republic     62073 1882 0   43.4806048 43.5978976 2022-06-22 04:20:54 Kabardino-Balkarian Republic, Russia
166251 166251 2022-06-21 Russia Kaliningrad Oblast     169228 1925 0   54.7293041 21.1489473 2022-06-22 04:20:54 Kaliningrad Oblast, Russia
166252 166252 2022-06-21 Russia Kalmykia Republic     51738 843 0   46.2313018 45.3275745 2022-06-22 04:20:54 Kalmykia Republic, Russia
166253 166253 2022-06-21 Russia Kaluga Oblast     104442 1453 0   54.4382773 35.5272854 2022-06-22 04:20:54 Kaluga Oblast, Russia
166254 166254 2022-06-21 Russia Kamchatka Krai     40143 617 0   57.1914882 160.0383819 2022-06-22 04:20:54 Kamchatka Krai, Russia
166255 166255 2022-06-21 Russia Karachay-Cherkess Republic     46076 984 0   43.7368326 41.7267991 2022-06-22 04:20:54 Karachay-Cherkess Republic, Russia
166256 166256 2022-06-21 Russia Karelia Republic     136809 1514 0   62.6194031 33.4920267 2022-06-22 04:20:54 Karelia Republic, Russia
166257 166257 2022-06-21 Russia Kemerovo Oblast     165661 2445 0   54.5335781 87.342861 2022-06-22 04:20:54 Kemerovo Oblast, Russia
166258 166258 2022-06-21 Russia Khabarovsk Krai     203603 1559 0   51.6312684 136.121524 2022-06-22 04:20:54 Khabarovsk Krai, Russia
166259 166259 2022-06-21 Russia Khakassia Republic     88091 2413 0   53.72258845 91.44293627 2022-06-22 04:20:54 Khakassia Republic, Russia
166260 166260 2022-06-21 Russia Khanty-Mansi Autonomous Okrug     211130 2553 0   61.0259025 69.0982628 2022-06-22 04:20:54 Khanty-Mansi Autonomous Okrug, Russia
166261 166261 2022-06-21 Russia Kirov Oblast     151961 1049 0   57.9665589 49.4074599 2022-06-22 04:20:54 Kirov Oblast, Russia
166262 166262 2022-06-21 Russia Komi Republic     172502 3196 0   63.9881421 54.3326073 2022-06-22 04:20:54 Komi Republic, Russia
166263 166263 2022-06-21 Russia Kostroma Oblast     89317 1401 0   58.424756 44.2533273 2022-06-22 04:20:54 Kostroma Oblast, Russia
166264 166264 2022-06-21 Russia Krasnodar Krai     262258 10951 0   45.7684014 39.0261044 2022-06-22 04:20:54 Krasnodar Krai, Russia
166265 166265 2022-06-21 Russia Krasnoyarsk Krai     366705 10866 0   63.3233807 97.0979974 2022-06-22 04:20:54 Krasnoyarsk Krai, Russia
166266 166266 2022-06-21 Russia Kurgan Oblast     104979 1439 0   55.7655302 64.5632681 2022-06-22 04:20:54 Kurgan Oblast, Russia
166267 166267 2022-06-21 Russia Kursk Oblast     119016 2485 0   51.6568453 36.4852695 2022-06-22 04:20:54 Kursk Oblast, Russia
166268 166268 2022-06-21 Russia Leningrad Oblast     188514 3490 0   60.1853296 32.3925325 2022-06-22 04:20:54 Leningrad Oblast, Russia
166269 166269 2022-06-21 Russia Lipetsk Oblast     152375 3785 0   52.6935178 39.1122664 2022-06-22 04:20:54 Lipetsk Oblast, Russia
166270 166270 2022-06-21 Russia Magadan Oblast     19828 390 0   62.48858785 153.9903764 2022-06-22 04:20:54 Magadan Oblast, Russia
166271 166271 2022-06-21 Russia Mari El Republic     44681 1087 0   56.5767504 47.8817512 2022-06-22 04:20:54 Mari El Republic, Russia
166272 166272 2022-06-21 Russia Mordovia Republic     68540 1390 0   54.4419829 44.4661144 2022-06-22 04:20:54 Mordovia Republic, Russia
166273 166273 2022-06-21 Russia Moscow     2775241 44014 0   55.7504461 37.6174943 2022-06-22 04:20:54 Moscow, Russia
166274 166274 2022-06-21 Russia Moscow Oblast     979606 15133 0   55.5043158 38.0353929 2022-06-22 04:20:54 Moscow Oblast, Russia
166275 166275 2022-06-21 Russia Murmansk Oblast     134886 3330 0   68.0000418 33.9999151 2022-06-22 04:20:54 Murmansk Oblast, Russia
166276 166276 2022-06-21 Russia Nenets Autonomous Okrug     7388 101 0   68.27557185 57.1686375 2022-06-22 04:20:54 Nenets Autonomous Okrug, Russia
166277 166277 2022-06-21 Russia Nizhny Novgorod Oblast     423019 11560 0   55.4718033 44.0911594 2022-06-22 04:20:54 Nizhny Novgorod Oblast, Russia
166278 166278 2022-06-21 Russia North Ossetia - Alania Republic     40948 1252 0   42.7933611 44.6324493 2022-06-22 04:20:54 North Ossetia - Alania Republic, Russia
166279 166279 2022-06-21 Russia Novgorod Oblast     100359 1035 0   58.2843833 32.5169757 2022-06-22 04:20:54 Novgorod Oblast, Russia
166280 166280 2022-06-21 Russia Novosibirsk Oblast     259687 5681 0   54.9720169 79.4813924 2022-06-22 04:20:54 Novosibirsk Oblast, Russia
166281 166281 2022-06-21 Russia Omsk Oblast     208430 4406 0   56.0935263 73.5099936 2022-06-22 04:20:54 Omsk Oblast, Russia
166282 166282 2022-06-21 Russia Orel Oblast     113647 1926 0   52.9685433 36.0692477 2022-06-22 04:20:54 Orel Oblast, Russia
166283 166283 2022-06-21 Russia Orenburg Oblast     217102 4024 0   52.0269262 54.7276647 2022-06-22 04:20:54 Orenburg Oblast, Russia
166284 166284 2022-06-21 Russia Penza Oblast     187624 5943 0   53.1655415 44.7879181 2022-06-22 04:20:54 Penza Oblast, Russia
166285 166285 2022-06-21 Russia Perm Krai     371039 8836 0   58.5951603 56.3159546 2022-06-22 04:20:54 Perm Krai, Russia
166286 166286 2022-06-21 Russia Primorsky Krai     175627 1966 0   45.0819456 134.726645 2022-06-22 04:20:54 Primorsky Krai, Russia
166287 166287 2022-06-21 Russia Pskov Oblast     111076 1857 0   57.5358729 28.8586826 2022-06-22 04:20:54 Pskov Oblast, Russia
166288 166288 2022-06-21 Russia Rostov Oblast     378360 10953 0   47.6222451 40.7957942 2022-06-22 04:20:54 Rostov Oblast, Russia
166289 166289 2022-06-21 Russia Ryazan Oblast     122086 3399 0   54.4226732 40.5705246 2022-06-22 04:20:54 Ryazan Oblast, Russia
166290 166290 2022-06-21 Russia Saint Petersburg     1534399 34046 0   59.9606739 30.1586551 2022-06-22 04:20:54 Saint Petersburg, Russia
166291 166291 2022-06-21 Russia Sakha (Yakutiya) Republic     181058 2118 0   66.941626 129.642371 2022-06-22 04:20:54 Sakha (Yakutiya) Republic, Russia
166292 166292 2022-06-21 Russia Sakhalin Oblast     64962 827 0   49.7219665 143.448533 2022-06-22 04:20:54 Sakhalin Oblast, Russia
166293 166293 2022-06-21 Russia Samara Oblast     385414 7892 0   53.2128813 50.8914633 2022-06-22 04:20:54 Samara Oblast, Russia
166294 166294 2022-06-21 Russia Saratov Oblast     254339 5988 0   51.6520555 46.8631952 2022-06-22 04:20:54 Saratov Oblast, Russia
166295 166295 2022-06-21 Russia Smolensk Oblast     131670 3069 0   55.0343496 33.0192065 2022-06-22 04:20:54 Smolensk Oblast, Russia
166296 166296 2022-06-21 Russia Stavropol Krai     198897 7077 0   44.8632577 43.4406913 2022-06-22 04:20:54 Stavropol Krai, Russia
166297 166297 2022-06-21 Russia Sverdlovsk Oblast     446770 10756 0   58.6414755 61.8021546 2022-06-22 04:20:54 Sverdlovsk Oblast, Russia
166298 166298 2022-06-21 Russia Tambov Oblast     117380 2431 0   52.9019574 41.3578918 2022-06-22 04:20:54 Tambov Oblast, Russia
166299 166299 2022-06-21 Russia Tatarstan Republic     152086 1995 0   55.7648572 52.43104273 2022-06-22 04:20:54 Tatarstan Republic, Russia
166300 166300 2022-06-21 Russia Tomsk Oblast     132242 855 0   58.6124279 82.0475315 2022-06-22 04:20:54 Tomsk Oblast, Russia
166301 166301 2022-06-21 Russia Tula Oblast     157675 5220 0   53.9570701 37.3690909 2022-06-22 04:20:54 Tula Oblast, Russia
166302 166302 2022-06-21 Russia Tver Oblast     163162 2747 0   57.1134475 35.1744428 2022-06-22 04:20:54 Tver Oblast, Russia
166303 166303 2022-06-21 Russia Tyumen Oblast     191959 4335 0   58.8206488 70.3658837 2022-06-22 04:20:54 Tyumen Oblast, Russia
166304 166304 2022-06-21 Russia Tyva Republic     44489 353 0   51.4017149 93.8582593 2022-06-22 04:20:54 Tyva Republic, Russia
166305 166305 2022-06-21 Russia Udmurt Republic     167311 3847 0   57.1961165 52.6959832 2022-06-22 04:20:54 Udmurt Republic, Russia
166306 166306 2022-06-21 Russia Ulyanovsk Oblast     203493 4712 0   54.1463177 47.2324921 2022-06-22 04:20:54 Ulyanovsk Oblast, Russia
166307 166307 2022-06-21 Russia Vladimir Oblast     152143 3478 0   56.0503336 40.6561633 2022-06-22 04:20:54 Vladimir Oblast, Russia
166308 166308 2022-06-21 Russia Volgograd Oblast     224061 6888 0   49.6048339 44.2903582 2022-06-22 04:20:54 Volgograd Oblast, Russia
166309 166309 2022-06-21 Russia Vologda Oblast     192073 3866 0   60.0391461 43.1215213 2022-06-22 04:20:54 Vologda Oblast, Russia
166310 166310 2022-06-21 Russia Voronezh Oblast     387505 8327 0   50.9800393 40.1506507 2022-06-22 04:20:54 Voronezh Oblast, Russia
166311 166311 2022-06-21 Russia Yamalo-Nenets Autonomous Okrug     137220 1042 0   67.1471631 74.3415488 2022-06-22 04:20:54 Yamalo-Nenets Autonomous Okrug, Russia
166312 166312 2022-06-21 Russia Yaroslavl Oblast     162812 2810 0   57.7781976 39.0021095 2022-06-22 04:20:54 Yaroslavl Oblast, Russia
166313 166313 2022-06-21 Russia Zabaykalsky Krai     169231 2347 0   52.248521 115.956325 2022-06-22 04:20:54 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]);