johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,430 rows where active = 2 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 >30
- US 16,085
- China 774
- Japan 482
- United Kingdom 249
- Malaysia 236
- Canada 190
- Australia 141
- France 122
- Saint Kitts and Nevis 99
- Kiribati 76
- Dominica 70
- Grenada 64
- Denmark 61
- Mauritius 53
- Netherlands 51
- Brunei 48
- Vanuatu 46
- Colombia 44
- Cambodia 36
- Fiji 34
- San Marino 34
- Solomon Islands 32
- Laos 31
- India 26
- Lesotho 25
- Antigua and Barbuda 24
- Saint Vincent and the Grenadines 23
- Bhutan 21
- Saint Lucia 20
- Timor-Leste 20
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
335554 | 335554 | 2021-08-04 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-05 04:21:51 | Anguilla, United Kingdom | ||
331958 | 331958 | 2021-08-04 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-05 04:21:51 | Kiribati | |||
331832 | 331832 | 2021-08-04 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-05 04:21:51 | Grenada | |||
331806 | 331806 | 2021-08-04 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-05 04:21:51 | Saint Pierre and Miquelon, France | ||
331710 | 331710 | 2021-08-04 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-05 04:21:51 | Guangxi, China | ||
3471825 | 3471825 | 2021-08-03 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-04 04:21:25 | Anguilla, United Kingdom | ||
3468229 | 3468229 | 2021-08-03 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-04 04:21:25 | Kiribati | |||
3468103 | 3468103 | 2021-08-03 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-04 04:21:25 | Grenada | |||
3468077 | 3468077 | 2021-08-03 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-04 04:21:25 | Saint Pierre and Miquelon, France | ||
3467981 | 3467981 | 2021-08-03 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-04 04:21:25 | Guangxi, China | ||
3687099 | 3687099 | 2021-08-02 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-03 04:21:39 | Anguilla, United Kingdom | ||
3683503 | 3683503 | 2021-08-02 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-03 04:21:39 | Kiribati | |||
3683377 | 3683377 | 2021-08-02 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-03 04:21:39 | Grenada | |||
3683351 | 3683351 | 2021-08-02 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-03 04:21:39 | Saint Pierre and Miquelon, France | ||
3683255 | 3683255 | 2021-08-02 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-03 04:21:39 | Guangxi, China | ||
3018998 | 3018998 | 2021-08-01 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-02 04:21:36 | Anguilla, United Kingdom | ||
3015402 | 3015402 | 2021-08-01 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-02 04:21:36 | Kiribati | |||
3015276 | 3015276 | 2021-08-01 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-02 04:21:36 | Grenada | |||
3015250 | 3015250 | 2021-08-01 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-02 04:21:36 | Saint Pierre and Miquelon, France | ||
3015154 | 3015154 | 2021-08-01 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-02 04:21:36 | Guangxi, China | ||
3907621 | 3907621 | 2021-07-31 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-08-01 04:21:50 | Anguilla, United Kingdom | ||
3904025 | 3904025 | 2021-07-31 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-08-01 04:21:50 | Kiribati | |||
3903981 | 3903981 | 2021-07-31 | Japan | Gifu | 9589 | 188 | 9399 | 2 | 35.778671 | 137.055925 | 2021-08-01 04:21:50 | Gifu, Japan | ||
3903899 | 3903899 | 2021-07-31 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-08-01 04:21:50 | Grenada | |||
3903873 | 3903873 | 2021-07-31 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-08-01 04:21:50 | Saint Pierre and Miquelon, France | ||
3903779 | 3903779 | 2021-07-31 | China | Hainan | 189 | 6 | 181 | 2 | 19.1959 | 109.7453 | 2021-08-01 04:21:50 | Hainan, China | ||
3903777 | 3903777 | 2021-07-31 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-08-01 04:21:50 | Guangxi, China | ||
3299826 | 3299826 | 2021-07-30 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-31 04:21:35 | Anguilla, United Kingdom | ||
3296230 | 3296230 | 2021-07-30 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-31 04:21:35 | Kiribati | |||
3296104 | 3296104 | 2021-07-30 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-31 04:21:35 | Grenada | |||
3296078 | 3296078 | 2021-07-30 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-31 04:21:35 | Saint Pierre and Miquelon, France | ||
3296000 | 3296000 | 2021-07-30 | China | Shandong | 885 | 7 | 876 | 2 | 36.3427 | 118.1498 | 2021-07-31 04:21:35 | Shandong, China | ||
3295982 | 3295982 | 2021-07-30 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-31 04:21:35 | Guangxi, China | ||
3389037 | 3389037 | 2021-07-29 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-30 04:21:34 | Anguilla, United Kingdom | ||
3385441 | 3385441 | 2021-07-29 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-30 04:21:34 | Kiribati | |||
3385315 | 3385315 | 2021-07-29 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-30 04:21:34 | Grenada | |||
3385289 | 3385289 | 2021-07-29 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-30 04:21:34 | Saint Pierre and Miquelon, France | ||
3385211 | 3385211 | 2021-07-29 | China | Shandong | 885 | 7 | 876 | 2 | 36.3427 | 118.1498 | 2021-07-30 04:21:34 | Shandong, China | ||
3385193 | 3385193 | 2021-07-29 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-30 04:21:34 | Guangxi, China | ||
411942 | 411942 | 2021-07-28 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-29 04:21:33 | Anguilla, United Kingdom | ||
408346 | 408346 | 2021-07-28 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-29 04:21:33 | Kiribati | |||
408220 | 408220 | 2021-07-28 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-29 04:21:33 | Grenada | |||
408194 | 408194 | 2021-07-28 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-29 04:21:33 | Saint Pierre and Miquelon, France | ||
408098 | 408098 | 2021-07-28 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-29 04:21:33 | Guangxi, China | ||
408094 | 408094 | 2021-07-28 | China | Chongqing | 601 | 6 | 593 | 2 | 30.0572 | 107.874 | 2021-07-29 04:21:33 | Chongqing, China | ||
1309803 | 1309803 | 2021-07-27 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-28 04:21:39 | Anguilla, United Kingdom | ||
1306207 | 1306207 | 2021-07-27 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-28 04:21:39 | Kiribati | |||
1306081 | 1306081 | 2021-07-27 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-28 04:21:39 | Grenada | |||
1306055 | 1306055 | 2021-07-27 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-28 04:21:39 | Saint Pierre and Miquelon, France | ||
1305959 | 1305959 | 2021-07-27 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-28 04:21:39 | Guangxi, China | ||
1305955 | 1305955 | 2021-07-27 | China | Chongqing | 601 | 6 | 593 | 2 | 30.0572 | 107.874 | 2021-07-28 04:21:39 | Chongqing, China | ||
1305852 | 1305852 | 2021-07-27 | Australia | Northern Territory | 192 | 0 | 190 | 2 | -12.4634 | 130.8456 | 2021-07-28 04:21:39 | Northern Territory, Australia | ||
3221946 | 3221946 | 2021-07-26 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-27 04:21:18 | Anguilla, United Kingdom | ||
3218350 | 3218350 | 2021-07-26 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-27 04:21:18 | Kiribati | |||
3218224 | 3218224 | 2021-07-26 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-27 04:21:18 | Grenada | |||
3218198 | 3218198 | 2021-07-26 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-27 04:21:18 | Saint Pierre and Miquelon, France | ||
3218102 | 3218102 | 2021-07-26 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-27 04:21:18 | Guangxi, China | ||
1382155 | 1382155 | 2021-07-25 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-26 04:21:28 | Anguilla, United Kingdom | ||
1378559 | 1378559 | 2021-07-25 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-26 04:21:28 | Kiribati | |||
1378433 | 1378433 | 2021-07-25 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-26 04:21:28 | Grenada | |||
1378407 | 1378407 | 2021-07-25 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-26 04:21:28 | Saint Pierre and Miquelon, France | ||
1378311 | 1378311 | 2021-07-25 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-26 04:21:28 | Guangxi, China | ||
1333895 | 1333895 | 2021-07-24 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-25 04:22:12 | Anguilla, United Kingdom | ||
1330299 | 1330299 | 2021-07-24 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-25 04:22:12 | Kiribati | |||
1330173 | 1330173 | 2021-07-24 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-25 04:22:12 | Grenada | |||
1330147 | 1330147 | 2021-07-24 | France | Saint Pierre and Miquelon | 28 | 0 | 26 | 2 | 46.8852 | -56.3159 | 2021-07-25 04:22:12 | Saint Pierre and Miquelon, France | ||
1330051 | 1330051 | 2021-07-24 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-25 04:22:12 | Guangxi, China | ||
1330045 | 1330045 | 2021-07-24 | China | Anhui | 1008 | 6 | 1000 | 2 | 31.8257 | 117.2264 | 2021-07-25 04:22:12 | Anhui, China | ||
3141199 | 3141199 | 2021-07-23 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-24 00:21:36 | Anguilla, United Kingdom | ||
3137603 | 3137603 | 2021-07-23 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-24 00:21:36 | Kiribati | |||
3137477 | 3137477 | 2021-07-23 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-24 00:21:36 | Grenada | |||
3137355 | 3137355 | 2021-07-23 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-24 00:21:36 | Guangxi, China | ||
3137353 | 3137353 | 2021-07-23 | China | Gansu | 197 | 2 | 193 | 2 | 35.7518 | 104.2861 | 2021-07-24 00:21:36 | Gansu, China | ||
3137349 | 3137349 | 2021-07-23 | China | Anhui | 1008 | 6 | 1000 | 2 | 31.8257 | 117.2264 | 2021-07-24 00:21:36 | Anhui, China | ||
3479959 | 3479959 | 2021-07-22 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-23 04:21:29 | Anguilla, United Kingdom | ||
3476363 | 3476363 | 2021-07-22 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-23 04:21:29 | Kiribati | |||
3476237 | 3476237 | 2021-07-22 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-23 04:21:29 | Grenada | |||
3476115 | 3476115 | 2021-07-22 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-23 04:21:29 | Guangxi, China | ||
3476113 | 3476113 | 2021-07-22 | China | Gansu | 197 | 2 | 193 | 2 | 35.7518 | 104.2861 | 2021-07-23 04:21:29 | Gansu, China | ||
3476109 | 3476109 | 2021-07-22 | China | Anhui | 1008 | 6 | 1000 | 2 | 31.8257 | 117.2264 | 2021-07-23 04:21:29 | Anhui, China | ||
3335178 | 3335178 | 2021-07-21 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-22 04:21:19 | Anguilla, United Kingdom | ||
3331582 | 3331582 | 2021-07-21 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-22 04:21:19 | Kiribati | |||
3331456 | 3331456 | 2021-07-21 | Grenada | 164 | 1 | 161 | 2 | 12.1165 | -61.679 | 2021-07-22 04:21:19 | Grenada | |||
3331334 | 3331334 | 2021-07-21 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-22 04:21:19 | Guangxi, China | ||
3331332 | 3331332 | 2021-07-21 | China | Gansu | 197 | 2 | 193 | 2 | 35.7518 | 104.2861 | 2021-07-22 04:21:19 | Gansu, China | ||
3331328 | 3331328 | 2021-07-21 | China | Anhui | 1008 | 6 | 1000 | 2 | 31.8257 | 117.2264 | 2021-07-22 04:21:19 | Anhui, China | ||
2375159 | 2375159 | 2021-07-20 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-21 04:21:40 | Anguilla, United Kingdom | ||
2371563 | 2371563 | 2021-07-20 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-21 04:21:40 | Kiribati | |||
2371329 | 2371329 | 2021-07-20 | China | Macau | 55 | 0 | 53 | 2 | 22.1667 | 113.55 | 2021-07-21 04:21:40 | Macau, China | ||
2371315 | 2371315 | 2021-07-20 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-21 04:21:40 | Guangxi, China | ||
487238 | 487238 | 2021-07-19 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-20 04:21:48 | Anguilla, United Kingdom | ||
483642 | 483642 | 2021-07-19 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-20 04:21:48 | Kiribati | |||
483408 | 483408 | 2021-07-19 | China | Macau | 55 | 0 | 53 | 2 | 22.1667 | 113.55 | 2021-07-20 04:21:48 | Macau, China | ||
483394 | 483394 | 2021-07-19 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-20 04:21:48 | Guangxi, China | ||
2674085 | 2674085 | 2021-07-18 | San Marino | 5094 | 90 | 5002 | 2 | 43.9424 | 12.4578 | 2021-07-19 04:21:24 | San Marino | |||
2673865 | 2673865 | 2021-07-18 | Kiribati | 2 | 0 | 0 | 2 | -3.3704 | -168.734 | 2021-07-19 04:21:24 | Kiribati | |||
2673631 | 2673631 | 2021-07-18 | China | Macau | 55 | 0 | 53 | 2 | 22.1667 | 113.55 | 2021-07-19 04:21:24 | Macau, China | ||
2673617 | 2673617 | 2021-07-18 | China | Guangxi | 277 | 2 | 273 | 2 | 23.8298 | 108.7881 | 2021-07-19 04:21:24 | Guangxi, China | ||
2673505 | 2673505 | 2021-07-18 | Antigua and Barbuda | 1268 | 42 | 1224 | 2 | 17.0608 | -61.7964 | 2021-07-19 04:21:24 | Antigua and Barbuda | |||
3706397 | 3706397 | 2021-07-17 | San Marino | 5094 | 90 | 5002 | 2 | 43.9424 | 12.4578 | 2021-07-18 04:22:07 | San Marino |
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]);