daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13,670 rows where active = 4 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), 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-08-04 | India | Andaman and Nicobar Islands | 7541 | 129 | 7408 | 4 | 11.225999 | 92.968178 | 2021-08-05 04:21:51 | Andaman and Nicobar Islands, India | ||
2021-08-04 | Colombia | Vaupes | 1727 | 17 | 1706 | 4 | 0.8554 | -70.812 | 2021-08-05 04:21:51 | Vaupes, Colombia | ||
2021-08-04 | China | Gansu | 199 | 2 | 193 | 4 | 35.7518 | 104.2861 | 2021-08-05 04:21:51 | Gansu, China | ||
2021-08-04 | China | Chongqing | 603 | 6 | 593 | 4 | 30.0572 | 107.874 | 2021-08-05 04:21:51 | Chongqing, China | ||
2021-08-04 | Chad | 4974 | 174 | 4796 | 4 | 15.4542 | 18.7322 | 2021-08-05 04:21:51 | Chad | |||
2021-08-03 | China | Gansu | 199 | 2 | 193 | 4 | 35.7518 | 104.2861 | 2021-08-04 04:21:25 | Gansu, China | ||
2021-08-03 | China | Chongqing | 603 | 6 | 593 | 4 | 30.0572 | 107.874 | 2021-08-04 04:21:25 | Chongqing, China | ||
2021-08-02 | China | Gansu | 199 | 2 | 193 | 4 | 35.7518 | 104.2861 | 2021-08-03 04:21:39 | Gansu, China | ||
2021-08-02 | China | Chongqing | 603 | 6 | 593 | 4 | 30.0572 | 107.874 | 2021-08-03 04:21:39 | Chongqing, China | ||
2021-08-01 | China | Gansu | 199 | 2 | 193 | 4 | 35.7518 | 104.2861 | 2021-08-02 04:21:36 | Gansu, China | ||
2021-08-01 | China | Chongqing | 603 | 6 | 593 | 4 | 30.0572 | 107.874 | 2021-08-02 04:21:36 | Chongqing, China | ||
2021-07-31 | China | Gansu | 199 | 2 | 193 | 4 | 35.7518 | 104.2861 | 2021-08-01 04:21:50 | Gansu, China | ||
2021-07-31 | China | Chongqing | 603 | 6 | 593 | 4 | 30.0572 | 107.874 | 2021-08-01 04:21:50 | Chongqing, China | ||
2021-07-30 | China | Inner Mongolia | 403 | 1 | 398 | 4 | 44.0935 | 113.9448 | 2021-07-31 04:21:35 | Inner Mongolia, China | ||
2021-07-30 | China | Gansu | 199 | 2 | 193 | 4 | 35.7518 | 104.2861 | 2021-07-31 04:21:35 | Gansu, China | ||
2021-07-30 | China | Chongqing | 603 | 6 | 593 | 4 | 30.0572 | 107.874 | 2021-07-31 04:21:35 | Chongqing, China | ||
2021-07-29 | China | Gansu | 199 | 2 | 193 | 4 | 35.7518 | 104.2861 | 2021-07-30 04:21:34 | Gansu, China | ||
2021-07-29 | China | Chongqing | 603 | 6 | 593 | 4 | 30.0572 | 107.874 | 2021-07-30 04:21:34 | Chongqing, China | ||
2021-07-28 | Colombia | Vaupes | 1716 | 17 | 1695 | 4 | 0.8554 | -70.812 | 2021-07-29 04:21:33 | Vaupes, Colombia | ||
2021-07-28 | China | Gansu | 199 | 2 | 193 | 4 | 35.7518 | 104.2861 | 2021-07-29 04:21:33 | Gansu, China | ||
2021-07-27 | Colombia | Vaupes | 1716 | 17 | 1695 | 4 | 0.8554 | -70.812 | 2021-07-28 04:21:39 | Vaupes, Colombia | ||
2021-07-27 | China | Gansu | 199 | 2 | 193 | 4 | 35.7518 | 104.2861 | 2021-07-28 04:21:39 | Gansu, China | ||
2021-07-26 | Colombia | Vaupes | 1716 | 17 | 1695 | 4 | 0.8554 | -70.812 | 2021-07-27 04:21:18 | Vaupes, Colombia | ||
2021-07-25 | Colombia | Vaupes | 1716 | 17 | 1695 | 4 | 0.8554 | -70.812 | 2021-07-26 04:21:28 | Vaupes, Colombia | ||
2021-07-25 | Australia | Northern Territory | 192 | 0 | 188 | 4 | -12.4634 | 130.8456 | 2021-07-26 04:21:28 | Northern Territory, Australia | ||
2021-07-24 | Colombia | Vaupes | 1716 | 17 | 1695 | 4 | 0.8554 | -70.812 | 2021-07-25 04:22:12 | Vaupes, Colombia | ||
2021-07-24 | Australia | Northern Territory | 192 | 0 | 188 | 4 | -12.4634 | 130.8456 | 2021-07-25 04:22:12 | Northern Territory, Australia | ||
2021-07-23 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-24 00:21:36 | Liaoning, China | ||
2021-07-22 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-23 04:21:29 | Liaoning, China | ||
2021-07-21 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-22 04:21:19 | Liaoning, China | ||
2021-07-20 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-21 04:21:40 | Liaoning, China | ||
2021-07-19 | San Marino | 5096 | 90 | 5002 | 4 | 43.9424 | 12.4578 | 2021-07-20 04:21:48 | San Marino | |||
2021-07-19 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-20 04:21:48 | Liaoning, China | ||
2021-07-18 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-19 04:21:24 | Liaoning, China | ||
2021-07-18 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-19 04:21:24 | Anhui, China | ||
2021-07-17 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-18 04:22:07 | Liaoning, China | ||
2021-07-17 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-18 04:22:07 | Anhui, China | ||
2021-07-16 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-17 04:22:22 | Liaoning, China | ||
2021-07-16 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-17 04:22:22 | Inner Mongolia, China | ||
2021-07-16 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-17 04:22:22 | Anhui, China | ||
2021-07-15 | United Kingdom | Cayman Islands | 620 | 2 | 614 | 4 | 19.3133 | -81.2546 | 2021-07-16 04:21:22 | Cayman Islands, United Kingdom | ||
2021-07-15 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-16 04:21:22 | Liaoning, China | ||
2021-07-15 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-16 04:21:22 | Inner Mongolia, China | ||
2021-07-15 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-16 04:21:22 | Anhui, China | ||
2021-07-14 | United Kingdom | Cayman Islands | 620 | 2 | 614 | 4 | 19.3133 | -81.2546 | 2021-07-15 04:21:48 | Cayman Islands, United Kingdom | ||
2021-07-14 | China | Liaoning | 431 | 2 | 425 | 4 | 41.2956 | 122.6085 | 2021-07-15 04:21:48 | Liaoning, China | ||
2021-07-14 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-15 04:21:48 | Inner Mongolia, China | ||
2021-07-14 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-15 04:21:48 | Anhui, China | ||
2021-07-14 | Chad | 4955 | 174 | 4777 | 4 | 15.4542 | 18.7322 | 2021-07-15 04:21:48 | Chad | |||
2021-07-13 | United Kingdom | Cayman Islands | 619 | 2 | 613 | 4 | 19.3133 | -81.2546 | 2021-07-14 04:21:35 | Cayman Islands, United Kingdom | ||
2021-07-13 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-14 04:21:35 | Inner Mongolia, China | ||
2021-07-13 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-14 04:21:35 | Anhui, China | ||
2021-07-12 | United Kingdom | Cayman Islands | 619 | 2 | 613 | 4 | 19.3133 | -81.2546 | 2021-07-13 04:21:18 | Cayman Islands, United Kingdom | ||
2021-07-12 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-13 04:21:18 | Liaoning, China | ||
2021-07-12 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-13 04:21:18 | Inner Mongolia, China | ||
2021-07-12 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-13 04:21:18 | Anhui, China | ||
2021-07-11 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-12 04:21:34 | Liaoning, China | ||
2021-07-11 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-12 04:21:34 | Inner Mongolia, China | ||
2021-07-11 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-12 04:21:34 | Anhui, China | ||
2021-07-10 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-11 04:21:43 | Liaoning, China | ||
2021-07-10 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-11 04:21:43 | Anhui, China | ||
2021-07-09 | Japan | Ehime | 2755 | 75 | 2676 | 4 | 33.624835 | 132.856842 | 2021-07-10 04:21:25 | Ehime, Japan | ||
2021-07-09 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-10 04:21:25 | Liaoning, China | ||
2021-07-09 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-10 04:21:25 | Anhui, China | ||
2021-07-08 | Japan | Tokushima | 1658 | 63 | 1591 | 4 | 33.919178 | 134.242091 | 2021-07-09 04:21:21 | Tokushima, Japan | ||
2021-07-08 | Japan | Ehime | 2755 | 75 | 2676 | 4 | 33.624835 | 132.856842 | 2021-07-09 04:21:21 | Ehime, Japan | ||
2021-07-08 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-09 04:21:21 | Liaoning, China | ||
2021-07-08 | China | Chongqing | 601 | 6 | 591 | 4 | 30.0572 | 107.874 | 2021-07-09 04:21:21 | Chongqing, China | ||
2021-07-08 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-09 04:21:21 | Anhui, China | ||
2021-07-07 | United Kingdom | Cayman Islands | 615 | 2 | 609 | 4 | 19.3133 | -81.2546 | 2021-07-08 04:21:26 | Cayman Islands, United Kingdom | ||
2021-07-07 | Japan | Tokushima | 1658 | 63 | 1591 | 4 | 33.919178 | 134.242091 | 2021-07-08 04:21:26 | Tokushima, Japan | ||
2021-07-07 | Japan | Ehime | 2755 | 75 | 2676 | 4 | 33.624835 | 132.856842 | 2021-07-08 04:21:26 | Ehime, Japan | ||
2021-07-07 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-08 04:21:26 | Liaoning, China | ||
2021-07-07 | China | Chongqing | 601 | 6 | 591 | 4 | 30.0572 | 107.874 | 2021-07-08 04:21:26 | Chongqing, China | ||
2021-07-07 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-08 04:21:26 | Anhui, China | ||
2021-07-06 | United Kingdom | Cayman Islands | 615 | 2 | 609 | 4 | 19.3133 | -81.2546 | 2021-07-07 04:21:20 | Cayman Islands, United Kingdom | ||
2021-07-06 | Japan | Tokushima | 1658 | 63 | 1591 | 4 | 33.919178 | 134.242091 | 2021-07-07 04:21:20 | Tokushima, Japan | ||
2021-07-06 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-07 04:21:20 | Liaoning, China | ||
2021-07-06 | China | Chongqing | 601 | 6 | 591 | 4 | 30.0572 | 107.874 | 2021-07-07 04:21:20 | Chongqing, China | ||
2021-07-06 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-07 04:21:20 | Anhui, China | ||
2021-07-05 | China | Macau | 55 | 0 | 51 | 4 | 22.1667 | 113.55 | 2021-07-06 04:21:32 | Macau, China | ||
2021-07-05 | China | Liaoning | 430 | 2 | 424 | 4 | 41.2956 | 122.6085 | 2021-07-06 04:21:32 | Liaoning, China | ||
2021-07-05 | China | Henan | 1317 | 22 | 1291 | 4 | 33.882 | 113.614 | 2021-07-06 04:21:32 | Henan, China | ||
2021-07-05 | China | Chongqing | 601 | 6 | 591 | 4 | 30.0572 | 107.874 | 2021-07-06 04:21:32 | Chongqing, China | ||
2021-07-05 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-06 04:21:32 | Anhui, China | ||
2021-07-04 | China | Macau | 55 | 0 | 51 | 4 | 22.1667 | 113.55 | 2021-07-05 04:21:28 | Macau, China | ||
2021-07-04 | China | Henan | 1317 | 22 | 1291 | 4 | 33.882 | 113.614 | 2021-07-05 04:21:28 | Henan, China | ||
2021-07-04 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-05 04:21:28 | Anhui, China | ||
2021-07-03 | Japan | Tokushima | 1657 | 63 | 1590 | 4 | 33.919178 | 134.242091 | 2021-07-04 04:21:38 | Tokushima, Japan | ||
2021-07-03 | Djibouti | 11604 | 155 | 11445 | 4 | 11.8251 | 42.5903 | 2021-07-04 04:21:38 | Djibouti | |||
2021-07-03 | China | Macau | 55 | 0 | 51 | 4 | 22.1667 | 113.55 | 2021-07-04 04:21:38 | Macau, China | ||
2021-07-03 | China | Henan | 1317 | 22 | 1291 | 4 | 33.882 | 113.614 | 2021-07-04 04:21:38 | Henan, China | ||
2021-07-03 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-04 04:21:38 | Anhui, China | ||
2021-07-02 | Djibouti | 11602 | 155 | 11443 | 4 | 11.8251 | 42.5903 | 2021-07-03 04:21:37 | Djibouti | |||
2021-07-02 | China | Henan | 1317 | 22 | 1291 | 4 | 33.882 | 113.614 | 2021-07-03 04:21:37 | Henan, China | ||
2021-07-02 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-03 04:21:37 | Anhui, China | ||
2021-07-01 | Djibouti | 11602 | 155 | 11443 | 4 | 11.8251 | 42.5903 | 2021-07-02 04:21:47 | Djibouti | |||
2021-07-01 | China | Henan | 1317 | 22 | 1291 | 4 | 33.882 | 113.614 | 2021-07-02 04:21:47 | Henan, China | ||
2021-07-01 | China | Anhui | 1008 | 6 | 998 | 4 | 31.8257 | 117.2264 | 2021-07-02 04:21:47 | Anhui, China | ||
2021-06-30 | United Kingdom | British Virgin Islands | 298 | 1 | 293 | 4 | 18.4207 | -64.64 | 2021-07-01 04:21:19 | British Virgin Islands, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;