daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,847 rows where "day" is on date 2020-07-10 sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, day
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-10 | Japan | Port Quarantine | 368 | 1 | 201 | 166 | 2020-07-11 04:34:26 | Port Quarantine, Japan | ||||
2020-07-10 | Chile | Unknown | 0 | 0 | 70 | 0 | 2020-07-11 04:34:26 | Unknown, Chile | ||||
2020-07-10 | Colombia | Unknown | 0 | 0 | 0 | 0 | 2020-07-11 04:34:26 | Unknown, Colombia | ||||
2020-07-10 | Germany | Unknown | 1018 | 0 | 0 | 1018 | 2020-07-11 04:34:26 | Unknown, Germany | ||||
2020-07-10 | India | Unknown | 3416 | 0 | 0 | 3416 | 2020-07-11 04:34:26 | Unknown, India | ||||
2020-07-10 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-07-11 04:34:26 | Unknown, Japan | ||||
2020-07-10 | Peru | Unknown | 0 | 0 | 210638 | 0 | 2020-07-11 04:34:26 | Unknown, Peru | ||||
2020-07-10 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-11 04:34:26 | Unknown, Spain | ||||
2020-07-10 | Diamond Princess | 712 | 13 | 651 | 48 | 2020-07-11 04:34:26 | Diamond Princess | |||||
2020-07-10 | MS Zaandam | 9 | 2 | 0 | 7 | 2020-07-11 04:34:26 | MS Zaandam | |||||
2020-07-10 | China | Unknown | 3582 | 0 | 0 | 0 | 2020-07-11 04:34:26 | Unknown, China | ||||
2020-07-10 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-07-11 04:34:26 | Unknown, Malaysia | ||||
2020-07-10 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-07-11 04:34:26 | Unknown, Ukraine | ||||
2020-07-10 | Kenya | 9448 | 181 | 2733 | 6534 | -0.0236 | 37.9062 | 2020-07-11 04:34:26 | Kenya | |||
2020-07-10 | Congo (Brazzaville) | 2028 | 47 | 589 | 1392 | -0.228 | 15.8277 | 2020-07-11 04:34:26 | Congo (Brazzaville) | |||
2020-07-10 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2020-07-11 04:34:26 | Nauru | |||
2020-07-10 | Indonesia | 72347 | 3469 | 33529 | 35349 | -0.7893 | 113.9213 | 2020-07-11 04:34:26 | Indonesia | |||
2020-07-10 | Gabon | 5942 | 46 | 3004 | 2892 | -0.8037 | 11.6094 | 2020-07-11 04:34:26 | Gabon | |||
2020-07-10 | Colombia | Amazonas | 2399 | 101 | 2110 | 188 | -1.4429 | -71.5724 | 2020-07-11 04:34:26 | Amazonas, Colombia | ||
2020-07-10 | Ecuador | 65018 | 4939 | 29577 | 30502 | -1.8312 | -78.1834 | 2020-07-11 04:34:26 | Ecuador | |||
2020-07-10 | Rwanda | 1252 | 3 | 635 | 614 | -1.9403 | 29.8739 | 2020-07-11 04:34:26 | Rwanda | |||
2020-07-10 | Brazil | Para | 124934 | 5274 | 109699 | 7751 | -1.9981 | -54.9306 | 2020-07-11 04:34:26 | Para, Brazil | ||
2020-07-10 | Brazil | Tocantins | 14939 | 251 | 8915 | 5349 | -10.1753 | -48.2982 | 2020-07-11 04:34:26 | Tocantins, Brazil | ||
2020-07-10 | Peru | Pasco | 1280 | 61 | 0 | 1219 | -10.39655 | -75.307635 | 2020-07-11 04:34:26 | Pasco, Peru | ||
2020-07-10 | Brazil | Sergipe | 34713 | 931 | 22686 | 11096 | -10.5741 | -37.3857 | 2020-07-11 04:34:26 | Sergipe, Brazil | ||
2020-07-10 | Angola | 458 | 23 | 117 | 318 | -11.2027 | 17.8739 | 2020-07-11 04:34:26 | Angola | |||
2020-07-10 | Brazil | Rondonia | 26000 | 606 | 15290 | 10105 | -11.5057 | -63.5806 | 2020-07-11 04:34:26 | Rondonia, Brazil | ||
2020-07-10 | Peru | Junin | 4890 | 589 | 0 | 4301 | -11.541783 | -74.876968 | 2020-07-11 04:34:26 | Junin, Peru | ||
2020-07-10 | Comoros | 314 | 7 | 272 | 35 | -11.6455 | 43.3333 | 2020-07-11 04:34:26 | Comoros | |||
2020-07-10 | Peru | Lima | 172854 | 21025 | 0 | 151829 | -11.766533 | -76.60449799999998 | 2020-07-11 04:34:26 | Lima, Peru | ||
2020-07-10 | Peru | Callao | 18921 | 3029 | 0 | 15892 | -11.954609 | -77.136042 | 2020-07-11 04:34:26 | Callao, Peru | ||
2020-07-10 | Peru | Madre de Dios | 2372 | 78 | 0 | 2294 | -11.972699 | -70.53171999999998 | 2020-07-11 04:34:26 | Madre de Dios, Peru | ||
2020-07-10 | Australia | Northern Territory | 31 | 0 | 29 | 2 | -12.4634 | 130.8456 | 2020-07-11 04:34:26 | Northern Territory, Australia | ||
2020-07-10 | Brazil | Bahia | 101186 | 2383 | 71926 | 26877 | -12.5797 | -41.7007 | 2020-07-11 04:34:26 | Bahia, Brazil | ||
2020-07-10 | Brazil | Mato Grosso | 27636 | 1026 | 11660 | 13750 | -12.6819 | -56.9211 | 2020-07-11 04:34:26 | Mato Grosso, Brazil | ||
2020-07-10 | France | Mayotte | 2711 | 37 | 2480 | 194 | -12.8275 | 45.166244 | 2020-07-11 04:34:26 | Mayotte, France | ||
2020-07-10 | Peru | Huancavelica | 1057 | 50 | 0 | 1007 | -13.023888000000001 | -75.00277 | 2020-07-11 04:34:26 | Huancavelica, Peru | ||
2020-07-10 | Zambia | 1895 | 42 | 1348 | 505 | -13.133897 | 27.849332 | 2020-07-11 04:34:26 | Zambia | |||
2020-07-10 | Peru | Cusco | 2125 | 76 | 0 | 2049 | -13.191068 | -72.153609 | 2020-07-11 04:34:26 | Cusco, Peru | ||
2020-07-10 | Malawi | 2069 | 31 | 379 | 1659 | -13.254307999999998 | 34.301525 | 2020-07-11 04:34:26 | Malawi | |||
2020-07-10 | Samoa | 0 | 0 | 0 | 0 | -13.759 | -172.1046 | 2020-07-11 04:34:26 | Samoa | |||
2020-07-10 | Peru | Apurimac | 620 | 36 | 0 | 584 | -14.027713 | -72.975378 | 2020-07-11 04:34:26 | Apurimac, Peru | ||
2020-07-10 | Peru | Ayacucho | 2178 | 125 | 0 | 2053 | -14.091648000000001 | -74.08344 | 2020-07-11 04:34:26 | Ayacucho, Peru | ||
2020-07-10 | Peru | Ica | 9140 | 1620 | 0 | 7520 | -14.235097 | -75.574821 | 2020-07-11 04:34:26 | Ica, Peru | ||
2020-07-10 | Peru | Puno | 1135 | 84 | 0 | 1051 | -14.995826999999998 | -69.922726 | 2020-07-11 04:34:26 | Puno, Peru | ||
2020-07-10 | Brazil | Distrito Federal | 67297 | 856 | 54402 | 12039 | -15.7998 | -47.8645 | 2020-07-11 04:34:26 | Distrito Federal, Brazil | ||
2020-07-10 | Brazil | Goias | 35706 | 835 | 10223 | 24108 | -15.827 | -49.8362 | 2020-07-11 04:34:26 | Goias, Brazil | ||
2020-07-10 | Peru | Arequipa | 8496 | 1073 | 0 | 7423 | -15.843523999999999 | -72.475539 | 2020-07-11 04:34:26 | Arequipa, Peru | ||
2020-07-10 | Bolivia | 45565 | 1702 | 13918 | 29945 | -16.2902 | -63.5887 | 2020-07-11 04:34:26 | Bolivia | |||
2020-07-10 | Peru | Moquegua | 1254 | 65 | 0 | 1189 | -16.860271 | -70.839046 | 2020-07-11 04:34:26 | Moquegua, Peru | ||
2020-07-10 | Peru | Tacna | 1223 | 47 | 0 | 1176 | -17.644160999999997 | -70.27756 | 2020-07-11 04:34:26 | Tacna, Peru | ||
2020-07-10 | France | French Polynesia | 62 | 0 | 60 | 2 | -17.6797 | -149.4068 | 2020-07-11 04:34:26 | French Polynesia, France | ||
2020-07-10 | Fiji | 26 | 0 | 18 | 8 | -17.7134 | 178.065 | 2020-07-11 04:34:26 | Fiji | |||
2020-07-10 | Brazil | Minas Gerais | 70086 | 1504 | 45145 | 23437 | -18.5122 | -44.555 | 2020-07-11 04:34:26 | Minas Gerais, Brazil | ||
2020-07-10 | Chile | Arica y Parinacota | 2322 | 26 | 1753 | 543 | -18.594 | -69.4785 | 2020-07-11 04:34:26 | Arica y Parinacota, Chile | ||
2020-07-10 | Mozambique | 1111 | 9 | 344 | 758 | -18.665695 | 35.529562 | 2020-07-11 04:34:26 | Mozambique | |||
2020-07-10 | Madagascar | 4143 | 34 | 2183 | 1926 | -18.766947000000002 | 46.869107 | 2020-07-11 04:34:26 | Madagascar | |||
2020-07-10 | Zimbabwe | 942 | 13 | 320 | 609 | -19.015438 | 29.154857 | 2020-07-11 04:34:26 | Zimbabwe | |||
2020-07-10 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-07-11 04:34:26 | Niue, New Zealand | ||
2020-07-10 | Brazil | Espirito Santo | 61361 | 1967 | 40983 | 18406 | -19.1834 | -40.3089 | 2020-07-11 04:34:26 | Espirito Santo, Brazil | ||
2020-07-10 | Chile | Tarapaca | 6961 | 107 | 6085 | 769 | -19.9232 | -69.5132 | 2020-07-11 04:34:26 | Tarapaca, Chile | ||
2020-07-10 | Brazil | Roraima | 21849 | 396 | 8191 | 12636 | -2.7376 | -62.0751 | 2020-07-11 04:34:26 | Roraima, Brazil | ||
2020-07-10 | Mauritius | 342 | 10 | 330 | 2 | -20.348404000000002 | 57.552152 | 2020-07-11 04:34:26 | Mauritius | |||
2020-07-10 | Brazil | Mato Grosso do Sul | 12969 | 153 | 8008 | 4107 | -20.7722 | -54.7852 | 2020-07-11 04:34:26 | Mato Grosso do Sul, Brazil | ||
2020-07-10 | France | New Caledonia | 21 | 0 | 21 | 0 | -20.904304999999997 | 165.618042 | 2020-07-11 04:34:26 | New Caledonia, France | ||
2020-07-10 | France | Reunion | 571 | 3 | 472 | 96 | -21.1151 | 55.5364 | 2020-07-11 04:34:26 | Reunion, France | ||
2020-07-10 | Tonga | 0 | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-07-11 04:34:26 | Tonga | |||
2020-07-10 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-07-11 04:34:26 | Cook Islands, New Zealand | ||
2020-07-10 | Botswana | 314 | 1 | 31 | 282 | -22.3285 | 24.6849 | 2020-07-11 04:34:26 | Botswana | |||
2020-07-10 | Brazil | Rio de Janeiro | 129443 | 11280 | 108151 | 10012 | -22.9068 | -43.1729 | 2020-07-11 04:34:26 | Rio de Janeiro, Brazil | ||
2020-07-10 | Namibia | 668 | 1 | 25 | 642 | -22.9576 | 18.4904 | 2020-07-11 04:34:26 | Namibia | |||
2020-07-10 | Paraguay | 2736 | 20 | 1256 | 1460 | -23.4425 | -58.4438 | 2020-07-11 04:34:26 | Paraguay | |||
2020-07-10 | Brazil | Sao Paulo | 359110 | 17442 | 204531 | 137137 | -23.5505 | -46.6333 | 2020-07-11 04:34:26 | Sao Paulo, Brazil | ||
2020-07-10 | Chile | Antofagasta | 11267 | 216 | 9241 | 1810 | -23.6509 | -70.3975 | 2020-07-11 04:34:26 | Antofagasta, Chile | ||
2020-07-10 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-07-11 04:34:26 | Pitcairn Islands, United Kingdom | ||
2020-07-10 | Brazil | Parana | 39512 | 978 | 13374 | 25160 | -25.2521 | -52.0215 | 2020-07-11 04:34:26 | Parana, Brazil | ||
2020-07-10 | Eswatini | 1257 | 18 | 633 | 606 | -26.5225 | 31.4659 | 2020-07-11 04:34:26 | Eswatini | |||
2020-07-10 | Brazil | Santa Catarina | 40106 | 459 | 31616 | 8031 | -27.2423 | -50.2189 | 2020-07-11 04:34:26 | Santa Catarina, Brazil | ||
2020-07-10 | Australia | Queensland | 1070 | 6 | 1058 | 6 | -27.4698 | 153.0251 | 2020-07-11 04:34:26 | Queensland, Australia | ||
2020-07-10 | Chile | Atacama | 1467 | 9 | 1084 | 374 | -27.5661 | -70.0503 | 2020-07-11 04:34:26 | Atacama, Chile | ||
2020-07-10 | Lesotho | 184 | 1 | 26 | 157 | -29.609988 | 28.233608 | 2020-07-11 04:34:26 | Lesotho | |||
2020-07-10 | Chile | Coquimbo | 3918 | 29 | 3140 | 749 | -29.959 | -71.3389 | 2020-07-11 04:34:26 | Coquimbo, Chile | ||
2020-07-10 | Kiribati | 0 | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-07-11 04:34:26 | Kiribati | |||
2020-07-10 | Burundi | 191 | 1 | 118 | 72 | -3.3731 | 29.9189 | 2020-07-11 04:34:26 | Burundi | |||
2020-07-10 | Brazil | Amazonas | 82507 | 3008 | 69107 | 10392 | -3.4168 | -65.8561 | 2020-07-11 04:34:26 | Amazonas, Brazil | ||
2020-07-10 | Peru | Tumbes | 3309 | 466 | 0 | 2843 | -3.857496 | -80.54525500000003 | 2020-07-11 04:34:26 | Tumbes, Peru | ||
2020-07-10 | Brazil | Rio Grande do Sul | 37490 | 919 | 31317 | 5254 | -30.0346 | -51.2177 | 2020-07-11 04:34:26 | Rio Grande do Sul, Brazil | ||
2020-07-10 | South Africa | 250687 | 3860 | 118232 | 128595 | -30.5595 | 22.9375 | 2020-07-11 04:34:26 | South Africa | |||
2020-07-10 | Australia | Western Australia | 634 | 9 | 604 | 21 | -31.9505 | 115.8605 | 2020-07-11 04:34:26 | Western Australia, Australia | ||
2020-07-10 | Uruguay | 985 | 29 | 886 | 70 | -32.5228 | -55.7658 | 2020-07-11 04:34:26 | Uruguay | |||
2020-07-10 | Chile | Valparaiso | 14053 | 320 | 11854 | 1879 | -33.0472 | -71.6127 | 2020-07-11 04:34:26 | Valparaiso, Chile | ||
2020-07-10 | Chile | Metropolitana | 235370 | 5673 | 216627 | 13070 | -33.4376 | -70.6505 | 2020-07-11 04:34:26 | Metropolitana, Chile | ||
2020-07-10 | Australia | New South Wales | 3474 | 49 | 2997 | 428 | -33.8688 | 151.2093 | 2020-07-11 04:34:26 | New South Wales, Australia | ||
2020-07-10 | Chile | OHiggins | 8069 | 113 | 6377 | 1579 | -34.5755 | -71.0022 | 2020-07-11 04:34:26 | OHiggins, Chile | ||
2020-07-10 | Australia | South Australia | 443 | 4 | 439 | 0 | -34.9285 | 138.6007 | 2020-07-11 04:34:26 | South Australia, Australia | ||
2020-07-10 | Australia | Australian Capital Territory | 113 | 3 | 105 | 5 | -35.4735 | 149.0124 | 2020-07-11 04:34:26 | Australian Capital Territory, Australia | ||
2020-07-10 | Chile | Maule | 6833 | 86 | 5615 | 1132 | -35.5183 | -71.6885 | 2020-07-11 04:34:26 | Maule, Chile | ||
2020-07-10 | Chile | Nuble | 2838 | 37 | 2376 | 425 | -36.7226 | -71.7622 | 2020-07-11 04:34:26 | Nuble, Chile | ||
2020-07-10 | Chile | Biobio | 8151 | 68 | 6762 | 1321 | -37.4464 | -72.1416 | 2020-07-11 04:34:26 | Biobio, Chile | ||
2020-07-10 | Australia | Victoria | 3560 | 23 | 2286 | 1251 | -37.8136 | 144.9631 | 2020-07-11 04:34:26 | Victoria, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;