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-11-18 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
3338772 3338772 2020-11-17 Russia Adygea Republic     6975 58 5686 1231 44.6939006 40.1520421 2020-11-18 05:40:31 Adygea Republic, Russia
3338773 3338773 2020-11-17 Russia Altai Krai     23154 452 20361 2341 52.6932243 82.69314240000001 2020-11-18 05:40:31 Altai Krai, Russia
3338774 3338774 2020-11-17 Russia Altai Republic     9702 20 7407 2275 50.7114101 86.8572186 2020-11-18 05:40:31 Altai Republic, Russia
3338775 3338775 2020-11-17 Russia Amur Oblast     9355 77 6809 2469 52.8032368 128.437295 2020-11-18 05:40:31 Amur Oblast, Russia
3338776 3338776 2020-11-17 Russia Arkhangelsk Oblast     26639 315 15665 10659 63.5589686 43.1221646 2020-11-18 05:40:31 Arkhangelsk Oblast, Russia
3338777 3338777 2020-11-17 Russia Astrakhan Oblast     11797 215 8449 3133 47.1878186 47.608851 2020-11-18 05:40:31 Astrakhan Oblast, Russia
3338778 3338778 2020-11-17 Russia Bashkortostan Republic     12565 69 11185 1311 54.8573563 57.1439682 2020-11-18 05:40:31 Bashkortostan Republic, Russia
3338779 3338779 2020-11-17 Russia Belgorod Oblast     14043 67 12168 1808 50.7080119 37.5837615 2020-11-18 05:40:31 Belgorod Oblast, Russia
3338780 3338780 2020-11-17 Russia Bryansk Oblast     15511 99 11394 4018 52.8873315 33.41585300000001 2020-11-18 05:40:31 Bryansk Oblast, Russia
3338781 3338781 2020-11-17 Russia Buryatia Republic     15378 295 13140 1943 52.7182426 109.492143 2020-11-18 05:40:31 Buryatia Republic, Russia
3338782 3338782 2020-11-17 Russia Chechen Republic     3254 52 2229 973 43.39761470000001 45.6985005 2020-11-18 05:40:31 Chechen Republic, Russia
3338783 3338783 2020-11-17 Russia Chelyabinsk Oblast     22194 174 20490 1530 54.4223954 61.1865846 2020-11-18 05:40:31 Chelyabinsk Oblast, Russia
3338784 3338784 2020-11-17 Russia Chukotka Autonomous Okrug     300 3 244 53 66.0006475 169.4900869 2020-11-18 05:40:31 Chukotka Autonomous Okrug, Russia
3338785 3338785 2020-11-17 Russia Chuvashia Republic     11108 203 9720 1185 55.4259922 47.0849429 2020-11-18 05:40:31 Chuvashia Republic, Russia
3338786 3338786 2020-11-17 Russia Dagestan Republic     17619 850 15781 988 43.05749160000001 47.1332224 2020-11-18 05:40:31 Dagestan Republic, Russia
3338787 3338787 2020-11-17 Russia Ingushetia Republic     8473 104 7016 1353 43.11542075 45.01713552 2020-11-18 05:40:31 Ingushetia Republic, Russia
3338788 3338788 2020-11-17 Russia Irkutsk Oblast     28591 613 24533 3445 56.6370122 104.719221 2020-11-18 05:40:31 Irkutsk Oblast, Russia
3338789 3338789 2020-11-17 Russia Ivanovo Oblast     13797 210 9619 3968 56.9167446 41.43521370000001 2020-11-18 05:40:31 Ivanovo Oblast, Russia
3338790 3338790 2020-11-17 Russia Jewish Autonomous Okrug     2586 47 1423 1116 48.57527615 132.66307460000002 2020-11-18 05:40:31 Jewish Autonomous Okrug, Russia
3338791 3338791 2020-11-17 Russia Kabardino-Balkarian Republic     11539 181 8415 2943 43.4806048 43.5978976 2020-11-18 05:40:31 Kabardino-Balkarian Republic, Russia
3338792 3338792 2020-11-17 Russia Kaliningrad Oblast     9099 105 5858 3136 54.7293041 21.1489473 2020-11-18 05:40:31 Kaliningrad Oblast, Russia
3338793 3338793 2020-11-17 Russia Kalmykia Republic     10605 120 8031 2454 46.2313018 45.3275745 2020-11-18 05:40:31 Kalmykia Republic, Russia
3338794 3338794 2020-11-17 Russia Kaluga Oblast     14168 97 10787 3284 54.4382773 35.5272854 2020-11-18 05:40:31 Kaluga Oblast, Russia
3338795 3338795 2020-11-17 Russia Kamchatka Krai     6774 70 4422 2282 57.1914882 160.03838190000005 2020-11-18 05:40:31 Kamchatka Krai, Russia
3338796 3338796 2020-11-17 Russia Karachay-Cherkess Republic     11090 34 7042 4014 43.7368326 41.7267991 2020-11-18 05:40:31 Karachay-Cherkess Republic, Russia
3338797 3338797 2020-11-17 Russia Karelia Republic     10609 73 5245 5291 62.61940309999999 33.4920267 2020-11-18 05:40:31 Karelia Republic, Russia
3338798 3338798 2020-11-17 Russia Kemerovo Oblast     18481 319 14996 3166 54.53357809999999 87.342861 2020-11-18 05:40:31 Kemerovo Oblast, Russia
3338799 3338799 2020-11-17 Russia Khabarovsk Krai     20485 147 13111 7227 51.6312684 136.121524 2020-11-18 05:40:31 Khabarovsk Krai, Russia
3338800 3338800 2020-11-17 Russia Khakassia Republic     9740 100 6660 2980 53.72258845 91.44293627 2020-11-18 05:40:31 Khakassia Republic, Russia
3338801 3338801 2020-11-17 Russia Khanty-Mansi Autonomous Okrug     31652 329 26464 4859 61.0259025 69.0982628 2020-11-18 05:40:31 Khanty-Mansi Autonomous Okrug, Russia
3338802 3338802 2020-11-17 Russia Kirov Oblast     15081 185 8518 6378 57.9665589 49.4074599 2020-11-18 05:40:31 Kirov Oblast, Russia
3338803 3338803 2020-11-17 Russia Komi Republic     17677 289 12236 5152 63.9881421 54.3326073 2020-11-18 05:40:31 Komi Republic, Russia
3338804 3338804 2020-11-17 Russia Kostroma Oblast     9603 167 5943 3493 58.424756 44.2533273 2020-11-18 05:40:31 Kostroma Oblast, Russia
3338805 3338805 2020-11-17 Russia Krasnodar Krai     19869 516 12655 6698 45.7684014 39.0261044 2020-11-18 05:40:31 Krasnodar Krai, Russia
3338806 3338806 2020-11-17 Russia Krasnoyarsk Krai     31882 858 24342 6682 63.3233807 97.0979974 2020-11-18 05:40:31 Krasnoyarsk Krai, Russia
3338807 3338807 2020-11-17 Russia Kurgan Oblast     7367 109 6622 636 55.7655302 64.5632681 2020-11-18 05:40:31 Kurgan Oblast, Russia
3338808 3338808 2020-11-17 Russia Kursk Oblast     13274 153 9896 3225 51.6568453 36.4852695 2020-11-18 05:40:31 Kursk Oblast, Russia
3338809 3338809 2020-11-17 Russia Leningrad Oblast     14288 126 8602 5560 60.1853296 32.3925325 2020-11-18 05:40:31 Leningrad Oblast, Russia
3338810 3338810 2020-11-17 Russia Lipetsk Oblast     9722 88 7716 1918 52.6935178 39.1122664 2020-11-18 05:40:31 Lipetsk Oblast, Russia
3338811 3338811 2020-11-17 Russia Magadan Oblast     5120 48 4082 990 62.48858785 153.9903764 2020-11-18 05:40:31 Magadan Oblast, Russia
3338812 3338812 2020-11-17 Russia Mari El Republic     6913 79 5813 1021 56.5767504 47.8817512 2020-11-18 05:40:31 Mari El Republic, Russia
3338813 3338813 2020-11-17 Russia Mordovia Republic     9605 56 7905 1644 54.4419829 44.4661144 2020-11-18 05:40:31 Mordovia Republic, Russia
3338814 3338814 2020-11-17 Russia Moscow     522456 7933 377131 137392 55.7504461 37.6174943 2020-11-18 05:40:31 Moscow, Russia
3338815 3338815 2020-11-17 Russia Moscow Oblast     98306 1826 72319 24161 55.50431579999999 38.0353929 2020-11-18 05:40:31 Moscow Oblast, Russia
3338816 3338816 2020-11-17 Russia Murmansk Oblast     23843 394 19555 3894 68.00004179999999 33.9999151 2020-11-18 05:40:31 Murmansk Oblast, Russia
3338817 3338817 2020-11-17 Russia Nenets Autonomous Okrug     587 0 329 258 68.27557185 57.1686375 2020-11-18 05:40:31 Nenets Autonomous Okrug, Russia
3338818 3338818 2020-11-17 Russia Nizhny Novgorod Oblast     48617 996 40741 6880 55.47180329999999 44.0911594 2020-11-18 05:40:31 Nizhny Novgorod Oblast, Russia
3338819 3338819 2020-11-17 Russia North Ossetia - Alania Republic     8390 72 6173 2145 42.79336110000001 44.6324493 2020-11-18 05:40:31 North Ossetia - Alania Republic, Russia
3338820 3338820 2020-11-17 Russia Novgorod Oblast     9397 89 5863 3445 58.2843833 32.5169757 2020-11-18 05:40:31 Novgorod Oblast, Russia
3338821 3338821 2020-11-17 Russia Novosibirsk Oblast     20354 666 16515 3173 54.9720169 79.48139240000002 2020-11-18 05:40:31 Novosibirsk Oblast, Russia
3338822 3338822 2020-11-17 Russia Omsk Oblast     19479 458 15233 3788 56.09352629999999 73.5099936 2020-11-18 05:40:31 Omsk Oblast, Russia
3338823 3338823 2020-11-17 Russia Orel Oblast     14215 171 10975 3069 52.96854329999999 36.0692477 2020-11-18 05:40:31 Orel Oblast, Russia
3338824 3338824 2020-11-17 Russia Orenburg Oblast     20753 163 18008 2582 52.02692620000001 54.7276647 2020-11-18 05:40:31 Orenburg Oblast, Russia
3338825 3338825 2020-11-17 Russia Penza Oblast     18092 219 13405 4468 53.1655415 44.78791810000001 2020-11-18 05:40:31 Penza Oblast, Russia
3338826 3338826 2020-11-17 Russia Perm Krai     16902 484 11425 4993 58.5951603 56.3159546 2020-11-18 05:40:31 Perm Krai, Russia
3338827 3338827 2020-11-17 Russia Primorsky Krai     18937 197 14010 4730 45.0819456 134.726645 2020-11-18 05:40:31 Primorsky Krai, Russia
3338828 3338828 2020-11-17 Russia Pskov Oblast     10035 72 5119 4844 57.5358729 28.8586826 2020-11-18 05:40:31 Pskov Oblast, Russia
3338829 3338829 2020-11-17 Russia Rostov Oblast     35907 1094 28774 6039 47.6222451 40.7957942 2020-11-18 05:40:31 Rostov Oblast, Russia
3338830 3338830 2020-11-17 Russia Ryazan Oblast     12540 73 9275 3192 54.42267320000001 40.57052460000001 2020-11-18 05:40:31 Ryazan Oblast, Russia
3338831 3338831 2020-11-17 Russia Saint Petersburg     85873 4620 50831 30422 59.9606739 30.158655100000004 2020-11-18 05:40:31 Saint Petersburg, Russia
3338832 3338832 2020-11-17 Russia Sakha (Yakutiya) Republic     17192 217 10510 6465 66.941626 129.642371 2020-11-18 05:40:31 Sakha (Yakutiya) Republic, Russia
3338833 3338833 2020-11-17 Russia Sakhalin Oblast     9673 5 6534 3134 49.7219665 143.448533 2020-11-18 05:40:31 Sakhalin Oblast, Russia
3338834 3338834 2020-11-17 Russia Samara Oblast     19294 364 17297 1633 53.2128813 50.8914633 2020-11-18 05:40:31 Samara Oblast, Russia
3338835 3338835 2020-11-17 Russia Saratov Oblast     24005 194 17240 6571 51.6520555 46.86319520000001 2020-11-18 05:40:31 Saratov Oblast, Russia
3338836 3338836 2020-11-17 Russia Smolensk Oblast     10677 257 7294 3126 55.03434960000001 33.0192065 2020-11-18 05:40:31 Smolensk Oblast, Russia
3338837 3338837 2020-11-17 Russia Stavropol Krai     24809 485 21080 3244 44.86325770000001 43.4406913 2020-11-18 05:40:31 Stavropol Krai, Russia
3338838 3338838 2020-11-17 Russia Sverdlovsk Oblast     41361 907 33519 6935 58.6414755 61.8021546 2020-11-18 05:40:31 Sverdlovsk Oblast, Russia
3338839 3338839 2020-11-17 Russia Tambov Oblast     11645 66 9542 2037 52.9019574 41.3578918 2020-11-18 05:40:31 Tambov Oblast, Russia
3338840 3338840 2020-11-17 Russia Tatarstan Republic     9366 123 8223 1020 55.7648572 52.43104273 2020-11-18 05:40:31 Tatarstan Republic, Russia
3338841 3338841 2020-11-17 Russia Tomsk Oblast     15839 140 10300 5399 58.6124279 82.04753149999998 2020-11-18 05:40:31 Tomsk Oblast, Russia
3338842 3338842 2020-11-17 Russia Tula Oblast     14606 454 12279 1873 53.9570701 37.3690909 2020-11-18 05:40:31 Tula Oblast, Russia
3338843 3338843 2020-11-17 Russia Tver Oblast     12573 355 7402 4816 57.1134475 35.174442799999994 2020-11-18 05:40:31 Tver Oblast, Russia
3338844 3338844 2020-11-17 Russia Tyumen Oblast     16076 113 10631 5332 58.8206488 70.36588370000001 2020-11-18 05:40:31 Tyumen Oblast, Russia
3338845 3338845 2020-11-17 Russia Tyva Republic     11090 122 10182 786 51.4017149 93.8582593 2020-11-18 05:40:31 Tyva Republic, Russia
3338846 3338846 2020-11-17 Russia Udmurt Republic     11237 260 9674 1303 57.1961165 52.69598320000001 2020-11-18 05:40:31 Udmurt Republic, Russia
3338847 3338847 2020-11-17 Russia Ulyanovsk Oblast     24455 306 19663 4486 54.1463177 47.2324921 2020-11-18 05:40:31 Ulyanovsk Oblast, Russia
3338848 3338848 2020-11-17 Russia Vladimir Oblast     11543 277 8808 2458 56.0503336 40.6561633 2020-11-18 05:40:31 Vladimir Oblast, Russia
3338849 3338849 2020-11-17 Russia Volgograd Oblast     24085 256 22251 1578 49.6048339 44.29035820000001 2020-11-18 05:40:31 Volgograd Oblast, Russia
3338850 3338850 2020-11-17 Russia Vologda Oblast     9151 74 7677 1400 60.0391461 43.1215213 2020-11-18 05:40:31 Vologda Oblast, Russia
3338851 3338851 2020-11-17 Russia Voronezh Oblast     30270 437 28551 1282 50.9800393 40.15065070000001 2020-11-18 05:40:31 Voronezh Oblast, Russia
3338852 3338852 2020-11-17 Russia Yamalo-Nenets Autonomous Okrug     23787 203 16283 7301 67.1471631 74.3415488 2020-11-18 05:40:31 Yamalo-Nenets Autonomous Okrug, Russia
3338853 3338853 2020-11-17 Russia Yaroslavl Oblast     14059 70 12759 1230 57.77819760000001 39.0021095 2020-11-18 05:40:31 Yaroslavl Oblast, Russia
3338854 3338854 2020-11-17 Russia Zabaykalsky Krai     15752 235 12991 2526 52.248521 115.956325 2020-11-18 05:40:31 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]);