johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

824,209 rows sorted by day descending

View and edit SQL

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
739870 2020-10-16 Afghanistan       40073 1485 33516 5072 33.93911 67.709953 2020-10-17 04:24:12 Afghanistan
739871 2020-10-16 Albania       16501 443 9957 6101 41.1533 20.1683 2020-10-17 04:24:12 Albania
739872 2020-10-16 Algeria       53998 1841 37856 14301 28.0339 1.6596 2020-10-17 04:24:12 Algeria
739873 2020-10-16 Andorra       3377 59 2057 1261 42.5063 1.5218 2020-10-17 04:24:12 Andorra
739874 2020-10-16 Angola       7222 234 3012 3976 -11.2027 17.8739 2020-10-17 04:24:12 Angola
739875 2020-10-16 Antigua and Barbuda       112 3 100 9 17.0608 -61.7964 2020-10-17 04:24:12 Antigua and Barbuda
739876 2020-10-16 Argentina       965609 25723 778501 161385 -38.4161 -63.6167 2020-10-17 04:24:12 Argentina
739877 2020-10-16 Armenia       61460 1056 47541 12863 40.0691 45.0382 2020-10-17 04:24:12 Armenia
739878 2020-10-16 Australia Australian Capital Territory     113 3 110 0 -35.4735 149.0124 2020-10-17 04:24:12 Australian Capital Territory, Australia
739879 2020-10-16 Australia New South Wales     4333 53 3142 1138 -33.8688 151.2093 2020-10-17 04:24:12 New South Wales, Australia
739880 2020-10-16 Australia Northern Territory     33 0 33 0 -12.4634 130.8456 2020-10-17 04:24:12 Northern Territory, Australia
739881 2020-10-16 Australia Queensland     1164 6 1154 4 -27.4698 153.0251 2020-10-17 04:24:12 Queensland, Australia
739882 2020-10-16 Australia South Australia     479 4 471 4 -34.9285 138.6007 2020-10-17 04:24:12 South Australia, Australia
739883 2020-10-16 Australia Tasmania     230 13 217 0 -42.8821 147.3272 2020-10-17 04:24:12 Tasmania, Australia
739884 2020-10-16 Australia Victoria     20317 816 19287 214 -37.8136 144.9631 2020-10-17 04:24:12 Victoria, Australia
739885 2020-10-16 Australia Western Australia     709 9 683 17 -31.9505 115.8605 2020-10-17 04:24:12 Western Australia, Australia
739886 2020-10-16 Austria       61387 882 47618 12887 47.5162 14.5501 2020-10-17 04:24:12 Austria
739887 2020-10-16 Azerbaijan       43789 621 39800 3368 40.1431 47.5769 2020-10-17 04:24:12 Azerbaijan
739888 2020-10-16 Bahamas       5517 114 3201 2202 25.025885 -78.035889 2020-10-17 04:24:12 Bahamas
739889 2020-10-16 Bahrain       77325 292 73421 3612 26.0275 50.55 2020-10-17 04:24:12 Bahrain
739890 2020-10-16 Bangladesh       386086 5623 300738 79725 23.685 90.3563 2020-10-17 04:24:12 Bangladesh
739891 2020-10-16 Barbados       219 7 195 17 13.1939 -59.5432 2020-10-17 04:24:12 Barbados
739892 2020-10-16 Belarus       86392 921 78990 6481 53.7098 27.9534 2020-10-17 04:24:12 Belarus
739893 2020-10-16 Belgium       202151 10359 20867 170925 50.8333 4.469936 2020-10-17 04:24:12 Belgium
739894 2020-10-16 Belize       2728 43 1626 1059 17.1899 -88.4976 2020-10-17 04:24:12 Belize
739895 2020-10-16 Benin       2496 41 2330 125 9.3077 2.3158 2020-10-17 04:24:12 Benin
739896 2020-10-16 Bhutan       316 0 298 18 27.5142 90.4336 2020-10-17 04:24:12 Bhutan
739897 2020-10-16 Bolivia       139562 8439 103896 27227 -16.2902 -63.5887 2020-10-17 04:24:12 Bolivia
739898 2020-10-16 Bosnia and Herzegovina       32845 980 24603 7262 43.9159 17.6791 2020-10-17 04:24:12 Bosnia and Herzegovina
739899 2020-10-16 Botswana       5242 20 905 4317 -22.3285 24.6849 2020-10-17 04:24:12 Botswana
739900 2020-10-16 Brazil Acre     29598 679 27176 1743 -9.0238 -70.812 2020-10-17 04:24:12 Acre, Brazil
739901 2020-10-16 Brazil Alagoas     89278 2167 85557 1554 -9.5713 -36.782 2020-10-17 04:24:12 Alagoas, Brazil
739902 2020-10-16 Brazil Amapa     50072 730 36905 12437 0.902 -52.003 2020-10-17 04:24:12 Amapa, Brazil
739903 2020-10-16 Brazil Amazonas     149784 4305 120012 25467 -3.4168 -65.8561 2020-10-17 04:24:12 Amazonas, Brazil
739904 2020-10-16 Brazil Bahia     332898 7267 311054 14577 -12.5797 -41.7007 2020-10-17 04:24:12 Bahia, Brazil
739905 2020-10-16 Brazil Ceara     263143 9199 223281 30663 -5.4984 -39.3206 2020-10-17 04:24:12 Ceara, Brazil
739906 2020-10-16 Brazil Distrito Federal     203576 3526 189807 10243 -15.7998 -47.8645 2020-10-17 04:24:12 Distrito Federal, Brazil
739907 2020-10-16 Brazil Espirito Santo     143093 3704 127835 11554 -19.1834 -40.3089 2020-10-17 04:24:12 Espirito Santo, Brazil
739908 2020-10-16 Brazil Goias     236105 5348 218177 12580 -15.827 -49.8362 2020-10-17 04:24:12 Goias, Brazil
739909 2020-10-16 Brazil Maranhao     180560 3914 167126 9520 -4.9609 -45.2744 2020-10-17 04:24:12 Maranhao, Brazil
739910 2020-10-16 Brazil Mato Grosso     134696 3649 112218 18829 -12.6819 -56.9211 2020-10-17 04:24:12 Mato Grosso, Brazil
739911 2020-10-16 Brazil Mato Grosso do Sul     76547 1478 68629 6440 -20.7722 -54.7852 2020-10-17 04:24:12 Mato Grosso do Sul, Brazil
739912 2020-10-16 Brazil Minas Gerais     331433 8345 286280 36808 -18.5122 -44.555 2020-10-17 04:24:12 Minas Gerais, Brazil
739913 2020-10-16 Brazil Para     240223 6670 221997 11556 -1.9981 -54.9306 2020-10-17 04:24:12 Para, Brazil
739914 2020-10-16 Brazil Paraiba     128032 2977 101073 23982 -7.24 -36.782 2020-10-17 04:24:12 Paraiba, Brazil
739915 2020-10-16 Brazil Parana     197941 4913 140100 52928 -25.2521 -52.0215 2020-10-17 04:24:12 Parana, Brazil
739916 2020-10-16 Brazil Pernambuco     155520 8469 131135 15916 -8.8137 -36.9541 2020-10-17 04:24:12 Pernambuco, Brazil
739917 2020-10-16 Brazil Piaui     105156 2269 99255 3632 -7.7183 -42.7289 2020-10-17 04:24:12 Piaui, Brazil
739918 2020-10-16 Brazil Rio Grande do Norte     76660 2547 42040 32073 -5.4026 -36.9541 2020-10-17 04:24:12 Rio Grande do Norte, Brazil
739919 2020-10-16 Brazil Rio Grande do Sul     220563 5312 198688 16563 -30.0346 -51.2177 2020-10-17 04:24:12 Rio Grande do Sul, Brazil
739920 2020-10-16 Brazil Rio de Janeiro     289440 19654 258928 10858 -22.9068 -43.1729 2020-10-17 04:24:12 Rio de Janeiro, Brazil
739921 2020-10-16 Brazil Rondonia     68823 1421 60189 7213 -11.5057 -63.5806 2020-10-17 04:24:12 Rondonia, Brazil
739922 2020-10-16 Brazil Roraima     53726 680 48508 4538 -2.7376 -62.0751 2020-10-17 04:24:12 Roraima, Brazil
739923 2020-10-16 Brazil Santa Catarina     232933 2962 213495 16476 -27.2423 -50.2189 2020-10-17 04:24:12 Santa Catarina, Brazil
739924 2020-10-16 Brazil Sao Paulo     1057240 37870 908199 111171 -23.5505 -46.6333 2020-10-17 04:24:12 Sao Paulo, Brazil
739925 2020-10-16 Brazil Sergipe     80925 2124 73030 5771 -10.5741 -37.3857 2020-10-17 04:24:12 Sergipe, Brazil
739926 2020-10-16 Brazil Tocantins     72335 1035 55699 15601 -10.1753 -48.2982 2020-10-17 04:24:12 Tocantins, Brazil
739927 2020-10-16 Brunei       147 3 143 1 4.5353 114.7277 2020-10-17 04:24:12 Brunei
739928 2020-10-16 Bulgaria       28505 958 16875 10672 42.7339 25.4858 2020-10-17 04:24:12 Bulgaria
739929 2020-10-16 Burkina Faso       2343 65 1718 560 12.2383 -1.5616 2020-10-17 04:24:12 Burkina Faso
739930 2020-10-16 Burma       33488 799 15477 17212 21.9162 95.956 2020-10-17 04:24:12 Burma
739931 2020-10-16 Burundi       531 1 497 33 -3.3731 29.9189 2020-10-17 04:24:12 Burundi
739932 2020-10-16 Cabo Verde       7526 82 6425 1019 16.5388 -23.0418 2020-10-17 04:24:12 Cabo Verde
739933 2020-10-16 Cambodia       283 0 280 3 11.55 104.9167 2020-10-17 04:24:12 Cambodia
739934 2020-10-16 Cameroon       21441 423 20117 901 3.848 11.5021 2020-10-17 04:24:12 Cameroon
739935 2020-10-16 Canada Alberta     21775 288 18651 2836 53.9333 -116.5765 2020-10-17 04:24:12 Alberta, Canada
739936 2020-10-16 Canada British Columbia     11189 251 9425 1513 53.7267 -127.6476 2020-10-17 04:24:12 British Columbia, Canada
739937 2020-10-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-10-17 04:24:12 Diamond Princess, Canada
739938 2020-10-16 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-10-17 04:24:12 Grand Princess, Canada
739939 2020-10-16 Canada Manitoba     3173 38 1553 1582 53.7609 -98.8139 2020-10-17 04:24:12 Manitoba, Canada
739940 2020-10-16 Canada New Brunswick     297 2 203 92 46.5653 -66.4619 2020-10-17 04:24:12 New Brunswick, Canada
739941 2020-10-16 Canada Newfoundland and Labrador     287 4 271 12 53.1355 -57.6604 2020-10-17 04:24:12 Newfoundland and Labrador, Canada
739942 2020-10-16 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-10-17 04:24:12 Northwest Territories,Canada
739943 2020-10-16 Canada Nova Scotia     1093 65 1024 4 44.682 -63.7443 2020-10-17 04:24:12 Nova Scotia, Canada
739944 2020-10-16 Canada Ontario     65730 3089 56635 6006 51.2538 -85.3232 2020-10-17 04:24:12 Ontario, Canada
739945 2020-10-16 Canada Prince Edward Island     63 0 60 3 46.5107 -63.4168 2020-10-17 04:24:12 Prince Edward Island, Canada
739946 2020-10-16 Canada Quebec     91018 6018 76512 8488 52.9399 -73.5491 2020-10-17 04:24:12 Quebec, Canada
739947 2020-10-16 Canada Saskatchewan     2270 25 1946 299 52.9399 -106.4509 2020-10-17 04:24:12 Saskatchewan, Canada
739948 2020-10-16 Canada Yukon     15 0 15 0 64.2823 -135.0 2020-10-17 04:24:12 Yukon, Canada
739949 2020-10-16 Central African Republic       4855 62 1924 2869 6.6111 20.9394 2020-10-17 04:24:12 Central African Republic
739950 2020-10-16 Chad       1361 93 1138 130 15.4542 18.7322 2020-10-17 04:24:12 Chad
739951 2020-10-16 Chile Antofagasta     20742 514 19768 460 -23.6509 -70.3975 2020-10-17 04:24:12 Antofagasta, Chile
739952 2020-10-16 Chile Araucania     9842 130 8473 1239 -38.9489 -72.3311 2020-10-17 04:24:12 Araucania, Chile
739953 2020-10-16 Chile Arica y Parinacota     9021 164 8362 495 -18.594 -69.4785 2020-10-17 04:24:12 Arica y Parinacota, Chile
739954 2020-10-16 Chile Atacama     7506 79 7167 260 -27.5661 -70.0503 2020-10-17 04:24:12 Atacama, Chile
739955 2020-10-16 Chile Aysen     792 2 608 182 -45.9864 -73.7669 2020-10-17 04:24:12 Aysen, Chile
739956 2020-10-16 Chile Biobio     26569 401 24359 1809 -37.4464 -72.1416 2020-10-17 04:24:12 Biobio, Chile
739957 2020-10-16 Chile Coquimbo     12421 230 11986 205 -29.959 -71.3389 2020-10-17 04:24:12 Coquimbo, Chile
739958 2020-10-16 Chile Los Lagos     11926 111 10268 1547 -41.9198 -72.1416 2020-10-17 04:24:12 Los Lagos, Chile
739959 2020-10-16 Chile Los Rios     2616 26 2177 413 -40.231 -72.3311 2020-10-17 04:24:12 Los Rios, Chile
739960 2020-10-16 Chile Magallanes     11130 114 9977 1039 -52.368 -70.9863 2020-10-17 04:24:12 Magallanes, Chile
739961 2020-10-16 Chile Maule     17498 375 16219 904 -35.5183 -71.6885 2020-10-17 04:24:12 Maule, Chile
739962 2020-10-16 Chile Metropolitana     292059 9581 279478 3000 -33.4376 -70.6505 2020-10-17 04:24:12 Metropolitana, Chile
739963 2020-10-16 Chile Nuble     6909 137 6503 269 -36.7226 -71.7622 2020-10-17 04:24:12 Nuble, Chile
739964 2020-10-16 Chile OHiggins     17639 455 16563 621 -34.5755 -71.0022 2020-10-17 04:24:12 OHiggins, Chile
739965 2020-10-16 Chile Tarapaca     12351 236 11810 305 -19.9232 -69.5132 2020-10-17 04:24:12 Tarapaca, Chile
739966 2020-10-16 Chile Unknown     52 1 52       2020-10-17 04:24:12 Unknown, Chile
739967 2020-10-16 Chile Valparaiso     29117 973 27327 817 -33.0472 -71.6127 2020-10-17 04:24:12 Valparaiso, Chile
739968 2020-10-16 China Anhui     991 6 985 0 31.8257 117.2264 2020-10-17 04:24:12 Anhui, China
739969 2020-10-16 China Beijing     937 9 927 1 40.1824 116.4142 2020-10-17 04:24:12 Beijing, China

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 3869.258ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette