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-08-17 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
1556148 1556148 2020-08-16 Russia Adygea Republic     3113 23 2538 552 44.6939006 40.1520421 2020-08-17 04:27:20 Adygea Republic, Russia
1556149 1556149 2020-08-16 Russia Altai Krai     10623 98 8924 1601 52.6932243 82.69314240000001 2020-08-17 04:27:20 Altai Krai, Russia
1556150 1556150 2020-08-16 Russia Altai Republic     1818 7 1561 250 50.7114101 86.8572186 2020-08-17 04:27:20 Altai Republic, Russia
1556151 1556151 2020-08-16 Russia Amur Oblast     3060 47 2611 402 52.8032368 128.437295 2020-08-17 04:27:20 Amur Oblast, Russia
1556152 1556152 2020-08-16 Russia Arkhangelsk Oblast     9768 241 8614 913 63.5589686 43.1221646 2020-08-17 04:27:20 Arkhangelsk Oblast, Russia
1556153 1556153 2020-08-16 Russia Astrakhan Oblast     5148 58 4278 812 47.1878186 47.608851 2020-08-17 04:27:20 Astrakhan Oblast, Russia
1556154 1556154 2020-08-16 Russia Bashkortostan Republic     7298 26 6227 1045 54.8573563 57.1439682 2020-08-17 04:27:20 Bashkortostan Republic, Russia
1556155 1556155 2020-08-16 Russia Belgorod Oblast     6714 51 5846 817 50.7080119 37.5837615 2020-08-17 04:27:20 Belgorod Oblast, Russia
1556156 1556156 2020-08-16 Russia Bryansk Oblast     7830 35 6366 1429 52.8873315 33.41585300000001 2020-08-17 04:27:20 Bryansk Oblast, Russia
1556157 1556157 2020-08-16 Russia Buryatia Republic     4600 42 3991 567 52.7182426 109.492143 2020-08-17 04:27:20 Buryatia Republic, Russia
1556158 1556158 2020-08-16 Russia Chechen Republic     2190 37 1462 691 43.39761470000001 45.6985005 2020-08-17 04:27:20 Chechen Republic, Russia
1556159 1556159 2020-08-16 Russia Chelyabinsk Oblast     12668 99 8238 4331 54.4223954 61.1865846 2020-08-17 04:27:20 Chelyabinsk Oblast, Russia
1556160 1556160 2020-08-16 Russia Chukotka Autonomous Okrug     164 1 154 9 66.0006475 169.4900869 2020-08-17 04:27:20 Chukotka Autonomous Okrug, Russia
1556161 1556161 2020-08-16 Russia Chuvashia Republic     7279 68 5311 1900 55.4259922 47.0849429 2020-08-17 04:27:20 Chuvashia Republic, Russia
1556162 1556162 2020-08-16 Russia Dagestan Republic     10032 469 9001 562 43.05749160000001 47.1332224 2020-08-17 04:27:20 Dagestan Republic, Russia
1556163 1556163 2020-08-16 Russia Ingushetia Republic     4025 75 3496 454 43.11542075 45.01713552 2020-08-17 04:27:20 Ingushetia Republic, Russia
1556164 1556164 2020-08-16 Russia Irkutsk Oblast     15442 225 11214 4003 56.6370122 104.719221 2020-08-17 04:27:20 Irkutsk Oblast, Russia
1556165 1556165 2020-08-16 Russia Ivanovo Oblast     6876 111 5568 1197 56.9167446 41.43521370000001 2020-08-17 04:27:20 Ivanovo Oblast, Russia
1556166 1556166 2020-08-16 Russia Jewish Autonomous Okrug     579 8 511 60 48.57527615 132.66307460000002 2020-08-17 04:27:20 Jewish Autonomous Okrug, Russia
1556167 1556167 2020-08-16 Russia Kabardino-Balkarian Republic     6223 75 5838 310 43.4806048 43.5978976 2020-08-17 04:27:20 Kabardino-Balkarian Republic, Russia
1556168 1556168 2020-08-16 Russia Kaliningrad Oblast     3121 53 2455 613 54.7293041 21.1489473 2020-08-17 04:27:20 Kaliningrad Oblast, Russia
1556169 1556169 2020-08-16 Russia Kalmykia Republic     3360 42 2339 979 46.2313018 45.3275745 2020-08-17 04:27:20 Kalmykia Republic, Russia
1556170 1556170 2020-08-16 Russia Kaluga Oblast     7625 58 6386 1181 54.4382773 35.5272854 2020-08-17 04:27:20 Kaluga Oblast, Russia
1556171 1556171 2020-08-16 Russia Kamchatka Krai     3615 42 3082 491 57.1914882 160.03838190000005 2020-08-17 04:27:20 Kamchatka Krai, Russia
1556172 1556172 2020-08-16 Russia Karachay-Cherkess Republic     4635 25 3768 842 43.7368326 41.7267991 2020-08-17 04:27:20 Karachay-Cherkess Republic, Russia
1556173 1556173 2020-08-16 Russia Karelia Republic     2701 14 1788 899 62.61940309999999 33.4920267 2020-08-17 04:27:20 Karelia Republic, Russia
1556174 1556174 2020-08-16 Russia Kemerovo Oblast     5025 19 3489 1517 54.53357809999999 87.342861 2020-08-17 04:27:20 Kemerovo Oblast, Russia
1556175 1556175 2020-08-16 Russia Khabarovsk Krai     9014 79 6802 2133 51.6312684 136.121524 2020-08-17 04:27:20 Khabarovsk Krai, Russia
1556176 1556176 2020-08-16 Russia Khakassia Republic     3144 37 2834 273 53.72258845 91.44293627 2020-08-17 04:27:20 Khakassia Republic, Russia
1556177 1556177 2020-08-16 Russia Khanty-Mansi Autonomous Okrug     18518 149 16300 2069 61.0259025 69.0982628 2020-08-17 04:27:20 Khanty-Mansi Autonomous Okrug, Russia
1556178 1556178 2020-08-16 Russia Kirov Oblast     5631 86 4629 916 57.9665589 49.4074599 2020-08-17 04:27:20 Kirov Oblast, Russia
1556179 1556179 2020-08-16 Russia Komi Republic     6083 76 4898 1109 63.9881421 54.3326073 2020-08-17 04:27:20 Komi Republic, Russia
1556180 1556180 2020-08-16 Russia Kostroma Oblast     2906 33 1981 892 58.424756 44.2533273 2020-08-17 04:27:20 Kostroma Oblast, Russia
1556181 1556181 2020-08-16 Russia Krasnodar Krai     9903 143 8416 1344 45.7684014 39.0261044 2020-08-17 04:27:20 Krasnodar Krai, Russia
1556182 1556182 2020-08-16 Russia Krasnoyarsk Krai     15167 387 12511 2269 63.3233807 97.0979974 2020-08-17 04:27:20 Krasnoyarsk Krai, Russia
1556183 1556183 2020-08-16 Russia Kurgan Oblast     2628 14 2244 370 55.7655302 64.5632681 2020-08-17 04:27:20 Kurgan Oblast, Russia
1556184 1556184 2020-08-16 Russia Kursk Oblast     6656 51 5544 1061 51.6568453 36.4852695 2020-08-17 04:27:20 Kursk Oblast, Russia
1556185 1556185 2020-08-16 Russia Leningrad Oblast     6373 66 4731 1576 60.1853296 32.3925325 2020-08-17 04:27:20 Leningrad Oblast, Russia
1556186 1556186 2020-08-16 Russia Lipetsk Oblast     4816 23 4205 588 52.6935178 39.1122664 2020-08-17 04:27:20 Lipetsk Oblast, Russia
1556187 1556187 2020-08-16 Russia Magadan Oblast     1651 15 1236 400 62.48858785 153.9903764 2020-08-17 04:27:20 Magadan Oblast, Russia
1556188 1556188 2020-08-16 Russia Mari El Republic     4012 36 3533 443 56.5767504 47.8817512 2020-08-17 04:27:20 Mari El Republic, Russia
1556189 1556189 2020-08-16 Russia Mordovia Republic     4983 38 3877 1068 54.4419829 44.4661144 2020-08-17 04:27:20 Mordovia Republic, Russia
1556190 1556190 2020-08-16 Russia Moscow     252374 4656 197143 50575 55.7504461 37.6174943 2020-08-17 04:27:20 Moscow, Russia
1556191 1556191 2020-08-16 Russia Moscow Oblast     65935 1144 49519 15272 55.50431579999999 38.0353929 2020-08-17 04:27:20 Moscow Oblast, Russia
1556192 1556192 2020-08-16 Russia Murmansk Oblast     11849 116 8730 3003 68.00004179999999 33.9999151 2020-08-17 04:27:20 Murmansk Oblast, Russia
1556193 1556193 2020-08-16 Russia Nenets Autonomous Okrug     297 0 104 193 68.27557185 57.1686375 2020-08-17 04:27:20 Nenets Autonomous Okrug, Russia
1556194 1556194 2020-08-16 Russia Nizhny Novgorod Oblast     25758 431 22666 2661 55.47180329999999 44.0911594 2020-08-17 04:27:20 Nizhny Novgorod Oblast, Russia
1556195 1556195 2020-08-16 Russia North Ossetia - Alania Republic     4679 67 4268 344 42.79336110000001 44.6324493 2020-08-17 04:27:20 North Ossetia - Alania Republic, Russia
1556196 1556196 2020-08-16 Russia Novgorod Oblast     4029 72 2883 1074 58.2843833 32.5169757 2020-08-17 04:27:20 Novgorod Oblast, Russia
1556197 1556197 2020-08-16 Russia Novosibirsk Oblast     10621 312 9266 1043 54.9720169 79.48139240000002 2020-08-17 04:27:20 Novosibirsk Oblast, Russia
1556198 1556198 2020-08-16 Russia Omsk Oblast     8491 122 6222 2147 56.09352629999999 73.5099936 2020-08-17 04:27:20 Omsk Oblast, Russia
1556199 1556199 2020-08-16 Russia Orel Oblast     6396 98 4902 1396 52.96854329999999 36.0692477 2020-08-17 04:27:20 Orel Oblast, Russia
1556200 1556200 2020-08-16 Russia Orenburg Oblast     8585 65 6934 1586 52.02692620000001 54.7276647 2020-08-17 04:27:20 Orenburg Oblast, Russia
1556201 1556201 2020-08-16 Russia Penza Oblast     7301 96 6955 250 53.1655415 44.78791810000001 2020-08-17 04:27:20 Penza Oblast, Russia
1556202 1556202 2020-08-16 Russia Perm Krai     6982 186 4931 1865 58.5951603 56.3159546 2020-08-17 04:27:20 Perm Krai, Russia
1556203 1556203 2020-08-16 Russia Primorsky Krai     8348 97 6661 1590 45.0819456 134.726645 2020-08-17 04:27:20 Primorsky Krai, Russia
1556204 1556204 2020-08-16 Russia Pskov Oblast     4143 59 2971 1113 57.5358729 28.8586826 2020-08-17 04:27:20 Pskov Oblast, Russia
1556205 1556205 2020-08-16 Russia Rostov Oblast     14996 287 12332 2377 47.6222451 40.7957942 2020-08-17 04:27:20 Rostov Oblast, Russia
1556206 1556206 2020-08-16 Russia Ryazan Oblast     6742 38 6015 689 54.42267320000001 40.57052460000001 2020-08-17 04:27:20 Ryazan Oblast, Russia
1556207 1556207 2020-08-16 Russia Saint Petersburg     34009 2255 24555 7199 59.9606739 30.158655100000004 2020-08-17 04:27:20 Saint Petersburg, Russia
1556208 1556208 2020-08-16 Russia Sakha (Yakutiya) Republic     6703 66 5657 980 66.941626 129.642371 2020-08-17 04:27:20 Sakha (Yakutiya) Republic, Russia
1556209 1556209 2020-08-16 Russia Sakhalin Oblast     3578 0 1924 1654 49.7219665 143.448533 2020-08-17 04:27:20 Sakhalin Oblast, Russia
1556210 1556210 2020-08-16 Russia Samara Oblast     7575 117 5770 1688 53.2128813 50.8914633 2020-08-17 04:27:20 Samara Oblast, Russia
1556211 1556211 2020-08-16 Russia Saratov Oblast     10922 66 6774 4082 51.6520555 46.86319520000001 2020-08-17 04:27:20 Saratov Oblast, Russia
1556212 1556212 2020-08-16 Russia Smolensk Oblast     5932 119 4821 992 55.03434960000001 33.0192065 2020-08-17 04:27:20 Smolensk Oblast, Russia
1556213 1556213 2020-08-16 Russia Stavropol Krai     10085 195 6811 3079 44.86325770000001 43.4406913 2020-08-17 04:27:20 Stavropol Krai, Russia
1556214 1556214 2020-08-16 Russia Sverdlovsk Oblast     23405 369 19031 4005 58.6414755 61.8021546 2020-08-17 04:27:20 Sverdlovsk Oblast, Russia
1556215 1556215 2020-08-16 Russia Tambov Oblast     6408 44 5322 1042 52.9019574 41.3578918 2020-08-17 04:27:20 Tambov Oblast, Russia
1556216 1556216 2020-08-16 Russia Tatarstan Republic     6075 29 4954 1092 55.7648572 52.43104273 2020-08-17 04:27:20 Tatarstan Republic, Russia
1556217 1556217 2020-08-16 Russia Tomsk Oblast     4979 52 3673 1254 58.6124279 82.04753149999998 2020-08-17 04:27:20 Tomsk Oblast, Russia
1556218 1556218 2020-08-16 Russia Tula Oblast     8827 293 7513 1021 53.9570701 37.3690909 2020-08-17 04:27:20 Tula Oblast, Russia
1556219 1556219 2020-08-16 Russia Tver Oblast     5039 170 3996 873 57.1134475 35.174442799999994 2020-08-17 04:27:20 Tver Oblast, Russia
1556220 1556220 2020-08-16 Russia Tyumen Oblast     7020 28 6670 322 58.8206488 70.36588370000001 2020-08-17 04:27:20 Tyumen Oblast, Russia
1556221 1556221 2020-08-16 Russia Tyva Republic     6482 60 5649 773 51.4017149 93.8582593 2020-08-17 04:27:20 Tyva Republic, Russia
1556222 1556222 2020-08-16 Russia Udmurt Republic     2764 34 2282 448 57.1961165 52.69598320000001 2020-08-17 04:27:20 Udmurt Republic, Russia
1556223 1556223 2020-08-16 Russia Ulyanovsk Oblast     10737 73 7695 2969 54.1463177 47.2324921 2020-08-17 04:27:20 Ulyanovsk Oblast, Russia
1556224 1556224 2020-08-16 Russia Vladimir Oblast     5948 184 5280 484 56.0503336 40.6561633 2020-08-17 04:27:20 Vladimir Oblast, Russia
1556225 1556225 2020-08-16 Russia Volgograd Oblast     10668 79 6850 3739 49.6048339 44.29035820000001 2020-08-17 04:27:20 Volgograd Oblast, Russia
1556226 1556226 2020-08-16 Russia Vologda Oblast     2881 30 2385 466 60.0391461 43.1215213 2020-08-17 04:27:20 Vologda Oblast, Russia
1556227 1556227 2020-08-16 Russia Voronezh Oblast     12655 97 11033 1525 50.9800393 40.15065070000001 2020-08-17 04:27:20 Voronezh Oblast, Russia
1556228 1556228 2020-08-16 Russia Yamalo-Nenets Autonomous Okrug     12528 82 11555 891 67.1471631 74.3415488 2020-08-17 04:27:20 Yamalo-Nenets Autonomous Okrug, Russia
1556229 1556229 2020-08-16 Russia Yaroslavl Oblast     6655 32 5945 678 57.77819760000001 39.0021095 2020-08-17 04:27:20 Yaroslavl Oblast, Russia
1556230 1556230 2020-08-16 Russia Zabaykalsky Krai     4301 51 4000 250 52.248521 115.956325 2020-08-17 04:27:20 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]);