johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4007 | 4007 | 2021-12-02 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2021-12-03 04:23:05 | Winter Olympics 2022 | |||
4008 | 4008 | 2021-12-02 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2021-12-03 04:23:05 | Antarctica | |||
4009 | 4009 | 2021-12-02 | United Kingdom | Jersey | 14237 | 81 | 0 | 0 | 49.2138 | -2.1358 | 2021-12-03 04:23:05 | Jersey, United Kingdom | ||
4010 | 4010 | 2021-12-02 | United Kingdom | Guernsey | 4163 | 23 | 0 | 0 | 49.448196 | -2.58949 | 2021-12-03 04:23:05 | Guernsey, United Kingdom | ||
4011 | 4011 | 2021-12-02 | Korea, North | 0 | 0 | 0 | 0 | 40.3399 | 127.5101 | 2021-12-03 04:23:05 | Korea, North | |||
4012 | 4012 | 2021-12-02 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-12-03 04:23:05 | Unknown, Ukraine | ||||
4013 | 4013 | 2021-12-02 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2021-12-03 04:23:05 | Nauru | |||
4014 | 4014 | 2021-12-02 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-12-03 04:23:05 | Niue, New Zealand | ||
4015 | 4015 | 2021-12-02 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2021-12-03 04:23:05 | Tuvalu | |||
4016 | 4016 | 2021-12-02 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-12-03 04:23:05 | Pitcairn Islands, United Kingdom | ||
8022 | 8022 | 2021-10-28 | Tonga | 0 | 0 | 0 | 0 | -21.179 | -175.1982 | 2021-10-29 04:22:03 | Tonga | |||
8023 | 8023 | 2021-10-28 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2021-10-29 04:22:03 | Winter Olympics 2022 | |||
8024 | 8024 | 2021-10-28 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2021-10-29 04:22:03 | Antarctica | |||
8025 | 8025 | 2021-10-28 | United Kingdom | Jersey | 10843 | 80 | 0 | 0 | 49.2138 | -2.1358 | 2021-10-29 04:22:03 | Jersey, United Kingdom | ||
8026 | 8026 | 2021-10-28 | United Kingdom | Guernsey | 2074 | 23 | 0 | 0 | 49.448196 | -2.58949 | 2021-10-29 04:22:03 | Guernsey, United Kingdom | ||
8027 | 8027 | 2021-10-28 | Korea, North | 0 | 0 | 0 | 0 | 40.3399 | 127.5101 | 2021-10-29 04:22:03 | Korea, North | |||
8028 | 8028 | 2021-10-28 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2021-10-29 04:22:03 | Unknown, Ukraine | ||||
8029 | 8029 | 2021-10-28 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2021-10-29 04:22:03 | Nauru | |||
8030 | 8030 | 2021-10-28 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-29 04:22:03 | Niue, New Zealand | ||
8031 | 8031 | 2021-10-28 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2021-10-29 04:22:03 | Tuvalu | |||
8032 | 8032 | 2021-10-28 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-29 04:22:03 | Pitcairn Islands, United Kingdom | ||
8043 | 8043 | 2020-10-25 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-26 04:25:02 | Northern Territory, Australia | ||
8046 | 8046 | 2020-10-25 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-26 04:25:02 | Tasmania, Australia | ||
8100 | 8100 | 2020-10-25 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-10-26 04:25:02 | Diamond Princess, Canada | ||
8101 | 8101 | 2020-10-25 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-26 04:25:02 | Grand Princess, Canada | ||
8107 | 8107 | 2020-10-25 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-10-26 04:25:02 | Nunavut, Canada | ||
8130 | 8130 | 2020-10-25 | Chile | Unknown | 50 | 1 | 50 | 0 | 2020-10-26 04:25:02 | Unknown, Chile | ||||
8132 | 8132 | 2020-10-25 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-10-26 04:25:02 | Anhui, China | ||
8136 | 8136 | 2020-10-25 | China | Gansu | 170 | 2 | 168 | 0 | 35.7518 | 104.2861 | 2020-10-26 04:25:02 | Gansu, China | ||
8138 | 8138 | 2020-10-25 | China | Guangxi | 260 | 2 | 258 | 0 | 23.8298 | 108.7881 | 2020-10-26 04:25:02 | Guangxi, China | ||
8139 | 8139 | 2020-10-25 | China | Guizhou | 147 | 2 | 145 | 0 | 26.8154 | 106.8748 | 2020-10-26 04:25:02 | Guizhou, China | ||
8140 | 8140 | 2020-10-25 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-26 04:25:02 | Hainan, China | ||
8142 | 8142 | 2020-10-25 | China | Heilongjiang | 948 | 13 | 935 | 0 | 47.862 | 127.7615 | 2020-10-26 04:25:02 | Heilongjiang, China | ||
8145 | 8145 | 2020-10-25 | China | Hubei | 68139 | 4512 | 63627 | 0 | 30.9756 | 112.2707 | 2020-10-26 04:25:02 | Hubei, China | ||
8146 | 8146 | 2020-10-25 | China | Hunan | 1019 | 4 | 1015 | 0 | 27.6104 | 111.7088 | 2020-10-26 04:25:02 | Hunan, China | ||
8149 | 8149 | 2020-10-25 | China | Jiangxi | 935 | 1 | 934 | 0 | 27.614 | 115.7221 | 2020-10-26 04:25:02 | Jiangxi, China | ||
8150 | 8150 | 2020-10-25 | China | Jilin | 157 | 2 | 155 | 0 | 43.6661 | 126.1923 | 2020-10-26 04:25:02 | Jilin, China | ||
8152 | 8152 | 2020-10-25 | China | Macau | 46 | 0 | 46 | 0 | 22.1667 | 113.55 | 2020-10-26 04:25:02 | Macau, China | ||
8153 | 8153 | 2020-10-25 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-10-26 04:25:02 | Ningxia, China | ||
8154 | 8154 | 2020-10-25 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-10-26 04:25:02 | Qinghai, China | ||
8161 | 8161 | 2020-10-25 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-10-26 04:25:02 | Tibet, China | ||
8162 | 8162 | 2020-10-25 | China | Xinjiang | 902 | 3 | 899 | 0 | 41.1129 | 85.2401 | 2020-10-26 04:25:02 | Xinjiang, China | ||
8230 | 8230 | 2020-10-25 | France | New Caledonia | 27 | 0 | 27 | 0 | -20.904305 | 165.618042 | 2020-10-26 04:25:02 | New Caledonia, France | ||
8286 | 8286 | 2020-10-25 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-10-26 04:25:02 | Lakshadweep, India | ||
8301 | 8301 | 2020-10-25 | India | Unknown | 0 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, India | ||||
8336 | 8336 | 2020-10-25 | Japan | Ehime | 116 | 6 | 110 | 0 | 33.624835 | 132.856842 | 2020-10-26 04:25:02 | Ehime, Japan | ||
8349 | 8349 | 2020-10-25 | Japan | Kagoshima | 463 | 12 | 453 | 0 | 31.009484000000004 | 130.430665 | 2020-10-26 04:25:02 | Kagoshima, Japan | ||
8361 | 8361 | 2020-10-25 | Japan | Oita | 159 | 3 | 156 | 0 | 33.200697 | 131.43323999999998 | 2020-10-26 04:25:02 | Oita, Japan | ||
8369 | 8369 | 2020-10-25 | Japan | Shimane | 140 | 0 | 140 | 0 | 35.07076 | 132.55406399999998 | 2020-10-26 04:25:02 | Shimane, Japan | ||
8375 | 8375 | 2020-10-25 | Japan | Toyama | 422 | 26 | 396 | 0 | 36.637464 | 137.26934599999998 | 2020-10-26 04:25:02 | Toyama, Japan | ||
8376 | 8376 | 2020-10-25 | Japan | Unknown | 8 | 0 | 8 | 0 | 2020-10-26 04:25:02 | Unknown, Japan | ||||
8504 | 8504 | 2020-10-25 | Peru | Unknown | 0 | 0 | 803846 | 0 | 2020-10-26 04:25:02 | Unknown, Peru | ||||
8594 | 8594 | 2020-10-25 | Saint Kitts and Nevis | 19 | 0 | 19 | 0 | 17.357822 | -62.782998 | 2020-10-26 04:25:02 | Saint Kitts and Nevis | |||
8597 | 8597 | 2020-10-25 | Samoa | 0 | 0 | 0 | 0 | -13.759 | -172.1046 | 2020-10-26 04:25:02 | Samoa | |||
8631 | 8631 | 2020-10-25 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, Spain | ||||
8719 | 8719 | 2020-10-25 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-26 04:25:02 | Out of AL, Alabama, US |
8731 | 8731 | 2020-10-25 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Alabama, US |
8740 | 8740 | 2020-10-25 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2020-10-26 04:25:02 | Bristol Bay, Alaska, US |
8761 | 8761 | 2020-10-25 | US | Alaska | Valdez-Cordova | 2261 | 0 | 0 | 0 | 0 | 61.47502768 | -144.7126799 | 2020-10-26 04:25:02 | Valdez-Cordova, Alaska, US |
8778 | 8778 | 2020-10-25 | US | Arizona | Unassigned | 90004 | 0 | 1 | 0 | 0 | 35.83883429 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Arizona, US |
8912 | 8912 | 2020-10-25 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-10-26 04:25:02 | Unassigned, California, US |
8963 | 8963 | 2020-10-25 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2020-10-26 04:25:02 | Out of CO, Colorado, US |
9233 | 9233 | 2020-10-25 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Hawaii, US |
9276 | 9276 | 2020-10-25 | US | Idaho | Unassigned | 90016 | 0 | 0 | 0 | 0 | 48.76684761 | -116.78476880000001 | 2020-10-26 04:25:02 | Unassigned, Idaho, US |
9463 | 9463 | 2020-10-25 | US | Indiana | Unassigned | 90018 | 0 | 89 | 0 | 0 | 41.64423868 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Indiana, US |
9674 | 9674 | 2020-10-25 | US | Kansas | Unassigned | 90020 | 0 | 19 | 0 | 0 | 39.82799632 | -99.91547333 | 2020-10-26 04:25:02 | Unassigned, Kansas, US |
9794 | 9794 | 2020-10-25 | US | Kentucky | Unassigned | 90021 | 0 | 0 | 0 | 0 | 38.97065142 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Kentucky, US |
9840 | 9840 | 2020-10-25 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2020-10-26 04:25:02 | Out of LA, Louisiana, US |
9877 | 9877 | 2020-10-25 | US | Maine | Out of ME | 80023 | 0 | 0 | 0 | 0 | 46.65926321 | 0.0 | 2020-08-07 22:34:20 | Out of ME, Maine, US |
9883 | 9883 | 2020-10-25 | US | Maine | Unassigned | 90023 | 0 | 0 | 0 | 0 | 46.65926321 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Maine, US |
9908 | 9908 | 2020-10-25 | US | Maryland | Unassigned | 90024 | 0 | 10 | 0 | 0 | 39.62357628 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Maryland, US |
10173 | 10173 | 2020-10-25 | US | Mississippi | Unassigned | 90028 | 0 | 0 | 0 | 0 | 34.88084463 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Mississippi, US |
10353 | 10353 | 2020-10-25 | US | Montana | Unassigned | 90030 | 0 | 0 | 0 | 0 | 48.78420029 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Montana, US |
10457 | 10457 | 2020-10-25 | US | Nevada | Esmeralda | 32009 | 0 | 0 | 0 | 0 | 37.78436681 | -117.6319999 | 2020-10-26 04:25:02 | Esmeralda, Nevada, US |
10467 | 10467 | 2020-10-25 | US | Nevada | Unassigned | 90032 | 0 | 0 | 0 | 0 | 41.40692186 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Nevada, US |
10576 | 10576 | 2020-10-25 | US | New York | Out of NY | 80036 | 0 | 111 | 0 | 0 | 44.74530905 | 0.0 | 2020-10-26 04:25:02 | Out of NY, New York, US |
10594 | 10594 | 2020-10-25 | US | New York | Unassigned | 90036 | 0 | 21 | 0 | 0 | 44.74530905 | 0.0 | 2020-10-26 04:25:02 | Unassigned, New York, US |
10690 | 10690 | 2020-10-25 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2020-10-26 04:25:02 | Unassigned, North Carolina, US |
10751 | 10751 | 2020-10-25 | US | North Dakota | Unassigned | 90038 | 0 | 0 | 0 | 0 | 48.814938700000006 | 0.0 | 2020-10-26 04:25:02 | Unassigned, North Dakota, US |
10836 | 10836 | 2020-10-25 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-10-26 04:25:02 | Unassigned, Ohio, US |
10904 | 10904 | 2020-10-25 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-10-26 04:25:02 | Out of OK, Oklahoma, US |
10955 | 10955 | 2020-10-25 | US | Oregon | Unassigned | 90041 | 0 | 0 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2020-10-26 04:25:02 | Unassigned, Oregon, US |
11021 | 11021 | 2020-10-25 | US | Pennsylvania | Unassigned | 90042 | 0 | 0 | 0 | 0 | 41.99253829 | -80.34921611 | 2020-10-26 04:25:02 | Unassigned, Pennsylvania, US |
11110 | 11110 | 2020-10-25 | US | Recovered | 0 | 0 | 3422878 | 0 | 0.0 | 0.0 | 2020-10-26 04:25:02 | Recovered, US | ||
11160 | 11160 | 2020-10-25 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-10-26 04:25:02 | Unassigned, South Carolina, US |
11226 | 11226 | 2020-10-25 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-10-26 04:25:02 | Unassigned, South Dakota, US |
11478 | 11478 | 2020-10-25 | US | Texas | Loving | 48301 | 1 | 0 | 0 | 0 | 31.84947612 | -103.5818571 | 2020-10-26 04:25:02 | Loving, Texas, US |
11557 | 11557 | 2020-10-25 | US | Texas | Unassigned | 90048 | 6582 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-10-26 04:25:02 | Unassigned, Texas, US |
11593 | 11593 | 2020-10-25 | US | Utah | Unassigned | 90049 | 0 | 0 | 0 | 0 | 41.72330587 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Utah, US |
11736 | 11736 | 2020-10-25 | US | Virginia | Unassigned | 90051 | 0 | 0 | 0 | 0 | 39.20172582 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Virginia, US |
11835 | 11835 | 2020-10-25 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-10-26 04:25:02 | Unassigned, West Virginia, US |
11905 | 11905 | 2020-10-25 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Wisconsin, US |
11937 | 11937 | 2020-10-25 | US | Wyoming | Unassigned | 90056 | 0 | 0 | 0 | 0 | 44.79048913 | -110.6563997 | 2020-10-26 04:25:02 | Unassigned, Wyoming, US |
11969 | 11969 | 2020-10-25 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-10-26 04:25:02 | Anguilla, United Kingdom | ||
11971 | 11971 | 2020-10-25 | United Kingdom | British Virgin Islands | 71 | 1 | 70 | 0 | 18.4207 | -64.64 | 2020-10-26 04:25:02 | British Virgin Islands, United Kingdom | ||
11975 | 11975 | 2020-10-25 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-10-26 04:25:02 | Falkland Islands (Malvinas), United Kingdom | ||
11978 | 11978 | 2020-10-25 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2020-10-26 04:25:02 | Montserrat, United Kingdom | ||
11980 | 11980 | 2020-10-25 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-26 04:25:02 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
11983 | 11983 | 2020-10-25 | United Kingdom | Unknown | 0 | 75 | 0 | 0 | 55.3781 | -3.436 | 2020-10-26 04:25:02 | Unknown, United Kingdom | ||
11995 | 11995 | 2020-10-25 | China | Unknown | 5492 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, 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]);