johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1370661 | 1370661 | 2022-09-21 | Peru | Ica | 117456 | 9038 | 0 | -14.235097 | -75.574821 | 2022-09-22 04:22:56 | Ica, Peru | |||
1370662 | 1370662 | 2022-09-21 | Peru | Junin | 146167 | 7629 | 0 | -11.541783 | -74.876968 | 2022-09-22 04:22:56 | Junin, Peru | |||
1370663 | 1370663 | 2022-09-21 | Peru | La Libertad | 168701 | 11020 | 0 | -7.92139 | -78.370238 | 2022-09-22 04:22:56 | La Libertad, Peru | |||
1370664 | 1370664 | 2022-09-21 | Peru | Lambayeque | 119648 | 9329 | 0 | -6.353049 | -79.824113 | 2022-09-22 04:22:56 | Lambayeque, Peru | |||
1370665 | 1370665 | 2022-09-21 | Peru | Lima | 1907438 | 94523 | 0 | -11.766533 | -76.604498 | 2022-09-22 04:22:56 | Lima, Peru | |||
1370666 | 1370666 | 2022-09-21 | Peru | Loreto | 62626 | 4422 | 0 | -4.124847 | -74.424115 | 2022-09-22 04:22:56 | Loreto, Peru | |||
1370667 | 1370667 | 2022-09-21 | Peru | Madre de Dios | 20377 | 878 | 0 | -11.972699 | -70.53172 | 2022-09-22 04:22:56 | Madre de Dios, Peru | |||
1370668 | 1370668 | 2022-09-21 | Peru | Moquegua | 59210 | 1679 | 0 | -16.860271 | -70.839046 | 2022-09-22 04:22:56 | Moquegua, Peru | |||
1370669 | 1370669 | 2022-09-21 | Peru | Pasco | 27233 | 1135 | 0 | -10.39655 | -75.307635 | 2022-09-22 04:22:56 | Pasco, Peru | |||
1370670 | 1370670 | 2022-09-21 | Peru | Piura | 172846 | 13232 | 0 | -5.133361 | -80.335861 | 2022-09-22 04:22:56 | Piura, Peru | |||
1370671 | 1370671 | 2022-09-21 | Peru | Puno | 74259 | 4928 | 0 | -14.995827 | -69.922726 | 2022-09-22 04:22:56 | Puno, Peru | |||
1370672 | 1370672 | 2022-09-21 | Peru | San Martin | 67116 | 3208 | 0 | -7.039531 | -76.729127 | 2022-09-22 04:22:56 | San Martin, Peru | |||
1370673 | 1370673 | 2022-09-21 | Peru | Tacna | 60430 | 2181 | 0 | -17.644161 | -70.27756 | 2022-09-22 04:22:56 | Tacna, Peru | |||
1370674 | 1370674 | 2022-09-21 | Peru | Tumbes | 31509 | 1722 | 0 | -3.857496 | -80.545255 | 2022-09-22 04:22:56 | Tumbes, Peru | |||
1370675 | 1370675 | 2022-09-21 | Peru | Ucayali | 43015 | 3294 | 0 | -9.621718 | -73.444929 | 2022-09-22 04:22:56 | Ucayali, Peru | |||
1370676 | 1370676 | 2022-09-21 | Peru | Unknown | 4637 | 97 | 0 | 2022-09-22 04:22:56 | Unknown, Peru | |||||
1370677 | 1370677 | 2022-09-21 | Philippines | 3927120 | 62657 | 0 | 12.879721 | 121.774017 | 2022-09-22 04:22:56 | Philippines | ||||
1370678 | 1370678 | 2022-09-21 | Poland | 6258678 | 117391 | 0 | 51.9194 | 19.1451 | 2022-09-22 04:22:56 | Poland | ||||
1370679 | 1370679 | 2022-09-21 | Portugal | 5469808 | 24972 | 0 | 39.3999 | -8.2245 | 2022-09-22 04:22:56 | Portugal | ||||
1370680 | 1370680 | 2022-09-21 | Qatar | 444174 | 682 | 0 | 25.3548 | 51.1839 | 2022-09-22 04:22:56 | Qatar | ||||
1370681 | 1370681 | 2022-09-21 | Romania | 3257997 | 66950 | 0 | 45.9432 | 24.9668 | 2022-09-22 04:22:56 | Romania | ||||
1370682 | 1370682 | 2022-09-21 | Russia | Adygea Republic | 52444 | 1009 | 0 | 44.6939006 | 40.1520421 | 2022-09-22 04:22:56 | Adygea Republic, Russia | |||
1370683 | 1370683 | 2022-09-21 | Russia | Altai Krai | 295392 | 8751 | 0 | 52.6932243 | 82.6931424 | 2022-09-22 04:22:56 | Altai Krai, Russia | |||
1370684 | 1370684 | 2022-09-21 | Russia | Altai Republic | 39026 | 626 | 0 | 50.7114101 | 86.8572186 | 2022-09-22 04:22:56 | Altai Republic, Russia | |||
1370685 | 1370685 | 2022-09-21 | Russia | Amur Oblast | 119871 | 765 | 0 | 52.8032368 | 128.437295 | 2022-09-22 04:22:56 | Amur Oblast, Russia | |||
1370686 | 1370686 | 2022-09-21 | Russia | Arkhangelsk Oblast | 257138 | 1774 | 0 | 63.5589686 | 43.1221646 | 2022-09-22 04:22:56 | Arkhangelsk Oblast, Russia | |||
1370687 | 1370687 | 2022-09-21 | Russia | Astrakhan Oblast | 130054 | 3083 | 0 | 47.1878186 | 47.608851 | 2022-09-22 04:22:56 | Astrakhan Oblast, Russia | |||
1370688 | 1370688 | 2022-09-21 | Russia | Bashkortostan Republic | 310548 | 5816 | 0 | 54.8573563 | 57.1439682 | 2022-09-22 04:22:56 | Bashkortostan Republic, Russia | |||
1370689 | 1370689 | 2022-09-21 | Russia | Belgorod Oblast | 150032 | 2287 | 0 | 50.7080119 | 37.5837615 | 2022-09-22 04:22:56 | Belgorod Oblast, Russia | |||
1370690 | 1370690 | 2022-09-21 | Russia | Bryansk Oblast | 177946 | 4071 | 0 | 52.8873315 | 33.415853 | 2022-09-22 04:22:56 | Bryansk Oblast, Russia | |||
1370691 | 1370691 | 2022-09-21 | Russia | Buryatia Republic | 149764 | 3066 | 0 | 52.7182426 | 109.492143 | 2022-09-22 04:22:56 | Buryatia Republic, Russia | |||
1370692 | 1370692 | 2022-09-21 | Russia | Chechen Republic | 46044 | 1076 | 0 | 43.3976147 | 45.6985005 | 2022-09-22 04:22:56 | Chechen Republic, Russia | |||
1370693 | 1370693 | 2022-09-21 | Russia | Chelyabinsk Oblast | 363478 | 7903 | 0 | 54.4223954 | 61.1865846 | 2022-09-22 04:22:56 | Chelyabinsk Oblast, Russia | |||
1370694 | 1370694 | 2022-09-21 | Russia | Chukotka Autonomous Okrug | 6428 | 44 | 0 | 66.0006475 | 169.4900869 | 2022-09-22 04:22:56 | Chukotka Autonomous Okrug, Russia | |||
1370695 | 1370695 | 2022-09-21 | Russia | Chuvashia Republic | 97257 | 4671 | 0 | 55.4259922 | 47.0849429 | 2022-09-22 04:22:56 | Chuvashia Republic, Russia | |||
1370696 | 1370696 | 2022-09-21 | Russia | Dagestan Republic | 100735 | 3608 | 0 | 43.0574916 | 47.1332224 | 2022-09-22 04:22:56 | Dagestan Republic, Russia | |||
1370697 | 1370697 | 2022-09-21 | Russia | Ingushetia Republic | 42558 | 550 | 0 | 43.11542075 | 45.01713552 | 2022-09-22 04:22:56 | Ingushetia Republic, Russia | |||
1370698 | 1370698 | 2022-09-21 | Russia | Irkutsk Oblast | 336366 | 8542 | 0 | 56.6370122 | 104.719221 | 2022-09-22 04:22:56 | Irkutsk Oblast, Russia | |||
1370699 | 1370699 | 2022-09-21 | Russia | Ivanovo Oblast | 121381 | 3163 | 0 | 56.9167446 | 41.4352137 | 2022-09-22 04:22:56 | Ivanovo Oblast, Russia | |||
1370700 | 1370700 | 2022-09-21 | Russia | Jewish Autonomous Okrug | 21411 | 559 | 0 | 48.57527615 | 132.6630746 | 2022-09-22 04:22:56 | Jewish Autonomous Okrug, Russia | |||
1370701 | 1370701 | 2022-09-21 | Russia | Kabardino-Balkarian Republic | 70687 | 1900 | 0 | 43.4806048 | 43.5978976 | 2022-09-22 04:22:56 | Kabardino-Balkarian Republic, Russia | |||
1370702 | 1370702 | 2022-09-21 | Russia | Kaliningrad Oblast | 183532 | 1964 | 0 | 54.7293041 | 21.1489473 | 2022-09-22 04:22:56 | Kaliningrad Oblast, Russia | |||
1370703 | 1370703 | 2022-09-21 | Russia | Kalmykia Republic | 57622 | 843 | 0 | 46.2313018 | 45.3275745 | 2022-09-22 04:22:56 | Kalmykia Republic, Russia | |||
1370704 | 1370704 | 2022-09-21 | Russia | Kaluga Oblast | 115845 | 1453 | 0 | 54.4382773 | 35.5272854 | 2022-09-22 04:22:56 | Kaluga Oblast, Russia | |||
1370705 | 1370705 | 2022-09-21 | Russia | Kamchatka Krai | 43254 | 623 | 0 | 57.1914882 | 160.0383819 | 2022-09-22 04:22:56 | Kamchatka Krai, Russia | |||
1370706 | 1370706 | 2022-09-21 | Russia | Karachay-Cherkess Republic | 49221 | 984 | 0 | 43.7368326 | 41.7267991 | 2022-09-22 04:22:56 | Karachay-Cherkess Republic, Russia | |||
1370707 | 1370707 | 2022-09-21 | Russia | Karelia Republic | 151158 | 1525 | 0 | 62.6194031 | 33.4920267 | 2022-09-22 04:22:56 | Karelia Republic, Russia | |||
1370708 | 1370708 | 2022-09-21 | Russia | Kemerovo Oblast | 198132 | 2630 | 0 | 54.5335781 | 87.342861 | 2022-09-22 04:22:56 | Kemerovo Oblast, Russia | |||
1370709 | 1370709 | 2022-09-21 | Russia | Khabarovsk Krai | 217604 | 1561 | 0 | 51.6312684 | 136.121524 | 2022-09-22 04:22:56 | Khabarovsk Krai, Russia | |||
1370710 | 1370710 | 2022-09-21 | Russia | Khakassia Republic | 98394 | 2416 | 0 | 53.72258845 | 91.44293627 | 2022-09-22 04:22:56 | Khakassia Republic, Russia | |||
1370711 | 1370711 | 2022-09-21 | Russia | Khanty-Mansi Autonomous Okrug | 237840 | 2566 | 0 | 61.0259025 | 69.0982628 | 2022-09-22 04:22:56 | Khanty-Mansi Autonomous Okrug, Russia | |||
1370712 | 1370712 | 2022-09-21 | Russia | Kirov Oblast | 158392 | 1067 | 0 | 57.9665589 | 49.4074599 | 2022-09-22 04:22:56 | Kirov Oblast, Russia | |||
1370713 | 1370713 | 2022-09-21 | Russia | Komi Republic | 182129 | 3211 | 0 | 63.9881421 | 54.3326073 | 2022-09-22 04:22:56 | Komi Republic, Russia | |||
1370714 | 1370714 | 2022-09-21 | Russia | Kostroma Oblast | 96684 | 1415 | 0 | 58.424756 | 44.2533273 | 2022-09-22 04:22:56 | Kostroma Oblast, Russia | |||
1370715 | 1370715 | 2022-09-21 | Russia | Krasnodar Krai | 324036 | 11029 | 0 | 45.7684014 | 39.0261044 | 2022-09-22 04:22:56 | Krasnodar Krai, Russia | |||
1370716 | 1370716 | 2022-09-21 | Russia | Krasnoyarsk Krai | 409640 | 11015 | 0 | 63.3233807 | 97.0979974 | 2022-09-22 04:22:56 | Krasnoyarsk Krai, Russia | |||
1370717 | 1370717 | 2022-09-21 | Russia | Kurgan Oblast | 114323 | 1456 | 0 | 55.7655302 | 64.5632681 | 2022-09-22 04:22:56 | Kurgan Oblast, Russia | |||
1370718 | 1370718 | 2022-09-21 | Russia | Kursk Oblast | 137734 | 2508 | 0 | 51.6568453 | 36.4852695 | 2022-09-22 04:22:56 | Kursk Oblast, Russia | |||
1370719 | 1370719 | 2022-09-21 | Russia | Leningrad Oblast | 225010 | 3497 | 0 | 60.1853296 | 32.3925325 | 2022-09-22 04:22:56 | Leningrad Oblast, Russia | |||
1370720 | 1370720 | 2022-09-21 | Russia | Lipetsk Oblast | 167901 | 3845 | 0 | 52.6935178 | 39.1122664 | 2022-09-22 04:22:56 | Lipetsk Oblast, Russia | |||
1370721 | 1370721 | 2022-09-21 | Russia | Magadan Oblast | 20910 | 390 | 0 | 62.48858785 | 153.9903764 | 2022-09-22 04:22:56 | Magadan Oblast, Russia | |||
1370722 | 1370722 | 2022-09-21 | Russia | Mari El Republic | 47071 | 1087 | 0 | 56.5767504 | 47.8817512 | 2022-09-22 04:22:56 | Mari El Republic, Russia | |||
1370723 | 1370723 | 2022-09-21 | Russia | Mordovia Republic | 77343 | 1395 | 0 | 54.4419829 | 44.4661144 | 2022-09-22 04:22:56 | Mordovia Republic, Russia | |||
1370724 | 1370724 | 2022-09-21 | Russia | Moscow | 3161996 | 45776 | 0 | 55.7504461 | 37.6174943 | 2022-09-22 04:22:56 | Moscow, Russia | |||
1370725 | 1370725 | 2022-09-21 | Russia | Moscow Oblast | 1094539 | 15335 | 0 | 55.5043158 | 38.0353929 | 2022-09-22 04:22:56 | Moscow Oblast, Russia | |||
1370726 | 1370726 | 2022-09-21 | Russia | Murmansk Oblast | 140591 | 3359 | 0 | 68.0000418 | 33.9999151 | 2022-09-22 04:22:56 | Murmansk Oblast, Russia | |||
1370727 | 1370727 | 2022-09-21 | Russia | Nenets Autonomous Okrug | 7940 | 101 | 0 | 68.27557185 | 57.1686375 | 2022-09-22 04:22:56 | Nenets Autonomous Okrug, Russia | |||
1370728 | 1370728 | 2022-09-21 | Russia | Nizhny Novgorod Oblast | 472433 | 11668 | 0 | 55.4718033 | 44.0911594 | 2022-09-22 04:22:56 | Nizhny Novgorod Oblast, Russia | |||
1370729 | 1370729 | 2022-09-21 | Russia | North Ossetia - Alania Republic | 44090 | 1258 | 0 | 42.7933611 | 44.6324493 | 2022-09-22 04:22:56 | North Ossetia - Alania Republic, Russia | |||
1370730 | 1370730 | 2022-09-21 | Russia | Novgorod Oblast | 111521 | 1039 | 0 | 58.2843833 | 32.5169757 | 2022-09-22 04:22:56 | Novgorod Oblast, Russia | |||
1370731 | 1370731 | 2022-09-21 | Russia | Novosibirsk Oblast | 288575 | 5713 | 0 | 54.9720169 | 79.4813924 | 2022-09-22 04:22:56 | Novosibirsk Oblast, Russia | |||
1370732 | 1370732 | 2022-09-21 | Russia | Omsk Oblast | 223128 | 4469 | 0 | 56.0935263 | 73.5099936 | 2022-09-22 04:22:56 | Omsk Oblast, Russia | |||
1370733 | 1370733 | 2022-09-21 | Russia | Orel Oblast | 126417 | 1948 | 0 | 52.9685433 | 36.0692477 | 2022-09-22 04:22:56 | Orel Oblast, Russia | |||
1370734 | 1370734 | 2022-09-21 | Russia | Orenburg Oblast | 233580 | 4028 | 0 | 52.0269262 | 54.7276647 | 2022-09-22 04:22:56 | Orenburg Oblast, Russia | |||
1370735 | 1370735 | 2022-09-21 | Russia | Penza Oblast | 205199 | 6059 | 0 | 53.1655415 | 44.7879181 | 2022-09-22 04:22:56 | Penza Oblast, Russia | |||
1370736 | 1370736 | 2022-09-21 | Russia | Perm Krai | 418291 | 8905 | 0 | 58.5951603 | 56.3159546 | 2022-09-22 04:22:56 | Perm Krai, Russia | |||
1370737 | 1370737 | 2022-09-21 | Russia | Primorsky Krai | 200283 | 1966 | 0 | 45.0819456 | 134.726645 | 2022-09-22 04:22:56 | Primorsky Krai, Russia | |||
1370738 | 1370738 | 2022-09-21 | Russia | Pskov Oblast | 120892 | 1908 | 0 | 57.5358729 | 28.8586826 | 2022-09-22 04:22:56 | Pskov Oblast, Russia | |||
1370739 | 1370739 | 2022-09-21 | Russia | Rostov Oblast | 424923 | 11006 | 0 | 47.6222451 | 40.7957942 | 2022-09-22 04:22:56 | Rostov Oblast, Russia | |||
1370740 | 1370740 | 2022-09-21 | Russia | Ryazan Oblast | 141605 | 3435 | 0 | 54.4226732 | 40.5705246 | 2022-09-22 04:22:56 | Ryazan Oblast, Russia | |||
1370741 | 1370741 | 2022-09-21 | Russia | Saint Petersburg | 1731634 | 35101 | 0 | 59.9606739 | 30.1586551 | 2022-09-22 04:22:56 | Saint Petersburg, Russia | |||
1370742 | 1370742 | 2022-09-21 | Russia | Sakha (Yakutiya) Republic | 207479 | 2131 | 0 | 66.941626 | 129.642371 | 2022-09-22 04:22:56 | Sakha (Yakutiya) Republic, Russia | |||
1370743 | 1370743 | 2022-09-21 | Russia | Sakhalin Oblast | 67291 | 829 | 0 | 49.7219665 | 143.448533 | 2022-09-22 04:22:56 | Sakhalin Oblast, Russia | |||
1370744 | 1370744 | 2022-09-21 | Russia | Samara Oblast | 443804 | 8008 | 0 | 53.2128813 | 50.8914633 | 2022-09-22 04:22:56 | Samara Oblast, Russia | |||
1370745 | 1370745 | 2022-09-21 | Russia | Saratov Oblast | 279745 | 6001 | 0 | 51.6520555 | 46.8631952 | 2022-09-22 04:22:56 | Saratov Oblast, Russia | |||
1370746 | 1370746 | 2022-09-21 | Russia | Smolensk Oblast | 141462 | 3103 | 0 | 55.0343496 | 33.0192065 | 2022-09-22 04:22:56 | Smolensk Oblast, Russia | |||
1370747 | 1370747 | 2022-09-21 | Russia | Stavropol Krai | 229520 | 7104 | 0 | 44.8632577 | 43.4406913 | 2022-09-22 04:22:56 | Stavropol Krai, Russia | |||
1370748 | 1370748 | 2022-09-21 | Russia | Sverdlovsk Oblast | 503506 | 10816 | 0 | 58.6414755 | 61.8021546 | 2022-09-22 04:22:56 | Sverdlovsk Oblast, Russia | |||
1370749 | 1370749 | 2022-09-21 | Russia | Tambov Oblast | 130671 | 2473 | 0 | 52.9019574 | 41.3578918 | 2022-09-22 04:22:56 | Tambov Oblast, Russia | |||
1370750 | 1370750 | 2022-09-21 | Russia | Tatarstan Republic | 173394 | 2004 | 0 | 55.7648572 | 52.43104273 | 2022-09-22 04:22:56 | Tatarstan Republic, Russia | |||
1370751 | 1370751 | 2022-09-21 | Russia | Tomsk Oblast | 146895 | 896 | 0 | 58.6124279 | 82.0475315 | 2022-09-22 04:22:56 | Tomsk Oblast, Russia | |||
1370752 | 1370752 | 2022-09-21 | Russia | Tula Oblast | 179447 | 5299 | 0 | 53.9570701 | 37.3690909 | 2022-09-22 04:22:56 | Tula Oblast, Russia | |||
1370753 | 1370753 | 2022-09-21 | Russia | Tver Oblast | 174745 | 2765 | 0 | 57.1134475 | 35.1744428 | 2022-09-22 04:22:56 | Tver Oblast, Russia | |||
1370754 | 1370754 | 2022-09-21 | Russia | Tyumen Oblast | 230184 | 4346 | 0 | 58.8206488 | 70.3658837 | 2022-09-22 04:22:56 | Tyumen Oblast, Russia | |||
1370755 | 1370755 | 2022-09-21 | Russia | Tyva Republic | 51948 | 356 | 0 | 51.4017149 | 93.8582593 | 2022-09-22 04:22:56 | Tyva Republic, Russia | |||
1370756 | 1370756 | 2022-09-21 | Russia | Udmurt Republic | 196397 | 3875 | 0 | 57.1961165 | 52.6959832 | 2022-09-22 04:22:56 | Udmurt Republic, Russia | |||
1370757 | 1370757 | 2022-09-21 | Russia | Ulyanovsk Oblast | 218533 | 4750 | 0 | 54.1463177 | 47.2324921 | 2022-09-22 04:22:56 | Ulyanovsk Oblast, Russia | |||
1370758 | 1370758 | 2022-09-21 | Russia | Vladimir Oblast | 165646 | 3522 | 0 | 56.0503336 | 40.6561633 | 2022-09-22 04:22:56 | Vladimir Oblast, Russia | |||
1370759 | 1370759 | 2022-09-21 | Russia | Volgograd Oblast | 252540 | 6904 | 0 | 49.6048339 | 44.2903582 | 2022-09-22 04:22:56 | Volgograd Oblast, Russia | |||
1370760 | 1370760 | 2022-09-21 | Russia | Vologda Oblast | 205651 | 3883 | 0 | 60.0391461 | 43.1215213 | 2022-09-22 04:22:56 | Vologda 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]);