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-05-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
2725205 2725205 2022-05-28 Russia Adygea Republic     49400 1002 0   44.6939006 40.1520421 2022-05-29 04:20:53 Adygea Republic, Russia
2725206 2725206 2022-05-28 Russia Altai Krai     268594 8642 0   52.6932243 82.6931424 2022-05-29 04:20:53 Altai Krai, Russia
2725207 2725207 2022-05-28 Russia Altai Republic     34386 618 0   50.7114101 86.8572186 2022-05-29 04:20:53 Altai Republic, Russia
2725208 2725208 2022-05-28 Russia Amur Oblast     107804 764 0   52.8032368 128.437295 2022-05-29 04:20:53 Amur Oblast, Russia
2725209 2725209 2022-05-28 Russia Arkhangelsk Oblast     230106 1762 0   63.5589686 43.1221646 2022-05-29 04:20:53 Arkhangelsk Oblast, Russia
2725210 2725210 2022-05-28 Russia Astrakhan Oblast     117034 3006 0   47.1878186 47.608851 2022-05-29 04:20:53 Astrakhan Oblast, Russia
2725211 2725211 2022-05-28 Russia Bashkortostan Republic     288271 5674 0   54.8573563 57.1439682 2022-05-29 04:20:53 Bashkortostan Republic, Russia
2725212 2725212 2022-05-28 Russia Belgorod Oblast     130780 2264 0   50.7080119 37.5837615 2022-05-29 04:20:53 Belgorod Oblast, Russia
2725213 2725213 2022-05-28 Russia Bryansk Oblast     161833 4022 0   52.8873315 33.415853 2022-05-29 04:20:53 Bryansk Oblast, Russia
2725214 2725214 2022-05-28 Russia Buryatia Republic     136627 3026 0   52.7182426 109.492143 2022-05-29 04:20:53 Buryatia Republic, Russia
2725215 2725215 2022-05-28 Russia Chechen Republic     43718 1076 0   43.3976147 45.6985005 2022-05-29 04:20:53 Chechen Republic, Russia
2725216 2725216 2022-05-28 Russia Chelyabinsk Oblast     330261 7681 0   54.4223954 61.1865846 2022-05-29 04:20:53 Chelyabinsk Oblast, Russia
2725217 2725217 2022-05-28 Russia Chukotka Autonomous Okrug     5695 42 0   66.0006475 169.4900869 2022-05-29 04:20:53 Chukotka Autonomous Okrug, Russia
2725218 2725218 2022-05-28 Russia Chuvashia Republic     79865 4637 0   55.4259922 47.0849429 2022-05-29 04:20:53 Chuvashia Republic, Russia
2725219 2725219 2022-05-28 Russia Dagestan Republic     93224 3593 0   43.0574916 47.1332224 2022-05-29 04:20:53 Dagestan Republic, Russia
2725220 2725220 2022-05-28 Russia Ingushetia Republic     40947 550 0   43.11542075 45.01713552 2022-05-29 04:20:53 Ingushetia Republic, Russia
2725221 2725221 2022-05-28 Russia Irkutsk Oblast     293767 8457 0   56.6370122 104.719221 2022-05-29 04:20:53 Irkutsk Oblast, Russia
2725222 2725222 2022-05-28 Russia Ivanovo Oblast     111472 3118 0   56.9167446 41.4352137 2022-05-29 04:20:53 Ivanovo Oblast, Russia
2725223 2725223 2022-05-28 Russia Jewish Autonomous Okrug     18781 545 0   48.57527615 132.6630746 2022-05-29 04:20:53 Jewish Autonomous Okrug, Russia
2725224 2725224 2022-05-28 Russia Kabardino-Balkarian Republic     61903 1875 0   43.4806048 43.5978976 2022-05-29 04:20:53 Kabardino-Balkarian Republic, Russia
2725225 2725225 2022-05-28 Russia Kaliningrad Oblast     168770 1914 0   54.7293041 21.1489473 2022-05-29 04:20:53 Kaliningrad Oblast, Russia
2725226 2725226 2022-05-28 Russia Kalmykia Republic     51553 843 0   46.2313018 45.3275745 2022-05-29 04:20:53 Kalmykia Republic, Russia
2725227 2725227 2022-05-28 Russia Kaluga Oblast     103908 1453 0   54.4382773 35.5272854 2022-05-29 04:20:53 Kaluga Oblast, Russia
2725228 2725228 2022-05-28 Russia Kamchatka Krai     39910 615 0   57.1914882 160.0383819 2022-05-29 04:20:53 Kamchatka Krai, Russia
2725229 2725229 2022-05-28 Russia Karachay-Cherkess Republic     46025 984 0   43.7368326 41.7267991 2022-05-29 04:20:53 Karachay-Cherkess Republic, Russia
2725230 2725230 2022-05-28 Russia Karelia Republic     135528 1509 0   62.6194031 33.4920267 2022-05-29 04:20:53 Karelia Republic, Russia
2725231 2725231 2022-05-28 Russia Kemerovo Oblast     164067 2383 0   54.5335781 87.342861 2022-05-29 04:20:53 Kemerovo Oblast, Russia
2725232 2725232 2022-05-28 Russia Khabarovsk Krai     202286 1552 0   51.6312684 136.121524 2022-05-29 04:20:53 Khabarovsk Krai, Russia
2725233 2725233 2022-05-28 Russia Khakassia Republic     87824 2410 0   53.72258845 91.44293627 2022-05-29 04:20:53 Khakassia Republic, Russia
2725234 2725234 2022-05-28 Russia Khanty-Mansi Autonomous Okrug     210583 2546 0   61.0259025 69.0982628 2022-05-29 04:20:53 Khanty-Mansi Autonomous Okrug, Russia
2725235 2725235 2022-05-28 Russia Kirov Oblast     151722 1045 0   57.9665589 49.4074599 2022-05-29 04:20:53 Kirov Oblast, Russia
2725236 2725236 2022-05-28 Russia Komi Republic     171856 3182 0   63.9881421 54.3326073 2022-05-29 04:20:53 Komi Republic, Russia
2725237 2725237 2022-05-28 Russia Kostroma Oblast     89036 1386 0   58.424756 44.2533273 2022-05-29 04:20:53 Kostroma Oblast, Russia
2725238 2725238 2022-05-28 Russia Krasnodar Krai     260913 10920 0   45.7684014 39.0261044 2022-05-29 04:20:53 Krasnodar Krai, Russia
2725239 2725239 2022-05-28 Russia Krasnoyarsk Krai     365609 10828 0   63.3233807 97.0979974 2022-05-29 04:20:53 Krasnoyarsk Krai, Russia
2725240 2725240 2022-05-28 Russia Kurgan Oblast     104506 1434 0   55.7655302 64.5632681 2022-05-29 04:20:53 Kurgan Oblast, Russia
2725241 2725241 2022-05-28 Russia Kursk Oblast     118196 2481 0   51.6568453 36.4852695 2022-05-29 04:20:53 Kursk Oblast, Russia
2725242 2725242 2022-05-28 Russia Leningrad Oblast     187592 3483 0   60.1853296 32.3925325 2022-05-29 04:20:53 Leningrad Oblast, Russia
2725243 2725243 2022-05-28 Russia Lipetsk Oblast     151249 3761 0   52.6935178 39.1122664 2022-05-29 04:20:53 Lipetsk Oblast, Russia
2725244 2725244 2022-05-28 Russia Magadan Oblast     19804 390 0   62.48858785 153.9903764 2022-05-29 04:20:53 Magadan Oblast, Russia
2725245 2725245 2022-05-28 Russia Mari El Republic     44611 1087 0   56.5767504 47.8817512 2022-05-29 04:20:53 Mari El Republic, Russia
2725246 2725246 2022-05-28 Russia Mordovia Republic     68090 1388 0   54.4419829 44.4661144 2022-05-29 04:20:53 Mordovia Republic, Russia
2725247 2725247 2022-05-28 Russia Moscow     2769901 43697 0   55.7504461 37.6174943 2022-05-29 04:20:53 Moscow, Russia
2725248 2725248 2022-05-28 Russia Moscow Oblast     975241 15080 0   55.5043158 38.0353929 2022-05-29 04:20:53 Moscow Oblast, Russia
2725249 2725249 2022-05-28 Russia Murmansk Oblast     134586 3323 0   68.0000418 33.9999151 2022-05-29 04:20:53 Murmansk Oblast, Russia
2725250 2725250 2022-05-28 Russia Nenets Autonomous Okrug     7364 100 0   68.27557185 57.1686375 2022-05-29 04:20:53 Nenets Autonomous Okrug, Russia
2725251 2725251 2022-05-28 Russia Nizhny Novgorod Oblast     420854 11519 0   55.4718033 44.0911594 2022-05-29 04:20:53 Nizhny Novgorod Oblast, Russia
2725252 2725252 2022-05-28 Russia North Ossetia - Alania Republic     40842 1252 0   42.7933611 44.6324493 2022-05-29 04:20:53 North Ossetia - Alania Republic, Russia
2725253 2725253 2022-05-28 Russia Novgorod Oblast     99762 1032 0   58.2843833 32.5169757 2022-05-29 04:20:53 Novgorod Oblast, Russia
2725254 2725254 2022-05-28 Russia Novosibirsk Oblast     258376 5660 0   54.9720169 79.4813924 2022-05-29 04:20:53 Novosibirsk Oblast, Russia
2725255 2725255 2022-05-28 Russia Omsk Oblast     207460 4384 0   56.0935263 73.5099936 2022-05-29 04:20:53 Omsk Oblast, Russia
2725256 2725256 2022-05-28 Russia Orel Oblast     112886 1921 0   52.9685433 36.0692477 2022-05-29 04:20:53 Orel Oblast, Russia
2725257 2725257 2022-05-28 Russia Orenburg Oblast     216429 4004 0   52.0269262 54.7276647 2022-05-29 04:20:53 Orenburg Oblast, Russia
2725258 2725258 2022-05-28 Russia Penza Oblast     186686 5897 0   53.1655415 44.7879181 2022-05-29 04:20:53 Penza Oblast, Russia
2725259 2725259 2022-05-28 Russia Perm Krai     369741 8798 0   58.5951603 56.3159546 2022-05-29 04:20:53 Perm Krai, Russia
2725260 2725260 2022-05-28 Russia Primorsky Krai     175065 1964 0   45.0819456 134.726645 2022-05-29 04:20:53 Primorsky Krai, Russia
2725261 2725261 2022-05-28 Russia Pskov Oblast     110547 1843 0   57.5358729 28.8586826 2022-05-29 04:20:53 Pskov Oblast, Russia
2725262 2725262 2022-05-28 Russia Rostov Oblast     376265 10928 0   47.6222451 40.7957942 2022-05-29 04:20:53 Rostov Oblast, Russia
2725263 2725263 2022-05-28 Russia Ryazan Oblast     121107 3383 0   54.4226732 40.5705246 2022-05-29 04:20:53 Ryazan Oblast, Russia
2725264 2725264 2022-05-28 Russia Saint Petersburg     1528742 33803 0   59.9606739 30.1586551 2022-05-29 04:20:53 Saint Petersburg, Russia
2725265 2725265 2022-05-28 Russia Sakha (Yakutiya) Republic     180119 2114 0   66.941626 129.642371 2022-05-29 04:20:53 Sakha (Yakutiya) Republic, Russia
2725266 2725266 2022-05-28 Russia Sakhalin Oblast     64816 826 0   49.7219665 143.448533 2022-05-29 04:20:53 Sakhalin Oblast, Russia
2725267 2725267 2022-05-28 Russia Samara Oblast     383947 7863 0   53.2128813 50.8914633 2022-05-29 04:20:53 Samara Oblast, Russia
2725268 2725268 2022-05-28 Russia Saratov Oblast     252142 5963 0   51.6520555 46.8631952 2022-05-29 04:20:53 Saratov Oblast, Russia
2725269 2725269 2022-05-28 Russia Smolensk Oblast     131160 3053 0   55.0343496 33.0192065 2022-05-29 04:20:53 Smolensk Oblast, Russia
2725270 2725270 2022-05-28 Russia Stavropol Krai     197697 7066 0   44.8632577 43.4406913 2022-05-29 04:20:53 Stavropol Krai, Russia
2725271 2725271 2022-05-28 Russia Sverdlovsk Oblast     444225 10745 0   58.6414755 61.8021546 2022-05-29 04:20:53 Sverdlovsk Oblast, Russia
2725272 2725272 2022-05-28 Russia Tambov Oblast     116803 2410 0   52.9019574 41.3578918 2022-05-29 04:20:53 Tambov Oblast, Russia
2725273 2725273 2022-05-28 Russia Tatarstan Republic     149710 1995 0   55.7648572 52.43104273 2022-05-29 04:20:53 Tatarstan Republic, Russia
2725274 2725274 2022-05-28 Russia Tomsk Oblast     131427 839 0   58.6124279 82.0475315 2022-05-29 04:20:53 Tomsk Oblast, Russia
2725275 2725275 2022-05-28 Russia Tula Oblast     156628 5198 0   53.9570701 37.3690909 2022-05-29 04:20:53 Tula Oblast, Russia
2725276 2725276 2022-05-28 Russia Tver Oblast     162493 2740 0   57.1134475 35.1744428 2022-05-29 04:20:53 Tver Oblast, Russia
2725277 2725277 2022-05-28 Russia Tyumen Oblast     191669 4327 0   58.8206488 70.3658837 2022-05-29 04:20:53 Tyumen Oblast, Russia
2725278 2725278 2022-05-28 Russia Tyva Republic     44476 351 0   51.4017149 93.8582593 2022-05-29 04:20:53 Tyva Republic, Russia
2725279 2725279 2022-05-28 Russia Udmurt Republic     166833 3839 0   57.1961165 52.6959832 2022-05-29 04:20:53 Udmurt Republic, Russia
2725280 2725280 2022-05-28 Russia Ulyanovsk Oblast     202857 4687 0   54.1463177 47.2324921 2022-05-29 04:20:53 Ulyanovsk Oblast, Russia
2725281 2725281 2022-05-28 Russia Vladimir Oblast     151667 3462 0   56.0503336 40.6561633 2022-05-29 04:20:53 Vladimir Oblast, Russia
2725282 2725282 2022-05-28 Russia Volgograd Oblast     221081 6879 0   49.6048339 44.2903582 2022-05-29 04:20:53 Volgograd Oblast, Russia
2725283 2725283 2022-05-28 Russia Vologda Oblast     190981 3844 0   60.0391461 43.1215213 2022-05-29 04:20:53 Vologda Oblast, Russia
2725284 2725284 2022-05-28 Russia Voronezh Oblast     384641 8297 0   50.9800393 40.1506507 2022-05-29 04:20:53 Voronezh Oblast, Russia
2725285 2725285 2022-05-28 Russia Yamalo-Nenets Autonomous Okrug     137017 1041 0   67.1471631 74.3415488 2022-05-29 04:20:53 Yamalo-Nenets Autonomous Okrug, Russia
2725286 2725286 2022-05-28 Russia Yaroslavl Oblast     161417 2806 0   57.7781976 39.0021095 2022-05-29 04:20:53 Yaroslavl Oblast, Russia
2725287 2725287 2022-05-28 Russia Zabaykalsky Krai     168778 2342 0   52.248521 115.956325 2022-05-29 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]);