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, last_update
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3381062 | 3381062 | 2021-06-13 | Afghanistan | 89861 | 3527 | 61410 | 24924 | 33.93911 | 67.709953 | 2021-06-14 04:22:46 | Afghanistan | |||
3381063 | 3381063 | 2021-06-13 | Albania | 132459 | 2453 | 129842 | 164 | 41.1533 | 20.1683 | 2021-06-14 04:22:46 | Albania | |||
3381064 | 3381064 | 2021-06-13 | Algeria | 133388 | 3571 | 92852 | 36965 | 28.0339 | 1.6596 | 2021-06-14 04:22:46 | Algeria | |||
3381065 | 3381065 | 2021-06-13 | Andorra | 13813 | 127 | 13591 | 95 | 42.5063 | 1.5218 | 2021-06-14 04:22:46 | Andorra | |||
3381066 | 3381066 | 2021-06-13 | Angola | 36705 | 831 | 30282 | 5592 | -11.2027 | 17.8739 | 2021-06-14 04:22:46 | Angola | |||
3381067 | 3381067 | 2021-06-13 | Antigua and Barbuda | 1263 | 42 | 1214 | 7 | 17.0608 | -61.7964 | 2021-06-14 04:22:46 | Antigua and Barbuda | |||
3381068 | 3381068 | 2021-06-13 | Argentina | 4124190 | 85343 | 3721350 | 317497 | -38.4161 | -63.6167 | 2021-06-14 04:22:46 | Argentina | |||
3381069 | 3381069 | 2021-06-13 | Armenia | 223682 | 4484 | 215195 | 4003 | 40.0691 | 45.0382 | 2021-06-14 04:22:46 | Armenia | |||
3381070 | 3381070 | 2021-06-13 | Australia | Australian Capital Territory | 124 | 3 | 121 | 0 | -35.4735 | 149.0124 | 2021-06-14 04:22:46 | Australian Capital Territory, Australia | ||
3381071 | 3381071 | 2021-06-13 | Australia | New South Wales | 5619 | 54 | 0 | 5565 | -33.8688 | 151.2093 | 2021-06-14 04:22:46 | New South Wales, Australia | ||
3381072 | 3381072 | 2021-06-13 | Australia | Northern Territory | 175 | 0 | 172 | 3 | -12.4634 | 130.8456 | 2021-06-14 04:22:46 | Northern Territory, Australia | ||
3381073 | 3381073 | 2021-06-13 | Australia | Queensland | 1652 | 7 | 1603 | 42 | -27.4698 | 153.0251 | 2021-06-14 04:22:46 | Queensland, Australia | ||
3381074 | 3381074 | 2021-06-13 | Australia | South Australia | 775 | 4 | 768 | 3 | -34.9285 | 138.6007 | 2021-06-14 04:22:46 | South Australia, Australia | ||
3381075 | 3381075 | 2021-06-13 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-06-14 04:22:46 | Tasmania, Australia | ||
3381076 | 3381076 | 2021-06-13 | Australia | Victoria | 20665 | 820 | 19782 | 63 | -37.8136 | 144.9631 | 2021-06-14 04:22:46 | Victoria, Australia | ||
3381077 | 3381077 | 2021-06-13 | Australia | Western Australia | 1018 | 9 | 1009 | 0 | -31.9505 | 115.8605 | 2021-06-14 04:22:46 | Western Australia, Australia | ||
3381078 | 3381078 | 2021-06-13 | Austria | 643851 | 13007 | 633939 | 4020 | 47.5162 | 14.5501 | 2021-06-14 04:22:46 | Austria | |||
3381079 | 3381079 | 2021-06-13 | Azerbaijan | 335171 | 4953 | 328580 | 1638 | 40.1431 | 47.5769 | 2021-06-14 04:22:46 | Azerbaijan | |||
3381080 | 3381080 | 2021-06-13 | Bahamas | 12092 | 236 | 11081 | 775 | 25.025885 | -78.035889 | 2021-06-14 04:22:46 | Bahamas | |||
3381081 | 3381081 | 2021-06-13 | Bahrain | 258731 | 1221 | 244579 | 12931 | 26.0275 | 50.55 | 2021-06-14 04:22:46 | Bahrain | |||
3381082 | 3381082 | 2021-06-13 | Bangladesh | 826922 | 13118 | 766266 | 47538 | 23.685 | 90.3563 | 2021-06-14 04:22:46 | Bangladesh | |||
3381083 | 3381083 | 2021-06-13 | Barbados | 4036 | 47 | 3971 | 18 | 13.1939 | -59.5432 | 2021-06-14 04:22:46 | Barbados | |||
3381084 | 3381084 | 2021-06-13 | Belarus | 405663 | 2978 | 398742 | 3943 | 53.7098 | 27.9534 | 2021-06-14 04:22:46 | Belarus | |||
3381085 | 3381085 | 2021-06-13 | Belgium | Antwerp | 140155 | 0 | 0 | 140155 | 51.2195 | 4.4024 | 2021-06-14 04:22:46 | Antwerp, Belgium | ||
3381086 | 3381086 | 2021-06-13 | Belgium | Brussels | 132336 | 0 | 0 | 132336 | 50.8503 | 4.3517 | 2021-06-14 04:22:46 | Brussels, Belgium | ||
3381087 | 3381087 | 2021-06-13 | Belgium | East Flanders | 123303 | 0 | 0 | 123303 | 51.0362 | 3.7373 | 2021-06-14 04:22:46 | East Flanders, Belgium | ||
3381088 | 3381088 | 2021-06-13 | Belgium | Flemish Brabant | 81898 | 0 | 0 | 81898 | 50.9167 | 4.5833 | 2021-06-14 04:22:46 | Flemish Brabant, Belgium | ||
3381089 | 3381089 | 2021-06-13 | Belgium | Hainaut | 158722 | 0 | 0 | 158722 | 50.5257 | 4.0621 | 2021-06-14 04:22:46 | Hainaut, Belgium | ||
3381090 | 3381090 | 2021-06-13 | Belgium | Liege | 129833 | 0 | 0 | 129833 | 50.4496 | 5.8492 | 2021-06-14 04:22:46 | Liege, Belgium | ||
3381091 | 3381091 | 2021-06-13 | Belgium | Limburg | 60700 | 0 | 0 | 60700 | 50.9739 | 5.3420000000000005 | 2021-06-14 04:22:46 | Limburg, Belgium | ||
3381092 | 3381092 | 2021-06-13 | Belgium | Luxembourg | 31148 | 0 | 0 | 31148 | 50.0547 | 5.4677 | 2021-06-14 04:22:46 | Luxembourg, Belgium | ||
3381093 | 3381093 | 2021-06-13 | Belgium | Namur | 59087 | 0 | 0 | 59087 | 50.331 | 4.8221 | 2021-06-14 04:22:46 | Namur, Belgium | ||
3381094 | 3381094 | 2021-06-13 | Belgium | Unknown | 20662 | 25088 | 0 | 0 | 2021-06-14 04:22:46 | Unknown, Belgium | ||||
3381095 | 3381095 | 2021-06-13 | Belgium | Walloon Brabant | 41389 | 0 | 0 | 41389 | 50.4 | 4.35 | 2021-06-14 04:22:46 | Walloon Brabant, Belgium | ||
3381096 | 3381096 | 2021-06-13 | Belgium | West Flanders | 97105 | 0 | 0 | 97105 | 51.0536 | 3.1458 | 2021-06-14 04:22:46 | West Flanders, Belgium | ||
3381097 | 3381097 | 2021-06-13 | Belize | 12938 | 325 | 12463 | 150 | 17.1899 | -88.4976 | 2021-06-14 04:22:46 | Belize | |||
3381098 | 3381098 | 2021-06-13 | Benin | 8109 | 102 | 7979 | 28 | 9.3077 | 2.3158 | 2021-06-14 04:22:46 | Benin | |||
3381099 | 3381099 | 2021-06-13 | Bhutan | 1813 | 1 | 1467 | 345 | 27.5142 | 90.4336 | 2021-06-14 04:22:46 | Bhutan | |||
3381100 | 3381100 | 2021-06-13 | Bolivia | 406954 | 15542 | 321665 | 69747 | -16.2902 | -63.5887 | 2021-06-14 04:22:46 | Bolivia | |||
3381101 | 3381101 | 2021-06-13 | Bosnia and Herzegovina | 204597 | 9479 | 177122 | 17996 | 43.9159 | 17.6791 | 2021-06-14 04:22:46 | Bosnia and Herzegovina | |||
3381102 | 3381102 | 2021-06-13 | Botswana | 59480 | 896 | 55617 | 2967 | -22.3285 | 24.6849 | 2021-06-14 04:22:46 | Botswana | |||
3381103 | 3381103 | 2021-06-13 | Brazil | Acre | 84174 | 1712 | 78886 | 3576 | -9.0238 | -70.812 | 2021-06-14 04:22:46 | Acre, Brazil | ||
3381104 | 3381104 | 2021-06-13 | Brazil | Alagoas | 203226 | 5002 | 193222 | 5002 | -9.5713 | -36.782 | 2021-06-14 04:22:46 | Alagoas, Brazil | ||
3381105 | 3381105 | 2021-06-13 | Brazil | Amapa | 113940 | 1762 | 89782 | 22396 | 0.902 | -52.003 | 2021-06-14 04:22:46 | Amapa, Brazil | ||
3381106 | 3381106 | 2021-06-13 | Brazil | Amazonas | 393492 | 13140 | 337529 | 42823 | -3.4168 | -65.8561 | 2021-06-14 04:22:46 | Amazonas, Brazil | ||
3381107 | 3381107 | 2021-06-13 | Brazil | Bahia | 1064747 | 22513 | 1028604 | 13630 | -12.5797 | -41.7007 | 2021-06-14 04:22:46 | Bahia, Brazil | ||
3381108 | 3381108 | 2021-06-13 | Brazil | Ceara | 845411 | 21379 | 588565 | 231336 | -5.4984 | -39.3206 | 2021-06-14 04:22:46 | Ceara, Brazil | ||
3381109 | 3381109 | 2021-06-13 | Brazil | Distrito Federal | 417279 | 8955 | 398721 | 9603 | -15.7998 | -47.8645 | 2021-06-14 04:22:46 | Distrito Federal, Brazil | ||
3381110 | 3381110 | 2021-06-13 | Brazil | Espirito Santo | 498530 | 11143 | 471639 | 15713 | -19.1834 | -40.3089 | 2021-06-14 04:22:46 | Espirito Santo, Brazil | ||
3381111 | 3381111 | 2021-06-13 | Brazil | Goias | 638468 | 17962 | 608666 | 11662 | -15.827 | -49.8362 | 2021-06-14 04:22:46 | Goias, Brazil | ||
3381112 | 3381112 | 2021-06-13 | Brazil | Maranhao | 301238 | 8544 | 263493 | 29201 | -4.9609 | -45.2744 | 2021-06-14 04:22:46 | Maranhao, Brazil | ||
3381113 | 3381113 | 2021-06-13 | Brazil | Mato Grosso | 427979 | 11417 | 401968 | 12295 | -12.6819 | -56.9211 | 2021-06-14 04:22:46 | Mato Grosso, Brazil | ||
3381114 | 3381114 | 2021-06-13 | Brazil | Mato Grosso do Sul | 314445 | 7517 | 286440 | 19613 | -20.7722 | -54.7852 | 2021-06-14 04:22:46 | Mato Grosso do Sul, Brazil | ||
3381115 | 3381115 | 2021-06-13 | Brazil | Minas Gerais | 1683100 | 43124 | 1545235 | 94741 | -18.5122 | -44.555 | 2021-06-14 04:22:46 | Minas Gerais, Brazil | ||
3381116 | 3381116 | 2021-06-13 | Brazil | Para | 534072 | 14972 | 498695 | 20290 | -1.9981 | -54.9306 | 2021-06-14 04:22:46 | Para, Brazil | ||
3381117 | 3381117 | 2021-06-13 | Brazil | Paraiba | 358860 | 8128 | 236555 | 114177 | -7.24 | -36.782 | 2021-06-14 04:22:46 | Paraiba, Brazil | ||
3381118 | 3381118 | 2021-06-13 | Brazil | Parana | 1149679 | 28135 | 804907 | 316637 | -25.2521 | -52.0215 | 2021-06-14 04:22:46 | Parana, Brazil | ||
3381119 | 3381119 | 2021-06-13 | Brazil | Pernambuco | 519577 | 16828 | 432119 | 70630 | -8.8137 | -36.9541 | 2021-06-14 04:22:46 | Pernambuco, Brazil | ||
3381120 | 3381120 | 2021-06-13 | Brazil | Piaui | 285036 | 6240 | 277980 | 580 | -7.7183 | -42.7289 | 2021-06-14 04:22:46 | Piaui, Brazil | ||
3381121 | 3381121 | 2021-06-13 | Brazil | Rio Grande do Norte | 284328 | 6473 | 150649 | 125723 | -5.4026 | -36.9541 | 2021-06-14 04:22:46 | Rio Grande do Norte, Brazil | ||
3381122 | 3381122 | 2021-06-13 | Brazil | Rio Grande do Sul | 1148734 | 29672 | 1098059 | 21003 | -30.0346 | -51.2177 | 2021-06-14 04:22:46 | Rio Grande do Sul, Brazil | ||
3381123 | 3381123 | 2021-06-13 | Brazil | Rio de Janeiro | 905821 | 52998 | 842522 | 10301 | -22.9068 | -43.1729 | 2021-06-14 04:22:46 | Rio de Janeiro, Brazil | ||
3381124 | 3381124 | 2021-06-13 | Brazil | Rondonia | 238112 | 5916 | 224353 | 7843 | -11.5057 | -63.5806 | 2021-06-14 04:22:46 | Rondonia, Brazil | ||
3381125 | 3381125 | 2021-06-13 | Brazil | Roraima | 107646 | 1679 | 101156 | 4735 | -2.7376 | -62.0751 | 2021-06-14 04:22:46 | Roraima, Brazil | ||
3381126 | 3381126 | 2021-06-13 | Brazil | Santa Catarina | 1006090 | 15964 | 966868 | 23258 | -27.2423 | -50.2189 | 2021-06-14 04:22:46 | Santa Catarina, Brazil | ||
3381127 | 3381127 | 2021-06-13 | Brazil | Sao Paulo | 3458849 | 118121 | 3075383 | 265345 | -23.5505 | -46.6333 | 2021-06-14 04:22:46 | Sao Paulo, Brazil | ||
3381128 | 3381128 | 2021-06-13 | Brazil | Sergipe | 251851 | 5381 | 230141 | 16329 | -10.5741 | -37.3857 | 2021-06-14 04:22:46 | Sergipe, Brazil | ||
3381129 | 3381129 | 2021-06-13 | Brazil | Tocantins | 188252 | 3029 | 168032 | 16754 | -10.1753 | -48.2982 | 2021-06-14 04:22:46 | Tocantins, Brazil | ||
3381130 | 3381130 | 2021-06-13 | Brunei | 248 | 3 | 239 | 6 | 4.5353 | 114.7277 | 2021-06-14 04:22:46 | Brunei | |||
3381131 | 3381131 | 2021-06-13 | Bulgaria | 420336 | 17900 | 389495 | 12941 | 42.7339 | 25.4858 | 2021-06-14 04:22:46 | Bulgaria | |||
3381132 | 3381132 | 2021-06-13 | Burkina Faso | 13459 | 167 | 13272 | 20 | 12.2383 | -1.5616 | 2021-06-14 04:22:46 | Burkina Faso | |||
3381133 | 3381133 | 2021-06-13 | Burma | 145603 | 3244 | 132928 | 9431 | 21.9162 | 95.956 | 2021-06-14 04:22:46 | Burma | |||
3381134 | 3381134 | 2021-06-13 | Burundi | 5013 | 8 | 773 | 4232 | -3.3731 | 29.9189 | 2021-06-14 04:22:46 | Burundi | |||
3381135 | 3381135 | 2021-06-13 | Cabo Verde | 31571 | 273 | 30316 | 982 | 16.5388 | -23.0418 | 2021-06-14 04:22:46 | Cabo Verde | |||
3381136 | 3381136 | 2021-06-13 | Cambodia | 38427 | 335 | 31858 | 6234 | 11.55 | 104.9167 | 2021-06-14 04:22:46 | Cambodia | |||
3381137 | 3381137 | 2021-06-13 | Cameroon | 80090 | 1310 | 35261 | 43519 | 3.848 | 11.5021 | 2021-06-14 04:22:46 | Cameroon | |||
3381138 | 3381138 | 2021-06-13 | Canada | Alberta | 230463 | 2270 | 225013 | 3180 | 53.9333 | -116.5765 | 2021-06-14 04:22:46 | Alberta, Canada | ||
3381139 | 3381139 | 2021-06-13 | Canada | British Columbia | 146176 | 1730 | 142526 | 1920 | 53.7267 | -127.6476 | 2021-06-14 04:22:46 | British Columbia, Canada | ||
3381140 | 3381140 | 2021-06-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3381141 | 3381141 | 2021-06-13 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3381142 | 3381142 | 2021-06-13 | Canada | Manitoba | 54357 | 1100 | 49952 | 3305 | 53.7609 | -98.8139 | 2021-06-14 04:22:46 | Manitoba, Canada | ||
3381143 | 3381143 | 2021-06-13 | Canada | New Brunswick | 2298 | 45 | 2155 | 98 | 46.5653 | -66.4619 | 2021-06-14 04:22:46 | New Brunswick, Canada | ||
3381144 | 3381144 | 2021-06-13 | Canada | Newfoundland and Labrador | 1375 | 7 | 1329 | 39 | 53.1355 | -57.6604 | 2021-06-14 04:22:46 | Newfoundland and Labrador, Canada | ||
3381145 | 3381145 | 2021-06-13 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-14 04:22:46 | Northwest Territories,Canada | ||
3381146 | 3381146 | 2021-06-13 | Canada | Nova Scotia | 5742 | 89 | 5513 | 140 | 44.682 | -63.7443 | 2021-06-14 04:22:46 | Nova Scotia, Canada | ||
3381147 | 3381147 | 2021-06-13 | Canada | Nunavut | 657 | 4 | 644 | 9 | 70.2998 | -83.1076 | 2021-06-14 04:22:46 | Nunavut, Canada | ||
3381148 | 3381148 | 2021-06-13 | Canada | Ontario | 544180 | 8957 | 532339 | 5738 | 51.2538 | -85.3232 | 2021-06-14 04:22:46 | Ontario, Canada | ||
3381149 | 3381149 | 2021-06-13 | Canada | Prince Edward Island | 206 | 0 | 202 | 4 | 46.5107 | -63.4168 | 2021-06-14 04:22:46 | Prince Edward Island, Canada | ||
3381150 | 3381150 | 2021-06-13 | Canada | Quebec | 373402 | 11172 | 359981 | 2249 | 52.9399 | -73.5491 | 2021-06-14 04:22:46 | Quebec, Canada | ||
3381151 | 3381151 | 2021-06-13 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-14 04:22:46 | Repatriated Travellers, Canada | ||||
3381152 | 3381152 | 2021-06-13 | Canada | Saskatchewan | 47941 | 555 | 46577 | 809 | 52.9399 | -106.4509 | 2021-06-14 04:22:46 | Saskatchewan, Canada | ||
3381153 | 3381153 | 2021-06-13 | Canada | Yukon | 104 | 2 | 84 | 18 | 64.2823 | -135.0 | 2021-06-14 04:22:46 | Yukon, Canada | ||
3381154 | 3381154 | 2021-06-13 | Central African Republic | 7101 | 98 | 6859 | 144 | 6.6111 | 20.9394 | 2021-06-14 04:22:46 | Central African Republic | |||
3381155 | 3381155 | 2021-06-13 | Chad | 4942 | 174 | 4767 | 1 | 15.4542 | 18.7322 | 2021-06-14 04:22:46 | Chad | |||
3381156 | 3381156 | 2021-06-13 | Chile | Antofagasta | 55347 | 1079 | 53221 | 1047 | -23.6509 | -70.3975 | 2021-06-14 04:22:46 | Antofagasta, Chile | ||
3381157 | 3381157 | 2021-06-13 | Chile | Araucania | 87763 | 1136 | 84325 | 2302 | -38.9489 | -72.3311 | 2021-06-14 04:22:46 | Araucania, Chile | ||
3381158 | 3381158 | 2021-06-13 | Chile | Arica y Parinacota | 23834 | 462 | 22739 | 633 | -18.594 | -69.4785 | 2021-06-14 04:22:46 | Arica y Parinacota, Chile | ||
3381159 | 3381159 | 2021-06-13 | Chile | Atacama | 22913 | 257 | 21899 | 757 | -27.5661 | -70.0503 | 2021-06-14 04:22:46 | Atacama, Chile | ||
3381160 | 3381160 | 2021-06-13 | Chile | Aysen | 6888 | 47 | 6397 | 444 | -45.9864 | -73.7669 | 2021-06-14 04:22:46 | Aysen, Chile | ||
3381161 | 3381161 | 2021-06-13 | Chile | Biobio | 137192 | 2200 | 131480 | 3512 | -37.4464 | -72.1416 | 2021-06-14 04:22:46 | Biobio, Chile |
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]);