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-04-09 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
2645934 2645934 2021-04-08 Russia Adygea Republic     14184 168 13564 452 44.6939006 40.1520421 2021-04-09 04:21:13 Adygea Republic, Russia
2645935 2645935 2021-04-08 Russia Altai Krai     47873 1898 42952 3023 52.6932243 82.69314240000001 2021-04-09 04:21:13 Altai Krai, Russia
2645936 2645936 2021-04-08 Russia Altai Republic     16720 200 16381 139 50.7114101 86.8572186 2021-04-09 04:21:13 Altai Republic, Russia
2645937 2645937 2021-04-08 Russia Amur Oblast     22022 259 20921 842 52.8032368 128.437295 2021-04-09 04:21:13 Amur Oblast, Russia
2645938 2645938 2021-04-08 Russia Arkhangelsk Oblast     60340 836 56055 3449 63.5589686 43.1221646 2021-04-09 04:21:13 Arkhangelsk Oblast, Russia
2645939 2645939 2021-04-08 Russia Astrakhan Oblast     31258 687 29751 820 47.1878186 47.608851 2021-04-09 04:21:13 Astrakhan Oblast, Russia
2645940 2645940 2021-04-08 Russia Bashkortostan Republic     33191 387 28981 3823 54.8573563 57.1439682 2021-04-09 04:21:13 Bashkortostan Republic, Russia
2645941 2645941 2021-04-08 Russia Belgorod Oblast     34962 581 32865 1516 50.7080119 37.5837615 2021-04-09 04:21:13 Belgorod Oblast, Russia
2645942 2645942 2021-04-08 Russia Bryansk Oblast     36362 293 35513 556 52.8873315 33.41585300000001 2021-04-09 04:21:13 Bryansk Oblast, Russia
2645943 2645943 2021-04-08 Russia Buryatia Republic     36374 800 34831 743 52.7182426 109.492143 2021-04-09 04:21:13 Buryatia Republic, Russia
2645944 2645944 2021-04-08 Russia Chechen Republic     11752 117 11445 190 43.39761470000001 45.6985005 2021-04-09 04:21:13 Chechen Republic, Russia
2645945 2645945 2021-04-08 Russia Chelyabinsk Oblast     56394 1282 51881 3231 54.4223954 61.1865846 2021-04-09 04:21:13 Chelyabinsk Oblast, Russia
2645946 2645946 2021-04-08 Russia Chukotka Autonomous Okrug     738 6 698 34 66.0006475 169.4900869 2021-04-09 04:21:13 Chukotka Autonomous Okrug, Russia
2645947 2645947 2021-04-08 Russia Chuvashia Republic     23134 1268 21091 775 55.4259922 47.0849429 2021-04-09 04:21:13 Chuvashia Republic, Russia
2645948 2645948 2021-04-08 Russia Dagestan Republic     31389 1416 29049 924 43.05749160000001 47.1332224 2021-04-09 04:21:13 Dagestan Republic, Russia
2645949 2645949 2021-04-08 Russia Ingushetia Republic     15197 181 13471 1545 43.11542075 45.01713552 2021-04-09 04:21:13 Ingushetia Republic, Russia
2645950 2645950 2021-04-08 Russia Irkutsk Oblast     62903 2075 59979 849 56.6370122 104.719221 2021-04-09 04:21:13 Irkutsk Oblast, Russia
2645951 2645951 2021-04-08 Russia Ivanovo Oblast     33063 1074 31540 449 56.9167446 41.43521370000001 2021-04-09 04:21:13 Ivanovo Oblast, Russia
2645952 2645952 2021-04-08 Russia Jewish Autonomous Okrug     4451 125 4256 70 48.57527615 132.66307460000002 2021-04-09 04:21:13 Jewish Autonomous Okrug, Russia
2645953 2645953 2021-04-08 Russia Kabardino-Balkarian Republic     23116 428 22082 606 43.4806048 43.5978976 2021-04-09 04:21:13 Kabardino-Balkarian Republic, Russia
2645954 2645954 2021-04-08 Russia Kaliningrad Oblast     30632 345 28357 1930 54.7293041 21.1489473 2021-04-09 04:21:13 Kaliningrad Oblast, Russia
2645955 2645955 2021-04-08 Russia Kalmykia Republic     20136 322 19289 525 46.2313018 45.3275745 2021-04-09 04:21:13 Kalmykia Republic, Russia
2645956 2645956 2021-04-08 Russia Kaluga Oblast     32817 293 30651 1873 54.4382773 35.5272854 2021-04-09 04:21:13 Kaluga Oblast, Russia
2645957 2645957 2021-04-08 Russia Kamchatka Krai     14228 211 13442 575 57.1914882 160.03838190000005 2021-04-09 04:21:13 Kamchatka Krai, Russia
2645958 2645958 2021-04-08 Russia Karachay-Cherkess Republic     19790 72 19270 448 43.7368326 41.7267991 2021-04-09 04:21:13 Karachay-Cherkess Republic, Russia
2645959 2645959 2021-04-08 Russia Karelia Republic     44451 409 42236 1806 62.61940309999999 33.4920267 2021-04-09 04:21:13 Karelia Republic, Russia
2645960 2645960 2021-04-08 Russia Kemerovo Oblast     33677 628 32771 278 54.53357809999999 87.342861 2021-04-09 04:21:13 Kemerovo Oblast, Russia
2645961 2645961 2021-04-08 Russia Khabarovsk Krai     51004 359 48675 1970 51.6312684 136.121524 2021-04-09 04:21:13 Khabarovsk Krai, Russia
2645962 2645962 2021-04-08 Russia Khakassia Republic     21952 512 21245 195 53.72258845 91.44293627 2021-04-09 04:21:13 Khakassia Republic, Russia
2645963 2645963 2021-04-08 Russia Khanty-Mansi Autonomous Okrug     54723 785 53261 677 61.0259025 69.0982628 2021-04-09 04:21:13 Khanty-Mansi Autonomous Okrug, Russia
2645964 2645964 2021-04-08 Russia Kirov Oblast     40431 330 36969 3132 57.9665589 49.4074599 2021-04-09 04:21:13 Kirov Oblast, Russia
2645965 2645965 2021-04-08 Russia Komi Republic     42146 827 40979 340 63.9881421 54.3326073 2021-04-09 04:21:13 Komi Republic, Russia
2645966 2645966 2021-04-08 Russia Kostroma Oblast     19973 405 17183 2385 58.424756 44.2533273 2021-04-09 04:21:13 Kostroma Oblast, Russia
2645967 2645967 2021-04-08 Russia Krasnodar Krai     43229 2415 37967 2847 45.7684014 39.0261044 2021-04-09 04:21:13 Krasnodar Krai, Russia
2645968 2645968 2021-04-08 Russia Krasnoyarsk Krai     67760 3246 62689 1825 63.3233807 97.0979974 2021-04-09 04:21:13 Krasnoyarsk Krai, Russia
2645969 2645969 2021-04-08 Russia Kurgan Oblast     19541 362 17844 1335 55.7655302 64.5632681 2021-04-09 04:21:13 Kurgan Oblast, Russia
2645970 2645970 2021-04-08 Russia Kursk Oblast     34749 612 31597 2540 51.6568453 36.4852695 2021-04-09 04:21:13 Kursk Oblast, Russia
2645971 2645971 2021-04-08 Russia Leningrad Oblast     40614 1019 38001 1594 60.1853296 32.3925325 2021-04-09 04:21:13 Leningrad Oblast, Russia
2645972 2645972 2021-04-08 Russia Lipetsk Oblast     28268 566 25106 2596 52.6935178 39.1122664 2021-04-09 04:21:13 Lipetsk Oblast, Russia
2645973 2645973 2021-04-08 Russia Magadan Oblast     8271 99 8074 98 62.48858785 153.9903764 2021-04-09 04:21:13 Magadan Oblast, Russia
2645974 2645974 2021-04-08 Russia Mari El Republic     12700 217 11861 622 56.5767504 47.8817512 2021-04-09 04:21:13 Mari El Republic, Russia
2645975 2645975 2021-04-08 Russia Mordovia Republic     19346 215 17339 1792 54.4419829 44.4661144 2021-04-09 04:21:13 Mordovia Republic, Russia
2645976 2645976 2021-04-08 Russia Moscow     1041799 17082 955148 69569 55.7504461 37.6174943 2021-04-09 04:21:13 Moscow, Russia
2645977 2645977 2021-04-08 Russia Moscow Oblast     236877 5531 194605 36741 55.50431579999999 38.0353929 2021-04-09 04:21:13 Moscow Oblast, Russia
2645978 2645978 2021-04-08 Russia Murmansk Oblast     49581 1105 47205 1271 68.00004179999999 33.9999151 2021-04-09 04:21:13 Murmansk Oblast, Russia
2645979 2645979 2021-04-08 Russia Nenets Autonomous Okrug     1092 4 1026 62 68.27557185 57.1686375 2021-04-09 04:21:13 Nenets Autonomous Okrug, Russia
2645980 2645980 2021-04-08 Russia Nizhny Novgorod Oblast     109534 2918 104119 2497 55.47180329999999 44.0911594 2021-04-09 04:21:13 Nizhny Novgorod Oblast, Russia
2645981 2645981 2021-04-08 Russia North Ossetia - Alania Republic     16465 175 15543 747 42.79336110000001 44.6324493 2021-04-09 04:21:13 North Ossetia - Alania Republic, Russia
2645982 2645982 2021-04-08 Russia Novgorod Oblast     29007 121 26252 2634 58.2843833 32.5169757 2021-04-09 04:21:13 Novgorod Oblast, Russia
2645983 2645983 2021-04-08 Russia Novosibirsk Oblast     39399 1667 36657 1075 54.9720169 79.48139240000002 2021-04-09 04:21:13 Novosibirsk Oblast, Russia
2645984 2645984 2021-04-08 Russia Omsk Oblast     44332 1338 41243 1751 56.09352629999999 73.5099936 2021-04-09 04:21:13 Omsk Oblast, Russia
2645985 2645985 2021-04-08 Russia Orel Oblast     32923 515 30293 2115 52.96854329999999 36.0692477 2021-04-09 04:21:13 Orel Oblast, Russia
2645986 2645986 2021-04-08 Russia Orenburg Oblast     40679 764 37072 2843 52.02692620000001 54.7276647 2021-04-09 04:21:13 Orenburg Oblast, Russia
2645987 2645987 2021-04-08 Russia Penza Oblast     42827 558 40081 2188 53.1655415 44.78791810000001 2021-04-09 04:21:13 Penza Oblast, Russia
2645988 2645988 2021-04-08 Russia Perm Krai     52151 2011 46927 3213 58.5951603 56.3159546 2021-04-09 04:21:13 Perm Krai, Russia
2645989 2645989 2021-04-08 Russia Primorsky Krai     42757 692 39933 2132 45.0819456 134.726645 2021-04-09 04:21:13 Primorsky Krai, Russia
2645990 2645990 2021-04-08 Russia Pskov Oblast     34828 267 24022 10539 57.5358729 28.8586826 2021-04-09 04:21:13 Pskov Oblast, Russia
2645991 2645991 2021-04-08 Russia Rostov Oblast     82761 3745 74277 4739 47.6222451 40.7957942 2021-04-09 04:21:13 Rostov Oblast, Russia
2645992 2645992 2021-04-08 Russia Ryazan Oblast     26723 394 24819 1510 54.42267320000001 40.57052460000001 2021-04-09 04:21:13 Ryazan Oblast, Russia
2645993 2645993 2021-04-08 Russia Saint Petersburg     400286 12521 355627 32138 59.9606739 30.158655100000004 2021-04-09 04:21:13 Saint Petersburg, Russia
2645994 2645994 2021-04-08 Russia Sakha (Yakutiya) Republic     33787 568 32677 542 66.941626 129.642371 2021-04-09 04:21:13 Sakha (Yakutiya) Republic, Russia
2645995 2645995 2021-04-08 Russia Sakhalin Oblast     22127 40 21787 300 49.7219665 143.448533 2021-04-09 04:21:13 Sakhalin Oblast, Russia
2645996 2645996 2021-04-08 Russia Samara Oblast     57328 1178 54103 2047 53.2128813 50.8914633 2021-04-09 04:21:13 Samara Oblast, Russia
2645997 2645997 2021-04-08 Russia Saratov Oblast     55982 857 50642 4483 51.6520555 46.86319520000001 2021-04-09 04:21:13 Saratov Oblast, Russia
2645998 2645998 2021-04-08 Russia Smolensk Oblast     28423 790 27101 532 55.03434960000001 33.0192065 2021-04-09 04:21:13 Smolensk Oblast, Russia
2645999 2645999 2021-04-08 Russia Stavropol Krai     51160 1255 48215 1690 44.86325770000001 43.4406913 2021-04-09 04:21:13 Stavropol Krai, Russia
2646000 2646000 2021-04-08 Russia Sverdlovsk Oblast     83582 2798 77016 3768 58.6414755 61.8021546 2021-04-09 04:21:13 Sverdlovsk Oblast, Russia
2646001 2646001 2021-04-08 Russia Tambov Oblast     30102 426 27440 2236 52.9019574 41.3578918 2021-04-09 04:21:13 Tambov Oblast, Russia
2646002 2646002 2021-04-08 Russia Tatarstan Republic     19698 428 16786 2484 55.7648572 52.43104273 2021-04-09 04:21:13 Tatarstan Republic, Russia
2646003 2646003 2021-04-08 Russia Tomsk Oblast     31594 369 30548 677 58.6124279 82.04753149999998 2021-04-09 04:21:13 Tomsk Oblast, Russia
2646004 2646004 2021-04-08 Russia Tula Oblast     36958 1629 34412 917 53.9570701 37.3690909 2021-04-09 04:21:13 Tula Oblast, Russia
2646005 2646005 2021-04-08 Russia Tver Oblast     38157 761 36148 1248 57.1134475 35.174442799999994 2021-04-09 04:21:13 Tver Oblast, Russia
2646006 2646006 2021-04-08 Russia Tyumen Oblast     34019 417 32131 1471 58.8206488 70.36588370000001 2021-04-09 04:21:13 Tyumen Oblast, Russia
2646007 2646007 2021-04-08 Russia Tyva Republic     15773 200 15011 562 51.4017149 93.8582593 2021-04-09 04:21:13 Tyva Republic, Russia
2646008 2646008 2021-04-08 Russia Udmurt Republic     31290 771 27876 2643 57.1961165 52.69598320000001 2021-04-09 04:21:13 Udmurt Republic, Russia
2646009 2646009 2021-04-08 Russia Ulyanovsk Oblast     51566 1027 48338 2201 54.1463177 47.2324921 2021-04-09 04:21:13 Ulyanovsk Oblast, Russia
2646010 2646010 2021-04-08 Russia Vladimir Oblast     30533 1023 27644 1866 56.0503336 40.6561633 2021-04-09 04:21:13 Vladimir Oblast, Russia
2646011 2646011 2021-04-08 Russia Volgograd Oblast     54516 991 52172 1353 49.6048339 44.29035820000001 2021-04-09 04:21:13 Volgograd Oblast, Russia
2646012 2646012 2021-04-08 Russia Vologda Oblast     43389 926 40436 2027 60.0391461 43.1215213 2021-04-09 04:21:13 Vologda Oblast, Russia
2646013 2646013 2021-04-08 Russia Voronezh Oblast     76741 2465 71412 2864 50.9800393 40.15065070000001 2021-04-09 04:21:13 Voronezh Oblast, Russia
2646014 2646014 2021-04-08 Russia Yamalo-Nenets Autonomous Okrug     38157 409 36802 946 67.1471631 74.3415488 2021-04-09 04:21:13 Yamalo-Nenets Autonomous Okrug, Russia
2646015 2646015 2021-04-08 Russia Yaroslavl Oblast     36794 494 35052 1248 57.77819760000001 39.0021095 2021-04-09 04:21:13 Yaroslavl Oblast, Russia
2646016 2646016 2021-04-08 Russia Zabaykalsky Krai     41468 598 39991 879 52.248521 115.956325 2021-04-09 04:21:13 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]);