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-03-29 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
1536109 1536109 2021-03-28 Russia Adygea Republic     14070 162 13182 726 44.6939006 40.1520421 2021-03-29 04:28:35 Adygea Republic, Russia
1536110 1536110 2021-03-28 Russia Altai Krai     46835 1786 41875 3174 52.6932243 82.69314240000001 2021-03-29 04:28:35 Altai Krai, Russia
1536111 1536111 2021-03-28 Russia Altai Republic     16639 187 16250 202 50.7114101 86.8572186 2021-03-29 04:28:35 Altai Republic, Russia
1536112 1536112 2021-03-28 Russia Amur Oblast     21830 236 20600 994 52.8032368 128.437295 2021-03-29 04:28:35 Amur Oblast, Russia
1536113 1536113 2021-03-28 Russia Arkhangelsk Oblast     59447 819 55007 3621 63.5589686 43.1221646 2021-03-29 04:28:35 Arkhangelsk Oblast, Russia
1536114 1536114 2021-03-28 Russia Astrakhan Oblast     30499 659 28294 1546 47.1878186 47.608851 2021-03-29 04:28:35 Astrakhan Oblast, Russia
1536115 1536115 2021-03-28 Russia Bashkortostan Republic     32034 352 27012 4670 54.8573563 57.1439682 2021-03-29 04:28:35 Bashkortostan Republic, Russia
1536116 1536116 2021-03-28 Russia Belgorod Oblast     34021 554 31794 1673 50.7080119 37.5837615 2021-03-29 04:28:35 Belgorod Oblast, Russia
1536117 1536117 2021-03-28 Russia Bryansk Oblast     35370 283 34507 580 52.8873315 33.41585300000001 2021-03-29 04:28:35 Bryansk Oblast, Russia
1536118 1536118 2021-03-28 Russia Buryatia Republic     35838 777 34223 838 52.7182426 109.492143 2021-03-29 04:28:35 Buryatia Republic, Russia
1536119 1536119 2021-03-28 Russia Chechen Republic     11622 116 11286 220 43.39761470000001 45.6985005 2021-03-29 04:28:35 Chechen Republic, Russia
1536120 1536120 2021-03-28 Russia Chelyabinsk Oblast     54998 1200 49924 3874 54.4223954 61.1865846 2021-03-29 04:28:35 Chelyabinsk Oblast, Russia
1536121 1536121 2021-03-28 Russia Chukotka Autonomous Okrug     728 5 689 34 66.0006475 169.4900869 2021-03-29 04:28:35 Chukotka Autonomous Okrug, Russia
1536122 1536122 2021-03-28 Russia Chuvashia Republic     22662 1199 20682 781 55.4259922 47.0849429 2021-03-29 04:28:35 Chuvashia Republic, Russia
1536123 1536123 2021-03-28 Russia Dagestan Republic     30911 1397 28586 928 43.05749160000001 47.1332224 2021-03-29 04:28:35 Dagestan Republic, Russia
1536124 1536124 2021-03-28 Russia Ingushetia Republic     15091 180 13369 1542 43.11542075 45.01713552 2021-03-29 04:28:35 Ingushetia Republic, Russia
1536125 1536125 2021-03-28 Russia Irkutsk Oblast     61078 1987 58198 893 56.6370122 104.719221 2021-03-29 04:28:35 Irkutsk Oblast, Russia
1536126 1536126 2021-03-28 Russia Ivanovo Oblast     32364 1031 30792 541 56.9167446 41.43521370000001 2021-03-29 04:28:35 Ivanovo Oblast, Russia
1536127 1536127 2021-03-28 Russia Jewish Autonomous Okrug     4420 124 4217 79 48.57527615 132.66307460000002 2021-03-29 04:28:35 Jewish Autonomous Okrug, Russia
1536128 1536128 2021-03-28 Russia Kabardino-Balkarian Republic     22649 412 21526 711 43.4806048 43.5978976 2021-03-29 04:28:35 Kabardino-Balkarian Republic, Russia
1536129 1536129 2021-03-28 Russia Kaliningrad Oblast     30121 334 27757 2030 54.7293041 21.1489473 2021-03-29 04:28:35 Kaliningrad Oblast, Russia
1536130 1536130 2021-03-28 Russia Kalmykia Republic     19883 313 19024 546 46.2313018 45.3275745 2021-03-29 04:28:35 Kalmykia Republic, Russia
1536131 1536131 2021-03-28 Russia Kaluga Oblast     32162 281 29973 1908 54.4382773 35.5272854 2021-03-29 04:28:35 Kaluga Oblast, Russia
1536132 1536132 2021-03-28 Russia Kamchatka Krai     14077 195 13123 759 57.1914882 160.03838190000005 2021-03-29 04:28:35 Kamchatka Krai, Russia
1536133 1536133 2021-03-28 Russia Karachay-Cherkess Republic     19628 70 18581 977 43.7368326 41.7267991 2021-03-29 04:28:35 Karachay-Cherkess Republic, Russia
1536134 1536134 2021-03-28 Russia Karelia Republic     43594 380 40882 2332 62.61940309999999 33.4920267 2021-03-29 04:28:35 Karelia Republic, Russia
1536135 1536135 2021-03-28 Russia Kemerovo Oblast     33106 607 32222 277 54.53357809999999 87.342861 2021-03-29 04:28:35 Kemerovo Oblast, Russia
1536136 1536136 2021-03-28 Russia Khabarovsk Krai     50502 340 48085 2077 51.6312684 136.121524 2021-03-29 04:28:35 Khabarovsk Krai, Russia
1536137 1536137 2021-03-28 Russia Khakassia Republic     21809 503 21053 253 53.72258845 91.44293627 2021-03-29 04:28:35 Khakassia Republic, Russia
1536138 1536138 2021-03-28 Russia Khanty-Mansi Autonomous Okrug     53956 781 52437 738 61.0259025 69.0982628 2021-03-29 04:28:35 Khanty-Mansi Autonomous Okrug, Russia
1536139 1536139 2021-03-28 Russia Kirov Oblast     39479 321 35817 3341 57.9665589 49.4074599 2021-03-29 04:28:35 Kirov Oblast, Russia
1536140 1536140 2021-03-28 Russia Komi Republic     41417 799 40240 378 63.9881421 54.3326073 2021-03-29 04:28:35 Komi Republic, Russia
1536141 1536141 2021-03-28 Russia Kostroma Oblast     19528 386 16767 2375 58.424756 44.2533273 2021-03-29 04:28:35 Kostroma Oblast, Russia
1536142 1536142 2021-03-28 Russia Krasnodar Krai     42042 2288 36887 2867 45.7684014 39.0261044 2021-03-29 04:28:35 Krasnodar Krai, Russia
1536143 1536143 2021-03-28 Russia Krasnoyarsk Krai     66414 3131 61469 1814 63.3233807 97.0979974 2021-03-29 04:28:35 Krasnoyarsk Krai, Russia
1536144 1536144 2021-03-28 Russia Kurgan Oblast     19099 347 17369 1383 55.7655302 64.5632681 2021-03-29 04:28:35 Kurgan Oblast, Russia
1536145 1536145 2021-03-28 Russia Kursk Oblast     33732 560 30517 2655 51.6568453 36.4852695 2021-03-29 04:28:35 Kursk Oblast, Russia
1536146 1536146 2021-03-28 Russia Leningrad Oblast     39578 912 37063 1603 60.1853296 32.3925325 2021-03-29 04:28:35 Leningrad Oblast, Russia
1536147 1536147 2021-03-28 Russia Lipetsk Oblast     27348 517 23884 2947 52.6935178 39.1122664 2021-03-29 04:28:35 Lipetsk Oblast, Russia
1536148 1536148 2021-03-28 Russia Magadan Oblast     8250 99 8021 130 62.48858785 153.9903764 2021-03-29 04:28:35 Magadan Oblast, Russia
1536149 1536149 2021-03-28 Russia Mari El Republic     12479 200 11625 654 56.5767504 47.8817512 2021-03-29 04:28:35 Mari El Republic, Russia
1536150 1536150 2021-03-28 Russia Mordovia Republic     18940 199 16924 1817 54.4419829 44.4661144 2021-03-29 04:28:35 Mordovia Republic, Russia
1536151 1536151 2021-03-28 Russia Moscow     1022551 16498 941192 64861 55.7504461 37.6174943 2021-03-29 04:28:35 Moscow, Russia
1536152 1536152 2021-03-28 Russia Moscow Oblast     230526 5403 189259 35864 55.50431579999999 38.0353929 2021-03-29 04:28:35 Moscow Oblast, Russia
1536153 1536153 2021-03-28 Russia Murmansk Oblast     48849 1070 46902 877 68.00004179999999 33.9999151 2021-03-29 04:28:35 Murmansk Oblast, Russia
1536154 1536154 2021-03-28 Russia Nenets Autonomous Okrug     1078 4 1014 60 68.27557185 57.1686375 2021-03-29 04:28:35 Nenets Autonomous Okrug, Russia
1536155 1536155 2021-03-28 Russia Nizhny Novgorod Oblast     106601 2813 100481 3307 55.47180329999999 44.0911594 2021-03-29 04:28:35 Nizhny Novgorod Oblast, Russia
1536156 1536156 2021-03-28 Russia North Ossetia - Alania Republic     16290 161 15298 831 42.79336110000001 44.6324493 2021-03-29 04:28:35 North Ossetia - Alania Republic, Russia
1536157 1536157 2021-03-28 Russia Novgorod Oblast     28552 118 25587 2847 58.2843833 32.5169757 2021-03-29 04:28:35 Novgorod Oblast, Russia
1536158 1536158 2021-03-28 Russia Novosibirsk Oblast     38522 1608 35666 1248 54.9720169 79.48139240000002 2021-03-29 04:28:35 Novosibirsk Oblast, Russia
1536159 1536159 2021-03-28 Russia Omsk Oblast     43482 1307 40249 1926 56.09352629999999 73.5099936 2021-03-29 04:28:35 Omsk Oblast, Russia
1536160 1536160 2021-03-28 Russia Orel Oblast     32243 499 29574 2170 52.96854329999999 36.0692477 2021-03-29 04:28:35 Orel Oblast, Russia
1536161 1536161 2021-03-28 Russia Orenburg Oblast     39767 723 36469 2575 52.02692620000001 54.7276647 2021-03-29 04:28:35 Orenburg Oblast, Russia
1536162 1536162 2021-03-28 Russia Penza Oblast     41712 519 38407 2786 53.1655415 44.78791810000001 2021-03-29 04:28:35 Penza Oblast, Russia
1536163 1536163 2021-03-28 Russia Perm Krai     50893 1932 45061 3900 58.5951603 56.3159546 2021-03-29 04:28:35 Perm Krai, Russia
1536164 1536164 2021-03-28 Russia Primorsky Krai     42198 673 38257 3268 45.0819456 134.726645 2021-03-29 04:28:35 Primorsky Krai, Russia
1536165 1536165 2021-03-28 Russia Pskov Oblast     34102 232 23326 10544 57.5358729 28.8586826 2021-03-29 04:28:35 Pskov Oblast, Russia
1536166 1536166 2021-03-28 Russia Rostov Oblast     80115 3521 71867 4727 47.6222451 40.7957942 2021-03-29 04:28:35 Rostov Oblast, Russia
1536167 1536167 2021-03-28 Russia Ryazan Oblast     26155 358 24208 1589 54.42267320000001 40.57052460000001 2021-03-29 04:28:35 Ryazan Oblast, Russia
1536168 1536168 2021-03-28 Russia Saint Petersburg     392500 12167 344728 35605 59.9606739 30.158655100000004 2021-03-29 04:28:35 Saint Petersburg, Russia
1536169 1536169 2021-03-28 Russia Sakha (Yakutiya) Republic     33487 545 32357 585 66.941626 129.642371 2021-03-29 04:28:35 Sakha (Yakutiya) Republic, Russia
1536170 1536170 2021-03-28 Russia Sakhalin Oblast     21976 39 21616 321 49.7219665 143.448533 2021-03-29 04:28:35 Sakhalin Oblast, Russia
1536171 1536171 2021-03-28 Russia Samara Oblast     55136 1071 51869 2196 53.2128813 50.8914633 2021-03-29 04:28:35 Samara Oblast, Russia
1536172 1536172 2021-03-28 Russia Saratov Oblast     54322 798 49001 4523 51.6520555 46.86319520000001 2021-03-29 04:28:35 Saratov Oblast, Russia
1536173 1536173 2021-03-28 Russia Smolensk Oblast     28039 748 26717 574 55.03434960000001 33.0192065 2021-03-29 04:28:35 Smolensk Oblast, Russia
1536174 1536174 2021-03-28 Russia Stavropol Krai     50242 1217 47146 1879 44.86325770000001 43.4406913 2021-03-29 04:28:35 Stavropol Krai, Russia
1536175 1536175 2021-03-28 Russia Sverdlovsk Oblast     82108 2706 75407 3995 58.6414755 61.8021546 2021-03-29 04:28:35 Sverdlovsk Oblast, Russia
1536176 1536176 2021-03-28 Russia Tambov Oblast     29138 403 26657 2078 52.9019574 41.3578918 2021-03-29 04:28:35 Tambov Oblast, Russia
1536177 1536177 2021-03-28 Russia Tatarstan Republic     19310 412 16111 2787 55.7648572 52.43104273 2021-03-29 04:28:35 Tatarstan Republic, Russia
1536178 1536178 2021-03-28 Russia Tomsk Oblast     31304 352 30191 761 58.6124279 82.04753149999998 2021-03-29 04:28:35 Tomsk Oblast, Russia
1536179 1536179 2021-03-28 Russia Tula Oblast     35970 1516 33385 1069 53.9570701 37.3690909 2021-03-29 04:28:35 Tula Oblast, Russia
1536180 1536180 2021-03-28 Russia Tver Oblast     37099 725 35015 1359 57.1134475 35.174442799999994 2021-03-29 04:28:35 Tver Oblast, Russia
1536181 1536181 2021-03-28 Russia Tyumen Oblast     33426 373 31502 1551 58.8206488 70.36588370000001 2021-03-29 04:28:35 Tyumen Oblast, Russia
1536182 1536182 2021-03-28 Russia Tyva Republic     15758 197 14885 676 51.4017149 93.8582593 2021-03-29 04:28:35 Tyva Republic, Russia
1536183 1536183 2021-03-28 Russia Udmurt Republic     30431 751 27048 2632 57.1961165 52.69598320000001 2021-03-29 04:28:35 Udmurt Republic, Russia
1536184 1536184 2021-03-28 Russia Ulyanovsk Oblast     50523 959 47186 2378 54.1463177 47.2324921 2021-03-29 04:28:35 Ulyanovsk Oblast, Russia
1536185 1536185 2021-03-28 Russia Vladimir Oblast     29780 996 26861 1923 56.0503336 40.6561633 2021-03-29 04:28:35 Vladimir Oblast, Russia
1536186 1536186 2021-03-28 Russia Volgograd Oblast     53281 940 50982 1359 49.6048339 44.29035820000001 2021-03-29 04:28:35 Volgograd Oblast, Russia
1536187 1536187 2021-03-28 Russia Vologda Oblast     42439 893 39553 1993 60.0391461 43.1215213 2021-03-29 04:28:35 Vologda Oblast, Russia
1536188 1536188 2021-03-28 Russia Voronezh Oblast     74539 2375 69185 2979 50.9800393 40.15065070000001 2021-03-29 04:28:35 Voronezh Oblast, Russia
1536189 1536189 2021-03-28 Russia Yamalo-Nenets Autonomous Okrug     37922 407 36463 1052 67.1471631 74.3415488 2021-03-29 04:28:35 Yamalo-Nenets Autonomous Okrug, Russia
1536190 1536190 2021-03-28 Russia Yaroslavl Oblast     35828 477 34210 1141 57.77819760000001 39.0021095 2021-03-29 04:28:35 Yaroslavl Oblast, Russia
1536191 1536191 2021-03-28 Russia Zabaykalsky Krai     40883 588 39390 905 52.248521 115.956325 2021-03-29 04:28:35 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]);