⚠️ 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,325,872 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
1252416 2021-02-21 Afghanistan       55604 2432 48834 4338 33.93911 67.709953 2021-02-22 05:24:21 Afghanistan
1252417 2021-02-21 Albania       100246 1666 63329 35251 41.1533 20.1683 2021-02-22 05:24:21 Albania
1252418 2021-02-21 Algeria       111917 2961 77076 31880 28.0339 1.6596 2021-02-22 05:24:21 Algeria
1252419 2021-02-21 Andorra       10699 107 10206 386 42.5063 1.5218 2021-02-22 05:24:21 Andorra
1252420 2021-02-21 Angola       20519 499 19013 1007 -11.2027 17.8739 2021-02-22 05:24:21 Angola
1252421 2021-02-21 Antigua and Barbuda       598 13 218 367 17.0608 -61.7964 2021-02-22 05:24:21 Antigua and Barbuda
1252422 2021-02-21 Argentina       2064334 51198 1866501 146635 -38.4161 -63.6167 2021-02-22 05:24:21 Argentina
1252423 2021-02-21 Armenia       170402 3164 161994 5244 40.0691 45.0382 2021-02-22 05:24:21 Armenia
1252424 2021-02-21 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-02-22 05:24:21 Australian Capital Territory, Australia
1252425 2021-02-21 Australia New South Wales     5150 54 0 5096 -33.8688 151.2093 2021-02-22 05:24:21 New South Wales, Australia
1252426 2021-02-21 Australia Northern Territory     104 0 101 3 -12.4634 130.8456 2021-02-22 05:24:21 Northern Territory, Australia
1252427 2021-02-21 Australia Queensland     1323 6 1309 8 -27.4698 153.0251 2021-02-22 05:24:21 Queensland, Australia
1252428 2021-02-21 Australia South Australia     610 4 603 3 -34.9285 138.6007 2021-02-22 05:24:21 South Australia, Australia
1252429 2021-02-21 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-02-22 05:24:21 Tasmania, Australia
1252430 2021-02-21 Australia Victoria     20479 820 19634 25 -37.8136 144.9631 2021-02-22 05:24:21 Victoria, Australia
1252431 2021-02-21 Australia Western Australia     912 9 899 4 -31.9505 115.8605 2021-02-22 05:24:21 Western Australia, Australia
1252432 2021-02-21 Austria       445374 8386 420509 16479 47.5162 14.5501 2021-02-22 05:24:21 Austria
1252433 2021-02-21 Azerbaijan       233129 3198 227761 2170 40.1431 47.5769 2021-02-22 05:24:21 Azerbaijan
1252434 2021-02-21 Bahamas       8403 179 7148 1076 25.025885 -78.035889 2021-02-22 05:24:21 Bahamas
1252435 2021-02-21 Bahrain       117809 423 110007 7379 26.0275 50.55 2021-02-22 05:24:21 Bahrain
1252436 2021-02-21 Bangladesh       543351 8349 491367 43635 23.685 90.3563 2021-02-22 05:24:21 Bangladesh
1252437 2021-02-21 Barbados       2772 31 1970 771 13.1939 -59.5432 2021-02-22 05:24:21 Barbados
1252438 2021-02-21 Belarus       278312 1912 268530 7870 53.7098 27.9534 2021-02-22 05:24:21 Belarus
1252439 2021-02-21 Belgium Antwerp     94684 0 0 94684 51.2195 4.4024 2021-02-22 05:24:21 Antwerp, Belgium
1252440 2021-02-21 Belgium Brussels     93210 0 0 93210 50.8503 4.3517 2021-02-22 05:24:21 Brussels, Belgium
1252441 2021-02-21 Belgium East Flanders     80695 0 0 80695 51.0362 3.7373 2021-02-22 05:24:21 East Flanders, Belgium
1252442 2021-02-21 Belgium Flemish Brabant     58155 0 0 58155 50.9167 4.5833 2021-02-22 05:24:21 Flemish Brabant, Belgium
1252443 2021-02-21 Belgium Hainaut     114374 0 0 114374 50.5257 4.0621 2021-02-22 05:24:21 Hainaut, Belgium
1252444 2021-02-21 Belgium Liege     104535 0 0 104535 50.4496 5.8492 2021-02-22 05:24:21 Liege, Belgium
1252445 2021-02-21 Belgium Limburg     37610 0 0 37610 50.9739 5.3420000000000005 2021-02-22 05:24:21 Limburg, Belgium
1252446 2021-02-21 Belgium Luxembourg     21358 0 0 21358 50.0547 5.4677 2021-02-22 05:24:21 Luxembourg, Belgium
1252447 2021-02-21 Belgium Namur     39537 0 0 39537 50.331 4.8221 2021-02-22 05:24:21 Namur, Belgium
1252448 2021-02-21 Belgium Unknown     13722 21903 0 -8181     2021-02-22 05:24:21 Unknown, Belgium
1252449 2021-02-21 Belgium Walloon Brabant     29216 0 0 29216 50.4 4.35 2021-02-22 05:24:21 Walloon Brabant, Belgium
1252450 2021-02-21 Belgium West Flanders     67377 0 0 67377 51.0536 3.1458 2021-02-22 05:24:21 West Flanders, Belgium
1252451 2021-02-21 Belize       12244 314 11749 181 17.1899 -88.4976 2021-02-22 05:24:21 Belize
1252452 2021-02-21 Benin       5434 70 4248 1116 9.3077 2.3158 2021-02-22 05:24:21 Benin
1252453 2021-02-21 Bhutan       866 1 857 8 27.5142 90.4336 2021-02-22 05:24:21 Bhutan
1252454 2021-02-21 Bolivia       242292 11441 185155 45696 -16.2902 -63.5887 2021-02-22 05:24:21 Bolivia
1252455 2021-02-21 Bosnia and Herzegovina       127537 4979 111991 10567 43.9159 17.6791 2021-02-22 05:24:21 Bosnia and Herzegovina
1252456 2021-02-21 Botswana       26524 254 22363 3907 -22.3285 24.6849 2021-02-22 05:24:21 Botswana
1252457 2021-02-21 Brazil Acre     54786 963 46016 7807 -9.0238 -70.812 2021-02-22 05:24:21 Acre, Brazil
1252458 2021-02-21 Brazil Alagoas     128192 2932 122264 2996 -9.5713 -36.782 2021-02-22 05:24:21 Alagoas, Brazil
1252459 2021-02-21 Brazil Amapa     82015 1121 59917 20977 0.902 -52.003 2021-02-22 05:24:21 Amapa, Brazil
1252460 2021-02-21 Brazil Amazonas     306003 10462 260097 35444 -3.4168 -65.8561 2021-02-22 05:24:21 Amazonas, Brazil
1252461 2021-02-21 Brazil Bahia     653335 11191 625441 16703 -12.5797 -41.7007 2021-02-22 05:24:21 Bahia, Brazil
1252462 2021-02-21 Brazil Ceara     409954 10954 308294 90706 -5.4984 -39.3206 2021-02-22 05:24:21 Ceara, Brazil
1252463 2021-02-21 Brazil Distrito Federal     289820 4757 279108 5955 -15.7998 -47.8645 2021-02-22 05:24:21 Distrito Federal, Brazil
1252464 2021-02-21 Brazil Espirito Santo     317573 6275 298845 12453 -19.1834 -40.3089 2021-02-22 05:24:21 Espirito Santo, Brazil
1252465 2021-02-21 Brazil Goias     380210 8286 365635 6289 -15.827 -49.8362 2021-02-22 05:24:21 Goias, Brazil
1252466 2021-02-21 Brazil Maranhao     215942 4936 201198 9808 -4.9609 -45.2744 2021-02-22 05:24:21 Maranhao, Brazil
1252467 2021-02-21 Brazil Mato Grosso     240371 5534 227549 7288 -12.6819 -56.9211 2021-02-22 05:24:21 Mato Grosso, Brazil
1252468 2021-02-21 Brazil Mato Grosso do Sul     175544 3204 164889 7451 -20.7722 -54.7852 2021-02-22 05:24:21 Mato Grosso do Sul, Brazil
1252469 2021-02-21 Brazil Minas Gerais     840315 17714 765805 56796 -18.5122 -44.555 2021-02-22 05:24:21 Minas Gerais, Brazil
1252470 2021-02-21 Brazil Para     355128 8278 334356 12494 -1.9981 -54.9306 2021-02-22 05:24:21 Para, Brazil
1252471 2021-02-21 Brazil Paraiba     212286 4356 156373 51557 -7.24 -36.782 2021-02-22 05:24:21 Paraiba, Brazil
1252472 2021-02-21 Brazil Parana     615066 11142 450509 153415 -25.2521 -52.0215 2021-02-22 05:24:21 Parana, Brazil
1252473 2021-02-21 Brazil Pernambuco     290500 10849 249822 29829 -8.8137 -36.9541 2021-02-22 05:24:21 Pernambuco, Brazil
1252474 2021-02-21 Brazil Piaui     169465 3242 165610 613 -7.7183 -42.7289 2021-02-22 05:24:21 Piaui, Brazil
1252475 2021-02-21 Brazil Rio Grande do Norte     160671 3487 118035 39149 -5.4026 -36.9541 2021-02-22 05:24:21 Rio Grande do Norte, Brazil
1252476 2021-02-21 Brazil Rio Grande do Sul     604385 11771 575190 17424 -30.0346 -51.2177 2021-02-22 05:24:21 Rio Grande do Sul, Brazil
1252477 2021-02-21 Brazil Rio de Janeiro     572007 32173 536670 3164 -22.9068 -43.1729 2021-02-22 05:24:21 Rio de Janeiro, Brazil
1252478 2021-02-21 Brazil Rondonia     142222 2690 120509 19023 -11.5057 -63.5806 2021-02-22 05:24:21 Rondonia, Brazil
1252479 2021-02-21 Brazil Roraima     79606 1037 74301 4268 -2.7376 -62.0751 2021-02-22 05:24:21 Roraima, Brazil
1252480 2021-02-21 Brazil Santa Catarina     638984 6961 603008 29015 -27.2423 -50.2189 2021-02-22 05:24:21 Santa Catarina, Brazil
1252481 2021-02-21 Brazil Sao Paulo     1975927 57799 1749210 168918 -23.5505 -46.6333 2021-02-22 05:24:21 Sao Paulo, Brazil
1252482 2021-02-21 Brazil Sergipe     148026 2909 137264 7853 -10.5741 -37.3857 2021-02-22 05:24:21 Sergipe, Brazil
1252483 2021-02-21 Brazil Tocantins     109841 1481 99777 8583 -10.1753 -48.2982 2021-02-22 05:24:21 Tocantins, Brazil
1252484 2021-02-21 Brunei       185 3 178 4 4.5353 114.7277 2021-02-22 05:24:21 Brunei
1252485 2021-02-21 Bulgaria       236666 9854 200252 26560 42.7339 25.4858 2021-02-22 05:24:21 Bulgaria
1252486 2021-02-21 Burkina Faso       11797 139 11140 518 12.2383 -1.5616 2021-02-22 05:24:21 Burkina Faso
1252487 2021-02-21 Burma       141750 3196 131282 7272 21.9162 95.956 2021-02-22 05:24:21 Burma
1252488 2021-02-21 Burundi       2031 3 773 1255 -3.3731 29.9189 2021-02-22 05:24:21 Burundi
1252489 2021-02-21 Cabo Verde       15048 144 14538 366 16.5388 -23.0418 2021-02-22 05:24:21 Cabo Verde
1252490 2021-02-21 Cambodia       568 0 475 93 11.55 104.9167 2021-02-22 05:24:21 Cambodia
1252491 2021-02-21 Cameroon       33749 523 31362 1864 3.848 11.5021 2021-02-22 05:24:21 Cameroon
1252492 2021-02-21 Canada Alberta     131063 1827 124478 4758 53.9333 -116.5765 2021-02-22 05:24:21 Alberta, Canada
1252493 2021-02-21 Canada British Columbia     75835 1327 69970 4538 53.7267 -127.6476 2021-02-22 05:24:21 British Columbia, Canada
1252494 2021-02-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1252495 2021-02-21 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1252496 2021-02-21 Canada Manitoba     31386 884 29322 1180 53.7609 -98.8139 2021-02-22 05:24:21 Manitoba, Canada
1252497 2021-02-21 Canada New Brunswick     1424 25 1311 88 46.5653 -66.4619 2021-02-22 05:24:21 New Brunswick, Canada
1252498 2021-02-21 Canada Newfoundland and Labrador     926 4 489 433 53.1355 -57.6604 2021-02-22 05:24:21 Newfoundland and Labrador, Canada
1252499 2021-02-21 Canada Northwest Territories     47 0 39 8 64.8255 -124.8457 2021-02-22 05:24:21 Northwest Territories,Canada
1252500 2021-02-21 Canada Nova Scotia     1609 65 1525 19 44.682 -63.7443 2021-02-22 05:24:21 Nova Scotia, Canada
1252501 2021-02-21 Canada Nunavut     339 1 310 28 70.2998 -83.1076 2021-02-22 05:24:21 Nunavut, Canada
1252502 2021-02-21 Canada Ontario     298154 6861 281363 9930 51.2538 -85.3232 2021-02-22 05:24:21 Ontario, Canada
1252503 2021-02-21 Canada Prince Edward Island     114 0 112 2 46.5107 -63.4168 2021-02-22 05:24:21 Prince Edward Island, Canada
1252504 2021-02-21 Canada Quebec     282122 10307 263537 8278 52.9399 -73.5491 2021-02-22 05:24:21 Quebec, Canada
1252505 2021-02-21 Canada Repatriated Travellers     13 0 13 0     2021-02-22 05:24:21 Repatriated Travellers, Canada
1252506 2021-02-21 Canada Saskatchewan     27620 372 25578 1670 52.9399 -106.4509 2021-02-22 05:24:21 Saskatchewan, Canada
1252507 2021-02-21 Canada Yukon     72 1 69 2 64.2823 -135.0 2021-02-22 05:24:21 Yukon, Canada
1252508 2021-02-21 Central African Republic       5001 63 4920 18 6.6111 20.9394 2021-02-22 05:24:21 Central African Republic
1252509 2021-02-21 Chad       3849 134 3315 400 15.4542 18.7322 2021-02-22 05:24:21 Chad
1252510 2021-02-21 Chile Antofagasta     36362 730 34221 1411 -23.6509 -70.3975 2021-02-22 05:24:21 Antofagasta, Chile
1252511 2021-02-21 Chile Araucania     37841 495 35719 1627 -38.9489 -72.3311 2021-02-22 05:24:21 Araucania, Chile
1252512 2021-02-21 Chile Arica y Parinacota     14656 284 13738 634 -18.594 -69.4785 2021-02-22 05:24:21 Arica y Parinacota, Chile
1252513 2021-02-21 Chile Atacama     11548 145 10969 434 -27.5661 -70.0503 2021-02-22 05:24:21 Atacama, Chile
1252514 2021-02-21 Chile Aysen     2973 23 2833 117 -45.9864 -73.7669 2021-02-22 05:24:21 Aysen, Chile
1252515 2021-02-21 Chile Biobio     69519 1231 65287 3001 -37.4464 -72.1416 2021-02-22 05:24:21 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]);