daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28,238 rows where active = 1 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-10-31 | Tonga | 1 | 0 | 0 | 1 | -21.179 | -175.1982 | 2021-11-01 04:22:01 | Tonga | |||
2021-10-30 | Tonga | 1 | 0 | 0 | 1 | -21.179 | -175.1982 | 2021-10-31 04:22:08 | Tonga | |||
2021-10-29 | Tonga | 1 | 0 | 0 | 1 | -21.179 | -175.1982 | 2021-10-30 04:22:03 | Tonga | |||
2021-08-04 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-08-05 04:21:51 | Montserrat, United Kingdom | ||
2021-08-04 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-05 04:21:51 | Cook Islands, New Zealand | ||
2021-08-04 | China | Shanxi | 254 | 0 | 253 | 1 | 37.5777 | 112.2922 | 2021-08-05 04:21:51 | Shanxi, China | ||
2021-08-04 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-05 04:21:51 | Ningxia, China | ||
2021-08-04 | China | Jilin | 574 | 3 | 570 | 1 | 43.6661 | 126.1923 | 2021-08-05 04:21:51 | Jilin, China | ||
2021-08-04 | China | Hainan | 189 | 6 | 182 | 1 | 19.1959 | 109.7453 | 2021-08-05 04:21:51 | Hainan, China | ||
2021-08-04 | Australia | Tasmania | 235 | 13 | 221 | 1 | -42.8821 | 147.3272 | 2021-08-05 04:21:51 | Tasmania, Australia | ||
2021-08-03 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-08-04 04:21:25 | Montserrat, United Kingdom | ||
2021-08-03 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-04 04:21:25 | Cook Islands, New Zealand | ||
2021-08-03 | China | Shanxi | 254 | 0 | 253 | 1 | 37.5777 | 112.2922 | 2021-08-04 04:21:25 | Shanxi, China | ||
2021-08-03 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-04 04:21:25 | Ningxia, China | ||
2021-08-03 | China | Jilin | 574 | 3 | 570 | 1 | 43.6661 | 126.1923 | 2021-08-04 04:21:25 | Jilin, China | ||
2021-08-03 | China | Hainan | 189 | 6 | 182 | 1 | 19.1959 | 109.7453 | 2021-08-04 04:21:25 | Hainan, China | ||
2021-08-02 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-08-03 04:21:39 | Montserrat, United Kingdom | ||
2021-08-02 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-03 04:21:39 | Cook Islands, New Zealand | ||
2021-08-02 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-03 04:21:39 | Ningxia, China | ||
2021-08-02 | China | Jilin | 574 | 3 | 570 | 1 | 43.6661 | 126.1923 | 2021-08-03 04:21:39 | Jilin, China | ||
2021-08-02 | China | Hainan | 189 | 6 | 182 | 1 | 19.1959 | 109.7453 | 2021-08-03 04:21:39 | Hainan, China | ||
2021-08-01 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-08-02 04:21:36 | Montserrat, United Kingdom | ||
2021-08-01 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-02 04:21:36 | Cook Islands, New Zealand | ||
2021-08-01 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-02 04:21:36 | Ningxia, China | ||
2021-08-01 | China | Jilin | 574 | 3 | 570 | 1 | 43.6661 | 126.1923 | 2021-08-02 04:21:36 | Jilin, China | ||
2021-08-01 | China | Hainan | 189 | 6 | 182 | 1 | 19.1959 | 109.7453 | 2021-08-02 04:21:36 | Hainan, China | ||
2021-07-31 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-08-01 04:21:50 | Montserrat, United Kingdom | ||
2021-07-31 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-01 04:21:50 | Cook Islands, New Zealand | ||
2021-07-31 | China | Ningxia | 77 | 0 | 76 | 1 | 37.2692 | 106.1655 | 2021-08-01 04:21:50 | Ningxia, China | ||
2021-07-31 | China | Jilin | 574 | 3 | 570 | 1 | 43.6661 | 126.1923 | 2021-08-01 04:21:50 | Jilin, China | ||
2021-07-30 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-31 04:21:35 | Montserrat, United Kingdom | ||
2021-07-30 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-31 04:21:35 | Cook Islands, New Zealand | ||
2021-07-30 | China | Jilin | 574 | 3 | 570 | 1 | 43.6661 | 126.1923 | 2021-07-31 04:21:35 | Jilin, China | ||
2021-07-30 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-31 04:21:35 | Hainan, China | ||
2021-07-29 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-30 04:21:34 | Montserrat, United Kingdom | ||
2021-07-29 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-30 04:21:34 | Cook Islands, New Zealand | ||
2021-07-29 | China | Jilin | 574 | 3 | 570 | 1 | 43.6661 | 126.1923 | 2021-07-30 04:21:34 | Jilin, China | ||
2021-07-29 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-30 04:21:34 | Hainan, China | ||
2021-07-28 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-29 04:21:33 | Montserrat, United Kingdom | ||
2021-07-28 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-29 04:21:33 | Cook Islands, New Zealand | ||
2021-07-28 | China | Shandong | 884 | 7 | 876 | 1 | 36.3427 | 118.1498 | 2021-07-29 04:21:33 | Shandong, China | ||
2021-07-28 | China | Jilin | 574 | 3 | 570 | 1 | 43.6661 | 126.1923 | 2021-07-29 04:21:33 | Jilin, China | ||
2021-07-28 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-29 04:21:33 | Hainan, China | ||
2021-07-27 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-28 04:21:39 | Montserrat, United Kingdom | ||
2021-07-27 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-28 04:21:39 | Cook Islands, New Zealand | ||
2021-07-27 | China | Shandong | 884 | 7 | 876 | 1 | 36.3427 | 118.1498 | 2021-07-28 04:21:39 | Shandong, China | ||
2021-07-27 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-28 04:21:39 | Ningxia, China | ||
2021-07-27 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-28 04:21:39 | Hainan, China | ||
2021-07-26 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-27 04:21:18 | Montserrat, United Kingdom | ||
2021-07-26 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-27 04:21:18 | Cook Islands, New Zealand | ||
2021-07-26 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-27 04:21:18 | Ningxia, China | ||
2021-07-26 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-27 04:21:18 | Hainan, China | ||
2021-07-25 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-26 04:21:28 | Montserrat, United Kingdom | ||
2021-07-25 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-26 04:21:28 | Cook Islands, New Zealand | ||
2021-07-25 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-26 04:21:28 | Ningxia, China | ||
2021-07-25 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-26 04:21:28 | Hainan, China | ||
2021-07-24 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-25 04:22:12 | Montserrat, United Kingdom | ||
2021-07-24 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-25 04:22:12 | Cook Islands, New Zealand | ||
2021-07-24 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-25 04:22:12 | Ningxia, China | ||
2021-07-24 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-25 04:22:12 | Hainan, China | ||
2021-07-23 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-24 00:21:36 | Montserrat, United Kingdom | ||
2021-07-23 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-24 00:21:36 | Cook Islands, New Zealand | ||
2021-07-23 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-24 00:21:36 | Ningxia, China | ||
2021-07-23 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-24 00:21:36 | Hainan, China | ||
2021-07-22 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-23 04:21:29 | Montserrat, United Kingdom | ||
2021-07-22 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-23 04:21:29 | Cook Islands, New Zealand | ||
2021-07-22 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-23 04:21:29 | Ningxia, China | ||
2021-07-22 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-23 04:21:29 | Hainan, China | ||
2021-07-21 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-22 04:21:19 | Montserrat, United Kingdom | ||
2021-07-21 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-22 04:21:19 | Cook Islands, New Zealand | ||
2021-07-21 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-22 04:21:19 | Ningxia, China | ||
2021-07-21 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-22 04:21:19 | Hainan, China | ||
2021-07-20 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-21 04:21:40 | Montserrat, United Kingdom | ||
2021-07-20 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-21 04:21:40 | Cook Islands, New Zealand | ||
2021-07-20 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-21 04:21:40 | Ningxia, China | ||
2021-07-20 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-21 04:21:40 | Hainan, China | ||
2021-07-20 | China | Gansu | 196 | 2 | 193 | 1 | 35.7518 | 104.2861 | 2021-07-21 04:21:40 | Gansu, China | ||
2021-07-19 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-20 04:21:48 | Montserrat, United Kingdom | ||
2021-07-19 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-20 04:21:48 | Cook Islands, New Zealand | ||
2021-07-19 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-20 04:21:48 | Ningxia, China | ||
2021-07-19 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-20 04:21:48 | Hainan, China | ||
2021-07-19 | China | Gansu | 196 | 2 | 193 | 1 | 35.7518 | 104.2861 | 2021-07-20 04:21:48 | Gansu, China | ||
2021-07-18 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-19 04:21:24 | Montserrat, United Kingdom | ||
2021-07-18 | United Kingdom | Anguilla | 112 | 0 | 111 | 1 | 18.2206 | -63.0686 | 2021-07-19 04:21:24 | Anguilla, United Kingdom | ||
2021-07-18 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-19 04:21:24 | Cook Islands, New Zealand | ||
2021-07-18 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-19 04:21:24 | Ningxia, China | ||
2021-07-18 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-19 04:21:24 | Hainan, China | ||
2021-07-18 | China | Gansu | 196 | 2 | 193 | 1 | 35.7518 | 104.2861 | 2021-07-19 04:21:24 | Gansu, China | ||
2021-07-17 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-18 04:22:07 | Montserrat, United Kingdom | ||
2021-07-17 | United Kingdom | Anguilla | 112 | 0 | 111 | 1 | 18.2206 | -63.0686 | 2021-07-18 04:22:07 | Anguilla, United Kingdom | ||
2021-07-17 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-18 04:22:07 | Cook Islands, New Zealand | ||
2021-07-17 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-18 04:22:07 | Ningxia, China | ||
2021-07-17 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-18 04:22:07 | Hainan, China | ||
2021-07-16 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-17 04:22:22 | Montserrat, United Kingdom | ||
2021-07-16 | United Kingdom | Cayman Islands | 620 | 2 | 617 | 1 | 19.3133 | -81.2546 | 2021-07-17 04:22:22 | Cayman Islands, United Kingdom | ||
2021-07-16 | United Kingdom | Anguilla | 112 | 0 | 111 | 1 | 18.2206 | -63.0686 | 2021-07-17 04:22:22 | Anguilla, United Kingdom | ||
2021-07-16 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-17 04:22:22 | Cook Islands, New Zealand | ||
2021-07-16 | China | Ningxia | 76 | 0 | 75 | 1 | 37.2692 | 106.1655 | 2021-07-17 04:22:22 | Ningxia, China | ||
2021-07-16 | China | Hainan | 188 | 6 | 181 | 1 | 19.1959 | 109.7453 | 2021-07-17 04:22:22 | Hainan, China | ||
2021-07-15 | United Kingdom | Montserrat | 21 | 1 | 19 | 1 | 16.742498 | -62.187366 | 2021-07-16 04:21:22 | Montserrat, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;