johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,007 rows where active = 24 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 3,505
- Japan 120
- China 55
- United Kingdom 35
- Colombia 32
- Malaysia 29
- Canada 26
- India 15
- Australia 14
- New Zealand 13
- France 12
- Sao Tome and Principe 10
- Taiwan* 10
- Djibouti 9
- Netherlands 9
- Ukraine 9
- Russia 8
- Bahamas 7
- Germany 6
- Italy 6
- Comoros 5
- Chile 4
- Lesotho 4
- Saint Vincent and the Grenadines 4
- Barbados 3
- Cambodia 3
- Denmark 3
- Gambia 3
- Iceland 3
- Liberia 3
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683262 | 3683262 | 2021-08-02 | China | Hubei | 68201 | 4512 | 63665 | 24 | 30.9756 | 112.2707 | 2021-08-03 04:21:39 | Hubei, China | ||
3015293 | 3015293 | 2021-08-01 | India | Dadra and Nagar Haveli and Daman and Diu | 10650 | 4 | 10622 | 24 | 20.194742 | 73.080901 | 2021-08-02 04:21:36 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3015171 | 3015171 | 2021-08-01 | China | Shaanxi | 659 | 3 | 632 | 24 | 35.1917 | 108.8701 | 2021-08-02 04:21:36 | Shaanxi, China | ||
3295963 | 3295963 | 2021-07-30 | Chile | Aysen | 8053 | 70 | 7959 | 24 | -45.9864 | -73.7669 | 2021-07-31 04:21:35 | Aysen, Chile | ||
3218119 | 3218119 | 2021-07-26 | China | Shaanxi | 655 | 3 | 628 | 24 | 35.1917 | 108.8701 | 2021-07-27 04:21:18 | Shaanxi, China | ||
1378328 | 1378328 | 2021-07-25 | China | Shaanxi | 655 | 3 | 628 | 24 | 35.1917 | 108.8701 | 2021-07-26 04:21:28 | Shaanxi, China | ||
1330068 | 1330068 | 2021-07-24 | China | Shaanxi | 655 | 3 | 628 | 24 | 35.1917 | 108.8701 | 2021-07-25 04:22:12 | Shaanxi, China | ||
3476010 | 3476010 | 2021-07-22 | Australia | South Australia | 850 | 4 | 822 | 24 | -34.9285 | 138.6007 | 2021-07-23 04:21:29 | South Australia, Australia | ||
3331648 | 3331648 | 2021-07-21 | Netherlands | Bonaire, Sint Eustatius and Saba | 1683 | 17 | 1642 | 24 | 12.1784 | -68.2385 | 2021-07-22 04:21:19 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2371629 | 2371629 | 2021-07-20 | Netherlands | Bonaire, Sint Eustatius and Saba | 1683 | 17 | 1642 | 24 | 12.1784 | -68.2385 | 2021-07-21 04:21:40 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
483533 | 483533 | 2021-07-19 | India | Dadra and Nagar Haveli and Daman and Diu | 10605 | 4 | 10577 | 24 | 20.194742 | 73.080901 | 2021-07-20 04:21:48 | Dadra and Nagar Haveli and Daman and Diu, India | ||
3706122 | 3706122 | 2021-07-17 | Italy | Valle d'Aosta | 11710 | 473 | 11213 | 24 | 45.73750286 | 7.320149366 | 2021-07-18 04:22:07 | Valle d'Aosta, Italy | ||
296016 | 296016 | 2021-07-15 | Japan | Ehime | 2777 | 75 | 2678 | 24 | 33.624835 | 132.856842 | 2021-07-16 04:21:22 | Ehime, Japan | ||
578601 | 578601 | 2021-07-13 | Canada | Newfoundland and Labrador | 1407 | 7 | 1376 | 24 | 53.1355 | -57.6604 | 2021-07-14 04:21:35 | Newfoundland and Labrador, Canada | ||
3741098 | 3741098 | 2021-07-12 | Japan | Kagoshima | 3740 | 39 | 3677 | 24 | 31.009484000000004 | 130.430665 | 2021-07-13 04:21:18 | Kagoshima, Japan | ||
3659637 | 3659637 | 2021-07-11 | Japan | Toyama | 2058 | 38 | 1996 | 24 | 36.637464 | 137.26934599999998 | 2021-07-12 04:21:34 | Toyama, Japan | ||
3659351 | 3659351 | 2021-07-11 | Burkina Faso | 13509 | 168 | 13317 | 24 | 12.2383 | -1.5616 | 2021-07-12 04:21:34 | Burkina Faso | |||
625921 | 625921 | 2021-07-10 | Japan | Toyama | 2058 | 38 | 1996 | 24 | 36.637464 | 137.26934599999998 | 2021-07-11 04:21:43 | Toyama, Japan | ||
625905 | 625905 | 2021-07-10 | Japan | Nara | 8324 | 132 | 8168 | 24 | 34.317451 | 135.871644 | 2021-07-11 04:21:43 | Nara, Japan | ||
829640 | 829640 | 2021-07-09 | Japan | Toyama | 2057 | 38 | 1995 | 24 | 36.637464 | 137.26934599999998 | 2021-07-10 04:21:25 | Toyama, Japan | ||
778404 | 778404 | 2021-07-08 | Japan | Toyama | 2056 | 38 | 1994 | 24 | 36.637464 | 137.26934599999998 | 2021-07-09 04:21:21 | Toyama, Japan | ||
778378 | 778378 | 2021-07-08 | Japan | Kagoshima | 3716 | 39 | 3653 | 24 | 31.009484000000004 | 130.430665 | 2021-07-09 04:21:21 | Kagoshima, Japan | ||
778358 | 778358 | 2021-07-08 | Italy | Valle d'Aosta | 11699 | 473 | 11202 | 24 | 45.73750286 | 7.320149366 | 2021-07-09 04:21:21 | Valle d'Aosta, Italy | ||
1932556 | 1932556 | 2021-07-05 | Netherlands | Curacao | 12349 | 126 | 12199 | 24 | 12.1696 | -68.99 | 2021-07-06 04:21:32 | Curacao, Netherlands | ||
1932454 | 1932454 | 2021-07-05 | Japan | Kagoshima | 3699 | 39 | 3636 | 24 | 31.009484000000004 | 130.430665 | 2021-07-06 04:21:32 | Kagoshima, Japan | ||
1165287 | 1165287 | 2021-07-04 | Netherlands | Curacao | 12349 | 126 | 12199 | 24 | 12.1696 | -68.99 | 2021-07-05 04:21:28 | Curacao, Netherlands | ||
1165015 | 1165015 | 2021-07-04 | Colombia | Guainia | 2091 | 24 | 2043 | 24 | 2.5854 | -68.5247 | 2021-07-05 04:21:28 | Guainia, Colombia | ||
1495721 | 1495721 | 2021-07-03 | Netherlands | Curacao | 12349 | 126 | 12199 | 24 | 12.1696 | -68.99 | 2021-07-04 04:21:38 | Curacao, Netherlands | ||
2764780 | 2764780 | 2021-07-01 | Colombia | Guainia | 2049 | 23 | 2002 | 24 | 2.5854 | -68.5247 | 2021-07-02 04:21:47 | Guainia, Colombia | ||
1893251 | 1893251 | 2021-06-30 | Monaco | 2577 | 33 | 2520 | 24 | 43.7333 | 7.4167 | 2021-07-01 04:21:19 | Monaco | |||
1892988 | 1892988 | 2021-06-30 | Colombia | Guainia | 2042 | 23 | 1995 | 24 | 2.5854 | -68.5247 | 2021-07-01 04:21:19 | Guainia, Colombia | ||
400157 | 400157 | 2021-06-29 | France | French Polynesia | 19003 | 142 | 18837 | 24 | -17.6797 | -149.4068 | 2021-06-30 04:21:41 | French Polynesia, France | ||
3129187 | 3129187 | 2021-06-28 | Malaysia | Perlis | 589 | 8 | 557 | 24 | 6.4449 | 100.2048 | 2021-06-29 04:21:28 | Perlis, Malaysia | ||
3125626 | 3125626 | 2021-06-28 | Netherlands | Curacao | 12332 | 126 | 12182 | 24 | 12.1696 | -68.99 | 2021-06-29 04:21:28 | Curacao, Netherlands | ||
3125400 | 3125400 | 2021-06-28 | France | French Polynesia | 19003 | 142 | 18837 | 24 | -17.6797 | -149.4068 | 2021-06-29 04:21:28 | French Polynesia, France | ||
3125354 | 3125354 | 2021-06-28 | Colombia | Guainia | 2040 | 23 | 1993 | 24 | 2.5854 | -68.5247 | 2021-06-29 04:21:28 | Guainia, Colombia | ||
2590019 | 2590019 | 2021-06-27 | Japan | Kagoshima | 3662 | 38 | 3600 | 24 | 31.009484000000004 | 130.430665 | 2021-06-28 04:21:29 | Kagoshima, Japan | ||
2589895 | 2589895 | 2021-06-27 | France | French Polynesia | 18994 | 142 | 18828 | 24 | -17.6797 | -149.4068 | 2021-06-28 04:21:29 | French Polynesia, France | ||
2589849 | 2589849 | 2021-06-27 | Colombia | Guainia | 2039 | 23 | 1992 | 24 | 2.5854 | -68.5247 | 2021-06-28 04:21:29 | Guainia, Colombia | ||
3958399 | 3958399 | 2021-06-26 | France | French Polynesia | 18994 | 142 | 18828 | 24 | -17.6797 | -149.4068 | 2021-06-27 04:21:39 | French Polynesia, France | ||
1712349 | 1712349 | 2021-06-25 | Japan | Miyazaki | 3069 | 27 | 3018 | 24 | 32.193203999999994 | 131.299374 | 2021-06-26 04:21:43 | Miyazaki, Japan | ||
1712327 | 1712327 | 2021-06-25 | Japan | Aomori | 2465 | 31 | 2410 | 24 | 40.781541 | 140.828896 | 2021-06-26 04:21:43 | Aomori, Japan | ||
1712218 | 1712218 | 2021-06-25 | France | French Polynesia | 18994 | 142 | 18828 | 24 | -17.6797 | -149.4068 | 2021-06-26 04:21:43 | French Polynesia, France | ||
2295466 | 2295466 | 2021-06-24 | Japan | Kagawa | 2084 | 30 | 2030 | 24 | 34.217292 | 133.969047 | 2021-06-25 04:21:33 | Kagawa, Japan | ||
2423025 | 2423025 | 2021-06-23 | New Zealand | 2723 | 28 | 2673 | 24 | -40.9006 | 174.886 | 2021-06-24 04:21:55 | New Zealand | |||
563102 | 563102 | 2021-06-22 | New Zealand | 2723 | 28 | 2673 | 24 | -40.9006 | 174.886 | 2021-06-23 04:21:46 | New Zealand | |||
107478 | 107478 | 2021-06-19 | Japan | Nara | 8018 | 124 | 7870 | 24 | 34.317451 | 135.871644 | 2021-06-20 04:21:48 | Nara, Japan | ||
2911197 | 2911197 | 2021-06-17 | Japan | Nagano | 4949 | 90 | 4835 | 24 | 36.132134 | 138.045528 | 2021-06-18 04:22:16 | Nagano, Japan | ||
2911036 | 2911036 | 2021-06-17 | Colombia | Vaupes | 1642 | 14 | 1604 | 24 | 0.8554 | -70.812 | 2021-06-18 04:22:16 | Vaupes, Colombia | ||
3030517 | 3030517 | 2021-06-16 | Russia | Nenets Autonomous Okrug | 1135 | 4 | 1107 | 24 | 68.27557185 | 57.1686375 | 2021-06-17 04:22:36 | Nenets Autonomous Okrug, Russia | ||
3030424 | 3030424 | 2021-06-16 | New Zealand | 2713 | 28 | 2663 | 24 | -40.9006 | 174.886 | 2021-06-17 04:22:36 | New Zealand | |||
1736513 | 1736513 | 2021-06-12 | Japan | Ehime | 2736 | 75 | 2637 | 24 | 33.624835 | 132.856842 | 2021-06-13 04:22:44 | Ehime, Japan | ||
3970555 | 3970555 | 2021-06-11 | Japan | Fukui | 1062 | 34 | 1004 | 24 | 35.846614 | 136.22465400000002 | 2021-06-12 04:22:22 | Fukui, Japan | ||
522991 | 522991 | 2021-06-09 | New Zealand | 2697 | 28 | 2647 | 24 | -40.9006 | 174.886 | 2021-06-10 04:23:17 | New Zealand | |||
522862 | 522862 | 2021-06-09 | Japan | Fukui | 1058 | 34 | 1000 | 24 | 35.846614 | 136.22465400000002 | 2021-06-10 04:23:17 | Fukui, Japan | ||
3472431 | 3472431 | 2021-06-08 | New Zealand | 2696 | 28 | 2646 | 24 | -40.9006 | 174.886 | 2021-06-09 04:23:31 | New Zealand | |||
3472190 | 3472190 | 2021-06-08 | France | French Polynesia | 18902 | 142 | 18736 | 24 | -17.6797 | -149.4068 | 2021-06-09 04:23:31 | French Polynesia, France | ||
829232 | 829232 | 2021-06-06 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 24 | 49.3723 | -2.3644 | 2021-06-07 04:22:51 | Channel Islands, United Kingdom | ||
825488 | 825488 | 2021-06-06 | Gambia | 5999 | 179 | 5796 | 24 | 13.4432 | -15.3101 | 2021-06-07 04:22:51 | Gambia | |||
2589637 | 2589637 | 2021-06-05 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 24 | 49.3723 | -2.3644 | 2021-06-06 04:24:03 | Channel Islands, United Kingdom | ||
2585893 | 2585893 | 2021-06-05 | Gambia | 5999 | 179 | 5796 | 24 | 13.4432 | -15.3101 | 2021-06-06 04:24:03 | Gambia | |||
2318951 | 2318951 | 2021-06-04 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 24 | 49.3723 | -2.3644 | 2021-06-05 04:23:03 | Channel Islands, United Kingdom | ||
2315207 | 2315207 | 2021-06-04 | Gambia | 5999 | 179 | 5796 | 24 | 13.4432 | -15.3101 | 2021-06-05 04:23:03 | Gambia | |||
1452236 | 1452236 | 2021-06-03 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 24 | 49.3723 | -2.3644 | 2021-06-04 04:23:37 | Channel Islands, United Kingdom | ||
1711960 | 1711960 | 2021-06-02 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 24 | 49.3723 | -2.3644 | 2021-06-03 04:23:32 | Channel Islands, United Kingdom | ||
2107778 | 2107778 | 2021-06-01 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 24 | 49.3723 | -2.3644 | 2021-06-02 04:24:34 | Channel Islands, United Kingdom | ||
1192394 | 1192394 | 2021-05-31 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 24 | 49.3723 | -2.3644 | 2021-06-01 04:23:09 | Channel Islands, United Kingdom | ||
82793 | 82793 | 2021-05-25 | Australia | Queensland | 1611 | 7 | 1580 | 24 | -27.4698 | 153.0251 | 2021-05-26 04:20:35 | Queensland, Australia | ||
726255 | 726255 | 2021-05-22 | Burkina Faso | 13414 | 165 | 13225 | 24 | 12.2383 | -1.5616 | 2021-05-23 04:20:51 | Burkina Faso | |||
1952706 | 1952706 | 2021-05-21 | Russia | Chukotka Autonomous Okrug | 764 | 7 | 733 | 24 | 66.0006475 | 169.4900869 | 2021-05-22 04:20:45 | Chukotka Autonomous Okrug, Russia | ||
1952377 | 1952377 | 2021-05-21 | Colombia | Vaupes | 1422 | 14 | 1384 | 24 | 0.8554 | -70.812 | 2021-05-22 04:20:45 | Vaupes, Colombia | ||
1913466 | 1913466 | 2021-05-20 | Russia | Tyva Republic | 15902 | 203 | 15675 | 24 | 51.4017149 | 93.8582593 | 2021-05-21 04:20:43 | Tyva Republic, Russia | ||
2255866 | 2255866 | 2021-05-19 | New Zealand | 2659 | 28 | 2609 | 24 | -40.9006 | 174.886 | 2021-05-20 04:21:05 | New Zealand | |||
2255793 | 2255793 | 2021-05-19 | Liberia | 2131 | 85 | 2022 | 24 | 6.4280550000000005 | -9.429499 | 2021-05-20 04:21:05 | Liberia | |||
2390904 | 2390904 | 2021-05-18 | New Zealand | 2658 | 28 | 2608 | 24 | -40.9006 | 174.886 | 2021-05-19 04:20:42 | New Zealand | |||
2390650 | 2390650 | 2021-05-18 | Djibouti | 11455 | 151 | 11280 | 24 | 11.8251 | 42.5903 | 2021-05-19 04:20:42 | Djibouti | |||
3574366 | 3574366 | 2021-05-17 | Canada | Northwest Territories | 121 | 0 | 101 | 24 | 64.8255 | -124.8457 | 2021-05-18 04:20:33 | Northwest Territories,Canada | ||
2939219 | 2939219 | 2021-05-16 | France | French Polynesia | 18815 | 141 | 18650 | 24 | -17.6797 | -149.4068 | 2021-05-17 04:20:34 | French Polynesia, France | ||
1872849 | 1872849 | 2021-05-15 | France | French Polynesia | 18815 | 141 | 18650 | 24 | -17.6797 | -149.4068 | 2021-05-16 04:20:49 | French Polynesia, France | ||
1872821 | 1872821 | 2021-05-15 | Colombia | Vichada | 1618 | 25 | 1569 | 24 | 4.4234 | -69.2878 | 2021-05-16 04:20:49 | Vichada, Colombia | ||
1081818 | 1081818 | 2021-05-14 | France | French Polynesia | 18815 | 141 | 18650 | 24 | -17.6797 | -149.4068 | 2021-05-15 04:20:58 | French Polynesia, France | ||
3958179 | 3958179 | 2021-05-11 | Malaysia | W.P. Labuan | 2490 | 12 | 2454 | 24 | 5.2831 | 115.2308 | 2021-05-12 04:21:29 | W.P. Labuan, Malaysia | ||
3954323 | 3954323 | 2021-05-11 | China | Zhejiang | 1347 | 1 | 1322 | 24 | 29.1832 | 120.0934 | 2021-05-12 04:21:29 | Zhejiang, China | ||
1428749 | 1428749 | 2021-05-09 | United Kingdom | British Virgin Islands | 216 | 1 | 191 | 24 | 18.4207 | -64.64 | 2021-05-10 04:20:38 | British Virgin Islands, United Kingdom | ||
1555658 | 1555658 | 2021-05-08 | Malaysia | W.P. Labuan | 2478 | 12 | 2442 | 24 | 5.2831 | 115.2308 | 2021-05-09 04:20:35 | W.P. Labuan, Malaysia | ||
1555617 | 1555617 | 2021-05-08 | United Kingdom | British Virgin Islands | 216 | 1 | 191 | 24 | 18.4207 | -64.64 | 2021-05-09 04:20:35 | British Virgin Islands, United Kingdom | ||
2505675 | 2505675 | 2021-05-07 | United Kingdom | British Virgin Islands | 216 | 1 | 191 | 24 | 18.4207 | -64.64 | 2021-05-08 04:21:04 | British Virgin Islands, United Kingdom | ||
2502299 | 2502299 | 2021-05-07 | Sao Tome and Principe | 2317 | 35 | 2258 | 24 | 0.1864 | 6.6131 | 2021-05-08 04:21:04 | Sao Tome and Principe | |||
2501877 | 2501877 | 2021-05-07 | Colombia | Guaviare | 2423 | 40 | 2359 | 24 | 1.0654 | -73.2603 | 2021-05-08 04:21:04 | Guaviare, Colombia | ||
3117131 | 3117131 | 2021-05-06 | United Kingdom | British Virgin Islands | 216 | 1 | 191 | 24 | 18.4207 | -64.64 | 2021-05-07 04:20:40 | British Virgin Islands, United Kingdom | ||
3113755 | 3113755 | 2021-05-06 | Sao Tome and Principe | 2317 | 35 | 2258 | 24 | 0.1864 | 6.6131 | 2021-05-07 04:20:40 | Sao Tome and Principe | |||
649598 | 649598 | 2021-05-05 | United Kingdom | British Virgin Islands | 216 | 1 | 191 | 24 | 18.4207 | -64.64 | 2021-05-06 04:20:38 | British Virgin Islands, United Kingdom | ||
645845 | 645845 | 2021-05-05 | France | French Polynesia | 18775 | 141 | 18610 | 24 | -17.6797 | -149.4068 | 2021-05-06 04:20:38 | French Polynesia, France | ||
3679298 | 3679298 | 2021-05-04 | United Kingdom | British Virgin Islands | 216 | 1 | 191 | 24 | 18.4207 | -64.64 | 2021-05-05 04:20:43 | British Virgin Islands, United Kingdom | ||
3675780 | 3675780 | 2021-05-04 | Netherlands | Sint Maarten | 2240 | 27 | 2189 | 24 | 18.0425 | -63.0548 | 2021-05-05 04:20:43 | Sint Maarten, Netherlands | ||
3675545 | 3675545 | 2021-05-04 | France | French Polynesia | 18771 | 141 | 18606 | 24 | -17.6797 | -149.4068 | 2021-05-05 04:20:43 | French Polynesia, France | ||
3675518 | 3675518 | 2021-05-04 | Comoros | 3846 | 146 | 3676 | 24 | -11.6455 | 43.3333 | 2021-05-05 04:20:43 | Comoros | |||
3675453 | 3675453 | 2021-05-04 | China | Fujian | 593 | 1 | 568 | 24 | 26.0789 | 117.9874 | 2021-05-05 04:20:43 | Fujian, China | ||
2764565 | 2764565 | 2021-05-03 | United Kingdom | British Virgin Islands | 216 | 1 | 191 | 24 | 18.4207 | -64.64 | 2021-05-04 04:20:34 | British Virgin Islands, United Kingdom | ||
2761052 | 2761052 | 2021-05-03 | New Zealand | 2623 | 28 | 2573 | 24 | -40.9006 | 174.886 | 2021-05-04 04:20:34 | New Zealand |
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]);