daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,783 rows where "day" is on date 2020-06-15 sorted by confirmed descending
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-06-15 | US | New York | New York City | 36061 | 210259 | 22124 | 0 | 188135 | 40.76727260000001 | -73.97152637 | 2020-06-16 04:33:09 | New York City, New York, US |
2020-06-15 | Russia | Moscow | 207264 | 3334 | 123240 | 80690 | 55.7504461 | 37.6174943 | 2020-06-16 04:33:09 | Moscow, Russia | ||
2020-06-15 | France | 192043 | 29375 | 69719 | 92949 | 46.2276 | 2.2137 | 2020-06-16 04:33:09 | France | |||
2020-06-15 | Iran | 189876 | 8950 | 150590 | 30336 | 32.427908 | 53.68804599999999 | 2020-06-16 04:33:09 | Iran | |||
2020-06-15 | Brazil | Sao Paulo | 181460 | 10767 | 49295 | 121398 | -23.5505 | -46.6333 | 2020-06-16 04:33:09 | Sao Paulo, Brazil | ||
2020-06-15 | Turkey | 179831 | 4825 | 152364 | 22642 | 38.9637 | 35.2433 | 2020-06-16 04:33:09 | Turkey | |||
2020-06-15 | United Kingdom | England | 157293 | 47456 | 0 | 119994 | 52.3555 | -1.1743 | 2020-06-16 04:33:09 | England, United Kingdom | ||
2020-06-15 | Chile | Metropolitana | 144280 | 2913 | 0 | 141367 | -33.4376 | -70.6505 | 2020-06-16 04:33:09 | Metropolitana, Chile | ||
2020-06-15 | Peru | Lima | 134008 | 14653 | 0 | 119355 | -11.766533 | -76.60449799999998 | 2020-06-16 04:33:09 | Lima, Peru | ||
2020-06-15 | Saudi Arabia | 132048 | 1011 | 87890 | 43147 | 23.885942 | 45.079162 | 2020-06-16 04:33:09 | Saudi Arabia | |||
2020-06-15 | India | Maharashtra | 110744 | 4128 | 56049 | 50567 | 19.449759 | 76.108221 | 2020-06-16 04:33:09 | Maharashtra, India | ||
2020-06-15 | United Kingdom | Unknown | 104221 | 70 | 0 | 104221 | 55.3781 | -3.436 | 2020-06-16 04:33:09 | Unknown, United Kingdom | ||
2020-06-15 | Italy | Lombardia | 91917 | 16457 | 59484 | 15976 | 45.46679409 | 9.190347404 | 2020-06-16 04:33:09 | Lombardia, Italy | ||
2020-06-15 | Bangladesh | 90619 | 1209 | 18731 | 70679 | 23.685 | 90.3563 | 2020-06-16 04:33:09 | Bangladesh | |||
2020-06-15 | US | Illinois | Cook | 17031 | 85184 | 4206 | 0 | 80978 | 41.84144849 | -87.81658794 | 2020-06-16 04:33:09 | Cook, Illinois, US |
2020-06-15 | Brazil | Rio de Janeiro | 80946 | 7728 | 65063 | 8155 | -22.9068 | -43.1729 | 2020-06-16 04:33:09 | Rio de Janeiro, Brazil | ||
2020-06-15 | Qatar | 80876 | 76 | 58681 | 22119 | 25.3548 | 51.1839 | 2020-06-16 04:33:09 | Qatar | |||
2020-06-15 | Brazil | Ceara | 79853 | 5041 | 58432 | 16031 | -5.4984 | -39.3206 | 2020-06-16 04:33:09 | Ceara, Brazil | ||
2020-06-15 | US | California | Los Angeles | 6037 | 73832 | 2926 | 0 | 70906 | 34.30828379 | -118.2282411 | 2020-06-16 04:33:09 | Los Angeles, California, US |
2020-06-15 | South Africa | 73533 | 1568 | 39867 | 32098 | -30.5595 | 22.9375 | 2020-06-16 04:33:09 | South Africa | |||
2020-06-15 | Brazil | Para | 71243 | 4291 | 55864 | 9159 | -1.9981 | -54.9306 | 2020-06-16 04:33:09 | Para, Brazil | ||
2020-06-15 | Spain | Madrid | 70570 | 8691 | 40736 | 21143 | 40.4168 | -3.7038 | 2020-06-16 04:33:09 | Madrid, Spain | ||
2020-06-15 | China | Hubei | 68135 | 4512 | 63623 | 0 | 30.9756 | 112.2707 | 2020-06-16 04:33:09 | Hubei, China | ||
2020-06-15 | Brazil | Maranhao | 60592 | 1499 | 35466 | 23627 | -4.9609 | -45.2744 | 2020-06-16 04:33:09 | Maranhao, Brazil | ||
2020-06-15 | Belgium | 60100 | 9661 | 16610 | 33829 | 50.8333 | 4.469936 | 2020-06-16 04:33:09 | Belgium | |||
2020-06-15 | Spain | Catalonia | 59897 | 5587 | 26203 | 28107 | 41.5912 | 1.5209 | 2020-06-16 04:33:09 | Catalonia, Spain | ||
2020-06-15 | Brazil | Amazonas | 56777 | 2512 | 45828 | 8437 | -3.4168 | -65.8561 | 2020-06-16 04:33:09 | Amazonas, Brazil | ||
2020-06-15 | Pakistan | Punjab | 55878 | 1081 | 17730 | 37067 | 30.811346 | 72.13913199999998 | 2020-06-16 04:33:09 | Punjab, Pakistan | ||
2020-06-15 | Pakistan | Sindh | 55581 | 853 | 28023 | 26705 | 26.009446 | 68.77680699999999 | 2020-06-16 04:33:09 | Sindh, Pakistan | ||
2020-06-15 | Belarus | 54680 | 312 | 30420 | 23948 | 53.7098 | 27.9534 | 2020-06-16 04:33:09 | Belarus | |||
2020-06-15 | Canada | Quebec | 53946 | 5511 | 22213 | 26222 | 52.9399 | -73.5491 | 2020-06-16 04:33:09 | Quebec, Canada | ||
2020-06-15 | Russia | Moscow Oblast | 50042 | 690 | 17422 | 31930 | 55.50431579999999 | 38.0353929 | 2020-06-16 04:33:09 | Moscow Oblast, Russia | ||
2020-06-15 | Netherlands | 48948 | 6065 | 0 | 42883 | 52.1326 | 5.2913 | 2020-06-16 04:33:09 | Netherlands | |||
2020-06-15 | Germany | Bayern | 47642 | 2541 | 44300 | 802 | 48.7904 | 11.4979 | 2020-06-16 04:33:09 | Bayern, Germany | ||
2020-06-15 | Ecuador | 47322 | 3929 | 23349 | 20044 | -1.8312 | -78.1834 | 2020-06-16 04:33:09 | Ecuador | |||
2020-06-15 | India | Tamil Nadu | 46504 | 479 | 25344 | 20681 | 11.006091 | 78.400624 | 2020-06-16 04:33:09 | Tamil Nadu, India | ||
2020-06-15 | Egypt | 46289 | 1672 | 12329 | 32288 | 26.820553000000004 | 30.802497999999996 | 2020-06-16 04:33:09 | Egypt | |||
2020-06-15 | Brazil | Pernambuco | 45507 | 3886 | 28894 | 12727 | -8.8137 | -36.9541 | 2020-06-16 04:33:09 | Pernambuco, Brazil | ||
2020-06-15 | India | Delhi | 42829 | 1400 | 16427 | 25002 | 28.646519 | 77.10898 | 2020-06-16 04:33:09 | Delhi, India | ||
2020-06-15 | United Arab Emirates | 42636 | 291 | 28129 | 14216 | 23.424076 | 53.847818000000004 | 2020-06-16 04:33:09 | United Arab Emirates | |||
2020-06-15 | US | New York | Nassau | 36059 | 41240 | 2167 | 0 | 39073 | 40.74066522 | -73.58941873 | 2020-06-16 04:33:09 | Nassau, New York, US |
2020-06-15 | Singapore | 40818 | 26 | 30366 | 10426 | 1.2833 | 103.8333 | 2020-06-16 04:33:09 | Singapore | |||
2020-06-15 | US | New York | Suffolk | 36103 | 40692 | 1955 | 0 | 38737 | 40.88320119 | -72.8012172 | 2020-06-16 04:33:09 | Suffolk, New York, US |
2020-06-15 | Germany | Nordrhein-Westfalen | 39307 | 1646 | 36300 | 1361 | 51.4332 | 7.6616 | 2020-06-16 04:33:09 | Nordrhein-Westfalen, Germany | ||
2020-06-15 | Indonesia | 39294 | 2198 | 15123 | 21973 | -0.7893 | 113.9213 | 2020-06-16 04:33:09 | Indonesia | |||
2020-06-15 | Brazil | Bahia | 37621 | 1145 | 15850 | 20625 | -12.5797 | -41.7007 | 2020-06-16 04:33:09 | Bahia, Brazil | ||
2020-06-15 | Mexico | Ciudad de Mexico | 37503 | 4664 | 28817 | 4022 | 19.4326 | -99.1332 | 2020-06-16 04:33:09 | Ciudad de Mexico, Mexico | ||
2020-06-15 | Portugal | 37036 | 1520 | 22852 | 12664 | 39.3999 | -8.2245 | 2020-06-16 04:33:09 | Portugal | |||
2020-06-15 | Kuwait | 36431 | 298 | 27531 | 8602 | 29.311659999999996 | 47.481766 | 2020-06-16 04:33:09 | Kuwait | |||
2020-06-15 | Germany | Baden-Wurttemberg | 35090 | 1805 | 32900 | 446 | 48.6616 | 9.3501 | 2020-06-16 04:33:09 | Baden-Wurttemberg, Germany | ||
2020-06-15 | US | New York | Westchester | 36119 | 34327 | 1405 | 0 | 32922 | 41.16278376 | -73.75741653 | 2020-06-16 04:33:09 | Westchester, New York, US |
2020-06-15 | Canada | Ontario | 32816 | 2527 | 27637 | 3770 | 51.2538 | -85.3232 | 2020-06-16 04:33:09 | Ontario, Canada | ||
2020-06-15 | Argentina | 32785 | 854 | 9891 | 22040 | -38.4161 | -63.6167 | 2020-06-16 04:33:09 | Argentina | |||
2020-06-15 | US | Texas | Harris | 48201 | 31735 | 284 | 0 | 16998 | 29.86 | -95.39 | 2020-06-16 04:33:09 | Harris, Texas, US |
2020-06-15 | Switzerland | 31131 | 1802 | 28900 | 429 | 46.8182 | 8.2275 | 2020-06-16 04:33:09 | Switzerland | |||
2020-06-15 | Italy | Piemonte | 31061 | 4012 | 24445 | 2604 | 45.0732745 | 7.680687483 | 2020-06-16 04:33:09 | Piemonte, Italy | ||
2020-06-15 | Poland | 29788 | 1256 | 14383 | 14149 | 51.9194 | 19.1451 | 2020-06-16 04:33:09 | Poland | |||
2020-06-15 | Brazil | Paraiba | 28668 | 656 | 6890 | 21122 | -7.24 | -36.782 | 2020-06-16 04:33:09 | Paraiba, Brazil | ||
2020-06-15 | Italy | Emilia-Romagna | 28084 | 4207 | 22377 | 1500 | 44.49436681 | 11.341720800000001 | 2020-06-16 04:33:09 | Emilia-Romagna, Italy | ||
2020-06-15 | Brazil | Espirito Santo | 27652 | 1087 | 15252 | 11243 | -19.1834 | -40.3089 | 2020-06-16 04:33:09 | Espirito Santo, Brazil | ||
2020-06-15 | Philippines | 26420 | 1098 | 6252 | 19070 | 12.879721 | 121.77401699999999 | 2020-06-16 04:33:09 | Philippines | |||
2020-06-15 | Afghanistan | 25613 | 480 | 5164 | 19969 | 33.93911 | 67.709953 | 2020-06-16 04:33:09 | Afghanistan | |||
2020-06-15 | Ireland | 25321 | 1706 | 22698 | 917 | 53.1424 | -7.6921 | 2020-06-16 04:33:09 | Ireland | |||
2020-06-15 | Oman | 24524 | 108 | 9533 | 14883 | 21.512583 | 55.92325500000001 | 2020-06-16 04:33:09 | Oman | |||
2020-06-15 | US | Pennsylvania | Philadelphia | 42101 | 24341 | 1509 | 0 | 22832 | 40.00338507 | -75.1379271 | 2020-06-16 04:33:09 | Philadelphia, Pennsylvania, US |
2020-06-15 | India | Gujarat | 24055 | 1505 | 16664 | 5886 | 22.694884 | 71.590923 | 2020-06-16 04:33:09 | Gujarat, India | ||
2020-06-15 | Mexico | Mexico | 23726 | 2005 | 19436 | 2285 | 19.4969 | -99.7233 | 2020-06-16 04:33:09 | Mexico, Mexico | ||
2020-06-15 | Brazil | Distrito Federal | 23684 | 319 | 13878 | 9487 | -15.7998 | -47.8645 | 2020-06-16 04:33:09 | Distrito Federal, Brazil | ||
2020-06-15 | Dominican Republic | 23271 | 605 | 14025 | 8641 | 18.7357 | -70.1627 | 2020-06-16 04:33:09 | Dominican Republic | |||
2020-06-15 | US | Massachusetts | Middlesex | 25017 | 23227 | 1763 | 0 | 21464 | 42.48607732 | -71.39049229 | 2020-06-16 04:33:09 | Middlesex, Massachusetts, US |
2020-06-15 | Brazil | Alagoas | 22962 | 768 | 15169 | 7025 | -9.5713 | -36.782 | 2020-06-16 04:33:09 | Alagoas, Brazil | ||
2020-06-15 | US | Florida | Miami-Dade | 12086 | 22197 | 826 | 0 | 21371 | 25.6112362 | -80.55170587 | 2020-06-16 04:33:09 | Miami-Dade, Florida, US |
2020-06-15 | Romania | 22165 | 1427 | 15817 | 4921 | 45.9432 | 24.9668 | 2020-06-16 04:33:09 | Romania | |||
2020-06-15 | US | Michigan | Wayne | 26163 | 21793 | 2670 | 0 | 19123 | 42.28098405 | -83.281255 | 2020-06-16 04:33:09 | Wayne, Michigan, US |
2020-06-15 | Brazil | Minas Gerais | 21728 | 481 | 11553 | 9694 | -18.5122 | -44.555 | 2020-06-16 04:33:09 | Minas Gerais, Brazil | ||
2020-06-15 | Panama | 21422 | 448 | 13766 | 7208 | 8.538 | -80.7821 | 2020-06-16 04:33:09 | Panama | |||
2020-06-15 | Iraq | 21315 | 652 | 9271 | 11392 | 33.223191 | 43.679291 | 2020-06-16 04:33:09 | Iraq | |||
2020-06-15 | Russia | Saint Petersburg | 20813 | 635 | 9739 | 10439 | 59.9606739 | 30.158655100000004 | 2020-06-16 04:33:09 | Saint Petersburg, Russia | ||
2020-06-15 | US | Arizona | Maricopa | 4013 | 19372 | 557 | 0 | 18815 | 33.34835867 | -112.4918154 | 2020-06-16 04:33:09 | Maricopa, Arizona, US |
2020-06-15 | Spain | Castilla y Leon | 19353 | 1928 | 8716 | 8709 | 41.8357 | -4.3976 | 2020-06-16 04:33:09 | Castilla y Leon, Spain | ||
2020-06-15 | US | Massachusetts | Suffolk | 25025 | 19334 | 951 | 0 | 18383 | 42.3279514 | -71.07850442 | 2020-06-16 04:33:09 | Suffolk, Massachusetts, US |
2020-06-15 | Israel | 19334 | 305 | 15480 | 3549 | 31.046051000000002 | 34.851612 | 2020-06-16 04:33:09 | Israel | |||
2020-06-15 | US | New Jersey | Hudson | 34017 | 19276 | 1256 | 0 | 18020 | 40.73766234 | -74.07515667 | 2020-06-16 04:33:09 | Hudson, New Jersey, US |
2020-06-15 | Italy | Veneto | 19220 | 1978 | 16487 | 755 | 45.43490485 | 12.33845213 | 2020-06-16 04:33:09 | Veneto, Italy | ||
2020-06-15 | Bolivia | 19073 | 632 | 3430 | 15011 | -16.2902 | -63.5887 | 2020-06-16 04:33:09 | Bolivia | |||
2020-06-15 | Bahrain | 19013 | 46 | 13267 | 5700 | 26.0275 | 50.55 | 2020-06-16 04:33:09 | Bahrain | |||
2020-06-15 | US | New Jersey | Bergen | 34003 | 18949 | 1664 | 0 | 17285 | 40.96010917 | -74.07164325 | 2020-06-16 04:33:09 | Bergen, New Jersey, US |
2020-06-15 | Pakistan | Khyber Pakhtunkhwa | 18472 | 707 | 4692 | 13073 | 34.485332 | 72.09169 | 2020-06-16 04:33:09 | Khyber Pakhtunkhwa, Pakistan | ||
2020-06-15 | US | New Jersey | Essex | 34013 | 18434 | 1751 | 0 | 16683 | 40.78681335 | -74.24657979 | 2020-06-16 04:33:09 | Essex, New Jersey, US |
2020-06-15 | Spain | Castilla - La Mancha | 17811 | 2945 | 6392 | 8474 | 39.2796 | -3.0977 | 2020-06-16 04:33:09 | Castilla - La Mancha, Spain | ||
2020-06-15 | US | Maryland | Prince George's | 24033 | 17400 | 640 | 0 | 16760 | 38.83070039 | -76.8496441 | 2020-06-16 04:33:09 | Prince George's, Maryland, US |
2020-06-15 | Armenia | 17064 | 285 | 6276 | 10503 | 40.0691 | 45.0382 | 2020-06-16 04:33:09 | Armenia | |||
2020-06-15 | Austria | 17029 | 771 | 16066 | 391 | 47.5162 | 14.5501 | 2020-06-16 04:33:09 | Austria | |||
2020-06-15 | Brazil | Amapa | 16813 | 329 | 7460 | 9024 | 0.902 | -52.003 | 2020-06-16 04:33:09 | Amapa, Brazil | ||
2020-06-15 | US | New Jersey | Passaic | 34031 | 16694 | 1001 | 0 | 15693 | 41.03238628 | -74.29954144 | 2020-06-16 04:33:09 | Passaic, New Jersey, US |
2020-06-15 | Nigeria | 16658 | 424 | 5349 | 10885 | 9.082 | 8.6753 | 2020-06-16 04:33:09 | Nigeria | |||
2020-06-15 | US | New Jersey | Middlesex | 34023 | 16489 | 1083 | 0 | 15406 | 40.43629879 | -74.41426991 | 2020-06-16 04:33:09 | Middlesex, New Jersey, US |
2020-06-15 | Colombia | Capital District | 16404 | 416 | 6885 | 9103 | 4.711 | -74.0721 | 2020-06-16 04:33:09 | Capital District, Colombia | ||
2020-06-15 | US | New Jersey | Union | 34039 | 16368 | 1128 | 0 | 15240 | 40.65835409 | -74.30680092 | 2020-06-16 04:33:09 | Union, New Jersey, US |
2020-06-15 | US | Connecticut | Fairfield | 9001 | 16338 | 1347 | 0 | 14991 | 41.26809896 | -73.3881171 | 2020-06-16 04:33:09 | Fairfield, Connecticut, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;