johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78,307 rows where country_or_region = "Russia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Adygea Republic 509
- Altai Krai 509
- Altai Republic 509
- Amur Oblast 509
- Arkhangelsk Oblast 509
- Astrakhan Oblast 509
- Bashkortostan Republic 509
- Belgorod Oblast 509
- Bryansk Oblast 509
- Buryatia Republic 509
- Chechen Republic 509
- Chelyabinsk Oblast 509
- Chukotka Autonomous Okrug 509
- Chuvashia Republic 509
- Dagestan Republic 509
- Ingushetia Republic 509
- Irkutsk Oblast 509
- Ivanovo Oblast 509
- Jewish Autonomous Okrug 509
- Kabardino-Balkarian Republic 509
- Kaliningrad Oblast 509
- Kalmykia Republic 509
- Kaluga Oblast 509
- Kamchatka Krai 509
- Karachay-Cherkess Republic 509
- Karelia Republic 509
- Kemerovo Oblast 509
- Khabarovsk Krai 509
- Khakassia Republic 509
- Khanty-Mansi Autonomous Okrug 509
- …
country_or_region 1
- Russia · 42,368 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
654181 | 654181 | 2021-10-22 | Russia | Adygea Republic | 20903 | 520 | 0 | 44.6939006 | 40.1520421 | 2021-10-23 04:21:32 | Adygea Republic, Russia | |||
654182 | 654182 | 2021-10-22 | Russia | Altai Krai | 84645 | 4694 | 0 | 52.693224300000004 | 82.69314240000001 | 2021-10-23 04:21:32 | Altai Krai, Russia | |||
654183 | 654183 | 2021-10-22 | Russia | Altai Republic | 22422 | 390 | 0 | 50.7114101 | 86.8572186 | 2021-10-23 04:21:32 | Altai Republic, Russia | |||
654184 | 654184 | 2021-10-22 | Russia | Amur Oblast | 38359 | 475 | 0 | 52.8032368 | 128.437295 | 2021-10-23 04:21:32 | Amur Oblast, Russia | |||
654185 | 654185 | 2021-10-22 | Russia | Arkhangelsk Oblast | 96661 | 1232 | 0 | 63.5589686 | 43.1221646 | 2021-10-23 04:21:32 | Arkhangelsk Oblast, Russia | |||
654186 | 654186 | 2021-10-22 | Russia | Astrakhan Oblast | 64032 | 1879 | 0 | 47.1878186 | 47.608851 | 2021-10-23 04:21:32 | Astrakhan Oblast, Russia | |||
654187 | 654187 | 2021-10-22 | Russia | Bashkortostan Republic | 80144 | 2304 | 0 | 54.8573563 | 57.1439682 | 2021-10-23 04:21:32 | Bashkortostan Republic, Russia | |||
654188 | 654188 | 2021-10-22 | Russia | Belgorod Oblast | 59437 | 1265 | 0 | 50.7080119 | 37.5837615 | 2021-10-23 04:21:32 | Belgorod Oblast, Russia | |||
654189 | 654189 | 2021-10-22 | Russia | Bryansk Oblast | 72194 | 1720 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-23 04:21:32 | Bryansk Oblast, Russia | |||
654190 | 654190 | 2021-10-22 | Russia | Buryatia Republic | 61525 | 1936 | 0 | 52.718242599999996 | 109.492143 | 2021-10-23 04:21:32 | Buryatia Republic, Russia | |||
654191 | 654191 | 2021-10-22 | Russia | Chechen Republic | 24264 | 677 | 0 | 43.39761470000001 | 45.6985005 | 2021-10-23 04:21:32 | Chechen Republic, Russia | |||
654192 | 654192 | 2021-10-22 | Russia | Chelyabinsk Oblast | 104929 | 3985 | 0 | 54.4223954 | 61.1865846 | 2021-10-23 04:21:32 | Chelyabinsk Oblast, Russia | |||
654193 | 654193 | 2021-10-22 | Russia | Chukotka Autonomous Okrug | 2215 | 19 | 0 | 66.0006475 | 169.4900869 | 2021-10-23 04:21:32 | Chukotka Autonomous Okrug, Russia | |||
654194 | 654194 | 2021-10-22 | Russia | Chuvashia Republic | 36380 | 2611 | 0 | 55.4259922 | 47.0849429 | 2021-10-23 04:21:32 | Chuvashia Republic, Russia | |||
654195 | 654195 | 2021-10-22 | Russia | Dagestan Republic | 54612 | 2691 | 0 | 43.05749160000001 | 47.1332224 | 2021-10-23 04:21:32 | Dagestan Republic, Russia | |||
654196 | 654196 | 2021-10-22 | Russia | Ingushetia Republic | 22973 | 354 | 0 | 43.11542075 | 45.01713552 | 2021-10-23 04:21:32 | Ingushetia Republic, Russia | |||
654197 | 654197 | 2021-10-22 | Russia | Irkutsk Oblast | 117705 | 5147 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-23 04:21:32 | Irkutsk Oblast, Russia | |||
654198 | 654198 | 2021-10-22 | Russia | Ivanovo Oblast | 53328 | 1762 | 0 | 56.9167446 | 41.43521370000001 | 2021-10-23 04:21:32 | Ivanovo Oblast, Russia | |||
654199 | 654199 | 2021-10-22 | Russia | Jewish Autonomous Okrug | 8857 | 286 | 0 | 48.57527615 | 132.66307460000002 | 2021-10-23 04:21:32 | Jewish Autonomous Okrug, Russia | |||
654200 | 654200 | 2021-10-22 | Russia | Kabardino-Balkarian Republic | 34001 | 887 | 0 | 43.480604799999995 | 43.5978976 | 2021-10-23 04:21:32 | Kabardino-Balkarian Republic, Russia | |||
654201 | 654201 | 2021-10-22 | Russia | Kaliningrad Oblast | 61212 | 833 | 0 | 54.7293041 | 21.1489473 | 2021-10-23 04:21:32 | Kaliningrad Oblast, Russia | |||
654202 | 654202 | 2021-10-22 | Russia | Kalmykia Republic | 31759 | 640 | 0 | 46.2313018 | 45.3275745 | 2021-10-23 04:21:32 | Kalmykia Republic, Russia | |||
654203 | 654203 | 2021-10-22 | Russia | Kaluga Oblast | 51404 | 809 | 0 | 54.438277299999996 | 35.5272854 | 2021-10-23 04:21:32 | Kaluga Oblast, Russia | |||
654204 | 654204 | 2021-10-22 | Russia | Kamchatka Krai | 20618 | 416 | 0 | 57.191488199999995 | 160.03838190000005 | 2021-10-23 04:21:32 | Kamchatka Krai, Russia | |||
654205 | 654205 | 2021-10-22 | Russia | Karachay-Cherkess Republic | 26794 | 729 | 0 | 43.7368326 | 41.7267991 | 2021-10-23 04:21:32 | Karachay-Cherkess Republic, Russia | |||
654206 | 654206 | 2021-10-22 | Russia | Karelia Republic | 71658 | 942 | 0 | 62.61940309999999 | 33.4920267 | 2021-10-23 04:21:32 | Karelia Republic, Russia | |||
654207 | 654207 | 2021-10-22 | Russia | Kemerovo Oblast | 60826 | 1414 | 0 | 54.53357809999999 | 87.342861 | 2021-10-23 04:21:32 | Kemerovo Oblast, Russia | |||
654208 | 654208 | 2021-10-22 | Russia | Khabarovsk Krai | 90672 | 881 | 0 | 51.6312684 | 136.121524 | 2021-10-23 04:21:32 | Khabarovsk Krai, Russia | |||
654209 | 654209 | 2021-10-22 | Russia | Khakassia Republic | 42023 | 1257 | 0 | 53.72258845 | 91.44293627 | 2021-10-23 04:21:32 | Khakassia Republic, Russia | |||
654210 | 654210 | 2021-10-22 | Russia | Khanty-Mansi Autonomous Okrug | 79819 | 1249 | 0 | 61.0259025 | 69.0982628 | 2021-10-23 04:21:32 | Khanty-Mansi Autonomous Okrug, Russia | |||
654211 | 654211 | 2021-10-22 | Russia | Kirov Oblast | 61497 | 576 | 0 | 57.9665589 | 49.4074599 | 2021-10-23 04:21:32 | Kirov Oblast, Russia | |||
654212 | 654212 | 2021-10-22 | Russia | Komi Republic | 76020 | 1910 | 0 | 63.9881421 | 54.3326073 | 2021-10-23 04:21:32 | Komi Republic, Russia | |||
654213 | 654213 | 2021-10-22 | Russia | Kostroma Oblast | 36942 | 853 | 0 | 58.424756 | 44.253327299999995 | 2021-10-23 04:21:32 | Kostroma Oblast, Russia | |||
654214 | 654214 | 2021-10-22 | Russia | Krasnodar Krai | 79115 | 7015 | 0 | 45.768401399999995 | 39.0261044 | 2021-10-23 04:21:32 | Krasnodar Krai, Russia | |||
654215 | 654215 | 2021-10-22 | Russia | Krasnoyarsk Krai | 125642 | 6319 | 0 | 63.3233807 | 97.09799740000001 | 2021-10-23 04:21:32 | Krasnoyarsk Krai, Russia | |||
654216 | 654216 | 2021-10-22 | Russia | Kurgan Oblast | 36946 | 780 | 0 | 55.7655302 | 64.5632681 | 2021-10-23 04:21:32 | Kurgan Oblast, Russia | |||
654217 | 654217 | 2021-10-22 | Russia | Kursk Oblast | 63254 | 1560 | 0 | 51.6568453 | 36.4852695 | 2021-10-23 04:21:32 | Kursk Oblast, Russia | |||
654218 | 654218 | 2021-10-22 | Russia | Leningrad Oblast | 75238 | 2524 | 0 | 60.185329599999996 | 32.3925325 | 2021-10-23 04:21:32 | Leningrad Oblast, Russia | |||
654219 | 654219 | 2021-10-22 | Russia | Lipetsk Oblast | 59256 | 1916 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-10-23 04:21:32 | Lipetsk Oblast, Russia | |||
654220 | 654220 | 2021-10-22 | Russia | Magadan Oblast | 11466 | 272 | 0 | 62.48858785 | 153.9903764 | 2021-10-23 04:21:32 | Magadan Oblast, Russia | |||
654221 | 654221 | 2021-10-22 | Russia | Mari El Republic | 21391 | 667 | 0 | 56.576750399999995 | 47.881751200000004 | 2021-10-23 04:21:32 | Mari El Republic, Russia | |||
654222 | 654222 | 2021-10-22 | Russia | Mordovia Republic | 30421 | 659 | 0 | 54.4419829 | 44.466114399999995 | 2021-10-23 04:21:32 | Mordovia Republic, Russia | |||
654223 | 654223 | 2021-10-22 | Russia | Moscow | 1753847 | 30537 | 0 | 55.7504461 | 37.6174943 | 2021-10-23 04:21:32 | Moscow, Russia | |||
654224 | 654224 | 2021-10-22 | Russia | Moscow Oblast | 493343 | 8417 | 0 | 55.50431579999999 | 38.0353929 | 2021-10-23 04:21:32 | Moscow Oblast, Russia | |||
654225 | 654225 | 2021-10-22 | Russia | Murmansk Oblast | 76699 | 2246 | 0 | 68.00004179999999 | 33.9999151 | 2021-10-23 04:21:32 | Murmansk Oblast, Russia | |||
654226 | 654226 | 2021-10-22 | Russia | Nenets Autonomous Okrug | 2612 | 58 | 0 | 68.27557185 | 57.1686375 | 2021-10-23 04:21:32 | Nenets Autonomous Okrug, Russia | |||
654227 | 654227 | 2021-10-22 | Russia | Nizhny Novgorod Oblast | 184166 | 7362 | 0 | 55.47180329999999 | 44.091159399999995 | 2021-10-23 04:21:32 | Nizhny Novgorod Oblast, Russia | |||
654228 | 654228 | 2021-10-22 | Russia | North Ossetia - Alania Republic | 24663 | 680 | 0 | 42.79336110000001 | 44.6324493 | 2021-10-23 04:21:32 | North Ossetia - Alania Republic, Russia | |||
654229 | 654229 | 2021-10-22 | Russia | Novgorod Oblast | 48228 | 484 | 0 | 58.2843833 | 32.516975699999996 | 2021-10-23 04:21:32 | Novgorod Oblast, Russia | |||
654230 | 654230 | 2021-10-22 | Russia | Novosibirsk Oblast | 68143 | 3265 | 0 | 54.9720169 | 79.48139240000002 | 2021-10-23 04:21:32 | Novosibirsk Oblast, Russia | |||
654231 | 654231 | 2021-10-22 | Russia | Omsk Oblast | 92926 | 2381 | 0 | 56.09352629999999 | 73.5099936 | 2021-10-23 04:21:32 | Omsk Oblast, Russia | |||
654232 | 654232 | 2021-10-22 | Russia | Orel Oblast | 50614 | 1047 | 0 | 52.96854329999999 | 36.0692477 | 2021-10-23 04:21:32 | Orel Oblast, Russia | |||
654233 | 654233 | 2021-10-22 | Russia | Orenburg Oblast | 85697 | 2395 | 0 | 52.02692620000001 | 54.7276647 | 2021-10-23 04:21:32 | Orenburg Oblast, Russia | |||
654234 | 654234 | 2021-10-22 | Russia | Penza Oblast | 76988 | 3277 | 0 | 53.1655415 | 44.78791810000001 | 2021-10-23 04:21:32 | Penza Oblast, Russia | |||
654235 | 654235 | 2021-10-22 | Russia | Perm Krai | 113814 | 5514 | 0 | 58.5951603 | 56.3159546 | 2021-10-23 04:21:32 | Perm Krai, Russia | |||
654236 | 654236 | 2021-10-22 | Russia | Primorsky Krai | 73840 | 1228 | 0 | 45.0819456 | 134.726645 | 2021-10-23 04:21:32 | Primorsky Krai, Russia | |||
654237 | 654237 | 2021-10-22 | Russia | Pskov Oblast | 55202 | 874 | 0 | 57.535872899999994 | 28.8586826 | 2021-10-23 04:21:32 | Pskov Oblast, Russia | |||
654238 | 654238 | 2021-10-22 | Russia | Rostov Oblast | 150578 | 7453 | 0 | 47.6222451 | 40.7957942 | 2021-10-23 04:21:32 | Rostov Oblast, Russia | |||
654239 | 654239 | 2021-10-22 | Russia | Ryazan Oblast | 45962 | 1308 | 0 | 54.42267320000001 | 40.57052460000001 | 2021-10-23 04:21:32 | Ryazan Oblast, Russia | |||
654240 | 654240 | 2021-10-22 | Russia | Saint Petersburg | 679743 | 23229 | 0 | 59.960673899999996 | 30.158655100000004 | 2021-10-23 04:21:32 | Saint Petersburg, Russia | |||
654241 | 654241 | 2021-10-22 | Russia | Sakha (Yakutiya) Republic | 59537 | 1371 | 0 | 66.941626 | 129.642371 | 2021-10-23 04:21:32 | Sakha (Yakutiya) Republic, Russia | |||
654242 | 654242 | 2021-10-22 | Russia | Sakhalin Oblast | 34226 | 346 | 0 | 49.7219665 | 143.448533 | 2021-10-23 04:21:32 | Sakhalin Oblast, Russia | |||
654243 | 654243 | 2021-10-22 | Russia | Samara Oblast | 121730 | 4388 | 0 | 53.2128813 | 50.8914633 | 2021-10-23 04:21:32 | Samara Oblast, Russia | |||
654244 | 654244 | 2021-10-22 | Russia | Saratov Oblast | 96866 | 3583 | 0 | 51.652055499999996 | 46.86319520000001 | 2021-10-23 04:21:32 | Saratov Oblast, Russia | |||
654245 | 654245 | 2021-10-22 | Russia | Smolensk Oblast | 56749 | 1863 | 0 | 55.03434960000001 | 33.0192065 | 2021-10-23 04:21:32 | Smolensk Oblast, Russia | |||
654246 | 654246 | 2021-10-22 | Russia | Stavropol Krai | 93976 | 3718 | 0 | 44.86325770000001 | 43.4406913 | 2021-10-23 04:21:32 | Stavropol Krai, Russia | |||
654247 | 654247 | 2021-10-22 | Russia | Sverdlovsk Oblast | 151334 | 7193 | 0 | 58.6414755 | 61.802154599999994 | 2021-10-23 04:21:32 | Sverdlovsk Oblast, Russia | |||
654248 | 654248 | 2021-10-22 | Russia | Tambov Oblast | 46685 | 1038 | 0 | 52.9019574 | 41.3578918 | 2021-10-23 04:21:32 | Tambov Oblast, Russia | |||
654249 | 654249 | 2021-10-22 | Russia | Tatarstan Republic | 29239 | 897 | 0 | 55.7648572 | 52.43104273 | 2021-10-23 04:21:32 | Tatarstan Republic, Russia | |||
654250 | 654250 | 2021-10-22 | Russia | Tomsk Oblast | 46216 | 585 | 0 | 58.6124279 | 82.04753149999998 | 2021-10-23 04:21:32 | Tomsk Oblast, Russia | |||
654251 | 654251 | 2021-10-22 | Russia | Tula Oblast | 58073 | 3305 | 0 | 53.9570701 | 37.369090899999996 | 2021-10-23 04:21:32 | Tula Oblast, Russia | |||
654252 | 654252 | 2021-10-22 | Russia | Tver Oblast | 73179 | 1789 | 0 | 57.1134475 | 35.174442799999994 | 2021-10-23 04:21:32 | Tver Oblast, Russia | |||
654253 | 654253 | 2021-10-22 | Russia | Tyumen Oblast | 67808 | 2231 | 0 | 58.8206488 | 70.36588370000001 | 2021-10-23 04:21:32 | Tyumen Oblast, Russia | |||
654254 | 654254 | 2021-10-22 | Russia | Tyva Republic | 27959 | 282 | 0 | 51.401714899999995 | 93.8582593 | 2021-10-23 04:21:32 | Tyva Republic, Russia | |||
654255 | 654255 | 2021-10-22 | Russia | Udmurt Republic | 60182 | 2416 | 0 | 57.1961165 | 52.69598320000001 | 2021-10-23 04:21:32 | Udmurt Republic, Russia | |||
654256 | 654256 | 2021-10-22 | Russia | Ulyanovsk Oblast | 90922 | 2874 | 0 | 54.146317700000004 | 47.2324921 | 2021-10-23 04:21:32 | Ulyanovsk Oblast, Russia | |||
654257 | 654257 | 2021-10-22 | Russia | Vladimir Oblast | 59973 | 2157 | 0 | 56.0503336 | 40.656163299999996 | 2021-10-23 04:21:32 | Vladimir Oblast, Russia | |||
654258 | 654258 | 2021-10-22 | Russia | Volgograd Oblast | 100271 | 3298 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-23 04:21:32 | Volgograd Oblast, Russia | |||
654259 | 654259 | 2021-10-22 | Russia | Vologda Oblast | 75148 | 2110 | 0 | 60.0391461 | 43.1215213 | 2021-10-23 04:21:32 | Vologda Oblast, Russia | |||
654260 | 654260 | 2021-10-22 | Russia | Voronezh Oblast | 147414 | 4773 | 0 | 50.9800393 | 40.15065070000001 | 2021-10-23 04:21:32 | Voronezh Oblast, Russia | |||
654261 | 654261 | 2021-10-22 | Russia | Yamalo-Nenets Autonomous Okrug | 52965 | 731 | 0 | 67.1471631 | 74.3415488 | 2021-10-23 04:21:32 | Yamalo-Nenets Autonomous Okrug, Russia | |||
654262 | 654262 | 2021-10-22 | Russia | Yaroslavl Oblast | 66562 | 1329 | 0 | 57.77819760000001 | 39.002109499999996 | 2021-10-23 04:21:32 | Yaroslavl Oblast, Russia | |||
654263 | 654263 | 2021-10-22 | Russia | Zabaykalsky Krai | 73943 | 1282 | 0 | 52.248521000000004 | 115.956325 | 2021-10-23 04:21:32 | Zabaykalsky Krai, Russia | |||
2123928 | 2123928 | 2021-10-21 | Russia | Adygea Republic | 20833 | 515 | 0 | 44.6939006 | 40.1520421 | 2021-10-22 04:21:14 | Adygea Republic, Russia | |||
2123929 | 2123929 | 2021-10-21 | Russia | Altai Krai | 84244 | 4674 | 0 | 52.693224300000004 | 82.69314240000001 | 2021-10-22 04:21:14 | Altai Krai, Russia | |||
2123930 | 2123930 | 2021-10-21 | Russia | Altai Republic | 22373 | 388 | 0 | 50.7114101 | 86.8572186 | 2021-10-22 04:21:14 | Altai Republic, Russia | |||
2123931 | 2123931 | 2021-10-21 | Russia | Amur Oblast | 38216 | 474 | 0 | 52.8032368 | 128.437295 | 2021-10-22 04:21:14 | Amur Oblast, Russia | |||
2123932 | 2123932 | 2021-10-21 | Russia | Arkhangelsk Oblast | 96276 | 1232 | 0 | 63.5589686 | 43.1221646 | 2021-10-22 04:21:14 | Arkhangelsk Oblast, Russia | |||
2123933 | 2123933 | 2021-10-21 | Russia | Astrakhan Oblast | 63787 | 1868 | 0 | 47.1878186 | 47.608851 | 2021-10-22 04:21:14 | Astrakhan Oblast, Russia | |||
2123934 | 2123934 | 2021-10-21 | Russia | Bashkortostan Republic | 79475 | 2268 | 0 | 54.8573563 | 57.1439682 | 2021-10-22 04:21:14 | Bashkortostan Republic, Russia | |||
2123935 | 2123935 | 2021-10-21 | Russia | Belgorod Oblast | 59118 | 1261 | 0 | 50.7080119 | 37.5837615 | 2021-10-22 04:21:14 | Belgorod Oblast, Russia | |||
2123936 | 2123936 | 2021-10-21 | Russia | Bryansk Oblast | 71805 | 1704 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-22 04:21:14 | Bryansk Oblast, Russia | |||
2123937 | 2123937 | 2021-10-21 | Russia | Buryatia Republic | 61368 | 1929 | 0 | 52.718242599999996 | 109.492143 | 2021-10-22 04:21:14 | Buryatia Republic, Russia | |||
2123938 | 2123938 | 2021-10-21 | Russia | Chechen Republic | 24167 | 673 | 0 | 43.39761470000001 | 45.6985005 | 2021-10-22 04:21:14 | Chechen Republic, Russia | |||
2123939 | 2123939 | 2021-10-21 | Russia | Chelyabinsk Oblast | 104500 | 3956 | 0 | 54.4223954 | 61.1865846 | 2021-10-22 04:21:14 | Chelyabinsk Oblast, Russia | |||
2123940 | 2123940 | 2021-10-21 | Russia | Chukotka Autonomous Okrug | 2199 | 19 | 0 | 66.0006475 | 169.4900869 | 2021-10-22 04:21:14 | Chukotka Autonomous Okrug, Russia | |||
2123941 | 2123941 | 2021-10-21 | Russia | Chuvashia Republic | 36233 | 2585 | 0 | 55.4259922 | 47.0849429 | 2021-10-22 04:21:14 | Chuvashia Republic, Russia | |||
2123942 | 2123942 | 2021-10-21 | Russia | Dagestan Republic | 54467 | 2684 | 0 | 43.05749160000001 | 47.1332224 | 2021-10-22 04:21:14 | Dagestan Republic, Russia | |||
2123943 | 2123943 | 2021-10-21 | Russia | Ingushetia Republic | 22901 | 353 | 0 | 43.11542075 | 45.01713552 | 2021-10-22 04:21:14 | Ingushetia Republic, Russia | |||
2123944 | 2123944 | 2021-10-21 | Russia | Irkutsk Oblast | 117282 | 5124 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-22 04:21:14 | Irkutsk Oblast, Russia |
Advanced export
JSON shape: default, array, newline-delimited
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]);