daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,990 rows where day = "2020-09-03" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update, day (date), last_update (date)
province_or_state >30
- Texas 255
- Georgia 161
- Virginia 134
- Kentucky 121
- Missouri 117
- Kansas 106
- Illinois 104
- North Carolina 101
- Iowa 100
- Tennessee 97
- Nebraska 94
- Indiana 93
- Ohio 89
- Minnesota 88
- Michigan 87
- Mississippi 83
- Puerto Rico 80
- Oklahoma 79
- Arkansas 76
- Wisconsin 73
- Alabama 69
- Florida 68
- Pennsylvania 68
- South Dakota 67
- Colorado 66
- Louisiana 66
- New York 63
- California 59
- Montana 57
- West Virginia 56
- …
country_or_region >30
- US 3,272
- Russia 83
- Japan 49
- India 37
- China 34
- Colombia 33
- Mexico 32
- Ukraine 28
- Brazil 27
- Peru 26
- Italy 21
- Sweden 21
- Spain 20
- United Kingdom 19
- Chile 17
- Germany 17
- Malaysia 17
- Netherlands 17
- Canada 15
- France 11
- Australia 8
- Pakistan 7
- Denmark 3
- New Zealand 3
- Afghanistan 1
- Albania 1
- Algeria 1
- Andorra 1
- Angola 1
- Antarctica 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-03 | Afghanistan | 38374 | 1413 | 29390 | 7571 | 33.93911 | 67.709953 | 2020-09-04 04:28:26 | Afghanistan | |||
2020-09-03 | Albania | 9844 | 301 | 5732 | 3811 | 41.1533 | 20.1683 | 2020-09-04 04:28:26 | Albania | |||
2020-09-03 | Algeria | 45469 | 1529 | 32006 | 11934 | 28.0339 | 1.6596 | 2020-09-04 04:28:26 | Algeria | |||
2020-09-03 | Andorra | 1199 | 53 | 909 | 237 | 42.5063 | 1.5218 | 2020-09-04 04:28:26 | Andorra | |||
2020-09-03 | Angola | 2805 | 113 | 1144 | 1548 | -11.2027 | 17.8739 | 2020-09-04 04:28:26 | Angola | |||
2020-09-03 | Antigua and Barbuda | 95 | 3 | 91 | 1 | 17.0608 | -61.7964 | 2020-09-04 04:28:26 | Antigua and Barbuda | |||
2020-09-03 | Argentina | 451198 | 9361 | 322461 | 119376 | -38.4161 | -63.6167 | 2020-09-04 04:28:26 | Argentina | |||
2020-09-03 | Armenia | 44271 | 887 | 38855 | 4529 | 40.0691 | 45.0382 | 2020-09-04 04:28:26 | Armenia | |||
2020-09-03 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-09-04 04:28:26 | Australian Capital Territory, Australia | ||
2020-09-03 | Australia | New South Wales | 4099 | 52 | 0 | 4047 | -33.8688 | 151.2093 | 2020-09-04 04:28:26 | New South Wales, Australia | ||
2020-09-03 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-09-04 04:28:26 | Northern Territory, Australia | ||
2020-09-03 | Australia | Queensland | 1128 | 6 | 1088 | 34 | -27.4698 | 153.0251 | 2020-09-04 04:28:26 | Queensland, Australia | ||
2020-09-03 | Australia | South Australia | 463 | 4 | 459 | 0 | -34.9285 | 138.6007 | 2020-09-04 04:28:26 | South Australia, Australia | ||
2020-09-03 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-04 04:28:26 | Tasmania, Australia | ||
2020-09-03 | Australia | Victoria | 19415 | 650 | 16370 | 2395 | -37.8136 | 144.9631 | 2020-09-04 04:28:26 | Victoria, Australia | ||
2020-09-03 | Australia | Western Australia | 655 | 9 | 643 | 3 | -31.9505 | 115.8605 | 2020-09-04 04:28:26 | Western Australia, Australia | ||
2020-09-03 | Austria | 27861 | 908 | 24171 | 3466 | 47.5162 | 14.5501 | 2020-09-04 04:28:26 | Austria | |||
2020-09-03 | Azerbaijan | 36899 | 541 | 34264 | 2094 | 40.1431 | 47.5769 | 2020-09-04 04:28:26 | Azerbaijan | |||
2020-09-03 | Bahamas | 2386 | 50 | 893 | 1443 | 25.025885 | -78.035889 | 2020-09-04 04:28:26 | Bahamas | |||
2020-09-03 | Bahrain | 53433 | 190 | 50013 | 3230 | 26.0275 | 50.55 | 2020-09-04 04:28:26 | Bahrain | |||
2020-09-03 | Bangladesh | 319686 | 4383 | 213980 | 101323 | 23.685 | 90.3563 | 2020-09-04 04:28:26 | Bangladesh | |||
2020-09-03 | Barbados | 177 | 7 | 150 | 20 | 13.1939 | -59.5432 | 2020-09-04 04:28:26 | Barbados | |||
2020-09-03 | Belarus | 72302 | 696 | 71205 | 401 | 53.7098 | 27.9534 | 2020-09-04 04:28:26 | Belarus | |||
2020-09-03 | Belgium | 86544 | 9899 | 18513 | 58132 | 50.8333 | 4.469936 | 2020-09-04 04:28:26 | Belgium | |||
2020-09-03 | Belize | 1101 | 13 | 240 | 848 | 17.1899 | -88.4976 | 2020-09-04 04:28:26 | Belize | |||
2020-09-03 | Benin | 2194 | 40 | 1738 | 416 | 9.3077 | 2.3158 | 2020-09-04 04:28:26 | Benin | |||
2020-09-03 | Bhutan | 227 | 0 | 150 | 77 | 27.5142 | 90.4336 | 2020-09-04 04:28:26 | Bhutan | |||
2020-09-03 | Bolivia | 118781 | 5288 | 65884 | 47609 | -16.2902 | -63.5887 | 2020-09-04 04:28:26 | Bolivia | |||
2020-09-03 | Bosnia and Herzegovina | 20804 | 636 | 14120 | 6048 | 43.9159 | 17.6791 | 2020-09-04 04:28:26 | Bosnia and Herzegovina | |||
2020-09-03 | Botswana | 1724 | 6 | 493 | 1225 | -22.3285 | 24.6849 | 2020-09-04 04:28:26 | Botswana | |||
2020-09-03 | Brazil | Acre | 25135 | 622 | 19695 | 4818 | -9.0238 | -70.812 | 2020-09-04 04:28:26 | Acre, Brazil | ||
2020-09-03 | Brazil | Alagoas | 79797 | 1910 | 75156 | 2731 | -9.5713 | -36.782 | 2020-09-04 04:28:26 | Alagoas, Brazil | ||
2020-09-03 | Brazil | Amapa | 44064 | 669 | 32172 | 11223 | 0.902 | -52.003 | 2020-09-04 04:28:26 | Amapa, Brazil | ||
2020-09-03 | Brazil | Amazonas | 122520 | 3828 | 103958 | 14734 | -3.4168 | -65.8561 | 2020-09-04 04:28:26 | Amazonas, Brazil | ||
2020-09-03 | Brazil | Bahia | 265739 | 5549 | 250309 | 9881 | -12.5797 | -41.7007 | 2020-09-04 04:28:26 | Bahia, Brazil | ||
2020-09-03 | Brazil | Ceara | 220040 | 8532 | 193642 | 17537 | -5.4984 | -39.3206 | 2020-09-04 04:28:26 | Ceara, Brazil | ||
2020-09-03 | Brazil | Distrito Federal | 165903 | 2641 | 150538 | 12724 | -15.7998 | -47.8645 | 2020-09-04 04:28:26 | Distrito Federal, Brazil | ||
2020-09-03 | Brazil | Espirito Santo | 113759 | 3221 | 102928 | 7610 | -19.1834 | -40.3089 | 2020-09-04 04:28:26 | Espirito Santo, Brazil | ||
2020-09-03 | Brazil | Goias | 143793 | 3385 | 132370 | 4701 | -15.827 | -49.8362 | 2020-09-04 04:28:26 | Goias, Brazil | ||
2020-09-03 | Brazil | Maranhao | 155717 | 3478 | 142763 | 9476 | -4.9609 | -45.2744 | 2020-09-04 04:28:26 | Maranhao, Brazil | ||
2020-09-03 | Brazil | Mato Grosso | 96349 | 2893 | 77046 | 15539 | -12.6819 | -56.9211 | 2020-09-04 04:28:26 | Mato Grosso, Brazil | ||
2020-09-03 | Brazil | Mato Grosso do Sul | 52406 | 939 | 42384 | 8277 | -20.7722 | -54.7852 | 2020-09-04 04:28:26 | Mato Grosso do Sul, Brazil | ||
2020-09-03 | Brazil | Minas Gerais | 224987 | 5591 | 189835 | 29561 | -18.5122 | -44.555 | 2020-09-04 04:28:26 | Minas Gerais, Brazil | ||
2020-09-03 | Brazil | Para | 205291 | 6228 | 187691 | 10063 | -1.9981 | -54.9306 | 2020-09-04 04:28:26 | Para, Brazil | ||
2020-09-03 | Brazil | Paraiba | 108182 | 2501 | 78720 | 26961 | -7.24 | -36.782 | 2020-09-04 04:28:26 | Paraiba, Brazil | ||
2020-09-03 | Brazil | Parana | 137865 | 3449 | 93878 | 40538 | -25.2521 | -52.0215 | 2020-09-04 04:28:26 | Parana, Brazil | ||
2020-09-03 | Brazil | Pernambuco | 130199 | 7619 | 113496 | 9084 | -8.8137 | -36.9541 | 2020-09-04 04:28:26 | Pernambuco, Brazil | ||
2020-09-03 | Brazil | Piaui | 81626 | 1884 | 78268 | 0 | -7.7183 | -42.7289 | 2020-09-04 04:28:26 | Piaui, Brazil | ||
2020-09-03 | Brazil | Rio Grande do Norte | 63507 | 2289 | 37767 | 22810 | -5.4026 | -36.9541 | 2020-09-04 04:28:26 | Rio Grande do Norte, Brazil | ||
2020-09-03 | Brazil | Rio Grande do Sul | 134610 | 3590 | 120364 | 10656 | -30.0346 | -51.2177 | 2020-09-04 04:28:26 | Rio Grande do Sul, Brazil | ||
2020-09-03 | Brazil | Rio de Janeiro | 230271 | 16394 | 207993 | 5884 | -22.9068 | -43.1729 | 2020-09-04 04:28:26 | Rio de Janeiro, Brazil | ||
2020-09-03 | Brazil | Rondonia | 56618 | 1165 | 46833 | 8620 | -11.5057 | -63.5806 | 2020-09-04 04:28:26 | Rondonia, Brazil | ||
2020-09-03 | Brazil | Roraima | 44665 | 598 | 11263 | 32475 | -2.7376 | -62.0751 | 2020-09-04 04:28:26 | Roraima, Brazil | ||
2020-09-03 | Brazil | Santa Catarina | 184204 | 2352 | 173163 | 8689 | -27.2423 | -50.2189 | 2020-09-04 04:28:26 | Santa Catarina, Brazil | ||
2020-09-03 | Brazil | Sao Paulo | 837978 | 30905 | 668588 | 138485 | -23.5505 | -46.6333 | 2020-09-04 04:28:26 | Sao Paulo, Brazil | ||
2020-09-03 | Brazil | Sergipe | 73182 | 1877 | 63592 | 7713 | -10.5741 | -37.3857 | 2020-09-04 04:28:26 | Sergipe, Brazil | ||
2020-09-03 | Brazil | Tocantins | 54013 | 730 | 35023 | 17203 | -10.1753 | -48.2982 | 2020-09-04 04:28:26 | Tocantins, Brazil | ||
2020-09-03 | Brunei | 145 | 3 | 139 | 3 | 4.5353 | 114.7277 | 2020-09-04 04:28:26 | Brunei | |||
2020-09-03 | Bulgaria | 16775 | 658 | 11935 | 4182 | 42.7339 | 25.4858 | 2020-09-04 04:28:26 | Bulgaria | |||
2020-09-03 | Burkina Faso | 1375 | 55 | 1075 | 245 | 12.2383 | -1.5616 | 2020-09-04 04:28:26 | Burkina Faso | |||
2020-09-03 | Burma | 1111 | 6 | 359 | 746 | 21.9162 | 95.956 | 2020-09-04 04:28:26 | Burma | |||
2020-09-03 | Burundi | 448 | 1 | 357 | 90 | -3.3731 | 29.9189 | 2020-09-04 04:28:26 | Burundi | |||
2020-09-03 | Cabo Verde | 4125 | 41 | 3502 | 582 | 16.5388 | -23.0418 | 2020-09-04 04:28:26 | Cabo Verde | |||
2020-09-03 | Cambodia | 274 | 0 | 272 | 2 | 11.55 | 104.9167 | 2020-09-04 04:28:26 | Cambodia | |||
2020-09-03 | Cameroon | 19604 | 415 | 18448 | 741 | 3.848 | 11.5021 | 2020-09-04 04:28:26 | Cameroon | |||
2020-09-03 | Canada | Alberta | 14310 | 242 | 12653 | 1415 | 53.9333 | -116.5765 | 2020-09-04 04:28:26 | Alberta, Canada | ||
2020-09-03 | Canada | British Columbia | 6041 | 210 | 4645 | 1186 | 53.7267 | -127.6476 | 2020-09-04 04:28:26 | British Columbia, Canada | ||
2020-09-03 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-09-04 04:28:26 | Diamond Princess, Canada | ||
2020-09-03 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-09-04 04:28:26 | Grand Princess, Canada | ||
2020-09-03 | Canada | Manitoba | 1264 | 16 | 791 | 457 | 53.7609 | -98.8139 | 2020-09-04 04:28:26 | Manitoba, Canada | ||
2020-09-03 | Canada | New Brunswick | 192 | 2 | 186 | 4 | 46.5653 | -66.4619 | 2020-09-04 04:28:26 | New Brunswick, Canada | ||
2020-09-03 | Canada | Newfoundland and Labrador | 269 | 3 | 266 | 0 | 53.1355 | -57.6604 | 2020-09-04 04:28:26 | Newfoundland and Labrador, Canada | ||
2020-09-03 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-04 04:28:26 | Northwest Territories,Canada | ||
2020-09-03 | Canada | Nova Scotia | 1085 | 65 | 1014 | 6 | 44.682 | -63.7443 | 2020-09-04 04:28:26 | Nova Scotia, Canada | ||
2020-09-03 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-09-04 04:28:26 | Nunavut, Canada | ||
2020-09-03 | Canada | Ontario | 43488 | 2812 | 40456 | 1405 | 51.2538 | -85.3232 | 2020-09-04 04:28:26 | Ontario, Canada | ||
2020-09-03 | Canada | Prince Edward Island | 46 | 0 | 44 | 2 | 46.5107 | -63.4168 | 2020-09-04 04:28:26 | Prince Edward Island, Canada | ||
2020-09-03 | Canada | Quebec | 62988 | 5783 | 55615 | 1590 | 52.9399 | -73.5491 | 2020-09-04 04:28:26 | Quebec, Canada | ||
2020-09-03 | Canada | Saskatchewan | 1634 | 24 | 1574 | 36 | 52.9399 | -106.4509 | 2020-09-04 04:28:26 | Saskatchewan, Canada | ||
2020-09-03 | Canada | Yukon | 15 | 0 | 15 | 0 | 64.2823 | -135.0 | 2020-09-04 04:28:26 | Yukon, Canada | ||
2020-09-03 | Central African Republic | 4729 | 62 | 1807 | 2860 | 6.6111 | 20.9394 | 2020-09-04 04:28:26 | Central African Republic | |||
2020-09-03 | Chad | 1018 | 77 | 908 | 33 | 15.4542 | 18.7322 | 2020-09-04 04:28:26 | Chad | |||
2020-09-03 | Chile | Antofagasta | 18344 | 448 | 17139 | 757 | -23.6509 | -70.3975 | 2020-09-04 04:28:26 | Antofagasta, Chile | ||
2020-09-03 | Chile | Araucania | 5288 | 96 | 4897 | 295 | -38.9489 | -72.3311 | 2020-09-04 04:28:26 | Araucania, Chile | ||
2020-09-03 | Chile | Arica y Parinacota | 6808 | 112 | 6194 | 502 | -18.594 | -69.4785 | 2020-09-04 04:28:26 | Arica y Parinacota, Chile | ||
2020-09-03 | Chile | Atacama | 5807 | 47 | 5273 | 487 | -27.5661 | -70.0503 | 2020-09-04 04:28:26 | Atacama, Chile | ||
2020-09-03 | Chile | Aysen | 124 | 1 | 105 | 18 | -45.9864 | -73.7669 | 2020-09-04 04:28:26 | Aysen, Chile | ||
2020-09-03 | Chile | Biobio | 18036 | 222 | 15566 | 2248 | -37.4464 | -72.1416 | 2020-09-04 04:28:26 | Biobio, Chile | ||
2020-09-03 | Chile | Coquimbo | 10215 | 143 | 9213 | 859 | -29.959 | -71.3389 | 2020-09-04 04:28:26 | Coquimbo, Chile | ||
2020-09-03 | Chile | Los Lagos | 6794 | 70 | 6110 | 614 | -41.9198 | -72.1416 | 2020-09-04 04:28:26 | Los Lagos, Chile | ||
2020-09-03 | Chile | Los Rios | 1155 | 15 | 1047 | 93 | -40.231 | -72.3311 | 2020-09-04 04:28:26 | Los Rios, Chile | ||
2020-09-03 | Chile | Magallanes | 3891 | 43 | 2803 | 1045 | -52.368 | -70.9863 | 2020-09-04 04:28:26 | Magallanes, Chile | ||
2020-09-03 | Chile | Maule | 12005 | 266 | 10891 | 848 | -35.5183 | -71.6885 | 2020-09-04 04:28:26 | Maule, Chile | ||
2020-09-03 | Chile | Metropolitana | 275138 | 8608 | 261917 | 4613 | -33.4376 | -70.6505 | 2020-09-04 04:28:26 | Metropolitana, Chile | ||
2020-09-03 | Chile | Nuble | 4887 | 82 | 4238 | 567 | -36.7226 | -71.7622 | 2020-09-04 04:28:26 | Nuble, Chile | ||
2020-09-03 | Chile | OHiggins | 13697 | 343 | 12522 | 832 | -34.5755 | -71.0022 | 2020-09-04 04:28:26 | OHiggins, Chile | ||
2020-09-03 | Chile | Tarapaca | 10796 | 206 | 10193 | 397 | -19.9232 | -69.5132 | 2020-09-04 04:28:26 | Tarapaca, Chile | ||
2020-09-03 | Chile | Unknown | 56 | 1 | 55 | 0 | 2020-09-04 04:28:26 | Unknown, Chile | ||||
2020-09-03 | Chile | Valparaiso | 23460 | 719 | 21246 | 1495 | -33.0472 | -71.6127 | 2020-09-04 04:28:26 | Valparaiso, Chile | ||
2020-09-03 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-09-04 04:28:26 | Anhui, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;