daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16,943 rows where active = 3 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
These facets timed out: province_or_state
country_or_region >30
- US 14,150
- China 769
- Japan 368
- United Kingdom 192
- Malaysia 167
- Canada 154
- Australia 146
- France 122
- Netherlands 95
- Antigua and Barbuda 50
- Denmark 48
- Fiji 47
- Laos 41
- Seychelles 34
- Brunei 33
- Liechtenstein 31
- Saint Kitts and Nevis 28
- Saint Vincent and the Grenadines 28
- India 27
- Saint Lucia 27
- Bhutan 25
- Cambodia 25
- Papua New Guinea 21
- Dominica 18
- Grenada 18
- Marshall Islands 16
- Chad 15
- Mauritius 15
- Suriname 14
- Colombia 13
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | United Kingdom | Falkland Islands (Malvinas) | 66 | 0 | 63 | 3 | -51.7963 | -59.5236 | 2021-08-05 04:21:51 | Falkland Islands (Malvinas), United Kingdom | ||
2021-07-31 | China | Shandong | 886 | 7 | 876 | 3 | 36.3427 | 118.1498 | 2021-08-01 04:21:50 | Shandong, China | ||
2021-07-26 | China | Gansu | 198 | 2 | 193 | 3 | 35.7518 | 104.2861 | 2021-07-27 04:21:18 | Gansu, China | ||
2021-07-26 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-27 04:21:18 | Chongqing, China | ||
2021-07-26 | Australia | Northern Territory | 192 | 0 | 189 | 3 | -12.4634 | 130.8456 | 2021-07-27 04:21:18 | Northern Territory, Australia | ||
2021-07-25 | China | Gansu | 198 | 2 | 193 | 3 | 35.7518 | 104.2861 | 2021-07-26 04:21:28 | Gansu, China | ||
2021-07-25 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-26 04:21:28 | Chongqing, China | ||
2021-07-24 | China | Gansu | 198 | 2 | 193 | 3 | 35.7518 | 104.2861 | 2021-07-25 04:22:12 | Gansu, China | ||
2021-07-24 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-25 04:22:12 | Chongqing, China | ||
2021-07-23 | China | Macau | 56 | 0 | 53 | 3 | 22.1667 | 113.55 | 2021-07-24 00:21:36 | Macau, China | ||
2021-07-23 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-24 00:21:36 | Chongqing, China | ||
2021-07-23 | Australia | Northern Territory | 191 | 0 | 188 | 3 | -12.4634 | 130.8456 | 2021-07-24 00:21:36 | Northern Territory, Australia | ||
2021-07-22 | China | Macau | 56 | 0 | 53 | 3 | 22.1667 | 113.55 | 2021-07-23 04:21:29 | Macau, China | ||
2021-07-22 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-23 04:21:29 | Chongqing, China | ||
2021-07-22 | Australia | Northern Territory | 191 | 0 | 188 | 3 | -12.4634 | 130.8456 | 2021-07-23 04:21:29 | Northern Territory, Australia | ||
2021-07-21 | China | Macau | 56 | 0 | 53 | 3 | 22.1667 | 113.55 | 2021-07-22 04:21:19 | Macau, China | ||
2021-07-21 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-22 04:21:19 | Chongqing, China | ||
2021-07-20 | Colombia | Vichada | 2746 | 45 | 2698 | 3 | 4.4234 | -69.2878 | 2021-07-21 04:21:40 | Vichada, Colombia | ||
2021-07-20 | Colombia | Vaupes | 1708 | 17 | 1688 | 3 | 0.8554 | -70.812 | 2021-07-21 04:21:40 | Vaupes, Colombia | ||
2021-07-20 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-21 04:21:40 | Chongqing, China | ||
2021-07-20 | China | Anhui | 1008 | 6 | 999 | 3 | 31.8257 | 117.2264 | 2021-07-21 04:21:40 | Anhui, China | ||
2021-07-19 | Colombia | Vaupes | 1704 | 17 | 1684 | 3 | 0.8554 | -70.812 | 2021-07-20 04:21:48 | Vaupes, Colombia | ||
2021-07-19 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-20 04:21:48 | Chongqing, China | ||
2021-07-19 | China | Anhui | 1008 | 6 | 999 | 3 | 31.8257 | 117.2264 | 2021-07-20 04:21:48 | Anhui, China | ||
2021-07-18 | United Kingdom | Cayman Islands | 622 | 2 | 617 | 3 | 19.3133 | -81.2546 | 2021-07-19 04:21:24 | Cayman Islands, United Kingdom | ||
2021-07-18 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-19 04:21:24 | Chongqing, China | ||
2021-07-17 | United Kingdom | Cayman Islands | 622 | 2 | 617 | 3 | 19.3133 | -81.2546 | 2021-07-18 04:22:07 | Cayman Islands, United Kingdom | ||
2021-07-17 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-18 04:22:07 | Chongqing, China | ||
2021-07-16 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-17 04:22:22 | Chongqing, China | ||
2021-07-15 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-16 04:21:22 | Chongqing, China | ||
2021-07-15 | Antigua and Barbuda | 1267 | 42 | 1222 | 3 | 17.0608 | -61.7964 | 2021-07-16 04:21:22 | Antigua and Barbuda | |||
2021-07-14 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-15 04:21:48 | Chongqing, China | ||
2021-07-14 | Canada | New Brunswick | 2336 | 46 | 2287 | 3 | 46.5653 | -66.4619 | 2021-07-15 04:21:48 | New Brunswick, Canada | ||
2021-07-14 | Antigua and Barbuda | 1267 | 42 | 1222 | 3 | 17.0608 | -61.7964 | 2021-07-15 04:21:48 | Antigua and Barbuda | |||
2021-07-13 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-14 04:21:35 | Chongqing, China | ||
2021-07-13 | Chad | 4954 | 174 | 4777 | 3 | 15.4542 | 18.7322 | 2021-07-14 04:21:35 | Chad | |||
2021-07-12 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-13 04:21:18 | Chongqing, China | ||
2021-07-12 | Chad | 4954 | 174 | 4777 | 3 | 15.4542 | 18.7322 | 2021-07-13 04:21:18 | Chad | |||
2021-07-11 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-12 04:21:34 | Chongqing, China | ||
2021-07-11 | Chad | 4954 | 174 | 4777 | 3 | 15.4542 | 18.7322 | 2021-07-12 04:21:34 | Chad | |||
2021-07-10 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-11 04:21:43 | Chongqing, China | ||
2021-07-10 | Chad | 4954 | 174 | 4777 | 3 | 15.4542 | 18.7322 | 2021-07-11 04:21:43 | Chad | |||
2021-07-09 | China | Chongqing | 601 | 6 | 592 | 3 | 30.0572 | 107.874 | 2021-07-10 04:21:25 | Chongqing, China | ||
2021-07-08 | Japan | Shimane | 556 | 2 | 551 | 3 | 35.07076 | 132.55406399999998 | 2021-07-09 04:21:21 | Shimane, Japan | ||
2021-07-06 | Dominica | 194 | 0 | 191 | 3 | 15.415 | -61.371 | 2021-07-07 04:21:20 | Dominica | |||
2021-07-06 | China | Macau | 55 | 0 | 52 | 3 | 22.1667 | 113.55 | 2021-07-07 04:21:20 | Macau, China | ||
2021-07-05 | Japan | Tokushima | 1657 | 63 | 1591 | 3 | 33.919178 | 134.242091 | 2021-07-06 04:21:32 | Tokushima, Japan | ||
2021-07-05 | Dominica | 194 | 0 | 191 | 3 | 15.415 | -61.371 | 2021-07-06 04:21:32 | Dominica | |||
2021-07-04 | Japan | Tokushima | 1657 | 63 | 1591 | 3 | 33.919178 | 134.242091 | 2021-07-05 04:21:28 | Tokushima, Japan | ||
2021-07-04 | Japan | Shimane | 553 | 1 | 549 | 3 | 35.07076 | 132.55406399999998 | 2021-07-05 04:21:28 | Shimane, Japan | ||
2021-07-04 | Dominica | 194 | 0 | 191 | 3 | 15.415 | -61.371 | 2021-07-05 04:21:28 | Dominica | |||
2021-07-04 | China | Liaoning | 429 | 2 | 424 | 3 | 41.2956 | 122.6085 | 2021-07-05 04:21:28 | Liaoning, China | ||
2021-07-03 | Japan | Shimane | 553 | 1 | 549 | 3 | 35.07076 | 132.55406399999998 | 2021-07-04 04:21:38 | Shimane, Japan | ||
2021-07-03 | Dominica | 194 | 0 | 191 | 3 | 15.415 | -61.371 | 2021-07-04 04:21:38 | Dominica | |||
2021-07-03 | China | Liaoning | 429 | 2 | 424 | 3 | 41.2956 | 122.6085 | 2021-07-04 04:21:38 | Liaoning, China | ||
2021-07-02 | Japan | Tokushima | 1656 | 63 | 1590 | 3 | 33.919178 | 134.242091 | 2021-07-03 04:21:37 | Tokushima, Japan | ||
2021-07-02 | Japan | Shimane | 553 | 1 | 549 | 3 | 35.07076 | 132.55406399999998 | 2021-07-03 04:21:37 | Shimane, Japan | ||
2021-07-02 | Dominica | 194 | 0 | 191 | 3 | 15.415 | -61.371 | 2021-07-03 04:21:37 | Dominica | |||
2021-07-02 | China | Macau | 54 | 0 | 51 | 3 | 22.1667 | 113.55 | 2021-07-03 04:21:37 | Macau, China | ||
2021-07-01 | Japan | Shimane | 553 | 1 | 549 | 3 | 35.07076 | 132.55406399999998 | 2021-07-02 04:21:47 | Shimane, Japan | ||
2021-07-01 | China | Macau | 54 | 0 | 51 | 3 | 22.1667 | 113.55 | 2021-07-02 04:21:47 | Macau, China | ||
2021-06-30 | Japan | Shimane | 553 | 1 | 549 | 3 | 35.07076 | 132.55406399999998 | 2021-07-01 04:21:19 | Shimane, Japan | ||
2021-06-30 | China | Macau | 54 | 0 | 51 | 3 | 22.1667 | 113.55 | 2021-07-01 04:21:19 | Macau, China | ||
2021-06-30 | China | Hubei | 68162 | 4512 | 63647 | 3 | 30.9756 | 112.2707 | 2021-07-01 04:21:19 | Hubei, China | ||
2021-06-29 | China | Macau | 54 | 0 | 51 | 3 | 22.1667 | 113.55 | 2021-06-30 04:21:41 | Macau, China | ||
2021-06-29 | China | Hubei | 68162 | 4512 | 63647 | 3 | 30.9756 | 112.2707 | 2021-06-30 04:21:41 | Hubei, China | ||
2021-06-28 | Japan | Shimane | 552 | 1 | 548 | 3 | 35.07076 | 132.55406399999998 | 2021-06-29 04:21:28 | Shimane, Japan | ||
2021-06-28 | Japan | Nagano | 5028 | 91 | 4934 | 3 | 36.132134 | 138.045528 | 2021-06-29 04:21:28 | Nagano, Japan | ||
2021-06-28 | China | Macau | 54 | 0 | 51 | 3 | 22.1667 | 113.55 | 2021-06-29 04:21:28 | Macau, China | ||
2021-06-28 | China | Inner Mongolia | 394 | 1 | 390 | 3 | 44.0935 | 113.9448 | 2021-06-29 04:21:28 | Inner Mongolia, China | ||
2021-06-27 | China | Inner Mongolia | 394 | 1 | 390 | 3 | 44.0935 | 113.9448 | 2021-06-28 04:21:29 | Inner Mongolia, China | ||
2021-06-26 | Dominica | 192 | 0 | 189 | 3 | 15.415 | -61.371 | 2021-06-27 04:21:39 | Dominica | |||
2021-06-26 | China | Inner Mongolia | 394 | 1 | 390 | 3 | 44.0935 | 113.9448 | 2021-06-27 04:21:39 | Inner Mongolia, China | ||
2021-06-26 | China | Hunan | 1054 | 4 | 1047 | 3 | 27.6104 | 111.7088 | 2021-06-27 04:21:39 | Hunan, China | ||
2021-06-26 | Australia | Western Australia | 1022 | 9 | 1010 | 3 | -31.9505 | 115.8605 | 2021-06-27 04:21:39 | Western Australia, Australia | ||
2021-06-25 | Japan | Shimane | 551 | 1 | 547 | 3 | 35.07076 | 132.55406399999998 | 2021-06-26 04:21:43 | Shimane, Japan | ||
2021-06-25 | Dominica | 192 | 0 | 189 | 3 | 15.415 | -61.371 | 2021-06-26 04:21:43 | Dominica | |||
2021-06-25 | China | Liaoning | 427 | 2 | 422 | 3 | 41.2956 | 122.6085 | 2021-06-26 04:21:43 | Liaoning, China | ||
2021-06-25 | China | Hunan | 1054 | 4 | 1047 | 3 | 27.6104 | 111.7088 | 2021-06-26 04:21:43 | Hunan, China | ||
2021-06-24 | Dominica | 192 | 0 | 189 | 3 | 15.415 | -61.371 | 2021-06-25 04:21:33 | Dominica | |||
2021-06-24 | Australia | Northern Territory | 177 | 0 | 174 | 3 | -12.4634 | 130.8456 | 2021-06-25 04:21:33 | Northern Territory, Australia | ||
2021-06-23 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-24 04:21:55 | Chongqing, China | ||
2021-06-23 | Australia | Northern Territory | 177 | 0 | 174 | 3 | -12.4634 | 130.8456 | 2021-06-24 04:21:55 | Northern Territory, Australia | ||
2021-06-22 | China | Liaoning | 426 | 2 | 421 | 3 | 41.2956 | 122.6085 | 2021-06-23 04:21:46 | Liaoning, China | ||
2021-06-22 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-23 04:21:46 | Chongqing, China | ||
2021-06-22 | Australia | Northern Territory | 177 | 0 | 174 | 3 | -12.4634 | 130.8456 | 2021-06-23 04:21:46 | Northern Territory, Australia | ||
2021-06-21 | China | Liaoning | 426 | 2 | 421 | 3 | 41.2956 | 122.6085 | 2021-06-22 04:21:34 | Liaoning, China | ||
2021-06-21 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-22 04:21:34 | Chongqing, China | ||
2021-06-20 | China | Liaoning | 426 | 2 | 421 | 3 | 41.2956 | 122.6085 | 2021-06-21 04:21:41 | Liaoning, China | ||
2021-06-20 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-21 04:21:41 | Chongqing, China | ||
2021-06-19 | China | Liaoning | 426 | 2 | 421 | 3 | 41.2956 | 122.6085 | 2021-06-20 04:21:48 | Liaoning, China | ||
2021-06-19 | China | Henan | 1316 | 22 | 1291 | 3 | 33.882 | 113.614 | 2021-06-20 04:21:48 | Henan, China | ||
2021-06-19 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-20 04:21:48 | Chongqing, China | ||
2021-06-18 | China | Liaoning | 426 | 2 | 421 | 3 | 41.2956 | 122.6085 | 2021-06-19 04:22:33 | Liaoning, China | ||
2021-06-18 | China | Henan | 1316 | 22 | 1291 | 3 | 33.882 | 113.614 | 2021-06-19 04:22:33 | Henan, China | ||
2021-06-18 | China | Chongqing | 598 | 6 | 589 | 3 | 30.0572 | 107.874 | 2021-06-19 04:22:33 | Chongqing, China | ||
2021-06-18 | Chad | 4945 | 174 | 4768 | 3 | 15.4542 | 18.7322 | 2021-06-19 04:22:33 | Chad | |||
2021-06-18 | Australia | Northern Territory | 176 | 0 | 173 | 3 | -12.4634 | 130.8456 | 2021-06-19 04:22:33 | Northern Territory, Australia | ||
2021-06-17 | China | Liaoning | 426 | 2 | 421 | 3 | 41.2956 | 122.6085 | 2021-06-18 04:22:16 | Liaoning, China | ||
2021-06-17 | China | Henan | 1316 | 22 | 1291 | 3 | 33.882 | 113.614 | 2021-06-18 04:22:16 | Henan, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;