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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
459531 | 459531 | 2022-02-02 | Panama | 705880 | 7752 | 0 | 8.538 | -80.7821 | 2022-02-03 04:21:21 | Panama | ||||
459532 | 459532 | 2022-02-02 | Papua New Guinea | 37390 | 597 | 0 | -6.314993 | 143.95555 | 2022-02-03 04:21:21 | Papua New Guinea | ||||
459533 | 459533 | 2022-02-02 | Paraguay | 594430 | 17426 | 0 | -23.4425 | -58.4438 | 2022-02-03 04:21:21 | Paraguay | ||||
459534 | 459534 | 2022-02-02 | Peru | Amazonas | 36021 | 1295 | 0 | -5.077253 | -78.050172 | 2022-02-03 04:21:21 | Amazonas, Peru | |||
459535 | 459535 | 2022-02-02 | Peru | Ancash | 98814 | 6821 | 0 | -9.407125 | -77.67179499999997 | 2022-02-03 04:21:21 | Ancash, Peru | |||
459536 | 459536 | 2022-02-02 | Peru | Apurimac | 29930 | 1542 | 0 | -14.027713 | -72.975378 | 2022-02-03 04:21:21 | Apurimac, Peru | |||
459537 | 459537 | 2022-02-02 | Peru | Arequipa | 150382 | 9808 | 0 | -15.843523999999999 | -72.475539 | 2022-02-03 04:21:21 | Arequipa, Peru | |||
459538 | 459538 | 2022-02-02 | Peru | Ayacucho | 40217 | 2184 | 0 | -14.091648000000001 | -74.08344 | 2022-02-03 04:21:21 | Ayacucho, Peru | |||
459539 | 459539 | 2022-02-02 | Peru | Cajamarca | 80452 | 4226 | 0 | -6.4302839999999994 | -78.74559599999998 | 2022-02-03 04:21:21 | Cajamarca, Peru | |||
459540 | 459540 | 2022-02-02 | Peru | Callao | 125469 | 10198 | 0 | -11.954609 | -77.136042 | 2022-02-03 04:21:21 | Callao, Peru | |||
459541 | 459541 | 2022-02-02 | Peru | Cusco | 97850 | 4883 | 0 | -13.191068 | -72.153609 | 2022-02-03 04:21:21 | Cusco, Peru | |||
459542 | 459542 | 2022-02-02 | Peru | Huancavelica | 18983 | 1194 | 0 | -13.023888000000001 | -75.00277 | 2022-02-03 04:21:21 | Huancavelica, Peru | |||
459543 | 459543 | 2022-02-02 | Peru | Huanuco | 42775 | 2746 | 0 | -9.421676 | -76.040642 | 2022-02-03 04:21:21 | Huanuco, Peru | |||
459544 | 459544 | 2022-02-02 | Peru | Ica | 75935 | 8655 | 0 | -14.235097 | -75.574821 | 2022-02-03 04:21:21 | Ica, Peru | |||
459545 | 459545 | 2022-02-02 | Peru | Junin | 103914 | 7150 | 0 | -11.541783 | -74.876968 | 2022-02-03 04:21:21 | Junin, Peru | |||
459546 | 459546 | 2022-02-02 | Peru | La Libertad | 114470 | 10483 | 0 | -7.92139 | -78.370238 | 2022-02-03 04:21:21 | La Libertad, Peru | |||
459547 | 459547 | 2022-02-02 | Peru | Lambayeque | 84124 | 8770 | 0 | -6.3530489999999995 | -79.824113 | 2022-02-03 04:21:21 | Lambayeque, Peru | |||
459548 | 459548 | 2022-02-02 | Peru | Lima | 1295823 | 90230 | 0 | -11.766533 | -76.60449799999998 | 2022-02-03 04:21:21 | Lima, Peru | |||
459549 | 459549 | 2022-02-02 | Peru | Loreto | 49581 | 4292 | 0 | -4.124847 | -74.424115 | 2022-02-03 04:21:21 | Loreto, Peru | |||
459550 | 459550 | 2022-02-02 | Peru | Madre de Dios | 15358 | 789 | 0 | -11.972699 | -70.53171999999998 | 2022-02-03 04:21:21 | Madre de Dios, Peru | |||
459551 | 459551 | 2022-02-02 | Peru | Moquegua | 35737 | 1548 | 0 | -16.860271 | -70.839046 | 2022-02-03 04:21:21 | Moquegua, Peru | |||
459552 | 459552 | 2022-02-02 | Peru | Pasco | 18772 | 1057 | 0 | -10.39655 | -75.307635 | 2022-02-03 04:21:21 | Pasco, Peru | |||
459553 | 459553 | 2022-02-02 | Peru | Piura | 116622 | 12387 | 0 | -5.133361 | -80.335861 | 2022-02-03 04:21:21 | Piura, Peru | |||
459554 | 459554 | 2022-02-02 | Peru | Puno | 51508 | 4323 | 0 | -14.995826999999998 | -69.922726 | 2022-02-03 04:21:21 | Puno, Peru | |||
459555 | 459555 | 2022-02-02 | Peru | San Martin | 54281 | 3052 | 0 | -7.039531 | -76.729127 | 2022-02-03 04:21:21 | San Martin, Peru | |||
459556 | 459556 | 2022-02-02 | Peru | Tacna | 39814 | 1998 | 0 | -17.644160999999997 | -70.27756 | 2022-02-03 04:21:21 | Tacna, Peru | |||
459557 | 459557 | 2022-02-02 | Peru | Tumbes | 20592 | 1607 | 0 | -3.857496 | -80.54525500000003 | 2022-02-03 04:21:21 | Tumbes, Peru | |||
459558 | 459558 | 2022-02-02 | Peru | Ucayali | 34228 | 3085 | 0 | -9.621718 | -73.444929 | 2022-02-03 04:21:21 | Ucayali, Peru | |||
459559 | 459559 | 2022-02-02 | Peru | Unknown | 454499 | 1897 | 0 | 2022-02-03 04:21:21 | Unknown, Peru | |||||
459560 | 459560 | 2022-02-02 | Philippines | 3577298 | 54097 | 0 | 12.879721 | 121.77401699999999 | 2022-02-03 04:21:21 | Philippines | ||||
459561 | 459561 | 2022-02-02 | Poland | 4981321 | 105753 | 0 | 51.9194 | 19.1451 | 2022-02-03 04:21:21 | Poland | ||||
459562 | 459562 | 2022-02-02 | Portugal | 2771842 | 20024 | 0 | 39.3999 | -8.2245 | 2022-02-03 04:21:21 | Portugal | ||||
459563 | 459563 | 2022-02-02 | Qatar | 341628 | 649 | 0 | 25.3548 | 51.1839 | 2022-02-03 04:21:21 | Qatar | ||||
459564 | 459564 | 2022-02-02 | Romania | 2292345 | 60242 | 0 | 45.9432 | 24.9668 | 2022-02-03 04:21:21 | Romania | ||||
459565 | 459565 | 2022-02-02 | Russia | Adygea Republic | 30729 | 825 | 0 | 44.6939006 | 40.1520421 | 2022-02-03 04:21:21 | Adygea Republic, Russia | |||
459566 | 459566 | 2022-02-02 | Russia | Altai Krai | 136096 | 7397 | 0 | 52.693224300000004 | 82.69314240000001 | 2022-02-03 04:21:21 | Altai Krai, Russia | |||
459567 | 459567 | 2022-02-02 | Russia | Altai Republic | 26882 | 561 | 0 | 50.7114101 | 86.8572186 | 2022-02-03 04:21:21 | Altai Republic, Russia | |||
459568 | 459568 | 2022-02-02 | Russia | Amur Oblast | 59692 | 678 | 0 | 52.8032368 | 128.437295 | 2022-02-03 04:21:21 | Amur Oblast, Russia | |||
459569 | 459569 | 2022-02-02 | Russia | Arkhangelsk Oblast | 144036 | 1562 | 0 | 63.5589686 | 43.1221646 | 2022-02-03 04:21:21 | Arkhangelsk Oblast, Russia | |||
459570 | 459570 | 2022-02-02 | Russia | Astrakhan Oblast | 90084 | 2673 | 0 | 47.1878186 | 47.608851 | 2022-02-03 04:21:21 | Astrakhan Oblast, Russia | |||
459571 | 459571 | 2022-02-02 | Russia | Bashkortostan Republic | 134265 | 4784 | 0 | 54.8573563 | 57.1439682 | 2022-02-03 04:21:21 | Bashkortostan Republic, Russia | |||
459572 | 459572 | 2022-02-02 | Russia | Belgorod Oblast | 88601 | 1934 | 0 | 50.7080119 | 37.5837615 | 2022-02-03 04:21:21 | Belgorod Oblast, Russia | |||
459573 | 459573 | 2022-02-02 | Russia | Bryansk Oblast | 106728 | 3275 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-02-03 04:21:21 | Bryansk Oblast, Russia | |||
459574 | 459574 | 2022-02-02 | Russia | Buryatia Republic | 89783 | 2614 | 0 | 52.718242599999996 | 109.492143 | 2022-02-03 04:21:21 | Buryatia Republic, Russia | |||
459575 | 459575 | 2022-02-02 | Russia | Chechen Republic | 36009 | 1010 | 0 | 43.39761470000001 | 45.6985005 | 2022-02-03 04:21:21 | Chechen Republic, Russia | |||
459576 | 459576 | 2022-02-02 | Russia | Chelyabinsk Oblast | 170858 | 6504 | 0 | 54.4223954 | 61.1865846 | 2022-02-03 04:21:21 | Chelyabinsk Oblast, Russia | |||
459577 | 459577 | 2022-02-02 | Russia | Chukotka Autonomous Okrug | 3129 | 40 | 0 | 66.0006475 | 169.4900869 | 2022-02-03 04:21:21 | Chukotka Autonomous Okrug, Russia | |||
459578 | 459578 | 2022-02-02 | Russia | Chuvashia Republic | 53579 | 4210 | 0 | 55.4259922 | 47.0849429 | 2022-02-03 04:21:21 | Chuvashia Republic, Russia | |||
459579 | 459579 | 2022-02-02 | Russia | Dagestan Republic | 73922 | 3333 | 0 | 43.05749160000001 | 47.1332224 | 2022-02-03 04:21:21 | Dagestan Republic, Russia | |||
459580 | 459580 | 2022-02-02 | Russia | Ingushetia Republic | 32038 | 509 | 0 | 43.11542075 | 45.01713552 | 2022-02-03 04:21:21 | Ingushetia Republic, Russia | |||
459581 | 459581 | 2022-02-02 | Russia | Irkutsk Oblast | 172461 | 7454 | 0 | 56.6370122 | 104.71922099999999 | 2022-02-03 04:21:21 | Irkutsk Oblast, Russia | |||
459582 | 459582 | 2022-02-02 | Russia | Ivanovo Oblast | 73026 | 2712 | 0 | 56.9167446 | 41.43521370000001 | 2022-02-03 04:21:21 | Ivanovo Oblast, Russia | |||
459583 | 459583 | 2022-02-02 | Russia | Jewish Autonomous Okrug | 12308 | 454 | 0 | 48.57527615 | 132.66307460000002 | 2022-02-03 04:21:21 | Jewish Autonomous Okrug, Russia | |||
459584 | 459584 | 2022-02-02 | Russia | Kabardino-Balkarian Republic | 45998 | 1582 | 0 | 43.480604799999995 | 43.5978976 | 2022-02-03 04:21:21 | Kabardino-Balkarian Republic, Russia | |||
459585 | 459585 | 2022-02-02 | Russia | Kaliningrad Oblast | 95464 | 1464 | 0 | 54.7293041 | 21.1489473 | 2022-02-03 04:21:21 | Kaliningrad Oblast, Russia | |||
459586 | 459586 | 2022-02-02 | Russia | Kalmykia Republic | 38389 | 781 | 0 | 46.2313018 | 45.3275745 | 2022-02-03 04:21:21 | Kalmykia Republic, Russia | |||
459587 | 459587 | 2022-02-02 | Russia | Kaluga Oblast | 72357 | 1297 | 0 | 54.438277299999996 | 35.5272854 | 2022-02-03 04:21:21 | Kaluga Oblast, Russia | |||
459588 | 459588 | 2022-02-02 | Russia | Kamchatka Krai | 26454 | 542 | 0 | 57.191488199999995 | 160.03838190000005 | 2022-02-03 04:21:21 | Kamchatka Krai, Russia | |||
459589 | 459589 | 2022-02-02 | Russia | Karachay-Cherkess Republic | 35307 | 938 | 0 | 43.7368326 | 41.7267991 | 2022-02-03 04:21:21 | Karachay-Cherkess Republic, Russia | |||
459590 | 459590 | 2022-02-02 | Russia | Karelia Republic | 99719 | 1323 | 0 | 62.61940309999999 | 33.4920267 | 2022-02-03 04:21:21 | Karelia Republic, Russia | |||
459591 | 459591 | 2022-02-02 | Russia | Kemerovo Oblast | 96552 | 1919 | 0 | 54.53357809999999 | 87.342861 | 2022-02-03 04:21:21 | Kemerovo Oblast, Russia | |||
459592 | 459592 | 2022-02-02 | Russia | Khabarovsk Krai | 135519 | 1346 | 0 | 51.6312684 | 136.121524 | 2022-02-03 04:21:21 | Khabarovsk Krai, Russia | |||
459593 | 459593 | 2022-02-02 | Russia | Khakassia Republic | 60312 | 2137 | 0 | 53.72258845 | 91.44293627 | 2022-02-03 04:21:21 | Khakassia Republic, Russia | |||
459594 | 459594 | 2022-02-02 | Russia | Khanty-Mansi Autonomous Okrug | 124440 | 2179 | 0 | 61.0259025 | 69.0982628 | 2022-02-03 04:21:21 | Khanty-Mansi Autonomous Okrug, Russia | |||
459595 | 459595 | 2022-02-02 | Russia | Kirov Oblast | 90610 | 827 | 0 | 57.9665589 | 49.4074599 | 2022-02-03 04:21:21 | Kirov Oblast, Russia | |||
459596 | 459596 | 2022-02-02 | Russia | Komi Republic | 107231 | 2785 | 0 | 63.9881421 | 54.3326073 | 2022-02-03 04:21:21 | Komi Republic, Russia | |||
459597 | 459597 | 2022-02-02 | Russia | Kostroma Oblast | 53201 | 1174 | 0 | 58.424756 | 44.253327299999995 | 2022-02-03 04:21:21 | Kostroma Oblast, Russia | |||
459598 | 459598 | 2022-02-02 | Russia | Krasnodar Krai | 145385 | 10078 | 0 | 45.768401399999995 | 39.0261044 | 2022-02-03 04:21:21 | Krasnodar Krai, Russia | |||
459599 | 459599 | 2022-02-02 | Russia | Krasnoyarsk Krai | 193321 | 9483 | 0 | 63.3233807 | 97.09799740000001 | 2022-02-03 04:21:21 | Krasnoyarsk Krai, Russia | |||
459600 | 459600 | 2022-02-02 | Russia | Kurgan Oblast | 54877 | 1053 | 0 | 55.7655302 | 64.5632681 | 2022-02-03 04:21:21 | Kurgan Oblast, Russia | |||
459601 | 459601 | 2022-02-02 | Russia | Kursk Oblast | 88065 | 2190 | 0 | 51.6568453 | 36.4852695 | 2022-02-03 04:21:21 | Kursk Oblast, Russia | |||
459602 | 459602 | 2022-02-02 | Russia | Leningrad Oblast | 119865 | 3175 | 0 | 60.185329599999996 | 32.3925325 | 2022-02-03 04:21:21 | Leningrad Oblast, Russia | |||
459603 | 459603 | 2022-02-02 | Russia | Lipetsk Oblast | 94976 | 3051 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-02-03 04:21:21 | Lipetsk Oblast, Russia | |||
459604 | 459604 | 2022-02-02 | Russia | Magadan Oblast | 14804 | 356 | 0 | 62.48858785 | 153.9903764 | 2022-02-03 04:21:21 | Magadan Oblast, Russia | |||
459605 | 459605 | 2022-02-02 | Russia | Mari El Republic | 33237 | 976 | 0 | 56.576750399999995 | 47.881751200000004 | 2022-02-03 04:21:21 | Mari El Republic, Russia | |||
459606 | 459606 | 2022-02-02 | Russia | Mordovia Republic | 44643 | 1158 | 0 | 54.4419829 | 44.466114399999995 | 2022-02-03 04:21:21 | Mordovia Republic, Russia | |||
459607 | 459607 | 2022-02-02 | Russia | Moscow | 2402668 | 39116 | 0 | 55.7504461 | 37.6174943 | 2022-02-03 04:21:21 | Moscow, Russia | |||
459608 | 459608 | 2022-02-02 | Russia | Moscow Oblast | 782577 | 13399 | 0 | 55.50431579999999 | 38.0353929 | 2022-02-03 04:21:21 | Moscow Oblast, Russia | |||
459609 | 459609 | 2022-02-02 | Russia | Murmansk Oblast | 100349 | 2950 | 0 | 68.00004179999999 | 33.9999151 | 2022-02-03 04:21:21 | Murmansk Oblast, Russia | |||
459610 | 459610 | 2022-02-02 | Russia | Nenets Autonomous Okrug | 4116 | 90 | 0 | 68.27557185 | 57.1686375 | 2022-02-03 04:21:21 | Nenets Autonomous Okrug, Russia | |||
459611 | 459611 | 2022-02-02 | Russia | Nizhny Novgorod Oblast | 257030 | 10541 | 0 | 55.47180329999999 | 44.091159399999995 | 2022-02-03 04:21:21 | Nizhny Novgorod Oblast, Russia | |||
459612 | 459612 | 2022-02-02 | Russia | North Ossetia - Alania Republic | 34080 | 1110 | 0 | 42.79336110000001 | 44.6324493 | 2022-02-03 04:21:21 | North Ossetia - Alania Republic, Russia | |||
459613 | 459613 | 2022-02-02 | Russia | Novgorod Oblast | 72382 | 842 | 0 | 58.2843833 | 32.516975699999996 | 2022-02-03 04:21:21 | Novgorod Oblast, Russia | |||
459614 | 459614 | 2022-02-02 | Russia | Novosibirsk Oblast | 105579 | 4659 | 0 | 54.9720169 | 79.48139240000002 | 2022-02-03 04:21:21 | Novosibirsk Oblast, Russia | |||
459615 | 459615 | 2022-02-02 | Russia | Omsk Oblast | 145663 | 3562 | 0 | 56.09352629999999 | 73.5099936 | 2022-02-03 04:21:21 | Omsk Oblast, Russia | |||
459616 | 459616 | 2022-02-02 | Russia | Orel Oblast | 78966 | 1626 | 0 | 52.96854329999999 | 36.0692477 | 2022-02-03 04:21:21 | Orel Oblast, Russia | |||
459617 | 459617 | 2022-02-02 | Russia | Orenburg Oblast | 120558 | 3599 | 0 | 52.02692620000001 | 54.7276647 | 2022-02-03 04:21:21 | Orenburg Oblast, Russia | |||
459618 | 459618 | 2022-02-02 | Russia | Penza Oblast | 109906 | 4898 | 0 | 53.1655415 | 44.78791810000001 | 2022-02-03 04:21:21 | Penza Oblast, Russia | |||
459619 | 459619 | 2022-02-02 | Russia | Perm Krai | 192943 | 7828 | 0 | 58.5951603 | 56.3159546 | 2022-02-03 04:21:21 | Perm Krai, Russia | |||
459620 | 459620 | 2022-02-02 | Russia | Primorsky Krai | 113400 | 1715 | 0 | 45.0819456 | 134.726645 | 2022-02-03 04:21:21 | Primorsky Krai, Russia | |||
459621 | 459621 | 2022-02-02 | Russia | Pskov Oblast | 75963 | 1443 | 0 | 57.535872899999994 | 28.8586826 | 2022-02-03 04:21:21 | Pskov Oblast, Russia | |||
459622 | 459622 | 2022-02-02 | Russia | Rostov Oblast | 222688 | 10048 | 0 | 47.6222451 | 40.7957942 | 2022-02-03 04:21:21 | Rostov Oblast, Russia | |||
459623 | 459623 | 2022-02-02 | Russia | Ryazan Oblast | 69428 | 2878 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-03 04:21:21 | Ryazan Oblast, Russia | |||
459624 | 459624 | 2022-02-02 | Russia | Saint Petersburg | 1057686 | 30022 | 0 | 59.960673899999996 | 30.158655100000004 | 2022-02-03 04:21:21 | Saint Petersburg, Russia | |||
459625 | 459625 | 2022-02-02 | Russia | Sakha (Yakutiya) Republic | 106058 | 1879 | 0 | 66.941626 | 129.642371 | 2022-02-03 04:21:21 | Sakha (Yakutiya) Republic, Russia | |||
459626 | 459626 | 2022-02-02 | Russia | Sakhalin Oblast | 46982 | 655 | 0 | 49.7219665 | 143.448533 | 2022-02-03 04:21:21 | Sakhalin Oblast, Russia | |||
459627 | 459627 | 2022-02-02 | Russia | Samara Oblast | 227390 | 6719 | 0 | 53.2128813 | 50.8914633 | 2022-02-03 04:21:21 | Samara Oblast, Russia | |||
459628 | 459628 | 2022-02-02 | Russia | Saratov Oblast | 146507 | 5373 | 0 | 51.652055499999996 | 46.86319520000001 | 2022-02-03 04:21:21 | Saratov Oblast, Russia | |||
459629 | 459629 | 2022-02-02 | Russia | Smolensk Oblast | 92279 | 2602 | 0 | 55.03434960000001 | 33.0192065 | 2022-02-03 04:21:21 | Smolensk Oblast, Russia | |||
459630 | 459630 | 2022-02-02 | Russia | Stavropol Krai | 146118 | 6482 | 0 | 44.86325770000001 | 43.4406913 | 2022-02-03 04:21:21 | Stavropol Krai, 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]);