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 2022-01-07 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
2610233 2610233 2022-01-06 Russia Adygea Republic     27686 752 0   44.6939006 40.1520421 2022-01-07 04:22:09 Adygea Republic, Russia
2610234 2610234 2022-01-06 Russia Altai Krai     121467 6727 0   52.693224300000004 82.69314240000001 2022-01-07 04:22:09 Altai Krai, Russia
2610235 2610235 2022-01-06 Russia Altai Republic     25440 524 0   50.7114101 86.8572186 2022-01-07 04:22:09 Altai Republic, Russia
2610236 2610236 2022-01-06 Russia Amur Oblast     55282 615 0   52.8032368 128.437295 2022-01-07 04:22:09 Amur Oblast, Russia
2610237 2610237 2022-01-06 Russia Arkhangelsk Oblast     124466 1521 0   63.5589686 43.1221646 2022-01-07 04:22:09 Arkhangelsk Oblast, Russia
2610238 2610238 2022-01-06 Russia Astrakhan Oblast     82105 2460 0   47.1878186 47.608851 2022-01-07 04:22:09 Astrakhan Oblast, Russia
2610239 2610239 2022-01-06 Russia Bashkortostan Republic     123179 4466 0   54.8573563 57.1439682 2022-01-07 04:22:09 Bashkortostan Republic, Russia
2610240 2610240 2022-01-06 Russia Belgorod Oblast     82299 1780 0   50.7080119 37.5837615 2022-01-07 04:22:09 Belgorod Oblast, Russia
2610241 2610241 2022-01-06 Russia Bryansk Oblast     97561 2986 0   52.887331499999995 33.41585300000001 2022-01-07 04:22:09 Bryansk Oblast, Russia
2610242 2610242 2022-01-06 Russia Buryatia Republic     77096 2471 0   52.718242599999996 109.492143 2022-01-07 04:22:09 Buryatia Republic, Russia
2610243 2610243 2022-01-06 Russia Chechen Republic     31211 946 0   43.39761470000001 45.6985005 2022-01-07 04:22:09 Chechen Republic, Russia
2610244 2610244 2022-01-06 Russia Chelyabinsk Oblast     147769 6195 0   54.4223954 61.1865846 2022-01-07 04:22:09 Chelyabinsk Oblast, Russia
2610245 2610245 2022-01-06 Russia Chukotka Autonomous Okrug     2966 39 0   66.0006475 169.4900869 2022-01-07 04:22:09 Chukotka Autonomous Okrug, Russia
2610246 2610246 2022-01-06 Russia Chuvashia Republic     46831 3990 0   55.4259922 47.0849429 2022-01-07 04:22:09 Chuvashia Republic, Russia
2610247 2610247 2022-01-06 Russia Dagestan Republic     66451 3221 0   43.05749160000001 47.1332224 2022-01-07 04:22:09 Dagestan Republic, Russia
2610248 2610248 2022-01-06 Russia Ingushetia Republic     29050 482 0   43.11542075 45.01713552 2022-01-07 04:22:09 Ingushetia Republic, Russia
2610249 2610249 2022-01-06 Russia Irkutsk Oblast     158668 7017 0   56.6370122 104.71922099999999 2022-01-07 04:22:09 Irkutsk Oblast, Russia
2610250 2610250 2022-01-06 Russia Ivanovo Oblast     68784 2557 0   56.9167446 41.43521370000001 2022-01-07 04:22:09 Ivanovo Oblast, Russia
2610251 2610251 2022-01-06 Russia Jewish Autonomous Okrug     11717 424 0   48.57527615 132.66307460000002 2022-01-07 04:22:09 Jewish Autonomous Okrug, Russia
2610252 2610252 2022-01-06 Russia Kabardino-Balkarian Republic     42502 1474 0   43.480604799999995 43.5978976 2022-01-07 04:22:09 Kabardino-Balkarian Republic, Russia
2610253 2610253 2022-01-06 Russia Kaliningrad Oblast     83077 1269 0   54.7293041 21.1489473 2022-01-07 04:22:09 Kaliningrad Oblast, Russia
2610254 2610254 2022-01-06 Russia Kalmykia Republic     34081 736 0   46.2313018 45.3275745 2022-01-07 04:22:09 Kalmykia Republic, Russia
2610255 2610255 2022-01-06 Russia Kaluga Oblast     65860 1242 0   54.438277299999996 35.5272854 2022-01-07 04:22:09 Kaluga Oblast, Russia
2610256 2610256 2022-01-06 Russia Kamchatka Krai     23858 510 0   57.191488199999995 160.03838190000005 2022-01-07 04:22:09 Kamchatka Krai, Russia
2610257 2610257 2022-01-06 Russia Karachay-Cherkess Republic     32610 910 0   43.7368326 41.7267991 2022-01-07 04:22:09 Karachay-Cherkess Republic, Russia
2610258 2610258 2022-01-06 Russia Karelia Republic     90674 1218 0   62.61940309999999 33.4920267 2022-01-07 04:22:09 Karelia Republic, Russia
2610259 2610259 2022-01-06 Russia Kemerovo Oblast     86670 1739 0   54.53357809999999 87.342861 2022-01-07 04:22:09 Kemerovo Oblast, Russia
2610260 2610260 2022-01-06 Russia Khabarovsk Krai     126813 1257 0   51.6312684 136.121524 2022-01-07 04:22:09 Khabarovsk Krai, Russia
2610261 2610261 2022-01-06 Russia Khakassia Republic     54098 2035 0   53.72258845 91.44293627 2022-01-07 04:22:09 Khakassia Republic, Russia
2610262 2610262 2022-01-06 Russia Khanty-Mansi Autonomous Okrug     96566 2031 0   61.0259025 69.0982628 2022-01-07 04:22:09 Khanty-Mansi Autonomous Okrug, Russia
2610263 2610263 2022-01-06 Russia Kirov Oblast     80072 764 0   57.9665589 49.4074599 2022-01-07 04:22:09 Kirov Oblast, Russia
2610264 2610264 2022-01-06 Russia Komi Republic     98048 2647 0   63.9881421 54.3326073 2022-01-07 04:22:09 Komi Republic, Russia
2610265 2610265 2022-01-06 Russia Kostroma Oblast     48824 1125 0   58.424756 44.253327299999995 2022-01-07 04:22:09 Kostroma Oblast, Russia
2610266 2610266 2022-01-06 Russia Krasnodar Krai     121247 9842 0   45.768401399999995 39.0261044 2022-01-07 04:22:09 Krasnodar Krai, Russia
2610267 2610267 2022-01-06 Russia Krasnoyarsk Krai     174812 8829 0   63.3233807 97.09799740000001 2022-01-07 04:22:09 Krasnoyarsk Krai, Russia
2610268 2610268 2022-01-06 Russia Kurgan Oblast     51185 1019 0   55.7655302 64.5632681 2022-01-07 04:22:09 Kurgan Oblast, Russia
2610269 2610269 2022-01-06 Russia Kursk Oblast     82380 2062 0   51.6568453 36.4852695 2022-01-07 04:22:09 Kursk Oblast, Russia
2610270 2610270 2022-01-06 Russia Leningrad Oblast     103305 3034 0   60.185329599999996 32.3925325 2022-01-07 04:22:09 Leningrad Oblast, Russia
2610271 2610271 2022-01-06 Russia Lipetsk Oblast     84685 2851 0   52.693517799999995 39.112266399999996 2022-01-07 04:22:09 Lipetsk Oblast, Russia
2610272 2610272 2022-01-06 Russia Magadan Oblast     13706 350 0   62.48858785 153.9903764 2022-01-07 04:22:09 Magadan Oblast, Russia
2610273 2610273 2022-01-06 Russia Mari El Republic     29617 946 0   56.576750399999995 47.881751200000004 2022-01-07 04:22:09 Mari El Republic, Russia
2610274 2610274 2022-01-06 Russia Mordovia Republic     40746 1047 0   54.4419829 44.466114399999995 2022-01-07 04:22:09 Mordovia Republic, Russia
2610275 2610275 2022-01-06 Russia Moscow     2043006 37183 0   55.7504461 37.6174943 2022-01-07 04:22:09 Moscow, Russia
2610276 2610276 2022-01-06 Russia Moscow Oblast     647750 12361 0   55.50431579999999 38.0353929 2022-01-07 04:22:09 Moscow Oblast, Russia
2610277 2610277 2022-01-06 Russia Murmansk Oblast     92389 2799 0   68.00004179999999 33.9999151 2022-01-07 04:22:09 Murmansk Oblast, Russia
2610278 2610278 2022-01-06 Russia Nenets Autonomous Okrug     3517 87 0   68.27557185 57.1686375 2022-01-07 04:22:09 Nenets Autonomous Okrug, Russia
2610279 2610279 2022-01-06 Russia Nizhny Novgorod Oblast     232907 9949 0   55.47180329999999 44.091159399999995 2022-01-07 04:22:09 Nizhny Novgorod Oblast, Russia
2610280 2610280 2022-01-06 Russia North Ossetia - Alania Republic     31379 989 0   42.79336110000001 44.6324493 2022-01-07 04:22:09 North Ossetia - Alania Republic, Russia
2610281 2610281 2022-01-06 Russia Novgorod Oblast     66074 779 0   58.2843833 32.516975699999996 2022-01-07 04:22:09 Novgorod Oblast, Russia
2610282 2610282 2022-01-06 Russia Novosibirsk Oblast     96440 4307 0   54.9720169 79.48139240000002 2022-01-07 04:22:09 Novosibirsk Oblast, Russia
2610283 2610283 2022-01-06 Russia Omsk Oblast     131945 3240 0   56.09352629999999 73.5099936 2022-01-07 04:22:09 Omsk Oblast, Russia
2610284 2610284 2022-01-06 Russia Orel Oblast     71060 1539 0   52.96854329999999 36.0692477 2022-01-07 04:22:09 Orel Oblast, Russia
2610285 2610285 2022-01-06 Russia Orenburg Oblast     108638 3489 0   52.02692620000001 54.7276647 2022-01-07 04:22:09 Orenburg Oblast, Russia
2610286 2610286 2022-01-06 Russia Penza Oblast     102970 4683 0   53.1655415 44.78791810000001 2022-01-07 04:22:09 Penza Oblast, Russia
2610287 2610287 2022-01-06 Russia Perm Krai     162402 7528 0   58.5951603 56.3159546 2022-01-07 04:22:09 Perm Krai, Russia
2610288 2610288 2022-01-06 Russia Primorsky Krai     104031 1579 0   45.0819456 134.726645 2022-01-07 04:22:09 Primorsky Krai, Russia
2610289 2610289 2022-01-06 Russia Pskov Oblast     71859 1294 0   57.535872899999994 28.8586826 2022-01-07 04:22:09 Pskov Oblast, Russia
2610290 2610290 2022-01-06 Russia Rostov Oblast     195789 9733 0   47.6222451 40.7957942 2022-01-07 04:22:09 Rostov Oblast, Russia
2610291 2610291 2022-01-06 Russia Ryazan Oblast     62085 2575 0   54.42267320000001 40.57052460000001 2022-01-07 04:22:09 Ryazan Oblast, Russia
2610292 2610292 2022-01-06 Russia Saint Petersburg     860107 28386 0   59.960673899999996 30.158655100000004 2022-01-07 04:22:09 Saint Petersburg, Russia
2610293 2610293 2022-01-06 Russia Sakha (Yakutiya) Republic     76548 1804 0   66.941626 129.642371 2022-01-07 04:22:09 Sakha (Yakutiya) Republic, Russia
2610294 2610294 2022-01-06 Russia Sakhalin Oblast     42568 552 0   49.7219665 143.448533 2022-01-07 04:22:09 Sakhalin Oblast, Russia
2610295 2610295 2022-01-06 Russia Samara Oblast     201482 6376 0   53.2128813 50.8914633 2022-01-07 04:22:09 Samara Oblast, Russia
2610296 2610296 2022-01-06 Russia Saratov Oblast     134365 5117 0   51.652055499999996 46.86319520000001 2022-01-07 04:22:09 Saratov Oblast, Russia
2610297 2610297 2022-01-06 Russia Smolensk Oblast     85452 2401 0   55.03434960000001 33.0192065 2022-01-07 04:22:09 Smolensk Oblast, Russia
2610298 2610298 2022-01-06 Russia Stavropol Krai     127013 6178 0   44.86325770000001 43.4406913 2022-01-07 04:22:09 Stavropol Krai, Russia
2610299 2610299 2022-01-06 Russia Sverdlovsk Oblast     201246 9551 0   58.6414755 61.802154599999994 2022-01-07 04:22:09 Sverdlovsk Oblast, Russia
2610300 2610300 2022-01-06 Russia Tambov Oblast     62131 1753 0   52.9019574 41.3578918 2022-01-07 04:22:09 Tambov Oblast, Russia
2610301 2610301 2022-01-06 Russia Tatarstan Republic     43261 1471 0   55.7648572 52.43104273 2022-01-07 04:22:09 Tatarstan Republic, Russia
2610302 2610302 2022-01-06 Russia Tomsk Oblast     62637 679 0   58.6124279 82.04753149999998 2022-01-07 04:22:09 Tomsk Oblast, Russia
2610303 2610303 2022-01-06 Russia Tula Oblast     76426 4323 0   53.9570701 37.369090899999996 2022-01-07 04:22:09 Tula Oblast, Russia
2610304 2610304 2022-01-06 Russia Tver Oblast     99848 2382 0   57.1134475 35.174442799999994 2022-01-07 04:22:09 Tver Oblast, Russia
2610305 2610305 2022-01-06 Russia Tyumen Oblast     91327 3467 0   58.8206488 70.36588370000001 2022-01-07 04:22:09 Tyumen Oblast, Russia
2610306 2610306 2022-01-06 Russia Tyva Republic     31615 320 0   51.401714899999995 93.8582593 2022-01-07 04:22:09 Tyva Republic, Russia
2610307 2610307 2022-01-06 Russia Udmurt Republic     79386 3254 0   57.1961165 52.69598320000001 2022-01-07 04:22:09 Udmurt Republic, Russia
2610308 2610308 2022-01-06 Russia Ulyanovsk Oblast     121137 3843 0   54.146317700000004 47.2324921 2022-01-07 04:22:09 Ulyanovsk Oblast, Russia
2610309 2610309 2022-01-06 Russia Vladimir Oblast     82517 2951 0   56.0503336 40.656163299999996 2022-01-07 04:22:09 Vladimir Oblast, Russia
2610310 2610310 2022-01-06 Russia Volgograd Oblast     130522 5631 0   49.604833899999996 44.29035820000001 2022-01-07 04:22:09 Volgograd Oblast, Russia
2610311 2610311 2022-01-06 Russia Vologda Oblast     100443 3011 0   60.0391461 43.1215213 2022-01-07 04:22:09 Vologda Oblast, Russia
2610312 2610312 2022-01-06 Russia Voronezh Oblast     195448 7018 0   50.9800393 40.15065070000001 2022-01-07 04:22:09 Voronezh Oblast, Russia
2610313 2610313 2022-01-06 Russia Yamalo-Nenets Autonomous Okrug     62252 961 0   67.1471631 74.3415488 2022-01-07 04:22:09 Yamalo-Nenets Autonomous Okrug, Russia
2610314 2610314 2022-01-06 Russia Yaroslavl Oblast     86833 1948 0   57.77819760000001 39.002109499999996 2022-01-07 04:22:09 Yaroslavl Oblast, Russia
2610315 2610315 2022-01-06 Russia Zabaykalsky Krai     96594 1887 0   52.248521000000004 115.956325 2022-01-07 04:22:09 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]);