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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2625560 | 2625560 | 2021-01-10 | Afghanistan | 53489 | 2277 | 43948 | 7264 | 33.93911 | 67.709953 | 2021-01-11 05:21:50 | Afghanistan | |||
2625561 | 2625561 | 2021-01-10 | Albania | 63595 | 1241 | 37648 | 24706 | 41.1533 | 20.1683 | 2021-01-11 05:21:50 | Albania | |||
2625562 | 2625562 | 2021-01-10 | Algeria | 102144 | 2807 | 69212 | 30125 | 28.0339 | 1.6596 | 2021-01-11 05:21:50 | Algeria | |||
2625563 | 2625563 | 2021-01-10 | Andorra | 8586 | 85 | 7724 | 777 | 42.5063 | 1.5218 | 2021-01-11 05:21:50 | Andorra | |||
2625564 | 2625564 | 2021-01-10 | Angola | 18193 | 416 | 13872 | 3905 | -11.2027 | 17.8739 | 2021-01-11 05:21:50 | Angola | |||
2625565 | 2625565 | 2021-01-10 | Antigua and Barbuda | 176 | 5 | 152 | 19 | 17.0608 | -61.7964 | 2021-01-11 05:21:50 | Antigua and Barbuda | |||
2625566 | 2625566 | 2021-01-10 | Argentina | 1722217 | 44495 | 1511750 | 165972 | -38.4161 | -63.6167 | 2021-01-11 05:21:50 | Argentina | |||
2625567 | 2625567 | 2021-01-10 | Armenia | 162131 | 2929 | 149312 | 9890 | 40.0691 | 45.0382 | 2021-01-11 05:21:50 | Armenia | |||
2625568 | 2625568 | 2021-01-10 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-11 05:21:50 | Australian Capital Territory, Australia | ||
2625569 | 2625569 | 2021-01-10 | Australia | New South Wales | 5018 | 54 | 0 | 4964 | -33.8688 | 151.2093 | 2021-01-11 05:21:50 | New South Wales, Australia | ||
2625570 | 2625570 | 2021-01-10 | Australia | Northern Territory | 90 | 0 | 71 | 19 | -12.4634 | 130.8456 | 2021-01-11 05:21:50 | Northern Territory, Australia | ||
2625571 | 2625571 | 2021-01-10 | Australia | Queensland | 1278 | 6 | 1243 | 29 | -27.4698 | 153.0251 | 2021-01-11 05:21:50 | Queensland, Australia | ||
2625572 | 2625572 | 2021-01-10 | Australia | South Australia | 588 | 4 | 569 | 15 | -34.9285 | 138.6007 | 2021-01-11 05:21:50 | South Australia, Australia | ||
2625573 | 2625573 | 2021-01-10 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-11 05:21:50 | Tasmania, Australia | ||
2625574 | 2625574 | 2021-01-10 | Australia | Victoria | 20411 | 820 | 19551 | 40 | -37.8136 | 144.9631 | 2021-01-11 05:21:50 | Victoria, Australia | ||
2625575 | 2625575 | 2021-01-10 | Australia | Western Australia | 877 | 9 | 851 | 17 | -31.9505 | 115.8605 | 2021-01-11 05:21:50 | Western Australia, Australia | ||
2625576 | 2625576 | 2021-01-10 | Austria | 377537 | 8161 | 353749 | 20250 | 47.5162 | 14.5501 | 2021-01-11 05:21:50 | Austria | |||
2625577 | 2625577 | 2021-01-10 | Azerbaijan | 224651 | 2909 | 208681 | 13061 | 40.1431 | 47.5769 | 2021-01-11 05:21:50 | Azerbaijan | |||
2625578 | 2625578 | 2021-01-10 | Bahamas | 7969 | 175 | 6313 | 1481 | 25.025885 | -78.035889 | 2021-01-11 05:21:50 | Bahamas | |||
2625579 | 2625579 | 2021-01-10 | Bahrain | 95558 | 356 | 92362 | 2840 | 26.0275 | 50.55 | 2021-01-11 05:21:50 | Bahrain | |||
2625580 | 2625580 | 2021-01-10 | Bangladesh | 522453 | 7781 | 466801 | 47871 | 23.685 | 90.3563 | 2021-01-11 05:21:50 | Bangladesh | |||
2625581 | 2625581 | 2021-01-10 | Barbados | 878 | 7 | 389 | 482 | 13.1939 | -59.5432 | 2021-01-11 05:21:50 | Barbados | |||
2625582 | 2625582 | 2021-01-10 | Belarus | 212201 | 1517 | 194984 | 15700 | 53.7098 | 27.9534 | 2021-01-11 05:21:50 | Belarus | |||
2625583 | 2625583 | 2021-01-10 | Belgium | Antwerp | 82041 | 0 | 0 | 82041 | 51.2195 | 4.4024 | 2021-01-11 05:21:50 | Antwerp, Belgium | ||
2625584 | 2625584 | 2021-01-10 | Belgium | Brussels | 83471 | 0 | 0 | 83471 | 50.8503 | 4.3517 | 2021-01-11 05:21:50 | Brussels, Belgium | ||
2625585 | 2625585 | 2021-01-10 | Belgium | East Flanders | 67492 | 0 | 0 | 67492 | 51.0362 | 3.7373 | 2021-01-11 05:21:50 | East Flanders, Belgium | ||
2625586 | 2625586 | 2021-01-10 | Belgium | Flemish Brabant | 50529 | 0 | 0 | 50529 | 50.9167 | 4.5833 | 2021-01-11 05:21:50 | Flemish Brabant, Belgium | ||
2625587 | 2625587 | 2021-01-10 | Belgium | Hainaut | 103911 | 0 | 0 | 103911 | 50.5257 | 4.0621 | 2021-01-11 05:21:50 | Hainaut, Belgium | ||
2625588 | 2625588 | 2021-01-10 | Belgium | Liege | 98275 | 0 | 0 | 98275 | 50.4496 | 5.8492 | 2021-01-11 05:21:50 | Liege, Belgium | ||
2625589 | 2625589 | 2021-01-10 | Belgium | Limburg | 30515 | 0 | 0 | 30515 | 50.9739 | 5.3420000000000005 | 2021-01-11 05:21:50 | Limburg, Belgium | ||
2625590 | 2625590 | 2021-01-10 | Belgium | Luxembourg | 18862 | 0 | 0 | 18862 | 50.0547 | 5.4677 | 2021-01-11 05:21:50 | Luxembourg, Belgium | ||
2625591 | 2625591 | 2021-01-10 | Belgium | Namur | 36067 | 0 | 0 | 36067 | 50.331 | 4.8221 | 2021-01-11 05:21:50 | Namur, Belgium | ||
2625592 | 2625592 | 2021-01-10 | Belgium | Unknown | 11114 | 20078 | 0 | 0 | 2021-01-11 05:21:50 | Unknown, Belgium | ||||
2625593 | 2625593 | 2021-01-10 | Belgium | Walloon Brabant | 25719 | 0 | 0 | 25719 | 50.4 | 4.35 | 2021-01-11 05:21:50 | Walloon Brabant, Belgium | ||
2625594 | 2625594 | 2021-01-10 | Belgium | West Flanders | 56267 | 0 | 0 | 56267 | 51.0536 | 3.1458 | 2021-01-11 05:21:50 | West Flanders, Belgium | ||
2625595 | 2625595 | 2021-01-10 | Belize | 11303 | 274 | 10397 | 632 | 17.1899 | -88.4976 | 2021-01-11 05:21:50 | Belize | |||
2625596 | 2625596 | 2021-01-10 | Benin | 3304 | 44 | 3185 | 75 | 9.3077 | 2.3158 | 2021-01-11 05:21:50 | Benin | |||
2625597 | 2625597 | 2021-01-10 | Bhutan | 813 | 1 | 459 | 353 | 27.5142 | 90.4336 | 2021-01-11 05:21:50 | Bhutan | |||
2625598 | 2625598 | 2021-01-10 | Bolivia | 173896 | 9376 | 138087 | 26433 | -16.2902 | -63.5887 | 2021-01-11 05:21:50 | Bolivia | |||
2625599 | 2625599 | 2021-01-10 | Bosnia and Herzegovina | 115633 | 4330 | 81625 | 29678 | 43.9159 | 17.6791 | 2021-01-11 05:21:50 | Bosnia and Herzegovina | |||
2625600 | 2625600 | 2021-01-10 | Botswana | 16050 | 48 | 12927 | 3075 | -22.3285 | 24.6849 | 2021-01-11 05:21:50 | Botswana | |||
2625601 | 2625601 | 2021-01-10 | Brazil | Acre | 43127 | 825 | 38323 | 3979 | -9.0238 | -70.812 | 2021-01-11 05:21:50 | Acre, Brazil | ||
2625602 | 2625602 | 2021-01-10 | Brazil | Alagoas | 108542 | 2561 | 103193 | 2788 | -9.5713 | -36.782 | 2021-01-11 05:21:50 | Alagoas, Brazil | ||
2625603 | 2625603 | 2021-01-10 | Brazil | Amapa | 70902 | 969 | 53921 | 16012 | 0.902 | -52.003 | 2021-01-11 05:21:50 | Amapa, Brazil | ||
2625604 | 2625604 | 2021-01-10 | Brazil | Amazonas | 213961 | 5701 | 177124 | 31136 | -3.4168 | -65.8561 | 2021-01-11 05:21:50 | Amazonas, Brazil | ||
2625605 | 2625605 | 2021-01-10 | Brazil | Bahia | 512841 | 9424 | 496542 | 6875 | -12.5797 | -41.7007 | 2021-01-11 05:21:50 | Bahia, Brazil | ||
2625606 | 2625606 | 2021-01-10 | Brazil | Ceara | 345002 | 10159 | 275120 | 59538 | -5.4984 | -39.3206 | 2021-01-11 05:21:50 | Ceara, Brazil | ||
2625607 | 2625607 | 2021-01-10 | Brazil | Distrito Federal | 258811 | 4356 | 247471 | 6984 | -15.7998 | -47.8645 | 2021-01-11 05:21:50 | Distrito Federal, Brazil | ||
2625608 | 2625608 | 2021-01-10 | Brazil | Espirito Santo | 263504 | 5321 | 241241 | 16921 | -19.1834 | -40.3089 | 2021-01-11 05:21:50 | Espirito Santo, Brazil | ||
2625609 | 2625609 | 2021-01-10 | Brazil | Goias | 317477 | 6965 | 306128 | 4230 | -15.827 | -49.8362 | 2021-01-11 05:21:50 | Goias, Brazil | ||
2625610 | 2625610 | 2021-01-10 | Brazil | Maranhao | 201945 | 4562 | 191535 | 5848 | -4.9609 | -45.2744 | 2021-01-11 05:21:50 | Maranhao, Brazil | ||
2625611 | 2625611 | 2021-01-10 | Brazil | Mato Grosso | 189359 | 4684 | 177150 | 6353 | -12.6819 | -56.9211 | 2021-01-11 05:21:50 | Mato Grosso, Brazil | ||
2625612 | 2625612 | 2021-01-10 | Brazil | Mato Grosso do Sul | 144051 | 2565 | 128556 | 12494 | -20.7722 | -54.7852 | 2021-01-11 05:21:50 | Mato Grosso do Sul, Brazil | ||
2625613 | 2625613 | 2021-01-10 | Brazil | Minas Gerais | 592311 | 12709 | 530061 | 49541 | -18.5122 | -44.555 | 2021-01-11 05:21:50 | Minas Gerais, Brazil | ||
2625614 | 2625614 | 2021-01-10 | Brazil | Para | 302125 | 7315 | 282575 | 11622 | -1.9981 | -54.9306 | 2021-01-11 05:21:50 | Para, Brazil | ||
2625615 | 2625615 | 2021-01-10 | Brazil | Paraiba | 172776 | 3808 | 130623 | 38345 | -7.24 | -36.782 | 2021-01-11 05:21:50 | Paraiba, Brazil | ||
2625616 | 2625616 | 2021-01-10 | Brazil | Parana | 473279 | 8749 | 349372 | 115158 | -25.2521 | -52.0215 | 2021-01-11 05:21:50 | Parana, Brazil | ||
2625617 | 2625617 | 2021-01-10 | Brazil | Pernambuco | 232037 | 9840 | 196457 | 25740 | -8.8137 | -36.9541 | 2021-01-11 05:21:50 | Pernambuco, Brazil | ||
2625618 | 2625618 | 2021-01-10 | Brazil | Piaui | 147509 | 2906 | 143770 | 371 | -7.7183 | -42.7289 | 2021-01-11 05:21:50 | Piaui, Brazil | ||
2625619 | 2625619 | 2021-01-10 | Brazil | Rio Grande do Norte | 125215 | 3112 | 88210 | 32978 | -5.4026 | -36.9541 | 2021-01-11 05:21:50 | Rio Grande do Norte, Brazil | ||
2625620 | 2625620 | 2021-01-10 | Brazil | Rio Grande do Sul | 480480 | 9439 | 455391 | 15650 | -30.0346 | -51.2177 | 2021-01-11 05:21:50 | Rio Grande do Sul, Brazil | ||
2625621 | 2625621 | 2021-01-10 | Brazil | Rio de Janeiro | 460927 | 26749 | 427837 | 6341 | -22.9068 | -43.1729 | 2021-01-11 05:21:50 | Rio de Janeiro, Brazil | ||
2625622 | 2625622 | 2021-01-10 | Brazil | Rondonia | 101588 | 1911 | 84316 | 15361 | -11.5057 | -63.5806 | 2021-01-11 05:21:50 | Rondonia, Brazil | ||
2625623 | 2625623 | 2021-01-10 | Brazil | Roraima | 69785 | 793 | 66262 | 2677 | -2.7376 | -62.0751 | 2021-01-11 05:21:50 | Roraima, Brazil | ||
2625624 | 2625624 | 2021-01-10 | Brazil | Santa Catarina | 520577 | 5637 | 490200 | 24740 | -27.2423 | -50.2189 | 2021-01-11 05:21:50 | Santa Catarina, Brazil | ||
2625625 | 2625625 | 2021-01-10 | Brazil | Sao Paulo | 1546132 | 48351 | 1360789 | 136992 | -23.5505 | -46.6333 | 2021-01-11 05:21:50 | Sao Paulo, Brazil | ||
2625626 | 2625626 | 2021-01-10 | Brazil | Sergipe | 122594 | 2574 | 105553 | 14467 | -10.5741 | -37.3857 | 2021-01-11 05:21:50 | Sergipe, Brazil | ||
2625627 | 2625627 | 2021-01-10 | Brazil | Tocantins | 93261 | 1274 | 83616 | 8213 | -10.1753 | -48.2982 | 2021-01-11 05:21:50 | Tocantins, Brazil | ||
2625628 | 2625628 | 2021-01-10 | Brunei | 173 | 3 | 153 | 17 | 4.5353 | 114.7277 | 2021-01-11 05:21:50 | Brunei | |||
2625629 | 2625629 | 2021-01-10 | Bulgaria | 208511 | 8126 | 135259 | 65126 | 42.7339 | 25.4858 | 2021-01-11 05:21:50 | Bulgaria | |||
2625630 | 2625630 | 2021-01-10 | Burkina Faso | 8082 | 89 | 5845 | 2148 | 12.2383 | -1.5616 | 2021-01-11 05:21:50 | Burkina Faso | |||
2625631 | 2625631 | 2021-01-10 | Burma | 130604 | 2846 | 114049 | 13709 | 21.9162 | 95.956 | 2021-01-11 05:21:50 | Burma | |||
2625632 | 2625632 | 2021-01-10 | Burundi | 986 | 2 | 773 | 211 | -3.3731 | 29.9189 | 2021-01-11 05:21:50 | Burundi | |||
2625633 | 2625633 | 2021-01-10 | Cabo Verde | 12392 | 114 | 11733 | 545 | 16.5388 | -23.0418 | 2021-01-11 05:21:50 | Cabo Verde | |||
2625634 | 2625634 | 2021-01-10 | Cambodia | 391 | 0 | 374 | 17 | 11.55 | 104.9167 | 2021-01-11 05:21:50 | Cambodia | |||
2625635 | 2625635 | 2021-01-10 | Cameroon | 26848 | 448 | 24892 | 1508 | 3.848 | 11.5021 | 2021-01-11 05:21:50 | Cameroon | |||
2625636 | 2625636 | 2021-01-10 | Canada | Alberta | 111452 | 1284 | 96052 | 14116 | 53.9333 | -116.5765 | 2021-01-11 05:21:50 | Alberta, Canada | ||
2625637 | 2625637 | 2021-01-10 | Canada | British Columbia | 56632 | 988 | 48205 | 7439 | 53.7267 | -127.6476 | 2021-01-11 05:21:50 | British Columbia, Canada | ||
2625638 | 2625638 | 2021-01-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2625639 | 2625639 | 2021-01-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2625640 | 2625640 | 2021-01-10 | Canada | Manitoba | 26316 | 738 | 20850 | 4728 | 53.7609 | -98.8139 | 2021-01-11 05:21:50 | Manitoba, Canada | ||
2625641 | 2625641 | 2021-01-10 | Canada | New Brunswick | 779 | 9 | 585 | 185 | 46.5653 | -66.4619 | 2021-01-11 05:21:50 | New Brunswick, Canada | ||
2625642 | 2625642 | 2021-01-10 | Canada | Newfoundland and Labrador | 393 | 4 | 381 | 8 | 53.1355 | -57.6604 | 2021-01-11 05:21:50 | Newfoundland and Labrador, Canada | ||
2625643 | 2625643 | 2021-01-10 | Canada | Northwest Territories | 24 | 0 | 24 | 0 | 64.8255 | -124.8457 | 2021-01-11 05:21:50 | Northwest Territories,Canada | ||
2625644 | 2625644 | 2021-01-10 | Canada | Nova Scotia | 1528 | 65 | 1435 | 28 | 44.682 | -63.7443 | 2021-01-11 05:21:50 | Nova Scotia, Canada | ||
2625645 | 2625645 | 2021-01-10 | Canada | Nunavut | 266 | 1 | 265 | 0 | 70.2998 | -83.1076 | 2021-01-11 05:21:50 | Nunavut, Canada | ||
2625646 | 2625646 | 2021-01-10 | Canada | Ontario | 223300 | 4983 | 186984 | 28418 | 51.2538 | -85.3232 | 2021-01-11 05:21:50 | Ontario, Canada | ||
2625647 | 2625647 | 2021-01-10 | Canada | Prince Edward Island | 102 | 0 | 94 | 8 | 46.5107 | -63.4168 | 2021-01-11 05:21:50 | Prince Edward Island, Canada | ||
2625648 | 2625648 | 2021-01-10 | Canada | Quebec | 230590 | 8800 | 195663 | 26127 | 52.9399 | -73.5491 | 2021-01-11 05:21:50 | Quebec, Canada | ||
2625649 | 2625649 | 2021-01-10 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-01-11 05:21:50 | Repatriated Travellers, Canada | ||||
2625650 | 2625650 | 2021-01-10 | Canada | Saskatchewan | 18114 | 191 | 14426 | 3186 | 52.9399 | -106.4509 | 2021-01-11 05:21:50 | Saskatchewan, Canada | ||
2625651 | 2625651 | 2021-01-10 | Canada | Yukon | 70 | 1 | 59 | 10 | 64.2823 | -135.0 | 2021-01-11 05:21:50 | Yukon, Canada | ||
2625652 | 2625652 | 2021-01-10 | Central African Republic | 4973 | 63 | 4885 | 25 | 6.6111 | 20.9394 | 2021-01-11 05:21:50 | Central African Republic | |||
2625653 | 2625653 | 2021-01-10 | Chad | 2537 | 107 | 1965 | 465 | 15.4542 | 18.7322 | 2021-01-11 05:21:50 | Chad | |||
2625654 | 2625654 | 2021-01-10 | Chile | Antofagasta | 25430 | 594 | 23566 | 1270 | -23.6509 | -70.3975 | 2021-01-11 05:21:50 | Antofagasta, Chile | ||
2625655 | 2625655 | 2021-01-10 | Chile | Araucania | 25493 | 336 | 23707 | 1450 | -38.9489 | -72.3311 | 2021-01-11 05:21:50 | Araucania, Chile | ||
2625656 | 2625656 | 2021-01-10 | Chile | Arica y Parinacota | 11243 | 231 | 10682 | 330 | -18.594 | -69.4785 | 2021-01-11 05:21:50 | Arica y Parinacota, Chile | ||
2625657 | 2625657 | 2021-01-10 | Chile | Atacama | 8826 | 115 | 8487 | 224 | -27.5661 | -70.0503 | 2021-01-11 05:21:50 | Atacama, Chile | ||
2625658 | 2625658 | 2021-01-10 | Chile | Aysen | 1812 | 18 | 1617 | 177 | -45.9864 | -73.7669 | 2021-01-11 05:21:50 | Aysen, Chile | ||
2625659 | 2625659 | 2021-01-10 | Chile | Biobio | 51665 | 881 | 47846 | 2938 | -37.4464 | -72.1416 | 2021-01-11 05:21:50 | 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]);