johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by admin2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
426995 | 426995 | 2021-10-10 | Ukraine | Ternopil Oblast | 80103 | 1380 | 0 | 49.5535 | 25.5948 | 2021-10-11 04:21:31 | Ternopil Oblast, Ukraine | |||
426996 | 426996 | 2021-10-10 | Ukraine | Vinnytsia Oblast | 77608 | 1831 | 0 | 49.2331 | 28.4682 | 2021-10-11 04:21:31 | Vinnytsia Oblast, Ukraine | |||
426997 | 426997 | 2021-10-10 | Ukraine | Volyn Oblast | 68933 | 1296 | 0 | 50.7472 | 25.3254 | 2021-10-11 04:21:31 | Volyn Oblast, Ukraine | |||
426998 | 426998 | 2021-10-10 | Ukraine | Zakarpattia Oblast | 64913 | 1656 | 0 | 48.6208 | 22.2879 | 2021-10-11 04:21:31 | Zakarpattia Oblast, Ukraine | |||
426999 | 426999 | 2021-10-10 | Ukraine | Zaporizhia Oblast | 120099 | 2751 | 0 | 47.8388 | 35.1396 | 2021-10-11 04:21:31 | Zaporizhia Oblast, Ukraine | |||
427000 | 427000 | 2021-10-10 | Ukraine | Zhytomyr Oblast | 98889 | 2033 | 0 | 50.2547 | 28.6587 | 2021-10-11 04:21:31 | Zhytomyr Oblast, Ukraine | |||
427001 | 427001 | 2021-10-10 | United Arab Emirates | 737766 | 2113 | 0 | 23.424076 | 53.847818000000004 | 2021-10-11 04:21:31 | United Arab Emirates | ||||
427002 | 427002 | 2021-10-10 | United Kingdom | Anguilla | 544 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-11 04:21:31 | Anguilla, United Kingdom | |||
427003 | 427003 | 2021-10-10 | United Kingdom | Bermuda | 5501 | 89 | 0 | 32.3078 | -64.7505 | 2021-10-11 04:21:31 | Bermuda, United Kingdom | |||
427004 | 427004 | 2021-10-10 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-10-11 04:21:31 | British Virgin Islands, United Kingdom | |||
427005 | 427005 | 2021-10-10 | United Kingdom | Cayman Islands | 960 | 2 | 0 | 19.3133 | -81.2546 | 2021-10-11 04:21:31 | Cayman Islands, United Kingdom | |||
427006 | 427006 | 2021-10-10 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-11 04:21:31 | Channel Islands, United Kingdom | |||
427007 | 427007 | 2021-10-10 | United Kingdom | England | 6936327 | 141793 | 0 | 52.3555 | -1.1743 | 2021-10-11 04:21:31 | England, United Kingdom | |||
427008 | 427008 | 2021-10-10 | United Kingdom | Falkland Islands (Malvinas) | 68 | 0 | 0 | -51.7963 | -59.5236 | 2021-10-11 04:21:31 | Falkland Islands (Malvinas), United Kingdom | |||
427009 | 427009 | 2021-10-10 | United Kingdom | Gibraltar | 5626 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-11 04:21:31 | Gibraltar, United Kingdom | |||
427010 | 427010 | 2021-10-10 | United Kingdom | Isle of Man | 8073 | 54 | 0 | 54.2361 | -4.5481 | 2021-10-11 04:21:31 | Isle of Man, United Kingdom | |||
427011 | 427011 | 2021-10-10 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-10-11 04:21:31 | Montserrat, United Kingdom | |||
427012 | 427012 | 2021-10-10 | United Kingdom | Northern Ireland | 249821 | 3539 | 0 | 54.7877 | -6.4923 | 2021-10-11 04:21:31 | Northern Ireland, United Kingdom | |||
427013 | 427013 | 2021-10-10 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-10-11 04:21:31 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
427014 | 427014 | 2021-10-10 | United Kingdom | Scotland | 590424 | 11404 | 0 | 56.4907 | -4.2026 | 2021-10-11 04:21:31 | Scotland, United Kingdom | |||
427015 | 427015 | 2021-10-10 | United Kingdom | Turks and Caicos Islands | 2898 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-10-11 04:21:31 | Turks and Caicos Islands, United Kingdom | |||
427016 | 427016 | 2021-10-10 | United Kingdom | Unknown | 0 | 222 | 0 | 55.3781 | -3.436 | 2021-10-11 04:21:31 | Unknown, United Kingdom | |||
427017 | 427017 | 2021-10-10 | United Kingdom | Wales | 377734 | 8509 | 0 | 52.1307 | -3.7837 | 2021-10-11 04:21:31 | Wales, United Kingdom | |||
427018 | 427018 | 2021-10-10 | Uruguay | 390038 | 6064 | 0 | -32.5228 | -55.7658 | 2021-10-11 04:21:31 | Uruguay | ||||
427019 | 427019 | 2021-10-10 | Uzbekistan | 178259 | 1269 | 0 | 41.377491 | 64.585262 | 2021-10-11 04:21:31 | Uzbekistan | ||||
427020 | 427020 | 2021-10-10 | Vanuatu | 4 | 1 | 0 | -15.3767 | 166.9592 | 2021-10-11 04:21:31 | Vanuatu | ||||
427021 | 427021 | 2021-10-10 | Venezuela | 383376 | 4617 | 0 | 6.4238 | -66.5897 | 2021-10-11 04:21:31 | Venezuela | ||||
427022 | 427022 | 2021-10-10 | Vietnam | 839662 | 20555 | 0 | 14.058323999999999 | 108.277199 | 2021-10-11 04:21:31 | Vietnam | ||||
427023 | 427023 | 2021-10-10 | West Bank and Gaza | 441882 | 4465 | 0 | 31.9522 | 35.2332 | 2021-10-11 04:21:31 | West Bank and Gaza | ||||
427024 | 427024 | 2021-10-10 | Yemen | 9369 | 1778 | 0 | 15.552726999999999 | 48.516388 | 2021-10-11 04:21:31 | Yemen | ||||
427025 | 427025 | 2021-10-10 | Zambia | 209347 | 3654 | 0 | -13.133897 | 27.849332 | 2021-10-11 04:21:31 | Zambia | ||||
427026 | 427026 | 2021-10-10 | Zimbabwe | 131796 | 4637 | 0 | -19.015438 | 29.154857 | 2021-10-11 04:21:31 | Zimbabwe | ||||
427027 | 427027 | 2021-10-10 | Tonga | 0 | 0 | 0 | 0 | -21.179 | -175.1982 | 2021-10-11 04:21:31 | Tonga | |||
427028 | 427028 | 2021-10-10 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2021-10-11 04:21:31 | Winter Olympics 2022 | |||
427029 | 427029 | 2021-10-10 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2021-10-11 04:21:31 | Antarctica | |||
427030 | 427030 | 2021-10-10 | United Kingdom | Jersey | 10198 | 79 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-11 04:21:31 | Jersey, United Kingdom | ||
427031 | 427031 | 2021-10-10 | United Kingdom | Guernsey | 1690 | 21 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-11 04:21:31 | Guernsey, United Kingdom | ||
427032 | 427032 | 2021-10-10 | Korea, North | 0 | 0 | 0 | 0 | 40.3399 | 127.5101 | 2021-10-11 04:21:31 | Korea, North | |||
427033 | 427033 | 2021-10-10 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-10-11 04:21:31 | Unknown, Ukraine | ||||
427034 | 427034 | 2021-10-10 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2021-10-11 04:21:31 | Nauru | |||
427035 | 427035 | 2021-10-10 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-11 04:21:31 | Niue, New Zealand | ||
427036 | 427036 | 2021-10-10 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2021-10-11 04:21:31 | Tuvalu | |||
427037 | 427037 | 2021-10-10 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-11 04:21:31 | Pitcairn Islands, United Kingdom | ||
427038 | 427038 | 2020-09-07 | Afghanistan | 38580 | 1419 | 30557 | 6604 | 33.93911 | 67.709953 | 2020-09-08 04:28:25 | Afghanistan | |||
427039 | 427039 | 2020-09-07 | Albania | 10406 | 319 | 6186 | 3901 | 41.1533 | 20.1683 | 2020-09-08 04:28:25 | Albania | |||
427040 | 427040 | 2020-09-07 | Algeria | 46653 | 1562 | 32985 | 12106 | 28.0339 | 1.6596 | 2020-09-08 04:28:25 | Algeria | |||
427041 | 427041 | 2020-09-07 | Andorra | 1261 | 53 | 934 | 274 | 42.5063 | 1.5218 | 2020-09-08 04:28:25 | Andorra | |||
427042 | 427042 | 2020-09-07 | Angola | 2981 | 120 | 1215 | 1646 | -11.2027 | 17.8739 | 2020-09-08 04:28:25 | Angola | |||
427043 | 427043 | 2020-09-07 | Antigua and Barbuda | 95 | 3 | 91 | 1 | 17.0608 | -61.7964 | 2020-09-08 04:28:25 | Antigua and Barbuda | |||
427044 | 427044 | 2020-09-07 | Argentina | 488007 | 10129 | 357388 | 120490 | -38.4161 | -63.6167 | 2020-09-08 04:28:25 | Argentina | |||
427045 | 427045 | 2020-09-07 | Armenia | 44845 | 900 | 40121 | 3824 | 40.0691 | 45.0382 | 2020-09-08 04:28:25 | Armenia | |||
427046 | 427046 | 2020-09-07 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-09-08 04:28:25 | Australian Capital Territory, Australia | ||
427047 | 427047 | 2020-09-07 | Australia | New South Wales | 4126 | 52 | 0 | 4074 | -33.8688 | 151.2093 | 2020-09-08 04:28:25 | New South Wales, Australia | ||
427048 | 427048 | 2020-09-07 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-09-08 04:28:25 | Northern Territory, Australia | ||
427049 | 427049 | 2020-09-07 | Australia | Queensland | 1134 | 6 | 1090 | 38 | -27.4698 | 153.0251 | 2020-09-08 04:28:25 | Queensland, Australia | ||
427050 | 427050 | 2020-09-07 | Australia | South Australia | 464 | 4 | 460 | 0 | -34.9285 | 138.6007 | 2020-09-08 04:28:25 | South Australia, Australia | ||
427051 | 427051 | 2020-09-07 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-08 04:28:25 | Tasmania, Australia | ||
427052 | 427052 | 2020-09-07 | Australia | Victoria | 19615 | 683 | 17056 | 1876 | -37.8136 | 144.9631 | 2020-09-08 04:28:25 | Victoria, Australia | ||
427053 | 427053 | 2020-09-07 | Australia | Western Australia | 658 | 9 | 644 | 5 | -31.9505 | 115.8605 | 2020-09-08 04:28:25 | Western Australia, Australia | ||
427054 | 427054 | 2020-09-07 | Austria | 29253 | 917 | 25300 | 3515 | 47.5162 | 14.5501 | 2020-09-08 04:28:25 | Austria | |||
427055 | 427055 | 2020-09-07 | Azerbaijan | 37418 | 551 | 34837 | 2030 | 40.1431 | 47.5769 | 2020-09-08 04:28:25 | Azerbaijan | |||
427056 | 427056 | 2020-09-07 | Bahamas | 2546 | 58 | 976 | 1512 | 25.025885 | -78.035889 | 2020-09-08 04:28:25 | Bahamas | |||
427057 | 427057 | 2020-09-07 | Bahrain | 56076 | 200 | 51240 | 4636 | 26.0275 | 50.55 | 2020-09-08 04:28:25 | Bahrain | |||
427058 | 427058 | 2020-09-07 | Bangladesh | 327359 | 4516 | 224573 | 98270 | 23.685 | 90.3563 | 2020-09-08 04:28:25 | Bangladesh | |||
427059 | 427059 | 2020-09-07 | Barbados | 179 | 7 | 154 | 18 | 13.1939 | -59.5432 | 2020-09-08 04:28:25 | Barbados | |||
427060 | 427060 | 2020-09-07 | Belarus | 73031 | 716 | 71883 | 432 | 53.7098 | 27.9534 | 2020-09-08 04:28:25 | Belarus | |||
427061 | 427061 | 2020-09-07 | Belgium | 88769 | 9909 | 18576 | 60284 | 50.8333 | 4.469936 | 2020-09-08 04:28:25 | Belgium | |||
427062 | 427062 | 2020-09-07 | Belize | 1307 | 16 | 314 | 977 | 17.1899 | -88.4976 | 2020-09-08 04:28:25 | Belize | |||
427063 | 427063 | 2020-09-07 | Benin | 2213 | 40 | 1793 | 380 | 9.3077 | 2.3158 | 2020-09-08 04:28:25 | Benin | |||
427064 | 427064 | 2020-09-07 | Bhutan | 233 | 0 | 151 | 82 | 27.5142 | 90.4336 | 2020-09-08 04:28:25 | Bhutan | |||
427065 | 427065 | 2020-09-07 | Bolivia | 121604 | 7054 | 73150 | 41400 | -16.2902 | -63.5887 | 2020-09-08 04:28:25 | Bolivia | |||
427066 | 427066 | 2020-09-07 | Bosnia and Herzegovina | 21660 | 664 | 14830 | 6166 | 43.9159 | 17.6791 | 2020-09-08 04:28:25 | Bosnia and Herzegovina | |||
427067 | 427067 | 2020-09-07 | Botswana | 2126 | 9 | 493 | 1624 | -22.3285 | 24.6849 | 2020-09-08 04:28:25 | Botswana | |||
427068 | 427068 | 2020-09-07 | Brazil | Acre | 25469 | 624 | 20168 | 4677 | -9.0238 | -70.812 | 2020-09-08 04:28:25 | Acre, Brazil | ||
427069 | 427069 | 2020-09-07 | Brazil | Alagoas | 80786 | 1936 | 76382 | 2468 | -9.5713 | -36.782 | 2020-09-08 04:28:25 | Alagoas, Brazil | ||
427070 | 427070 | 2020-09-07 | Brazil | Amapa | 44863 | 673 | 32736 | 11454 | 0.902 | -52.003 | 2020-09-08 04:28:25 | Amapa, Brazil | ||
427071 | 427071 | 2020-09-07 | Brazil | Amazonas | 123905 | 3849 | 105120 | 14936 | -3.4168 | -65.8561 | 2020-09-08 04:28:25 | Amazonas, Brazil | ||
427072 | 427072 | 2020-09-07 | Brazil | Bahia | 271963 | 5693 | 257791 | 8479 | -12.5797 | -41.7007 | 2020-09-08 04:28:25 | Bahia, Brazil | ||
427073 | 427073 | 2020-09-07 | Brazil | Ceara | 222473 | 8567 | 197162 | 16717 | -5.4984 | -39.3206 | 2020-09-08 04:28:25 | Ceara, Brazil | ||
427074 | 427074 | 2020-09-07 | Brazil | Distrito Federal | 170806 | 2720 | 154753 | 13333 | -15.7998 | -47.8645 | 2020-09-08 04:28:25 | Distrito Federal, Brazil | ||
427075 | 427075 | 2020-09-07 | Brazil | Espirito Santo | 115793 | 3268 | 104887 | 7638 | -19.1834 | -40.3089 | 2020-09-08 04:28:25 | Espirito Santo, Brazil | ||
427076 | 427076 | 2020-09-07 | Brazil | Goias | 147933 | 3481 | 138671 | 5582 | -15.827 | -49.8362 | 2020-09-08 04:28:25 | Goias, Brazil | ||
427077 | 427077 | 2020-09-07 | Brazil | Maranhao | 158310 | 3518 | 146103 | 8689 | -4.9609 | -45.2744 | 2020-09-08 04:28:25 | Maranhao, Brazil | ||
427078 | 427078 | 2020-09-07 | Brazil | Mato Grosso | 98709 | 2978 | 79290 | 15984 | -12.6819 | -56.9211 | 2020-09-08 04:28:25 | Mato Grosso, Brazil | ||
427079 | 427079 | 2020-09-07 | Brazil | Mato Grosso do Sul | 54363 | 987 | 44741 | 8414 | -20.7722 | -54.7852 | 2020-09-08 04:28:25 | Mato Grosso do Sul, Brazil | ||
427080 | 427080 | 2020-09-07 | Brazil | Minas Gerais | 236012 | 5851 | 199383 | 30778 | -18.5122 | -44.555 | 2020-09-08 04:28:25 | Minas Gerais, Brazil | ||
427081 | 427081 | 2020-09-07 | Brazil | Para | 208560 | 6269 | 192995 | 9007 | -1.9981 | -54.9306 | 2020-09-08 04:28:25 | Para, Brazil | ||
427082 | 427082 | 2020-09-07 | Brazil | Paraiba | 109706 | 2550 | 81039 | 26117 | -7.24 | -36.782 | 2020-09-08 04:28:25 | Paraiba, Brazil | ||
427083 | 427083 | 2020-09-07 | Brazil | Parana | 143853 | 3577 | 95386 | 44890 | -25.2521 | -52.0215 | 2020-09-08 04:28:25 | Parana, Brazil | ||
427084 | 427084 | 2020-09-07 | Brazil | Pernambuco | 132420 | 7721 | 114990 | 9709 | -8.8137 | -36.9541 | 2020-09-08 04:28:25 | Pernambuco, Brazil | ||
427085 | 427085 | 2020-09-07 | Brazil | Piaui | 82564 | 1915 | 80091 | 290 | -7.7183 | -42.7289 | 2020-09-08 04:28:25 | Piaui, Brazil | ||
427086 | 427086 | 2020-09-07 | Brazil | Rio Grande do Norte | 64097 | 2304 | 38385 | 23131 | -5.4026 | -36.9541 | 2020-09-08 04:28:25 | Rio Grande do Norte, Brazil | ||
427087 | 427087 | 2020-09-07 | Brazil | Rio Grande do Sul | 143952 | 3756 | 131093 | 9103 | -30.0346 | -51.2177 | 2020-09-08 04:28:25 | Rio Grande do Sul, Brazil | ||
427088 | 427088 | 2020-09-07 | Brazil | Rio de Janeiro | 233052 | 16593 | 210761 | 5698 | -22.9068 | -43.1729 | 2020-09-08 04:28:25 | Rio de Janeiro, Brazil | ||
427089 | 427089 | 2020-09-07 | Brazil | Rondonia | 58237 | 1187 | 49385 | 7665 | -11.5057 | -63.5806 | 2020-09-08 04:28:25 | Rondonia, Brazil | ||
427090 | 427090 | 2020-09-07 | Brazil | Roraima | 45302 | 598 | 14732 | 29923 | -2.7376 | -62.0751 | 2020-09-08 04:28:25 | Roraima, Brazil | ||
427091 | 427091 | 2020-09-07 | Brazil | Santa Catarina | 189477 | 2422 | 179189 | 7866 | -27.2423 | -50.2189 | 2020-09-08 04:28:25 | Santa Catarina, Brazil | ||
427092 | 427092 | 2020-09-07 | Brazil | Sao Paulo | 857330 | 31377 | 699451 | 126502 | -23.5505 | -46.6333 | 2020-09-08 04:28:25 | Sao Paulo, Brazil | ||
427093 | 427093 | 2020-09-07 | Brazil | Sergipe | 73846 | 1898 | 66376 | 5572 | -10.5741 | -37.3857 | 2020-09-08 04:28:25 | Sergipe, Brazil | ||
427094 | 427094 | 2020-09-07 | Brazil | Tocantins | 56223 | 758 | 38141 | 17011 | -10.1753 | -48.2982 | 2020-09-08 04:28:25 | Tocantins, Brazil |
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]);