johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,368 rows where active = 22 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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331781 | 331781 | 2021-08-04 | Denmark | Faroe Islands | 987 | 2 | 963 | 22 | 61.8926 | -6.9118 | 2021-08-05 04:21:51 | Faroe Islands, Denmark | ||
331705 | 331705 | 2021-08-04 | China | Beijing | 1099 | 9 | 1068 | 22 | 40.1824 | 116.4142 | 2021-08-05 04:21:51 | Beijing, China | ||
3015176 | 3015176 | 2021-08-01 | China | Tianjin | 425 | 3 | 400 | 22 | 39.3054 | 117.323 | 2021-08-02 04:21:36 | Tianjin, China | ||
3015162 | 3015162 | 2021-08-01 | China | Hunan | 1090 | 4 | 1064 | 22 | 27.6104 | 111.7088 | 2021-08-02 04:21:36 | Hunan, China | ||
3903799 | 3903799 | 2021-07-31 | China | Tianjin | 425 | 3 | 400 | 22 | 39.3054 | 117.323 | 2021-08-01 04:21:50 | Tianjin, China | ||
3295999 | 3295999 | 2021-07-30 | China | Shaanxi | 656 | 3 | 631 | 22 | 35.1917 | 108.8701 | 2021-07-31 04:21:35 | Shaanxi, China | ||
3218344 | 3218344 | 2021-07-26 | Japan | Yamagata | 2092 | 47 | 2023 | 22 | 38.448396 | 140.102154 | 2021-07-27 04:21:18 | Yamagata, Japan | ||
3476345 | 3476345 | 2021-07-22 | Japan | Saga | 2629 | 24 | 2583 | 22 | 33.286977 | 130.115738 | 2021-07-23 04:21:29 | Saga, Japan | ||
2371528 | 2371528 | 2021-07-20 | Japan | Kagoshima | 3784 | 39 | 3723 | 22 | 31.009484000000004 | 130.430665 | 2021-07-21 04:21:40 | Kagoshima, Japan | ||
483708 | 483708 | 2021-07-19 | Netherlands | Bonaire, Sint Eustatius and Saba | 1672 | 17 | 1633 | 22 | 12.1784 | -68.2385 | 2021-07-20 04:21:48 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2673931 | 2673931 | 2021-07-18 | Netherlands | Bonaire, Sint Eustatius and Saba | 1672 | 17 | 1633 | 22 | 12.1784 | -68.2385 | 2021-07-19 04:21:24 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2673829 | 2673829 | 2021-07-18 | Japan | Kagawa | 2131 | 31 | 2078 | 22 | 34.217292 | 133.969047 | 2021-07-19 04:21:24 | Kagawa, Japan | ||
2947380 | 2947380 | 2021-07-16 | Japan | Miyazaki | 3111 | 27 | 3062 | 22 | 32.193203999999994 | 131.299374 | 2021-07-17 04:22:22 | Miyazaki, Japan | ||
2947353 | 2947353 | 2021-07-16 | Italy | Valle d'Aosta | 11708 | 473 | 11213 | 22 | 45.73750286 | 7.320149366 | 2021-07-17 04:22:22 | Valle d'Aosta, Italy | ||
296036 | 296036 | 2021-07-15 | Japan | Miyazaki | 3111 | 27 | 3062 | 22 | 32.193203999999994 | 131.299374 | 2021-07-16 04:21:22 | Miyazaki, Japan | ||
295955 | 295955 | 2021-07-15 | India | Dadra and Nagar Haveli and Daman and Diu | 10591 | 4 | 10565 | 22 | 20.194742 | 73.080901 | 2021-07-16 04:21:22 | Dadra and Nagar Haveli and Daman and Diu, India | ||
295783 | 295783 | 2021-07-15 | Canada | Nova Scotia | 5870 | 92 | 5756 | 22 | 44.682 | -63.7443 | 2021-07-16 04:21:22 | Nova Scotia, Canada | ||
3635618 | 3635618 | 2021-07-14 | United Kingdom | Turks and Caicos Islands | 2440 | 18 | 2400 | 22 | 21.694000000000006 | -71.7979 | 2021-07-15 04:21:48 | Turks and Caicos Islands, United Kingdom | ||
3631973 | 3631973 | 2021-07-14 | Japan | Kagawa | 2122 | 31 | 2069 | 22 | 34.217292 | 133.969047 | 2021-07-15 04:21:48 | Kagawa, Japan | ||
3631900 | 3631900 | 2021-07-14 | India | Dadra and Nagar Haveli and Daman and Diu | 10591 | 4 | 10565 | 22 | 20.194742 | 73.080901 | 2021-07-15 04:21:48 | Dadra and Nagar Haveli and Daman and Diu, India | ||
578589 | 578589 | 2021-07-13 | Burkina Faso | 13523 | 168 | 13333 | 22 | 12.2383 | -1.5616 | 2021-07-14 04:21:35 | Burkina Faso | |||
3741078 | 3741078 | 2021-07-12 | Italy | Valle d'Aosta | 11702 | 473 | 11207 | 22 | 45.73750286 | 7.320149366 | 2021-07-13 04:21:18 | Valle d'Aosta, Italy | ||
3659723 | 3659723 | 2021-07-11 | Netherlands | Sint Maarten | 2638 | 34 | 2582 | 22 | 18.0425 | -63.0548 | 2021-07-12 04:21:34 | Sint Maarten, Netherlands | ||
3659591 | 3659591 | 2021-07-11 | Italy | Valle d'Aosta | 11702 | 473 | 11207 | 22 | 45.73750286 | 7.320149366 | 2021-07-12 04:21:34 | Valle d'Aosta, Italy | ||
626007 | 626007 | 2021-07-10 | Netherlands | Sint Maarten | 2638 | 34 | 2582 | 22 | 18.0425 | -63.0548 | 2021-07-11 04:21:43 | Sint Maarten, Netherlands | ||
1440610 | 1440610 | 2021-07-07 | Japan | Nara | 8269 | 132 | 8115 | 22 | 34.317451 | 135.871644 | 2021-07-08 04:21:26 | Nara, Japan | ||
1440580 | 1440580 | 2021-07-07 | Italy | Valle d'Aosta | 11697 | 473 | 11202 | 22 | 45.73750286 | 7.320149366 | 2021-07-08 04:21:26 | Valle d'Aosta, Italy | ||
2693961 | 2693961 | 2021-07-06 | Sao Tome and Principe | 2383 | 37 | 2324 | 22 | 0.1864 | 6.6131 | 2021-07-07 04:21:20 | Sao Tome and Principe | |||
2693685 | 2693685 | 2021-07-06 | Italy | Valle d'Aosta | 11696 | 473 | 11201 | 22 | 45.73750286 | 7.320149366 | 2021-07-07 04:21:20 | Valle d'Aosta, Italy | ||
1164936 | 1164936 | 2021-07-04 | Canada | New Brunswick | 2337 | 46 | 2269 | 22 | 46.5653 | -66.4619 | 2021-07-05 04:21:28 | New Brunswick, Canada | ||
2075597 | 2075597 | 2021-07-02 | Malaysia | Perlis | 595 | 8 | 565 | 22 | 6.4449 | 100.2048 | 2021-07-03 04:21:37 | Perlis, Malaysia | ||
2071934 | 2071934 | 2021-07-02 | Japan | Kagoshima | 3689 | 38 | 3629 | 22 | 31.009484000000004 | 130.430665 | 2021-07-03 04:21:37 | Kagoshima, Japan | ||
2071853 | 2071853 | 2021-07-02 | India | Andaman and Nicobar Islands | 7475 | 128 | 7325 | 22 | 11.225999 | 92.968178 | 2021-07-03 04:21:37 | Andaman and Nicobar Islands, India | ||
2768589 | 2768589 | 2021-07-01 | United Kingdom | Isle of Man | 1620 | 29 | 1569 | 22 | 54.2361 | -4.5481 | 2021-07-02 04:21:47 | Isle of Man, United Kingdom | ||
1896821 | 1896821 | 2021-06-30 | Malaysia | Perlis | 594 | 8 | 564 | 22 | 6.4449 | 100.2048 | 2021-07-01 04:21:19 | Perlis, Malaysia | ||
1893158 | 1893158 | 2021-06-30 | Japan | Kagoshima | 3674 | 38 | 3614 | 22 | 31.009484000000004 | 130.430665 | 2021-07-01 04:21:19 | Kagoshima, Japan | ||
2590018 | 2590018 | 2021-06-27 | Japan | Kagawa | 2092 | 30 | 2040 | 22 | 34.217292 | 133.969047 | 2021-06-28 04:21:29 | Kagawa, Japan | ||
1712371 | 1712371 | 2021-06-25 | Japan | Yamagata | 2020 | 47 | 1951 | 22 | 38.448396 | 140.102154 | 2021-06-26 04:21:43 | Yamagata, Japan | ||
2426544 | 2426544 | 2021-06-23 | United Kingdom | Gibraltar | 4332 | 94 | 4216 | 22 | 36.1408 | -5.3536 | 2021-06-24 04:21:55 | Gibraltar, United Kingdom | ||
2422914 | 2422914 | 2021-06-23 | Japan | Miyazaki | 3063 | 27 | 3014 | 22 | 32.193203999999994 | 131.299374 | 2021-06-24 04:21:55 | Miyazaki, Japan | ||
107586 | 107586 | 2021-06-19 | New Zealand | 2718 | 28 | 2670 | 22 | -40.9006 | 174.886 | 2021-06-20 04:21:48 | New Zealand | |||
2911194 | 2911194 | 2021-06-17 | Japan | Mie | 5163 | 109 | 5032 | 22 | 34.508018 | 136.376013 | 2021-06-18 04:22:16 | Mie, Japan | ||
2911176 | 2911176 | 2021-06-17 | Japan | Ehime | 2745 | 75 | 2648 | 22 | 33.624835 | 132.856842 | 2021-06-18 04:22:16 | Ehime, Japan | ||
1564132 | 1564132 | 2021-06-14 | Japan | Tokushima | 1646 | 63 | 1561 | 22 | 33.919178 | 134.242091 | 2021-06-15 04:22:22 | Tokushima, Japan | ||
3381415 | 3381415 | 2021-06-13 | Japan | Tokushima | 1646 | 63 | 1561 | 22 | 33.919178 | 134.242091 | 2021-06-14 04:22:46 | Tokushima, Japan | ||
3970380 | 3970380 | 2021-06-11 | China | Yunnan | 369 | 2 | 345 | 22 | 24.974 | 101.487 | 2021-06-12 04:22:22 | Yunnan, China | ||
2716977 | 2716977 | 2021-06-10 | Japan | Fukui | 1059 | 34 | 1003 | 22 | 35.846614 | 136.22465400000002 | 2021-06-11 04:23:20 | Fukui, Japan | ||
522899 | 522899 | 2021-06-09 | Japan | Tottori | 466 | 2 | 442 | 22 | 35.359069 | 133.863619 | 2021-06-10 04:23:17 | Tottori, Japan | ||
522565 | 522565 | 2021-06-09 | Barbados | 4032 | 47 | 3963 | 22 | 13.1939 | -59.5432 | 2021-06-10 04:23:17 | Barbados | |||
3145715 | 3145715 | 2021-06-07 | New Zealand | 2692 | 28 | 2644 | 22 | -40.9006 | 174.886 | 2021-06-08 04:22:35 | New Zealand | |||
3145460 | 3145460 | 2021-06-07 | Djibouti | 11565 | 154 | 11389 | 22 | 11.8251 | 42.5903 | 2021-06-08 04:22:35 | Djibouti | |||
825623 | 825623 | 2021-06-06 | Japan | Tokushima | 1636 | 63 | 1551 | 22 | 33.919178 | 134.242091 | 2021-06-07 04:22:51 | Tokushima, Japan | ||
2585852 | 2585852 | 2021-06-05 | Colombia | Vaupes | 1578 | 14 | 1542 | 22 | 0.8554 | -70.812 | 2021-06-06 04:24:03 | Vaupes, Colombia | ||
1448706 | 1448706 | 2021-06-03 | Netherlands | Curacao | 12276 | 122 | 12132 | 22 | 12.1696 | -68.99 | 2021-06-04 04:23:37 | Curacao, Netherlands | ||
2104022 | 2104022 | 2021-06-01 | France | French Polynesia | 18875 | 142 | 18711 | 22 | -17.6797 | -149.4068 | 2021-06-02 04:24:34 | French Polynesia, France | ||
2103993 | 2103993 | 2021-06-01 | Colombia | Vaupes | 1535 | 14 | 1499 | 22 | 0.8554 | -70.812 | 2021-06-02 04:24:34 | Vaupes, Colombia | ||
1188609 | 1188609 | 2021-05-31 | Colombia | Vaupes | 1535 | 14 | 1499 | 22 | 0.8554 | -70.812 | 2021-06-01 04:23:09 | Vaupes, Colombia | ||
20235 | 20235 | 2021-05-28 | Colombia | Vichada | 1770 | 25 | 1723 | 22 | 4.4234 | -69.2878 | 2021-05-29 04:20:41 | Vichada, Colombia | ||
1309941 | 1309941 | 2021-05-26 | Canada | Nunavut | 647 | 4 | 621 | 22 | 70.2998 | -83.1076 | 2021-05-27 04:20:59 | Nunavut, Canada | ||
83228 | 83228 | 2021-05-25 | New Zealand | 2669 | 28 | 2621 | 22 | -40.9006 | 174.886 | 2021-05-26 04:20:35 | New Zealand | |||
1413190 | 1413190 | 2021-05-24 | New Zealand | 2669 | 28 | 2621 | 22 | -40.9006 | 174.886 | 2021-05-25 04:21:08 | New Zealand | |||
1771123 | 1771123 | 2021-05-23 | Chad | 4924 | 173 | 4729 | 22 | 15.4542 | 18.7322 | 2021-05-24 04:20:53 | Chad | |||
726206 | 726206 | 2021-05-22 | Barbados | 3991 | 47 | 3922 | 22 | 13.1939 | -59.5432 | 2021-05-23 04:20:51 | Barbados | |||
2255490 | 2255490 | 2021-05-19 | Burkina Faso | 13407 | 165 | 13220 | 22 | 12.2383 | -1.5616 | 2021-05-20 04:21:05 | Burkina Faso | |||
2394428 | 2394428 | 2021-05-18 | United Kingdom | Turks and Caicos Islands | 2404 | 17 | 2365 | 22 | 21.694000000000006 | -71.7979 | 2021-05-19 04:20:42 | Turks and Caicos Islands, United Kingdom | ||
3578253 | 3578253 | 2021-05-17 | United Kingdom | Turks and Caicos Islands | 2404 | 17 | 2365 | 22 | 21.694000000000006 | -71.7979 | 2021-05-18 04:20:33 | Turks and Caicos Islands, United Kingdom | ||
2942983 | 2942983 | 2021-05-16 | United Kingdom | Turks and Caicos Islands | 2404 | 17 | 2365 | 22 | 21.694000000000006 | -71.7979 | 2021-05-17 04:20:34 | Turks and Caicos Islands, United Kingdom | ||
1876613 | 1876613 | 2021-05-15 | United Kingdom | Turks and Caicos Islands | 2404 | 17 | 2365 | 22 | 21.694000000000006 | -71.7979 | 2021-05-16 04:20:49 | Turks and Caicos Islands, United Kingdom | ||
1872787 | 1872787 | 2021-05-15 | China | Zhejiang | 1347 | 1 | 1324 | 22 | 29.1832 | 120.0934 | 2021-05-16 04:20:49 | Zhejiang, China | ||
1872657 | 1872657 | 2021-05-15 | Australia | Victoria | 20544 | 820 | 19702 | 22 | -37.8136 | 144.9631 | 2021-05-16 04:20:49 | Victoria, Australia | ||
1085582 | 1085582 | 2021-05-14 | United Kingdom | Turks and Caicos Islands | 2404 | 17 | 2365 | 22 | 21.694000000000006 | -71.7979 | 2021-05-15 04:20:58 | Turks and Caicos Islands, United Kingdom | ||
1081756 | 1081756 | 2021-05-14 | China | Zhejiang | 1347 | 1 | 1324 | 22 | 29.1832 | 120.0934 | 2021-05-15 04:20:58 | Zhejiang, China | ||
3057848 | 3057848 | 2021-05-13 | United Kingdom | Turks and Caicos Islands | 2404 | 17 | 2365 | 22 | 21.694000000000006 | -71.7979 | 2021-05-14 04:20:41 | Turks and Caicos Islands, United Kingdom | ||
3054022 | 3054022 | 2021-05-13 | China | Zhejiang | 1347 | 1 | 1324 | 22 | 29.1832 | 120.0934 | 2021-05-14 04:20:41 | Zhejiang, China | ||
2008318 | 2008318 | 2021-05-12 | United Kingdom | Turks and Caicos Islands | 2404 | 17 | 2365 | 22 | 21.694000000000006 | -71.7979 | 2021-05-13 04:20:51 | Turks and Caicos Islands, United Kingdom | ||
2004492 | 2004492 | 2021-05-12 | China | Zhejiang | 1347 | 1 | 1324 | 22 | 29.1832 | 120.0934 | 2021-05-13 04:20:51 | Zhejiang, China | ||
3958149 | 3958149 | 2021-05-11 | United Kingdom | Turks and Caicos Islands | 2404 | 17 | 2365 | 22 | 21.694000000000006 | -71.7979 | 2021-05-12 04:21:29 | Turks and Caicos Islands, United Kingdom | ||
1551802 | 1551802 | 2021-05-08 | China | Zhejiang | 1345 | 1 | 1322 | 22 | 29.1832 | 120.0934 | 2021-05-09 04:20:35 | Zhejiang, China | ||
1551673 | 1551673 | 2021-05-08 | Australia | Western Australia | 1013 | 9 | 982 | 22 | -31.9505 | 115.8605 | 2021-05-09 04:20:35 | Western Australia, Australia | ||
1551672 | 1551672 | 2021-05-08 | Australia | Victoria | 20533 | 820 | 19691 | 22 | -37.8136 | 144.9631 | 2021-05-09 04:20:35 | Victoria, Australia | ||
1551669 | 1551669 | 2021-05-08 | Australia | Queensland | 1580 | 7 | 1551 | 22 | -27.4698 | 153.0251 | 2021-05-09 04:20:35 | Queensland, Australia | ||
2505716 | 2505716 | 2021-05-07 | Malaysia | W.P. Labuan | 2476 | 12 | 2442 | 22 | 5.2831 | 115.2308 | 2021-05-08 04:21:04 | W.P. Labuan, Malaysia | ||
2501860 | 2501860 | 2021-05-07 | China | Zhejiang | 1345 | 1 | 1322 | 22 | 29.1832 | 120.0934 | 2021-05-08 04:21:04 | Zhejiang, China | ||
646222 | 646222 | 2021-05-05 | Sao Tome and Principe | 2314 | 35 | 2257 | 22 | 0.1864 | 6.6131 | 2021-05-06 04:20:38 | Sao Tome and Principe | |||
645800 | 645800 | 2021-05-05 | Colombia | Guaviare | 2411 | 40 | 2349 | 22 | 1.0654 | -73.2603 | 2021-05-06 04:20:38 | Guaviare, Colombia | ||
3679339 | 3679339 | 2021-05-04 | Malaysia | W.P. Labuan | 2467 | 12 | 2433 | 22 | 5.2831 | 115.2308 | 2021-05-05 04:20:43 | W.P. Labuan, Malaysia | ||
3675922 | 3675922 | 2021-05-04 | Sao Tome and Principe | 2311 | 35 | 2254 | 22 | 0.1864 | 6.6131 | 2021-05-05 04:20:43 | Sao Tome and Principe | |||
3675360 | 3675360 | 2021-05-04 | Barbados | 3884 | 45 | 3817 | 22 | 13.1939 | -59.5432 | 2021-05-05 04:20:43 | Barbados | |||
2760812 | 2760812 | 2021-05-03 | France | French Polynesia | 18765 | 141 | 18602 | 22 | -17.6797 | -149.4068 | 2021-05-04 04:20:34 | French Polynesia, France | ||
2450480 | 2450480 | 2021-05-02 | Barbados | 3866 | 44 | 3800 | 22 | 13.1939 | -59.5432 | 2021-05-03 04:20:39 | Barbados | |||
3393243 | 3393243 | 2021-04-28 | Colombia | Guaviare | 2346 | 40 | 2284 | 22 | 1.0654 | -73.2603 | 2021-04-29 04:20:55 | Guaviare, Colombia | ||
3701959 | 3701959 | 2021-04-27 | Colombia | Guaviare | 2340 | 40 | 2278 | 22 | 1.0654 | -73.2603 | 2021-04-28 04:20:32 | Guaviare, Colombia | ||
3129293 | 3129293 | 2021-04-18 | Canada | Nunavut | 417 | 4 | 391 | 22 | 70.2998 | -83.1076 | 2021-04-19 04:20:57 | Nunavut, Canada | ||
982718 | 982718 | 2021-04-17 | Canada | Newfoundland and Labrador | 1042 | 6 | 1011 | 22 | 53.1355 | -57.6604 | 2021-04-18 04:20:41 | Newfoundland and Labrador, Canada | ||
169813 | 169813 | 2021-04-16 | Canada | Newfoundland and Labrador | 1039 | 6 | 1011 | 22 | 53.1355 | -57.6604 | 2021-04-17 04:20:40 | Newfoundland and Labrador, Canada | ||
2552522 | 2552522 | 2021-04-15 | United Kingdom | Cayman Islands | 523 | 2 | 499 | 22 | 19.3133 | -81.2546 | 2021-04-16 04:20:46 | Cayman Islands, United Kingdom | ||
605554 | 605554 | 2021-04-09 | Colombia | Vichada | 1502 | 23 | 1457 | 22 | 4.4234 | -69.2878 | 2021-04-10 04:20:59 | Vichada, Colombia | ||
3088947 | 3088947 | 2021-04-05 | United Kingdom | Cayman Islands | 501 | 2 | 477 | 22 | 19.3133 | -81.2546 | 2021-04-06 04:20:32 | Cayman Islands, United Kingdom | ||
3085329 | 3085329 | 2021-04-05 | Japan | Oita | 1323 | 22 | 1279 | 22 | 33.200697 | 131.43323999999998 | 2021-04-06 04:20:32 | Oita, Japan | ||
391870 | 391870 | 2021-04-04 | United Kingdom | Cayman Islands | 501 | 2 | 477 | 22 | 19.3133 | -81.2546 | 2021-04-05 04:20:35 | Cayman Islands, United Kingdom |
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]);