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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1370632 | 1370632 | 2022-09-21 | New Zealand | Niue | 80 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-22 04:22:56 | Niue, New Zealand | |||
1370633 | 1370633 | 2022-09-21 | New Zealand | 1769694 | 1972 | 0 | -40.9006 | 174.886 | 2022-09-22 04:22:56 | New Zealand | ||||
1370634 | 1370634 | 2022-09-21 | Nicaragua | 15021 | 245 | 0 | 12.865416 | -85.207229 | 2022-09-22 04:22:56 | Nicaragua | ||||
1370635 | 1370635 | 2022-09-21 | Niger | 9395 | 313 | 0 | 17.607789 | 8.081666 | 2022-09-22 04:22:56 | Niger | ||||
1370636 | 1370636 | 2022-09-21 | Nigeria | 265008 | 3155 | 0 | 9.082 | 8.6753 | 2022-09-22 04:22:56 | Nigeria | ||||
1370637 | 1370637 | 2022-09-21 | North Macedonia | 342413 | 9524 | 0 | 41.6086 | 21.7453 | 2022-09-22 04:22:56 | North Macedonia | ||||
1370638 | 1370638 | 2022-09-21 | Norway | 1461744 | 4065 | 0 | 60.472 | 8.4689 | 2022-09-22 04:22:56 | Norway | ||||
1370639 | 1370639 | 2022-09-21 | Oman | 397993 | 4628 | 0 | 21.512583 | 55.923255 | 2022-09-22 04:22:56 | Oman | ||||
1370640 | 1370640 | 2022-09-21 | Pakistan | Azad Jammu and Kashmir | 44312 | 793 | 0 | 34.027401 | 73.947253 | 2022-09-22 04:22:56 | Azad Jammu and Kashmir, Pakistan | |||
1370641 | 1370641 | 2022-09-21 | Pakistan | Balochistan | 35987 | 378 | 0 | 28.328492 | 65.898403 | 2022-09-22 04:22:56 | Balochistan, Pakistan | |||
1370642 | 1370642 | 2022-09-21 | Pakistan | Gilgit-Baltistan | 12056 | 191 | 0 | 35.792146 | 74.982138 | 2022-09-22 04:22:56 | Gilgit-Baltistan, Pakistan | |||
1370643 | 1370643 | 2022-09-21 | Pakistan | Islamabad | 139378 | 1031 | 0 | 33.665087 | 73.121219 | 2022-09-22 04:22:56 | Islamabad, Pakistan | |||
1370644 | 1370644 | 2022-09-21 | Pakistan | Khyber Pakhtunkhwa | 224136 | 6363 | 0 | 34.485332 | 72.09169 | 2022-09-22 04:22:56 | Khyber Pakhtunkhwa, Pakistan | |||
1370645 | 1370645 | 2022-09-21 | Pakistan | Punjab | 522006 | 13612 | 0 | 30.811346 | 72.139132 | 2022-09-22 04:22:56 | Punjab, Pakistan | |||
1370646 | 1370646 | 2022-09-21 | Pakistan | Sindh | 594019 | 8239 | 0 | 26.009446 | 68.776807 | 2022-09-22 04:22:56 | Sindh, Pakistan | |||
1370647 | 1370647 | 2022-09-21 | Palau | 5445 | 6 | 0 | 7.515 | 134.5825 | 2022-09-22 04:22:56 | Palau | ||||
1370648 | 1370648 | 2022-09-21 | Panama | 985814 | 8490 | 0 | 8.538 | -80.7821 | 2022-09-22 04:22:56 | Panama | ||||
1370649 | 1370649 | 2022-09-21 | Papua New Guinea | 44954 | 664 | 0 | -6.314993 | 143.95555 | 2022-09-22 04:22:56 | Papua New Guinea | ||||
1370650 | 1370650 | 2022-09-21 | Paraguay | 716009 | 19564 | 0 | -23.4425 | -58.4438 | 2022-09-22 04:22:56 | Paraguay | ||||
1370651 | 1370651 | 2022-09-21 | Peru | Amazonas | 49576 | 1371 | 0 | -5.077253 | -78.050172 | 2022-09-22 04:22:56 | Amazonas, Peru | |||
1370652 | 1370652 | 2022-09-21 | Peru | Ancash | 148234 | 7346 | 0 | -9.407125 | -77.671795 | 2022-09-22 04:22:56 | Ancash, Peru | |||
1370653 | 1370653 | 2022-09-21 | Peru | Apurimac | 44212 | 1673 | 0 | -14.027713 | -72.975378 | 2022-09-22 04:22:56 | Apurimac, Peru | |||
1370654 | 1370654 | 2022-09-21 | Peru | Arequipa | 268516 | 10588 | 0 | -15.843524 | -72.475539 | 2022-09-22 04:22:56 | Arequipa, Peru | |||
1370655 | 1370655 | 2022-09-21 | Peru | Ayacucho | 53503 | 2379 | 0 | -14.091648 | -74.08344 | 2022-09-22 04:22:56 | Ayacucho, Peru | |||
1370656 | 1370656 | 2022-09-21 | Peru | Cajamarca | 109034 | 4545 | 0 | -6.430284 | -78.745596 | 2022-09-22 04:22:56 | Cajamarca, Peru | |||
1370657 | 1370657 | 2022-09-21 | Peru | Callao | 159808 | 10614 | 0 | -11.954609 | -77.136042 | 2022-09-22 04:22:56 | Callao, Peru | |||
1370658 | 1370658 | 2022-09-21 | Peru | Cusco | 134963 | 5313 | 0 | -13.191068 | -72.153609 | 2022-09-22 04:22:56 | Cusco, Peru | |||
1370659 | 1370659 | 2022-09-21 | Peru | Huancavelica | 28776 | 1308 | 0 | -13.023888 | -75.00277 | 2022-09-22 04:22:56 | Huancavelica, Peru | |||
1370660 | 1370660 | 2022-09-21 | Peru | Huanuco | 58024 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-22 04:22:56 | Huanuco, Peru | |||
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 |
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]);