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
day (date) >30 ✖
- 2020-08-11 3,979
- 2020-08-05 3,977
- 2020-08-06 3,977
- 2020-08-07 3,977
- 2020-08-08 3,977
- 2020-08-09 3,977
- 2020-08-10 3,977
- 2020-08-04 3,973
- 2020-07-29 3,972
- 2020-07-30 3,972
- 2020-07-31 3,972
- 2020-08-01 3,972
- 2020-08-02 3,972
- 2020-08-03 3,972
- 2020-07-28 3,969
- 2020-07-26 3,968
- 2020-07-27 3,968
- 2020-07-25 3,967
- 2020-07-24 3,966
- 2020-07-23 3,965
- 2020-07-22 3,962
- 2020-07-21 3,961
- 2020-07-20 3,958
- 2020-07-19 3,956
- 2020-07-18 3,955
- 2020-07-17 3,874
- 2020-07-16 3,861
- 2020-07-15 3,859
- 2020-07-14 3,858
- 2020-07-13 3,852
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
662001 | 662001 | 2020-08-11 | Afghanistan | 37355 | 1348 | 26415 | 9592 | 33.93911 | 67.709953 | 2020-08-12 04:27:29 | Afghanistan | |||
662002 | 662002 | 2020-08-11 | Albania | 6676 | 205 | 3480 | 2991 | 41.1533 | 20.1683 | 2020-08-12 04:27:29 | Albania | |||
662003 | 662003 | 2020-08-11 | Algeria | 36204 | 1322 | 25263 | 9619 | 28.0339 | 1.6596 | 2020-08-12 04:27:29 | Algeria | |||
662004 | 662004 | 2020-08-11 | Andorra | 963 | 52 | 839 | 72 | 42.5063 | 1.5218 | 2020-08-12 04:27:29 | Andorra | |||
662005 | 662005 | 2020-08-11 | Angola | 1735 | 80 | 575 | 1080 | -11.2027 | 17.8739 | 2020-08-12 04:27:29 | Angola | |||
662006 | 662006 | 2020-08-11 | Antigua and Barbuda | 92 | 3 | 76 | 13 | 17.0608 | -61.7964 | 2020-08-12 04:27:29 | Antigua and Barbuda | |||
662007 | 662007 | 2020-08-11 | Argentina | 260911 | 5004 | 181389 | 74518 | -38.4161 | -63.6167 | 2020-08-12 04:27:29 | Argentina | |||
662008 | 662008 | 2020-08-11 | Armenia | 40593 | 803 | 33157 | 6633 | 40.0691 | 45.0382 | 2020-08-12 04:27:29 | Armenia | |||
662009 | 662009 | 2020-08-11 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-12 04:27:29 | Australian Capital Territory, Australia | ||
662010 | 662010 | 2020-08-11 | Australia | New South Wales | 3915 | 50 | 0 | 3865 | -33.8688 | 151.2093 | 2020-08-12 04:27:29 | New South Wales, Australia | ||
662011 | 662011 | 2020-08-11 | Australia | Northern Territory | 33 | 0 | 31 | 2 | -12.4634 | 130.8456 | 2020-08-12 04:27:29 | Northern Territory, Australia | ||
662012 | 662012 | 2020-08-11 | Australia | Queensland | 1089 | 6 | 1076 | 7 | -27.4698 | 153.0251 | 2020-08-12 04:27:29 | Queensland, Australia | ||
662013 | 662013 | 2020-08-11 | Australia | South Australia | 459 | 4 | 447 | 8 | -34.9285 | 138.6007 | 2020-08-12 04:27:29 | South Australia, Australia | ||
662014 | 662014 | 2020-08-11 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-12 04:27:29 | Tasmania, Australia | ||
662015 | 662015 | 2020-08-11 | Australia | Victoria | 15646 | 267 | 6889 | 8490 | -37.8136 | 144.9631 | 2020-08-12 04:27:29 | Victoria, Australia | ||
662016 | 662016 | 2020-08-11 | Australia | Western Australia | 642 | 9 | 632 | 1 | -31.9505 | 115.8605 | 2020-08-12 04:27:29 | Western Australia, Australia | ||
662017 | 662017 | 2020-08-11 | Austria | 22038 | 873 | 20123 | 1399 | 47.5162 | 14.5501 | 2020-08-12 04:27:29 | Austria | |||
662018 | 662018 | 2020-08-11 | Azerbaijan | 33731 | 495 | 30856 | 2380 | 40.1431 | 47.5769 | 2020-08-12 04:27:29 | Azerbaijan | |||
662019 | 662019 | 2020-08-11 | Bahamas | 989 | 15 | 116 | 858 | 25.025885 | -78.035889 | 2020-08-12 04:27:29 | Bahamas | |||
662020 | 662020 | 2020-08-11 | Bahrain | 44804 | 165 | 41504 | 3135 | 26.0275 | 50.55 | 2020-08-12 04:27:29 | Bahrain | |||
662021 | 662021 | 2020-08-11 | Bangladesh | 263503 | 3471 | 151972 | 108060 | 23.685 | 90.3563 | 2020-08-12 04:27:29 | Bangladesh | |||
662022 | 662022 | 2020-08-11 | Barbados | 143 | 7 | 112 | 24 | 13.1939 | -59.5432 | 2020-08-12 04:27:29 | Barbados | |||
662023 | 662023 | 2020-08-11 | Belarus | 69005 | 592 | 65219 | 3194 | 53.7098 | 27.9534 | 2020-08-12 04:27:29 | Belarus | |||
662024 | 662024 | 2020-08-11 | Belgium | 75008 | 9885 | 17841 | 47282 | 50.8333 | 4.469936 | 2020-08-12 04:27:29 | Belgium | |||
662025 | 662025 | 2020-08-11 | Belize | 177 | 2 | 32 | 143 | 17.1899 | -88.4976 | 2020-08-12 04:27:29 | Belize | |||
662026 | 662026 | 2020-08-11 | Benin | 2001 | 38 | 1681 | 282 | 9.3077 | 2.3158 | 2020-08-12 04:27:29 | Benin | |||
662027 | 662027 | 2020-08-11 | Bhutan | 113 | 0 | 97 | 16 | 27.5142 | 90.4336 | 2020-08-12 04:27:29 | Bhutan | |||
662028 | 662028 | 2020-08-11 | Bolivia | 93328 | 3761 | 31753 | 57814 | -16.2902 | -63.5887 | 2020-08-12 04:27:29 | Bolivia | |||
662029 | 662029 | 2020-08-11 | Bosnia and Herzegovina | 14708 | 447 | 8411 | 5850 | 43.9159 | 17.6791 | 2020-08-12 04:27:29 | Bosnia and Herzegovina | |||
662030 | 662030 | 2020-08-11 | Botswana | 1066 | 2 | 80 | 984 | -22.3285 | 24.6849 | 2020-08-12 04:27:29 | Botswana | |||
662031 | 662031 | 2020-08-11 | Brazil | Acre | 21757 | 565 | 14932 | 6260 | -9.0238 | -70.812 | 2020-08-12 04:27:29 | Acre, Brazil | ||
662032 | 662032 | 2020-08-11 | Brazil | Alagoas | 68935 | 1700 | 62379 | 4856 | -9.5713 | -36.782 | 2020-08-12 04:27:29 | Alagoas, Brazil | ||
662033 | 662033 | 2020-08-11 | Brazil | Amapa | 38636 | 604 | 26337 | 11695 | 0.902 | -52.003 | 2020-08-12 04:27:29 | Amapa, Brazil | ||
662034 | 662034 | 2020-08-11 | Brazil | Amazonas | 108105 | 3405 | 91613 | 13087 | -3.4168 | -65.8561 | 2020-08-12 04:27:29 | Amazonas, Brazil | ||
662035 | 662035 | 2020-08-11 | Brazil | Bahia | 198767 | 4067 | 180488 | 14212 | -12.5797 | -41.7007 | 2020-08-12 04:27:29 | Bahia, Brazil | ||
662036 | 662036 | 2020-08-11 | Brazil | Ceara | 191540 | 8043 | 162744 | 19795 | -5.4984 | -39.3206 | 2020-08-12 04:27:29 | Ceara, Brazil | ||
662037 | 662037 | 2020-08-11 | Brazil | Distrito Federal | 127484 | 1815 | 109598 | 16071 | -15.7998 | -47.8645 | 2020-08-12 04:27:29 | Distrito Federal, Brazil | ||
662038 | 662038 | 2020-08-11 | Brazil | Espirito Santo | 94478 | 2783 | 80509 | 11184 | -19.1834 | -40.3089 | 2020-08-12 04:27:29 | Espirito Santo, Brazil | ||
662039 | 662039 | 2020-08-11 | Brazil | Goias | 91849 | 2122 | 82256 | 5871 | -15.827 | -49.8362 | 2020-08-12 04:27:29 | Goias, Brazil | ||
662040 | 662040 | 2020-08-11 | Brazil | Maranhao | 132060 | 3204 | 121843 | 7013 | -4.9609 | -45.2744 | 2020-08-12 04:27:29 | Maranhao, Brazil | ||
662041 | 662041 | 2020-08-11 | Brazil | Mato Grosso | 67144 | 2239 | 44520 | 20352 | -12.6819 | -56.9211 | 2020-08-12 04:27:29 | Mato Grosso, Brazil | ||
662042 | 662042 | 2020-08-11 | Brazil | Mato Grosso do Sul | 33509 | 558 | 26764 | 5254 | -20.7722 | -54.7852 | 2020-08-12 04:27:29 | Mato Grosso do Sul, Brazil | ||
662043 | 662043 | 2020-08-11 | Brazil | Minas Gerais | 156551 | 3613 | 125002 | 27936 | -18.5122 | -44.555 | 2020-08-12 04:27:29 | Minas Gerais, Brazil | ||
662044 | 662044 | 2020-08-11 | Brazil | Para | 171878 | 5909 | 156023 | 7689 | -1.9981 | -54.9306 | 2020-08-12 04:27:29 | Para, Brazil | ||
662045 | 662045 | 2020-08-11 | Brazil | Paraiba | 91819 | 2046 | 45744 | 44029 | -7.24 | -36.782 | 2020-08-12 04:27:29 | Paraiba, Brazil | ||
662046 | 662046 | 2020-08-11 | Brazil | Parana | 95943 | 2445 | 56077 | 37421 | -25.2521 | -52.0215 | 2020-08-12 04:27:29 | Parana, Brazil | ||
662047 | 662047 | 2020-08-11 | Brazil | Pernambuco | 105982 | 7008 | 85731 | 13243 | -8.8137 | -36.9541 | 2020-08-12 04:27:29 | Pernambuco, Brazil | ||
662048 | 662048 | 2020-08-11 | Brazil | Piaui | 62465 | 1548 | 60248 | 0 | -7.7183 | -42.7289 | 2020-08-12 04:27:29 | Piaui, Brazil | ||
662049 | 662049 | 2020-08-11 | Brazil | Rio de Janeiro | 182563 | 14212 | 163579 | 4772 | -22.9068 | -43.1729 | 2020-08-12 04:27:29 | Rio de Janeiro, Brazil | ||
662050 | 662050 | 2020-08-11 | Brazil | Rio Grande do Norte | 57921 | 2025 | 28243 | 27675 | -5.4026 | -36.9541 | 2020-08-12 04:27:29 | Rio Grande do Norte, Brazil | ||
662051 | 662051 | 2020-08-11 | Brazil | Rio Grande do Sul | 87415 | 2472 | 77551 | 7392 | -30.0346 | -51.2177 | 2020-08-12 04:27:29 | Rio Grande do Sul, Brazil | ||
662052 | 662052 | 2020-08-11 | Brazil | Rondonia | 45468 | 966 | 36680 | 7822 | -11.5057 | -63.5806 | 2020-08-12 04:27:29 | Rondonia, Brazil | ||
662053 | 662053 | 2020-08-11 | Brazil | Roraima | 37579 | 555 | 9113 | 27342 | -2.7376 | -62.0751 | 2020-08-12 04:27:29 | Roraima, Brazil | ||
662054 | 662054 | 2020-08-11 | Brazil | Santa Catarina | 109522 | 1619 | 97228 | 10675 | -27.2423 | -50.2189 | 2020-08-12 04:27:29 | Santa Catarina, Brazil | ||
662055 | 662055 | 2020-08-11 | Brazil | Sao Paulo | 639562 | 25571 | 437647 | 176344 | -23.5505 | -46.6333 | 2020-08-12 04:27:29 | Sao Paulo, Brazil | ||
662056 | 662056 | 2020-08-11 | Brazil | Sergipe | 65455 | 1633 | 46644 | 17178 | -10.5741 | -37.3857 | 2020-08-12 04:27:29 | Sergipe, Brazil | ||
662057 | 662057 | 2020-08-11 | Brazil | Tocantins | 33766 | 482 | 19845 | 12728 | -10.1753 | -48.2982 | 2020-08-12 04:27:29 | Tocantins, Brazil | ||
662058 | 662058 | 2020-08-11 | Brunei | 142 | 3 | 138 | 1 | 4.5353 | 114.7277 | 2020-08-12 04:27:29 | Brunei | |||
662059 | 662059 | 2020-08-11 | Bulgaria | 13722 | 471 | 8154 | 5097 | 42.7339 | 25.4858 | 2020-08-12 04:27:29 | Bulgaria | |||
662060 | 662060 | 2020-08-11 | Burkina Faso | 1211 | 54 | 990 | 167 | 12.2383 | -1.5616 | 2020-08-12 04:27:29 | Burkina Faso | |||
662061 | 662061 | 2020-08-11 | Burma | 360 | 6 | 313 | 41 | 21.9162 | 95.956 | 2020-08-12 04:27:29 | Burma | |||
662062 | 662062 | 2020-08-11 | Burundi | 408 | 1 | 315 | 92 | -3.3731 | 29.9189 | 2020-08-12 04:27:29 | Burundi | |||
662063 | 662063 | 2020-08-11 | Cabo Verde | 2920 | 33 | 2148 | 739 | 16.5388 | -23.0418 | 2020-08-12 04:27:29 | Cabo Verde | |||
662064 | 662064 | 2020-08-11 | Cambodia | 268 | 0 | 220 | 48 | 11.55 | 104.9167 | 2020-08-12 04:27:29 | Cambodia | |||
662065 | 662065 | 2020-08-11 | Cameroon | 18213 | 398 | 15320 | 2495 | 3.848 | 11.5021 | 2020-08-12 04:27:29 | Cameroon | |||
662066 | 662066 | 2020-08-11 | Canada | Alberta | 11772 | 216 | 10552 | 1004 | 53.9333 | -116.5765 | 2020-08-12 04:27:29 | Alberta, Canada | ||
662067 | 662067 | 2020-08-11 | Canada | British Columbia | 4111 | 195 | 3444 | 472 | 53.7267 | -127.6476 | 2020-08-12 04:27:29 | British Columbia, Canada | ||
662068 | 662068 | 2020-08-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-08-12 04:27:29 | Diamond Princess, Canada | ||
662069 | 662069 | 2020-08-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-08-12 04:27:29 | Grand Princess, Canada | ||
662070 | 662070 | 2020-08-11 | Canada | Manitoba | 562 | 8 | 360 | 194 | 53.7609 | -98.8139 | 2020-08-12 04:27:29 | Manitoba, Canada | ||
662071 | 662071 | 2020-08-11 | Canada | New Brunswick | 177 | 2 | 168 | 7 | 46.5653 | -66.4619 | 2020-08-12 04:27:29 | New Brunswick, Canada | ||
662072 | 662072 | 2020-08-11 | Canada | Newfoundland and Labrador | 268 | 3 | 263 | 2 | 53.1355 | -57.6604 | 2020-08-12 04:27:29 | Newfoundland and Labrador, Canada | ||
662073 | 662073 | 2020-08-11 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-08-12 04:27:29 | Northwest Territories,Canada | ||
662074 | 662074 | 2020-08-11 | Canada | Nova Scotia | 1071 | 64 | 1007 | 0 | 44.682 | -63.7443 | 2020-08-12 04:27:29 | Nova Scotia, Canada | ||
662075 | 662075 | 2020-08-11 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-08-12 04:27:29 | Nunavut, Canada | ||
662076 | 662076 | 2020-08-11 | Canada | Ontario | 40711 | 2786 | 38175 | 1155 | 51.2538 | -85.3232 | 2020-08-12 04:27:29 | Ontario, Canada | ||
662077 | 662077 | 2020-08-11 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-12 04:27:29 | Prince Edward Island, Canada | ||
662078 | 662078 | 2020-08-11 | Canada | Quebec | 60600 | 5739 | 53135 | 1726 | 52.9399 | -73.5491 | 2020-08-12 04:27:29 | Quebec, Canada | ||
662079 | 662079 | 2020-08-11 | Canada | Saskatchewan | 1479 | 20 | 1294 | 165 | 52.9399 | -106.4509 | 2020-08-12 04:27:29 | Saskatchewan, Canada | ||
662080 | 662080 | 2020-08-11 | Canada | Yukon | 15 | 0 | 13 | 2 | 64.2823 | -135.0 | 2020-08-12 04:27:29 | Yukon, Canada | ||
662081 | 662081 | 2020-08-11 | Central African Republic | 4645 | 61 | 1723 | 2861 | 6.6111 | 20.9394 | 2020-08-12 04:27:29 | Central African Republic | |||
662082 | 662082 | 2020-08-11 | Chad | 946 | 76 | 859 | 11 | 15.4542 | 18.7322 | 2020-08-12 04:27:29 | Chad | |||
662083 | 662083 | 2020-08-11 | Chile | Antofagasta | 16239 | 387 | 14674 | 1178 | -23.6509 | -70.3975 | 2020-08-12 04:27:29 | Antofagasta, Chile | ||
662084 | 662084 | 2020-08-11 | Chile | Araucania | 4455 | 83 | 4105 | 267 | -38.9489 | -72.3311 | 2020-08-12 04:27:29 | Araucania, Chile | ||
662085 | 662085 | 2020-08-11 | Chile | Arica y Parinacota | 5334 | 78 | 4519 | 737 | -18.594 | -69.4785 | 2020-08-12 04:27:29 | Arica y Parinacota, Chile | ||
662086 | 662086 | 2020-08-11 | Chile | Atacama | 3998 | 21 | 2962 | 1015 | -27.5661 | -70.0503 | 2020-08-12 04:27:29 | Atacama, Chile | ||
662087 | 662087 | 2020-08-11 | Chile | Aysen | 95 | 1 | 80 | 14 | -45.9864 | -73.7669 | 2020-08-12 04:27:29 | Aysen, Chile | ||
662088 | 662088 | 2020-08-11 | Chile | Biobio | 13174 | 143 | 11503 | 1528 | -37.4464 | -72.1416 | 2020-08-12 04:27:29 | Biobio, Chile | ||
662089 | 662089 | 2020-08-11 | Chile | Coquimbo | 7549 | 89 | 6532 | 928 | -29.959 | -71.3389 | 2020-08-12 04:27:29 | Coquimbo, Chile | ||
662090 | 662090 | 2020-08-11 | Chile | Los Lagos | 5053 | 54 | 4029 | 970 | -41.9198 | -72.1416 | 2020-08-12 04:27:29 | Los Lagos, Chile | ||
662091 | 662091 | 2020-08-11 | Chile | Los Rios | 981 | 15 | 892 | 74 | -40.231 | -72.3311 | 2020-08-12 04:27:29 | Los Rios, Chile | ||
662092 | 662092 | 2020-08-11 | Chile | Magallanes | 2109 | 30 | 1771 | 308 | -52.368 | -70.9863 | 2020-08-12 04:27:29 | Magallanes, Chile | ||
662093 | 662093 | 2020-08-11 | Chile | Maule | 9983 | 203 | 8970 | 810 | -35.5183 | -71.6885 | 2020-08-12 04:27:29 | Maule, Chile | ||
662094 | 662094 | 2020-08-11 | Chile | Metropolitana | 263095 | 7972 | 249276 | 5847 | -33.4376 | -70.6505 | 2020-08-12 04:27:29 | Metropolitana, Chile | ||
662095 | 662095 | 2020-08-11 | Chile | Nuble | 3843 | 69 | 3502 | 272 | -36.7226 | -71.7622 | 2020-08-12 04:27:29 | Nuble, Chile | ||
662096 | 662096 | 2020-08-11 | Chile | OHiggins | 11728 | 281 | 10524 | 923 | -34.5755 | -71.0022 | 2020-08-12 04:27:29 | OHiggins, Chile | ||
662097 | 662097 | 2020-08-11 | Chile | Tarapaca | 9543 | 182 | 8716 | 645 | -19.9232 | -69.5132 | 2020-08-12 04:27:29 | Tarapaca, Chile | ||
662098 | 662098 | 2020-08-11 | Chile | Unknown | 66 | 1 | 62 | 3 | 2020-08-12 04:27:29 | Unknown, Chile | ||||
662099 | 662099 | 2020-08-11 | Chile | Valparaiso | 19371 | 569 | 17424 | 1378 | -33.0472 | -71.6127 | 2020-08-12 04:27:29 | Valparaiso, Chile | ||
662100 | 662100 | 2020-08-11 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-08-12 04:27:29 | Anhui, China |
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]);