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-02-04 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
340456 340456 2021-02-03 Russia Adygea Republic     13160 122 11300 1738 44.6939006 40.1520421 2021-02-04 05:22:26 Adygea Republic, Russia
340457 340457 2021-02-03 Russia Altai Krai     39544 1224 35529 2791 52.6932243 82.69314240000001 2021-02-04 05:22:26 Altai Krai, Russia
340458 340458 2021-02-03 Russia Altai Republic     15484 134 14397 953 50.7114101 86.8572186 2021-02-04 05:22:26 Altai Republic, Russia
340459 340459 2021-02-03 Russia Amur Oblast     19734 140 18050 1544 52.8032368 128.437295 2021-02-04 05:22:26 Amur Oblast, Russia
340460 340460 2021-02-03 Russia Arkhangelsk Oblast     51946 477 44598 6871 63.5589686 43.1221646 2021-02-04 05:22:26 Arkhangelsk Oblast, Russia
340461 340461 2021-02-03 Russia Astrakhan Oblast     24956 490 15489 8977 47.1878186 47.608851 2021-02-04 05:22:26 Astrakhan Oblast, Russia
340462 340462 2021-02-03 Russia Bashkortostan Republic     24744 193 18760 5791 54.8573563 57.1439682 2021-02-04 05:22:26 Bashkortostan Republic, Russia
340463 340463 2021-02-03 Russia Belgorod Oblast     27959 386 25396 2177 50.7080119 37.5837615 2021-02-04 05:22:26 Belgorod Oblast, Russia
340464 340464 2021-02-03 Russia Bryansk Oblast     29594 241 28204 1149 52.8873315 33.41585300000001 2021-02-04 05:22:26 Bryansk Oblast, Russia
340465 340465 2021-02-03 Russia Buryatia Republic     30860 672 28411 1777 52.7182426 109.492143 2021-02-04 05:22:26 Buryatia Republic, Russia
340466 340466 2021-02-03 Russia Chechen Republic     10862 108 9831 923 43.39761470000001 45.6985005 2021-02-04 05:22:26 Chechen Republic, Russia
340467 340467 2021-02-03 Russia Chelyabinsk Oblast     44655 797 34092 9766 54.4223954 61.1865846 2021-02-04 05:22:26 Chelyabinsk Oblast, Russia
340468 340468 2021-02-03 Russia Chukotka Autonomous Okrug     640 4 581 55 66.0006475 169.4900869 2021-02-04 05:22:26 Chukotka Autonomous Okrug, Russia
340469 340469 2021-02-03 Russia Chuvashia Republic     19729 899 17807 1023 55.4259922 47.0849429 2021-02-04 05:22:26 Chuvashia Republic, Russia
340470 340470 2021-02-03 Russia Dagestan Republic     28203 1256 25277 1670 43.05749160000001 47.1332224 2021-02-04 05:22:26 Dagestan Republic, Russia
340471 340471 2021-02-03 Russia Ingushetia Republic     14067 161 12280 1626 43.11542075 45.01713552 2021-02-04 05:22:26 Ingushetia Republic, Russia
340472 340472 2021-02-03 Russia Irkutsk Oblast     49449 1591 44315 3543 56.6370122 104.719221 2021-02-04 05:22:26 Irkutsk Oblast, Russia
340473 340473 2021-02-03 Russia Ivanovo Oblast     27269 773 23896 2600 56.9167446 41.43521370000001 2021-02-04 05:22:26 Ivanovo Oblast, Russia
340474 340474 2021-02-03 Russia Jewish Autonomous Okrug     4197 107 3822 268 48.57527615 132.66307460000002 2021-02-04 05:22:26 Jewish Autonomous Okrug, Russia
340475 340475 2021-02-03 Russia Kabardino-Balkarian Republic     19034 334 17745 955 43.4806048 43.5978976 2021-02-04 05:22:26 Kabardino-Balkarian Republic, Russia
340476 340476 2021-02-03 Russia Kaliningrad Oblast     24629 221 21836 2572 54.7293041 21.1489473 2021-02-04 05:22:26 Kaliningrad Oblast, Russia
340477 340477 2021-02-03 Russia Kalmykia Republic     17636 260 15954 1422 46.2313018 45.3275745 2021-02-04 05:22:26 Kalmykia Republic, Russia
340478 340478 2021-02-03 Russia Kaluga Oblast     26439 222 24139 2078 54.4382773 35.5272854 2021-02-04 05:22:26 Kaluga Oblast, Russia
340479 340479 2021-02-03 Russia Kamchatka Krai     12448 84 11038 1326 57.1914882 160.03838190000005 2021-02-04 05:22:26 Kamchatka Krai, Russia
340480 340480 2021-02-03 Russia Karachay-Cherkess Republic     17768 54 16012 1702 43.7368326 41.7267991 2021-02-04 05:22:26 Karachay-Cherkess Republic, Russia
340481 340481 2021-02-03 Russia Karelia Republic     36590 237 31587 4766 62.61940309999999 33.4920267 2021-02-04 05:22:26 Karelia Republic, Russia
340482 340482 2021-02-03 Russia Kemerovo Oblast     29640 527 27872 1241 54.53357809999999 87.342861 2021-02-04 05:22:26 Kemerovo Oblast, Russia
340483 340483 2021-02-03 Russia Khabarovsk Krai     45329 258 40964 4107 51.6312684 136.121524 2021-02-04 05:22:26 Khabarovsk Krai, Russia
340484 340484 2021-02-03 Russia Khakassia Republic     20545 393 19099 1053 53.72258845 91.44293627 2021-02-04 05:22:26 Khakassia Republic, Russia
340485 340485 2021-02-03 Russia Khanty-Mansi Autonomous Okrug     48155 675 45137 2343 61.0259025 69.0982628 2021-02-04 05:22:26 Khanty-Mansi Autonomous Okrug, Russia
340486 340486 2021-02-03 Russia Kirov Oblast     32900 269 27627 5004 57.9665589 49.4074599 2021-02-04 05:22:26 Kirov Oblast, Russia
340487 340487 2021-02-03 Russia Komi Republic     36790 699 35521 570 63.9881421 54.3326073 2021-02-04 05:22:26 Komi Republic, Russia
340488 340488 2021-02-03 Russia Kostroma Oblast     17185 299 14028 2858 58.424756 44.2533273 2021-02-04 05:22:26 Kostroma Oblast, Russia
340489 340489 2021-02-03 Russia Krasnodar Krai     34229 1524 25475 7230 45.7684014 39.0261044 2021-02-04 05:22:26 Krasnodar Krai, Russia
340490 340490 2021-02-03 Russia Krasnoyarsk Krai     57346 2415 52841 2090 63.3233807 97.0979974 2021-02-04 05:22:26 Krasnoyarsk Krai, Russia
340491 340491 2021-02-03 Russia Kurgan Oblast     15515 222 13651 1642 55.7655302 64.5632681 2021-02-04 05:22:26 Kurgan Oblast, Russia
340492 340492 2021-02-03 Russia Kursk Oblast     26802 380 23497 2925 51.6568453 36.4852695 2021-02-04 05:22:26 Kursk Oblast, Russia
340493 340493 2021-02-03 Russia Leningrad Oblast     31354 442 28428 2484 60.1853296 32.3925325 2021-02-04 05:22:26 Leningrad Oblast, Russia
340494 340494 2021-02-03 Russia Lipetsk Oblast     21374 380 17395 3599 52.6935178 39.1122664 2021-02-04 05:22:26 Lipetsk Oblast, Russia
340495 340495 2021-02-03 Russia Magadan Oblast     7906 91 7465 350 62.48858785 153.9903764 2021-02-04 05:22:26 Magadan Oblast, Russia
340496 340496 2021-02-03 Russia Mari El Republic     10793 156 9453 1184 56.5767504 47.8817512 2021-02-04 05:22:26 Mari El Republic, Russia
340497 340497 2021-02-03 Russia Mordovia Republic     16261 139 13769 2353 54.4419829 44.4661144 2021-02-04 05:22:26 Mordovia Republic, Russia
340498 340498 2021-02-03 Russia Moscow     935355 13634 829844 91877 55.7504461 37.6174943 2021-02-04 05:22:26 Moscow, Russia
340499 340499 2021-02-03 Russia Moscow Oblast     195636 3871 156107 35658 55.50431579999999 38.0353929 2021-02-04 05:22:26 Moscow Oblast, Russia
340500 340500 2021-02-03 Russia Murmansk Oblast     43634 834 40935 1865 68.00004179999999 33.9999151 2021-02-04 05:22:26 Murmansk Oblast, Russia
340501 340501 2021-02-03 Russia Nenets Autonomous Okrug     929 1 791 137 68.27557185 57.1686375 2021-02-04 05:22:26 Nenets Autonomous Okrug, Russia
340502 340502 2021-02-03 Russia Nizhny Novgorod Oblast     85840 2157 78082 5601 55.47180329999999 44.0911594 2021-02-04 05:22:26 Nizhny Novgorod Oblast, Russia
340503 340503 2021-02-03 Russia North Ossetia - Alania Republic     14630 122 13071 1437 42.79336110000001 44.6324493 2021-02-04 05:22:26 North Ossetia - Alania Republic, Russia
340504 340504 2021-02-03 Russia Novgorod Oblast     24477 110 20508 3859 58.2843833 32.5169757 2021-02-04 05:22:26 Novgorod Oblast, Russia
340505 340505 2021-02-03 Russia Novosibirsk Oblast     32652 1250 30155 1247 54.9720169 79.48139240000002 2021-02-04 05:22:26 Novosibirsk Oblast, Russia
340506 340506 2021-02-03 Russia Omsk Oblast     37753 1096 34551 2106 56.09352629999999 73.5099936 2021-02-04 05:22:26 Omsk Oblast, Russia
340507 340507 2021-02-03 Russia Orel Oblast     27204 360 23996 2848 52.96854329999999 36.0692477 2021-02-04 05:22:26 Orel Oblast, Russia
340508 340508 2021-02-03 Russia Orenburg Oblast     34555 492 30752 3311 52.02692620000001 54.7276647 2021-02-04 05:22:26 Orenburg Oblast, Russia
340509 340509 2021-02-03 Russia Penza Oblast     33371 388 26442 6541 53.1655415 44.78791810000001 2021-02-04 05:22:26 Penza Oblast, Russia
340510 340510 2021-02-03 Russia Perm Krai     40645 1477 33618 5550 58.5951603 56.3159546 2021-02-04 05:22:26 Perm Krai, Russia
340511 340511 2021-02-03 Russia Primorsky Krai     36967 541 28341 8085 45.0819456 134.726645 2021-02-04 05:22:26 Primorsky Krai, Russia
340512 340512 2021-02-03 Russia Pskov Oblast     29650 139 18086 11425 57.5358729 28.8586826 2021-02-04 05:22:26 Pskov Oblast, Russia
340513 340513 2021-02-03 Russia Rostov Oblast     64803 2705 54571 7527 47.6222451 40.7957942 2021-02-04 05:22:26 Rostov Oblast, Russia
340514 340514 2021-02-03 Russia Ryazan Oblast     22222 235 20275 1712 54.42267320000001 40.57052460000001 2021-02-04 05:22:26 Ryazan Oblast, Russia
340515 340515 2021-02-03 Russia Saint Petersburg     339358 9906 237310 92142 59.9606739 30.158655100000004 2021-02-04 05:22:26 Saint Petersburg, Russia
340516 340516 2021-02-03 Russia Sakha (Yakutiya) Republic     30934 494 28256 2184 66.941626 129.642371 2021-02-04 05:22:26 Sakha (Yakutiya) Republic, Russia
340517 340517 2021-02-03 Russia Sakhalin Oblast     19920 27 17446 2447 49.7219665 143.448533 2021-02-04 05:22:26 Sakhalin Oblast, Russia
340518 340518 2021-02-03 Russia Samara Oblast     41204 832 37897 2475 53.2128813 50.8914633 2021-02-04 05:22:26 Samara Oblast, Russia
340519 340519 2021-02-03 Russia Saratov Oblast     43917 552 38566 4799 51.6520555 46.86319520000001 2021-02-04 05:22:26 Saratov Oblast, Russia
340520 340520 2021-02-03 Russia Smolensk Oblast     22903 471 20033 2399 55.03434960000001 33.0192065 2021-02-04 05:22:26 Smolensk Oblast, Russia
340521 340521 2021-02-03 Russia Stavropol Krai     43165 945 38714 3506 44.86325770000001 43.4406913 2021-02-04 05:22:26 Stavropol Krai, Russia
340522 340522 2021-02-03 Russia Sverdlovsk Oblast     71479 2079 64144 5256 58.6414755 61.8021546 2021-02-04 05:22:26 Sverdlovsk Oblast, Russia
340523 340523 2021-02-03 Russia Tambov Oblast     22993 278 20999 1716 52.9019574 41.3578918 2021-02-04 05:22:26 Tambov Oblast, Russia
340524 340524 2021-02-03 Russia Tatarstan Republic     16302 283 12812 3207 55.7648572 52.43104273 2021-02-04 05:22:26 Tatarstan Republic, Russia
340525 340525 2021-02-03 Russia Tomsk Oblast     28512 267 25725 2520 58.6124279 82.04753149999998 2021-02-04 05:22:26 Tomsk Oblast, Russia
340526 340526 2021-02-03 Russia Tula Oblast     29434 1037 26728 1669 53.9570701 37.3690909 2021-02-04 05:22:26 Tula Oblast, Russia
340527 340527 2021-02-03 Russia Tver Oblast     29642 523 25752 3367 57.1134475 35.174442799999994 2021-02-04 05:22:26 Tver Oblast, Russia
340528 340528 2021-02-03 Russia Tyumen Oblast     28644 251 26849 1544 58.8206488 70.36588370000001 2021-02-04 05:22:26 Tyumen Oblast, Russia
340529 340529 2021-02-03 Russia Tyva Republic     15430 190 14270 970 51.4017149 93.8582593 2021-02-04 05:22:26 Tyva Republic, Russia
340530 340530 2021-02-03 Russia Udmurt Republic     25844 518 22394 2932 57.1961165 52.69598320000001 2021-02-04 05:22:26 Udmurt Republic, Russia
340531 340531 2021-02-03 Russia Ulyanovsk Oblast     44311 637 40691 2983 54.1463177 47.2324921 2021-02-04 05:22:26 Ulyanovsk Oblast, Russia
340532 340532 2021-02-03 Russia Vladimir Oblast     23943 699 21089 2155 56.0503336 40.6561633 2021-02-04 05:22:26 Vladimir Oblast, Russia
340533 340533 2021-02-03 Russia Volgograd Oblast     44050 624 42056 1370 49.6048339 44.29035820000001 2021-02-04 05:22:26 Volgograd Oblast, Russia
340534 340534 2021-02-03 Russia Vologda Oblast     33685 641 28830 4214 60.0391461 43.1215213 2021-02-04 05:22:26 Vologda Oblast, Russia
340535 340535 2021-02-03 Russia Voronezh Oblast     59332 1593 53254 4485 50.9800393 40.15065070000001 2021-02-04 05:22:26 Voronezh Oblast, Russia
340536 340536 2021-02-03 Russia Yamalo-Nenets Autonomous Okrug     35803 382 32250 3171 67.1471631 74.3415488 2021-02-04 05:22:26 Yamalo-Nenets Autonomous Okrug, Russia
340537 340537 2021-02-03 Russia Yaroslavl Oblast     28674 321 26955 1398 57.77819760000001 39.0021095 2021-02-04 05:22:26 Yaroslavl Oblast, Russia
340538 340538 2021-02-03 Russia Zabaykalsky Krai     34845 479 32983 1383 52.248521 115.956325 2021-02-04 05:22:26 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]);