⚠️ 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,585,769 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
802450 2021-05-03 Afghanistan       60300 2642 53391 4267 33.93911 67.709953 2021-05-04 04:20:34 Afghanistan
802451 2021-05-03 Albania       131276 2399 111792 17085 41.1533 20.1683 2021-05-04 04:20:34 Albania
802452 2021-05-03 Algeria       122717 3280 85534 33903 28.0339 1.6596 2021-05-04 04:20:34 Algeria
802453 2021-05-03 Andorra       13295 127 12793 375 42.5063 1.5218 2021-05-04 04:20:34 Andorra
802454 2021-05-03 Angola       27133 603 24190 2340 -11.2027 17.8739 2021-05-04 04:20:34 Angola
802455 2021-05-03 Antigua and Barbuda       1232 32 1014 186 17.0608 -61.7964 2021-05-04 04:20:34 Antigua and Barbuda
802456 2021-05-03 Argentina       3021179 64792 2698072 258315 -38.4161 -63.6167 2021-05-04 04:20:34 Argentina
802457 2021-05-03 Armenia       217008 4149 200472 12387 40.0691 45.0382 2021-05-04 04:20:34 Armenia
802458 2021-05-03 Australia Australian Capital Territory     124 3 120 1 -35.4735 149.0124 2021-05-04 04:20:34 Australian Capital Territory, Australia
802459 2021-05-03 Australia New South Wales     5496 54 0 5442 -33.8688 151.2093 2021-05-04 04:20:34 New South Wales, Australia
802460 2021-05-03 Australia Northern Territory     166 0 131 35 -12.4634 130.8456 2021-05-04 04:20:34 Northern Territory, Australia
802461 2021-05-03 Australia Queensland     1568 7 1511 50 -27.4698 153.0251 2021-05-04 04:20:34 Queensland, Australia
802462 2021-05-03 Australia South Australia     730 4 691 35 -34.9285 138.6007 2021-05-04 04:20:34 South Australia, Australia
802463 2021-05-03 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-05-04 04:20:34 Tasmania, Australia
802464 2021-05-03 Australia Victoria     20524 820 19683 21 -37.8136 144.9631 2021-05-04 04:20:34 Victoria, Australia
802465 2021-05-03 Australia Western Australia     1008 9 973 26 -31.9505 115.8605 2021-05-04 04:20:34 Western Australia, Australia
802466 2021-05-03 Austria       623201 10260 591525 21416 47.5162 14.5501 2021-05-04 04:20:34 Austria
802467 2021-05-03 Azerbaijan       321798 4580 294784 22434 40.1431 47.5769 2021-05-04 04:20:34 Azerbaijan
802468 2021-05-03 Bahamas       10576 210 9579 787 25.025885 -78.035889 2021-05-04 04:20:34 Bahamas
802469 2021-05-03 Bahrain       180462 657 168865 10940 26.0275 50.55 2021-05-04 04:20:34 Bahrain
802470 2021-05-03 Bangladesh       763682 11644 691162 60876 23.685 90.3563 2021-05-04 04:20:34 Bangladesh
802471 2021-05-03 Barbados       3881 44 3804 33 13.1939 -59.5432 2021-05-04 04:20:34 Barbados
802472 2021-05-03 Belarus       361897 2572 352464 6861 53.7098 27.9534 2021-05-04 04:20:34 Belarus
802473 2021-05-03 Belgium Antwerp     127541 0 0 127541 51.2195 4.4024 2021-05-04 04:20:34 Antwerp, Belgium
802474 2021-05-03 Belgium Brussels     123218 0 0 123218 50.8503 4.3517 2021-05-04 04:20:34 Brussels, Belgium
802475 2021-05-03 Belgium East Flanders     114694 0 0 114694 51.0362 3.7373 2021-05-04 04:20:34 East Flanders, Belgium
802476 2021-05-03 Belgium Flemish Brabant     76108 0 0 76108 50.9167 4.5833 2021-05-04 04:20:34 Flemish Brabant, Belgium
802477 2021-05-03 Belgium Hainaut     147230 0 0 147230 50.5257 4.0621 2021-05-04 04:20:34 Hainaut, Belgium
802478 2021-05-03 Belgium Liege     121696 0 0 121696 50.4496 5.8492 2021-05-04 04:20:34 Liege, Belgium
802479 2021-05-03 Belgium Limburg     54904 0 0 54904 50.9739 5.3420000000000005 2021-05-04 04:20:34 Limburg, Belgium
802480 2021-05-03 Belgium Luxembourg     29117 0 0 29117 50.0547 5.4677 2021-05-04 04:20:34 Luxembourg, Belgium
802481 2021-05-03 Belgium Namur     55513 0 0 55513 50.331 4.8221 2021-05-04 04:20:34 Namur, Belgium
802482 2021-05-03 Belgium Unknown     18972 24322 0 -5350     2021-05-04 04:20:34 Unknown, Belgium
802483 2021-05-03 Belgium Walloon Brabant     38047 0 0 38047 50.4 4.35 2021-05-04 04:20:34 Walloon Brabant, Belgium
802484 2021-05-03 Belgium West Flanders     89856 0 0 89856 51.0536 3.1458 2021-05-04 04:20:34 West Flanders, Belgium
802485 2021-05-03 Belize       12674 323 12239 112 17.1899 -88.4976 2021-05-04 04:20:34 Belize
802486 2021-05-03 Benin       7884 100 7652 132 9.3077 2.3158 2021-05-04 04:20:34 Benin
802487 2021-05-03 Bhutan       1119 1 999 119 27.5142 90.4336 2021-05-04 04:20:34 Bhutan
802488 2021-05-03 Bolivia       308984 13035 254683 41266 -16.2902 -63.5887 2021-05-04 04:20:34 Bolivia
802489 2021-05-03 Bosnia and Herzegovina       198461 8551 159223 30687 43.9159 17.6791 2021-05-04 04:20:34 Bosnia and Herzegovina
802490 2021-05-03 Botswana       47851 724 45645 1482 -22.3285 24.6849 2021-05-04 04:20:34 Botswana
802491 2021-05-03 Brazil Acre     78325 1552 63652 13121 -9.0238 -70.812 2021-05-04 04:20:34 Acre, Brazil
802492 2021-05-03 Brazil Alagoas     175415 4275 166575 4565 -9.5713 -36.782 2021-05-04 04:20:34 Alagoas, Brazil
802493 2021-05-03 Brazil Amapa     106440 1561 78064 26815 0.902 -52.003 2021-05-04 04:20:34 Amapa, Brazil
802494 2021-05-03 Brazil Amazonas     372128 12658 318611 40859 -3.4168 -65.8561 2021-05-04 04:20:34 Amazonas, Brazil
802495 2021-05-03 Brazil Bahia     909912 18730 872677 18505 -12.5797 -41.7007 2021-05-04 04:20:34 Bahia, Brazil
802496 2021-05-03 Brazil Ceara     678271 17799 459424 201048 -5.4984 -39.3206 2021-05-04 04:20:34 Ceara, Brazil
802497 2021-05-03 Brazil Distrito Federal     381468 7883 364114 9471 -15.7998 -47.8645 2021-05-04 04:20:34 Distrito Federal, Brazil
802498 2021-05-03 Brazil Espirito Santo     439857 9613 411308 18936 -19.1834 -40.3089 2021-05-04 04:20:34 Espirito Santo, Brazil
802499 2021-05-03 Brazil Goias     554859 15127 526787 12945 -15.827 -49.8362 2021-05-04 04:20:34 Goias, Brazil
802500 2021-05-03 Brazil Maranhao     268016 7366 240273 20377 -4.9609 -45.2744 2021-05-04 04:20:34 Maranhao, Brazil
802501 2021-05-03 Brazil Mato Grosso     362915 9731 345626 7558 -12.6819 -56.9211 2021-05-04 04:20:34 Mato Grosso, Brazil
802502 2021-05-03 Brazil Mato Grosso do Sul     250365 5812 236519 8034 -20.7722 -54.7852 2021-05-04 04:20:34 Mato Grosso do Sul, Brazil
802503 2021-05-03 Brazil Minas Gerais     1371818 34313 1261550 75955 -18.5122 -44.555 2021-05-04 04:20:34 Minas Gerais, Brazil
802504 2021-05-03 Brazil Para     474018 13163 442857 17998 -1.9981 -54.9306 2021-05-04 04:20:34 Para, Brazil
802505 2021-05-03 Brazil Paraiba     295458 6872 204944 83642 -7.24 -36.782 2021-05-04 04:20:34 Paraiba, Brazil
802506 2021-05-03 Brazil Parana     955247 22674 682036 250537 -25.2521 -52.0215 2021-05-04 04:20:34 Parana, Brazil
802507 2021-05-03 Brazil Pernambuco     410453 14206 348230 48017 -8.8137 -36.9541 2021-05-04 04:20:34 Pernambuco, Brazil
802508 2021-05-03 Brazil Piaui     242934 5182 237608 144 -7.7183 -42.7289 2021-05-04 04:20:34 Piaui, Brazil
802509 2021-05-03 Brazil Rio Grande do Norte     225609 5525 150649 69435 -5.4026 -36.9541 2021-05-04 04:20:34 Rio Grande do Norte, Brazil
802510 2021-05-03 Brazil Rio Grande do Sul     980806 25165 943031 12610 -30.0346 -51.2177 2021-05-04 04:20:34 Rio Grande do Sul, Brazil
802511 2021-05-03 Brazil Rio de Janeiro     748614 44897 695771 7946 -22.9068 -43.1729 2021-05-04 04:20:34 Rio de Janeiro, Brazil
802512 2021-05-03 Brazil Rondonia     213766 5215 199908 8643 -11.5057 -63.5806 2021-05-04 04:20:34 Rondonia, Brazil
802513 2021-05-03 Brazil Roraima     96771 1513 91438 3820 -2.7376 -62.0751 2021-05-04 04:20:34 Roraima, Brazil
802514 2021-05-03 Brazil Santa Catarina     893367 13674 857182 22511 -27.2423 -50.2189 2021-05-04 04:20:34 Santa Catarina, Brazil
802515 2021-05-03 Brazil Sao Paulo     2926516 97172 2606926 222418 -23.5505 -46.6333 2021-05-04 04:20:34 Sao Paulo, Brazil
802516 2021-05-03 Brazil Sergipe     205209 4357 186990 13862 -10.5741 -37.3857 2021-05-04 04:20:34 Sergipe, Brazil
802517 2021-05-03 Brazil Tocantins     160972 2587 142393 15992 -10.1753 -48.2982 2021-05-04 04:20:34 Tocantins, Brazil
802518 2021-05-03 Brunei       227 3 218 6 4.5353 114.7277 2021-05-04 04:20:34 Brunei
802519 2021-05-03 Bulgaria       405825 16548 341168 48109 42.7339 25.4858 2021-05-04 04:20:34 Bulgaria
802520 2021-05-03 Burkina Faso       13324 157 13067 100 12.2383 -1.5616 2021-05-04 04:20:34 Burkina Faso
802521 2021-05-03 Burma       142842 3209 131989 7644 21.9162 95.956 2021-05-04 04:20:34 Burma
802522 2021-05-03 Burundi       4046 6 773 3267 -3.3731 29.9189 2021-05-04 04:20:34 Burundi
802523 2021-05-03 Cabo Verde       24548 226 21249 3073 16.5388 -23.0418 2021-05-04 04:20:34 Cabo Verde
802524 2021-05-03 Cambodia       15361 106 5430 9825 11.55 104.9167 2021-05-04 04:20:34 Cambodia
802525 2021-05-03 Cameroon       72250 1107 35261 35882 3.848 11.5021 2021-05-04 04:20:34 Cameroon
802526 2021-05-03 Canada Alberta     196910 2090 171212 23608 53.9333 -116.5765 2021-05-04 04:20:34 Alberta, Canada
802527 2021-05-03 Canada British Columbia     131656 1596 122518 7542 53.7267 -127.6476 2021-05-04 04:20:34 British Columbia, Canada
802528 2021-05-03 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
802529 2021-05-03 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
802530 2021-05-03 Canada Manitoba     39524 979 35952 2593 53.7609 -98.8139 2021-05-04 04:20:34 Manitoba, Canada
802531 2021-05-03 Canada New Brunswick     1954 38 1773 143 46.5653 -66.4619 2021-05-04 04:20:34 New Brunswick, Canada
802532 2021-05-03 Canada Newfoundland and Labrador     1104 6 1038 60 53.1355 -57.6604 2021-05-04 04:20:34 Newfoundland and Labrador, Canada
802533 2021-05-03 Canada Northwest Territories     65 0 56 9 64.8255 -124.8457 2021-05-04 04:20:34 Northwest Territories,Canada
802534 2021-05-03 Canada Nova Scotia     2854 67 1844 943 44.682 -63.7443 2021-05-04 04:20:34 Nova Scotia, Canada
802535 2021-05-03 Canada Nunavut     528 4 439 85 70.2998 -83.1076 2021-05-04 04:20:34 Nunavut, Canada
802536 2021-05-03 Canada Ontario     482447 8109 442002 32336 51.2538 -85.3232 2021-05-04 04:20:34 Ontario, Canada
802537 2021-05-03 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-05-04 04:20:34 Prince Edward Island, Canada
802538 2021-05-03 Canada Quebec     352678 10944 332577 9157 52.9399 -73.5491 2021-05-04 04:20:34 Quebec, Canada
802539 2021-05-03 Canada Repatriated Travellers     13 0 13 0     2021-05-04 04:20:34 Repatriated Travellers, Canada
802540 2021-05-03 Canada Saskatchewan     41806 498 38911 2397 52.9399 -106.4509 2021-05-04 04:20:34 Saskatchewan, Canada
802541 2021-05-03 Canada Yukon     82 2 79 1 64.2823 -135.0 2021-05-04 04:20:34 Yukon, Canada
802542 2021-05-03 Central African Republic       6411 88 5112 1211 6.6111 20.9394 2021-05-04 04:20:34 Central African Republic
802543 2021-05-03 Chad       4828 170 4528 130 15.4542 18.7322 2021-05-04 04:20:34 Chad
802544 2021-05-03 Chile Antofagasta     49218 972 47119 1127 -23.6509 -70.3975 2021-05-04 04:20:34 Antofagasta, Chile
802545 2021-05-03 Chile Araucania     72331 896 68364 3071 -38.9489 -72.3311 2021-05-04 04:20:34 Araucania, Chile
802546 2021-05-03 Chile Arica y Parinacota     20402 401 19264 737 -18.594 -69.4785 2021-05-04 04:20:34 Arica y Parinacota, Chile
802547 2021-05-03 Chile Atacama     18396 204 17315 877 -27.5661 -70.0503 2021-05-04 04:20:34 Atacama, Chile
802548 2021-05-03 Chile Aysen     4383 30 4153 200 -45.9864 -73.7669 2021-05-04 04:20:34 Aysen, Chile
802549 2021-05-03 Chile Biobio     116636 1899 111467 3270 -37.4464 -72.1416 2021-05-04 04:20:34 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] 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]);