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 2021-01-28 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
3153786 3153786 2021-01-27 Russia Adygea Republic     12844 115 10927 1802 44.6939006 40.1520421 2021-01-28 05:22:24 Adygea Republic, Russia
3153787 3153787 2021-01-27 Russia Altai Krai     38271 1143 34537 2591 52.6932243 82.69314240000001 2021-01-28 05:22:24 Altai Krai, Russia
3153788 3153788 2021-01-27 Russia Altai Republic     15196 130 14104 962 50.7114101 86.8572186 2021-01-28 05:22:24 Altai Republic, Russia
3153789 3153789 2021-01-27 Russia Amur Oblast     19126 136 17342 1648 52.8032368 128.437295 2021-01-28 05:22:24 Amur Oblast, Russia
3153790 3153790 2021-01-27 Russia Arkhangelsk Oblast     50256 459 42579 7218 63.5589686 43.1221646 2021-01-28 05:22:24 Arkhangelsk Oblast, Russia
3153791 3153791 2021-01-27 Russia Astrakhan Oblast     23780 472 14889 8419 47.1878186 47.608851 2021-01-28 05:22:24 Astrakhan Oblast, Russia
3153792 3153792 2021-01-27 Russia Bashkortostan Republic     23577 178 17763 5636 54.8573563 57.1439682 2021-01-28 05:22:24 Bashkortostan Republic, Russia
3153793 3153793 2021-01-27 Russia Belgorod Oblast     26762 352 24305 2105 50.7080119 37.5837615 2021-01-28 05:22:24 Belgorod Oblast, Russia
3153794 3153794 2021-01-27 Russia Bryansk Oblast     28358 238 27123 997 52.8873315 33.41585300000001 2021-01-28 05:22:24 Bryansk Oblast, Russia
3153795 3153795 2021-01-27 Russia Buryatia Republic     29813 656 27303 1854 52.7182426 109.492143 2021-01-28 05:22:24 Buryatia Republic, Russia
3153796 3153796 2021-01-27 Russia Chechen Republic     10646 106 9102 1438 43.39761470000001 45.6985005 2021-01-28 05:22:24 Chechen Republic, Russia
3153797 3153797 2021-01-27 Russia Chelyabinsk Oblast     42695 746 30703 11246 54.4223954 61.1865846 2021-01-28 05:22:24 Chelyabinsk Oblast, Russia
3153798 3153798 2021-01-27 Russia Chukotka Autonomous Okrug     615 4 552 59 66.0006475 169.4900869 2021-01-28 05:22:24 Chukotka Autonomous Okrug, Russia
3153799 3153799 2021-01-27 Russia Chuvashia Republic     19102 830 17213 1059 55.4259922 47.0849429 2021-01-28 05:22:24 Chuvashia Republic, Russia
3153800 3153800 2021-01-27 Russia Dagestan Republic     27564 1226 24371 1967 43.05749160000001 47.1332224 2021-01-28 05:22:24 Dagestan Republic, Russia
3153801 3153801 2021-01-27 Russia Ingushetia Republic     13784 159 11993 1632 43.11542075 45.01713552 2021-01-28 05:22:24 Ingushetia Republic, Russia
3153802 3153802 2021-01-27 Russia Irkutsk Oblast     47612 1523 42374 3715 56.6370122 104.719221 2021-01-28 05:22:24 Irkutsk Oblast, Russia
3153803 3153803 2021-01-27 Russia Ivanovo Oblast     26085 724 22298 3063 56.9167446 41.43521370000001 2021-01-28 05:22:24 Ivanovo Oblast, Russia
3153804 3153804 2021-01-27 Russia Jewish Autonomous Okrug     4122 104 3677 341 48.57527615 132.66307460000002 2021-01-28 05:22:24 Jewish Autonomous Okrug, Russia
3153805 3153805 2021-01-27 Russia Kabardino-Balkarian Republic     18423 318 17201 904 43.4806048 43.5978976 2021-01-28 05:22:24 Kabardino-Balkarian Republic, Russia
3153806 3153806 2021-01-27 Russia Kaliningrad Oblast     23305 215 20547 2543 54.7293041 21.1489473 2021-01-28 05:22:24 Kaliningrad Oblast, Russia
3153807 3153807 2021-01-27 Russia Kalmykia Republic     17113 245 14732 2136 46.2313018 45.3275745 2021-01-28 05:22:24 Kalmykia Republic, Russia
3153808 3153808 2021-01-27 Russia Kaluga Oblast     25369 212 23205 1952 54.4382773 35.5272854 2021-01-28 05:22:24 Kaluga Oblast, Russia
3153809 3153809 2021-01-27 Russia Kamchatka Krai     12044 84 10637 1323 57.1914882 160.03838190000005 2021-01-28 05:22:24 Kamchatka Krai, Russia
3153810 3153810 2021-01-27 Russia Karachay-Cherkess Republic     17297 51 15592 1654 43.7368326 41.7267991 2021-01-28 05:22:24 Karachay-Cherkess Republic, Russia
3153811 3153811 2021-01-27 Russia Karelia Republic     34938 219 29604 5115 62.61940309999999 33.4920267 2021-01-28 05:22:24 Karelia Republic, Russia
3153812 3153812 2021-01-27 Russia Kemerovo Oblast     28940 514 26767 1659 54.53357809999999 87.342861 2021-01-28 05:22:24 Kemerovo Oblast, Russia
3153813 3153813 2021-01-27 Russia Khabarovsk Krai     43370 246 39556 3568 51.6312684 136.121524 2021-01-28 05:22:24 Khabarovsk Krai, Russia
3153814 3153814 2021-01-27 Russia Khakassia Republic     20176 374 18533 1269 53.72258845 91.44293627 2021-01-28 05:22:24 Khakassia Republic, Russia
3153815 3153815 2021-01-27 Russia Khanty-Mansi Autonomous Okrug     46919 652 43548 2719 61.0259025 69.0982628 2021-01-28 05:22:24 Khanty-Mansi Autonomous Okrug, Russia
3153816 3153816 2021-01-27 Russia Kirov Oblast     31682 262 26098 5322 57.9665589 49.4074599 2021-01-28 05:22:24 Kirov Oblast, Russia
3153817 3153817 2021-01-27 Russia Komi Republic     35813 680 34503 630 63.9881421 54.3326073 2021-01-28 05:22:24 Komi Republic, Russia
3153818 3153818 2021-01-27 Russia Kostroma Oblast     16828 284 13526 3018 58.424756 44.2533273 2021-01-28 05:22:24 Kostroma Oblast, Russia
3153819 3153819 2021-01-27 Russia Krasnodar Krai     32932 1393 23625 7914 45.7684014 39.0261044 2021-01-28 05:22:24 Krasnodar Krai, Russia
3153820 3153820 2021-01-27 Russia Krasnoyarsk Krai     55184 2244 50792 2148 63.3233807 97.0979974 2021-01-28 05:22:24 Krasnoyarsk Krai, Russia
3153821 3153821 2021-01-27 Russia Kurgan Oblast     14852 204 13063 1585 55.7655302 64.5632681 2021-01-28 05:22:24 Kurgan Oblast, Russia
3153822 3153822 2021-01-27 Russia Kursk Oblast     25571 359 22491 2721 51.6568453 36.4852695 2021-01-28 05:22:24 Kursk Oblast, Russia
3153823 3153823 2021-01-27 Russia Leningrad Oblast     29818 386 26847 2585 60.1853296 32.3925325 2021-01-28 05:22:24 Leningrad Oblast, Russia
3153824 3153824 2021-01-27 Russia Lipetsk Oblast     20333 360 16340 3633 52.6935178 39.1122664 2021-01-28 05:22:24 Lipetsk Oblast, Russia
3153825 3153825 2021-01-27 Russia Magadan Oblast     7770 84 7334 352 62.48858785 153.9903764 2021-01-28 05:22:24 Magadan Oblast, Russia
3153826 3153826 2021-01-27 Russia Mari El Republic     10489 151 9154 1184 56.5767504 47.8817512 2021-01-28 05:22:24 Mari El Republic, Russia
3153827 3153827 2021-01-27 Russia Mordovia Republic     15736 131 13156 2449 54.4419829 44.4661144 2021-01-28 05:22:24 Mordovia Republic, Russia
3153828 3153828 2021-01-27 Russia Moscow     919662 13175 791320 115167 55.7504461 37.6174943 2021-01-28 05:22:24 Moscow, Russia
3153829 3153829 2021-01-27 Russia Moscow Oblast     188608 3619 148881 36108 55.50431579999999 38.0353929 2021-01-28 05:22:24 Moscow Oblast, Russia
3153830 3153830 2021-01-27 Russia Murmansk Oblast     42456 801 38699 2956 68.00004179999999 33.9999151 2021-01-28 05:22:24 Murmansk Oblast, Russia
3153831 3153831 2021-01-27 Russia Nenets Autonomous Okrug     890 0 768 122 68.27557185 57.1686375 2021-01-28 05:22:24 Nenets Autonomous Okrug, Russia
3153832 3153832 2021-01-27 Russia Nizhny Novgorod Oblast     82560 2062 74655 5843 55.47180329999999 44.0911594 2021-01-28 05:22:24 Nizhny Novgorod Oblast, Russia
3153833 3153833 2021-01-27 Russia North Ossetia - Alania Republic     14186 113 12634 1439 42.79336110000001 44.6324493 2021-01-28 05:22:24 North Ossetia - Alania Republic, Russia
3153834 3153834 2021-01-27 Russia Novgorod Oblast     23417 110 19228 4079 58.2843833 32.5169757 2021-01-28 05:22:24 Novgorod Oblast, Russia
3153835 3153835 2021-01-27 Russia Novosibirsk Oblast     31709 1191 28896 1622 54.9720169 79.48139240000002 2021-01-28 05:22:24 Novosibirsk Oblast, Russia
3153836 3153836 2021-01-27 Russia Omsk Oblast     36484 1069 33279 2136 56.09352629999999 73.5099936 2021-01-28 05:22:24 Omsk Oblast, Russia
3153837 3153837 2021-01-27 Russia Orel Oblast     26070 335 22965 2770 52.96854329999999 36.0692477 2021-01-28 05:22:24 Orel Oblast, Russia
3153838 3153838 2021-01-27 Russia Orenburg Oblast     33420 457 29633 3330 52.02692620000001 54.7276647 2021-01-28 05:22:24 Orenburg Oblast, Russia
3153839 3153839 2021-01-27 Russia Penza Oblast     31813 373 25162 6278 53.1655415 44.78791810000001 2021-01-28 05:22:24 Penza Oblast, Russia
3153840 3153840 2021-01-27 Russia Perm Krai     38651 1405 31905 5341 58.5951603 56.3159546 2021-01-28 05:22:24 Perm Krai, Russia
3153841 3153841 2021-01-27 Russia Primorsky Krai     35487 503 26808 8176 45.0819456 134.726645 2021-01-28 05:22:24 Primorsky Krai, Russia
3153842 3153842 2021-01-27 Russia Pskov Oblast     28773 127 16982 11664 57.5358729 28.8586826 2021-01-28 05:22:24 Pskov Oblast, Russia
3153843 3153843 2021-01-27 Russia Rostov Oblast     62193 2562 51621 8010 47.6222451 40.7957942 2021-01-28 05:22:24 Rostov Oblast, Russia
3153844 3153844 2021-01-27 Russia Ryazan Oblast     21477 223 19564 1690 54.42267320000001 40.57052460000001 2021-01-28 05:22:24 Ryazan Oblast, Russia
3153845 3153845 2021-01-27 Russia Saint Petersburg     325032 9502 217888 97642 59.9606739 30.158655100000004 2021-01-28 05:22:24 Saint Petersburg, Russia
3153846 3153846 2021-01-27 Russia Sakha (Yakutiya) Republic     30126 479 26948 2699 66.941626 129.642371 2021-01-28 05:22:24 Sakha (Yakutiya) Republic, Russia
3153847 3153847 2021-01-27 Russia Sakhalin Oblast     19305 23 16354 2928 49.7219665 143.448533 2021-01-28 05:22:24 Sakhalin Oblast, Russia
3153848 3153848 2021-01-27 Russia Samara Oblast     39136 803 36137 2196 53.2128813 50.8914633 2021-01-28 05:22:24 Samara Oblast, Russia
3153849 3153849 2021-01-27 Russia Saratov Oblast     42206 524 36765 4917 51.6520555 46.86319520000001 2021-01-28 05:22:24 Saratov Oblast, Russia
3153850 3153850 2021-01-27 Russia Smolensk Oblast     21625 436 18398 2791 55.03434960000001 33.0192065 2021-01-28 05:22:24 Smolensk Oblast, Russia
3153851 3153851 2021-01-27 Russia Stavropol Krai     41557 910 37336 3311 44.86325770000001 43.4406913 2021-01-28 05:22:24 Stavropol Krai, Russia
3153852 3153852 2021-01-27 Russia Sverdlovsk Oblast     69030 1973 61564 5493 58.6414755 61.8021546 2021-01-28 05:22:24 Sverdlovsk Oblast, Russia
3153853 3153853 2021-01-27 Russia Tambov Oblast     21933 259 20354 1320 52.9019574 41.3578918 2021-01-28 05:22:24 Tambov Oblast, Russia
3153854 3153854 2021-01-27 Russia Tatarstan Republic     15707 264 12138 3305 55.7648572 52.43104273 2021-01-28 05:22:24 Tatarstan Republic, Russia
3153855 3153855 2021-01-27 Russia Tomsk Oblast     27832 255 24897 2680 58.6124279 82.04753149999998 2021-01-28 05:22:24 Tomsk Oblast, Russia
3153856 3153856 2021-01-27 Russia Tula Oblast     28233 972 25396 1865 53.9570701 37.3690909 2021-01-28 05:22:24 Tula Oblast, Russia
3153857 3153857 2021-01-27 Russia Tver Oblast     28278 507 24303 3468 57.1134475 35.174442799999994 2021-01-28 05:22:24 Tver Oblast, Russia
3153858 3153858 2021-01-27 Russia Tyumen Oblast     27651 241 26012 1398 58.8206488 70.36588370000001 2021-01-28 05:22:24 Tyumen Oblast, Russia
3153859 3153859 2021-01-27 Russia Tyva Republic     15351 187 14182 982 51.4017149 93.8582593 2021-01-28 05:22:24 Tyva Republic, Russia
3153860 3153860 2021-01-27 Russia Udmurt Republic     24941 482 21265 3194 57.1961165 52.69598320000001 2021-01-28 05:22:24 Udmurt Republic, Russia
3153861 3153861 2021-01-27 Russia Ulyanovsk Oblast     42991 583 39262 3146 54.1463177 47.2324921 2021-01-28 05:22:24 Ulyanovsk Oblast, Russia
3153862 3153862 2021-01-27 Russia Vladimir Oblast     22894 654 20086 2154 56.0503336 40.6561633 2021-01-28 05:22:24 Vladimir Oblast, Russia
3153863 3153863 2021-01-27 Russia Volgograd Oblast     42381 587 40421 1373 49.6048339 44.29035820000001 2021-01-28 05:22:24 Volgograd Oblast, Russia
3153864 3153864 2021-01-27 Russia Vologda Oblast     31692 590 26947 4155 60.0391461 43.1215213 2021-01-28 05:22:24 Vologda Oblast, Russia
3153865 3153865 2021-01-27 Russia Voronezh Oblast     56708 1512 50935 4261 50.9800393 40.15065070000001 2021-01-28 05:22:24 Voronezh Oblast, Russia
3153866 3153866 2021-01-27 Russia Yamalo-Nenets Autonomous Okrug     35354 373 30869 4112 67.1471631 74.3415488 2021-01-28 05:22:24 Yamalo-Nenets Autonomous Okrug, Russia
3153867 3153867 2021-01-27 Russia Yaroslavl Oblast     27380 303 25685 1392 57.77819760000001 39.0021095 2021-01-28 05:22:24 Yaroslavl Oblast, Russia
3153868 3153868 2021-01-27 Russia Zabaykalsky Krai     33383 458 31222 1703 52.248521 115.956325 2021-01-28 05:22:24 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]);