daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,016 rows where "day" is on date 2022-03-15 sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 201
- US 3,279
- Russia 83
- Japan 49
- India 37
- China 34
- Colombia 34
- Mexico 33
- Ukraine 28
- Brazil 27
- Peru 26
- Italy 21
- Sweden 21
- Spain 20
- United Kingdom 19
- Chile 17
- Germany 17
- Malaysia 17
- Netherlands 17
- Canada 16
- Belgium 12
- France 12
- Australia 8
- Pakistan 7
- Denmark 3
- New Zealand 3
- Afghanistan 1
- Albania 1
- Algeria 1
- Andorra 1
- Angola 1
- Antarctica 1
- Antigua and Barbuda 1
- Argentina 1
- Armenia 1
- Austria 1
- Azerbaijan 1
- Bahamas 1
- Bahrain 1
- Bangladesh 1
- Barbados 1
- Belarus 1
- Belize 1
- Benin 1
- Bhutan 1
- Bolivia 1
- Bosnia and Herzegovina 1
- Botswana 1
- Brunei 1
- Bulgaria 1
- Burkina Faso 1
- Burma 1
- Burundi 1
- Cabo Verde 1
- Cambodia 1
- Cameroon 1
- Central African Republic 1
- Chad 1
- Comoros 1
- Congo (Brazzaville) 1
- Congo (Kinshasa) 1
- Costa Rica 1
- Cote d'Ivoire 1
- Croatia 1
- Cuba 1
- Cyprus 1
- Czechia 1
- Diamond Princess 1
- Djibouti 1
- Dominica 1
- Dominican Republic 1
- Ecuador 1
- Egypt 1
- El Salvador 1
- Equatorial Guinea 1
- Eritrea 1
- Estonia 1
- Eswatini 1
- Ethiopia 1
- Fiji 1
- Finland 1
- Gabon 1
- Gambia 1
- Georgia 1
- Ghana 1
- Greece 1
- Grenada 1
- Guatemala 1
- Guinea 1
- Guinea-Bissau 1
- Guyana 1
- Haiti 1
- Holy See 1
- Honduras 1
- Hungary 1
- Iceland 1
- Indonesia 1
- Iran 1
- Iraq 1
- Ireland 1
- Israel 1
- Jamaica 1
- Jordan 1
- Kazakhstan 1
- Kenya 1
- Kiribati 1
- Korea, North 1
- Korea, South 1
- Kosovo 1
- Kuwait 1
- Kyrgyzstan 1
- Laos 1
- Latvia 1
- Lebanon 1
- Lesotho 1
- Liberia 1
- Libya 1
- Liechtenstein 1
- Lithuania 1
- Luxembourg 1
- MS Zaandam 1
- Madagascar 1
- Malawi 1
- Maldives 1
- Mali 1
- Malta 1
- Marshall Islands 1
- Mauritania 1
- Mauritius 1
- Micronesia 1
- Moldova 1
- Monaco 1
- Mongolia 1
- Montenegro 1
- Morocco 1
- Mozambique 1
- Namibia 1
- Nauru 1
- Nepal 1
- Nicaragua 1
- Niger 1
- Nigeria 1
- North Macedonia 1
- Norway 1
- Oman 1
- Palau 1
- Panama 1
- Papua New Guinea 1
- Paraguay 1
- Philippines 1
- Poland 1
- Portugal 1
- Qatar 1
- Romania 1
- Rwanda 1
- Saint Kitts and Nevis 1
- Saint Lucia 1
- Saint Vincent and the Grenadines 1
- Samoa 1
- San Marino 1
- Sao Tome and Principe 1
- Saudi Arabia 1
- Senegal 1
- Serbia 1
- Seychelles 1
- Sierra Leone 1
- Singapore 1
- Slovakia 1
- Slovenia 1
- Solomon Islands 1
- Somalia 1
- South Africa 1
- South Sudan 1
- Sri Lanka 1
- Sudan 1
- Summer Olympics 2020 1
- Suriname 1
- Switzerland 1
- Syria 1
- Taiwan* 1
- Tajikistan 1
- Tanzania 1
- Thailand 1
- Timor-Leste 1
- Togo 1
- Tonga 1
- Trinidad and Tobago 1
- Tunisia 1
- Turkey 1
- Tuvalu 1
- Uganda 1
- United Arab Emirates 1
- Uruguay 1
- Uzbekistan 1
- Vanuatu 1
- Venezuela 1
- Vietnam 1
- West Bank and Gaza 1
- Winter Olympics 2022 1
- Yemen 1
- Zambia 1
- Zimbabwe 1
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-03-15 | Belgium | Unknown | 53794 | 30445 | 0 | 2022-03-16 04:20:50 | Unknown, Belgium | |||||
2022-03-15 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-03-16 04:20:50 | Repatriated Travellers, Canada | |||||
2022-03-15 | Chile | Unknown | 43 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, Chile | |||||
2022-03-15 | China | Unknown | 23563 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, China | |||||
2022-03-15 | Colombia | Unknown | 0 | 300 | 0 | 2022-03-16 04:20:50 | Unknown, Colombia | |||||
2022-03-15 | Diamond Princess | 712 | 13 | 0 | 2022-03-16 04:20:50 | Diamond Princess | ||||||
2022-03-15 | Germany | Unknown | 37652 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, Germany | |||||
2022-03-15 | India | Unknown | 0 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, India | |||||
2022-03-15 | Japan | Port Quarantine | 12472 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2022-03-15 | Japan | Unknown | 8 | 0 | 0 | 2021-11-10 23:21:44 | Unknown, Japan | |||||
2022-03-15 | MS Zaandam | 9 | 2 | 0 | 2022-03-16 04:20:50 | MS Zaandam | ||||||
2022-03-15 | Malaysia | Unknown | 0 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, Malaysia | |||||
2022-03-15 | Mexico | Unknown | 0 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, Mexico | |||||
2022-03-15 | Netherlands | Unknown | 19 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
2022-03-15 | Peru | Unknown | 992 | 73 | 0 | 2022-03-16 04:20:50 | Unknown, Peru | |||||
2022-03-15 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
2022-03-15 | Ukraine | Unknown | 102904 | 1764 | 0 | 0 | 2022-03-16 04:20:50 | Unknown, Ukraine | ||||
2022-03-15 | Kenya | 323204 | 5647 | 0 | -0.0236 | 37.9062 | 2022-03-16 04:20:50 | Kenya | ||||
2022-03-15 | Congo (Brazzaville) | 24049 | 378 | 0 | -0.228 | 15.8277 | 2022-03-16 04:20:50 | Congo (Brazzaville) | ||||
2022-03-15 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2022-03-16 04:20:50 | Nauru | |||
2022-03-15 | Indonesia | 5914532 | 152745 | 0 | -0.7893 | 113.9213 | 2022-03-16 04:20:50 | Indonesia | ||||
2022-03-15 | Gabon | 47570 | 303 | 0 | -0.8037 | 11.6094 | 2022-03-16 04:20:50 | Gabon | ||||
2022-03-15 | Colombia | Amazonas | 7557 | 264 | 0 | -1.4429 | -71.5724 | 2022-03-16 04:20:50 | Amazonas, Colombia | |||
2022-03-15 | Ecuador | 849699 | 35348 | 0 | -1.8312 | -78.1834 | 2022-03-16 04:20:50 | Ecuador | ||||
2022-03-15 | Rwanda | 129610 | 1459 | 0 | -1.9403 | 29.8739 | 2022-03-16 04:20:50 | Rwanda | ||||
2022-03-15 | Brazil | Para | 738836 | 17999 | 0 | -1.9981 | -54.9306 | 2022-03-16 04:20:50 | Para, Brazil | |||
2022-03-15 | Brazil | Tocantins | 301172 | 4134 | 0 | -10.1753 | -48.2982 | 2022-03-16 04:20:50 | Tocantins, Brazil | |||
2022-03-15 | Peru | Pasco | 23846 | 1090 | 0 | -10.39655 | -75.307635 | 2022-03-16 04:20:50 | Pasco, Peru | |||
2022-03-15 | Brazil | Sergipe | 322987 | 6290 | 0 | -10.5741 | -37.3857 | 2022-03-16 04:20:50 | Sergipe, Brazil | |||
2022-03-15 | Angola | 98956 | 1900 | 0 | -11.2027 | 17.8739 | 2022-03-16 04:20:50 | Angola | ||||
2022-03-15 | Brazil | Rondonia | 384179 | 7122 | 0 | -11.5057 | -63.5806 | 2022-03-16 04:20:50 | Rondonia, Brazil | |||
2022-03-15 | Peru | Junin | 125412 | 7410 | 0 | -11.541783 | -74.876968 | 2022-03-16 04:20:50 | Junin, Peru | |||
2022-03-15 | Comoros | 8069 | 160 | 0 | -11.6455 | 43.3333 | 2022-03-16 04:20:50 | Comoros | ||||
2022-03-15 | Peru | Lima | 1601185 | 92695 | 0 | -11.766533 | -76.60449799999998 | 2022-03-16 04:20:50 | Lima, Peru | |||
2022-03-15 | Peru | Callao | 146180 | 10461 | 0 | -11.954609 | -77.136042 | 2022-03-16 04:20:50 | Callao, Peru | |||
2022-03-15 | Peru | Madre de Dios | 17691 | 841 | 0 | -11.972699 | -70.53171999999998 | 2022-03-16 04:20:50 | Madre de Dios, Peru | |||
2022-03-15 | Australia | Northern Territory | 45469 | 31 | 0 | -12.4634 | 130.8456 | 2022-03-16 04:20:50 | Northern Territory, Australia | |||
2022-03-15 | Brazil | Bahia | 1519949 | 29521 | 0 | -12.5797 | -41.7007 | 2022-03-16 04:20:50 | Bahia, Brazil | |||
2022-03-15 | Brazil | Mato Grosso | 719019 | 14824 | 0 | -12.6819 | -56.9211 | 2022-03-16 04:20:50 | Mato Grosso, Brazil | |||
2022-03-15 | France | Mayotte | 36745 | 187 | 0 | -12.8275 | 45.166244 | 2022-03-16 04:20:50 | Mayotte, France | |||
2022-03-15 | Peru | Huancavelica | 25606 | 1259 | 0 | -13.023888000000001 | -75.00277 | 2022-03-16 04:20:50 | Huancavelica, Peru | |||
2022-03-15 | Zambia | 315202 | 3960 | 0 | -13.133897 | 27.849332 | 2022-03-16 04:20:50 | Zambia | ||||
2022-03-15 | Peru | Cusco | 116398 | 5123 | 0 | -13.191068 | -72.153609 | 2022-03-16 04:20:50 | Cusco, Peru | |||
2022-03-15 | Malawi | 85515 | 2624 | 0 | -13.2543 | 34.3015 | 2022-03-16 04:20:50 | Malawi | ||||
2022-03-15 | Samoa | 48 | 0 | 0 | -13.759 | -172.1046 | 2022-03-16 04:20:50 | Samoa | ||||
2022-03-15 | Peru | Apurimac | 38690 | 1617 | 0 | -14.027713 | -72.975378 | 2022-03-16 04:20:50 | Apurimac, Peru | |||
2022-03-15 | Peru | Ayacucho | 47976 | 2309 | 0 | -14.091648000000001 | -74.08344 | 2022-03-16 04:20:50 | Ayacucho, Peru | |||
2022-03-15 | Peru | Ica | 103273 | 8896 | 0 | -14.235097 | -75.574821 | 2022-03-16 04:20:50 | Ica, Peru | |||
2022-03-15 | US | American Samoa | 60 | 588 | 0 | 0 | -14.270999999999999 | -170.132 | 2022-03-16 04:20:50 | American Samoa, US | ||
2022-03-15 | France | Wallis and Futuna | 454 | 7 | 0 | -14.2938 | -178.1165 | 2022-03-16 04:20:50 | Wallis and Futuna, France | |||
2022-03-15 | Peru | Puno | 65291 | 4703 | 0 | -14.995826999999998 | -69.922726 | 2022-03-16 04:20:50 | Puno, Peru | |||
2022-03-15 | Vanuatu | 341 | 1 | 0 | -15.3767 | 166.9592 | 2022-03-16 04:20:50 | Vanuatu | ||||
2022-03-15 | Brazil | Distrito Federal | 688882 | 11525 | 0 | -15.7998 | -47.8645 | 2022-03-16 04:20:50 | Distrito Federal, Brazil | |||
2022-03-15 | Brazil | Goias | 1227691 | 26038 | 0 | -15.827 | -49.8362 | 2022-03-16 04:20:50 | Goias, Brazil | |||
2022-03-15 | Peru | Arequipa | 211951 | 10217 | 0 | -15.843523999999999 | -72.475539 | 2022-03-16 04:20:50 | Arequipa, Peru | |||
2022-03-15 | Bolivia | 897970 | 21475 | 0 | -16.2902 | -63.5887 | 2022-03-16 04:20:50 | Bolivia | ||||
2022-03-15 | Peru | Moquegua | 48212 | 1611 | 0 | -16.860271 | -70.839046 | 2022-03-16 04:20:50 | Moquegua, Peru | |||
2022-03-15 | Peru | Tacna | 53638 | 2113 | 0 | -17.644160999999997 | -70.27756 | 2022-03-16 04:20:50 | Tacna, Peru | |||
2022-03-15 | France | French Polynesia | 70826 | 645 | 0 | -17.6797 | -149.4068 | 2022-03-16 04:20:50 | French Polynesia, France | |||
2022-03-15 | Fiji | 64081 | 834 | 0 | -17.7134 | 178.065 | 2022-03-16 04:20:50 | Fiji | ||||
2022-03-15 | Brazil | Minas Gerais | 3270602 | 60370 | 0 | -18.5122 | -44.555 | 2022-03-16 04:20:50 | Minas Gerais, Brazil | |||
2022-03-15 | Chile | Arica y Parinacota | 53829 | 658 | 0 | -18.594 | -69.4785 | 2022-03-16 04:20:50 | Arica y Parinacota, Chile | |||
2022-03-15 | Mozambique | 225188 | 2198 | 0 | -18.665695 | 35.529562 | 2022-03-16 04:20:50 | Mozambique | ||||
2022-03-15 | Madagascar | 63870 | 1377 | 0 | -18.766947000000002 | 46.869107 | 2022-03-16 04:20:50 | Madagascar | ||||
2022-03-15 | Zimbabwe | 242909 | 5416 | 0 | -19.015438 | 29.154857 | 2022-03-16 04:20:50 | Zimbabwe | ||||
2022-03-15 | New Zealand | Niue | 1 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-16 04:20:50 | Niue, New Zealand | ||
2022-03-15 | Brazil | Espirito Santo | 1032926 | 14259 | 0 | -19.1834 | -40.3089 | 2022-03-16 04:20:50 | Espirito Santo, Brazil | |||
2022-03-15 | Chile | Tarapaca | 78026 | 956 | 0 | -19.9232 | -69.5132 | 2022-03-16 04:20:50 | Tarapaca, Chile | |||
2022-03-15 | Brazil | Roraima | 154608 | 2140 | 0 | -2.7376 | -62.0751 | 2022-03-16 04:20:50 | Roraima, Brazil | |||
2022-03-15 | Mauritius | 181362 | 934 | 0 | -20.348404000000002 | 57.552152 | 2022-03-16 04:20:50 | Mauritius | ||||
2022-03-15 | Brazil | Mato Grosso do Sul | 515437 | 10445 | 0 | -20.7722 | -54.7852 | 2022-03-16 04:20:50 | Mato Grosso do Sul, Brazil | |||
2022-03-15 | France | New Caledonia | 59625 | 305 | 0 | -20.904304999999997 | 165.618042 | 2022-03-16 04:20:50 | New Caledonia, France | |||
2022-03-15 | France | Reunion | 318695 | 689 | 0 | -21.1151 | 55.5364 | 2022-03-16 04:20:50 | Reunion, France | |||
2022-03-15 | Tonga | 2072 | 2 | 0 | -21.179000000000002 | -175.1982 | 2022-03-16 04:20:50 | Tonga | ||||
2022-03-15 | New Zealand | Cook Islands | 379 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-16 04:20:50 | Cook Islands, New Zealand | |||
2022-03-15 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-16 04:20:50 | Botswana | ||||
2022-03-15 | Brazil | Rio de Janeiro | 2042494 | 72254 | 0 | -22.9068 | -43.1729 | 2022-03-16 04:20:50 | Rio de Janeiro, Brazil | |||
2022-03-15 | Namibia | 157458 | 4014 | 0 | -22.9576 | 18.4904 | 2022-03-16 04:20:50 | Namibia | ||||
2022-03-15 | Paraguay | 646283 | 18552 | 0 | -23.4425 | -58.4438 | 2022-03-16 04:20:50 | Paraguay | ||||
2022-03-15 | Brazil | Sao Paulo | 5142009 | 166182 | 0 | -23.5505 | -46.6333 | 2022-03-16 04:20:50 | Sao Paulo, Brazil | |||
2022-03-15 | Chile | Antofagasta | 118030 | 1437 | 0 | -23.6509 | -70.3975 | 2022-03-16 04:20:50 | Antofagasta, Chile | |||
2022-03-15 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-03-16 04:20:50 | Pitcairn Islands, United Kingdom | ||
2022-03-15 | Brazil | Parana | 2386425 | 42722 | 0 | -25.2521 | -52.0215 | 2022-03-16 04:20:50 | Parana, Brazil | |||
2022-03-15 | Eswatini | 69478 | 1392 | 0 | -26.5225 | 31.4659 | 2022-03-16 04:20:50 | Eswatini | ||||
2022-03-15 | Brazil | Santa Catarina | 1651040 | 21587 | 0 | -27.2423 | -50.2189 | 2022-03-16 04:20:50 | Santa Catarina, Brazil | |||
2022-03-15 | Australia | Queensland | 640104 | 652 | 0 | -27.4698 | 153.0251 | 2022-03-16 04:20:50 | Queensland, Australia | |||
2022-03-15 | Chile | Atacama | 61913 | 440 | 0 | -27.5661 | -70.0503 | 2022-03-16 04:20:50 | Atacama, Chile | |||
2022-03-15 | Lesotho | 32775 | 697 | 0 | -29.61 | 28.2336 | 2022-03-16 04:20:50 | Lesotho | ||||
2022-03-15 | Chile | Coquimbo | 116928 | 1303 | 0 | -29.959 | -71.3389 | 2022-03-16 04:20:50 | Coquimbo, Chile | |||
2022-03-15 | Kiribati | 3038 | 13 | 0 | -3.3704 | -168.734 | 2022-03-16 04:20:50 | Kiribati | ||||
2022-03-15 | Burundi | 38279 | 38 | 0 | -3.3731 | 29.9189 | 2022-03-16 04:20:50 | Burundi | ||||
2022-03-15 | Brazil | Amazonas | 579295 | 14144 | 0 | -3.4168 | -65.8561 | 2022-03-16 04:20:50 | Amazonas, Brazil | |||
2022-03-15 | Peru | Tumbes | 27224 | 1684 | 0 | -3.857496 | -80.54525500000003 | 2022-03-16 04:20:50 | Tumbes, Peru | |||
2022-03-15 | Brazil | Rio Grande do Sul | 2222120 | 38755 | 0 | -30.0346 | -51.2177 | 2022-03-16 04:20:50 | Rio Grande do Sul, Brazil | |||
2022-03-15 | South Africa | 3696823 | 99727 | 0 | -30.5595 | 22.9375 | 2022-03-16 04:20:50 | South Africa | ||||
2022-03-15 | Australia | Western Australia | 56309 | 14 | 0 | -31.9505 | 115.8605 | 2022-03-16 04:20:50 | Western Australia, Australia | |||
2022-03-15 | Uruguay | 867282 | 7110 | 0 | -32.5228 | -55.7658 | 2022-03-16 04:20:50 | Uruguay | ||||
2022-03-15 | Chile | Valparaiso | 283169 | 4160 | 0 | -33.0472 | -71.6127 | 2022-03-16 04:20:50 | Valparaiso, Chile | |||
2022-03-15 | Chile | Metropolitana | 1277127 | 21571 | 0 | -33.4376 | -70.6505 | 2022-03-16 04:20:50 | Metropolitana, Chile | |||
2022-03-15 | Australia | New South Wales | 1511588 | 1994 | 0 | -33.8688 | 151.2093 | 2022-03-16 04:20:50 | New South Wales, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;