johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, last_update
country_or_region >30
- US 3,264,872
- Russia 77,809
- Japan 46,136
- China 34,661
- India 34,383
- Colombia 31,985
- Mexico 31,192
- Ukraine 26,430
- Brazil 25,700
- Peru 24,523
- Italy 20,138
- Sweden 19,698
- United Kingdom 19,619
- Spain 19,178
- Malaysia 18,141
- Germany 16,325
- Chile 16,194
- Canada 16,132
- Netherlands 15,740
- France 11,901
- Belgium 9,557
- Australia 8,372
- Pakistan 6,594
- New Zealand 3,171
- Denmark 3,059
- Mainland China 1,517
- Antarctica 1,068
- Korea, North 1,068
- Nauru 1,068
- Tonga 1,068
- …
Link | rowid ▼ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24058 | 24058 | 2021-05-28 | Malaysia | W.P. Putrajaya | 1821 | 10 | 1562 | 249 | 2.9264 | 101.6964 | 2021-05-29 04:20:41 | W.P. Putrajaya, Malaysia | ||
24059 | 24059 | 2021-05-28 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2021-05-29 04:20:41 | Unknown, Malaysia | ||||
24060 | 24060 | 2021-05-28 | Tonga | 0 | 0 | 0 | 0 | -21.179 | -175.1982 | 2021-05-29 04:20:41 | Tonga | |||
24061 | 24061 | 2021-05-28 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2021-05-29 04:20:41 | Winter Olympics 2022 | |||
24062 | 24062 | 2021-05-28 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2021-05-29 04:20:41 | Antarctica | |||
24063 | 24063 | 2021-05-28 | United Kingdom | Jersey | 3241 | 69 | 0 | 0 | 49.2138 | -2.1358 | 2021-05-29 04:20:41 | Jersey, United Kingdom | ||
24064 | 24064 | 2021-05-28 | United Kingdom | Guernsey | 822 | 17 | 0 | 0 | 49.448196 | -2.58949 | 2021-05-29 04:20:41 | Guernsey, United Kingdom | ||
24065 | 24065 | 2021-05-28 | Korea, North | 0 | 0 | 0 | 0 | 40.3399 | 127.5101 | 2021-05-29 04:20:41 | Korea, North | |||
24066 | 24066 | 2021-05-28 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-05-29 04:20:41 | Unknown, Ukraine | ||||
24067 | 24067 | 2021-05-28 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2021-05-29 04:20:41 | Nauru | |||
24068 | 24068 | 2021-05-28 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-05-29 04:20:41 | Niue, New Zealand | ||
24069 | 24069 | 2021-05-28 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2021-05-29 04:20:41 | Tuvalu | |||
24070 | 24070 | 2021-05-28 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-05-29 04:20:41 | Pitcairn Islands, United Kingdom | ||
24071 | 24071 | 2022-03-20 | Afghanistan | 177093 | 7654 | 0 | 33.93911 | 67.709953 | 2022-03-21 04:20:50 | Afghanistan | ||||
24072 | 24072 | 2022-03-20 | Albania | 273088 | 3487 | 0 | 41.1533 | 20.1683 | 2022-03-21 04:20:50 | Albania | ||||
24073 | 24073 | 2022-03-20 | Algeria | 265550 | 6871 | 0 | 28.0339 | 1.6596 | 2022-03-21 04:20:50 | Algeria | ||||
24074 | 24074 | 2022-03-20 | Andorra | 39234 | 153 | 0 | 42.5063 | 1.5218 | 2022-03-21 04:20:50 | Andorra | ||||
24075 | 24075 | 2022-03-20 | Angola | 99003 | 1900 | 0 | -11.2027 | 17.8739 | 2022-03-21 04:20:50 | Angola | ||||
24076 | 24076 | 2022-03-20 | Antarctica | 11 | 0 | 0 | -71.9499 | 23.346999999999998 | 2022-03-21 04:20:50 | Antarctica | ||||
24077 | 24077 | 2022-03-20 | Antigua and Barbuda | 7473 | 135 | 0 | 17.0608 | -61.7964 | 2022-03-21 04:20:50 | Antigua and Barbuda | ||||
24078 | 24078 | 2022-03-20 | Argentina | 9007753 | 127494 | 0 | -38.4161 | -63.6167 | 2022-03-21 04:20:50 | Argentina | ||||
24079 | 24079 | 2022-03-20 | Armenia | 422307 | 8595 | 0 | 40.0691 | 45.0382 | 2022-03-21 04:20:50 | Armenia | ||||
24080 | 24080 | 2022-03-20 | Australia | Australian Capital Territory | 67243 | 38 | 0 | -35.4735 | 149.0124 | 2022-03-21 04:20:50 | Australian Capital Territory, Australia | |||
24081 | 24081 | 2022-03-20 | Australia | New South Wales | 1602275 | 2025 | 0 | -33.8688 | 151.2093 | 2022-03-21 04:20:50 | New South Wales, Australia | |||
24082 | 24082 | 2022-03-20 | Australia | Northern Territory | 46360 | 31 | 0 | -12.4634 | 130.8456 | 2022-03-21 04:20:50 | Northern Territory, Australia | |||
24083 | 24083 | 2022-03-20 | Australia | Queensland | 672275 | 685 | 0 | -27.4698 | 153.0251 | 2022-03-21 04:20:50 | Queensland, Australia | |||
24084 | 24084 | 2022-03-20 | Australia | South Australia | 207490 | 234 | 0 | -34.9285 | 138.6007 | 2022-03-21 04:20:50 | South Australia, Australia | |||
24085 | 24085 | 2022-03-20 | Australia | Tasmania | 69526 | 27 | 0 | -42.8821 | 147.3272 | 2022-03-21 04:20:50 | Tasmania, Australia | |||
24086 | 24086 | 2022-03-20 | Australia | Victoria | 1185768 | 2675 | 0 | -37.8136 | 144.9631 | 2022-03-21 04:20:50 | Victoria, Australia | |||
24087 | 24087 | 2022-03-20 | Australia | Western Australia | 92431 | 21 | 0 | -31.9505 | 115.8605 | 2022-03-21 04:20:50 | Western Australia, Australia | |||
24088 | 24088 | 2022-03-20 | Austria | 3462110 | 18525 | 0 | 47.5162 | 14.5501 | 2022-03-21 04:20:50 | Austria | ||||
24089 | 24089 | 2022-03-20 | Azerbaijan | 791482 | 9656 | 0 | 40.1431 | 47.5769 | 2022-03-21 04:20:50 | Azerbaijan | ||||
24090 | 24090 | 2022-03-20 | Bahamas | 33221 | 787 | 0 | 25.025885 | -78.035889 | 2022-03-21 04:20:50 | Bahamas | ||||
24091 | 24091 | 2022-03-20 | Bahrain | 544851 | 1465 | 0 | 26.0275 | 50.55 | 2022-03-21 04:20:50 | Bahrain | ||||
24092 | 24092 | 2022-03-20 | Bangladesh | 1950609 | 29117 | 0 | 23.685 | 90.3563 | 2022-03-21 04:20:50 | Bangladesh | ||||
24093 | 24093 | 2022-03-20 | Barbados | 57733 | 329 | 0 | 13.1939 | -59.5432 | 2022-03-21 04:20:50 | Barbados | ||||
24094 | 24094 | 2022-03-20 | Belarus | 951081 | 6722 | 0 | 53.7098 | 27.9534 | 2022-03-21 04:20:50 | Belarus | ||||
24095 | 24095 | 2022-03-20 | Belgium | Antwerp | 573834 | 0 | 0 | 51.2195 | 4.4024 | 2022-03-21 04:20:50 | Antwerp, Belgium | |||
24096 | 24096 | 2022-03-20 | Belgium | Brussels | 420609 | 0 | 0 | 50.8503 | 4.3517 | 2022-03-21 04:20:50 | Brussels, Belgium | |||
24097 | 24097 | 2022-03-20 | Belgium | East Flanders | 480700 | 0 | 0 | 51.0362 | 3.7373 | 2022-03-21 04:20:50 | East Flanders, Belgium | |||
24098 | 24098 | 2022-03-20 | Belgium | Flemish Brabant | 346444 | 0 | 0 | 50.9167 | 4.5833 | 2022-03-21 04:20:50 | Flemish Brabant, Belgium | |||
24099 | 24099 | 2022-03-20 | Belgium | Hainaut | 423885 | 0 | 0 | 50.5257 | 4.0621 | 2022-03-21 04:20:50 | Hainaut, Belgium | |||
24100 | 24100 | 2022-03-20 | Belgium | Liege | 351761 | 0 | 0 | 50.4496 | 5.8492 | 2022-03-21 04:20:50 | Liege, Belgium | |||
24101 | 24101 | 2022-03-20 | Belgium | Limburg | 269731 | 0 | 0 | 50.9739 | 5.3420000000000005 | 2022-03-21 04:20:50 | Limburg, Belgium | |||
24102 | 24102 | 2022-03-20 | Belgium | Luxembourg | 96753 | 0 | 0 | 50.0547 | 5.4677 | 2022-03-21 04:20:50 | Luxembourg, Belgium | |||
24103 | 24103 | 2022-03-20 | Belgium | Namur | 164436 | 0 | 0 | 50.331 | 4.8221 | 2022-03-21 04:20:50 | Namur, Belgium | |||
24104 | 24104 | 2022-03-20 | Belgium | Unknown | 54232 | 30529 | 0 | 2022-03-21 04:20:50 | Unknown, Belgium | |||||
24105 | 24105 | 2022-03-20 | Belgium | Walloon Brabant | 138299 | 0 | 0 | 50.4 | 4.35 | 2022-03-21 04:20:50 | Walloon Brabant, Belgium | |||
24106 | 24106 | 2022-03-20 | Belgium | West Flanders | 386877 | 0 | 0 | 51.0536 | 3.1458 | 2022-03-21 04:20:50 | West Flanders, Belgium | |||
24107 | 24107 | 2022-03-20 | Belize | 57143 | 654 | 0 | 17.1899 | -88.4976 | 2022-03-21 04:20:50 | Belize | ||||
24108 | 24108 | 2022-03-20 | Benin | 26952 | 163 | 0 | 9.3077 | 2.3158 | 2022-03-21 04:20:50 | Benin | ||||
24109 | 24109 | 2022-03-20 | Bhutan | 22004 | 9 | 0 | 27.5142 | 90.4336 | 2022-03-21 04:20:50 | Bhutan | ||||
24110 | 24110 | 2022-03-20 | Bolivia | 899697 | 21482 | 0 | -16.2902 | -63.5887 | 2022-03-21 04:20:50 | Bolivia | ||||
24111 | 24111 | 2022-03-20 | Bosnia and Herzegovina | 373985 | 15664 | 0 | 43.9159 | 17.6791 | 2022-03-21 04:20:50 | Bosnia and Herzegovina | ||||
24112 | 24112 | 2022-03-20 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-21 04:20:50 | Botswana | ||||
24113 | 24113 | 2022-03-20 | Brazil | Acre | 123669 | 1990 | 0 | -9.0238 | -70.812 | 2022-03-21 04:20:50 | Acre, Brazil | |||
24114 | 24114 | 2022-03-20 | Brazil | Alagoas | 295321 | 6845 | 0 | -9.5713 | -36.782 | 2022-03-21 04:20:50 | Alagoas, Brazil | |||
24115 | 24115 | 2022-03-20 | Brazil | Amapa | 160260 | 2120 | 0 | 0.902 | -52.003 | 2022-03-21 04:20:50 | Amapa, Brazil | |||
24116 | 24116 | 2022-03-20 | Brazil | Amazonas | 580491 | 14147 | 0 | -3.4168 | -65.8561 | 2022-03-21 04:20:50 | Amazonas, Brazil | |||
24117 | 24117 | 2022-03-20 | Brazil | Bahia | 1524517 | 29584 | 0 | -12.5797 | -41.7007 | 2022-03-21 04:20:50 | Bahia, Brazil | |||
24118 | 24118 | 2022-03-20 | Brazil | Ceara | 1236310 | 26666 | 0 | -5.4984 | -39.3206 | 2022-03-21 04:20:50 | Ceara, Brazil | |||
24119 | 24119 | 2022-03-20 | Brazil | Distrito Federal | 689883 | 11551 | 0 | -15.7998 | -47.8645 | 2022-03-21 04:20:50 | Distrito Federal, Brazil | |||
24120 | 24120 | 2022-03-20 | Brazil | Espirito Santo | 1034457 | 14300 | 0 | -19.1834 | -40.3089 | 2022-03-21 04:20:50 | Espirito Santo, Brazil | |||
24121 | 24121 | 2022-03-20 | Brazil | Goias | 1247897 | 26067 | 0 | -15.827 | -49.8362 | 2022-03-21 04:20:50 | Goias, Brazil | |||
24122 | 24122 | 2022-03-20 | Brazil | Maranhao | 421786 | 10858 | 0 | -4.9609 | -45.2744 | 2022-03-21 04:20:50 | Maranhao, Brazil | |||
24123 | 24123 | 2022-03-20 | Brazil | Mato Grosso | 721235 | 14841 | 0 | -12.6819 | -56.9211 | 2022-03-21 04:20:50 | Mato Grosso, Brazil | |||
24124 | 24124 | 2022-03-20 | Brazil | Mato Grosso do Sul | 520247 | 10467 | 0 | -20.7722 | -54.7852 | 2022-03-21 04:20:50 | Mato Grosso do Sul, Brazil | |||
24125 | 24125 | 2022-03-20 | Brazil | Minas Gerais | 3296877 | 60560 | 0 | -18.5122 | -44.555 | 2022-03-21 04:20:50 | Minas Gerais, Brazil | |||
24126 | 24126 | 2022-03-20 | Brazil | Para | 744882 | 18036 | 0 | -1.9981 | -54.9306 | 2022-03-21 04:20:50 | Para, Brazil | |||
24127 | 24127 | 2022-03-20 | Brazil | Paraiba | 592205 | 10174 | 0 | -7.24 | -36.782 | 2022-03-21 04:20:50 | Paraiba, Brazil | |||
24128 | 24128 | 2022-03-20 | Brazil | Parana | 2396983 | 42801 | 0 | -25.2521 | -52.0215 | 2022-03-21 04:20:50 | Parana, Brazil | |||
24129 | 24129 | 2022-03-20 | Brazil | Pernambuco | 880404 | 21285 | 0 | -8.8137 | -36.9541 | 2022-03-21 04:20:50 | Pernambuco, Brazil | |||
24130 | 24130 | 2022-03-20 | Brazil | Piaui | 367207 | 7716 | 0 | -7.7183 | -42.7289 | 2022-03-21 04:20:50 | Piaui, Brazil | |||
24131 | 24131 | 2022-03-20 | Brazil | Rio Grande do Norte | 492730 | 8113 | 0 | -5.4026 | -36.9541 | 2022-03-21 04:20:50 | Rio Grande do Norte, Brazil | |||
24132 | 24132 | 2022-03-20 | Brazil | Rio Grande do Sul | 2240729 | 38882 | 0 | -30.0346 | -51.2177 | 2022-03-21 04:20:50 | Rio Grande do Sul, Brazil | |||
24133 | 24133 | 2022-03-20 | Brazil | Rio de Janeiro | 2058978 | 72495 | 0 | -22.9068 | -43.1729 | 2022-03-21 04:20:50 | Rio de Janeiro, Brazil | |||
24134 | 24134 | 2022-03-20 | Brazil | Rondonia | 387366 | 7140 | 0 | -11.5057 | -63.5806 | 2022-03-21 04:20:50 | Rondonia, Brazil | |||
24135 | 24135 | 2022-03-20 | Brazil | Roraima | 154827 | 2144 | 0 | -2.7376 | -62.0751 | 2022-03-21 04:20:50 | Roraima, Brazil | |||
24136 | 24136 | 2022-03-20 | Brazil | Santa Catarina | 1660608 | 21618 | 0 | -27.2423 | -50.2189 | 2022-03-21 04:20:50 | Santa Catarina, Brazil | |||
24137 | 24137 | 2022-03-20 | Brazil | Sao Paulo | 5182365 | 166658 | 0 | -23.5505 | -46.6333 | 2022-03-21 04:20:50 | Sao Paulo, Brazil | |||
24138 | 24138 | 2022-03-20 | Brazil | Sergipe | 323933 | 6297 | 0 | -10.5741 | -37.3857 | 2022-03-21 04:20:50 | Sergipe, Brazil | |||
24139 | 24139 | 2022-03-20 | Brazil | Tocantins | 301647 | 4140 | 0 | -10.1753 | -48.2982 | 2022-03-21 04:20:50 | Tocantins, Brazil | |||
24140 | 24140 | 2022-03-20 | Brunei | 124716 | 189 | 0 | 4.5353 | 114.7277 | 2022-03-21 04:20:50 | Brunei | ||||
24141 | 24141 | 2022-03-20 | Bulgaria | 1124186 | 36282 | 0 | 42.7339 | 25.4858 | 2022-03-21 04:20:50 | Bulgaria | ||||
24142 | 24142 | 2022-03-20 | Burkina Faso | 20813 | 379 | 0 | 12.2383 | -1.5616 | 2022-03-21 04:20:50 | Burkina Faso | ||||
24143 | 24143 | 2022-03-20 | Burma | 608990 | 19425 | 0 | 21.9162 | 95.956 | 2022-03-21 04:20:50 | Burma | ||||
24144 | 24144 | 2022-03-20 | Burundi | 38308 | 38 | 0 | -3.3731 | 29.9189 | 2022-03-21 04:20:50 | Burundi | ||||
24145 | 24145 | 2022-03-20 | Cabo Verde | 55925 | 401 | 0 | 16.5388 | -23.0418 | 2022-03-21 04:20:50 | Cabo Verde | ||||
24146 | 24146 | 2022-03-20 | Cambodia | 134986 | 3051 | 0 | 11.55 | 104.9167 | 2022-03-21 04:20:50 | Cambodia | ||||
24147 | 24147 | 2022-03-20 | Cameroon | 119544 | 1927 | 0 | 3.8480000000000003 | 11.5021 | 2022-03-21 04:20:50 | Cameroon | ||||
24148 | 24148 | 2022-03-20 | Canada | Alberta | 534285 | 4023 | 0 | 53.9333 | -116.5765 | 2022-03-21 04:20:50 | Alberta, Canada | |||
24149 | 24149 | 2022-03-20 | Canada | British Columbia | 353578 | 2966 | 0 | 53.7267 | -127.6476 | 2022-03-21 04:20:50 | British Columbia, Canada | |||
24150 | 24150 | 2022-03-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
24151 | 24151 | 2022-03-20 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
24152 | 24152 | 2022-03-20 | Canada | Manitoba | 133928 | 1726 | 0 | 53.7609 | -98.8139 | 2022-03-21 04:20:50 | Manitoba, Canada | |||
24153 | 24153 | 2022-03-20 | Canada | New Brunswick | 42320 | 320 | 0 | 46.5653 | -66.4619 | 2022-03-21 04:20:50 | New Brunswick, Canada | |||
24154 | 24154 | 2022-03-20 | Canada | Newfoundland and Labrador | 32113 | 82 | 0 | 53.1355 | -57.6604 | 2022-03-21 04:20:50 | Newfoundland and Labrador, Canada | |||
24155 | 24155 | 2022-03-20 | Canada | Northwest Territories | 9843 | 20 | 0 | 64.8255 | -124.8457 | 2022-03-21 04:20:50 | Northwest Territories,Canada | |||
24156 | 24156 | 2022-03-20 | Canada | Nova Scotia | 48471 | 218 | 0 | 44.681999999999995 | -63.7443 | 2022-03-21 04:20:50 | Nova Scotia, Canada | |||
24157 | 24157 | 2022-03-20 | Canada | Nunavut | 3331 | 5 | 0 | 70.2998 | -83.1076 | 2022-03-21 04:20:50 | Nunavut, Canada |
Advanced export
JSON shape: default, array, newline-delimited
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]);