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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1615930 | 1615930 | 2021-03-05 | Afghanistan | 55827 | 2449 | 49362 | 4016 | 33.93911 | 67.709953 | 2021-03-06 04:23:41 | Afghanistan | |||
1615931 | 1615931 | 2021-03-05 | Albania | 111301 | 1897 | 73610 | 35794 | 41.1533 | 20.1683 | 2021-03-06 04:23:41 | Albania | |||
1615932 | 1615932 | 2021-03-05 | Algeria | 113948 | 3007 | 78824 | 32117 | 28.0339 | 1.6596 | 2021-03-06 04:23:41 | Algeria | |||
1615933 | 1615933 | 2021-03-05 | Andorra | 10998 | 112 | 10584 | 302 | 42.5063 | 1.5218 | 2021-03-06 04:23:41 | Andorra | |||
1615934 | 1615934 | 2021-03-05 | Angola | 21026 | 511 | 19624 | 891 | -11.2027 | 17.8739 | 2021-03-06 04:23:41 | Angola | |||
1615935 | 1615935 | 2021-03-05 | Antigua and Barbuda | 813 | 21 | 355 | 437 | 17.0608 | -61.7964 | 2021-03-06 04:23:41 | Antigua and Barbuda | |||
1615936 | 1615936 | 2021-03-05 | Argentina | 2141854 | 52784 | 1934845 | 154225 | -38.4161 | -63.6167 | 2021-03-06 04:23:41 | Argentina | |||
1615937 | 1615937 | 2021-03-05 | Armenia | 173749 | 3215 | 164463 | 6071 | 40.0691 | 45.0382 | 2021-03-06 04:23:41 | Armenia | |||
1615938 | 1615938 | 2021-03-05 | Australia | Australian Capital Territory | 120 | 3 | 115 | 2 | -35.4735 | 149.0124 | 2021-03-06 04:23:41 | Australian Capital Territory, Australia | ||
1615939 | 1615939 | 2021-03-05 | Australia | New South Wales | 5207 | 54 | 0 | 5153 | -33.8688 | 151.2093 | 2021-03-06 04:23:41 | New South Wales, Australia | ||
1615940 | 1615940 | 2021-03-05 | Australia | Northern Territory | 105 | 0 | 105 | 0 | -12.4634 | 130.8456 | 2021-03-06 04:23:41 | Northern Territory, Australia | ||
1615941 | 1615941 | 2021-03-05 | Australia | Queensland | 1347 | 6 | 1316 | 25 | -27.4698 | 153.0251 | 2021-03-06 04:23:41 | Queensland, Australia | ||
1615942 | 1615942 | 2021-03-05 | Australia | South Australia | 618 | 4 | 610 | 4 | -34.9285 | 138.6007 | 2021-03-06 04:23:41 | South Australia, Australia | ||
1615943 | 1615943 | 2021-03-05 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-03-06 04:23:41 | Tasmania, Australia | ||
1615944 | 1615944 | 2021-03-05 | Australia | Victoria | 20482 | 820 | 19656 | 6 | -37.8136 | 144.9631 | 2021-03-06 04:23:41 | Victoria, Australia | ||
1615945 | 1615945 | 2021-03-05 | Australia | Western Australia | 916 | 9 | 903 | 4 | -31.9505 | 115.8605 | 2021-03-06 04:23:41 | Western Australia, Australia | ||
1615946 | 1615946 | 2021-03-05 | Austria | 463314 | 10576 | 439101 | 22544 | 47.5162 | 14.5501 | 2021-03-06 04:23:41 | Austria | |||
1615947 | 1615947 | 2021-03-05 | Azerbaijan | 236012 | 3235 | 229442 | 3335 | 40.1431 | 47.5769 | 2021-03-06 04:23:41 | Azerbaijan | |||
1615948 | 1615948 | 2021-03-05 | Bahamas | 8600 | 181 | 7415 | 1004 | 25.025885 | -78.035889 | 2021-03-06 04:23:41 | Bahamas | |||
1615949 | 1615949 | 2021-03-05 | Bahrain | 125514 | 468 | 118301 | 6745 | 26.0275 | 50.55 | 2021-03-06 04:23:41 | Bahrain | |||
1615950 | 1615950 | 2021-03-05 | Bangladesh | 549184 | 8441 | 501144 | 39599 | 23.685 | 90.3563 | 2021-03-06 04:23:41 | Bangladesh | |||
1615951 | 1615951 | 2021-03-05 | Barbados | 3217 | 37 | 2690 | 490 | 13.1939 | -59.5432 | 2021-03-06 04:23:41 | Barbados | |||
1615952 | 1615952 | 2021-03-05 | Belarus | 293103 | 2020 | 283508 | 7575 | 53.7098 | 27.9534 | 2021-03-06 04:23:41 | Belarus | |||
1615953 | 1615953 | 2021-03-05 | Belgium | Antwerp | 98637 | 0 | 0 | 98637 | 51.2195 | 4.4024 | 2021-03-06 04:23:41 | Antwerp, Belgium | ||
1615954 | 1615954 | 2021-03-05 | Belgium | Brussels | 96995 | 0 | 0 | 96995 | 50.8503 | 4.3517 | 2021-03-06 04:23:41 | Brussels, Belgium | ||
1615955 | 1615955 | 2021-03-05 | Belgium | East Flanders | 85194 | 0 | 0 | 85194 | 51.0362 | 3.7373 | 2021-03-06 04:23:41 | East Flanders, Belgium | ||
1615956 | 1615956 | 2021-03-05 | Belgium | Flemish Brabant | 60508 | 0 | 0 | 60508 | 50.9167 | 4.5833 | 2021-03-06 04:23:41 | Flemish Brabant, Belgium | ||
1615957 | 1615957 | 2021-03-05 | Belgium | Hainaut | 117983 | 0 | 0 | 117983 | 50.5257 | 4.0621 | 2021-03-06 04:23:41 | Hainaut, Belgium | ||
1615958 | 1615958 | 2021-03-05 | Belgium | Liege | 106159 | 0 | 0 | 106159 | 50.4496 | 5.8492 | 2021-03-06 04:23:41 | Liege, Belgium | ||
1615959 | 1615959 | 2021-03-05 | Belgium | Limburg | 39112 | 0 | 0 | 39112 | 50.9739 | 5.3420000000000005 | 2021-03-06 04:23:41 | Limburg, Belgium | ||
1615960 | 1615960 | 2021-03-05 | Belgium | Luxembourg | 22185 | 0 | 0 | 22185 | 50.0547 | 5.4677 | 2021-03-06 04:23:41 | Luxembourg, Belgium | ||
1615961 | 1615961 | 2021-03-05 | Belgium | Namur | 41030 | 0 | 0 | 41030 | 50.331 | 4.8221 | 2021-03-06 04:23:41 | Namur, Belgium | ||
1615962 | 1615962 | 2021-03-05 | Belgium | Unknown | 14500 | 22215 | 0 | 0 | 2021-03-06 04:23:41 | Unknown, Belgium | ||||
1615963 | 1615963 | 2021-03-05 | Belgium | Walloon Brabant | 30422 | 0 | 0 | 30422 | 50.4 | 4.35 | 2021-03-06 04:23:41 | Walloon Brabant, Belgium | ||
1615964 | 1615964 | 2021-03-05 | Belgium | West Flanders | 70285 | 0 | 0 | 70285 | 51.0536 | 3.1458 | 2021-03-06 04:23:41 | West Flanders, Belgium | ||
1615965 | 1615965 | 2021-03-05 | Belize | 12335 | 315 | 11926 | 94 | 17.1899 | -88.4976 | 2021-03-06 04:23:41 | Belize | |||
1615966 | 1615966 | 2021-03-05 | Benin | 6071 | 75 | 4963 | 1033 | 9.3077 | 2.3158 | 2021-03-06 04:23:41 | Benin | |||
1615967 | 1615967 | 2021-03-05 | Bhutan | 867 | 1 | 866 | 0 | 27.5142 | 90.4336 | 2021-03-06 04:23:41 | Bhutan | |||
1615968 | 1615968 | 2021-03-05 | Bolivia | 253297 | 11789 | 196731 | 44777 | -16.2902 | -63.5887 | 2021-03-06 04:23:41 | Bolivia | |||
1615969 | 1615969 | 2021-03-05 | Bosnia and Herzegovina | 135513 | 5228 | 117885 | 12400 | 43.9159 | 17.6791 | 2021-03-06 04:23:41 | Bosnia and Herzegovina | |||
1615970 | 1615970 | 2021-03-05 | Botswana | 31746 | 359 | 26760 | 4627 | -22.3285 | 24.6849 | 2021-03-06 04:23:41 | Botswana | |||
1615971 | 1615971 | 2021-03-05 | Brazil | Acre | 59500 | 1047 | 51346 | 7107 | -9.0238 | -70.812 | 2021-03-06 04:23:41 | Acre, Brazil | ||
1615972 | 1615972 | 2021-03-05 | Brazil | Alagoas | 134423 | 3064 | 127580 | 3779 | -9.5713 | -36.782 | 2021-03-06 04:23:41 | Alagoas, Brazil | ||
1615973 | 1615973 | 2021-03-05 | Brazil | Amapa | 85065 | 1156 | 63071 | 20838 | 0.902 | -52.003 | 2021-03-06 04:23:41 | Amapa, Brazil | ||
1615974 | 1615974 | 2021-03-05 | Brazil | Amazonas | 322227 | 11229 | 272889 | 38109 | -3.4168 | -65.8561 | 2021-03-06 04:23:41 | Amazonas, Brazil | ||
1615975 | 1615975 | 2021-03-05 | Brazil | Bahia | 706375 | 12353 | 671789 | 22233 | -12.5797 | -41.7007 | 2021-03-06 04:23:41 | Bahia, Brazil | ||
1615976 | 1615976 | 2021-03-05 | Brazil | Ceara | 441484 | 11642 | 321045 | 107612 | -5.4984 | -39.3206 | 2021-03-06 04:23:41 | Ceara, Brazil | ||
1615977 | 1615977 | 2021-03-05 | Brazil | Distrito Federal | 303685 | 4933 | 286382 | 12370 | -15.7998 | -47.8645 | 2021-03-06 04:23:41 | Distrito Federal, Brazil | ||
1615978 | 1615978 | 2021-03-05 | Brazil | Espirito Santo | 332890 | 6526 | 314512 | 11768 | -19.1834 | -40.3089 | 2021-03-06 04:23:41 | Espirito Santo, Brazil | ||
1615979 | 1615979 | 2021-03-05 | Brazil | Goias | 412205 | 8881 | 391013 | 11192 | -15.827 | -49.8362 | 2021-03-06 04:23:41 | Goias, Brazil | ||
1615980 | 1615980 | 2021-03-05 | Brazil | Maranhao | 222481 | 5201 | 206320 | 10960 | -4.9609 | -45.2744 | 2021-03-06 04:23:41 | Maranhao, Brazil | ||
1615981 | 1615981 | 2021-03-05 | Brazil | Mato Grosso | 259946 | 5968 | 242204 | 9783 | -12.6819 | -56.9211 | 2021-03-06 04:23:41 | Mato Grosso, Brazil | ||
1615982 | 1615982 | 2021-03-05 | Brazil | Mato Grosso do Sul | 187073 | 3431 | 172910 | 9557 | -20.7722 | -54.7852 | 2021-03-06 04:23:41 | Mato Grosso do Sul, Brazil | ||
1615983 | 1615983 | 2021-03-05 | Brazil | Minas Gerais | 908869 | 19204 | 826955 | 62710 | -18.5122 | -44.555 | 2021-03-06 04:23:41 | Minas Gerais, Brazil | ||
1615984 | 1615984 | 2021-03-05 | Brazil | Para | 372488 | 8875 | 347980 | 14428 | -1.9981 | -54.9306 | 2021-03-06 04:23:41 | Para, Brazil | ||
1615985 | 1615985 | 2021-03-05 | Brazil | Paraiba | 226536 | 4632 | 164712 | 57192 | -7.24 | -36.782 | 2021-03-06 04:23:41 | Paraiba, Brazil | ||
1615986 | 1615986 | 2021-03-05 | Brazil | Parana | 672179 | 12196 | 480234 | 179749 | -25.2521 | -52.0215 | 2021-03-06 04:23:41 | Parana, Brazil | ||
1615987 | 1615987 | 2021-03-05 | Brazil | Pernambuco | 306320 | 11119 | 263727 | 31474 | -8.8137 | -36.9541 | 2021-03-06 04:23:41 | Pernambuco, Brazil | ||
1615988 | 1615988 | 2021-03-05 | Brazil | Piaui | 178539 | 3447 | 174280 | 0 | -7.7183 | -42.7289 | 2021-03-06 04:23:41 | Piaui, Brazil | ||
1615989 | 1615989 | 2021-03-05 | Brazil | Rio Grande do Norte | 173249 | 3735 | 123516 | 44718 | -5.4026 | -36.9541 | 2021-03-06 04:23:41 | Rio Grande do Norte, Brazil | ||
1615990 | 1615990 | 2021-03-05 | Brazil | Rio Grande do Sul | 676576 | 13188 | 623181 | 40207 | -30.0346 | -51.2177 | 2021-03-06 04:23:41 | Rio Grande do Sul, Brazil | ||
1615991 | 1615991 | 2021-03-05 | Brazil | Rio de Janeiro | 591945 | 33607 | 553067 | 5271 | -22.9068 | -43.1729 | 2021-03-06 04:23:41 | Rio de Janeiro, Brazil | ||
1615992 | 1615992 | 2021-03-05 | Brazil | Rondonia | 155471 | 3040 | 135593 | 16838 | -11.5057 | -63.5806 | 2021-03-06 04:23:41 | Rondonia, Brazil | ||
1615993 | 1615993 | 2021-03-05 | Brazil | Roraima | 83745 | 1167 | 77828 | 4464 | -2.7376 | -62.0751 | 2021-03-06 04:23:41 | Roraima, Brazil | ||
1615994 | 1615994 | 2021-03-05 | Brazil | Santa Catarina | 700127 | 7816 | 654155 | 38156 | -27.2423 | -50.2189 | 2021-03-06 04:23:41 | Santa Catarina, Brazil | ||
1615995 | 1615995 | 2021-03-05 | Brazil | Sao Paulo | 2093924 | 61064 | 1852904 | 179956 | -23.5505 | -46.6333 | 2021-03-06 04:23:41 | Sao Paulo, Brazil | ||
1615996 | 1615996 | 2021-03-05 | Brazil | Sergipe | 154031 | 3003 | 144160 | 6868 | -10.5741 | -37.3857 | 2021-03-06 04:23:41 | Sergipe, Brazil | ||
1615997 | 1615997 | 2021-03-05 | Brazil | Tocantins | 118244 | 1574 | 104197 | 11966 | -10.1753 | -48.2982 | 2021-03-06 04:23:41 | Tocantins, Brazil | ||
1615998 | 1615998 | 2021-03-05 | Brunei | 188 | 3 | 182 | 3 | 4.5353 | 114.7277 | 2021-03-06 04:23:41 | Brunei | |||
1615999 | 1615999 | 2021-03-05 | Bulgaria | 258385 | 10571 | 211918 | 35896 | 42.7339 | 25.4858 | 2021-03-06 04:23:41 | Bulgaria | |||
1616000 | 1616000 | 2021-03-05 | Burkina Faso | 12123 | 143 | 11722 | 258 | 12.2383 | -1.5616 | 2021-03-06 04:23:41 | Burkina Faso | |||
1616001 | 1616001 | 2021-03-05 | Burma | 142000 | 3200 | 131571 | 7229 | 21.9162 | 95.956 | 2021-03-06 04:23:41 | Burma | |||
1616002 | 1616002 | 2021-03-05 | Burundi | 2283 | 3 | 773 | 1507 | -3.3731 | 29.9189 | 2021-03-06 04:23:41 | Burundi | |||
1616003 | 1616003 | 2021-03-05 | Cabo Verde | 15683 | 152 | 15007 | 524 | 16.5388 | -23.0418 | 2021-03-06 04:23:41 | Cabo Verde | |||
1616004 | 1616004 | 2021-03-05 | Cambodia | 953 | 0 | 491 | 462 | 11.55 | 104.9167 | 2021-03-06 04:23:41 | Cambodia | |||
1616005 | 1616005 | 2021-03-05 | Cameroon | 35714 | 551 | 32594 | 2569 | 3.848 | 11.5021 | 2021-03-06 04:23:41 | Cameroon | |||
1616006 | 1616006 | 2021-03-05 | Canada | Alberta | 135196 | 1913 | 128644 | 4639 | 53.9333 | -116.5765 | 2021-03-06 04:23:41 | Alberta, Canada | ||
1616007 | 1616007 | 2021-03-05 | Canada | British Columbia | 83107 | 1380 | 76752 | 4975 | 53.7267 | -127.6476 | 2021-03-06 04:23:41 | British Columbia, Canada | ||
1616008 | 1616008 | 2021-03-05 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1616009 | 1616009 | 2021-03-05 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1616010 | 1616010 | 2021-03-05 | Canada | Manitoba | 32104 | 904 | 30067 | 1133 | 53.7609 | -98.8139 | 2021-03-06 04:23:41 | Manitoba, Canada | ||
1616011 | 1616011 | 2021-03-05 | Canada | New Brunswick | 1447 | 28 | 1385 | 34 | 46.5653 | -66.4619 | 2021-03-06 04:23:41 | New Brunswick, Canada | ||
1616012 | 1616012 | 2021-03-05 | Canada | Newfoundland and Labrador | 1003 | 6 | 880 | 117 | 53.1355 | -57.6604 | 2021-03-06 04:23:41 | Newfoundland and Labrador, Canada | ||
1616013 | 1616013 | 2021-03-05 | Canada | Northwest Territories | 42 | 0 | 46 | 1 | 64.8255 | -124.8457 | 2021-03-06 04:23:41 | Northwest Territories,Canada | ||
1616014 | 1616014 | 2021-03-05 | Canada | Nova Scotia | 1651 | 65 | 1555 | 31 | 44.682 | -63.7443 | 2021-03-06 04:23:41 | Nova Scotia, Canada | ||
1616015 | 1616015 | 2021-03-05 | Canada | Nunavut | 373 | 1 | 355 | 17 | 70.2998 | -83.1076 | 2021-03-06 04:23:41 | Nunavut, Canada | ||
1616016 | 1616016 | 2021-03-05 | Canada | Ontario | 310622 | 7046 | 294011 | 9956 | 51.2538 | -85.3232 | 2021-03-06 04:23:41 | Ontario, Canada | ||
1616017 | 1616017 | 2021-03-05 | Canada | Prince Edward Island | 136 | 0 | 114 | 22 | 46.5107 | -63.4168 | 2021-03-06 04:23:41 | Prince Edward Island, Canada | ||
1616018 | 1616018 | 2021-03-05 | Canada | Quebec | 290885 | 10455 | 273430 | 7000 | 52.9399 | -73.5491 | 2021-03-06 04:23:41 | Quebec, Canada | ||
1616019 | 1616019 | 2021-03-05 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-03-06 04:23:41 | Repatriated Travellers, Canada | ||||
1616020 | 1616020 | 2021-03-05 | Canada | Saskatchewan | 29430 | 393 | 27532 | 1507 | 52.9399 | -106.4509 | 2021-03-06 04:23:41 | Saskatchewan, Canada | ||
1616021 | 1616021 | 2021-03-05 | Canada | Yukon | 72 | 1 | 71 | 0 | 64.2823 | -135.0 | 2021-03-06 04:23:41 | Yukon, Canada | ||
1616022 | 1616022 | 2021-03-05 | Central African Republic | 5018 | 63 | 4920 | 35 | 6.6111 | 20.9394 | 2021-03-06 04:23:41 | Central African Republic | |||
1616023 | 1616023 | 2021-03-05 | Chad | 4089 | 140 | 3572 | 377 | 15.4542 | 18.7322 | 2021-03-06 04:23:41 | Chad | |||
1616024 | 1616024 | 2021-03-05 | Chile | Antofagasta | 38610 | 786 | 36448 | 1376 | -23.6509 | -70.3975 | 2021-03-06 04:23:41 | Antofagasta, Chile | ||
1616025 | 1616025 | 2021-03-05 | Chile | Araucania | 42105 | 543 | 39310 | 2252 | -38.9489 | -72.3311 | 2021-03-06 04:23:41 | Araucania, Chile | ||
1616026 | 1616026 | 2021-03-05 | Chile | Arica y Parinacota | 15458 | 307 | 14614 | 537 | -18.594 | -69.4785 | 2021-03-06 04:23:41 | Arica y Parinacota, Chile | ||
1616027 | 1616027 | 2021-03-05 | Chile | Atacama | 12331 | 155 | 11689 | 487 | -27.5661 | -70.0503 | 2021-03-06 04:23:41 | Atacama, Chile | ||
1616028 | 1616028 | 2021-03-05 | Chile | Aysen | 3142 | 25 | 3020 | 97 | -45.9864 | -73.7669 | 2021-03-06 04:23:41 | Aysen, Chile | ||
1616029 | 1616029 | 2021-03-05 | Chile | Biobio | 75733 | 1315 | 70604 | 3814 | -37.4464 | -72.1416 | 2021-03-06 04:23:41 | 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]);