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-07-01 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
2974205 2974205 2020-06-30 Russia Adygea Republic     1898 14 1302 582 44.6939006 40.1520421 2020-07-01 04:33:52 Adygea Republic, Russia
2974211 2974211 2020-06-30 Russia Altai Krai     3985 33 2889 1063 52.6932243 82.69314240000001 2020-07-01 04:33:52 Altai Krai, Russia
2974212 2974212 2020-06-30 Russia Altai Republic     650 0 285 365 50.7114101 86.8572186 2020-07-01 04:33:52 Altai Republic, Russia
2974217 2974217 2020-06-30 Russia Amur Oblast     1707 11 786 910 52.8032368 128.437295 2020-07-01 04:33:52 Amur Oblast, Russia
2974233 2974233 2020-06-30 Russia Arkhangelsk Oblast     5556 58 2688 2810 63.5589686 43.1221646 2020-07-01 04:33:52 Arkhangelsk Oblast, Russia
2974237 2974237 2020-06-30 Russia Astrakhan Oblast     3479 31 2340 1108 47.1878186 47.608851 2020-07-01 04:33:52 Astrakhan Oblast, Russia
2974251 2974251 2020-06-30 Russia Bashkortostan Republic     5361 18 2995 2348 54.8573563 57.1439682 2020-07-01 04:33:52 Bashkortostan Republic, Russia
2974255 2974255 2020-06-30 Russia Belgorod Oblast     4524 42 3453 1029 50.7080119 37.5837615 2020-07-01 04:33:52 Belgorod Oblast, Russia
2974268 2974268 2020-06-30 Russia Bryansk Oblast     6212 34 4427 1751 52.8873315 33.41585300000001 2020-07-01 04:33:52 Bryansk Oblast, Russia
2974269 2974269 2020-06-30 Russia Buryatia Republic     2924 19 2001 904 52.7182426 109.492143 2020-07-01 04:33:52 Buryatia Republic, Russia
2974292 2974292 2020-06-30 Russia Chechen Republic     1713 22 1193 498 43.39761470000001 45.6985005 2020-07-01 04:33:52 Chechen Republic, Russia
2974293 2974293 2020-06-30 Russia Chelyabinsk Oblast     7202 88 3700 3414 54.4223954 61.1865846 2020-07-01 04:33:52 Chelyabinsk Oblast, Russia
2974303 2974303 2020-06-30 Russia Chukotka Autonomous Okrug     138 1 129 8 66.0006475 169.4900869 2020-07-01 04:33:52 Chukotka Autonomous Okrug, Russia
2974304 2974304 2020-06-30 Russia Chuvashia Republic     5076 31 2900 2145 55.4259922 47.0849429 2020-07-01 04:33:52 Chuvashia Republic, Russia
2974315 2974315 2020-06-30 Russia Dagestan Republic     7840 374 5775 1691 43.05749160000001 47.1332224 2020-07-01 04:33:52 Dagestan Republic, Russia
2974382 2974382 2020-06-30 Russia Ingushetia Republic     3047 68 2458 521 43.11542075 45.01713552 2020-07-01 04:33:52 Ingushetia Republic, Russia
2974384 2974384 2020-06-30 Russia Irkutsk Oblast     7285 59 2704 4522 56.6370122 104.719221 2020-07-01 04:33:52 Irkutsk Oblast, Russia
2974389 2974389 2020-06-30 Russia Ivanovo Oblast     4691 44 2923 1724 56.9167446 41.43521370000001 2020-07-01 04:33:52 Ivanovo Oblast, Russia
2974393 2974393 2020-06-30 Russia Jewish Autonomous Okrug     426 5 347 74 48.57527615 132.66307460000002 2020-07-01 04:33:52 Jewish Autonomous Okrug, Russia
2974400 2974400 2020-06-30 Russia Kabardino-Balkarian Republic     5010 53 3386 1571 43.4806048 43.5978976 2020-07-01 04:33:52 Kabardino-Balkarian Republic, Russia
2974403 2974403 2020-06-30 Russia Kaliningrad Oblast     2446 37 1485 924 54.7293041 21.1489473 2020-07-01 04:33:52 Kaliningrad Oblast, Russia
2974405 2974405 2020-06-30 Russia Kalmykia Republic     1483 23 1054 406 46.2313018 45.3275745 2020-07-01 04:33:52 Kalmykia Republic, Russia
2974406 2974406 2020-06-30 Russia Kaluga Oblast     6018 44 3590 2384 54.4382773 35.5272854 2020-07-01 04:33:52 Kaluga Oblast, Russia
2974407 2974407 2020-06-30 Russia Kamchatka Krai     2190 28 946 1216 57.1914882 160.03838190000005 2020-07-01 04:33:52 Kamchatka Krai, Russia
2974409 2974409 2020-06-30 Russia Karachay-Cherkess Republic     3520 12 1452 2056 43.7368326 41.7267991 2020-07-01 04:33:52 Karachay-Cherkess Republic, Russia
2974410 2974410 2020-06-30 Russia Karelia Republic     1294 3 518 773 62.61940309999999 33.4920267 2020-07-01 04:33:52 Karelia Republic, Russia
2974412 2974412 2020-06-30 Russia Kemerovo Oblast     1662 9 734 919 54.53357809999999 87.342861 2020-07-01 04:33:52 Kemerovo Oblast, Russia
2974414 2974414 2020-06-30 Russia Khabarovsk Krai     4221 29 2161 2031 51.6312684 136.121524 2020-07-01 04:33:52 Khabarovsk Krai, Russia
2974415 2974415 2020-06-30 Russia Khakassia Republic     1872 15 1340 517 53.72258845 91.44293627 2020-07-01 04:33:52 Khakassia Republic, Russia
2974416 2974416 2020-06-30 Russia Khanty-Mansi Autonomous Okrug     8958 55 4501 4402 61.0259025 69.0982628 2020-07-01 04:33:52 Khanty-Mansi Autonomous Okrug, Russia
2974423 2974423 2020-06-30 Russia Kirov Oblast     3214 35 2522 657 57.9665589 49.4074599 2020-07-01 04:33:52 Kirov Oblast, Russia
2974426 2974426 2020-06-30 Russia Komi Republic     3409 30 1599 1780 63.9881421 54.3326073 2020-07-01 04:33:52 Komi Republic, Russia
2974427 2974427 2020-06-30 Russia Kostroma Oblast     1583 17 906 660 58.424756 44.2533273 2020-07-01 04:33:52 Kostroma Oblast, Russia
2974428 2974428 2020-06-30 Russia Krasnodar Krai     5982 76 4706 1200 45.7684014 39.0261044 2020-07-01 04:33:52 Krasnodar Krai, Russia
2974429 2974429 2020-06-30 Russia Krasnoyarsk Krai     8904 120 3827 4957 63.3233807 97.0979974 2020-07-01 04:33:52 Krasnoyarsk Krai, Russia
2974432 2974432 2020-06-30 Russia Kurgan Oblast     786 1 427 358 55.7655302 64.5632681 2020-07-01 04:33:52 Kurgan Oblast, Russia
2974433 2974433 2020-06-30 Russia Kursk Oblast     5080 34 2975 2071 51.6568453 36.4852695 2020-07-01 04:33:52 Kursk Oblast, Russia
2974441 2974441 2020-06-30 Russia Leningrad Oblast     4420 32 4169 219 60.1853296 32.3925325 2020-07-01 04:33:52 Leningrad Oblast, Russia
2974445 2974445 2020-06-30 Russia Lipetsk Oblast     3779 16 2358 1405 52.6935178 39.1122664 2020-07-01 04:33:52 Lipetsk Oblast, Russia
2974456 2974456 2020-06-30 Russia Magadan Oblast     764 4 361 399 62.48858785 153.9903764 2020-07-01 04:33:52 Magadan Oblast, Russia
2974464 2974464 2020-06-30 Russia Mari El Republic     2959 23 2824 112 56.5767504 47.8817512 2020-07-01 04:33:52 Mari El Republic, Russia
2974485 2974485 2020-06-30 Russia Mordovia Republic     3394 26 2200 1168 54.4419829 44.4661144 2020-07-01 04:33:52 Mordovia Republic, Russia
2974487 2974487 2020-06-30 Russia Moscow     221598 3796 150397 67405 55.7504461 37.6174943 2020-07-01 04:33:52 Moscow, Russia
2974488 2974488 2020-06-30 Russia Moscow Oblast     57570 887 35240 21443 55.50431579999999 38.0353929 2020-07-01 04:33:52 Moscow Oblast, Russia
2974490 2974490 2020-06-30 Russia Murmansk Oblast     5211 15 3529 1667 68.00004179999999 33.9999151 2020-07-01 04:33:52 Murmansk Oblast, Russia
2974499 2974499 2020-06-30 Russia Nenets Autonomous Okrug     104 0 38 66 68.27557185 57.1686375 2020-07-01 04:33:52 Nenets Autonomous Okrug, Russia
2974507 2974507 2020-06-30 Russia Nizhny Novgorod Oblast     17481 234 11061 6186 55.47180329999999 44.0911594 2020-07-01 04:33:52 Nizhny Novgorod Oblast, Russia
2974511 2974511 2020-06-30 Russia North Ossetia - Alania Republic     4006 67 3525 414 42.79336110000001 44.6324493 2020-07-01 04:33:52 North Ossetia - Alania Republic, Russia
2974518 2974518 2020-06-30 Russia Novgorod Oblast     2884 25 796 2063 58.2843833 32.5169757 2020-07-01 04:33:52 Novgorod Oblast, Russia
2974519 2974519 2020-06-30 Russia Novosibirsk Oblast     5985 96 3496 2393 54.9720169 79.48139240000002 2020-07-01 04:33:52 Novosibirsk Oblast, Russia
2974529 2974529 2020-06-30 Russia Omsk Oblast     3615 30 2005 1580 56.09352629999999 73.5099936 2020-07-01 04:33:52 Omsk Oblast, Russia
2974532 2974532 2020-06-30 Russia Orel Oblast     4513 61 2823 1629 52.96854329999999 36.0692477 2020-07-01 04:33:52 Orel Oblast, Russia
2974533 2974533 2020-06-30 Russia Orenburg Oblast     3777 19 2672 1086 52.02692620000001 54.7276647 2020-07-01 04:33:52 Orenburg Oblast, Russia
2974543 2974543 2020-06-30 Russia Penza Oblast     4970 41 4661 268 53.1655415 44.78791810000001 2020-07-01 04:33:52 Penza Oblast, Russia
2974544 2974544 2020-06-30 Russia Perm Krai     3691 78 2701 912 58.5951603 56.3159546 2020-07-01 04:33:52 Perm Krai, Russia
2974551 2974551 2020-06-30 Russia Primorsky Krai     4306 44 2745 1517 45.0819456 134.726645 2020-07-01 04:33:52 Primorsky Krai, Russia
2974553 2974553 2020-06-30 Russia Pskov Oblast     2757 22 984 1751 57.5358729 28.8586826 2020-07-01 04:33:52 Pskov Oblast, Russia
2974579 2974579 2020-06-30 Russia Rostov Oblast     9611 125 5744 3742 47.6222451 40.7957942 2020-07-01 04:33:52 Rostov Oblast, Russia
2974580 2974580 2020-06-30 Russia Ryazan Oblast     5197 19 3506 1672 54.42267320000001 40.57052460000001 2020-07-01 04:33:52 Ryazan Oblast, Russia
2974587 2974587 2020-06-30 Russia Saint Petersburg     24207 1136 17310 5761 59.9606739 30.158655100000004 2020-07-01 04:33:52 Saint Petersburg, Russia
2974590 2974590 2020-06-30 Russia Sakha (Yakutiya) Republic     4223 30 2961 1232 66.941626 129.642371 2020-07-01 04:33:52 Sakha (Yakutiya) Republic, Russia
2974591 2974591 2020-06-30 Russia Sakhalin Oblast     800 0 332 468 49.7219665 143.448533 2020-07-01 04:33:52 Sakhalin Oblast, Russia
2974592 2974592 2020-06-30 Russia Samara Oblast     4837 56 2714 2067 53.2128813 50.8914633 2020-07-01 04:33:52 Samara Oblast, Russia
2974599 2974599 2020-06-30 Russia Saratov Oblast     6444 43 3344 3057 51.6520555 46.86319520000001 2020-07-01 04:33:52 Saratov Oblast, Russia
2974620 2974620 2020-06-30 Russia Smolensk Oblast     4581 65 2343 2173 55.03434960000001 33.0192065 2020-07-01 04:33:52 Smolensk Oblast, Russia
2974625 2974625 2020-06-30 Russia Stavropol Krai     5141 97 2963 2081 44.86325770000001 43.4406913 2020-07-01 04:33:52 Stavropol Krai, Russia
2974629 2974629 2020-06-30 Russia Sverdlovsk Oblast     12792 95 7459 5238 58.6414755 61.8021546 2020-07-01 04:33:52 Sverdlovsk Oblast, Russia
2974633 2974633 2020-06-30 Russia Tambov Oblast     4727 19 2880 1828 52.9019574 41.3578918 2020-07-01 04:33:52 Tambov Oblast, Russia
2974637 2974637 2020-06-30 Russia Tatarstan Republic     4555 11 3703 841 55.7648572 52.43104273 2020-07-01 04:33:52 Tatarstan Republic, Russia
2974649 2974649 2020-06-30 Russia Tomsk Oblast     2254 14 1079 1161 58.6124279 82.04753149999998 2020-07-01 04:33:52 Tomsk Oblast, Russia
2974654 2974654 2020-06-30 Russia Tula Oblast     6686 107 5502 1077 53.9570701 37.3690909 2020-07-01 04:33:52 Tula Oblast, Russia
2974657 2974657 2020-06-30 Russia Tver Oblast     3622 69 2464 1089 57.1134475 35.174442799999994 2020-07-01 04:33:52 Tver Oblast, Russia
2974658 2974658 2020-06-30 Russia Tyumen Oblast     3087 17 1812 1258 58.8206488 70.36588370000001 2020-07-01 04:33:52 Tyumen Oblast, Russia
2974659 2974659 2020-06-30 Russia Tyva Republic     4486 3 1149 3334 51.4017149 93.8582593 2020-07-01 04:33:52 Tyva Republic, Russia
2974661 2974661 2020-06-30 Russia Udmurt Republic     1420 16 1028 376 57.1961165 52.69598320000001 2020-07-01 04:33:52 Udmurt Republic, Russia
2974662 2974662 2020-06-30 Russia Ulyanovsk Oblast     5780 39 3003 2738 54.1463177 47.2324921 2020-07-01 04:33:52 Ulyanovsk Oblast, Russia
2974690 2974690 2020-06-30 Russia Vladimir Oblast     4362 64 2724 1574 56.0503336 40.6561633 2020-07-01 04:33:52 Vladimir Oblast, Russia
2974691 2974691 2020-06-30 Russia Volgograd Oblast     6327 39 2905 3383 49.6048339 44.29035820000001 2020-07-01 04:33:52 Volgograd Oblast, Russia
2974692 2974692 2020-06-30 Russia Vologda Oblast     1607 17 1181 409 60.0391461 43.1215213 2020-07-01 04:33:52 Vologda Oblast, Russia
2974694 2974694 2020-06-30 Russia Voronezh Oblast     7588 38 4286 3264 50.9800393 40.15065070000001 2020-07-01 04:33:52 Voronezh Oblast, Russia
2974702 2974702 2020-06-30 Russia Yamalo-Nenets Autonomous Okrug     5580 37 2378 3165 67.1471631 74.3415488 2020-07-01 04:33:52 Yamalo-Nenets Autonomous Okrug, Russia
2974704 2974704 2020-06-30 Russia Yaroslavl Oblast     4785 19 3194 1572 57.77819760000001 39.0021095 2020-07-01 04:33:52 Yaroslavl Oblast, Russia
2974708 2974708 2020-06-30 Russia Zabaykalsky Krai     3100 42 2000 1058 52.248521 115.956325 2020-07-01 04:33:52 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]);