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 2020-09-16 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
2729181 2729181 2020-09-15 Russia Adygea Republic     3689 30 3161 498 44.6939006 40.1520421 2020-09-16 04:22:53 Adygea Republic, Russia
2729182 2729182 2020-09-15 Russia Altai Krai     12651 152 11328 1171 52.6932243 82.69314240000001 2020-09-16 04:22:53 Altai Krai, Russia
2729183 2729183 2020-09-15 Russia Altai Republic     2584 12 2128 444 50.7114101 86.8572186 2020-09-16 04:22:53 Altai Republic, Russia
2729184 2729184 2020-09-15 Russia Amur Oblast     3842 50 3376 416 52.8032368 128.437295 2020-09-16 04:22:53 Amur Oblast, Russia
2729185 2729185 2020-09-15 Russia Arkhangelsk Oblast     11932 256 9625 2051 63.5589686 43.1221646 2020-09-16 04:22:53 Arkhangelsk Oblast, Russia
2729186 2729186 2020-09-15 Russia Astrakhan Oblast     6356 89 6048 219 47.1878186 47.608851 2020-09-16 04:22:53 Astrakhan Oblast, Russia
2729187 2729187 2020-09-15 Russia Bashkortostan Republic     8254 31 7899 324 54.8573563 57.1439682 2020-09-16 04:22:53 Bashkortostan Republic, Russia
2729188 2729188 2020-09-15 Russia Belgorod Oblast     8008 55 7389 564 50.7080119 37.5837615 2020-09-16 04:22:53 Belgorod Oblast, Russia
2729189 2729189 2020-09-15 Russia Bryansk Oblast     8733 35 7090 1608 52.8873315 33.41585300000001 2020-09-16 04:22:53 Bryansk Oblast, Russia
2729190 2729190 2020-09-15 Russia Buryatia Republic     5937 61 5039 837 52.7182426 109.492143 2020-09-16 04:22:53 Buryatia Republic, Russia
2729191 2729191 2020-09-15 Russia Chechen Republic     2352 40 1782 530 43.39761470000001 45.6985005 2020-09-16 04:22:53 Chechen Republic, Russia
2729192 2729192 2020-09-15 Russia Chelyabinsk Oblast     14652 111 10611 3930 54.4223954 61.1865846 2020-09-16 04:22:53 Chelyabinsk Oblast, Russia
2729193 2729193 2020-09-15 Russia Chukotka Autonomous Okrug     180 2 169 9 66.0006475 169.4900869 2020-09-16 04:22:53 Chukotka Autonomous Okrug, Russia
2729194 2729194 2020-09-15 Russia Chuvashia Republic     8194 81 6890 1223 55.4259922 47.0849429 2020-09-16 04:22:53 Chuvashia Republic, Russia
2729195 2729195 2020-09-15 Russia Dagestan Republic     12175 528 10468 1179 43.05749160000001 47.1332224 2020-09-16 04:22:53 Dagestan Republic, Russia
2729196 2729196 2020-09-15 Russia Ingushetia Republic     4949 77 4295 577 43.11542075 45.01713552 2020-09-16 04:22:53 Ingushetia Republic, Russia
2729197 2729197 2020-09-15 Russia Irkutsk Oblast     17905 264 14312 3329 56.6370122 104.719221 2020-09-16 04:22:53 Irkutsk Oblast, Russia
2729198 2729198 2020-09-15 Russia Ivanovo Oblast     8009 126 6561 1322 56.9167446 41.43521370000001 2020-09-16 04:22:53 Ivanovo Oblast, Russia
2729199 2729199 2020-09-15 Russia Jewish Autonomous Okrug     733 10 625 98 48.57527615 132.66307460000002 2020-09-16 04:22:53 Jewish Autonomous Okrug, Russia
2729200 2729200 2020-09-15 Russia Kabardino-Balkarian Republic     7023 83 6298 642 43.4806048 43.5978976 2020-09-16 04:22:53 Kabardino-Balkarian Republic, Russia
2729201 2729201 2020-09-15 Russia Kaliningrad Oblast     3810 61 3014 735 54.7293041 21.1489473 2020-09-16 04:22:53 Kaliningrad Oblast, Russia
2729202 2729202 2020-09-15 Russia Kalmykia Republic     5451 65 3252 2134 46.2313018 45.3275745 2020-09-16 04:22:53 Kalmykia Republic, Russia
2729203 2729203 2020-09-15 Russia Kaluga Oblast     8502 71 7246 1185 54.4382773 35.5272854 2020-09-16 04:22:53 Kaluga Oblast, Russia
2729204 2729204 2020-09-15 Russia Kamchatka Krai     4122 64 3228 830 57.1914882 160.03838190000005 2020-09-16 04:22:53 Kamchatka Krai, Russia
2729205 2729205 2020-09-15 Russia Karachay-Cherkess Republic     6027 28 4611 1388 43.7368326 41.7267991 2020-09-16 04:22:53 Karachay-Cherkess Republic, Russia
2729206 2729206 2020-09-15 Russia Karelia Republic     3485 16 2533 936 62.61940309999999 33.4920267 2020-09-16 04:22:53 Karelia Republic, Russia
2729207 2729207 2020-09-15 Russia Kemerovo Oblast     7809 55 5923 1831 54.53357809999999 87.342861 2020-09-16 04:22:53 Kemerovo Oblast, Russia
2729208 2729208 2020-09-15 Russia Khabarovsk Krai     11059 97 8920 2042 51.6312684 136.121524 2020-09-16 04:22:53 Khabarovsk Krai, Russia
2729209 2729209 2020-09-15 Russia Khakassia Republic     3835 47 3294 494 53.72258845 91.44293627 2020-09-16 04:22:53 Khakassia Republic, Russia
2729210 2729210 2020-09-15 Russia Khanty-Mansi Autonomous Okrug     20748 178 19931 639 61.0259025 69.0982628 2020-09-16 04:22:53 Khanty-Mansi Autonomous Okrug, Russia
2729211 2729211 2020-09-15 Russia Kirov Oblast     7512 112 5374 2026 57.9665589 49.4074599 2020-09-16 04:22:53 Kirov Oblast, Russia
2729212 2729212 2020-09-15 Russia Komi Republic     7165 91 6147 927 63.9881421 54.3326073 2020-09-16 04:22:53 Komi Republic, Russia
2729213 2729213 2020-09-15 Russia Kostroma Oblast     4115 53 2995 1067 58.424756 44.2533273 2020-09-16 04:22:53 Kostroma Oblast, Russia
2729214 2729214 2020-09-15 Russia Krasnodar Krai     12563 228 9952 2383 45.7684014 39.0261044 2020-09-16 04:22:53 Krasnodar Krai, Russia
2729215 2729215 2020-09-15 Russia Krasnoyarsk Krai     18445 523 14376 3546 63.3233807 97.0979974 2020-09-16 04:22:53 Krasnoyarsk Krai, Russia
2729216 2729216 2020-09-15 Russia Kurgan Oblast     3361 23 2891 447 55.7655302 64.5632681 2020-09-16 04:22:53 Kurgan Oblast, Russia
2729217 2729217 2020-09-15 Russia Kursk Oblast     7558 55 6364 1139 51.6568453 36.4852695 2020-09-16 04:22:53 Kursk Oblast, Russia
2729218 2729218 2020-09-15 Russia Leningrad Oblast     7339 90 5253 1996 60.1853296 32.3925325 2020-09-16 04:22:53 Leningrad Oblast, Russia
2729219 2729219 2020-09-15 Russia Lipetsk Oblast     5582 34 4922 626 52.6935178 39.1122664 2020-09-16 04:22:53 Lipetsk Oblast, Russia
2729220 2729220 2020-09-15 Russia Magadan Oblast     2372 19 1858 495 62.48858785 153.9903764 2020-09-16 04:22:53 Magadan Oblast, Russia
2729221 2729221 2020-09-15 Russia Mari El Republic     4527 46 3999 482 56.5767504 47.8817512 2020-09-16 04:22:53 Mari El Republic, Russia
2729222 2729222 2020-09-15 Russia Mordovia Republic     5931 39 4843 1049 54.4419829 44.4661144 2020-09-16 04:22:53 Mordovia Republic, Russia
2729223 2729223 2020-09-15 Russia Moscow     272523 5006 231483 36034 55.7504461 37.6174943 2020-09-16 04:22:53 Moscow, Russia
2729224 2729224 2020-09-15 Russia Moscow Oblast     70658 1255 53731 15672 55.50431579999999 38.0353929 2020-09-16 04:22:53 Moscow Oblast, Russia
2729225 2729225 2020-09-15 Russia Murmansk Oblast     13836 185 11346 2305 68.00004179999999 33.9999151 2020-09-16 04:22:53 Murmansk Oblast, Russia
2729226 2729226 2020-09-15 Russia Nenets Autonomous Okrug     323 0 114 209 68.27557185 57.1686375 2020-09-16 04:22:53 Nenets Autonomous Okrug, Russia
2729227 2729227 2020-09-15 Russia Nizhny Novgorod Oblast     29943 529 26513 2901 55.47180329999999 44.0911594 2020-09-16 04:22:53 Nizhny Novgorod Oblast, Russia
2729228 2729228 2020-09-15 Russia North Ossetia - Alania Republic     5311 68 4558 685 42.79336110000001 44.6324493 2020-09-16 04:22:53 North Ossetia - Alania Republic, Russia
2729229 2729229 2020-09-15 Russia Novgorod Oblast     4716 86 3454 1176 58.2843833 32.5169757 2020-09-16 04:22:53 Novgorod Oblast, Russia
2729230 2729230 2020-09-15 Russia Novosibirsk Oblast     12207 398 10934 875 54.9720169 79.48139240000002 2020-09-16 04:22:53 Novosibirsk Oblast, Russia
2729231 2729231 2020-09-15 Russia Omsk Oblast     10006 248 8576 1182 56.09352629999999 73.5099936 2020-09-16 04:22:53 Omsk Oblast, Russia
2729232 2729232 2020-09-15 Russia Orel Oblast     7774 116 6158 1500 52.96854329999999 36.0692477 2020-09-16 04:22:53 Orel Oblast, Russia
2729233 2729233 2020-09-15 Russia Orenburg Oblast     11328 82 10208 1038 52.02692620000001 54.7276647 2020-09-16 04:22:53 Orenburg Oblast, Russia
2729234 2729234 2020-09-15 Russia Penza Oblast     9484 118 8301 1065 53.1655415 44.78791810000001 2020-09-16 04:22:53 Penza Oblast, Russia
2729235 2729235 2020-09-15 Russia Perm Krai     8746 240 6069 2437 58.5951603 56.3159546 2020-09-16 04:22:53 Perm Krai, Russia
2729236 2729236 2020-09-15 Russia Primorsky Krai     10701 110 9086 1505 45.0819456 134.726645 2020-09-16 04:22:53 Primorsky Krai, Russia
2729237 2729237 2020-09-15 Russia Pskov Oblast     4982 65 3743 1174 57.5358729 28.8586826 2020-09-16 04:22:53 Pskov Oblast, Russia
2729238 2729238 2020-09-15 Russia Rostov Oblast     19195 410 15640 3145 47.6222451 40.7957942 2020-09-16 04:22:53 Rostov Oblast, Russia
2729239 2729239 2020-09-15 Russia Ryazan Oblast     7614 47 6483 1084 54.42267320000001 40.57052460000001 2020-09-16 04:22:53 Ryazan Oblast, Russia
2729240 2729240 2020-09-15 Russia Saint Petersburg     39681 2676 27294 9711 59.9606739 30.158655100000004 2020-09-16 04:22:53 Saint Petersburg, Russia
2729241 2729241 2020-09-15 Russia Sakha (Yakutiya) Republic     8263 90 6458 1715 66.941626 129.642371 2020-09-16 04:22:53 Sakha (Yakutiya) Republic, Russia
2729242 2729242 2020-09-15 Russia Sakhalin Oblast     5081 0 3467 1614 49.7219665 143.448533 2020-09-16 04:22:53 Sakhalin Oblast, Russia
2729243 2729243 2020-09-15 Russia Samara Oblast     10066 144 7817 2105 53.2128813 50.8914633 2020-09-16 04:22:53 Samara Oblast, Russia
2729244 2729244 2020-09-15 Russia Saratov Oblast     13897 87 9055 4755 51.6520555 46.86319520000001 2020-09-16 04:22:53 Saratov Oblast, Russia
2729245 2729245 2020-09-15 Russia Smolensk Oblast     6358 136 5568 654 55.03434960000001 33.0192065 2020-09-16 04:22:53 Smolensk Oblast, Russia
2729246 2729246 2020-09-15 Russia Stavropol Krai     13933 274 9610 4049 44.86325770000001 43.4406913 2020-09-16 04:22:53 Stavropol Krai, Russia
2729247 2729247 2020-09-15 Russia Sverdlovsk Oblast     27172 533 20842 5797 58.6414755 61.8021546 2020-09-16 04:22:53 Sverdlovsk Oblast, Russia
2729248 2729248 2020-09-15 Russia Tambov Oblast     7153 46 6255 852 52.9019574 41.3578918 2020-09-16 04:22:53 Tambov Oblast, Russia
2729249 2729249 2020-09-15 Russia Tatarstan Republic     6880 41 5662 1177 55.7648572 52.43104273 2020-09-16 04:22:53 Tatarstan Republic, Russia
2729250 2729250 2020-09-15 Russia Tomsk Oblast     6479 77 5251 1151 58.6124279 82.04753149999998 2020-09-16 04:22:53 Tomsk Oblast, Russia
2729251 2729251 2020-09-15 Russia Tula Oblast     9686 350 8654 682 53.9570701 37.3690909 2020-09-16 04:22:53 Tula Oblast, Russia
2729252 2729252 2020-09-15 Russia Tver Oblast     5755 217 4351 1187 57.1134475 35.174442799999994 2020-09-16 04:22:53 Tver Oblast, Russia
2729253 2729253 2020-09-15 Russia Tyumen Oblast     8520 32 7300 1188 58.8206488 70.36588370000001 2020-09-16 04:22:53 Tyumen Oblast, Russia
2729254 2729254 2020-09-15 Russia Tyva Republic     7187 67 6506 614 51.4017149 93.8582593 2020-09-16 04:22:53 Tyva Republic, Russia
2729255 2729255 2020-09-15 Russia Udmurt Republic     3961 55 3028 878 57.1961165 52.69598320000001 2020-09-16 04:22:53 Udmurt Republic, Russia
2729256 2729256 2020-09-15 Russia Ulyanovsk Oblast     13661 134 11518 2009 54.1463177 47.2324921 2020-09-16 04:22:53 Ulyanovsk Oblast, Russia
2729257 2729257 2020-09-15 Russia Vladimir Oblast     6772 199 5694 879 56.0503336 40.6561633 2020-09-16 04:22:53 Vladimir Oblast, Russia
2729258 2729258 2020-09-15 Russia Volgograd Oblast     13570 126 11817 1627 49.6048339 44.29035820000001 2020-09-16 04:22:53 Volgograd Oblast, Russia
2729259 2729259 2020-09-15 Russia Vologda Oblast     3950 44 3377 529 60.0391461 43.1215213 2020-09-16 04:22:53 Vologda Oblast, Russia
2729260 2729260 2020-09-15 Russia Voronezh Oblast     15751 140 14715 896 50.9800393 40.15065070000001 2020-09-16 04:22:53 Voronezh Oblast, Russia
2729261 2729261 2020-09-15 Russia Yamalo-Nenets Autonomous Okrug     14162 97 13188 877 67.1471631 74.3415488 2020-09-16 04:22:53 Yamalo-Nenets Autonomous Okrug, Russia
2729262 2729262 2020-09-15 Russia Yaroslavl Oblast     7851 43 7350 458 57.77819760000001 39.0021095 2020-09-16 04:22:53 Yaroslavl Oblast, Russia
2729263 2729263 2020-09-15 Russia Zabaykalsky Krai     5261 64 4499 698 52.248521 115.956325 2020-09-16 04:22: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]);