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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1563779 | 1563779 | 2021-06-14 | Afghanistan | 91458 | 3612 | 61706 | 26140 | 33.93911 | 67.709953 | 2021-06-15 04:22:22 | Afghanistan | |||
1563780 | 1563780 | 2021-06-14 | Albania | 132461 | 2453 | 129865 | 143 | 41.1533 | 20.1683 | 2021-06-15 04:22:22 | Albania | |||
1563781 | 1563781 | 2021-06-14 | Algeria | 133742 | 3579 | 93094 | 37069 | 28.0339 | 1.6596 | 2021-06-15 04:22:22 | Algeria | |||
1563782 | 1563782 | 2021-06-14 | Andorra | 13826 | 127 | 13618 | 81 | 42.5063 | 1.5218 | 2021-06-15 04:22:22 | Andorra | |||
1563783 | 1563783 | 2021-06-14 | Angola | 36790 | 836 | 30359 | 5595 | -11.2027 | 17.8739 | 2021-06-15 04:22:22 | Angola | |||
1563784 | 1563784 | 2021-06-14 | Antigua and Barbuda | 1263 | 42 | 1214 | 7 | 17.0608 | -61.7964 | 2021-06-15 04:22:22 | Antigua and Barbuda | |||
1563785 | 1563785 | 2021-06-14 | Argentina | 4145482 | 86029 | 3748794 | 310659 | -38.4161 | -63.6167 | 2021-06-15 04:22:22 | Argentina | |||
1563786 | 1563786 | 2021-06-14 | Armenia | 223723 | 4488 | 215228 | 4007 | 40.0691 | 45.0382 | 2021-06-15 04:22:22 | Armenia | |||
1563787 | 1563787 | 2021-06-14 | Australia | Australian Capital Territory | 124 | 3 | 121 | 0 | -35.4735 | 149.0124 | 2021-06-15 04:22:22 | Australian Capital Territory, Australia | ||
1563788 | 1563788 | 2021-06-14 | Australia | New South Wales | 5623 | 54 | 0 | 5569 | -33.8688 | 151.2093 | 2021-06-15 04:22:22 | New South Wales, Australia | ||
1563789 | 1563789 | 2021-06-14 | Australia | Northern Territory | 175 | 0 | 173 | 2 | -12.4634 | 130.8456 | 2021-06-15 04:22:22 | Northern Territory, Australia | ||
1563790 | 1563790 | 2021-06-14 | Australia | Queensland | 1655 | 7 | 1604 | 44 | -27.4698 | 153.0251 | 2021-06-15 04:22:22 | Queensland, Australia | ||
1563791 | 1563791 | 2021-06-14 | Australia | South Australia | 775 | 4 | 769 | 2 | -34.9285 | 138.6007 | 2021-06-15 04:22:22 | South Australia, Australia | ||
1563792 | 1563792 | 2021-06-14 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-06-15 04:22:22 | Tasmania, Australia | ||
1563793 | 1563793 | 2021-06-14 | Australia | Victoria | 20668 | 820 | 19795 | 53 | -37.8136 | 144.9631 | 2021-06-15 04:22:22 | Victoria, Australia | ||
1563794 | 1563794 | 2021-06-14 | Australia | Western Australia | 1019 | 9 | 1009 | 1 | -31.9505 | 115.8605 | 2021-06-15 04:22:22 | Western Australia, Australia | ||
1563795 | 1563795 | 2021-06-14 | Austria | 644058 | 13012 | 634123 | 3947 | 47.5162 | 14.5501 | 2021-06-15 04:22:22 | Austria | |||
1563796 | 1563796 | 2021-06-14 | Azerbaijan | 335196 | 4955 | 328699 | 1542 | 40.1431 | 47.5769 | 2021-06-15 04:22:22 | Azerbaijan | |||
1563797 | 1563797 | 2021-06-14 | Bahamas | 12199 | 237 | 11136 | 826 | 25.025885 | -78.035889 | 2021-06-15 04:22:22 | Bahamas | |||
1563798 | 1563798 | 2021-06-14 | Bahrain | 259523 | 1236 | 246074 | 12213 | 26.0275 | 50.55 | 2021-06-15 04:22:22 | Bahrain | |||
1563799 | 1563799 | 2021-06-14 | Bangladesh | 829972 | 13172 | 768830 | 47970 | 23.685 | 90.3563 | 2021-06-15 04:22:22 | Bangladesh | |||
1563800 | 1563800 | 2021-06-14 | Barbados | 4037 | 47 | 3971 | 19 | 13.1939 | -59.5432 | 2021-06-15 04:22:22 | Barbados | |||
1563801 | 1563801 | 2021-06-14 | Belarus | 406360 | 2987 | 399174 | 4199 | 53.7098 | 27.9534 | 2021-06-15 04:22:22 | Belarus | |||
1563802 | 1563802 | 2021-06-14 | Belgium | Antwerp | 140202 | 0 | 0 | 140202 | 51.2195 | 4.4024 | 2021-06-15 04:22:22 | Antwerp, Belgium | ||
1563803 | 1563803 | 2021-06-14 | Belgium | Brussels | 132371 | 0 | 0 | 132371 | 50.8503 | 4.3517 | 2021-06-15 04:22:22 | Brussels, Belgium | ||
1563804 | 1563804 | 2021-06-14 | Belgium | East Flanders | 123324 | 0 | 0 | 123324 | 51.0362 | 3.7373 | 2021-06-15 04:22:22 | East Flanders, Belgium | ||
1563805 | 1563805 | 2021-06-14 | Belgium | Flemish Brabant | 81934 | 0 | 0 | 81934 | 50.9167 | 4.5833 | 2021-06-15 04:22:22 | Flemish Brabant, Belgium | ||
1563806 | 1563806 | 2021-06-14 | Belgium | Hainaut | 158752 | 0 | 0 | 158752 | 50.5257 | 4.0621 | 2021-06-15 04:22:22 | Hainaut, Belgium | ||
1563807 | 1563807 | 2021-06-14 | Belgium | Liege | 129847 | 0 | 0 | 129847 | 50.4496 | 5.8492 | 2021-06-15 04:22:22 | Liege, Belgium | ||
1563808 | 1563808 | 2021-06-14 | Belgium | Limburg | 60716 | 0 | 0 | 60716 | 50.9739 | 5.3420000000000005 | 2021-06-15 04:22:22 | Limburg, Belgium | ||
1563809 | 1563809 | 2021-06-14 | Belgium | Luxembourg | 31152 | 0 | 0 | 31152 | 50.0547 | 5.4677 | 2021-06-15 04:22:22 | Luxembourg, Belgium | ||
1563810 | 1563810 | 2021-06-14 | Belgium | Namur | 59091 | 0 | 0 | 59091 | 50.331 | 4.8221 | 2021-06-15 04:22:22 | Namur, Belgium | ||
1563811 | 1563811 | 2021-06-14 | Belgium | Unknown | 20670 | 25093 | 0 | 0 | 2021-06-15 04:22:22 | Unknown, Belgium | ||||
1563812 | 1563812 | 2021-06-14 | Belgium | Walloon Brabant | 41397 | 0 | 0 | 41397 | 50.4 | 4.35 | 2021-06-15 04:22:22 | Walloon Brabant, Belgium | ||
1563813 | 1563813 | 2021-06-14 | Belgium | West Flanders | 97123 | 0 | 0 | 97123 | 51.0536 | 3.1458 | 2021-06-15 04:22:22 | West Flanders, Belgium | ||
1563814 | 1563814 | 2021-06-14 | Belize | 12971 | 326 | 12479 | 166 | 17.1899 | -88.4976 | 2021-06-15 04:22:22 | Belize | |||
1563815 | 1563815 | 2021-06-14 | Benin | 8109 | 102 | 7979 | 28 | 9.3077 | 2.3158 | 2021-06-15 04:22:22 | Benin | |||
1563816 | 1563816 | 2021-06-14 | Bhutan | 1826 | 1 | 1467 | 358 | 27.5142 | 90.4336 | 2021-06-15 04:22:22 | Bhutan | |||
1563817 | 1563817 | 2021-06-14 | Bolivia | 409106 | 15614 | 324028 | 69464 | -16.2902 | -63.5887 | 2021-06-15 04:22:22 | Bolivia | |||
1563818 | 1563818 | 2021-06-14 | Bosnia and Herzegovina | 204668 | 9495 | 177976 | 17197 | 43.9159 | 17.6791 | 2021-06-15 04:22:22 | Bosnia and Herzegovina | |||
1563819 | 1563819 | 2021-06-14 | Botswana | 61457 | 926 | 56798 | 3733 | -22.3285 | 24.6849 | 2021-06-15 04:22:22 | Botswana | |||
1563820 | 1563820 | 2021-06-14 | Brazil | Acre | 84337 | 1719 | 78886 | 3732 | -9.0238 | -70.812 | 2021-06-15 04:22:22 | Acre, Brazil | ||
1563821 | 1563821 | 2021-06-14 | Brazil | Alagoas | 204126 | 5020 | 193884 | 5222 | -9.5713 | -36.782 | 2021-06-15 04:22:22 | Alagoas, Brazil | ||
1563822 | 1563822 | 2021-06-14 | Brazil | Amapa | 114503 | 1769 | 90692 | 22042 | 0.902 | -52.003 | 2021-06-15 04:22:22 | Amapa, Brazil | ||
1563823 | 1563823 | 2021-06-14 | Brazil | Amazonas | 393875 | 13149 | 337529 | 43197 | -3.4168 | -65.8561 | 2021-06-15 04:22:22 | Amazonas, Brazil | ||
1563824 | 1563824 | 2021-06-14 | Brazil | Bahia | 1066552 | 22601 | 1030977 | 12974 | -12.5797 | -41.7007 | 2021-06-15 04:22:22 | Bahia, Brazil | ||
1563825 | 1563825 | 2021-06-14 | Brazil | Ceara | 848248 | 21460 | 588565 | 238223 | -5.4984 | -39.3206 | 2021-06-15 04:22:22 | Ceara, Brazil | ||
1563826 | 1563826 | 2021-06-14 | Brazil | Distrito Federal | 418089 | 8976 | 398721 | 10392 | -15.7998 | -47.8645 | 2021-06-15 04:22:22 | Distrito Federal, Brazil | ||
1563827 | 1563827 | 2021-06-14 | Brazil | Espirito Santo | 499839 | 11173 | 473312 | 15354 | -19.1834 | -40.3089 | 2021-06-15 04:22:22 | Espirito Santo, Brazil | ||
1563828 | 1563828 | 2021-06-14 | Brazil | Goias | 641993 | 18093 | 611089 | 9818 | -15.827 | -49.8362 | 2021-06-15 04:22:22 | Goias, Brazil | ||
1563829 | 1563829 | 2021-06-14 | Brazil | Maranhao | 301547 | 8567 | 263681 | 29299 | -4.9609 | -45.2744 | 2021-06-15 04:22:22 | Maranhao, Brazil | ||
1563830 | 1563830 | 2021-06-14 | Brazil | Mato Grosso | 429557 | 11466 | 404050 | 11736 | -12.6819 | -56.9211 | 2021-06-15 04:22:22 | Mato Grosso, Brazil | ||
1563831 | 1563831 | 2021-06-14 | Brazil | Mato Grosso do Sul | 315832 | 7569 | 288044 | 18884 | -20.7722 | -54.7852 | 2021-06-15 04:22:22 | Mato Grosso do Sul, Brazil | ||
1563832 | 1563832 | 2021-06-14 | Brazil | Minas Gerais | 1684962 | 43154 | 1547087 | 94721 | -18.5122 | -44.555 | 2021-06-15 04:22:22 | Minas Gerais, Brazil | ||
1563833 | 1563833 | 2021-06-14 | Brazil | Para | 535640 | 15005 | 499891 | 19209 | -1.9981 | -54.9306 | 2021-06-15 04:22:22 | Para, Brazil | ||
1563834 | 1563834 | 2021-06-14 | Brazil | Paraiba | 361435 | 8158 | 236555 | 116722 | -7.24 | -36.782 | 2021-06-15 04:22:22 | Paraiba, Brazil | ||
1563835 | 1563835 | 2021-06-14 | Brazil | Parana | 1152368 | 28208 | 805154 | 318549 | -25.2521 | -52.0215 | 2021-06-15 04:22:22 | Parana, Brazil | ||
1563836 | 1563836 | 2021-06-14 | Brazil | Pernambuco | 520694 | 16860 | 432119 | 71715 | -8.8137 | -36.9541 | 2021-06-15 04:22:22 | Pernambuco, Brazil | ||
1563837 | 1563837 | 2021-06-14 | Brazil | Piaui | 285644 | 6265 | 277980 | 816 | -7.7183 | -42.7289 | 2021-06-15 04:22:22 | Piaui, Brazil | ||
1563838 | 1563838 | 2021-06-14 | Brazil | Rio Grande do Norte | 286577 | 6508 | 150649 | 127206 | -5.4026 | -36.9541 | 2021-06-15 04:22:22 | Rio Grande do Norte, Brazil | ||
1563839 | 1563839 | 2021-06-14 | Brazil | Rio Grande do Sul | 1149424 | 29701 | 1100220 | 19503 | -30.0346 | -51.2177 | 2021-06-15 04:22:22 | Rio Grande do Sul, Brazil | ||
1563840 | 1563840 | 2021-06-14 | Brazil | Rio de Janeiro | 909341 | 53015 | 845952 | 10374 | -22.9068 | -43.1729 | 2021-06-15 04:22:22 | Rio de Janeiro, Brazil | ||
1563841 | 1563841 | 2021-06-14 | Brazil | Rondonia | 239067 | 5944 | 224510 | 8613 | -11.5057 | -63.5806 | 2021-06-15 04:22:22 | Rondonia, Brazil | ||
1563842 | 1563842 | 2021-06-14 | Brazil | Roraima | 107872 | 1680 | 101156 | 4811 | -2.7376 | -62.0751 | 2021-06-15 04:22:22 | Roraima, Brazil | ||
1563843 | 1563843 | 2021-06-14 | Brazil | Santa Catarina | 1008059 | 16006 | 966868 | 25185 | -27.2423 | -50.2189 | 2021-06-15 04:22:22 | Santa Catarina, Brazil | ||
1563844 | 1563844 | 2021-06-14 | Brazil | Sao Paulo | 3464158 | 118213 | 3075383 | 270562 | -23.5505 | -46.6333 | 2021-06-15 04:22:22 | Sao Paulo, Brazil | ||
1563845 | 1563845 | 2021-06-14 | Brazil | Sergipe | 252753 | 5405 | 230141 | 17207 | -10.5741 | -37.3857 | 2021-06-15 04:22:22 | Sergipe, Brazil | ||
1563846 | 1563846 | 2021-06-14 | Brazil | Tocantins | 189136 | 3042 | 168302 | 16921 | -10.1753 | -48.2982 | 2021-06-15 04:22:22 | Tocantins, Brazil | ||
1563847 | 1563847 | 2021-06-14 | Brunei | 248 | 3 | 239 | 6 | 4.5353 | 114.7277 | 2021-06-15 04:22:22 | Brunei | |||
1563848 | 1563848 | 2021-06-14 | Bulgaria | 420493 | 17915 | 390388 | 12190 | 42.7339 | 25.4858 | 2021-06-15 04:22:22 | Bulgaria | |||
1563849 | 1563849 | 2021-06-14 | Burkina Faso | 13459 | 167 | 13272 | 20 | 12.2383 | -1.5616 | 2021-06-15 04:22:22 | Burkina Faso | |||
1563850 | 1563850 | 2021-06-14 | Burma | 145826 | 3248 | 132969 | 9609 | 21.9162 | 95.956 | 2021-06-15 04:22:22 | Burma | |||
1563851 | 1563851 | 2021-06-14 | Burundi | 5026 | 8 | 773 | 4245 | -3.3731 | 29.9189 | 2021-06-15 04:22:22 | Burundi | |||
1563852 | 1563852 | 2021-06-14 | Cabo Verde | 31647 | 276 | 30542 | 829 | 16.5388 | -23.0418 | 2021-06-15 04:22:22 | Cabo Verde | |||
1563853 | 1563853 | 2021-06-14 | Cambodia | 38969 | 348 | 32967 | 5654 | 11.55 | 104.9167 | 2021-06-15 04:22:22 | Cambodia | |||
1563854 | 1563854 | 2021-06-14 | Cameroon | 80090 | 1310 | 35261 | 43519 | 3.848 | 11.5021 | 2021-06-15 04:22:22 | Cameroon | |||
1563855 | 1563855 | 2021-06-14 | Canada | Alberta | 230578 | 2270 | 225219 | 3089 | 53.9333 | -116.5765 | 2021-06-15 04:22:22 | Alberta, Canada | ||
1563856 | 1563856 | 2021-06-14 | Canada | British Columbia | 146453 | 1734 | 143147 | 1572 | 53.7267 | -127.6476 | 2021-06-15 04:22:22 | British Columbia, Canada | ||
1563857 | 1563857 | 2021-06-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1563858 | 1563858 | 2021-06-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1563859 | 1563859 | 2021-06-14 | Canada | Manitoba | 54481 | 1102 | 50268 | 3111 | 53.7609 | -98.8139 | 2021-06-15 04:22:22 | Manitoba, Canada | ||
1563860 | 1563860 | 2021-06-14 | Canada | New Brunswick | 2299 | 45 | 2163 | 91 | 46.5653 | -66.4619 | 2021-06-15 04:22:22 | New Brunswick, Canada | ||
1563861 | 1563861 | 2021-06-14 | Canada | Newfoundland and Labrador | 1379 | 7 | 1329 | 43 | 53.1355 | -57.6604 | 2021-06-15 04:22:22 | Newfoundland and Labrador, Canada | ||
1563862 | 1563862 | 2021-06-14 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-15 04:22:22 | Northwest Territories,Canada | ||
1563863 | 1563863 | 2021-06-14 | Canada | Nova Scotia | 5749 | 90 | 5535 | 124 | 44.682 | -63.7443 | 2021-06-15 04:22:22 | Nova Scotia, Canada | ||
1563864 | 1563864 | 2021-06-14 | Canada | Nunavut | 657 | 4 | 644 | 9 | 70.2998 | -83.1076 | 2021-06-15 04:22:22 | Nunavut, Canada | ||
1563865 | 1563865 | 2021-06-14 | Canada | Ontario | 544536 | 8961 | 533335 | 5361 | 51.2538 | -85.3232 | 2021-06-15 04:22:22 | Ontario, Canada | ||
1563866 | 1563866 | 2021-06-14 | Canada | Prince Edward Island | 206 | 0 | 202 | 4 | 46.5107 | -63.4168 | 2021-06-15 04:22:22 | Prince Edward Island, Canada | ||
1563867 | 1563867 | 2021-06-14 | Canada | Quebec | 373512 | 11173 | 360194 | 2145 | 52.9399 | -73.5491 | 2021-06-15 04:22:22 | Quebec, Canada | ||
1563868 | 1563868 | 2021-06-14 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2021-06-15 04:22:22 | Repatriated Travellers, Canada | ||||
1563869 | 1563869 | 2021-06-14 | Canada | Saskatchewan | 47996 | 556 | 46666 | 774 | 52.9399 | -106.4509 | 2021-06-15 04:22:22 | Saskatchewan, Canada | ||
1563870 | 1563870 | 2021-06-14 | Canada | Yukon | 107 | 3 | 85 | 19 | 64.2823 | -135.0 | 2021-06-15 04:22:22 | Yukon, Canada | ||
1563871 | 1563871 | 2021-06-14 | Central African Republic | 7101 | 98 | 6859 | 144 | 6.6111 | 20.9394 | 2021-06-15 04:22:22 | Central African Republic | |||
1563872 | 1563872 | 2021-06-14 | Chad | 4943 | 174 | 4767 | 2 | 15.4542 | 18.7322 | 2021-06-15 04:22:22 | Chad | |||
1563873 | 1563873 | 2021-06-14 | Chile | Antofagasta | 55534 | 1080 | 53386 | 1068 | -23.6509 | -70.3975 | 2021-06-15 04:22:22 | Antofagasta, Chile | ||
1563874 | 1563874 | 2021-06-14 | Chile | Araucania | 88114 | 1142 | 84738 | 2234 | -38.9489 | -72.3311 | 2021-06-15 04:22:22 | Araucania, Chile | ||
1563875 | 1563875 | 2021-06-14 | Chile | Arica y Parinacota | 23938 | 463 | 22824 | 651 | -18.594 | -69.4785 | 2021-06-15 04:22:22 | Arica y Parinacota, Chile | ||
1563876 | 1563876 | 2021-06-14 | Chile | Atacama | 23005 | 258 | 22000 | 747 | -27.5661 | -70.0503 | 2021-06-15 04:22:22 | Atacama, Chile | ||
1563877 | 1563877 | 2021-06-14 | Chile | Aysen | 6946 | 49 | 6483 | 414 | -45.9864 | -73.7669 | 2021-06-15 04:22:22 | Aysen, Chile | ||
1563878 | 1563878 | 2021-06-14 | Chile | Biobio | 137642 | 2200 | 132014 | 3428 | -37.4464 | -72.1416 | 2021-06-15 04:22:22 | 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]);