daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,778 rows where "day" is on date 2020-06-14 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-14 | US | New York | New York City | 36061 | 209878 | 22103 | 0 | 187775 | 40.76727260000001 | -73.97152637 | 2020-06-15 03:33:14 | New York City, New York, US |
2020-06-14 | Russia | Moscow | 205905 | 3281 | 121691 | 80933 | 55.7504461 | 37.6174943 | 2020-06-15 03:33:14 | Moscow, Russia | ||
2020-06-14 | France | 191991 | 29347 | 69820 | 92824 | 46.2276 | 2.2137 | 2020-06-15 03:33:14 | France | |||
2020-06-14 | Iran | 187427 | 8837 | 148674 | 29916 | 32.427908 | 53.68804599999999 | 2020-06-15 03:33:14 | Iran | |||
2020-06-14 | Turkey | 178239 | 4807 | 151417 | 22015 | 38.9637 | 35.2433 | 2020-06-15 03:33:14 | Turkey | |||
2020-06-14 | Brazil | Sao Paulo | 178202 | 10694 | 49295 | 118213 | -23.5505 | -46.6333 | 2020-06-15 03:33:14 | Sao Paulo, Brazil | ||
2020-06-14 | United Kingdom | England | 157074 | 47364 | 0 | 119808 | 52.3555 | -1.1743 | 2020-06-15 03:33:14 | England, United Kingdom | ||
2020-06-14 | Chile | Metropolitana | 140398 | 2878 | 0 | 137520 | -33.4376 | -70.6505 | 2020-06-15 03:33:14 | Metropolitana, Chile | ||
2020-06-14 | Peru | Lima | 132186 | 14374 | 0 | 117812 | -11.766533 | -76.60449799999998 | 2020-06-15 03:33:14 | Lima, Peru | ||
2020-06-14 | Saudi Arabia | 127541 | 972 | 84720 | 41849 | 23.885942 | 45.079162 | 2020-06-15 03:33:14 | Saudi Arabia | |||
2020-06-14 | India | Maharashtra | 104568 | 3830 | 49346 | 51392 | 19.449759 | 76.108221 | 2020-06-15 03:33:14 | Maharashtra, India | ||
2020-06-14 | United Kingdom | Unknown | 103470 | 70 | 0 | 103470 | 55.3781 | -3.436 | 2020-06-15 03:33:14 | Unknown, United Kingdom | ||
2020-06-14 | Italy | Lombardia | 91658 | 16449 | 59220 | 15989 | 45.46679409 | 9.190347404 | 2020-06-15 03:33:14 | Lombardia, Italy | ||
2020-06-14 | Bangladesh | 87520 | 1171 | 18730 | 67619 | 23.685 | 90.3563 | 2020-06-15 03:33:14 | Bangladesh | |||
2020-06-14 | US | Illinois | Cook | 17031 | 84906 | 4189 | 0 | 80717 | 41.84144849 | -87.81658794 | 2020-06-15 03:33:14 | Cook, Illinois, US |
2020-06-14 | Qatar | 79602 | 73 | 56898 | 22631 | 25.3548 | 51.1839 | 2020-06-15 03:33:14 | Qatar | |||
2020-06-14 | Brazil | Rio de Janeiro | 79572 | 7672 | 63817 | 8083 | -22.9068 | -43.1729 | 2020-06-15 03:33:14 | Rio de Janeiro, Brazil | ||
2020-06-14 | Brazil | Ceara | 76833 | 4885 | 56352 | 15535 | -5.4984 | -39.3206 | 2020-06-15 03:33:14 | Ceara, Brazil | ||
2020-06-14 | US | California | Los Angeles | 6037 | 73018 | 2907 | 0 | 70111 | 34.30828379 | -118.2282411 | 2020-06-15 03:33:14 | Los Angeles, California, US |
2020-06-14 | Spain | Madrid | 70521 | 8691 | 40736 | 21094 | 40.4168 | -3.7038 | 2020-06-15 03:33:14 | Madrid, Spain | ||
2020-06-14 | South Africa | 70038 | 1480 | 38531 | 30027 | -30.5595 | 22.9375 | 2020-06-15 03:33:14 | South Africa | |||
2020-06-14 | Brazil | Para | 69224 | 4201 | 57008 | 7980 | -1.9981 | -54.9306 | 2020-06-15 03:33:14 | Para, Brazil | ||
2020-06-14 | China | Hubei | 68135 | 4512 | 63623 | 0 | 30.9756 | 112.2707 | 2020-06-15 03:33:14 | Hubei, China | ||
2020-06-14 | Belgium | 60029 | 9655 | 16589 | 33785 | 50.8333 | 4.469936 | 2020-06-15 03:33:14 | Belgium | |||
2020-06-14 | Brazil | Maranhao | 59850 | 1467 | 34210 | 24173 | -4.9609 | -45.2744 | 2020-06-15 03:33:14 | Maranhao, Brazil | ||
2020-06-14 | Spain | Catalonia | 59820 | 5587 | 26203 | 28030 | 41.5912 | 1.5209 | 2020-06-15 03:33:14 | Catalonia, Spain | ||
2020-06-14 | Brazil | Amazonas | 56506 | 2492 | 45624 | 8390 | -3.4168 | -65.8561 | 2020-06-15 03:33:14 | Amazonas, Brazil | ||
2020-06-14 | Pakistan | Punjab | 54138 | 1031 | 17710 | 35397 | 30.811346 | 72.13913199999998 | 2020-06-15 03:33:14 | Punjab, Pakistan | ||
2020-06-14 | Belarus | 53973 | 308 | 30103 | 23562 | 53.7098 | 27.9534 | 2020-06-15 03:33:14 | Belarus | |||
2020-06-14 | Canada | Quebec | 53834 | 5493 | 21742 | 26599 | 52.9399 | -73.5491 | 2020-06-15 03:33:14 | Quebec, Canada | ||
2020-06-14 | Pakistan | Sindh | 53805 | 831 | 25606 | 27368 | 26.009446 | 68.77680699999999 | 2020-06-15 03:33:14 | Sindh, Pakistan | ||
2020-06-14 | Russia | Moscow Oblast | 49353 | 678 | 16573 | 32102 | 55.50431579999999 | 38.0353929 | 2020-06-15 03:33:14 | Moscow Oblast, Russia | ||
2020-06-14 | Netherlands | 48783 | 6059 | 0 | 42724 | 52.1326 | 5.2913 | 2020-06-15 03:33:14 | Netherlands | |||
2020-06-14 | Germany | Bayern | 47626 | 2541 | 44200 | 888 | 48.7904 | 11.4979 | 2020-06-15 03:33:14 | Bayern, Germany | ||
2020-06-14 | Ecuador | 46751 | 3896 | 23064 | 19791 | -1.8312 | -78.1834 | 2020-06-15 03:33:14 | Ecuador | |||
2020-06-14 | Brazil | Pernambuco | 45261 | 3855 | 28770 | 12636 | -8.8137 | -36.9541 | 2020-06-15 03:33:14 | Pernambuco, Brazil | ||
2020-06-14 | Egypt | 44598 | 1575 | 11931 | 31092 | 26.820553000000004 | 30.802497999999996 | 2020-06-15 03:33:14 | Egypt | |||
2020-06-14 | India | Tamil Nadu | 42687 | 397 | 23409 | 18881 | 11.006091 | 78.400624 | 2020-06-15 03:33:14 | Tamil Nadu, India | ||
2020-06-14 | United Arab Emirates | 42294 | 289 | 27462 | 14543 | 23.424076 | 53.847818000000004 | 2020-06-15 03:33:14 | United Arab Emirates | |||
2020-06-14 | US | New York | Nassau | 36059 | 41204 | 2165 | 0 | 39039 | 40.74066522 | -73.58941873 | 2020-06-15 03:33:14 | Nassau, New York, US |
2020-06-14 | US | New York | Suffolk | 36103 | 40659 | 1948 | 0 | 38711 | 40.88320119 | -72.8012172 | 2020-06-15 03:33:14 | Suffolk, New York, US |
2020-06-14 | Singapore | 40604 | 26 | 29589 | 10989 | 1.2833 | 103.8333 | 2020-06-15 03:33:14 | Singapore | |||
2020-06-14 | Germany | Nordrhein-Westfalen | 39233 | 1645 | 36100 | 1488 | 51.4332 | 7.6616 | 2020-06-15 03:33:14 | Nordrhein-Westfalen, Germany | ||
2020-06-14 | India | Delhi | 38958 | 1271 | 14945 | 22742 | 28.646519 | 77.10898 | 2020-06-15 03:33:14 | Delhi, India | ||
2020-06-14 | Indonesia | 38277 | 2134 | 14531 | 21612 | -0.7893 | 113.9213 | 2020-06-15 03:33:14 | Indonesia | |||
2020-06-14 | Mexico | Ciudad de Mexico | 36879 | 4553 | 27760 | 4566 | 19.4326 | -99.1332 | 2020-06-15 03:33:14 | Ciudad de Mexico, Mexico | ||
2020-06-14 | Portugal | 36690 | 1517 | 22669 | 12504 | 39.3999 | -8.2245 | 2020-06-15 03:33:14 | Portugal | |||
2020-06-14 | Brazil | Bahia | 36402 | 1105 | 15486 | 19810 | -12.5797 | -41.7007 | 2020-06-15 03:33:14 | Bahia, Brazil | ||
2020-06-14 | Kuwait | 35920 | 296 | 26759 | 8865 | 29.311659999999996 | 47.481766 | 2020-06-15 03:33:14 | Kuwait | |||
2020-06-14 | Germany | Baden-Wurttemberg | 35090 | 1805 | 32800 | 489 | 48.6616 | 9.3501 | 2020-06-15 03:33:14 | Baden-Wurttemberg, Germany | ||
2020-06-14 | US | New York | Westchester | 36119 | 34290 | 1404 | 0 | 32886 | 41.16278376 | -73.75741653 | 2020-06-15 03:33:14 | Westchester, New York, US |
2020-06-14 | Canada | Ontario | 32628 | 2519 | 27357 | 3859 | 51.2538 | -85.3232 | 2020-06-15 03:33:14 | Ontario, Canada | ||
2020-06-14 | Argentina | 31577 | 833 | 9564 | 21180 | -38.4161 | -63.6167 | 2020-06-15 03:33:14 | Argentina | |||
2020-06-14 | Switzerland | 31117 | 1802 | 28800 | 515 | 46.8182 | 8.2275 | 2020-06-15 03:33:14 | Switzerland | |||
2020-06-14 | Italy | Piemonte | 31059 | 4012 | 24399 | 2648 | 45.0732745 | 7.680687483 | 2020-06-15 03:33:14 | Piemonte, Italy | ||
2020-06-14 | US | Texas | Harris | 48201 | 30330 | 275 | 0 | 16503 | 29.86 | -95.39 | 2020-06-15 03:33:14 | Harris, Texas, US |
2020-06-14 | Poland | 29392 | 1247 | 14226 | 13919 | 51.9194 | 19.1451 | 2020-06-15 03:33:14 | Poland | |||
2020-06-14 | Italy | Emilia-Romagna | 28073 | 4204 | 22232 | 1637 | 44.49436681 | 11.341720800000001 | 2020-06-15 03:33:14 | Emilia-Romagna, Italy | ||
2020-06-14 | Brazil | Paraiba | 28013 | 633 | 6689 | 20691 | -7.24 | -36.782 | 2020-06-15 03:33:14 | Paraiba, Brazil | ||
2020-06-14 | Brazil | Espirito Santo | 26469 | 1055 | 14224 | 11163 | -19.1834 | -40.3089 | 2020-06-15 03:33:14 | Espirito Santo, Brazil | ||
2020-06-14 | Philippines | 25930 | 1088 | 5954 | 18888 | 12.879721 | 121.77401699999999 | 2020-06-15 03:33:14 | Philippines | |||
2020-06-14 | Ireland | 25303 | 1706 | 22698 | 899 | 53.1424 | -7.6921 | 2020-06-15 03:33:14 | Ireland | |||
2020-06-14 | Afghanistan | 24852 | 475 | 4725 | 19652 | 33.93911 | 67.709953 | 2020-06-15 03:33:14 | Afghanistan | |||
2020-06-14 | US | Pennsylvania | Philadelphia | 42101 | 24268 | 1505 | 0 | 22763 | 40.00338507 | -75.1379271 | 2020-06-15 03:33:14 | Philadelphia, Pennsylvania, US |
2020-06-14 | Oman | 23481 | 104 | 8454 | 14923 | 21.512583 | 55.92325500000001 | 2020-06-15 03:33:14 | Oman | |||
2020-06-14 | Mexico | Mexico | 23359 | 1952 | 18704 | 2703 | 19.4969 | -99.7233 | 2020-06-15 03:33:14 | Mexico, Mexico | ||
2020-06-14 | US | Massachusetts | Middlesex | 25017 | 23195 | 1756 | 0 | 21439 | 42.48607732 | -71.39049229 | 2020-06-15 03:33:14 | Middlesex, Massachusetts, US |
2020-06-14 | India | Gujarat | 23038 | 1448 | 15883 | 5707 | 22.694884 | 71.590923 | 2020-06-15 03:33:14 | Gujarat, India | ||
2020-06-14 | Dominican Republic | 22962 | 592 | 13320 | 9050 | 18.7357 | -70.1627 | 2020-06-15 03:33:14 | Dominican Republic | |||
2020-06-14 | Brazil | Distrito Federal | 22871 | 304 | 13194 | 9373 | -15.7998 | -47.8645 | 2020-06-15 03:33:14 | Distrito Federal, Brazil | ||
2020-06-14 | Brazil | Alagoas | 22199 | 744 | 14261 | 7194 | -9.5713 | -36.782 | 2020-06-15 03:33:14 | Alagoas, Brazil | ||
2020-06-14 | Romania | 21999 | 1410 | 15719 | 4870 | 45.9432 | 24.9668 | 2020-06-15 03:33:14 | Romania | |||
2020-06-14 | US | Florida | Miami-Dade | 12086 | 21917 | 825 | 0 | 21092 | 25.6112362 | -80.55170587 | 2020-06-15 03:33:14 | Miami-Dade, Florida, US |
2020-06-14 | US | Michigan | Wayne | 26163 | 21749 | 2670 | 0 | 19079 | 42.28098405 | -83.281255 | 2020-06-15 03:33:14 | Wayne, Michigan, US |
2020-06-14 | Panama | 21418 | 437 | 13766 | 7215 | 8.538 | -80.7821 | 2020-06-15 03:33:14 | Panama | |||
2020-06-14 | Brazil | Minas Gerais | 21381 | 475 | 11156 | 9750 | -18.5122 | -44.555 | 2020-06-15 03:33:14 | Minas Gerais, Brazil | ||
2020-06-14 | Russia | Saint Petersburg | 20561 | 597 | 9677 | 10287 | 59.9606739 | 30.158655100000004 | 2020-06-15 03:33:14 | Saint Petersburg, Russia | ||
2020-06-14 | Iraq | 20209 | 607 | 8121 | 11481 | 33.223191 | 43.679291 | 2020-06-15 03:33:14 | Iraq | |||
2020-06-14 | Spain | Castilla y Leon | 19343 | 1928 | 8716 | 8699 | 41.8357 | -4.3976 | 2020-06-15 03:33:14 | Castilla y Leon, Spain | ||
2020-06-14 | US | Massachusetts | Suffolk | 25025 | 19335 | 950 | 0 | 18385 | 42.3279514 | -71.07850442 | 2020-06-15 03:33:14 | Suffolk, Massachusetts, US |
2020-06-14 | US | New Jersey | Hudson | 34017 | 19253 | 1254 | 0 | 17999 | 40.73766234 | -74.07515667 | 2020-06-15 03:33:14 | Hudson, New Jersey, US |
2020-06-14 | Italy | Veneto | 19219 | 1978 | 16469 | 772 | 45.43490485 | 12.33845213 | 2020-06-15 03:33:14 | Veneto, Italy | ||
2020-06-14 | Israel | 19136 | 305 | 15386 | 3445 | 31.046051000000002 | 34.851612 | 2020-06-15 03:33:14 | Israel | |||
2020-06-14 | US | New Jersey | Bergen | 34003 | 18919 | 1664 | 0 | 17255 | 40.96010917 | -74.07164325 | 2020-06-15 03:33:14 | Bergen, New Jersey, US |
2020-06-14 | US | Arizona | Maricopa | 4013 | 18692 | 551 | 0 | 18141 | 33.34835867 | -112.4918154 | 2020-06-15 03:33:14 | Maricopa, Arizona, US |
2020-06-14 | Bolivia | 18459 | 611 | 3113 | 14735 | -16.2902 | -63.5887 | 2020-06-15 03:33:14 | Bolivia | |||
2020-06-14 | US | New Jersey | Essex | 34013 | 18419 | 1745 | 0 | 16674 | 40.78681335 | -74.24657979 | 2020-06-15 03:33:14 | Essex, New Jersey, US |
2020-06-14 | Bahrain | 18227 | 42 | 12818 | 5367 | 26.0275 | 50.55 | 2020-06-15 03:33:14 | Bahrain | |||
2020-06-14 | Pakistan | Khyber Pakhtunkhwa | 18013 | 675 | 4539 | 12799 | 34.485332 | 72.09169 | 2020-06-15 03:33:14 | Khyber Pakhtunkhwa, Pakistan | ||
2020-06-14 | Spain | Castilla - La Mancha | 17803 | 2945 | 6392 | 8466 | 39.2796 | -3.0977 | 2020-06-15 03:33:14 | Castilla - La Mancha, Spain | ||
2020-06-14 | US | Maryland | Prince George's | 24033 | 17326 | 637 | 0 | 16689 | 38.83070039 | -76.8496441 | 2020-06-15 03:33:14 | Prince George's, Maryland, US |
2020-06-14 | Austria | 17007 | 770 | 16059 | 373 | 47.5162 | 14.5501 | 2020-06-15 03:33:14 | Austria | |||
2020-06-14 | US | New Jersey | Passaic | 34031 | 16671 | 999 | 0 | 15672 | 41.03238628 | -74.29954144 | 2020-06-15 03:33:14 | Passaic, New Jersey, US |
2020-06-14 | Armenia | 16667 | 269 | 6214 | 10184 | 40.0691 | 45.0382 | 2020-06-15 03:33:14 | Armenia | |||
2020-06-14 | Brazil | Amapa | 16512 | 324 | 7363 | 8825 | 0.902 | -52.003 | 2020-06-15 03:33:14 | Amapa, Brazil | ||
2020-06-14 | US | New Jersey | Middlesex | 34023 | 16461 | 1076 | 0 | 15385 | 40.43629879 | -74.41426991 | 2020-06-15 03:33:14 | Middlesex, New Jersey, US |
2020-06-14 | US | New Jersey | Union | 34039 | 16376 | 1126 | 0 | 15250 | 40.65835409 | -74.30680092 | 2020-06-15 03:33:14 | Union, New Jersey, US |
2020-06-14 | US | Connecticut | Fairfield | 9001 | 16306 | 1346 | 0 | 14960 | 41.26809896 | -73.3881171 | 2020-06-15 03:33:14 | Fairfield, Connecticut, US |
2020-06-14 | Nigeria | 16085 | 420 | 5220 | 10445 | 9.082 | 8.6753 | 2020-06-15 03:33:14 | Nigeria | |||
2020-06-14 | Sweden | Stockholm | 15971 | 2186 | 0 | 13785 | 59.6025 | 18.1384 | 2020-06-15 03:33:14 | Stockholm, Sweden |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;