johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,016 rows where day = "2022-07-29" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update, day (date), last_update (date)
province_or_state >30
- Texas 255
- Georgia 161
- Virginia 134
- Kentucky 121
- Missouri 117
- Kansas 107
- Illinois 104
- North Carolina 101
- Iowa 100
- Tennessee 97
- Nebraska 94
- Indiana 93
- Ohio 89
- Minnesota 88
- Michigan 87
- Mississippi 83
- Puerto Rico 80
- Oklahoma 79
- Arkansas 76
- Wisconsin 73
- Alabama 69
- Florida 68
- Pennsylvania 68
- South Dakota 67
- Colorado 66
- Louisiana 66
- New York 64
- California 60
- Montana 57
- West Virginia 56
- …
country_or_region >30
- US 3,279
- Russia 83
- Japan 49
- India 37
- China 34
- Colombia 34
- Mexico 33
- Ukraine 28
- Brazil 27
- Peru 26
- Italy 21
- Sweden 21
- Spain 20
- United Kingdom 19
- Chile 17
- Germany 17
- Malaysia 17
- Netherlands 17
- Canada 16
- Belgium 12
- France 12
- Australia 8
- Pakistan 7
- Denmark 3
- New Zealand 3
- Afghanistan 1
- Albania 1
- Algeria 1
- Andorra 1
- Angola 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1783185 | 1783185 | 2022-07-29 | Afghanistan | 185481 | 7743 | 0 | 33.93911 | 67.709953 | 2022-07-30 04:20:42 | Afghanistan | ||||
1783186 | 1783186 | 2022-07-29 | Albania | 310362 | 3541 | 0 | 41.1533 | 20.1683 | 2022-07-30 04:20:42 | Albania | ||||
1783187 | 1783187 | 2022-07-29 | Algeria | 267287 | 6876 | 0 | 28.0339 | 1.6596 | 2022-07-30 04:20:42 | Algeria | ||||
1783188 | 1783188 | 2022-07-29 | Andorra | 45508 | 153 | 0 | 42.5063 | 1.5218 | 2022-07-30 04:20:42 | Andorra | ||||
1783189 | 1783189 | 2022-07-29 | Angola | 102301 | 1912 | 0 | -11.2027 | 17.8739 | 2022-07-30 04:20:42 | Angola | ||||
1783190 | 1783190 | 2022-07-29 | Antarctica | 11 | 0 | 0 | -71.9499 | 23.347 | 2022-07-30 04:20:42 | Antarctica | ||||
1783191 | 1783191 | 2022-07-29 | Antigua and Barbuda | 8741 | 144 | 0 | 17.0608 | -61.7964 | 2022-07-30 04:20:42 | Antigua and Barbuda | ||||
1783192 | 1783192 | 2022-07-29 | Argentina | 9507562 | 129278 | 0 | -38.4161 | -63.6167 | 2022-07-30 04:20:42 | Argentina | ||||
1783193 | 1783193 | 2022-07-29 | Armenia | 425365 | 8633 | 0 | 40.0691 | 45.0382 | 2022-07-30 04:20:42 | Armenia | ||||
1783194 | 1783194 | 2022-07-29 | Australia | Australian Capital Territory | 190917 | 92 | 0 | -35.4735 | 149.0124 | 2022-07-30 04:20:42 | Australian Capital Territory, Australia | |||
1783195 | 1783195 | 2022-07-29 | Australia | New South Wales | 3176133 | 4153 | 0 | -33.8688 | 151.2093 | 2022-07-30 04:20:42 | New South Wales, Australia | |||
1783196 | 1783196 | 2022-07-29 | Australia | Northern Territory | 90761 | 55 | 0 | -12.4634 | 130.8456 | 2022-07-30 04:20:42 | Northern Territory, Australia | |||
1783197 | 1783197 | 2022-07-29 | Australia | Queensland | 1506868 | 1567 | 0 | -27.4698 | 153.0251 | 2022-07-30 04:20:42 | Queensland, Australia | |||
1783198 | 1783198 | 2022-07-29 | Australia | South Australia | 706353 | 665 | 0 | -34.9285 | 138.6007 | 2022-07-30 04:20:42 | South Australia, Australia | |||
1783199 | 1783199 | 2022-07-29 | Australia | Tasmania | 229712 | 137 | 0 | -42.8821 | 147.3272 | 2022-07-30 04:20:42 | Tasmania, Australia | |||
1783200 | 1783200 | 2022-07-29 | Australia | Victoria | 2413948 | 4638 | 0 | -37.8136 | 144.9631 | 2022-07-30 04:20:42 | Victoria, Australia | |||
1783201 | 1783201 | 2022-07-29 | Australia | Western Australia | 1061791 | 497 | 0 | -31.9505 | 115.8605 | 2022-07-30 04:20:42 | Western Australia, Australia | |||
1783202 | 1783202 | 2022-07-29 | Austria | 4774043 | 20317 | 0 | 47.5162 | 14.5501 | 2022-07-30 04:20:42 | Austria | ||||
1783203 | 1783203 | 2022-07-29 | Azerbaijan | 798011 | 9746 | 0 | 40.1431 | 47.5769 | 2022-07-30 04:20:42 | Azerbaijan | ||||
1783204 | 1783204 | 2022-07-29 | Bahamas | 36670 | 822 | 0 | 25.025885 | -78.035889 | 2022-07-30 04:20:42 | Bahamas | ||||
1783205 | 1783205 | 2022-07-29 | Bahrain | 658727 | 1509 | 0 | 26.0275 | 50.55 | 2022-07-30 04:20:42 | Bahrain | ||||
1783206 | 1783206 | 2022-07-29 | Bangladesh | 2004543 | 29285 | 0 | 23.685 | 90.3563 | 2022-07-30 04:20:42 | Bangladesh | ||||
1783207 | 1783207 | 2022-07-29 | Barbados | 91593 | 492 | 0 | 13.1939 | -59.5432 | 2022-07-30 04:20:42 | Barbados | ||||
1783208 | 1783208 | 2022-07-29 | Belarus | 994037 | 7118 | 0 | 53.7098 | 27.9534 | 2022-07-30 04:20:42 | Belarus | ||||
1783209 | 1783209 | 2022-07-29 | Belgium | Antwerp | 709317 | 0 | 0 | 51.2195 | 4.4024 | 2022-07-30 04:20:42 | Antwerp, Belgium | |||
1783210 | 1783210 | 2022-07-29 | Belgium | Brussels | 479945 | 0 | 0 | 50.8503 | 4.3517 | 2022-07-30 04:20:42 | Brussels, Belgium | |||
1783211 | 1783211 | 2022-07-29 | Belgium | East Flanders | 596596 | 0 | 0 | 51.0362 | 3.7373 | 2022-07-30 04:20:42 | East Flanders, Belgium | |||
1783212 | 1783212 | 2022-07-29 | Belgium | Flemish Brabant | 431226 | 0 | 0 | 50.9167 | 4.5833 | 2022-07-30 04:20:42 | Flemish Brabant, Belgium | |||
1783213 | 1783213 | 2022-07-29 | Belgium | Hainaut | 485467 | 0 | 0 | 50.5257 | 4.0621 | 2022-07-30 04:20:42 | Hainaut, Belgium | |||
1783214 | 1783214 | 2022-07-29 | Belgium | Liege | 395045 | 0 | 0 | 50.4496 | 5.8492 | 2022-07-30 04:20:42 | Liege, Belgium | |||
1783215 | 1783215 | 2022-07-29 | Belgium | Limburg | 325138 | 0 | 0 | 50.9739 | 5.342 | 2022-07-30 04:20:42 | Limburg, Belgium | |||
1783216 | 1783216 | 2022-07-29 | Belgium | Luxembourg | 113955 | 0 | 0 | 50.0547 | 5.4677 | 2022-07-30 04:20:42 | Luxembourg, Belgium | |||
1783217 | 1783217 | 2022-07-29 | Belgium | Namur | 188498 | 0 | 0 | 50.331 | 4.8221 | 2022-07-30 04:20:42 | Namur, Belgium | |||
1783218 | 1783218 | 2022-07-29 | Belgium | Unknown | 59864 | 32228 | 0 | 2022-07-30 04:20:42 | Unknown, Belgium | |||||
1783219 | 1783219 | 2022-07-29 | Belgium | Walloon Brabant | 162181 | 0 | 0 | 50.4 | 4.35 | 2022-07-30 04:20:42 | Walloon Brabant, Belgium | |||
1783220 | 1783220 | 2022-07-29 | Belgium | West Flanders | 467023 | 0 | 0 | 51.0536 | 3.1458 | 2022-07-30 04:20:42 | West Flanders, Belgium | |||
1783221 | 1783221 | 2022-07-29 | Belize | 67111 | 680 | 0 | 17.1899 | -88.4976 | 2022-07-30 04:20:42 | Belize | ||||
1783222 | 1783222 | 2022-07-29 | Benin | 27316 | 163 | 0 | 9.3077 | 2.3158 | 2022-07-30 04:20:42 | Benin | ||||
1783223 | 1783223 | 2022-07-29 | Bhutan | 60368 | 21 | 0 | 27.5142 | 90.4336 | 2022-07-30 04:20:42 | Bhutan | ||||
1783224 | 1783224 | 2022-07-29 | Bolivia | 1032023 | 22053 | 0 | -16.2902 | -63.5887 | 2022-07-30 04:20:42 | Bolivia | ||||
1783225 | 1783225 | 2022-07-29 | Bosnia and Herzegovina | 384976 | 15853 | 0 | 43.9159 | 17.6791 | 2022-07-30 04:20:42 | Bosnia and Herzegovina | ||||
1783226 | 1783226 | 2022-07-29 | Botswana | 325470 | 2770 | 0 | -22.3285 | 24.6849 | 2022-07-30 04:20:42 | Botswana | ||||
1783227 | 1783227 | 2022-07-29 | Brazil | Acre | 143181 | 2018 | 0 | -9.0238 | -70.812 | 2022-07-30 04:20:42 | Acre, Brazil | |||
1783228 | 1783228 | 2022-07-29 | Brazil | Alagoas | 317703 | 7068 | 0 | -9.5713 | -36.782 | 2022-07-30 04:20:42 | Alagoas, Brazil | |||
1783229 | 1783229 | 2022-07-29 | Brazil | Amapa | 176224 | 2149 | 0 | 0.902 | -52.003 | 2022-07-30 04:20:42 | Amapa, Brazil | |||
1783230 | 1783230 | 2022-07-29 | Brazil | Amazonas | 605151 | 14223 | 0 | -3.4168 | -65.8561 | 2022-07-30 04:20:42 | Amazonas, Brazil | |||
1783231 | 1783231 | 2022-07-29 | Brazil | Bahia | 1658889 | 30349 | 0 | -12.5797 | -41.7007 | 2022-07-30 04:20:42 | Bahia, Brazil | |||
1783232 | 1783232 | 2022-07-29 | Brazil | Ceara | 1360208 | 27415 | 0 | -5.4984 | -39.3206 | 2022-07-30 04:20:42 | Ceara, Brazil | |||
1783233 | 1783233 | 2022-07-29 | Brazil | Distrito Federal | 830565 | 11819 | 0 | -15.7998 | -47.8645 | 2022-07-30 04:20:42 | Distrito Federal, Brazil | |||
1783234 | 1783234 | 2022-07-29 | Brazil | Espirito Santo | 1202265 | 14694 | 0 | -19.1834 | -40.3089 | 2022-07-30 04:20:42 | Espirito Santo, Brazil | |||
1783235 | 1783235 | 2022-07-29 | Brazil | Goias | 1609177 | 27181 | 0 | -15.827 | -49.8362 | 2022-07-30 04:20:42 | Goias, Brazil | |||
1783236 | 1783236 | 2022-07-29 | Brazil | Maranhao | 460025 | 10939 | 0 | -4.9609 | -45.2744 | 2022-07-30 04:20:42 | Maranhao, Brazil | |||
1783237 | 1783237 | 2022-07-29 | Brazil | Mato Grosso | 811571 | 14863 | 0 | -12.6819 | -56.9211 | 2022-07-30 04:20:42 | Mato Grosso, Brazil | |||
1783238 | 1783238 | 2022-07-29 | Brazil | Mato Grosso do Sul | 564192 | 10707 | 0 | -20.7722 | -54.7852 | 2022-07-30 04:20:42 | Mato Grosso do Sul, Brazil | |||
1783239 | 1783239 | 2022-07-29 | Brazil | Minas Gerais | 3814127 | 62902 | 0 | -18.5122 | -44.555 | 2022-07-30 04:20:42 | Minas Gerais, Brazil | |||
1783240 | 1783240 | 2022-07-29 | Brazil | Para | 809892 | 18537 | 0 | -1.9981 | -54.9306 | 2022-07-30 04:20:42 | Para, Brazil | |||
1783241 | 1783241 | 2022-07-29 | Brazil | Paraiba | 644904 | 10352 | 0 | -7.24 | -36.782 | 2022-07-30 04:20:42 | Paraiba, Brazil | |||
1783242 | 1783242 | 2022-07-29 | Brazil | Parana | 2690893 | 44438 | 0 | -25.2521 | -52.0215 | 2022-07-30 04:20:42 | Parana, Brazil | |||
1783243 | 1783243 | 2022-07-29 | Brazil | Pernambuco | 1028058 | 22037 | 0 | -8.8137 | -36.9541 | 2022-07-30 04:20:42 | Pernambuco, Brazil | |||
1783244 | 1783244 | 2022-07-29 | Brazil | Piaui | 386237 | 7877 | 0 | -7.7183 | -42.7289 | 2022-07-30 04:20:42 | Piaui, Brazil | |||
1783245 | 1783245 | 2022-07-29 | Brazil | Rio Grande do Norte | 546402 | 8380 | 0 | -5.4026 | -36.9541 | 2022-07-30 04:20:42 | Rio Grande do Norte, Brazil | |||
1783246 | 1783246 | 2022-07-29 | Brazil | Rio Grande do Sul | 2640779 | 40444 | 0 | -30.0346 | -51.2177 | 2022-07-30 04:20:42 | Rio Grande do Sul, Brazil | |||
1783247 | 1783247 | 2022-07-29 | Brazil | Rio de Janeiro | 2445094 | 74766 | 0 | -22.9068 | -43.1729 | 2022-07-30 04:20:42 | Rio de Janeiro, Brazil | |||
1783248 | 1783248 | 2022-07-29 | Brazil | Rondonia | 443613 | 7299 | 0 | -11.5057 | -63.5806 | 2022-07-30 04:20:42 | Rondonia, Brazil | |||
1783249 | 1783249 | 2022-07-29 | Brazil | Roraima | 172615 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-30 04:20:42 | Roraima, Brazil | |||
1783250 | 1783250 | 2022-07-29 | Brazil | Santa Catarina | 1837652 | 22215 | 0 | -27.2423 | -50.2189 | 2022-07-30 04:20:42 | Santa Catarina, Brazil | |||
1783251 | 1783251 | 2022-07-29 | Brazil | Sao Paulo | 5911552 | 172887 | 0 | -23.5505 | -46.6333 | 2022-07-30 04:20:42 | Sao Paulo, Brazil | |||
1783252 | 1783252 | 2022-07-29 | Brazil | Sergipe | 340814 | 6412 | 0 | -10.5741 | -37.3857 | 2022-07-30 04:20:42 | Sergipe, Brazil | |||
1783253 | 1783253 | 2022-07-29 | Brazil | Tocantins | 338915 | 4184 | 0 | -10.1753 | -48.2982 | 2022-07-30 04:20:42 | Tocantins, Brazil | |||
1783254 | 1783254 | 2022-07-29 | Brunei | 205890 | 225 | 0 | 4.5353 | 114.7277 | 2022-07-30 04:20:42 | Brunei | ||||
1783255 | 1783255 | 2022-07-29 | Bulgaria | 1205966 | 37372 | 0 | 42.7339 | 25.4858 | 2022-07-30 04:20:42 | Bulgaria | ||||
1783256 | 1783256 | 2022-07-29 | Burkina Faso | 21128 | 387 | 0 | 12.2383 | -1.5616 | 2022-07-30 04:20:42 | Burkina Faso | ||||
1783257 | 1783257 | 2022-07-29 | Burma | 614043 | 19434 | 0 | 21.9162 | 95.956 | 2022-07-30 04:20:42 | Burma | ||||
1783258 | 1783258 | 2022-07-29 | Burundi | 45308 | 38 | 0 | -3.3731 | 29.9189 | 2022-07-30 04:20:42 | Burundi | ||||
1783259 | 1783259 | 2022-07-29 | Cabo Verde | 62138 | 410 | 0 | 16.5388 | -23.0418 | 2022-07-30 04:20:42 | Cabo Verde | ||||
1783260 | 1783260 | 2022-07-29 | Cambodia | 136706 | 3056 | 0 | 11.55 | 104.9167 | 2022-07-30 04:20:42 | Cambodia | ||||
1783261 | 1783261 | 2022-07-29 | Cameroon | 120215 | 1931 | 0 | 3.848 | 11.5021 | 2022-07-30 04:20:42 | Cameroon | ||||
1783262 | 1783262 | 2022-07-29 | Canada | Alberta | 594474 | 4665 | 0 | 53.9333 | -116.5765 | 2022-07-30 04:20:42 | Alberta, Canada | |||
1783263 | 1783263 | 2022-07-29 | Canada | British Columbia | 378291 | 3908 | 0 | 53.7267 | -127.6476 | 2022-07-30 04:20:42 | British Columbia, Canada | |||
1783264 | 1783264 | 2022-07-29 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
1783265 | 1783265 | 2022-07-29 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
1783266 | 1783266 | 2022-07-29 | Canada | Manitoba | 146266 | 2061 | 0 | 53.7609 | -98.8139 | 2022-07-30 04:20:42 | Manitoba, Canada | |||
1783267 | 1783267 | 2022-07-29 | Canada | New Brunswick | 71479 | 443 | 0 | 46.5653 | -66.4619 | 2022-07-30 04:20:42 | New Brunswick, Canada | |||
1783268 | 1783268 | 2022-07-29 | Canada | Newfoundland and Labrador | 49412 | 203 | 0 | 53.1355 | -57.6604 | 2022-07-30 04:20:42 | Newfoundland and Labrador, Canada | |||
1783269 | 1783269 | 2022-07-29 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-07-30 04:20:42 | Northwest Territories,Canada | |||
1783270 | 1783270 | 2022-07-29 | Canada | Nova Scotia | 113669 | 467 | 0 | 44.682 | -63.7443 | 2022-07-30 04:20:42 | Nova Scotia, Canada | |||
1783271 | 1783271 | 2022-07-29 | Canada | Nunavut | 3531 | 7 | 0 | 70.2998 | -83.1076 | 2022-07-30 04:20:42 | Nunavut, Canada | |||
1783272 | 1783272 | 2022-07-29 | Canada | Ontario | 1385022 | 13702 | 0 | 51.2538 | -85.3232 | 2022-07-30 04:20:42 | Ontario, Canada | |||
1783273 | 1783273 | 2022-07-29 | Canada | Prince Edward Island | 46240 | 49 | 0 | 46.5107 | -63.4168 | 2022-07-30 04:20:42 | Prince Edward Island, Canada | |||
1783274 | 1783274 | 2022-07-29 | Canada | Quebec | 1145558 | 15945 | 0 | 52.9399 | -73.5491 | 2022-07-30 04:20:42 | Quebec, Canada | |||
1783275 | 1783275 | 2022-07-29 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2022-07-30 04:20:42 | Repatriated Travellers, Canada | |||||
1783276 | 1783276 | 2022-07-29 | Canada | Saskatchewan | 140291 | 1438 | 0 | 52.9399 | -106.4509 | 2022-07-30 04:20:42 | Saskatchewan, Canada | |||
1783277 | 1783277 | 2022-07-29 | Canada | Yukon | 4672 | 26 | 0 | 64.2823 | -135.0 | 2022-07-30 04:20:42 | Yukon, Canada | |||
1783278 | 1783278 | 2022-07-29 | Central African Republic | 14764 | 113 | 0 | 6.6111 | 20.9394 | 2022-07-30 04:20:42 | Central African Republic | ||||
1783279 | 1783279 | 2022-07-29 | Chad | 7432 | 193 | 0 | 15.4542 | 18.7322 | 2022-07-30 04:20:42 | Chad | ||||
1783280 | 1783280 | 2022-07-29 | Chile | Antofagasta | 149103 | 1816 | 0 | -23.6509 | -70.3975 | 2022-07-30 04:20:42 | Antofagasta, Chile | |||
1783281 | 1783281 | 2022-07-29 | Chile | Araucania | 238768 | 2628 | 0 | -38.9489 | -72.3311 | 2022-07-30 04:20:42 | Araucania, Chile | |||
1783282 | 1783282 | 2022-07-29 | Chile | Arica y Parinacota | 65015 | 825 | 0 | -18.594 | -69.4785 | 2022-07-30 04:20:42 | Arica y Parinacota, Chile | |||
1783283 | 1783283 | 2022-07-29 | Chile | Atacama | 89179 | 637 | 0 | -27.5661 | -70.0503 | 2022-07-30 04:20:42 | Atacama, Chile | |||
1783284 | 1783284 | 2022-07-29 | Chile | Aysen | 28427 | 188 | 0 | -45.9864 | -73.7669 | 2022-07-30 04:20:42 | Aysen, Chile |
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]);