daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
5,118 rows where active = 17 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 >30
- US 4,366
- China 145
- Japan 132
- United Kingdom 49
- Malaysia 38
- Colombia 36
- Canada 35
- Australia 33
- France 28
- Comoros 17
- Niger 16
- Italy 15
- India 14
- Netherlands 14
- San Marino 14
- Barbados 12
- Sao Tome and Principe 11
- Antigua and Barbuda 9
- Djibouti 9
- Chile 8
- Dominica 8
- Denmark 7
- New Zealand 7
- Laos 6
- Timor-Leste 6
- Ukraine 6
- Angola 5
- Botswana 5
- Cambodia 5
- Brunei 4
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | China | Shandong | 900 | 7 | 876 | 17 | 36.3427 | 118.1498 | 2021-08-05 04:21:51 | Shandong, China | ||
2021-08-02 | Japan | Gifu | 9633 | 188 | 9428 | 17 | 35.778671 | 137.055925 | 2021-08-03 04:21:39 | Gifu, Japan | ||
2021-07-29 | Antigua and Barbuda | 1295 | 43 | 1235 | 17 | 17.0608 | -61.7964 | 2021-07-30 04:21:34 | Antigua and Barbuda | |||
2021-07-28 | China | Henan | 1331 | 22 | 1292 | 17 | 33.882 | 113.614 | 2021-07-29 04:21:33 | Henan, China | ||
2021-07-27 | United Kingdom | Bermuda | 2538 | 33 | 2488 | 17 | 32.3078 | -64.7505 | 2021-07-28 04:21:39 | Bermuda, United Kingdom | ||
2021-07-27 | Japan | Nagano | 5173 | 94 | 5062 | 17 | 36.132134 | 138.045528 | 2021-07-28 04:21:39 | Nagano, Japan | ||
2021-07-26 | United Kingdom | Bermuda | 2538 | 33 | 2488 | 17 | 32.3078 | -64.7505 | 2021-07-27 04:21:18 | Bermuda, United Kingdom | ||
2021-07-26 | China | Tianjin | 418 | 3 | 398 | 17 | 39.3054 | 117.323 | 2021-07-27 04:21:18 | Tianjin, China | ||
2021-07-26 | China | Henan | 1330 | 22 | 1291 | 17 | 33.882 | 113.614 | 2021-07-27 04:21:18 | Henan, China | ||
2021-07-25 | United Kingdom | Bermuda | 2538 | 33 | 2488 | 17 | 32.3078 | -64.7505 | 2021-07-26 04:21:28 | Bermuda, United Kingdom | ||
2021-07-25 | China | Tianjin | 418 | 3 | 398 | 17 | 39.3054 | 117.323 | 2021-07-26 04:21:28 | Tianjin, China | ||
2021-07-25 | China | Henan | 1330 | 22 | 1291 | 17 | 33.882 | 113.614 | 2021-07-26 04:21:28 | Henan, China | ||
2021-07-24 | United Kingdom | Bermuda | 2538 | 33 | 2488 | 17 | 32.3078 | -64.7505 | 2021-07-25 04:22:12 | Bermuda, United Kingdom | ||
2021-07-24 | China | Tianjin | 418 | 3 | 398 | 17 | 39.3054 | 117.323 | 2021-07-25 04:22:12 | Tianjin, China | ||
2021-07-22 | China | Tianjin | 416 | 3 | 396 | 17 | 39.3054 | 117.323 | 2021-07-23 04:21:29 | Tianjin, China | ||
2021-07-21 | China | Tianjin | 415 | 3 | 395 | 17 | 39.3054 | 117.323 | 2021-07-22 04:21:19 | Tianjin, China | ||
2021-07-20 | China | Tianjin | 415 | 3 | 395 | 17 | 39.3054 | 117.323 | 2021-07-21 04:21:40 | Tianjin, China | ||
2021-07-19 | China | Tianjin | 415 | 3 | 395 | 17 | 39.3054 | 117.323 | 2021-07-20 04:21:48 | Tianjin, China | ||
2021-07-16 | China | Tianjin | 412 | 3 | 392 | 17 | 39.3054 | 117.323 | 2021-07-17 04:22:22 | Tianjin, China | ||
2021-07-15 | Japan | Tokushima | 1675 | 63 | 1595 | 17 | 33.919178 | 134.242091 | 2021-07-16 04:21:22 | Tokushima, Japan | ||
2021-07-15 | Japan | Kagoshima | 3753 | 39 | 3697 | 17 | 31.009484000000004 | 130.430665 | 2021-07-16 04:21:22 | Kagoshima, Japan | ||
2021-07-15 | China | Tianjin | 412 | 3 | 392 | 17 | 39.3054 | 117.323 | 2021-07-16 04:21:22 | Tianjin, China | ||
2021-07-14 | Japan | Tokushima | 1673 | 63 | 1593 | 17 | 33.919178 | 134.242091 | 2021-07-15 04:21:48 | Tokushima, Japan | ||
2021-07-13 | Japan | Nara | 8364 | 132 | 8215 | 17 | 34.317451 | 135.871644 | 2021-07-14 04:21:35 | Nara, Japan | ||
2021-07-09 | Netherlands | Sint Maarten | 2633 | 34 | 2582 | 17 | 18.0425 | -63.0548 | 2021-07-10 04:21:25 | Sint Maarten, Netherlands | ||
2021-07-09 | Australia | South Australia | 816 | 4 | 795 | 17 | -34.9285 | 138.6007 | 2021-07-10 04:21:25 | South Australia, Australia | ||
2021-07-08 | Netherlands | Sint Maarten | 2633 | 34 | 2582 | 17 | 18.0425 | -63.0548 | 2021-07-09 04:21:21 | Sint Maarten, Netherlands | ||
2021-07-06 | Malaysia | Perlis | 599 | 8 | 574 | 17 | 6.4449 | 100.2048 | 2021-07-07 04:21:20 | Perlis, Malaysia | ||
2021-07-05 | Sao Tome and Principe | 2377 | 37 | 2323 | 17 | 0.1864 | 6.6131 | 2021-07-06 04:21:32 | Sao Tome and Principe | |||
2021-07-05 | Monaco | 2589 | 33 | 2539 | 17 | 43.7333 | 7.4167 | 2021-07-06 04:21:32 | Monaco | |||
2021-07-04 | Monaco | 2587 | 33 | 2537 | 17 | 43.7333 | 7.4167 | 2021-07-05 04:21:28 | Monaco | |||
2021-07-04 | Australia | South Australia | 813 | 4 | 792 | 17 | -34.9285 | 138.6007 | 2021-07-05 04:21:28 | South Australia, Australia | ||
2021-06-30 | United Kingdom | Cayman Islands | 614 | 2 | 595 | 17 | 19.3133 | -81.2546 | 2021-07-01 04:21:19 | Cayman Islands, United Kingdom | ||
2021-06-29 | United Kingdom | Cayman Islands | 614 | 2 | 595 | 17 | 19.3133 | -81.2546 | 2021-06-30 04:21:41 | Cayman Islands, United Kingdom | ||
2021-06-28 | United Kingdom | Cayman Islands | 614 | 2 | 595 | 17 | 19.3133 | -81.2546 | 2021-06-29 04:21:28 | Cayman Islands, United Kingdom | ||
2021-06-27 | United Kingdom | Cayman Islands | 609 | 2 | 590 | 17 | 19.3133 | -81.2546 | 2021-06-28 04:21:29 | Cayman Islands, United Kingdom | ||
2021-06-26 | United Kingdom | Cayman Islands | 609 | 2 | 590 | 17 | 19.3133 | -81.2546 | 2021-06-27 04:21:39 | Cayman Islands, United Kingdom | ||
2021-06-25 | United Kingdom | Cayman Islands | 609 | 2 | 590 | 17 | 19.3133 | -81.2546 | 2021-06-26 04:21:43 | Cayman Islands, United Kingdom | ||
2021-06-25 | Japan | Ehime | 2752 | 75 | 2660 | 17 | 33.624835 | 132.856842 | 2021-06-26 04:21:43 | Ehime, Japan | ||
2021-06-23 | United Kingdom | Turks and Caicos Islands | 2424 | 18 | 2389 | 17 | 21.694000000000006 | -71.7979 | 2021-06-24 04:21:55 | Turks and Caicos Islands, United Kingdom | ||
2021-06-23 | Canada | Newfoundland and Labrador | 1384 | 7 | 1360 | 17 | 53.1355 | -57.6604 | 2021-06-24 04:21:55 | Newfoundland and Labrador, Canada | ||
2021-06-22 | United Kingdom | Turks and Caicos Islands | 2424 | 18 | 2389 | 17 | 21.694000000000006 | -71.7979 | 2021-06-23 04:21:46 | Turks and Caicos Islands, United Kingdom | ||
2021-06-22 | Canada | Newfoundland and Labrador | 1384 | 7 | 1360 | 17 | 53.1355 | -57.6604 | 2021-06-23 04:21:46 | Newfoundland and Labrador, Canada | ||
2021-06-21 | United Kingdom | Turks and Caicos Islands | 2424 | 18 | 2389 | 17 | 21.694000000000006 | -71.7979 | 2021-06-22 04:21:34 | Turks and Caicos Islands, United Kingdom | ||
2021-06-20 | United Kingdom | Turks and Caicos Islands | 2424 | 18 | 2389 | 17 | 21.694000000000006 | -71.7979 | 2021-06-21 04:21:41 | Turks and Caicos Islands, United Kingdom | ||
2021-06-20 | Japan | Nara | 8030 | 125 | 7888 | 17 | 34.317451 | 135.871644 | 2021-06-21 04:21:41 | Nara, Japan | ||
2021-06-20 | Comoros | 3908 | 146 | 3745 | 17 | -11.6455 | 43.3333 | 2021-06-21 04:21:41 | Comoros | |||
2021-06-20 | China | Shaanxi | 624 | 3 | 604 | 17 | 35.1917 | 108.8701 | 2021-06-21 04:21:41 | Shaanxi, China | ||
2021-06-19 | United Kingdom | Gibraltar | 4319 | 94 | 4208 | 17 | 36.1408 | -5.3536 | 2021-06-20 04:21:48 | Gibraltar, United Kingdom | ||
2021-06-19 | Comoros | 3908 | 146 | 3745 | 17 | -11.6455 | 43.3333 | 2021-06-20 04:21:48 | Comoros | |||
2021-06-19 | China | Shaanxi | 624 | 3 | 604 | 17 | 35.1917 | 108.8701 | 2021-06-20 04:21:48 | Shaanxi, China | ||
2021-06-18 | China | Shaanxi | 624 | 3 | 604 | 17 | 35.1917 | 108.8701 | 2021-06-19 04:22:33 | Shaanxi, China | ||
2021-06-17 | United Kingdom | Gibraltar | 4317 | 94 | 4206 | 17 | 36.1408 | -5.3536 | 2021-06-18 04:22:16 | Gibraltar, United Kingdom | ||
2021-06-17 | Denmark | Faroe Islands | 758 | 1 | 740 | 17 | 61.8926 | -6.9118 | 2021-06-18 04:22:16 | Faroe Islands, Denmark | ||
2021-06-16 | Denmark | Faroe Islands | 757 | 1 | 739 | 17 | 61.8926 | -6.9118 | 2021-06-17 04:22:36 | Faroe Islands, Denmark | ||
2021-06-15 | Comoros | 3901 | 146 | 3738 | 17 | -11.6455 | 43.3333 | 2021-06-16 04:22:32 | Comoros | |||
2021-06-15 | China | Shaanxi | 622 | 3 | 602 | 17 | 35.1917 | 108.8701 | 2021-06-16 04:22:32 | Shaanxi, China | ||
2021-06-15 | China | Jiangsu | 738 | 0 | 721 | 17 | 32.9711 | 119.455 | 2021-06-16 04:22:32 | Jiangsu, China | ||
2021-06-14 | Japan | Shimane | 550 | 0 | 533 | 17 | 35.07076 | 132.55406399999998 | 2021-06-15 04:22:22 | Shimane, Japan | ||
2021-06-14 | Comoros | 3901 | 146 | 3738 | 17 | -11.6455 | 43.3333 | 2021-06-15 04:22:22 | Comoros | |||
2021-06-14 | China | Shaanxi | 622 | 3 | 602 | 17 | 35.1917 | 108.8701 | 2021-06-15 04:22:22 | Shaanxi, China | ||
2021-06-13 | Russia | Nenets Autonomous Okrug | 1127 | 4 | 1106 | 17 | 68.27557185 | 57.1686375 | 2021-06-14 04:22:46 | Nenets Autonomous Okrug, Russia | ||
2021-06-13 | Japan | Shimane | 550 | 0 | 533 | 17 | 35.07076 | 132.55406399999998 | 2021-06-14 04:22:46 | Shimane, Japan | ||
2021-06-13 | Japan | Akita | 763 | 19 | 727 | 17 | 39.748679 | 140.408228 | 2021-06-14 04:22:46 | Akita, Japan | ||
2021-06-13 | Djibouti | 11572 | 154 | 11401 | 17 | 11.8251 | 42.5903 | 2021-06-14 04:22:46 | Djibouti | |||
2021-06-13 | Comoros | 3899 | 146 | 3736 | 17 | -11.6455 | 43.3333 | 2021-06-14 04:22:46 | Comoros | |||
2021-06-13 | China | Shaanxi | 622 | 3 | 602 | 17 | 35.1917 | 108.8701 | 2021-06-14 04:22:46 | Shaanxi, China | ||
2021-06-12 | Djibouti | 11572 | 154 | 11401 | 17 | 11.8251 | 42.5903 | 2021-06-13 04:22:44 | Djibouti | |||
2021-06-12 | Comoros | 3899 | 146 | 3736 | 17 | -11.6455 | 43.3333 | 2021-06-13 04:22:44 | Comoros | |||
2021-06-11 | China | Shaanxi | 621 | 3 | 601 | 17 | 35.1917 | 108.8701 | 2021-06-12 04:22:22 | Shaanxi, China | ||
2021-06-10 | Djibouti | 11570 | 154 | 11399 | 17 | 11.8251 | 42.5903 | 2021-06-11 04:23:20 | Djibouti | |||
2021-06-09 | China | Shaanxi | 620 | 3 | 600 | 17 | 35.1917 | 108.8701 | 2021-06-10 04:23:17 | Shaanxi, China | ||
2021-06-08 | China | Yunnan | 361 | 2 | 342 | 17 | 24.974 | 101.487 | 2021-06-09 04:23:31 | Yunnan, China | ||
2021-06-07 | United Kingdom | Turks and Caicos Islands | 2421 | 17 | 2387 | 17 | 21.694000000000006 | -71.7979 | 2021-06-08 04:22:35 | Turks and Caicos Islands, United Kingdom | ||
2021-06-06 | United Kingdom | Turks and Caicos Islands | 2421 | 17 | 2387 | 17 | 21.694000000000006 | -71.7979 | 2021-06-07 04:22:51 | Turks and Caicos Islands, United Kingdom | ||
2021-06-06 | New Zealand | 2682 | 28 | 2639 | 17 | -40.9006 | 174.886 | 2021-06-07 04:22:51 | New Zealand | |||
2021-06-06 | China | Shaanxi | 618 | 3 | 598 | 17 | 35.1917 | 108.8701 | 2021-06-07 04:22:51 | Shaanxi, China | ||
2021-06-05 | United Kingdom | Turks and Caicos Islands | 2420 | 17 | 2386 | 17 | 21.694000000000006 | -71.7979 | 2021-06-06 04:24:03 | Turks and Caicos Islands, United Kingdom | ||
2021-06-05 | New Zealand | 2682 | 28 | 2639 | 17 | -40.9006 | 174.886 | 2021-06-06 04:24:03 | New Zealand | |||
2021-06-05 | Djibouti | 11556 | 154 | 11385 | 17 | 11.8251 | 42.5903 | 2021-06-06 04:24:03 | Djibouti | |||
2021-06-04 | New Zealand | 2682 | 28 | 2639 | 17 | -40.9006 | 174.886 | 2021-06-05 04:23:03 | New Zealand | |||
2021-06-04 | Burkina Faso | 13447 | 167 | 13263 | 17 | 12.2383 | -1.5616 | 2021-06-05 04:23:03 | Burkina Faso | |||
2021-06-03 | United Kingdom | Bermuda | 2494 | 33 | 2444 | 17 | 32.3078 | -64.7505 | 2021-06-04 04:23:37 | Bermuda, United Kingdom | ||
2021-06-03 | New Zealand | 2682 | 28 | 2639 | 17 | -40.9006 | 174.886 | 2021-06-04 04:23:37 | New Zealand | |||
2021-06-03 | China | Yunnan | 355 | 2 | 336 | 17 | 24.974 | 101.487 | 2021-06-04 04:23:37 | Yunnan, China | ||
2021-06-03 | Australia | Queensland | 1621 | 7 | 1597 | 17 | -27.4698 | 153.0251 | 2021-06-04 04:23:37 | Queensland, Australia | ||
2021-06-02 | New Zealand | 2681 | 28 | 2638 | 17 | -40.9006 | 174.886 | 2021-06-03 04:23:32 | New Zealand | |||
2021-06-02 | China | Shaanxi | 616 | 3 | 596 | 17 | 35.1917 | 108.8701 | 2021-06-03 04:23:32 | Shaanxi, China | ||
2021-06-01 | Netherlands | Bonaire, Sint Eustatius and Saba | 1614 | 17 | 1580 | 17 | 12.1784 | -68.2385 | 2021-06-02 04:24:34 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2021-06-01 | China | Shaanxi | 616 | 3 | 596 | 17 | 35.1917 | 108.8701 | 2021-06-02 04:24:34 | Shaanxi, China | ||
2021-05-31 | New Zealand | 2673 | 28 | 2630 | 17 | -40.9006 | 174.886 | 2021-06-01 04:23:09 | New Zealand | |||
2021-05-31 | Netherlands | Bonaire, Sint Eustatius and Saba | 1613 | 17 | 1579 | 17 | 12.1784 | -68.2385 | 2021-06-01 04:23:09 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2021-05-31 | France | French Polynesia | 18870 | 142 | 18711 | 17 | -17.6797 | -149.4068 | 2021-06-01 04:23:09 | French Polynesia, France | ||
2021-05-30 | United Kingdom | Turks and Caicos Islands | 2415 | 17 | 2381 | 17 | 21.694000000000006 | -71.7979 | 2021-05-31 03:08:59 | Turks and Caicos Islands, United Kingdom | ||
2021-05-30 | Sao Tome and Principe | 2345 | 37 | 2291 | 17 | 0.1864 | 6.6131 | 2021-05-31 03:08:59 | Sao Tome and Principe | |||
2021-05-30 | New Zealand | 2673 | 28 | 2630 | 17 | -40.9006 | 174.886 | 2021-05-31 03:08:59 | New Zealand | |||
2021-05-29 | Sao Tome and Principe | 2345 | 37 | 2291 | 17 | 0.1864 | 6.6131 | 2021-05-30 04:20:55 | Sao Tome and Principe | |||
2021-05-28 | Comoros | 3879 | 146 | 3716 | 17 | -11.6455 | 43.3333 | 2021-05-29 04:20:41 | Comoros | |||
2021-05-27 | Sao Tome and Principe | 2338 | 37 | 2284 | 17 | 0.1864 | 6.6131 | 2021-05-28 04:20:36 | Sao Tome and Principe | |||
2021-05-27 | Comoros | 3879 | 146 | 3716 | 17 | -11.6455 | 43.3333 | 2021-05-28 04:20:36 | Comoros |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;