⚠️ 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,146,457 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
838201 2021-01-11 Afghanistan       53538 2288 44137 7113 33.93911 67.709953 2021-01-12 05:22:15 Afghanistan
838202 2021-01-11 Albania       63971 1247 37981 24743 41.1533 20.1683 2021-01-12 05:22:15 Albania
838203 2021-01-11 Algeria       102369 2812 69403 30154 28.0339 1.6596 2021-01-12 05:22:15 Algeria
838204 2021-01-11 Andorra       8586 85 7724 777 42.5063 1.5218 2021-01-12 05:22:15 Andorra
838205 2021-01-11 Angola       18254 420 14825 3009 -11.2027 17.8739 2021-01-12 05:22:15 Angola
838206 2021-01-11 Antigua and Barbuda       176 5 152 19 17.0608 -61.7964 2021-01-12 05:22:15 Antigua and Barbuda
838207 2021-01-11 Argentina       1730921 44654 1518715 167552 -38.4161 -63.6167 2021-01-12 05:22:15 Argentina
838208 2021-01-11 Armenia       162288 2931 149873 9484 40.0691 45.0382 2021-01-12 05:22:15 Armenia
838209 2021-01-11 Australia Australian Capital Territory     118 3 115 0 -35.4735 149.0124 2021-01-12 05:22:15 Australian Capital Territory, Australia
838210 2021-01-11 Australia New South Wales     5034 54 3216 1764 -33.8688 151.2093 2021-01-12 05:22:15 New South Wales, Australia
838211 2021-01-11 Australia Northern Territory     90 0 71 19 -12.4634 130.8456 2021-01-12 05:22:15 Northern Territory, Australia
838212 2021-01-11 Australia Queensland     1281 6 1243 32 -27.4698 153.0251 2021-01-12 05:22:15 Queensland, Australia
838213 2021-01-11 Australia South Australia     588 4 569 15 -34.9285 138.6007 2021-01-12 05:22:15 South Australia, Australia
838214 2021-01-11 Australia Tasmania     234 13 221 0 -42.8821 147.3272 2021-01-12 05:22:15 Tasmania, Australia
838215 2021-01-11 Australia Victoria     20411 820 19553 38 -37.8136 144.9631 2021-01-12 05:22:15 Victoria, Australia
838216 2021-01-11 Australia Western Australia     878 9 855 14 -31.9505 115.8605 2021-01-12 05:22:15 Western Australia, Australia
838217 2021-01-11 Austria       382258 6747 355530 19981 47.5162 14.5501 2021-01-12 05:22:15 Austria
838218 2021-01-11 Azerbaijan       224827 2926 209522 12379 40.1431 47.5769 2021-01-12 05:22:15 Azerbaijan
838219 2021-01-11 Bahamas       8004 175 6331 1498 25.025885 -78.035889 2021-01-12 05:22:15 Bahamas
838220 2021-01-11 Bahrain       95879 356 92645 2878 26.0275 50.55 2021-01-12 05:22:15 Bahrain
838221 2021-01-11 Bangladesh       523302 7803 467718 47781 23.685 90.3563 2021-01-12 05:22:15 Bangladesh
838222 2021-01-11 Barbados       884 7 399 478 13.1939 -59.5432 2021-01-12 05:22:15 Barbados
838223 2021-01-11 Belarus       213993 1526 196284 16183 53.7098 27.9534 2021-01-12 05:22:15 Belarus
838224 2021-01-11 Belgium Antwerp     82215 0 0 82215 51.2195 4.4024 2021-01-12 05:22:15 Antwerp, Belgium
838225 2021-01-11 Belgium Brussels     83638 0 0 83638 50.8503 4.3517 2021-01-12 05:22:15 Brussels, Belgium
838226 2021-01-11 Belgium East Flanders     67589 0 0 67589 51.0362 3.7373 2021-01-12 05:22:15 East Flanders, Belgium
838227 2021-01-11 Belgium Flemish Brabant     50598 0 0 50598 50.9167 4.5833 2021-01-12 05:22:15 Flemish Brabant, Belgium
838228 2021-01-11 Belgium Hainaut     103975 0 0 103975 50.5257 4.0621 2021-01-12 05:22:15 Hainaut, Belgium
838229 2021-01-11 Belgium Liege     98307 0 0 98307 50.4496 5.8492 2021-01-12 05:22:15 Liege, Belgium
838230 2021-01-11 Belgium Limburg     30599 0 0 30599 50.9739 5.3420000000000005 2021-01-12 05:22:15 Limburg, Belgium
838231 2021-01-11 Belgium Luxembourg     18894 0 0 18894 50.0547 5.4677 2021-01-12 05:22:15 Luxembourg, Belgium
838232 2021-01-11 Belgium Namur     36123 0 0 36123 50.331 4.8221 2021-01-12 05:22:15 Namur, Belgium
838233 2021-01-11 Belgium Unknown     11147 20122 0 -8975     2021-01-12 05:22:15 Unknown, Belgium
838234 2021-01-11 Belgium Walloon Brabant     25747 0 0 25747 50.4 4.35 2021-01-12 05:22:15 Walloon Brabant, Belgium
838235 2021-01-11 Belgium West Flanders     56391 0 0 56391 51.0536 3.1458 2021-01-12 05:22:15 West Flanders, Belgium
838236 2021-01-11 Belize       11332 275 10419 638 17.1899 -88.4976 2021-01-12 05:22:15 Belize
838237 2021-01-11 Benin       3363 46 3222 95 9.3077 2.3158 2021-01-12 05:22:15 Benin
838238 2021-01-11 Bhutan       825 1 469 355 27.5142 90.4336 2021-01-12 05:22:15 Bhutan
838239 2021-01-11 Bolivia       175288 9415 138809 27064 -16.2902 -63.5887 2021-01-12 05:22:15 Bolivia
838240 2021-01-11 Bosnia and Herzegovina       115633 4330 81625 29678 43.9159 17.6791 2021-01-12 05:22:15 Bosnia and Herzegovina
838241 2021-01-11 Botswana       16768 59 13310 3399 -22.3285 24.6849 2021-01-12 05:22:15 Botswana
838242 2021-01-11 Brazil Acre     43346 826 38970 3550 -9.0238 -70.812 2021-01-12 05:22:15 Acre, Brazil
838243 2021-01-11 Brazil Alagoas     108820 2569 103446 2805 -9.5713 -36.782 2021-01-12 05:22:15 Alagoas, Brazil
838244 2021-01-11 Brazil Amapa     71287 976 54715 15596 0.902 -52.003 2021-01-12 05:22:15 Amapa, Brazil
838245 2021-01-11 Brazil Amazonas     216112 5756 181460 28896 -3.4168 -65.8561 2021-01-12 05:22:15 Amazonas, Brazil
838246 2021-01-11 Brazil Bahia     513756 9453 497735 6568 -12.5797 -41.7007 2021-01-12 05:22:15 Bahia, Brazil
838247 2021-01-11 Brazil Ceara     345124 10160 276146 58818 -5.4984 -39.3206 2021-01-12 05:22:15 Ceara, Brazil
838248 2021-01-11 Brazil Distrito Federal     259797 4368 248948 6481 -15.7998 -47.8645 2021-01-12 05:22:15 Distrito Federal, Brazil
838249 2021-01-11 Brazil Espirito Santo     265313 5354 243995 15964 -19.1834 -40.3089 2021-01-12 05:22:15 Espirito Santo, Brazil
838250 2021-01-11 Brazil Goias     318013 6965 308161 2887 -15.827 -49.8362 2021-01-12 05:22:15 Goias, Brazil
838251 2021-01-11 Brazil Maranhao     202050 4568 191545 5937 -4.9609 -45.2744 2021-01-12 05:22:15 Maranhao, Brazil
838252 2021-01-11 Brazil Mato Grosso     189132 4619 178504 6009 -12.6819 -56.9211 2021-01-12 05:22:15 Mato Grosso, Brazil
838253 2021-01-11 Brazil Mato Grosso do Sul     144051 2565 128935 12551 -20.7722 -54.7852 2021-01-12 05:22:15 Mato Grosso do Sul, Brazil
838254 2021-01-11 Brazil Minas Gerais     595007 12736 531414 50857 -18.5122 -44.555 2021-01-12 05:22:15 Minas Gerais, Brazil
838255 2021-01-11 Brazil Para     302125 7315 283711 11099 -1.9981 -54.9306 2021-01-12 05:22:15 Para, Brazil
838256 2021-01-11 Brazil Paraiba     173299 3824 130673 38802 -7.24 -36.782 2021-01-12 05:22:15 Paraiba, Brazil
838257 2021-01-11 Brazil Parana     474949 8768 350073 116108 -25.2521 -52.0215 2021-01-12 05:22:15 Parana, Brazil
838258 2021-01-11 Brazil Pernambuco     232756 9851 198249 24656 -8.8137 -36.9541 2021-01-12 05:22:15 Pernambuco, Brazil
838259 2021-01-11 Brazil Piaui     147509 2906 144740 -137 -7.7183 -42.7289 2021-01-12 05:22:15 Piaui, Brazil
838260 2021-01-11 Brazil Rio Grande do Norte     124523 3098 88210 33215 -5.4026 -36.9541 2021-01-12 05:22:15 Rio Grande do Norte, Brazil
838261 2021-01-11 Brazil Rio Grande do Sul     482062 9498 457266 15298 -30.0346 -51.2177 2021-01-12 05:22:15 Rio Grande do Sul, Brazil
838262 2021-01-11 Brazil Rio de Janeiro     461561 26771 428991 5799 -22.9068 -43.1729 2021-01-12 05:22:15 Rio de Janeiro, Brazil
838263 2021-01-11 Brazil Rondonia     102518 1926 85353 15239 -11.5057 -63.5806 2021-01-12 05:22:15 Rondonia, Brazil
838264 2021-01-11 Brazil Roraima     69785 793 66262 2730 -2.7376 -62.0751 2021-01-12 05:22:15 Roraima, Brazil
838265 2021-01-11 Brazil Santa Catarina     522478 5677 494693 22108 -27.2423 -50.2189 2021-01-12 05:22:15 Santa Catarina, Brazil
838266 2021-01-11 Brazil Sao Paulo     1549142 48379 1370112 130651 -23.5505 -46.6333 2021-01-12 05:22:15 Sao Paulo, Brazil
838267 2021-01-11 Brazil Sergipe     123836 2585 107105 14146 -10.5741 -37.3857 2021-01-12 05:22:15 Sergipe, Brazil
838268 2021-01-11 Brazil Tocantins     93261 1274 83825 8162 -10.1753 -48.2982 2021-01-12 05:22:15 Tocantins, Brazil
838269 2021-01-11 Brunei       173 3 153 17 4.5353 114.7277 2021-01-12 05:22:15 Brunei
838270 2021-01-11 Bulgaria       209131 8232 137842 63057 42.7339 25.4858 2021-01-12 05:22:15 Bulgaria
838271 2021-01-11 Burkina Faso       8279 89 5872 2318 12.2383 -1.5616 2021-01-12 05:22:15 Burkina Faso
838272 2021-01-11 Burma       131186 2858 114609 13719 21.9162 95.956 2021-01-12 05:22:15 Burma
838273 2021-01-11 Burundi       1019 2 773 244 -3.3731 29.9189 2021-01-12 05:22:15 Burundi
838274 2021-01-11 Cabo Verde       12433 115 11793 525 16.5388 -23.0418 2021-01-12 05:22:15 Cabo Verde
838275 2021-01-11 Cambodia       392 0 374 18 11.55 104.9167 2021-01-12 05:22:15 Cambodia
838276 2021-01-11 Cameroon       26848 448 24892 1508 3.848 11.5021 2021-01-12 05:22:15 Cameroon
838277 2021-01-11 Canada Alberta     112091 1307 96867 13917 53.9333 -116.5765 2021-01-12 05:22:15 Alberta, Canada
838278 2021-01-11 Canada British Columbia     58107 1010 50541 6556 53.7267 -127.6476 2021-01-12 05:22:15 British Columbia, Canada
838279 2021-01-11 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
838280 2021-01-11 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
838281 2021-01-11 Canada Manitoba     26450 741 22295 3414 53.7609 -98.8139 2021-01-12 05:22:15 Manitoba, Canada
838282 2021-01-11 Canada New Brunswick     800 9 586 205 46.5653 -66.4619 2021-01-12 05:22:15 New Brunswick, Canada
838283 2021-01-11 Canada Newfoundland and Labrador     393 4 381 8 53.1355 -57.6604 2021-01-12 05:22:15 Newfoundland and Labrador, Canada
838284 2021-01-11 Canada Northwest Territories     24 0 24 0 64.8255 -124.8457 2021-01-12 05:22:15 Northwest Territories,Canada
838285 2021-01-11 Canada Nova Scotia     1533 65 1442 26 44.682 -63.7443 2021-01-12 05:22:15 Nova Scotia, Canada
838286 2021-01-11 Canada Nunavut     266 1 265 0 70.2998 -83.1076 2021-01-12 05:22:15 Nunavut, Canada
838287 2021-01-11 Canada Ontario     223857 5021 190042 28794 51.2538 -85.3232 2021-01-12 05:22:15 Ontario, Canada
838288 2021-01-11 Canada Prince Edward Island     102 0 94 8 46.5107 -63.4168 2021-01-12 05:22:15 Prince Edward Island, Canada
838289 2021-01-11 Canada Quebec     230690 8737 197938 24015 52.9399 -73.5491 2021-01-12 05:22:15 Quebec, Canada
838290 2021-01-11 Canada Repatriated Travellers     13 0 13 0     2021-01-12 05:22:15 Repatriated Travellers, Canada
838291 2021-01-11 Canada Saskatchewan     18522 199 14588 3735 52.9399 -106.4509 2021-01-12 05:22:15 Saskatchewan, Canada
838292 2021-01-11 Canada Yukon     70 1 63 6 64.2823 -135.0 2021-01-12 05:22:15 Yukon, Canada
838293 2021-01-11 Central African Republic       4973 63 4885 25 6.6111 20.9394 2021-01-12 05:22:15 Central African Republic
838294 2021-01-11 Chad       2589 107 1994 488 15.4542 18.7322 2021-01-12 05:22:15 Chad
838295 2021-01-11 Chile Antofagasta     25737 597 23720 1420 -23.6509 -70.3975 2021-01-12 05:22:15 Antofagasta, Chile
838296 2021-01-11 Chile Araucania     25712 344 23947 1421 -38.9489 -72.3311 2021-01-12 05:22:15 Araucania, Chile
838297 2021-01-11 Chile Arica y Parinacota     11341 232 10726 383 -18.594 -69.4785 2021-01-12 05:22:15 Arica y Parinacota, Chile
838298 2021-01-11 Chile Atacama     8829 115 8516 198 -27.5661 -70.0503 2021-01-12 05:22:15 Atacama, Chile
838299 2021-01-11 Chile Aysen     1847 18 1646 183 -45.9864 -73.7669 2021-01-12 05:22:15 Aysen, Chile
838300 2021-01-11 Chile Biobio     52198 891 48247 3060 -37.4464 -72.1416 2021-01-12 05:22:15 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]);