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

701,555 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
223557 2020-09-15 Afghanistan       38815 1426 32098 5291 33.93911 67.709953 2020-09-16 04:22:53 Afghanistan
223558 2020-09-15 Albania       11672 340 6668 4664 41.1533 20.1683 2020-09-16 04:22:53 Albania
223559 2020-09-15 Algeria       48734 1632 34385 12717 28.0339 1.6596 2020-09-16 04:22:53 Algeria
223560 2020-09-15 Andorra       1438 53 945 440 42.5063 1.5218 2020-09-16 04:22:53 Andorra
223561 2020-09-15 Angola       3569 139 1332 2098 -11.2027 17.8739 2020-09-16 04:22:53 Angola
223562 2020-09-15 Antigua and Barbuda       95 3 91 1 17.0608 -61.7964 2020-09-16 04:22:53 Antigua and Barbuda
223563 2020-09-15 Argentina       577338 11852 438883 126603 -38.4161 -63.6167 2020-09-16 04:22:53 Argentina
223564 2020-09-15 Armenia       46119 920 41941 3258 40.0691 45.0382 2020-09-16 04:22:53 Armenia
223565 2020-09-15 Australia Australian Capital Territory     113 3 110 0 -35.4735 149.0124 2020-09-16 04:22:53 Australian Capital Territory, Australia
223566 2020-09-15 Australia New South Wales     4185 52 2994 1139 -33.8688 151.2093 2020-09-16 04:22:53 New South Wales, Australia
223567 2020-09-15 Australia Northern Territory     33 0 31 2 -12.4634 130.8456 2020-09-16 04:22:53 Northern Territory, Australia
223568 2020-09-15 Australia Queensland     1149 6 1111 32 -27.4698 153.0251 2020-09-16 04:22:53 Queensland, Australia
223569 2020-09-15 Australia South Australia     466 4 462 0 -34.9285 138.6007 2020-09-16 04:22:53 South Australia, Australia
223570 2020-09-15 Australia Tasmania     230 13 217 0 -42.8821 147.3272 2020-09-16 04:22:53 Tasmania, Australia
223571 2020-09-15 Australia Victoria     19943 737 18079 1127 -37.8136 144.9631 2020-09-16 04:22:53 Victoria, Australia
223572 2020-09-15 Australia Western Australia     659 9 646 4 -31.9505 115.8605 2020-09-16 04:22:53 Western Australia, Australia
223573 2020-09-15 Austria       34305 757 27354 6194 47.5162 14.5501 2020-09-16 04:22:53 Austria
223574 2020-09-15 Azerbaijan       38517 566 35998 1953 40.1431 47.5769 2020-09-16 04:22:53 Azerbaijan
223575 2020-09-15 Bahamas       3032 69 1482 1481 25.025885 -78.035889 2020-09-16 04:22:53 Bahamas
223576 2020-09-15 Bahrain       61643 213 54831 6599 26.0275 50.55 2020-09-16 04:22:53 Bahrain
223577 2020-09-15 Bangladesh       341056 4802 245594 90660 23.685 90.3563 2020-09-16 04:22:53 Bangladesh
223578 2020-09-15 Barbados       184 7 169 8 13.1939 -59.5432 2020-09-16 04:22:53 Barbados
223579 2020-09-15 Belarus       74552 761 72661 1130 53.7098 27.9534 2020-09-16 04:22:53 Belarus
223580 2020-09-15 Belgium       94795 9930 18789 66076 50.8333 4.469936 2020-09-16 04:22:53 Belgium
223581 2020-09-15 Belize       1528 19 663 846 17.1899 -88.4976 2020-09-16 04:22:53 Belize
223582 2020-09-15 Benin       2267 40 1942 285 9.3077 2.3158 2020-09-16 04:22:53 Benin
223583 2020-09-15 Bhutan       246 0 175 71 27.5142 90.4336 2020-09-16 04:22:53 Bhutan
223584 2020-09-15 Bolivia       128286 7447 86216 34623 -16.2902 -63.5887 2020-09-16 04:22:53 Bolivia
223585 2020-09-15 Bosnia and Herzegovina       23929 725 16701 6503 43.9159 17.6791 2020-09-16 04:22:53 Bosnia and Herzegovina
223586 2020-09-15 Botswana       2463 11 575 1877 -22.3285 24.6849 2020-09-16 04:22:53 Botswana
223587 2020-09-15 Brazil Acre     26287 642 23652 1993 -9.0238 -70.812 2020-09-16 04:22:53 Acre, Brazil
223588 2020-09-15 Brazil Alagoas     82595 1991 79411 1193 -9.5713 -36.782 2020-09-16 04:22:53 Alagoas, Brazil
223589 2020-09-15 Brazil Amapa     46117 682 33837 11598 0.902 -52.003 2020-09-16 04:22:53 Amapa, Brazil
223590 2020-09-15 Brazil Amazonas     128150 3907 107879 16364 -3.4168 -65.8561 2020-09-16 04:22:53 Amazonas, Brazil
223591 2020-09-15 Brazil Bahia     285448 6040 272127 7281 -12.5797 -41.7007 2020-09-16 04:22:53 Bahia, Brazil
223592 2020-09-15 Brazil Ceara     229072 8739 203561 16772 -5.4984 -39.3206 2020-09-16 04:22:53 Ceara, Brazil
223593 2020-09-15 Brazil Distrito Federal     178747 2970 165276 10501 -15.7998 -47.8645 2020-09-16 04:22:53 Distrito Federal, Brazil
223594 2020-09-15 Brazil Espirito Santo     120916 3372 110622 6922 -19.1834 -40.3089 2020-09-16 04:22:53 Espirito Santo, Brazil
223595 2020-09-15 Brazil Goias     170064 3885 161008 5171 -15.827 -49.8362 2020-09-16 04:22:53 Goias, Brazil
223596 2020-09-15 Brazil Maranhao     163802 3601 153613 6588 -4.9609 -45.2744 2020-09-16 04:22:53 Maranhao, Brazil
223597 2020-09-15 Brazil Mato Grosso     107486 3124 88853 15509 -12.6819 -56.9211 2020-09-16 04:22:53 Mato Grosso, Brazil
223598 2020-09-15 Brazil Mato Grosso do Sul     60297 1106 52437 6754 -20.7722 -54.7852 2020-09-16 04:22:53 Mato Grosso do Sul, Brazil
223599 2020-09-15 Brazil Minas Gerais     255606 6328 221210 28068 -18.5122 -44.555 2020-09-16 04:22:53 Minas Gerais, Brazil
223600 2020-09-15 Brazil Para     216318 6387 201503 8428 -1.9981 -54.9306 2020-09-16 04:22:53 Para, Brazil
223601 2020-09-15 Brazil Paraiba     113903 2649 86591 24663 -7.24 -36.782 2020-09-16 04:22:53 Paraiba, Brazil
223602 2020-09-15 Brazil Parana     155820 3918 108879 43023 -25.2521 -52.0215 2020-09-16 04:22:53 Parana, Brazil
223603 2020-09-15 Brazil Pernambuco     137869 7914 119554 10401 -8.8137 -36.9541 2020-09-16 04:22:53 Pernambuco, Brazil
223604 2020-09-15 Brazil Piaui     87213 1988 85447 -222 -7.7183 -42.7289 2020-09-16 04:22:53 Piaui, Brazil
223605 2020-09-15 Brazil Rio Grande do Norte     65647 2326 39207 24114 -5.4026 -36.9541 2020-09-16 04:22:53 Rio Grande do Norte, Brazil
223606 2020-09-15 Brazil Rio Grande do Sul     160940 4174 147529 9237 -30.0346 -51.2177 2020-09-16 04:22:53 Rio Grande do Sul, Brazil
223607 2020-09-15 Brazil Rio de Janeiro     244418 17180 220651 6587 -22.9068 -43.1729 2020-09-16 04:22:53 Rio de Janeiro, Brazil
223608 2020-09-15 Brazil Rondonia     61260 1269 51591 8400 -11.5057 -63.5806 2020-09-16 04:22:53 Rondonia, Brazil
223609 2020-09-15 Brazil Roraima     46848 611 14936 31301 -2.7376 -62.0751 2020-09-16 04:22:53 Roraima, Brazil
223610 2020-09-15 Brazil Santa Catarina     200241 2569 188493 9179 -27.2423 -50.2189 2020-09-16 04:22:53 Santa Catarina, Brazil
223611 2020-09-15 Brazil Sao Paulo     901271 32963 763246 105062 -23.5505 -46.6333 2020-09-16 04:22:53 Sao Paulo, Brazil
223612 2020-09-15 Brazil Sergipe     75203 1962 68277 4964 -10.5741 -37.3857 2020-09-16 04:22:53 Sergipe, Brazil
223613 2020-09-15 Brazil Tocantins     60725 822 42115 17788 -10.1753 -48.2982 2020-09-16 04:22:53 Tocantins, Brazil
223614 2020-09-15 Brunei       145 3 139 3 4.5353 114.7277 2020-09-16 04:22:53 Brunei
223615 2020-09-15 Bulgaria       18216 736 13057 4423 42.7339 25.4858 2020-09-16 04:22:53 Bulgaria
223616 2020-09-15 Burkina Faso       1733 56 1141 536 12.2383 -1.5616 2020-09-16 04:22:53 Burkina Faso
223617 2020-09-15 Burma       3636 39 832 2765 21.9162 95.956 2020-09-16 04:22:53 Burma
223618 2020-09-15 Burundi       472 1 374 97 -3.3731 29.9189 2020-09-16 04:22:53 Burundi
223619 2020-09-15 Cabo Verde       4904 46 4294 564 16.5388 -23.0418 2020-09-16 04:22:53 Cabo Verde
223620 2020-09-15 Cambodia       275 0 274 1 11.55 104.9167 2020-09-16 04:22:53 Cambodia
223621 2020-09-15 Cameroon       20271 415 18837 1019 3.848 11.5021 2020-09-16 04:22:53 Cameroon
223622 2020-09-15 Canada Alberta     15957 254 14212 1491 53.9333 -116.5765 2020-09-16 04:22:53 Alberta, Canada
223623 2020-09-15 Canada British Columbia     7376 219 5548 1609 53.7267 -127.6476 2020-09-16 04:22:53 British Columbia, Canada
223624 2020-09-15 Canada Diamond Princess     0 1 0   0.0 0.0 2020-09-16 04:22:53 Diamond Princess, Canada
223625 2020-09-15 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-09-16 04:22:53 Grand Princess, Canada
223626 2020-09-15 Canada Manitoba     1466 16 1181 269 53.7609 -98.8139 2020-09-16 04:22:53 Manitoba, Canada
223627 2020-09-15 Canada New Brunswick     194 2 189 3 46.5653 -66.4619 2020-09-16 04:22:53 New Brunswick, Canada
223628 2020-09-15 Canada Newfoundland and Labrador     271 3 267 1 53.1355 -57.6604 2020-09-16 04:22:53 Newfoundland and Labrador, Canada
223629 2020-09-15 Canada Northwest Territories     5 0 5 0 64.8255 -124.8457 2020-09-16 04:22:53 Northwest Territories,Canada
223630 2020-09-15 Canada Nova Scotia     1086 65 1020 1 44.682 -63.7443 2020-09-16 04:22:53 Nova Scotia, Canada
223631 2020-09-15 Canada Ontario     47165 2870 42027 2268 51.2538 -85.3232 2020-09-16 04:22:53 Ontario, Canada
223632 2020-09-15 Canada Prince Edward Island     57 0 56 1 46.5107 -63.4168 2020-09-16 04:22:53 Prince Edward Island, Canada
223633 2020-09-15 Canada Quebec     65554 5785 57628 2141 52.9399 -73.5491 2020-09-16 04:22:53 Quebec, Canada
223634 2020-09-15 Canada Saskatchewan     1741 24 1616 101 52.9399 -106.4509 2020-09-16 04:22:53 Saskatchewan, Canada
223635 2020-09-15 Canada Yukon     15 0 15 0 64.2823 -135.0 2020-09-16 04:22:53 Yukon, Canada
223636 2020-09-15 Central African Republic       4772 62 1828 2882 6.6111 20.9394 2020-09-16 04:22:53 Central African Republic
223637 2020-09-15 Chad       1087 81 944 62 15.4542 18.7322 2020-09-16 04:22:53 Chad
223638 2020-09-15 Chile Antofagasta     19175 478 18107 590 -23.6509 -70.3975 2020-09-16 04:22:53 Antofagasta, Chile
223639 2020-09-15 Chile Araucania     6066 101 5414 551 -38.9489 -72.3311 2020-09-16 04:22:53 Araucania, Chile
223640 2020-09-15 Chile Arica y Parinacota     7378 133 6803 442 -18.594 -69.4785 2020-09-16 04:22:53 Arica y Parinacota, Chile
223641 2020-09-15 Chile Atacama     6374 53 5879 442 -27.5661 -70.0503 2020-09-16 04:22:53 Atacama, Chile
223642 2020-09-15 Chile Aysen     175 1 129 45 -45.9864 -73.7669 2020-09-16 04:22:53 Aysen, Chile
223643 2020-09-15 Chile Biobio     20714 268 18429 2017 -37.4464 -72.1416 2020-09-16 04:22:53 Biobio, Chile
223644 2020-09-15 Chile Coquimbo     11264 178 10378 708 -29.959 -71.3389 2020-09-16 04:22:53 Coquimbo, Chile
223645 2020-09-15 Chile Los Lagos     7678 81 6937 660 -41.9198 -72.1416 2020-09-16 04:22:53 Los Lagos, Chile
223646 2020-09-15 Chile Los Rios     1442 15 1172 255 -40.231 -72.3311 2020-09-16 04:22:53 Los Rios, Chile
223647 2020-09-15 Chile Magallanes     5603 55 4223 1325 -52.368 -70.9863 2020-09-16 04:22:53 Magallanes, Chile
223648 2020-09-15 Chile Maule     13711 290 12071 1350 -35.5183 -71.6885 2020-09-16 04:22:53 Maule, Chile
223649 2020-09-15 Chile Metropolitana     280938 8914 267678 4346 -33.4376 -70.6505 2020-09-16 04:22:53 Metropolitana, Chile
223650 2020-09-15 Chile Nuble     5681 97 4962 622 -36.7226 -71.7622 2020-09-16 04:22:53 Nuble, Chile
223651 2020-09-15 Chile OHiggins     14933 369 13657 907 -34.5755 -71.0022 2020-09-16 04:22:53 OHiggins, Chile
223652 2020-09-15 Chile Tarapaca     11271 215 10699 357 -19.9232 -69.5132 2020-09-16 04:22:53 Tarapaca, Chile
223653 2020-09-15 Chile Unknown     56 1 55 0     2020-09-16 04:22:53 Unknown, Chile
223654 2020-09-15 Chile Valparaiso     25524 791 23351 1382 -33.0472 -71.6127 2020-09-16 04:22:53 Valparaiso, Chile
223655 2020-09-15 China Anhui     991 6 985 0 31.8257 117.2264 2020-09-16 04:22:53 Anhui, China
223656 2020-09-15 China Beijing     935 9 926 0 40.1824 116.4142 2020-09-16 04:22:53 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] INTEGER,
   [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 3820.655ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette