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-10-12 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
3786074 3786074 2020-10-11 Russia Adygea Republic     4513 38 3765 710 44.6939006 40.1520421 2020-10-12 04:23:45 Adygea Republic, Russia
3786075 3786075 2020-10-11 Russia Altai Krai     15169 253 13626 1290 52.6932243 82.69314240000001 2020-10-12 04:23:45 Altai Krai, Russia
3786076 3786076 2020-10-11 Russia Altai Republic     4514 12 3274 1228 50.7114101 86.8572186 2020-10-12 04:23:45 Altai Republic, Russia
3786077 3786077 2020-10-11 Russia Amur Oblast     4776 57 4259 460 52.8032368 128.437295 2020-10-12 04:23:45 Amur Oblast, Russia
3786078 3786078 2020-10-11 Russia Arkhangelsk Oblast     15427 266 10503 4658 63.5589686 43.1221646 2020-10-12 04:23:45 Arkhangelsk Oblast, Russia
3786079 3786079 2020-10-11 Russia Astrakhan Oblast     7684 129 6600 955 47.1878186 47.608851 2020-10-12 04:23:45 Astrakhan Oblast, Russia
3786080 3786080 2020-10-11 Russia Bashkortostan Republic     9290 45 8610 635 54.8573563 57.1439682 2020-10-12 04:23:45 Bashkortostan Republic, Russia
3786081 3786081 2020-10-11 Russia Belgorod Oblast     9642 58 8612 972 50.7080119 37.5837615 2020-10-12 04:23:45 Belgorod Oblast, Russia
3786082 3786082 2020-10-11 Russia Bryansk Oblast     10275 41 8197 2037 52.8873315 33.41585300000001 2020-10-12 04:23:45 Bryansk Oblast, Russia
3786083 3786083 2020-10-11 Russia Buryatia Republic     7889 81 6583 1225 52.7182426 109.492143 2020-10-12 04:23:45 Buryatia Republic, Russia
3786084 3786084 2020-10-11 Russia Chechen Republic     2491 42 2033 416 43.39761470000001 45.6985005 2020-10-12 04:23:45 Chechen Republic, Russia
3786085 3786085 2020-10-11 Russia Chelyabinsk Oblast     16649 142 12340 4167 54.4223954 61.1865846 2020-10-12 04:23:45 Chelyabinsk Oblast, Russia
3786086 3786086 2020-10-11 Russia Chukotka Autonomous Okrug     210 2 187 21 66.0006475 169.4900869 2020-10-12 04:23:45 Chukotka Autonomous Okrug, Russia
3786087 3786087 2020-10-11 Russia Chuvashia Republic     8919 105 7476 1338 55.4259922 47.0849429 2020-10-12 04:23:45 Chuvashia Republic, Russia
3786088 3786088 2020-10-11 Russia Dagestan Republic     14345 681 12523 1141 43.05749160000001 47.1332224 2020-10-12 04:23:45 Dagestan Republic, Russia
3786089 3786089 2020-10-11 Russia Ingushetia Republic     6246 86 5140 1020 43.11542075 45.01713552 2020-10-12 04:23:45 Ingushetia Republic, Russia
3786090 3786090 2020-10-11 Russia Irkutsk Oblast     20406 318 17122 2966 56.6370122 104.719221 2020-10-12 04:23:45 Irkutsk Oblast, Russia
3786091 3786091 2020-10-11 Russia Ivanovo Oblast     9448 144 7317 1987 56.9167446 41.43521370000001 2020-10-12 04:23:45 Ivanovo Oblast, Russia
3786092 3786092 2020-10-11 Russia Jewish Autonomous Okrug     1203 19 772 412 48.57527615 132.66307460000002 2020-10-12 04:23:45 Jewish Autonomous Okrug, Russia
3786093 3786093 2020-10-11 Russia Kabardino-Balkarian Republic     8336 105 6703 1528 43.4806048 43.5978976 2020-10-12 04:23:45 Kabardino-Balkarian Republic, Russia
3786094 3786094 2020-10-11 Russia Kaliningrad Oblast     5110 87 3566 1457 54.7293041 21.1489473 2020-10-12 04:23:45 Kaliningrad Oblast, Russia
3786095 3786095 2020-10-11 Russia Kalmykia Republic     7279 79 4496 2704 46.2313018 45.3275745 2020-10-12 04:23:45 Kalmykia Republic, Russia
3786096 3786096 2020-10-11 Russia Kaluga Oblast     9999 74 8053 1872 54.4382773 35.5272854 2020-10-12 04:23:45 Kaluga Oblast, Russia
3786097 3786097 2020-10-11 Russia Kamchatka Krai     4819 70 3382 1367 57.1914882 160.03838190000005 2020-10-12 04:23:45 Kamchatka Krai, Russia
3786098 3786098 2020-10-11 Russia Karachay-Cherkess Republic     7921 30 4998 2893 43.7368326 41.7267991 2020-10-12 04:23:45 Karachay-Cherkess Republic, Russia
3786099 3786099 2020-10-11 Russia Karelia Republic     4613 38 3202 1373 62.61940309999999 33.4920267 2020-10-12 04:23:45 Karelia Republic, Russia
3786100 3786100 2020-10-11 Russia Kemerovo Oblast     11700 137 8168 3395 54.53357809999999 87.342861 2020-10-12 04:23:45 Kemerovo Oblast, Russia
3786101 3786101 2020-10-11 Russia Khabarovsk Krai     13041 116 10181 2744 51.6312684 136.121524 2020-10-12 04:23:45 Khabarovsk Krai, Russia
3786102 3786102 2020-10-11 Russia Khakassia Republic     4963 48 4164 751 53.72258845 91.44293627 2020-10-12 04:23:45 Khakassia Republic, Russia
3786103 3786103 2020-10-11 Russia Khanty-Mansi Autonomous Okrug     24340 203 21952 2185 61.0259025 69.0982628 2020-10-12 04:23:45 Khanty-Mansi Autonomous Okrug, Russia
3786104 3786104 2020-10-11 Russia Kirov Oblast     9393 147 5999 3247 57.9665589 49.4074599 2020-10-12 04:23:45 Kirov Oblast, Russia
3786105 3786105 2020-10-11 Russia Komi Republic     9625 136 7828 1661 63.9881421 54.3326073 2020-10-12 04:23:45 Komi Republic, Russia
3786106 3786106 2020-10-11 Russia Kostroma Oblast     5432 90 3850 1492 58.424756 44.2533273 2020-10-12 04:23:45 Kostroma Oblast, Russia
3786107 3786107 2020-10-11 Russia Krasnodar Krai     15085 318 10872 3895 45.7684014 39.0261044 2020-10-12 04:23:45 Krasnodar Krai, Russia
3786108 3786108 2020-10-11 Russia Krasnoyarsk Krai     21565 575 16008 4982 63.3233807 97.0979974 2020-10-12 04:23:45 Krasnoyarsk Krai, Russia
3786109 3786109 2020-10-11 Russia Kurgan Oblast     4369 44 3684 641 55.7655302 64.5632681 2020-10-12 04:23:45 Kurgan Oblast, Russia
3786110 3786110 2020-10-11 Russia Kursk Oblast     8852 60 7053 1739 51.6568453 36.4852695 2020-10-12 04:23:45 Kursk Oblast, Russia
3786111 3786111 2020-10-11 Russia Leningrad Oblast     9145 100 5784 3261 60.1853296 32.3925325 2020-10-12 04:23:45 Leningrad Oblast, Russia
3786112 3786112 2020-10-11 Russia Lipetsk Oblast     6625 51 5652 922 52.6935178 39.1122664 2020-10-12 04:23:45 Lipetsk Oblast, Russia
3786113 3786113 2020-10-11 Russia Magadan Oblast     3389 28 2565 796 62.48858785 153.9903764 2020-10-12 04:23:45 Magadan Oblast, Russia
3786114 3786114 2020-10-11 Russia Mari El Republic     5171 56 4435 680 56.5767504 47.8817512 2020-10-12 04:23:45 Mari El Republic, Russia
3786115 3786115 2020-10-11 Russia Mordovia Republic     6946 44 5773 1129 54.4419829 44.4661144 2020-10-12 04:23:45 Mordovia Republic, Russia
3786116 3786116 2020-10-11 Russia Moscow     330418 5595 261619 63204 55.7504461 37.6174943 2020-10-12 04:23:45 Moscow, Russia
3786117 3786117 2020-10-11 Russia Moscow Oblast     77391 1412 58530 17449 55.50431579999999 38.0353929 2020-10-12 04:23:45 Moscow Oblast, Russia
3786118 3786118 2020-10-11 Russia Murmansk Oblast     16328 234 13241 2853 68.00004179999999 33.9999151 2020-10-12 04:23:45 Murmansk Oblast, Russia
3786119 3786119 2020-10-11 Russia Nenets Autonomous Okrug     351 0 136 215 68.27557185 57.1686375 2020-10-12 04:23:45 Nenets Autonomous Okrug, Russia
3786120 3786120 2020-10-11 Russia Nizhny Novgorod Oblast     34805 613 29487 4705 55.47180329999999 44.0911594 2020-10-12 04:23:45 Nizhny Novgorod Oblast, Russia
3786121 3786121 2020-10-11 Russia North Ossetia - Alania Republic     6220 70 4940 1210 42.79336110000001 44.6324493 2020-10-12 04:23:45 North Ossetia - Alania Republic, Russia
3786122 3786122 2020-10-11 Russia Novgorod Oblast     5885 86 3974 1825 58.2843833 32.5169757 2020-10-12 04:23:45 Novgorod Oblast, Russia
3786123 3786123 2020-10-11 Russia Novosibirsk Oblast     14090 491 12471 1128 54.9720169 79.48139240000002 2020-10-12 04:23:45 Novosibirsk Oblast, Russia
3786124 3786124 2020-10-11 Russia Omsk Oblast     12258 335 10609 1314 56.09352629999999 73.5099936 2020-10-12 04:23:45 Omsk Oblast, Russia
3786125 3786125 2020-10-11 Russia Orel Oblast     9553 137 7490 1926 52.96854329999999 36.0692477 2020-10-12 04:23:45 Orel Oblast, Russia
3786126 3786126 2020-10-11 Russia Orenburg Oblast     14185 89 12900 1196 52.02692620000001 54.7276647 2020-10-12 04:23:45 Orenburg Oblast, Russia
3786127 3786127 2020-10-11 Russia Penza Oblast     12005 139 9619 2247 53.1655415 44.78791810000001 2020-10-12 04:23:45 Penza Oblast, Russia
3786128 3786128 2020-10-11 Russia Perm Krai     10818 317 7333 3168 58.5951603 56.3159546 2020-10-12 04:23:45 Perm Krai, Russia
3786129 3786129 2020-10-11 Russia Primorsky Krai     12621 122 10758 1741 45.0819456 134.726645 2020-10-12 04:23:45 Primorsky Krai, Russia
3786130 3786130 2020-10-11 Russia Pskov Oblast     5956 67 4242 1647 57.5358729 28.8586826 2020-10-12 04:23:45 Pskov Oblast, Russia
3786131 3786131 2020-10-11 Russia Rostov Oblast     24624 587 19752 4285 47.6222451 40.7957942 2020-10-12 04:23:45 Rostov Oblast, Russia
3786132 3786132 2020-10-11 Russia Ryazan Oblast     8811 54 6915 1842 54.42267320000001 40.57052460000001 2020-10-12 04:23:45 Ryazan Oblast, Russia
3786133 3786133 2020-10-11 Russia Saint Petersburg     47591 3241 31362 12988 59.9606739 30.158655100000004 2020-10-12 04:23:45 Saint Petersburg, Russia
3786134 3786134 2020-10-11 Russia Sakha (Yakutiya) Republic     10487 105 7436 2946 66.941626 129.642371 2020-10-12 04:23:45 Sakha (Yakutiya) Republic, Russia
3786135 3786135 2020-10-11 Russia Sakhalin Oblast     6205 0 4441 1764 49.7219665 143.448533 2020-10-12 04:23:45 Sakhalin Oblast, Russia
3786136 3786136 2020-10-11 Russia Samara Oblast     13057 207 10186 2664 53.2128813 50.8914633 2020-10-12 04:23:45 Samara Oblast, Russia
3786137 3786137 2020-10-11 Russia Saratov Oblast     16998 122 11512 5364 51.6520555 46.86319520000001 2020-10-12 04:23:45 Saratov Oblast, Russia
3786138 3786138 2020-10-11 Russia Smolensk Oblast     7082 154 5874 1054 55.03434960000001 33.0192065 2020-10-12 04:23:45 Smolensk Oblast, Russia
3786139 3786139 2020-10-11 Russia Stavropol Krai     17748 348 12816 4584 44.86325770000001 43.4406913 2020-10-12 04:23:45 Stavropol Krai, Russia
3786140 3786140 2020-10-11 Russia Sverdlovsk Oblast     31124 651 23051 7422 58.6414755 61.8021546 2020-10-12 04:23:45 Sverdlovsk Oblast, Russia
3786141 3786141 2020-10-11 Russia Tambov Oblast     8305 46 6934 1325 52.9019574 41.3578918 2020-10-12 04:23:45 Tambov Oblast, Russia
3786142 3786142 2020-10-11 Russia Tatarstan Republic     7549 61 6374 1114 55.7648572 52.43104273 2020-10-12 04:23:45 Tatarstan Republic, Russia
3786143 3786143 2020-10-11 Russia Tomsk Oblast     8741 92 6960 1689 58.6124279 82.04753149999998 2020-10-12 04:23:45 Tomsk Oblast, Russia
3786144 3786144 2020-10-11 Russia Tula Oblast     10645 389 9604 652 53.9570701 37.3690909 2020-10-12 04:23:45 Tula Oblast, Russia
3786145 3786145 2020-10-11 Russia Tver Oblast     7150 271 4711 2168 57.1134475 35.174442799999994 2020-10-12 04:23:45 Tver Oblast, Russia
3786146 3786146 2020-10-11 Russia Tyumen Oblast     10617 45 7888 2684 58.8206488 70.36588370000001 2020-10-12 04:23:45 Tyumen Oblast, Russia
3786147 3786147 2020-10-11 Russia Tyva Republic     8136 85 6999 1052 51.4017149 93.8582593 2020-10-12 04:23:45 Tyva Republic, Russia
3786148 3786148 2020-10-11 Russia Udmurt Republic     6503 83 4433 1987 57.1961165 52.69598320000001 2020-10-12 04:23:45 Udmurt Republic, Russia
3786149 3786149 2020-10-11 Russia Ulyanovsk Oblast     17062 180 14003 2879 54.1463177 47.2324921 2020-10-12 04:23:45 Ulyanovsk Oblast, Russia
3786150 3786150 2020-10-11 Russia Vladimir Oblast     7897 237 6092 1568 56.0503336 40.6561633 2020-10-12 04:23:45 Vladimir Oblast, Russia
3786151 3786151 2020-10-11 Russia Volgograd Oblast     16629 161 14533 1935 49.6048339 44.29035820000001 2020-10-12 04:23:45 Volgograd Oblast, Russia
3786152 3786152 2020-10-11 Russia Vologda Oblast     5273 54 4031 1188 60.0391461 43.1215213 2020-10-12 04:23:45 Vologda Oblast, Russia
3786153 3786153 2020-10-11 Russia Voronezh Oblast     20058 209 17819 2030 50.9800393 40.15065070000001 2020-10-12 04:23:45 Voronezh Oblast, Russia
3786154 3786154 2020-10-11 Russia Yamalo-Nenets Autonomous Okrug     16986 106 13662 3218 67.1471631 74.3415488 2020-10-12 04:23:45 Yamalo-Nenets Autonomous Okrug, Russia
3786155 3786155 2020-10-11 Russia Yaroslavl Oblast     9297 49 8673 575 57.77819760000001 39.0021095 2020-10-12 04:23:45 Yaroslavl Oblast, Russia
3786156 3786156 2020-10-11 Russia Zabaykalsky Krai     7414 72 5403 1939 52.248521 115.956325 2020-10-12 04:23:45 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]);