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

951,597 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
286005 2020-11-20 Afghanistan       44443 1661 35370 7412 33.93911 67.709953 2020-11-21 05:25:51 Afghanistan
286006 2020-11-20 Albania       31459 672 15055 15732 41.1533 20.1683 2020-11-21 05:25:51 Albania
286007 2020-11-20 Algeria       72755 2236 47581 22938 28.0339 1.6596 2020-11-21 05:25:51 Algeria
286008 2020-11-20 Andorra       6142 76 5239 827 42.5063 1.5218 2020-11-21 05:25:51 Andorra
286009 2020-11-20 Angola       14267 334 7117 6816 -11.2027 17.8739 2020-11-21 05:25:51 Angola
286010 2020-11-20 Antigua and Barbuda       139 4 127 8 17.0608 -61.7964 2020-11-21 05:25:51 Antigua and Barbuda
286011 2020-11-20 Argentina       1359042 36790 1177819 144433 -38.4161 -63.6167 2020-11-21 05:25:51 Argentina
286012 2020-11-20 Armenia       123646 1900 90754 30992 40.0691 45.0382 2020-11-21 05:25:51 Armenia
286013 2020-11-20 Australia Australian Capital Territory     115 3 111 1 -35.4735 149.0124 2020-11-21 05:25:51 Australian Capital Territory, Australia
286014 2020-11-20 Australia New South Wales     4527 53 3173 1301 -33.8688 151.2093 2020-11-21 05:25:51 New South Wales, Australia
286015 2020-11-20 Australia Northern Territory     46 0 39 7 -12.4634 130.8456 2020-11-21 05:25:51 Northern Territory, Australia
286016 2020-11-20 Australia Queensland     1192 6 1171 15 -27.4698 153.0251 2020-11-21 05:25:51 Queensland, Australia
286017 2020-11-20 Australia South Australia     554 4 513 37 -34.9285 138.6007 2020-11-21 05:25:51 South Australia, Australia
286018 2020-11-20 Australia Tasmania     230 13 217 0 -42.8821 147.3272 2020-11-21 05:25:51 Tasmania, Australia
286019 2020-11-20 Australia Victoria     20345 819 19525 1 -37.8136 144.9631 2020-11-21 05:25:51 Victoria, Australia
286020 2020-11-20 Australia Western Australia     797 9 772 16 -31.9505 115.8605 2020-11-21 05:25:51 Western Australia, Australia
286021 2020-11-20 Austria       235351 2224 156483 76644 47.5162 14.5501 2020-11-21 05:25:51 Austria
286022 2020-11-20 Azerbaijan       87163 1079 60869 25215 40.1431 47.5769 2020-11-21 05:25:51 Azerbaijan
286023 2020-11-20 Bahamas       7367 163 5516 1688 25.025885 -78.035889 2020-11-21 05:25:51 Bahamas
286024 2020-11-20 Bahrain       85467 338 83416 1713 26.0275 50.55 2020-11-21 05:25:51 Bahrain
286025 2020-11-20 Bangladesh       443434 6322 358431 78681 23.685 90.3563 2020-11-21 05:25:51 Bangladesh
286026 2020-11-20 Barbados       253 7 241 5 13.1939 -59.5432 2020-11-21 05:25:51 Barbados
286027 2020-11-20 Belarus       120847 1081 100749 19017 53.7098 27.9534 2020-11-21 05:25:51 Belarus
286028 2020-11-20 Belgium Antwerp     64605 0 0 64605 51.2195 4.4024 2020-11-21 05:25:51 Antwerp, Belgium
286029 2020-11-20 Belgium Brussels     74344 0 0 74344 50.8503 4.3517 2020-11-21 05:25:51 Brussels, Belgium
286030 2020-11-20 Belgium East Flanders     50826 0 0 50826 51.0362 3.7373 2020-11-21 05:25:51 East Flanders, Belgium
286031 2020-11-20 Belgium Flemish Brabant     42231 0 0 42231 50.9167 4.5833 2020-11-21 05:25:51 Flemish Brabant, Belgium
286032 2020-11-20 Belgium Hainaut     89091 0 0 89091 50.5257 4.0621 2020-11-21 05:25:51 Hainaut, Belgium
286033 2020-11-20 Belgium Liege     89428 0 0 89428 50.4496 5.8492 2020-11-21 05:25:51 Liege, Belgium
286034 2020-11-20 Belgium Limburg     22959 0 0 22959 50.9739 5.3420000000000005 2020-11-21 05:25:51 Limburg, Belgium
286035 2020-11-20 Belgium Luxembourg     15484 0 0 15484 50.0547 5.4677 2020-11-21 05:25:51 Luxembourg, Belgium
286036 2020-11-20 Belgium Namur     31164 0 0 31164 50.331 4.8221 2020-11-21 05:25:51 Namur, Belgium
286037 2020-11-20 Belgium Unknown     9155 15352 0 -6197     2020-11-21 05:25:51 Unknown, Belgium
286038 2020-11-20 Belgium Walloon Brabant     22479 0 0 22479 50.4 4.35 2020-11-21 05:25:51 Walloon Brabant, Belgium
286039 2020-11-20 Belgium West Flanders     41914 0 0 41914 51.0536 3.1458 2020-11-21 05:25:51 West Flanders, Belgium
286040 2020-11-20 Belize       5056 107 2760 2189 17.1899 -88.4976 2020-11-21 05:25:51 Belize
286041 2020-11-20 Benin       2916 43 2579 294 9.3077 2.3158 2020-11-21 05:25:51 Benin
286042 2020-11-20 Bhutan       378 0 358 20 27.5142 90.4336 2020-11-21 05:25:51 Bhutan
286043 2020-11-20 Bolivia       143854 8900 119029 15925 -16.2902 -63.5887 2020-11-21 05:25:51 Bolivia
286044 2020-11-20 Bosnia and Herzegovina       77994 2209 42916 32869 43.9159 17.6791 2020-11-21 05:25:51 Bosnia and Herzegovina
286045 2020-11-20 Botswana       9594 31 7296 2267 -22.3285 24.6849 2020-11-21 05:25:51 Botswana
286046 2020-11-20 Brazil Acre     34246 711 29823 3712 -9.0238 -70.812 2020-11-21 05:25:51 Acre, Brazil
286047 2020-11-20 Brazil Alagoas     93245 2311 89887 1047 -9.5713 -36.782 2020-11-21 05:25:51 Alagoas, Brazil
286048 2020-11-20 Brazil Amapa     56085 787 46049 9249 0.902 -52.003 2020-11-21 05:25:51 Amapa, Brazil
286049 2020-11-20 Brazil Amazonas     172858 4761 147952 20145 -3.4168 -65.8561 2020-11-21 05:25:51 Amazonas, Brazil
286050 2020-11-20 Brazil Bahia     382164 8061 365848 8255 -12.5797 -41.7007 2020-11-21 05:25:51 Bahia, Brazil
286051 2020-11-20 Brazil Ceara     289925 9477 244955 35493 -5.4984 -39.3206 2020-11-21 05:25:51 Ceara, Brazil
286052 2020-11-20 Brazil Distrito Federal     222836 3857 213717 5262 -15.7998 -47.8645 2020-11-21 05:25:51 Distrito Federal, Brazil
286053 2020-11-20 Brazil Espirito Santo     176903 4101 164427 8375 -19.1834 -40.3089 2020-11-21 05:25:51 Espirito Santo, Brazil
286054 2020-11-20 Brazil Goias     272494 6201 262946 3347 -15.827 -49.8362 2020-11-21 05:25:51 Goias, Brazil
286055 2020-11-20 Brazil Maranhao     190953 4218 184004 2731 -4.9609 -45.2744 2020-11-21 05:25:51 Maranhao, Brazil
286056 2020-11-20 Brazil Mato Grosso     153800 4025 144878 4897 -12.6819 -56.9211 2020-11-21 05:25:51 Mato Grosso, Brazil
286057 2020-11-20 Brazil Mato Grosso do Sul     90765 1713 82598 6454 -20.7722 -54.7852 2020-11-21 05:25:51 Mato Grosso do Sul, Brazil
286058 2020-11-20 Brazil Minas Gerais     393110 9688 361276 22146 -18.5122 -44.555 2020-11-21 05:25:51 Minas Gerais, Brazil
286059 2020-11-20 Brazil Para     264810 6855 247967 9988 -1.9981 -54.9306 2020-11-21 05:25:51 Para, Brazil
286060 2020-11-20 Brazil Paraiba     141615 3236 113102 25277 -7.24 -36.782 2020-11-21 05:25:51 Paraiba, Brazil
286061 2020-11-20 Brazil Parana     250898 5832 184661 60405 -25.2521 -52.0215 2020-11-21 05:25:51 Parana, Brazil
286062 2020-11-20 Brazil Pernambuco     174312 8899 154975 10438 -8.8137 -36.9541 2020-11-21 05:25:51 Pernambuco, Brazil
286063 2020-11-20 Brazil Piaui     122007 2568 119519 -80 -7.7183 -42.7289 2020-11-21 05:25:51 Piaui, Brazil
286064 2020-11-20 Brazil Rio Grande do Norte     84865 2657 47431 34777 -5.4026 -36.9541 2020-11-21 05:25:51 Rio Grande do Norte, Brazil
286065 2020-11-20 Brazil Rio Grande do Sul     293221 6447 269603 17171 -30.0346 -51.2177 2020-11-21 05:25:51 Rio Grande do Sul, Brazil
286066 2020-11-20 Brazil Rio de Janeiro     336915 21938 308297 6680 -22.9068 -43.1729 2020-11-21 05:25:51 Rio de Janeiro, Brazil
286067 2020-11-20 Brazil Rondonia     76729 1515 68444 6770 -11.5057 -63.5806 2020-11-21 05:25:51 Rondonia, Brazil
286068 2020-11-20 Brazil Roraima     61553 720 58377 2456 -2.7376 -62.0751 2020-11-21 05:25:51 Roraima, Brazil
286069 2020-11-20 Brazil Santa Catarina     317502 3435 290537 23530 -27.2423 -50.2189 2020-11-21 05:25:51 Santa Catarina, Brazil
286070 2020-11-20 Brazil Sao Paulo     1200348 41179 1076616 82553 -23.5505 -46.6333 2020-11-21 05:25:51 Sao Paulo, Brazil
286071 2020-11-20 Brazil Sergipe     86847 2274 81667 2906 -10.5741 -37.3857 2020-11-21 05:25:51 Sergipe, Brazil
286072 2020-11-20 Brazil Tocantins     79158 1147 71340 6671 -10.1753 -48.2982 2020-11-21 05:25:51 Tocantins, Brazil
286073 2020-11-20 Brunei       148 3 145 0 4.5353 114.7277 2020-11-21 05:25:51 Brunei
286074 2020-11-20 Bulgaria       118418 2778 34388 81252 42.7339 25.4858 2020-11-21 05:25:51 Bulgaria
286075 2020-11-20 Burkina Faso       2686 68 2476 142 12.2383 -1.5616 2020-11-21 05:25:51 Burkina Faso
286076 2020-11-20 Burma       76414 1695 56601 18118 21.9162 95.956 2020-11-21 05:25:51 Burma
286077 2020-11-20 Burundi       649 1 575 73 -3.3731 29.9189 2020-11-21 05:25:51 Burundi
286078 2020-11-20 Cabo Verde       10152 104 9626 422 16.5388 -23.0418 2020-11-21 05:25:51 Cabo Verde
286079 2020-11-20 Cambodia       305 0 295 10 11.55 104.9167 2020-11-21 05:25:51 Cambodia
286080 2020-11-20 Cameroon       23528 435 22177 916 3.848 11.5021 2020-11-21 05:25:51 Cameroon
286081 2020-11-20 Canada Alberta     43952 462 32835 10655 53.9333 -116.5765 2020-11-21 05:25:51 Alberta, Canada
286082 2020-11-20 Canada British Columbia     25474 331 18021 7122 53.7267 -127.6476 2020-11-21 05:25:51 British Columbia, Canada
286083 2020-11-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-11-21 05:25:51 Diamond Princess, Canada
286084 2020-11-20 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-11-21 05:25:51 Grand Princess, Canada
286085 2020-11-20 Canada Manitoba     12919 207 4851 7861 53.7609 -98.8139 2020-11-21 05:25:51 Manitoba, Canada
286086 2020-11-20 Canada New Brunswick     401 6 344 51 46.5653 -66.4619 2020-11-21 05:25:51 New Brunswick, Canada
286087 2020-11-20 Canada Newfoundland and Labrador     311 4 294 13 53.1355 -57.6604 2020-11-21 05:25:51 Newfoundland and Labrador, Canada
286088 2020-11-20 Canada Northwest Territories     15 0 10 5 64.8255 -124.8457 2020-11-21 05:25:51 Northwest Territories,Canada
286089 2020-11-20 Canada Nova Scotia     1160 65 1067 28 44.682 -63.7443 2020-11-21 05:25:51 Nova Scotia, Canada
286090 2020-11-20 Canada Nunavut     82 0 0 0 70.2998 -83.1076 2020-11-21 05:25:51 Nunavut, Canada
286091 2020-11-20 Canada Ontario     104307 3501 89280 11526 51.2538 -85.3232 2020-11-21 05:25:51 Ontario, Canada
286092 2020-11-20 Canada Prince Edward Island     68 0 65 3 46.5107 -63.4168 2020-11-21 05:25:51 Prince Edward Island, Canada
286093 2020-11-20 Canada Quebec     129699 6774 111326 11599 52.9399 -73.5491 2020-11-21 05:25:51 Quebec, Canada
286094 2020-11-20 Canada Saskatchewan     5804 33 3626 2145 52.9399 -106.4509 2020-11-21 05:25:51 Saskatchewan, Canada
286095 2020-11-20 Canada Yukon     29 1 22 6 64.2823 -135.0 2020-11-21 05:25:51 Yukon, Canada
286096 2020-11-20 Central African Republic       4911 63 1924 2924 6.6111 20.9394 2020-11-21 05:25:51 Central African Republic
286097 2020-11-20 Chad       1626 101 1465 60 15.4542 18.7322 2020-11-21 05:25:51 Chad
286098 2020-11-20 Chile Antofagasta     21959 556 21174 229 -23.6509 -70.3975 2020-11-21 05:25:51 Antofagasta, Chile
286099 2020-11-20 Chile Araucania     15936 203 14758 975 -38.9489 -72.3311 2020-11-21 05:25:51 Araucania, Chile
286100 2020-11-20 Chile Arica y Parinacota     10099 198 9726 175 -18.594 -69.4785 2020-11-21 05:25:51 Arica y Parinacota, Chile
286101 2020-11-20 Chile Atacama     8034 101 7857 76 -27.5661 -70.0503 2020-11-21 05:25:51 Atacama, Chile
286102 2020-11-20 Chile Aysen     1195 9 1137 49 -45.9864 -73.7669 2020-11-21 05:25:51 Aysen, Chile
286103 2020-11-20 Chile Biobio     33992 570 31723 1699 -37.4464 -72.1416 2020-11-21 05:25:51 Biobio, Chile
286104 2020-11-20 Chile Coquimbo     12901 262 12555 84 -29.959 -71.3389 2020-11-21 05:25:51 Coquimbo, 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]);
Powered by Datasette · Query took 4580.47ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette