daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,014 rows where "day" is on date 2021-01-23 sorted by day
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-01-23 | Afghanistan | 54559 | 2373 | 46943 | 5243 | 33.93911 | 67.709953 | 2021-01-24 05:22:35 | Afghanistan | |||
2021-01-23 | Albania | 71441 | 1310 | 43384 | 26747 | 41.1533 | 20.1683 | 2021-01-24 05:22:35 | Albania | |||
2021-01-23 | Algeria | 105369 | 2861 | 71755 | 30753 | 28.0339 | 1.6596 | 2021-01-24 05:22:35 | Algeria | |||
2021-01-23 | Andorra | 9499 | 96 | 8588 | 815 | 42.5063 | 1.5218 | 2021-01-24 05:22:35 | Andorra | |||
2021-01-23 | Angola | 19367 | 457 | 17249 | 1661 | -11.2027 | 17.8739 | 2021-01-24 05:22:35 | Angola | |||
2021-01-23 | Antigua and Barbuda | 195 | 6 | 162 | 27 | 17.0608 | -61.7964 | 2021-01-24 05:22:35 | Antigua and Barbuda | |||
2021-01-23 | Argentina | 1862192 | 46737 | 1646668 | 168787 | -38.4161 | -63.6167 | 2021-01-24 05:22:35 | Argentina | |||
2021-01-23 | Armenia | 165909 | 3034 | 154535 | 8340 | 40.0691 | 45.0382 | 2021-01-24 05:22:35 | Armenia | |||
2021-01-23 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-24 05:22:35 | Australian Capital Territory, Australia | ||
2021-01-23 | Australia | New South Wales | 5087 | 54 | 0 | 5033 | -33.8688 | 151.2093 | 2021-01-24 05:22:35 | New South Wales, Australia | ||
2021-01-23 | Australia | Northern Territory | 98 | 0 | 90 | 8 | -12.4634 | 130.8456 | 2021-01-24 05:22:35 | Northern Territory, Australia | ||
2021-01-23 | Australia | Queensland | 1303 | 6 | 1272 | 25 | -27.4698 | 153.0251 | 2021-01-24 05:22:35 | Queensland, Australia | ||
2021-01-23 | Australia | South Australia | 596 | 4 | 591 | 1 | -34.9285 | 138.6007 | 2021-01-24 05:22:35 | South Australia, Australia | ||
2021-01-23 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-24 05:22:35 | Tasmania, Australia | ||
2021-01-23 | Australia | Victoria | 20436 | 820 | 19586 | 30 | -37.8136 | 144.9631 | 2021-01-24 05:22:35 | Victoria, Australia | ||
2021-01-23 | Australia | Western Australia | 894 | 9 | 873 | 12 | -31.9505 | 115.8605 | 2021-01-24 05:22:35 | Western Australia, Australia | ||
2021-01-23 | Austria | 398234 | 8951 | 380248 | 15875 | 47.5162 | 14.5501 | 2021-01-24 05:22:35 | Austria | |||
2021-01-23 | Azerbaijan | 228688 | 3072 | 219724 | 5892 | 40.1431 | 47.5769 | 2021-01-24 05:22:35 | Azerbaijan | |||
2021-01-23 | Bahamas | 8101 | 175 | 6720 | 1206 | 25.025885 | -78.035889 | 2021-01-24 05:22:35 | Bahamas | |||
2021-01-23 | Bahrain | 99456 | 367 | 96112 | 2977 | 26.0275 | 50.55 | 2021-01-24 05:22:35 | Bahrain | |||
2021-01-23 | Bangladesh | 531326 | 8003 | 475899 | 47424 | 23.685 | 90.3563 | 2021-01-24 05:22:35 | Bangladesh | |||
2021-01-23 | Barbados | 1341 | 9 | 622 | 710 | 13.1939 | -59.5432 | 2021-01-24 05:22:35 | Barbados | |||
2021-01-23 | Belarus | 235859 | 1639 | 220912 | 13308 | 53.7098 | 27.9534 | 2021-01-24 05:22:35 | Belarus | |||
2021-01-23 | Belgium | Antwerp | 86058 | 0 | 0 | 86058 | 51.2195 | 4.4024 | 2021-01-24 05:22:35 | Antwerp, Belgium | ||
2021-01-23 | Belgium | Brussels | 86507 | 0 | 0 | 86507 | 50.8503 | 4.3517 | 2021-01-24 05:22:35 | Brussels, Belgium | ||
2021-01-23 | Belgium | East Flanders | 71294 | 0 | 0 | 71294 | 51.0362 | 3.7373 | 2021-01-24 05:22:35 | East Flanders, Belgium | ||
2021-01-23 | Belgium | Flemish Brabant | 52647 | 0 | 0 | 52647 | 50.9167 | 4.5833 | 2021-01-24 05:22:35 | Flemish Brabant, Belgium | ||
2021-01-23 | Belgium | Hainaut | 106981 | 0 | 0 | 106981 | 50.5257 | 4.0621 | 2021-01-24 05:22:35 | Hainaut, Belgium | ||
2021-01-23 | Belgium | Liege | 100243 | 0 | 0 | 100243 | 50.4496 | 5.8492 | 2021-01-24 05:22:35 | Liege, Belgium | ||
2021-01-23 | Belgium | Limburg | 32925 | 0 | 0 | 32925 | 50.9739 | 5.3420000000000005 | 2021-01-24 05:22:35 | Limburg, Belgium | ||
2021-01-23 | Belgium | Luxembourg | 19505 | 0 | 0 | 19505 | 50.0547 | 5.4677 | 2021-01-24 05:22:35 | Luxembourg, Belgium | ||
2021-01-23 | Belgium | Namur | 36948 | 0 | 0 | 36948 | 50.331 | 4.8221 | 2021-01-24 05:22:35 | Namur, Belgium | ||
2021-01-23 | Belgium | Unknown | 12178 | 20726 | 0 | 0 | 2021-01-24 05:22:35 | Unknown, Belgium | ||||
2021-01-23 | Belgium | Walloon Brabant | 26684 | 0 | 0 | 26684 | 50.4 | 4.35 | 2021-01-24 05:22:35 | Walloon Brabant, Belgium | ||
2021-01-23 | Belgium | West Flanders | 59884 | 0 | 0 | 59884 | 51.0536 | 3.1458 | 2021-01-24 05:22:35 | West Flanders, Belgium | ||
2021-01-23 | Belize | 11722 | 290 | 11050 | 382 | 17.1899 | -88.4976 | 2021-01-24 05:22:35 | Belize | |||
2021-01-23 | Benin | 3643 | 48 | 3317 | 278 | 9.3077 | 2.3158 | 2021-01-24 05:22:35 | Benin | |||
2021-01-23 | Bhutan | 854 | 1 | 702 | 151 | 27.5142 | 90.4336 | 2021-01-24 05:22:35 | Bhutan | |||
2021-01-23 | Bolivia | 199989 | 9927 | 149895 | 40167 | -16.2902 | -63.5887 | 2021-01-24 05:22:35 | Bolivia | |||
2021-01-23 | Bosnia and Herzegovina | 119420 | 4555 | 90691 | 24174 | 43.9159 | 17.6791 | 2021-01-24 05:22:35 | Bosnia and Herzegovina | |||
2021-01-23 | Botswana | 19654 | 105 | 15911 | 3638 | -22.3285 | 24.6849 | 2021-01-24 05:22:35 | Botswana | |||
2021-01-23 | Brazil | Acre | 46239 | 848 | 39095 | 6296 | -9.0238 | -70.812 | 2021-01-24 05:22:35 | Acre, Brazil | ||
2021-01-23 | Brazil | Alagoas | 113662 | 2674 | 107976 | 3012 | -9.5713 | -36.782 | 2021-01-24 05:22:35 | Alagoas, Brazil | ||
2021-01-23 | Brazil | Amapa | 75054 | 1025 | 57084 | 16945 | 0.902 | -52.003 | 2021-01-24 05:22:35 | Amapa, Brazil | ||
2021-01-23 | Brazil | Amazonas | 248561 | 7051 | 207742 | 33768 | -3.4168 | -65.8561 | 2021-01-24 05:22:35 | Amazonas, Brazil | ||
2021-01-23 | Brazil | Bahia | 562466 | 9827 | 541416 | 11223 | -12.5797 | -41.7007 | 2021-01-24 05:22:35 | Bahia, Brazil | ||
2021-01-23 | Brazil | Ceara | 362351 | 10331 | 281679 | 68974 | -5.4984 | -39.3206 | 2021-01-24 05:22:35 | Ceara, Brazil | ||
2021-01-23 | Brazil | Distrito Federal | 269350 | 4468 | 257079 | 7803 | -15.7998 | -47.8645 | 2021-01-24 05:22:35 | Distrito Federal, Brazil | ||
2021-01-23 | Brazil | Espirito Santo | 284854 | 5658 | 265274 | 13909 | -19.1834 | -40.3089 | 2021-01-24 05:22:35 | Espirito Santo, Brazil | ||
2021-01-23 | Brazil | Goias | 338076 | 7282 | 325286 | 5410 | -15.827 | -49.8362 | 2021-01-24 05:22:35 | Goias, Brazil | ||
2021-01-23 | Brazil | Maranhao | 205396 | 4644 | 193936 | 6816 | -4.9609 | -45.2744 | 2021-01-24 05:22:35 | Maranhao, Brazil | ||
2021-01-23 | Brazil | Mato Grosso | 207747 | 4954 | 191831 | 9885 | -12.6819 | -56.9211 | 2021-01-24 05:22:35 | Mato Grosso, Brazil | ||
2021-01-23 | Brazil | Mato Grosso do Sul | 156459 | 2812 | 140908 | 12270 | -20.7722 | -54.7852 | 2021-01-24 05:22:35 | Mato Grosso do Sul, Brazil | ||
2021-01-23 | Brazil | Minas Gerais | 686682 | 14148 | 608858 | 63676 | -18.5122 | -44.555 | 2021-01-24 05:22:35 | Minas Gerais, Brazil | ||
2021-01-23 | Brazil | Para | 318777 | 7499 | 297936 | 12453 | -1.9981 | -54.9306 | 2021-01-24 05:22:35 | Para, Brazil | ||
2021-01-23 | Brazil | Paraiba | 182907 | 3968 | 138676 | 40263 | -7.24 | -36.782 | 2021-01-24 05:22:35 | Paraiba, Brazil | ||
2021-01-23 | Brazil | Parana | 522169 | 9355 | 379394 | 133420 | -25.2521 | -52.0215 | 2021-01-24 05:22:35 | Parana, Brazil | ||
2021-01-23 | Brazil | Pernambuco | 250165 | 10177 | 211038 | 28950 | -8.8137 | -36.9541 | 2021-01-24 05:22:35 | Pernambuco, Brazil | ||
2021-01-23 | Brazil | Piaui | 155362 | 3004 | 151914 | 192 | -7.7183 | -42.7289 | 2021-01-24 05:22:35 | Piaui, Brazil | ||
2021-01-23 | Brazil | Rio Grande do Norte | 135774 | 3247 | 95604 | 36047 | -5.4026 | -36.9541 | 2021-01-24 05:22:35 | Rio Grande do Norte, Brazil | ||
2021-01-23 | Brazil | Rio Grande do Sul | 527182 | 10299 | 500724 | 16159 | -30.0346 | -51.2177 | 2021-01-24 05:22:35 | Rio Grande do Sul, Brazil | ||
2021-01-23 | Brazil | Rio de Janeiro | 500185 | 28812 | 460121 | 11252 | -22.9068 | -43.1729 | 2021-01-24 05:22:35 | Rio de Janeiro, Brazil | ||
2021-01-23 | Brazil | Rondonia | 116133 | 2097 | 94677 | 19359 | -11.5057 | -63.5806 | 2021-01-24 05:22:35 | Rondonia, Brazil | ||
2021-01-23 | Brazil | Roraima | 72313 | 821 | 68373 | 2933 | -2.7376 | -62.0751 | 2021-01-24 05:22:35 | Roraima, Brazil | ||
2021-01-23 | Brazil | Santa Catarina | 557774 | 6097 | 531991 | 19686 | -27.2423 | -50.2189 | 2021-01-24 05:22:35 | Santa Catarina, Brazil | ||
2021-01-23 | Brazil | Sao Paulo | 1694355 | 51423 | 1420484 | 222448 | -23.5505 | -46.6333 | 2021-01-24 05:22:35 | Sao Paulo, Brazil | ||
2021-01-23 | Brazil | Sergipe | 132337 | 2719 | 119170 | 10448 | -10.5741 | -37.3857 | 2021-01-24 05:22:35 | Sergipe, Brazil | ||
2021-01-23 | Brazil | Tocantins | 99485 | 1347 | 87662 | 10284 | -10.1753 | -48.2982 | 2021-01-24 05:22:35 | Tocantins, Brazil | ||
2021-01-23 | Brunei | 175 | 3 | 169 | 3 | 4.5353 | 114.7277 | 2021-01-24 05:22:35 | Brunei | |||
2021-01-23 | Bulgaria | 214696 | 8811 | 178888 | 26997 | 42.7339 | 25.4858 | 2021-01-24 05:22:35 | Bulgaria | |||
2021-01-23 | Burkina Faso | 9967 | 109 | 7988 | 1870 | 12.2383 | -1.5616 | 2021-01-24 05:22:35 | Burkina Faso | |||
2021-01-23 | Burma | 137098 | 3045 | 121124 | 12929 | 21.9162 | 95.956 | 2021-01-24 05:22:35 | Burma | |||
2021-01-23 | Burundi | 1438 | 2 | 773 | 663 | -3.3731 | 29.9189 | 2021-01-24 05:22:35 | Burundi | |||
2021-01-23 | Cabo Verde | 13414 | 124 | 12646 | 644 | 16.5388 | -23.0418 | 2021-01-24 05:22:35 | Cabo Verde | |||
2021-01-23 | Cambodia | 458 | 0 | 405 | 53 | 11.55 | 104.9167 | 2021-01-24 05:22:35 | Cambodia | |||
2021-01-23 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-01-24 05:22:35 | Cameroon | |||
2021-01-23 | Canada | Alberta | 120330 | 1525 | 109078 | 9727 | 53.9333 | -116.5765 | 2021-01-24 05:22:35 | Alberta, Canada | ||
2021-01-23 | Canada | British Columbia | 63484 | 1128 | 56455 | 5901 | 53.7267 | -127.6476 | 2021-01-24 05:22:35 | British Columbia, Canada | ||
2021-01-23 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2021-01-23 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2021-01-23 | Canada | Manitoba | 28476 | 797 | 24307 | 3372 | 53.7609 | -98.8139 | 2021-01-24 05:22:35 | Manitoba, Canada | ||
2021-01-23 | Canada | New Brunswick | 1104 | 13 | 762 | 329 | 46.5653 | -66.4619 | 2021-01-24 05:22:35 | New Brunswick, Canada | ||
2021-01-23 | Canada | Newfoundland and Labrador | 398 | 4 | 386 | 8 | 53.1355 | -57.6604 | 2021-01-24 05:22:35 | Newfoundland and Labrador, Canada | ||
2021-01-23 | Canada | Northwest Territories | 31 | 0 | 24 | 7 | 64.8255 | -124.8457 | 2021-01-24 05:22:35 | Northwest Territories,Canada | ||
2021-01-23 | Canada | Nova Scotia | 1570 | 65 | 1483 | 22 | 44.682 | -63.7443 | 2021-01-24 05:22:35 | Nova Scotia, Canada | ||
2021-01-23 | Canada | Nunavut | 267 | 1 | 264 | 2 | 70.2998 | -83.1076 | 2021-01-24 05:22:35 | Nunavut, Canada | ||
2021-01-23 | Canada | Ontario | 257847 | 5753 | 228722 | 22917 | 51.2538 | -85.3232 | 2021-01-24 05:22:35 | Ontario, Canada | ||
2021-01-23 | Canada | Prince Edward Island | 110 | 0 | 103 | 7 | 46.5107 | -63.4168 | 2021-01-24 05:22:35 | Prince Edward Island, Canada | ||
2021-01-23 | Canada | Quebec | 252937 | 9443 | 223367 | 20127 | 52.9399 | -73.5491 | 2021-01-24 05:22:35 | Quebec, Canada | ||
2021-01-23 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-24 05:22:35 | Repatriated Travellers, Canada | ||||
2021-01-23 | Canada | Saskatchewan | 21917 | 250 | 18506 | 3161 | 52.9399 | -106.4509 | 2021-01-24 05:22:35 | Saskatchewan, Canada | ||
2021-01-23 | Canada | Yukon | 70 | 1 | 69 | 0 | 64.2823 | -135.0 | 2021-01-24 05:22:35 | Yukon, Canada | ||
2021-01-23 | Central African Republic | 4974 | 63 | 4885 | 26 | 6.6111 | 20.9394 | 2021-01-24 05:22:35 | Central African Republic | |||
2021-01-23 | Chad | 3137 | 115 | 2240 | 782 | 15.4542 | 18.7322 | 2021-01-24 05:22:35 | Chad | |||
2021-01-23 | Chile | Antofagasta | 29285 | 615 | 26645 | 2025 | -23.6509 | -70.3975 | 2021-01-24 05:22:35 | Antofagasta, Chile | ||
2021-01-23 | Chile | Araucania | 29386 | 379 | 27338 | 1669 | -38.9489 | -72.3311 | 2021-01-24 05:22:35 | Araucania, Chile | ||
2021-01-23 | Chile | Arica y Parinacota | 12251 | 250 | 11399 | 602 | -18.594 | -69.4785 | 2021-01-24 05:22:35 | Arica y Parinacota, Chile | ||
2021-01-23 | Chile | Atacama | 9602 | 123 | 9114 | 365 | -27.5661 | -70.0503 | 2021-01-24 05:22:35 | Atacama, Chile | ||
2021-01-23 | Chile | Aysen | 2265 | 18 | 2032 | 215 | -45.9864 | -73.7669 | 2021-01-24 05:22:35 | Aysen, Chile | ||
2021-01-23 | Chile | Biobio | 57766 | 992 | 53492 | 3282 | -37.4464 | -72.1416 | 2021-01-24 05:22:35 | Biobio, Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;