johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 3,258,305
- Russia 77,643
- Japan 46,038
- China 34,593
- India 34,309
- Colombia 31,917
- Mexico 31,125
- Ukraine 26,373
- Brazil 25,646
- Peru 24,471
- Italy 20,096
- Sweden 19,656
- United Kingdom 19,578
- Spain 19,138
- Malaysia 18,105
- Germany 16,291
- Chile 16,160
- Canada 16,099
- Netherlands 15,706
- France 11,876
- Belgium 9,518
- Australia 8,348
- Pakistan 6,580
- New Zealand 3,164
- Denmark 3,053
- Mainland China 1,517
- Kiribati 1,065
- Korea, North 1,065
- Nauru 1,065
- Palau 1,065
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
451086 | 451086 | 2022-12-21 | Belgium | Hainaut | 513347 | 0 | 0 | 50.5257 | 4.0621 | 2022-12-22 04:20:56 | Hainaut, Belgium | |||
451087 | 451087 | 2022-12-21 | Belgium | Liege | 415326 | 0 | 0 | 50.4496 | 5.8492 | 2022-12-22 04:20:56 | Liege, Belgium | |||
451088 | 451088 | 2022-12-21 | Belgium | Limburg | 344915 | 0 | 0 | 50.9739 | 5.342 | 2022-12-22 04:20:56 | Limburg, Belgium | |||
451089 | 451089 | 2022-12-21 | Belgium | Luxembourg | 121861 | 0 | 0 | 50.0547 | 5.4677 | 2022-12-22 04:20:56 | Luxembourg, Belgium | |||
451090 | 451090 | 2022-12-21 | Belgium | Namur | 200902 | 0 | 0 | 50.331 | 4.8221 | 2022-12-22 04:20:56 | Namur, Belgium | |||
451091 | 451091 | 2022-12-21 | Belgium | Unknown | 62623 | 33211 | 0 | 2022-12-22 04:20:56 | Unknown, Belgium | |||||
451092 | 451092 | 2022-12-21 | Belgium | Walloon Brabant | 172090 | 0 | 0 | 50.4 | 4.35 | 2022-12-22 04:20:56 | Walloon Brabant, Belgium | |||
451093 | 451093 | 2022-12-21 | Belgium | West Flanders | 492686 | 0 | 0 | 51.0536 | 3.1458 | 2022-12-22 04:20:56 | West Flanders, Belgium | |||
451094 | 451094 | 2022-12-21 | Belize | 69675 | 688 | 0 | 17.1899 | -88.4976 | 2022-12-22 04:20:56 | Belize | ||||
451095 | 451095 | 2022-12-21 | Benin | 27982 | 163 | 0 | 9.3077 | 2.3158 | 2022-12-22 04:20:56 | Benin | ||||
451096 | 451096 | 2022-12-21 | Bhutan | 62524 | 21 | 0 | 27.5142 | 90.4336 | 2022-12-22 04:20:56 | Bhutan | ||||
451097 | 451097 | 2022-12-21 | Bolivia | 1137843 | 22274 | 0 | -16.2902 | -63.5887 | 2022-12-22 04:20:56 | Bolivia | ||||
451098 | 451098 | 2022-12-21 | Bosnia and Herzegovina | 400842 | 16220 | 0 | 43.9159 | 17.6791 | 2022-12-22 04:20:56 | Bosnia and Herzegovina | ||||
451099 | 451099 | 2022-12-21 | Botswana | 327511 | 2794 | 0 | -22.3285 | 24.6849 | 2022-12-22 04:20:56 | Botswana | ||||
451100 | 451100 | 2022-12-21 | Brazil | Acre | 157668 | 2036 | 0 | -9.0238 | -70.812 | 2022-12-22 04:20:56 | Acre, Brazil | |||
451101 | 451101 | 2022-12-21 | Brazil | Alagoas | 333280 | 7182 | 0 | -9.5713 | -36.782 | 2022-12-22 04:20:56 | Alagoas, Brazil | |||
451102 | 451102 | 2022-12-21 | Brazil | Amapa | 182387 | 2165 | 0 | 0.902 | -52.003 | 2022-12-22 04:20:56 | Amapa, Brazil | |||
451103 | 451103 | 2022-12-21 | Brazil | Amazonas | 624630 | 14411 | 0 | -3.4168 | -65.8561 | 2022-12-22 04:20:56 | Amazonas, Brazil | |||
451104 | 451104 | 2022-12-21 | Brazil | Bahia | 1759036 | 31119 | 0 | -12.5797 | -41.7007 | 2022-12-22 04:20:56 | Bahia, Brazil | |||
451105 | 451105 | 2022-12-21 | Brazil | Ceara | 1432312 | 28055 | 0 | -5.4984 | -39.3206 | 2022-12-22 04:20:56 | Ceara, Brazil | |||
451106 | 451106 | 2022-12-21 | Brazil | Distrito Federal | 881597 | 11838 | 0 | -15.7998 | -47.8645 | 2022-12-22 04:20:56 | Distrito Federal, Brazil | |||
451107 | 451107 | 2022-12-21 | Brazil | Espirito Santo | 1301263 | 14931 | 0 | -19.1834 | -40.3089 | 2022-12-22 04:20:56 | Espirito Santo, Brazil | |||
451108 | 451108 | 2022-12-21 | Brazil | Goias | 1805482 | 27707 | 0 | -15.827 | -49.8362 | 2022-12-22 04:20:56 | Goias, Brazil | |||
451109 | 451109 | 2022-12-21 | Brazil | Maranhao | 487088 | 11026 | 0 | -4.9609 | -45.2744 | 2022-12-22 04:20:56 | Maranhao, Brazil | |||
451110 | 451110 | 2022-12-21 | Brazil | Mato Grosso | 852600 | 14999 | 0 | -12.6819 | -56.9211 | 2022-12-22 04:20:56 | Mato Grosso, Brazil | |||
451111 | 451111 | 2022-12-21 | Brazil | Mato Grosso do Sul | 590660 | 10886 | 0 | -20.7722 | -54.7852 | 2022-12-22 04:20:56 | Mato Grosso do Sul, Brazil | |||
451112 | 451112 | 2022-12-21 | Brazil | Minas Gerais | 4019396 | 64238 | 0 | -18.5122 | -44.555 | 2022-12-22 04:20:56 | Minas Gerais, Brazil | |||
451113 | 451113 | 2022-12-21 | Brazil | Para | 859705 | 18943 | 0 | -1.9981 | -54.9306 | 2022-12-22 04:20:56 | Para, Brazil | |||
451114 | 451114 | 2022-12-21 | Brazil | Paraiba | 695250 | 10503 | 0 | -7.24 | -36.782 | 2022-12-22 04:20:56 | Paraiba, Brazil | |||
451115 | 451115 | 2022-12-21 | Brazil | Parana | 2838612 | 45655 | 0 | -25.2521 | -52.0215 | 2022-12-22 04:20:56 | Parana, Brazil | |||
451116 | 451116 | 2022-12-21 | Brazil | Pernambuco | 1113073 | 22548 | 0 | -8.8137 | -36.9541 | 2022-12-22 04:20:56 | Pernambuco, Brazil | |||
451117 | 451117 | 2022-12-21 | Brazil | Piaui | 411408 | 8006 | 0 | -7.7183 | -42.7289 | 2022-12-22 04:20:56 | Piaui, Brazil | |||
451118 | 451118 | 2022-12-21 | Brazil | Rio Grande do Norte | 580279 | 8605 | 0 | -5.4026 | -36.9541 | 2022-12-22 04:20:56 | Rio Grande do Norte, Brazil | |||
451119 | 451119 | 2022-12-21 | Brazil | Rio Grande do Sul | 2850186 | 41405 | 0 | -30.0346 | -51.2177 | 2022-12-22 04:20:56 | Rio Grande do Sul, Brazil | |||
451120 | 451120 | 2022-12-21 | Brazil | Rio de Janeiro | 2686177 | 76329 | 0 | -22.9068 | -43.1729 | 2022-12-22 04:20:56 | Rio de Janeiro, Brazil | |||
451121 | 451121 | 2022-12-21 | Brazil | Rondonia | 466607 | 7388 | 0 | -11.5057 | -63.5806 | 2022-12-22 04:20:56 | Rondonia, Brazil | |||
451122 | 451122 | 2022-12-21 | Brazil | Roraima | 180976 | 2178 | 0 | -2.7376 | -62.0751 | 2022-12-22 04:20:56 | Roraima, Brazil | |||
451123 | 451123 | 2022-12-21 | Brazil | Santa Catarina | 1944278 | 22548 | 0 | -27.2423 | -50.2189 | 2022-12-22 04:20:56 | Santa Catarina, Brazil | |||
451124 | 451124 | 2022-12-21 | Brazil | Sao Paulo | 6276621 | 177071 | 0 | -23.5505 | -46.6333 | 2022-12-22 04:20:56 | Sao Paulo, Brazil | |||
451125 | 451125 | 2022-12-21 | Brazil | Sergipe | 356830 | 6481 | 0 | -10.5741 | -37.3857 | 2022-12-22 04:20:56 | Sergipe, Brazil | |||
451126 | 451126 | 2022-12-21 | Brazil | Tocantins | 357040 | 4208 | 0 | -10.1753 | -48.2982 | 2022-12-22 04:20:56 | Tocantins, Brazil | |||
451127 | 451127 | 2022-12-21 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-22 04:20:56 | Brunei | ||||
451128 | 451128 | 2022-12-21 | Bulgaria | 1290820 | 38084 | 0 | 42.7339 | 25.4858 | 2022-12-22 04:20:56 | Bulgaria | ||||
451129 | 451129 | 2022-12-21 | Burkina Faso | 22006 | 395 | 0 | 12.2383 | -1.5616 | 2022-12-22 04:20:56 | Burkina Faso | ||||
451130 | 451130 | 2022-12-21 | Burma | 633585 | 19489 | 0 | 21.9162 | 95.956 | 2022-12-22 04:20:56 | Burma | ||||
451131 | 451131 | 2022-12-21 | Burundi | 51722 | 38 | 0 | -3.3731 | 29.9189 | 2022-12-22 04:20:56 | Burundi | ||||
451132 | 451132 | 2022-12-21 | Cabo Verde | 63181 | 412 | 0 | 16.5388 | -23.0418 | 2022-12-22 04:20:56 | Cabo Verde | ||||
451133 | 451133 | 2022-12-21 | Cambodia | 138457 | 3056 | 0 | 11.55 | 104.9167 | 2022-12-22 04:20:56 | Cambodia | ||||
451134 | 451134 | 2022-12-21 | Cameroon | 123993 | 1965 | 0 | 3.848 | 11.5021 | 2022-12-22 04:20:56 | Cameroon | ||||
451135 | 451135 | 2022-12-21 | Canada | Alberta | 622428 | 5351 | 0 | 53.9333 | -116.5765 | 2022-12-22 04:20:56 | Alberta, Canada | |||
451136 | 451136 | 2022-12-21 | Canada | British Columbia | 391285 | 4760 | 0 | 53.7267 | -127.6476 | 2022-12-22 04:20:56 | British Columbia, Canada | |||
451137 | 451137 | 2022-12-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
451138 | 451138 | 2022-12-21 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
451139 | 451139 | 2022-12-21 | Canada | Manitoba | 153349 | 2305 | 0 | 53.7609 | -98.8139 | 2022-12-22 04:20:56 | Manitoba, Canada | |||
451140 | 451140 | 2022-12-21 | Canada | New Brunswick | 84244 | 628 | 0 | 46.5653 | -66.4619 | 2022-12-22 04:20:56 | New Brunswick, Canada | |||
451141 | 451141 | 2022-12-21 | Canada | Newfoundland and Labrador | 53785 | 282 | 0 | 53.1355 | -57.6604 | 2022-12-22 04:20:56 | Newfoundland and Labrador, Canada | |||
451142 | 451142 | 2022-12-21 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-12-22 04:20:56 | Northwest Territories,Canada | |||
451143 | 451143 | 2022-12-21 | Canada | Nova Scotia | 133919 | 672 | 0 | 44.682 | -63.7443 | 2022-12-22 04:20:56 | Nova Scotia, Canada | |||
451144 | 451144 | 2022-12-21 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-12-22 04:20:56 | Nunavut, Canada | |||
451145 | 451145 | 2022-12-21 | Canada | Ontario | 1544643 | 15440 | 0 | 51.2538 | -85.3232 | 2022-12-22 04:20:56 | Ontario, Canada | |||
451146 | 451146 | 2022-12-21 | Canada | Prince Edward Island | 55319 | 82 | 0 | 46.5107 | -63.4168 | 2022-12-22 04:20:56 | Prince Edward Island, Canada | |||
451147 | 451147 | 2022-12-21 | Canada | Quebec | 1275579 | 17586 | 0 | 52.9399 | -73.5491 | 2022-12-22 04:20:56 | Quebec, Canada | |||
451148 | 451148 | 2022-12-21 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-12-22 04:20:56 | Repatriated Travellers, Canada | |||||
451149 | 451149 | 2022-12-21 | Canada | Saskatchewan | 150003 | 1750 | 0 | 52.9399 | -106.4509 | 2022-12-22 04:20:56 | Saskatchewan, Canada | |||
451150 | 451150 | 2022-12-21 | Canada | Yukon | 4989 | 32 | 0 | 64.2823 | -135.0 | 2022-12-22 04:20:56 | Yukon, Canada | |||
451151 | 451151 | 2022-12-21 | Central African Republic | 15311 | 113 | 0 | 6.6111 | 20.9394 | 2022-12-22 04:20:56 | Central African Republic | ||||
451152 | 451152 | 2022-12-21 | Chad | 7649 | 194 | 0 | 15.4542 | 18.7322 | 2022-12-22 04:20:56 | Chad | ||||
451153 | 451153 | 2022-12-21 | Chile | Antofagasta | 176454 | 1919 | 0 | -23.6509 | -70.3975 | 2022-12-22 04:20:56 | Antofagasta, Chile | |||
451154 | 451154 | 2022-12-21 | Chile | Araucania | 284663 | 2830 | 0 | -38.9489 | -72.3311 | 2022-12-22 04:20:56 | Araucania, Chile | |||
451155 | 451155 | 2022-12-21 | Chile | Arica y Parinacota | 76825 | 875 | 0 | -18.594 | -69.4785 | 2022-12-22 04:20:56 | Arica y Parinacota, Chile | |||
451156 | 451156 | 2022-12-21 | Chile | Atacama | 110173 | 693 | 0 | -27.5661 | -70.0503 | 2022-12-22 04:20:56 | Atacama, Chile | |||
451157 | 451157 | 2022-12-21 | Chile | Aysen | 34711 | 211 | 0 | -45.9864 | -73.7669 | 2022-12-22 04:20:56 | Aysen, Chile | |||
451158 | 451158 | 2022-12-21 | Chile | Biobio | 491266 | 4701 | 0 | -37.4464 | -72.1416 | 2022-12-22 04:20:56 | Biobio, Chile | |||
451159 | 451159 | 2022-12-21 | Chile | Coquimbo | 201411 | 1897 | 0 | -29.959 | -71.3389 | 2022-12-22 04:20:56 | Coquimbo, Chile | |||
451160 | 451160 | 2022-12-21 | Chile | Los Lagos | 236698 | 2499 | 0 | -41.9198 | -72.1416 | 2022-12-22 04:20:56 | Los Lagos, Chile | |||
451161 | 451161 | 2022-12-21 | Chile | Los Rios | 142499 | 1366 | 0 | -40.231 | -72.3311 | 2022-12-22 04:20:56 | Los Rios, Chile | |||
451162 | 451162 | 2022-12-21 | Chile | Magallanes | 65925 | 764 | 0 | -52.368 | -70.9863 | 2022-12-22 04:20:56 | Magallanes, Chile | |||
451163 | 451163 | 2022-12-21 | Chile | Maule | 335497 | 3259 | 0 | -35.5183 | -71.6885 | 2022-12-22 04:20:56 | Maule, Chile | |||
451164 | 451164 | 2022-12-21 | Chile | Metropolitana | 1891190 | 30383 | 0 | -33.4376 | -70.6505 | 2022-12-22 04:20:56 | Metropolitana, Chile | |||
451165 | 451165 | 2022-12-21 | Chile | Nuble | 151488 | 1272 | 0 | -36.7226 | -71.7622 | 2022-12-22 04:20:56 | Nuble, Chile | |||
451166 | 451166 | 2022-12-21 | Chile | OHiggins | 213350 | 2774 | 0 | -34.5755 | -71.0022 | 2022-12-22 04:20:56 | OHiggins, Chile | |||
451167 | 451167 | 2022-12-21 | Chile | Tarapaca | 108812 | 1155 | 0 | -19.9232 | -69.5132 | 2022-12-22 04:20:56 | Tarapaca, Chile | |||
451168 | 451168 | 2022-12-21 | Chile | Unknown | 42 | 2 | 0 | 2022-12-22 04:20:56 | Unknown, Chile | |||||
451169 | 451169 | 2022-12-21 | Chile | Valparaiso | 471121 | 6313 | 0 | -33.0472 | -71.6127 | 2022-12-22 04:20:56 | Valparaiso, Chile | |||
451170 | 451170 | 2022-12-21 | China | Anhui | 1700 | 6 | 0 | 31.8257 | 117.2264 | 2022-12-22 04:20:56 | Anhui, China | |||
451171 | 451171 | 2022-12-21 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-22 04:20:56 | Beijing, China | |||
451172 | 451172 | 2022-12-21 | China | Chongqing | 10181 | 7 | 0 | 30.0572 | 107.874 | 2022-12-22 04:20:56 | Chongqing, China | |||
451173 | 451173 | 2022-12-21 | China | Fujian | 7651 | 1 | 0 | 26.0789 | 117.9874 | 2022-12-22 04:20:56 | Fujian, China | |||
451174 | 451174 | 2022-12-21 | China | Gansu | 1563 | 2 | 0 | 35.7518 | 104.2861 | 2022-12-22 04:20:56 | Gansu, China | |||
451175 | 451175 | 2022-12-21 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-22 04:20:56 | Guangdong, China | |||
451176 | 451176 | 2022-12-21 | China | Guangxi | 2457 | 2 | 0 | 23.8298 | 108.7881 | 2022-12-22 04:20:56 | Guangxi, China | |||
451177 | 451177 | 2022-12-21 | China | Guizhou | 1794 | 2 | 0 | 26.8154 | 106.8748 | 2022-12-22 04:20:56 | Guizhou, China | |||
451178 | 451178 | 2022-12-21 | China | Hainan | 10436 | 6 | 0 | 19.1959 | 109.7453 | 2022-12-22 04:20:56 | Hainan, China | |||
451179 | 451179 | 2022-12-21 | China | Hebei | 2943 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-22 04:20:56 | Hebei, China | |||
451180 | 451180 | 2022-12-21 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-22 04:20:56 | Heilongjiang, China | |||
451181 | 451181 | 2022-12-21 | China | Henan | 9089 | 23 | 0 | 33.882 | 113.614 | 2022-12-22 04:20:56 | Henan, China | |||
451182 | 451182 | 2022-12-21 | China | Hong Kong | 2402238 | 11334 | 0 | 22.3 | 114.2 | 2022-12-22 04:20:56 | Hong Kong, China | |||
451183 | 451183 | 2022-12-21 | China | Hubei | 68861 | 4512 | 0 | 30.9756 | 112.2707 | 2022-12-22 04:20:56 | Hubei, China | |||
451184 | 451184 | 2022-12-21 | China | Hunan | 2983 | 4 | 0 | 27.6104 | 111.7088 | 2022-12-22 04:20:56 | Hunan, China | |||
451185 | 451185 | 2022-12-21 | China | Inner Mongolia | 8394 | 1 | 0 | 44.0935 | 113.9448 | 2022-12-22 04:20:56 | Inner Mongolia, China |
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]);