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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
923371 | 923371 | 2020-11-26 | Afghanistan | 45490 | 1725 | 36232 | 7533 | 33.93911 | 67.709953 | 2020-11-27 05:26:53 | Afghanistan | |||
923372 | 923372 | 2020-11-26 | Albania | 35600 | 753 | 17352 | 17495 | 41.1533 | 20.1683 | 2020-11-27 05:26:53 | Albania | |||
923373 | 923373 | 2020-11-26 | Algeria | 79110 | 2352 | 51334 | 25424 | 28.0339 | 1.6596 | 2020-11-27 05:26:53 | Algeria | |||
923374 | 923374 | 2020-11-26 | Andorra | 6534 | 76 | 5649 | 809 | 42.5063 | 1.5218 | 2020-11-27 05:26:53 | Andorra | |||
923375 | 923375 | 2020-11-26 | Angola | 14920 | 341 | 7617 | 6962 | -11.2027 | 17.8739 | 2020-11-27 05:26:53 | Angola | |||
923376 | 923376 | 2020-11-26 | Antigua and Barbuda | 141 | 4 | 130 | 7 | 17.0608 | -61.7964 | 2020-11-27 05:26:53 | Antigua and Barbuda | |||
923377 | 923377 | 2020-11-26 | Argentina | 1399431 | 37941 | 1226662 | 134828 | -38.4161 | -63.6167 | 2020-11-27 05:26:53 | Argentina | |||
923378 | 923378 | 2020-11-26 | Armenia | 130870 | 2068 | 103055 | 25747 | 40.0691 | 45.0382 | 2020-11-27 05:26:53 | Armenia | |||
923379 | 923379 | 2020-11-26 | Australia | Australian Capital Territory | 116 | 3 | 112 | 1 | -35.4735 | 149.0124 | 2020-11-27 05:26:53 | Australian Capital Territory, Australia | ||
923380 | 923380 | 2020-11-26 | Australia | New South Wales | 4556 | 53 | 0 | 4503 | -33.8688 | 151.2093 | 2020-11-27 05:26:53 | New South Wales, Australia | ||
923381 | 923381 | 2020-11-26 | Australia | Northern Territory | 52 | 0 | 46 | 6 | -12.4634 | 130.8456 | 2020-11-27 05:26:53 | Northern Territory, Australia | ||
923382 | 923382 | 2020-11-26 | Australia | Queensland | 1198 | 6 | 1178 | 14 | -27.4698 | 153.0251 | 2020-11-27 05:26:53 | Queensland, Australia | ||
923383 | 923383 | 2020-11-26 | Australia | South Australia | 559 | 4 | 533 | 22 | -34.9285 | 138.6007 | 2020-11-27 05:26:53 | South Australia, Australia | ||
923384 | 923384 | 2020-11-26 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-11-27 05:26:53 | Tasmania, Australia | ||
923385 | 923385 | 2020-11-26 | Australia | Victoria | 20345 | 819 | 19526 | 0 | -37.8136 | 144.9631 | 2020-11-27 05:26:53 | Victoria, Australia | ||
923386 | 923386 | 2020-11-26 | Australia | Western Australia | 817 | 9 | 778 | 30 | -31.9505 | 115.8605 | 2020-11-27 05:26:53 | Western Australia, Australia | ||
923387 | 923387 | 2020-11-26 | Austria | 260116 | 3575 | 196342 | 66923 | 47.5162 | 14.5501 | 2020-11-27 05:26:53 | Austria | |||
923388 | 923388 | 2020-11-26 | Azerbaijan | 106101 | 1256 | 68572 | 36273 | 40.1431 | 47.5769 | 2020-11-27 05:26:53 | Azerbaijan | |||
923389 | 923389 | 2020-11-26 | Bahamas | 7482 | 163 | 5789 | 1530 | 25.025885 | -78.035889 | 2020-11-27 05:26:53 | Bahamas | |||
923390 | 923390 | 2020-11-26 | Bahrain | 86347 | 341 | 84510 | 1496 | 26.0275 | 50.55 | 2020-11-27 05:26:53 | Bahrain | |||
923391 | 923391 | 2020-11-26 | Bangladesh | 456438 | 6524 | 371453 | 78461 | 23.685 | 90.3563 | 2020-11-27 05:26:53 | Bangladesh | |||
923392 | 923392 | 2020-11-26 | Barbados | 266 | 7 | 246 | 13 | 13.1939 | -59.5432 | 2020-11-27 05:26:53 | Barbados | |||
923393 | 923393 | 2020-11-26 | Belarus | 130012 | 1128 | 108769 | 20115 | 53.7098 | 27.9534 | 2020-11-27 05:26:53 | Belarus | |||
923394 | 923394 | 2020-11-26 | Belgium | Antwerp | 66488 | 0 | 0 | 66488 | 51.2195 | 4.4024 | 2020-11-27 05:26:53 | Antwerp, Belgium | ||
923395 | 923395 | 2020-11-26 | Belgium | Brussels | 75755 | 0 | 0 | 75755 | 50.8503 | 4.3517 | 2020-11-27 05:26:53 | Brussels, Belgium | ||
923396 | 923396 | 2020-11-26 | Belgium | East Flanders | 52849 | 0 | 0 | 52849 | 51.0362 | 3.7373 | 2020-11-27 05:26:53 | East Flanders, Belgium | ||
923397 | 923397 | 2020-11-26 | Belgium | Flemish Brabant | 43337 | 0 | 0 | 43337 | 50.9167 | 4.5833 | 2020-11-27 05:26:53 | Flemish Brabant, Belgium | ||
923398 | 923398 | 2020-11-26 | Belgium | Hainaut | 90813 | 0 | 0 | 90813 | 50.5257 | 4.0621 | 2020-11-27 05:26:53 | Hainaut, Belgium | ||
923399 | 923399 | 2020-11-26 | Belgium | Liege | 90962 | 0 | 0 | 90962 | 50.4496 | 5.8492 | 2020-11-27 05:26:53 | Liege, Belgium | ||
923400 | 923400 | 2020-11-26 | Belgium | Limburg | 23767 | 0 | 0 | 23767 | 50.9739 | 5.3420000000000005 | 2020-11-27 05:26:53 | Limburg, Belgium | ||
923401 | 923401 | 2020-11-26 | Belgium | Luxembourg | 15953 | 0 | 0 | 15953 | 50.0547 | 5.4677 | 2020-11-27 05:26:53 | Luxembourg, Belgium | ||
923402 | 923402 | 2020-11-26 | Belgium | Namur | 31933 | 0 | 0 | 31933 | 50.331 | 4.8221 | 2020-11-27 05:26:53 | Namur, Belgium | ||
923403 | 923403 | 2020-11-26 | Belgium | Unknown | 9375 | 16219 | 0 | 0 | 2020-11-27 05:26:53 | Unknown, Belgium | ||||
923404 | 923404 | 2020-11-26 | Belgium | Walloon Brabant | 22914 | 0 | 0 | 22914 | 50.4 | 4.35 | 2020-11-27 05:26:53 | Walloon Brabant, Belgium | ||
923405 | 923405 | 2020-11-26 | Belgium | West Flanders | 43386 | 0 | 0 | 43386 | 51.0536 | 3.1458 | 2020-11-27 05:26:53 | West Flanders, Belgium | ||
923406 | 923406 | 2020-11-26 | Belize | 5515 | 131 | 3021 | 2363 | 17.1899 | -88.4976 | 2020-11-27 05:26:53 | Belize | |||
923407 | 923407 | 2020-11-26 | Benin | 2974 | 43 | 2579 | 352 | 9.3077 | 2.3158 | 2020-11-27 05:26:53 | Benin | |||
923408 | 923408 | 2020-11-26 | Bhutan | 389 | 0 | 368 | 21 | 27.5142 | 90.4336 | 2020-11-27 05:26:53 | Bhutan | |||
923409 | 923409 | 2020-11-26 | Bolivia | 144390 | 8939 | 120720 | 14731 | -16.2902 | -63.5887 | 2020-11-27 05:26:53 | Bolivia | |||
923410 | 923410 | 2020-11-26 | Bosnia and Herzegovina | 84252 | 2480 | 48780 | 32992 | 43.9159 | 17.6791 | 2020-11-27 05:26:53 | Bosnia and Herzegovina | |||
923411 | 923411 | 2020-11-26 | Botswana | 10258 | 31 | 7717 | 2510 | -22.3285 | 24.6849 | 2020-11-27 05:26:53 | Botswana | |||
923412 | 923412 | 2020-11-26 | Brazil | Acre | 35304 | 722 | 30179 | 4403 | -9.0238 | -70.812 | 2020-11-27 05:26:53 | Acre, Brazil | ||
923413 | 923413 | 2020-11-26 | Brazil | Alagoas | 94060 | 2329 | 90650 | 1081 | -9.5713 | -36.782 | 2020-11-27 05:26:53 | Alagoas, Brazil | ||
923414 | 923414 | 2020-11-26 | Brazil | Amapa | 58043 | 802 | 46549 | 10692 | 0.902 | -52.003 | 2020-11-27 05:26:53 | Amapa, Brazil | ||
923415 | 923415 | 2020-11-26 | Brazil | Amazonas | 176214 | 4856 | 150866 | 20492 | -3.4168 | -65.8561 | 2020-11-27 05:26:53 | Amazonas, Brazil | ||
923416 | 923416 | 2020-11-26 | Brazil | Bahia | 392381 | 8185 | 375458 | 8738 | -12.5797 | -41.7007 | 2020-11-27 05:26:53 | Bahia, Brazil | ||
923417 | 923417 | 2020-11-26 | Brazil | Ceara | 297793 | 9565 | 248685 | 38922 | -5.4984 | -39.3206 | 2020-11-27 05:26:53 | Ceara, Brazil | ||
923418 | 923418 | 2020-11-26 | Brazil | Distrito Federal | 226697 | 3910 | 216780 | 6007 | -15.7998 | -47.8645 | 2020-11-27 05:26:53 | Distrito Federal, Brazil | ||
923419 | 923419 | 2020-11-26 | Brazil | Espirito Santo | 184801 | 4207 | 170664 | 9763 | -19.1834 | -40.3089 | 2020-11-27 05:26:53 | Espirito Santo, Brazil | ||
923420 | 923420 | 2020-11-26 | Brazil | Goias | 276943 | 6305 | 266908 | 3730 | -15.827 | -49.8362 | 2020-11-27 05:26:53 | Goias, Brazil | ||
923421 | 923421 | 2020-11-26 | Brazil | Maranhao | 192501 | 4263 | 185186 | 3052 | -4.9609 | -45.2744 | 2020-11-27 05:26:53 | Maranhao, Brazil | ||
923422 | 923422 | 2020-11-26 | Brazil | Mato Grosso | 157524 | 4116 | 147402 | 5250 | -12.6819 | -56.9211 | 2020-11-27 05:26:53 | Mato Grosso, Brazil | ||
923423 | 923423 | 2020-11-26 | Brazil | Mato Grosso do Sul | 95721 | 1754 | 84587 | 8858 | -20.7722 | -54.7852 | 2020-11-27 05:26:53 | Mato Grosso do Sul, Brazil | ||
923424 | 923424 | 2020-11-26 | Brazil | Minas Gerais | 406880 | 9904 | 373326 | 23650 | -18.5122 | -44.555 | 2020-11-27 05:26:53 | Minas Gerais, Brazil | ||
923425 | 923425 | 2020-11-26 | Brazil | Para | 269057 | 6892 | 251449 | 10191 | -1.9981 | -54.9306 | 2020-11-27 05:26:53 | Para, Brazil | ||
923426 | 923426 | 2020-11-26 | Brazil | Paraiba | 144378 | 3276 | 114202 | 26900 | -7.24 | -36.782 | 2020-11-27 05:26:53 | Paraiba, Brazil | ||
923427 | 923427 | 2020-11-26 | Brazil | Parana | 269258 | 6043 | 193261 | 69954 | -25.2521 | -52.0215 | 2020-11-27 05:26:53 | Parana, Brazil | ||
923428 | 923428 | 2020-11-26 | Brazil | Pernambuco | 178639 | 8987 | 158260 | 11392 | -8.8137 | -36.9541 | 2020-11-27 05:26:53 | Pernambuco, Brazil | ||
923429 | 923429 | 2020-11-26 | Brazil | Piaui | 125155 | 2608 | 122101 | 0 | -7.7183 | -42.7289 | 2020-11-27 05:26:53 | Piaui, Brazil | ||
923430 | 923430 | 2020-11-26 | Brazil | Rio Grande do Norte | 93048 | 2688 | 47431 | 38670 | -5.4026 | -36.9541 | 2020-11-27 05:26:53 | Rio Grande do Norte, Brazil | ||
923431 | 923431 | 2020-11-26 | Brazil | Rio Grande do Sul | 308647 | 6686 | 284992 | 16969 | -30.0346 | -51.2177 | 2020-11-27 05:26:53 | Rio Grande do Sul, Brazil | ||
923432 | 923432 | 2020-11-26 | Brazil | Rio de Janeiro | 346024 | 22394 | 317198 | 6432 | -22.9068 | -43.1729 | 2020-11-27 05:26:53 | Rio de Janeiro, Brazil | ||
923433 | 923433 | 2020-11-26 | Brazil | Rondonia | 78788 | 1535 | 69693 | 7560 | -11.5057 | -63.5806 | 2020-11-27 05:26:53 | Rondonia, Brazil | ||
923434 | 923434 | 2020-11-26 | Brazil | Roraima | 62757 | 724 | 58796 | 3084 | -2.7376 | -62.0751 | 2020-11-27 05:26:53 | Roraima, Brazil | ||
923435 | 923435 | 2020-11-26 | Brazil | Santa Catarina | 343007 | 3608 | 312509 | 26890 | -27.2423 | -50.2189 | 2020-11-27 05:26:53 | Santa Catarina, Brazil | ||
923436 | 923436 | 2020-11-26 | Brazil | Sao Paulo | 1229267 | 41773 | 1084660 | 102834 | -23.5505 | -46.6333 | 2020-11-27 05:26:53 | Sao Paulo, Brazil | ||
923437 | 923437 | 2020-11-26 | Brazil | Sergipe | 88661 | 2292 | 82246 | 4123 | -10.5741 | -37.3857 | 2020-11-27 05:26:53 | Sergipe, Brazil | ||
923438 | 923438 | 2020-11-26 | Brazil | Tocantins | 80717 | 1157 | 72849 | 6446 | -10.1753 | -48.2982 | 2020-11-27 05:26:53 | Tocantins, Brazil | ||
923439 | 923439 | 2020-11-26 | Brunei | 150 | 3 | 145 | 2 | 4.5353 | 114.7277 | 2020-11-27 05:26:53 | Brunei | |||
923440 | 923440 | 2020-11-26 | Bulgaria | 136628 | 3529 | 44875 | 88224 | 42.7339 | 25.4858 | 2020-11-27 05:26:53 | Bulgaria | |||
923441 | 923441 | 2020-11-26 | Burkina Faso | 2777 | 68 | 2567 | 142 | 12.2383 | -1.5616 | 2020-11-27 05:26:53 | Burkina Faso | |||
923442 | 923442 | 2020-11-26 | Burma | 85205 | 1846 | 64645 | 18714 | 21.9162 | 95.956 | 2020-11-27 05:26:53 | Burma | |||
923443 | 923443 | 2020-11-26 | Burundi | 677 | 1 | 575 | 101 | -3.3731 | 29.9189 | 2020-11-27 05:26:53 | Burundi | |||
923444 | 923444 | 2020-11-26 | Cabo Verde | 10570 | 105 | 9956 | 509 | 16.5388 | -23.0418 | 2020-11-27 05:26:53 | Cabo Verde | |||
923445 | 923445 | 2020-11-26 | Cambodia | 307 | 0 | 298 | 9 | 11.55 | 104.9167 | 2020-11-27 05:26:53 | Cambodia | |||
923446 | 923446 | 2020-11-26 | Cameroon | 24022 | 437 | 22177 | 1408 | 3.848 | 11.5021 | 2020-11-27 05:26:53 | Cameroon | |||
923447 | 923447 | 2020-11-26 | Canada | Alberta | 51878 | 510 | 37316 | 14052 | 53.9333 | -116.5765 | 2020-11-27 05:26:53 | Alberta, Canada | ||
923448 | 923448 | 2020-11-26 | Canada | British Columbia | 29973 | 384 | 19998 | 9591 | 53.7267 | -127.6476 | 2020-11-27 05:26:53 | British Columbia, Canada | ||
923449 | 923449 | 2020-11-26 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-11-27 05:26:53 | Diamond Princess, Canada | ||
923450 | 923450 | 2020-11-26 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-27 05:26:53 | Grand Princess, Canada | ||
923451 | 923451 | 2020-11-26 | Canada | Manitoba | 15288 | 266 | 6177 | 8845 | 53.7609 | -98.8139 | 2020-11-27 05:26:53 | Manitoba, Canada | ||
923452 | 923452 | 2020-11-26 | Canada | New Brunswick | 465 | 7 | 353 | 105 | 46.5653 | -66.4619 | 2020-11-27 05:26:53 | New Brunswick, Canada | ||
923453 | 923453 | 2020-11-26 | Canada | Newfoundland and Labrador | 327 | 4 | 295 | 28 | 53.1355 | -57.6604 | 2020-11-27 05:26:53 | Newfoundland and Labrador, Canada | ||
923454 | 923454 | 2020-11-26 | Canada | Northwest Territories | 15 | 0 | 15 | 0 | 64.8255 | -124.8457 | 2020-11-27 05:26:53 | Northwest Territories,Canada | ||
923455 | 923455 | 2020-11-26 | Canada | Nova Scotia | 1257 | 65 | 1078 | 114 | 44.682 | -63.7443 | 2020-11-27 05:26:53 | Nova Scotia, Canada | ||
923456 | 923456 | 2020-11-26 | Canada | Nunavut | 155 | 0 | 5 | 150 | 70.2998 | -83.1076 | 2020-11-27 05:26:53 | Nunavut, Canada | ||
923457 | 923457 | 2020-11-26 | Canada | Ontario | 113860 | 3575 | 97645 | 11660 | 51.2538 | -85.3232 | 2020-11-27 05:26:53 | Ontario, Canada | ||
923458 | 923458 | 2020-11-26 | Canada | Prince Edward Island | 70 | 0 | 68 | 2 | 46.5107 | -63.4168 | 2020-11-27 05:26:53 | Prince Edward Island, Canada | ||
923459 | 923459 | 2020-11-26 | Canada | Quebec | 138170 | 7031 | 118491 | 12648 | 52.9399 | -73.5491 | 2020-11-27 05:26:53 | Quebec, Canada | ||
923460 | 923460 | 2020-11-26 | Canada | Repatriated Travellers | 13 | 0 | 13 | 0 | 2020-11-27 05:26:53 | Repatriated Travellers, Canada | ||||
923461 | 923461 | 2020-11-26 | Canada | Saskatchewan | 7362 | 40 | 4176 | 3146 | 52.9399 | -106.4509 | 2020-11-27 05:26:53 | Saskatchewan, Canada | ||
923462 | 923462 | 2020-11-26 | Canada | Yukon | 42 | 1 | 29 | 12 | 64.2823 | -135.0 | 2020-11-27 05:26:53 | Yukon, Canada | ||
923463 | 923463 | 2020-11-26 | Central African Republic | 4913 | 63 | 1924 | 2926 | 6.6111 | 20.9394 | 2020-11-27 05:26:53 | Central African Republic | |||
923464 | 923464 | 2020-11-26 | Chad | 1661 | 101 | 1496 | 64 | 15.4542 | 18.7322 | 2020-11-27 05:26:53 | Chad | |||
923465 | 923465 | 2020-11-26 | Chile | Antofagasta | 22088 | 559 | 21348 | 181 | -23.6509 | -70.3975 | 2020-11-27 05:26:53 | Antofagasta, Chile | ||
923466 | 923466 | 2020-11-26 | Chile | Araucania | 16882 | 216 | 15783 | 883 | -38.9489 | -72.3311 | 2020-11-27 05:26:53 | Araucania, Chile | ||
923467 | 923467 | 2020-11-26 | Chile | Arica y Parinacota | 10176 | 200 | 9847 | 129 | -18.594 | -69.4785 | 2020-11-27 05:26:53 | Arica y Parinacota, Chile | ||
923468 | 923468 | 2020-11-26 | Chile | Atacama | 8100 | 103 | 7927 | 70 | -27.5661 | -70.0503 | 2020-11-27 05:26:53 | Atacama, Chile | ||
923469 | 923469 | 2020-11-26 | Chile | Aysen | 1236 | 13 | 1181 | 42 | -45.9864 | -73.7669 | 2020-11-27 05:26:53 | Aysen, Chile | ||
923470 | 923470 | 2020-11-26 | Chile | Biobio | 35472 | 594 | 33203 | 1675 | -37.4464 | -72.1416 | 2020-11-27 05:26:53 | Biobio, 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]);