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-09-19 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
2849018 2849018 2020-09-18 Russia Adygea Republic     3753 31 3229 493 44.6939006 40.1520421 2020-09-19 04:22:00 Adygea Republic, Russia
2849019 2849019 2020-09-18 Russia Altai Krai     12846 161 11523 1162 52.6932243 82.6931424 2020-09-19 04:22:00 Altai Krai, Russia
2849020 2849020 2020-09-18 Russia Altai Republic     2746 12 2214 520 50.7114101 86.8572186 2020-09-19 04:22:00 Altai Republic, Russia
2849021 2849021 2020-09-18 Russia Amur Oblast     3928 50 3486 392 52.8032368 128.437295 2020-09-19 04:22:00 Amur Oblast, Russia
2849022 2849022 2020-09-18 Russia Arkhangelsk Oblast     12193 257 9759 2177 63.5589686 43.1221646 2020-09-19 04:22:00 Arkhangelsk Oblast, Russia
2849023 2849023 2020-09-18 Russia Astrakhan Oblast     6504 92 6121 291 47.1878186 47.608851 2020-09-19 04:22:00 Astrakhan Oblast, Russia
2849024 2849024 2020-09-18 Russia Bashkortostan Republic     8350 31 8075 244 54.8573563 57.1439682 2020-09-19 04:22:00 Bashkortostan Republic, Russia
2849025 2849025 2020-09-18 Russia Belgorod Oblast     8152 57 7520 575 50.7080119 37.5837615 2020-09-19 04:22:00 Belgorod Oblast, Russia
2849026 2849026 2020-09-18 Russia Bryansk Oblast     8878 37 7233 1608 52.8873315 33.415853 2020-09-19 04:22:00 Bryansk Oblast, Russia
2849027 2849027 2020-09-18 Russia Buryatia Republic     6088 62 5182 844 52.7182426 109.492143 2020-09-19 04:22:00 Buryatia Republic, Russia
2849028 2849028 2020-09-18 Russia Chechen Republic     2368 40 1786 542 43.3976147 45.6985005 2020-09-19 04:22:00 Chechen Republic, Russia
2849029 2849029 2020-09-18 Russia Chelyabinsk Oblast     14857 119 10840 3898 54.4223954 61.1865846 2020-09-19 04:22:00 Chelyabinsk Oblast, Russia
2849030 2849030 2020-09-18 Russia Chukotka Autonomous Okrug     181 2 171 8 66.0006475 169.4900869 2020-09-19 04:22:00 Chukotka Autonomous Okrug, Russia
2849031 2849031 2020-09-18 Russia Chuvashia Republic     8274 85 7025 1164 55.4259922 47.0849429 2020-09-19 04:22:00 Chuvashia Republic, Russia
2849032 2849032 2020-09-18 Russia Dagestan Republic     12429 538 10669 1222 43.0574916 47.1332224 2020-09-19 04:22:00 Dagestan Republic, Russia
2849033 2849033 2020-09-18 Russia Ingushetia Republic     5089 78 4394 617 43.11542075 45.01713552 2020-09-19 04:22:00 Ingushetia Republic, Russia
2849034 2849034 2020-09-18 Russia Irkutsk Oblast     18139 273 14712 3154 56.6370122 104.719221 2020-09-19 04:22:00 Irkutsk Oblast, Russia
2849035 2849035 2020-09-18 Russia Ivanovo Oblast     8138 129 6684 1325 56.9167446 41.4352137 2020-09-19 04:22:00 Ivanovo Oblast, Russia
2849036 2849036 2020-09-18 Russia Jewish Autonomous Okrug     760 10 641 109 48.57527615 132.6630746 2020-09-19 04:22:00 Jewish Autonomous Okrug, Russia
2849037 2849037 2020-09-18 Russia Kabardino-Balkarian Republic     7149 85 6332 732 43.4806048 43.5978976 2020-09-19 04:22:00 Kabardino-Balkarian Republic, Russia
2849038 2849038 2020-09-18 Russia Kaliningrad Oblast     3906 67 3115 724 54.7293041 21.1489473 2020-09-19 04:22:00 Kaliningrad Oblast, Russia
2849039 2849039 2020-09-18 Russia Kalmykia Republic     5612 65 3305 2242 46.2313018 45.3275745 2020-09-19 04:22:00 Kalmykia Republic, Russia
2849040 2849040 2020-09-18 Russia Kaluga Oblast     8622 71 7337 1214 54.4382773 35.5272854 2020-09-19 04:22:00 Kaluga Oblast, Russia
2849041 2849041 2020-09-18 Russia Kamchatka Krai     4198 67 3245 886 57.1914882 160.0383819 2020-09-19 04:22:00 Kamchatka Krai, Russia
2849042 2849042 2020-09-18 Russia Karachay-Cherkess Republic     6221 28 4683 1510 43.7368326 41.7267991 2020-09-19 04:22:00 Karachay-Cherkess Republic, Russia
2849043 2849043 2020-09-18 Russia Karelia Republic     3587 16 2615 956 62.6194031 33.4920267 2020-09-19 04:22:00 Karelia Republic, Russia
2849044 2849044 2020-09-18 Russia Kemerovo Oblast     8188 67 6198 1923 54.5335781 87.342861 2020-09-19 04:22:00 Kemerovo Oblast, Russia
2849045 2849045 2020-09-18 Russia Khabarovsk Krai     11255 101 9119 2035 51.6312684 136.121524 2020-09-19 04:22:00 Khabarovsk Krai, Russia
2849046 2849046 2020-09-18 Russia Khakassia Republic     3928 47 3355 526 53.72258845 91.44293627 2020-09-19 04:22:00 Khakassia Republic, Russia
2849047 2849047 2020-09-18 Russia Khanty-Mansi Autonomous Okrug     20988 179 20197 612 61.0259025 69.0982628 2020-09-19 04:22:00 Khanty-Mansi Autonomous Okrug, Russia
2849048 2849048 2020-09-18 Russia Kirov Oblast     7701 118 5493 2090 57.9665589 49.4074599 2020-09-19 04:22:00 Kirov Oblast, Russia
2849049 2849049 2020-09-18 Russia Komi Republic     7359 96 6314 949 63.9881421 54.3326073 2020-09-19 04:22:00 Komi Republic, Russia
2849050 2849050 2020-09-18 Russia Kostroma Oblast     4235 58 3122 1055 58.424756 44.2533273 2020-09-19 04:22:00 Kostroma Oblast, Russia
2849051 2849051 2020-09-18 Russia Krasnodar Krai     12843 235 10120 2488 45.7684014 39.0261044 2020-09-19 04:22:00 Krasnodar Krai, Russia
2849052 2849052 2020-09-18 Russia Krasnoyarsk Krai     18751 526 14628 3597 63.3233807 97.0979974 2020-09-19 04:22:00 Krasnoyarsk Krai, Russia
2849053 2849053 2020-09-18 Russia Kurgan Oblast     3447 25 2964 458 55.7655302 64.5632681 2020-09-19 04:22:00 Kurgan Oblast, Russia
2849054 2849054 2020-09-18 Russia Kursk Oblast     7651 56 6455 1140 51.6568453 36.4852695 2020-09-19 04:22:00 Kursk Oblast, Russia
2849055 2849055 2020-09-18 Russia Leningrad Oblast     7468 91 5334 2043 60.1853296 32.3925325 2020-09-19 04:22:00 Leningrad Oblast, Russia
2849056 2849056 2020-09-18 Russia Lipetsk Oblast     5682 36 5076 570 52.6935178 39.1122664 2020-09-19 04:22:00 Lipetsk Oblast, Russia
2849057 2849057 2020-09-18 Russia Magadan Oblast     2484 22 1943 519 62.48858785 153.9903764 2020-09-19 04:22:00 Magadan Oblast, Russia
2849058 2849058 2020-09-18 Russia Mari El Republic     4590 46 4063 481 56.5767504 47.8817512 2020-09-19 04:22:00 Mari El Republic, Russia
2849059 2849059 2020-09-18 Russia Mordovia Republic     6024 40 4998 986 54.4419829 44.4661144 2020-09-19 04:22:00 Mordovia Republic, Russia
2849060 2849060 2020-09-18 Russia Moscow     274808 5033 235136 34639 55.7504461 37.6174943 2020-09-19 04:22:00 Moscow, Russia
2849061 2849061 2020-09-18 Russia Moscow Oblast     71173 1272 54195 15706 55.5043158 38.0353929 2020-09-19 04:22:00 Moscow Oblast, Russia
2849062 2849062 2020-09-18 Russia Murmansk Oblast     14060 192 11623 2245 68.0000418 33.9999151 2020-09-19 04:22:00 Murmansk Oblast, Russia
2849063 2849063 2020-09-18 Russia Nenets Autonomous Okrug     324 0 114 210 68.27557185 57.1686375 2020-09-19 04:22:00 Nenets Autonomous Okrug, Russia
2849064 2849064 2020-09-18 Russia Nizhny Novgorod Oblast     30435 538 26988 2909 55.4718033 44.0911594 2020-09-19 04:22:00 Nizhny Novgorod Oblast, Russia
2849065 2849065 2020-09-18 Russia North Ossetia - Alania Republic     5408 68 4599 741 42.7933611 44.6324493 2020-09-19 04:22:00 North Ossetia - Alania Republic, Russia
2849066 2849066 2020-09-18 Russia Novgorod Oblast     4803 86 3523 1194 58.2843833 32.5169757 2020-09-19 04:22:00 Novgorod Oblast, Russia
2849067 2849067 2020-09-18 Russia Novosibirsk Oblast     12356 407 11205 744 54.9720169 79.4813924 2020-09-19 04:22:00 Novosibirsk Oblast, Russia
2849068 2849068 2020-09-18 Russia Omsk Oblast     10140 255 8801 1084 56.0935263 73.5099936 2020-09-19 04:22:00 Omsk Oblast, Russia
2849069 2849069 2020-09-18 Russia Orel Oblast     7925 121 6321 1483 52.9685433 36.0692477 2020-09-19 04:22:00 Orel Oblast, Russia
2849070 2849070 2020-09-18 Russia Orenburg Oblast     11628 82 10569 977 52.0269262 54.7276647 2020-09-19 04:22:00 Orenburg Oblast, Russia
2849071 2849071 2020-09-18 Russia Penza Oblast     9778 121 8444 1213 53.1655415 44.7879181 2020-09-19 04:22:00 Penza Oblast, Russia
2849072 2849072 2020-09-18 Russia Perm Krai     8944 246 6199 2499 58.5951603 56.3159546 2020-09-19 04:22:00 Perm Krai, Russia
2849073 2849073 2020-09-18 Russia Primorsky Krai     10910 112 9346 1452 45.0819456 134.726645 2020-09-19 04:22:00 Primorsky Krai, Russia
2849074 2849074 2020-09-18 Russia Pskov Oblast     5057 65 3849 1143 57.5358729 28.8586826 2020-09-19 04:22:00 Pskov Oblast, Russia
2849075 2849075 2020-09-18 Russia Rostov Oblast     19705 430 15954 3321 47.6222451 40.7957942 2020-09-19 04:22:00 Rostov Oblast, Russia
2849076 2849076 2020-09-18 Russia Ryazan Oblast     7712 47 6547 1118 54.4226732 40.5705246 2020-09-19 04:22:00 Ryazan Oblast, Russia
2849077 2849077 2020-09-18 Russia Saint Petersburg     40305 2744 27610 9951 59.9606739 30.1586551 2020-09-19 04:22:00 Saint Petersburg, Russia
2849078 2849078 2020-09-18 Russia Sakha (Yakutiya) Republic     8467 90 6592 1785 66.941626 129.642371 2020-09-19 04:22:00 Sakha (Yakutiya) Republic, Russia
2849079 2849079 2020-09-18 Russia Sakhalin Oblast     5174 0 3642 1532 49.7219665 143.448533 2020-09-19 04:22:00 Sakhalin Oblast, Russia
2849080 2849080 2020-09-18 Russia Samara Oblast     10435 163 8055 2217 53.2128813 50.8914633 2020-09-19 04:22:00 Samara Oblast, Russia
2849081 2849081 2020-09-18 Russia Saratov Oblast     14222 91 9375 4756 51.6520555 46.8631952 2020-09-19 04:22:00 Saratov Oblast, Russia
2849082 2849082 2020-09-18 Russia Smolensk Oblast     6392 137 5612 643 55.0343496 33.0192065 2020-09-19 04:22:00 Smolensk Oblast, Russia
2849083 2849083 2020-09-18 Russia Stavropol Krai     14348 282 10015 4051 44.8632577 43.4406913 2020-09-19 04:22:00 Stavropol Krai, Russia
2849084 2849084 2020-09-18 Russia Sverdlovsk Oblast     27554 559 21027 5968 58.6414755 61.8021546 2020-09-19 04:22:00 Sverdlovsk Oblast, Russia
2849085 2849085 2020-09-18 Russia Tambov Oblast     7252 46 6366 840 52.9019574 41.3578918 2020-09-19 04:22:00 Tambov Oblast, Russia
2849086 2849086 2020-09-18 Russia Tatarstan Republic     6949 45 5775 1129 55.7648572 52.43104273 2020-09-19 04:22:00 Tatarstan Republic, Russia
2849087 2849087 2020-09-18 Russia Tomsk Oblast     6645 78 5411 1156 58.6124279 82.0475315 2020-09-19 04:22:00 Tomsk Oblast, Russia
2849088 2849088 2020-09-18 Russia Tula Oblast     9779 354 8759 666 53.9570701 37.3690909 2020-09-19 04:22:00 Tula Oblast, Russia
2849089 2849089 2020-09-18 Russia Tver Oblast     5832 223 4401 1208 57.1134475 35.1744428 2020-09-19 04:22:00 Tver Oblast, Russia
2849090 2849090 2020-09-18 Russia Tyumen Oblast     8690 35 7378 1277 58.8206488 70.3658837 2020-09-19 04:22:00 Tyumen Oblast, Russia
2849091 2849091 2020-09-18 Russia Tyva Republic     7291 71 6581 639 51.4017149 93.8582593 2020-09-19 04:22:00 Tyva Republic, Russia
2849092 2849092 2020-09-18 Russia Udmurt Republic     4170 59 3208 903 57.1961165 52.6959832 2020-09-19 04:22:00 Udmurt Republic, Russia
2849093 2849093 2020-09-18 Russia Ulyanovsk Oblast     14033 140 12032 1861 54.1463177 47.2324921 2020-09-19 04:22:00 Ulyanovsk Oblast, Russia
2849094 2849094 2020-09-18 Russia Vladimir Oblast     6871 200 5755 916 56.0503336 40.6561633 2020-09-19 04:22:00 Vladimir Oblast, Russia
2849095 2849095 2020-09-18 Russia Volgograd Oblast     13869 129 12234 1506 49.6048339 44.2903582 2020-09-19 04:22:00 Volgograd Oblast, Russia
2849096 2849096 2020-09-18 Russia Vologda Oblast     4080 45 3499 536 60.0391461 43.1215213 2020-09-19 04:22:00 Vologda Oblast, Russia
2849097 2849097 2020-09-18 Russia Voronezh Oblast     16105 148 15025 932 50.9800393 40.1506507 2020-09-19 04:22:00 Voronezh Oblast, Russia
2849098 2849098 2020-09-18 Russia Yamalo-Nenets Autonomous Okrug     14341 98 13244 999 67.1471631 74.3415488 2020-09-19 04:22:00 Yamalo-Nenets Autonomous Okrug, Russia
2849099 2849099 2020-09-18 Russia Yaroslavl Oblast     7997 45 7566 386 57.7781976 39.0021095 2020-09-19 04:22:00 Yaroslavl Oblast, Russia
2849100 2849100 2020-09-18 Russia Zabaykalsky Krai     5426 65 4570 791 52.248521 115.956325 2020-09-19 04:22:00 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]);