⚠️ 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

1,469,868 rows sorted by day descending

View and edit SQL

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
1328707 2021-04-07 Afghanistan       56873 2512 51940 2421 33.93911 67.709953 2021-04-08 04:21:13 Afghanistan
1328708 2021-04-07 Albania       127192 2291 95600 29301 41.1533 20.1683 2021-04-08 04:21:13 Albania
1328709 2021-04-07 Algeria       118004 3116 82192 32696 28.0339 1.6596 2021-04-08 04:21:13 Algeria
1328710 2021-04-07 Andorra       12363 119 11616 628 42.5063 1.5218 2021-04-08 04:21:13 Andorra
1328711 2021-04-07 Angola       23010 547 21545 918 -11.2027 17.8739 2021-04-08 04:21:13 Angola
1328712 2021-04-07 Antigua and Barbuda       1177 29 911 237 17.0608 -61.7964 2021-04-08 04:21:13 Antigua and Barbuda
1328713 2021-04-07 Argentina       2450068 56832 2174625 218611 -38.4161 -63.6167 2021-04-08 04:21:13 Argentina
1328714 2021-04-07 Armenia       198898 3647 178227 17024 40.0691 45.0382 2021-04-08 04:21:13 Armenia
1328715 2021-04-07 Australia Australian Capital Territory     123 3 120 0 -35.4735 149.0124 2021-04-08 04:21:13 Australian Capital Territory, Australia
1328716 2021-04-07 Australia New South Wales     5318 54 0 5264 -33.8688 151.2093 2021-04-08 04:21:13 New South Wales, Australia
1328717 2021-04-07 Australia Northern Territory     112 0 106 6 -12.4634 130.8456 2021-04-08 04:21:13 Northern Territory, Australia
1328718 2021-04-07 Australia Queensland     1500 6 1366 128 -27.4698 153.0251 2021-04-08 04:21:13 Queensland, Australia
1328719 2021-04-07 Australia South Australia     663 4 651 8 -34.9285 138.6007 2021-04-08 04:21:13 South Australia, Australia
1328720 2021-04-07 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-04-08 04:21:13 Tasmania, Australia
1328721 2021-04-07 Australia Victoria     20484 820 19664 0 -37.8136 144.9631 2021-04-08 04:21:13 Victoria, Australia
1328722 2021-04-07 Australia Western Australia     951 9 928 14 -31.9505 115.8605 2021-04-08 04:21:13 Western Australia, Australia
1328723 2021-04-07 Austria       566008 9546 522774 33688 47.5162 14.5501 2021-04-08 04:21:13 Austria
1328724 2021-04-07 Azerbaijan       276464 3780 244540 28144 40.1431 47.5769 2021-04-08 04:21:13 Azerbaijan
1328725 2021-04-07 Bahamas       9296 189 8811 296 25.025885 -78.035889 2021-04-08 04:21:13 Bahamas
1328726 2021-04-07 Bahrain       151931 547 141119 10265 26.0275 50.55 2021-04-08 04:21:13 Bahrain
1328727 2021-04-07 Bangladesh       659278 9447 561639 88192 23.685 90.3563 2021-04-08 04:21:13 Bangladesh
1328728 2021-04-07 Barbados       3691 43 3557 91 13.1939 -59.5432 2021-04-08 04:21:13 Barbados
1328729 2021-04-07 Belarus       330536 2314 320844 7378 53.7098 27.9534 2021-04-08 04:21:13 Belarus
1328730 2021-04-07 Belgium Antwerp     115402 0 0 115402 51.2195 4.4024 2021-04-08 04:21:13 Antwerp, Belgium
1328731 2021-04-07 Belgium Brussels     112945 0 0 112945 50.8503 4.3517 2021-04-08 04:21:13 Brussels, Belgium
1328732 2021-04-07 Belgium East Flanders     103311 0 0 103311 51.0362 3.7373 2021-04-08 04:21:13 East Flanders, Belgium
1328733 2021-04-07 Belgium Flemish Brabant     69895 0 0 69895 50.9167 4.5833 2021-04-08 04:21:13 Flemish Brabant, Belgium
1328734 2021-04-07 Belgium Hainaut     134717 0 0 134717 50.5257 4.0621 2021-04-08 04:21:13 Hainaut, Belgium
1328735 2021-04-07 Belgium Liege     114138 0 0 114138 50.4496 5.8492 2021-04-08 04:21:13 Liege, Belgium
1328736 2021-04-07 Belgium Limburg     47336 0 0 47336 50.9739 5.3420000000000005 2021-04-08 04:21:13 Limburg, Belgium
1328737 2021-04-07 Belgium Luxembourg     26237 0 0 26237 50.0547 5.4677 2021-04-08 04:21:13 Luxembourg, Belgium
1328738 2021-04-07 Belgium Namur     50091 0 0 50091 50.331 4.8221 2021-04-08 04:21:13 Namur, Belgium
1328739 2021-04-07 Belgium Unknown     17024 23301 0 -6277     2021-04-08 04:21:13 Unknown, Belgium
1328740 2021-04-07 Belgium Walloon Brabant     35082 0 0 35082 50.4 4.35 2021-04-08 04:21:13 Walloon Brabant, Belgium
1328741 2021-04-07 Belgium West Flanders     82034 0 0 82034 51.0536 3.1458 2021-04-08 04:21:13 West Flanders, Belgium
1328742 2021-04-07 Belize       12485 318 12106 61 17.1899 -88.4976 2021-04-08 04:21:13 Belize
1328743 2021-04-07 Benin       7313 93 6452 768 9.3077 2.3158 2021-04-08 04:21:13 Benin
1328744 2021-04-07 Bhutan       900 1 874 25 27.5142 90.4336 2021-04-08 04:21:13 Bhutan
1328745 2021-04-07 Bolivia       277966 12385 227812 37769 -16.2902 -63.5887 2021-04-08 04:21:13 Bolivia
1328746 2021-04-07 Bosnia and Herzegovina       179248 7132 137242 34874 43.9159 17.6791 2021-04-08 04:21:13 Bosnia and Herzegovina
1328747 2021-04-07 Botswana       41710 616 36958 4136 -22.3285 24.6849 2021-04-08 04:21:13 Botswana
1328748 2021-04-07 Brazil Acre     71880 1318 55117 15445 -9.0238 -70.812 2021-04-08 04:21:13 Acre, Brazil
1328749 2021-04-07 Brazil Alagoas     158069 3710 149548 4811 -9.5713 -36.782 2021-04-08 04:21:13 Alagoas, Brazil
1328750 2021-04-07 Brazil Amapa     100292 1356 72904 26032 0.902 -52.003 2021-04-08 04:21:13 Amapa, Brazil
1328751 2021-04-07 Brazil Amazonas     355027 12177 302749 40101 -3.4168 -65.8561 2021-04-08 04:21:13 Amazonas, Brazil
1328752 2021-04-07 Brazil Bahia     825015 16107 794967 13941 -12.5797 -41.7007 2021-04-08 04:21:13 Bahia, Brazil
1328753 2021-04-07 Brazil Ceara     564524 14884 397569 152071 -5.4984 -39.3206 2021-04-08 04:21:13 Ceara, Brazil
1328754 2021-04-07 Brazil Distrito Federal     353206 6532 329673 17001 -15.7998 -47.8645 2021-04-08 04:21:13 Distrito Federal, Brazil
1328755 2021-04-07 Brazil Espirito Santo     395799 7937 363880 23982 -19.1834 -40.3089 2021-04-08 04:21:13 Espirito Santo, Brazil
1328756 2021-04-07 Brazil Goias     498522 12343 475835 10344 -15.827 -49.8362 2021-04-08 04:21:13 Goias, Brazil
1328757 2021-04-07 Brazil Maranhao     246665 6369 223168 17128 -4.9609 -45.2744 2021-04-08 04:21:13 Maranhao, Brazil
1328758 2021-04-07 Brazil Mato Grosso     320791 8184 298627 13980 -12.6819 -56.9211 2021-04-08 04:21:13 Mato Grosso, Brazil
1328759 2021-04-07 Brazil Mato Grosso do Sul     224697 4630 203779 16288 -20.7722 -54.7852 2021-04-08 04:21:13 Mato Grosso do Sul, Brazil
1328760 2021-04-07 Brazil Minas Gerais     1182847 26303 1061397 95147 -18.5122 -44.555 2021-04-08 04:21:13 Minas Gerais, Brazil
1328761 2021-04-07 Brazil Para     428880 10880 400205 17795 -1.9981 -54.9306 2021-04-08 04:21:13 Para, Brazil
1328762 2021-04-07 Brazil Paraiba     267008 6050 186879 74079 -7.24 -36.782 2021-04-08 04:21:13 Paraiba, Brazil
1328763 2021-04-07 Brazil Parana     869167 18118 613836 237213 -25.2521 -52.0215 2021-04-08 04:21:13 Parana, Brazil
1328764 2021-04-07 Brazil Pernambuco     361470 12541 303491 45438 -8.8137 -36.9541 2021-04-08 04:21:13 Pernambuco, Brazil
1328765 2021-04-07 Brazil Piaui     213660 4341 208048 1271 -7.7183 -42.7289 2021-04-08 04:21:13 Piaui, Brazil
1328766 2021-04-07 Brazil Rio Grande do Norte     201737 4786 142776 54175 -5.4026 -36.9541 2021-04-08 04:21:13 Rio Grande do Norte, Brazil
1328767 2021-04-07 Brazil Rio Grande do Sul     875450 21261 839406 14783 -30.0346 -51.2177 2021-04-08 04:21:13 Rio Grande do Sul, Brazil
1328768 2021-04-07 Brazil Rio de Janeiro     666025 38282 616078 11665 -22.9068 -43.1729 2021-04-08 04:21:13 Rio de Janeiro, Brazil
1328769 2021-04-07 Brazil Rondonia     193630 4419 171652 17559 -11.5057 -63.5806 2021-04-08 04:21:13 Rondonia, Brazil
1328770 2021-04-07 Brazil Roraima     90765 1367 84118 5280 -2.7376 -62.0751 2021-04-08 04:21:13 Roraima, Brazil
1328771 2021-04-07 Brazil Santa Catarina     825860 11613 790221 24026 -27.2423 -50.2189 2021-04-08 04:21:13 Santa Catarina, Brazil
1328772 2021-04-07 Brazil Sao Paulo     2576362 79443 2218618 278301 -23.5505 -46.6333 2021-04-08 04:21:13 Sao Paulo, Brazil
1328773 2021-04-07 Brazil Sergipe     180483 3668 163462 13353 -10.5741 -37.3857 2021-04-08 04:21:13 Sergipe, Brazil
1328774 2021-04-07 Brazil Tocantins     145374 2157 124156 19061 -10.1753 -48.2982 2021-04-08 04:21:13 Tocantins, Brazil
1328775 2021-04-07 Brunei       215 3 198 14 4.5353 114.7277 2021-04-08 04:21:13 Brunei
1328776 2021-04-07 Bulgaria       364419 14034 278665 71720 42.7339 25.4858 2021-04-08 04:21:13 Bulgaria
1328777 2021-04-07 Burkina Faso       12873 150 12540 183 12.2383 -1.5616 2021-04-08 04:21:13 Burkina Faso
1328778 2021-04-07 Burma       142541 3206 131829 7506 21.9162 95.956 2021-04-08 04:21:13 Burma
1328779 2021-04-07 Burundi       3017 6 773 2238 -3.3731 29.9189 2021-04-08 04:21:13 Burundi
1328780 2021-04-07 Cabo Verde       18214 175 16811 1228 16.5388 -23.0418 2021-04-08 04:21:13 Cabo Verde
1328781 2021-04-07 Cambodia       2915 22 1824 1069 11.55 104.9167 2021-04-08 04:21:13 Cambodia
1328782 2021-04-07 Cameroon       57337 851 35261 21225 3.848 11.5021 2021-04-08 04:21:13 Cameroon
1328783 2021-04-07 Canada Alberta     155476 2002 142010 11464 53.9333 -116.5765 2021-04-08 04:21:13 Alberta, Canada
1328784 2021-04-07 Canada British Columbia     106985 1491 96626 8868 53.7267 -127.6476 2021-04-08 04:21:13 British Columbia, Canada
1328785 2021-04-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1328786 2021-04-07 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1328787 2021-04-07 Canada Manitoba     34656 943 32419 1294 53.7609 -98.8139 2021-04-08 04:21:13 Manitoba, Canada
1328788 2021-04-07 Canada New Brunswick     1679 31 1484 164 46.5653 -66.4619 2021-04-08 04:21:13 New Brunswick, Canada
1328789 2021-04-07 Canada Newfoundland and Labrador     1021 6 1007 8 53.1355 -57.6604 2021-04-08 04:21:13 Newfoundland and Labrador, Canada
1328790 2021-04-07 Canada Northwest Territories     49 0 48 1 64.8255 -124.8457 2021-04-08 04:21:13 Northwest Territories,Canada
1328791 2021-04-07 Canada Nova Scotia     1749 66 1646 37 44.682 -63.7443 2021-04-08 04:21:13 Nova Scotia, Canada
1328792 2021-04-07 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-08 04:21:13 Nunavut, Canada
1328793 2021-04-07 Canada Ontario     377999 7461 344222 26316 51.2538 -85.3232 2021-04-08 04:21:13 Ontario, Canada
1328794 2021-04-07 Canada Prince Edward Island     160 0 152 8 46.5107 -63.4168 2021-04-08 04:21:13 Prince Edward Island, Canada
1328795 2021-04-07 Canada Quebec     319802 10709 298298 10795 52.9399 -73.5491 2021-04-08 04:21:13 Quebec, Canada
1328796 2021-04-07 Canada Repatriated Travellers     13 0 13 0     2021-04-08 04:21:13 Repatriated Travellers, Canada
1328797 2021-04-07 Canada Saskatchewan     35171 445 32588 2138 52.9399 -106.4509 2021-04-08 04:21:13 Saskatchewan, Canada
1328798 2021-04-07 Canada Yukon     74 1 73 0 64.2823 -135.0 2021-04-08 04:21:13 Yukon, Canada
1328799 2021-04-07 Central African Republic       5353 73 5024 256 6.6111 20.9394 2021-04-08 04:21:13 Central African Republic
1328800 2021-04-07 Chad       4606 166 4236 204 15.4542 18.7322 2021-04-08 04:21:13 Chad
1328801 2021-04-07 Chile Antofagasta     44493 887 42402 1204 -23.6509 -70.3975 2021-04-08 04:21:13 Antofagasta, Chile
1328802 2021-04-07 Chile Araucania     58241 711 55108 2422 -38.9489 -72.3311 2021-04-08 04:21:13 Araucania, Chile
1328803 2021-04-07 Chile Arica y Parinacota     17938 358 17020 560 -18.594 -69.4785 2021-04-08 04:21:13 Arica y Parinacota, Chile
1328804 2021-04-07 Chile Atacama     15027 176 14103 748 -27.5661 -70.0503 2021-04-08 04:21:13 Atacama, Chile
1328805 2021-04-07 Chile Aysen     3677 28 3519 130 -45.9864 -73.7669 2021-04-08 04:21:13 Aysen, Chile
1328806 2021-04-07 Chile Biobio     100614 1643 94755 4216 -37.4464 -72.1416 2021-04-08 04:21:13 Biobio, Chile

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]);