johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6,895 rows where active = 12 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 5,728
- Holy See 213
- China 177
- Japan 134
- United Kingdom 78
- Australia 68
- Colombia 59
- Malaysia 59
- Solomon Islands 44
- Canada 36
- Italy 21
- India 16
- Mongolia 14
- Netherlands 11
- Chile 10
- Grenada 10
- Russia 10
- Comoros 9
- France 9
- Timor-Leste 9
- Barbados 7
- Botswana 7
- Brunei 7
- Cambodia 7
- Guinea-Bissau 7
- Iceland 7
- Ukraine 7
- Bhutan 6
- Chad 6
- Denmark 6
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468043 | 3468043 | 2021-08-03 | Comoros | 4028 | 147 | 3869 | 12 | -11.6455 | 43.3333 | 2021-08-04 04:21:25 | Comoros | |||
3468024 | 3468024 | 2021-08-03 | Colombia | Guainia | 2214 | 29 | 2173 | 12 | 2.5854 | -68.5247 | 2021-08-04 04:21:25 | Guainia, Colombia | ||
3467948 | 3467948 | 2021-08-03 | Canada | Nova Scotia | 5893 | 93 | 5788 | 12 | 44.682 | -63.7443 | 2021-08-04 04:21:25 | Nova Scotia, Canada | ||
3467946 | 3467946 | 2021-08-03 | Canada | Newfoundland and Labrador | 1440 | 7 | 1421 | 12 | 53.1355 | -57.6604 | 2021-08-04 04:21:25 | Newfoundland and Labrador, Canada | ||
3683317 | 3683317 | 2021-08-02 | Comoros | 4028 | 147 | 3869 | 12 | -11.6455 | 43.3333 | 2021-08-03 04:21:39 | Comoros | |||
3683298 | 3683298 | 2021-08-02 | Colombia | Guainia | 2214 | 29 | 2173 | 12 | 2.5854 | -68.5247 | 2021-08-03 04:21:39 | Guainia, Colombia | ||
3683220 | 3683220 | 2021-08-02 | Canada | Newfoundland and Labrador | 1440 | 7 | 1421 | 12 | 53.1355 | -57.6604 | 2021-08-03 04:21:39 | Newfoundland and Labrador, Canada | ||
3015216 | 3015216 | 2021-08-01 | Comoros | 4028 | 147 | 3869 | 12 | -11.6455 | 43.3333 | 2021-08-02 04:21:36 | Comoros | |||
3015197 | 3015197 | 2021-08-01 | Colombia | Guainia | 2214 | 29 | 2173 | 12 | 2.5854 | -68.5247 | 2021-08-02 04:21:36 | Guainia, Colombia | ||
3903837 | 3903837 | 2021-07-31 | Colombia | Vaupes | 1727 | 17 | 1698 | 12 | 0.8554 | -70.812 | 2021-08-01 04:21:50 | Vaupes, Colombia | ||
3299829 | 3299829 | 2021-07-30 | United Kingdom | Cayman Islands | 642 | 2 | 628 | 12 | 19.3133 | -81.2546 | 2021-07-31 04:21:35 | Cayman Islands, United Kingdom | ||
3296025 | 3296025 | 2021-07-30 | Colombia | Guainia | 2213 | 29 | 2172 | 12 | 2.5854 | -68.5247 | 2021-07-31 04:21:35 | Guainia, Colombia | ||
3385236 | 3385236 | 2021-07-29 | Colombia | Guainia | 2213 | 29 | 2172 | 12 | 2.5854 | -68.5247 | 2021-07-30 04:21:34 | Guainia, Colombia | ||
408173 | 408173 | 2021-07-28 | Djibouti | 11647 | 155 | 11480 | 12 | 11.8251 | 42.5903 | 2021-07-29 04:21:33 | Djibouti | |||
408093 | 408093 | 2021-07-28 | China | Beijing | 1088 | 9 | 1067 | 12 | 40.1824 | 116.4142 | 2021-07-29 04:21:33 | Beijing, China | ||
1306091 | 1306091 | 2021-07-27 | India | Andaman and Nicobar Islands | 7530 | 129 | 7389 | 12 | 11.225999 | 92.968178 | 2021-07-28 04:21:39 | Andaman and Nicobar Islands, India | ||
1305954 | 1305954 | 2021-07-27 | China | Beijing | 1087 | 9 | 1066 | 12 | 40.1824 | 116.4142 | 2021-07-28 04:21:39 | Beijing, China | ||
1378373 | 1378373 | 2021-07-25 | Comoros | 4021 | 147 | 3862 | 12 | -11.6455 | 43.3333 | 2021-07-26 04:21:28 | Comoros | |||
1378278 | 1378278 | 2021-07-25 | Canada | Nova Scotia | 5882 | 93 | 5777 | 12 | 44.682 | -63.7443 | 2021-07-26 04:21:28 | Nova Scotia, Canada | ||
1330018 | 1330018 | 2021-07-24 | Canada | Nova Scotia | 5882 | 93 | 5777 | 12 | 44.682 | -63.7443 | 2021-07-25 04:22:12 | Nova Scotia, Canada | ||
3137363 | 3137363 | 2021-07-23 | China | Hunan | 1069 | 4 | 1053 | 12 | 27.6104 | 111.7088 | 2021-07-24 00:21:36 | Hunan, China | ||
3137322 | 3137322 | 2021-07-23 | Canada | Nova Scotia | 5882 | 93 | 5777 | 12 | 44.682 | -63.7443 | 2021-07-24 00:21:36 | Nova Scotia, Canada | ||
3476123 | 3476123 | 2021-07-22 | China | Hunan | 1069 | 4 | 1053 | 12 | 27.6104 | 111.7088 | 2021-07-23 04:21:29 | Hunan, China | ||
3331342 | 3331342 | 2021-07-21 | China | Hunan | 1069 | 4 | 1053 | 12 | 27.6104 | 111.7088 | 2021-07-22 04:21:19 | Hunan, China | ||
2371325 | 2371325 | 2021-07-20 | China | Jiangsu | 751 | 0 | 739 | 12 | 32.9711 | 119.455 | 2021-07-21 04:21:40 | Jiangsu, China | ||
2371310 | 2371310 | 2021-07-20 | China | Beijing | 1085 | 9 | 1064 | 12 | 40.1824 | 116.4142 | 2021-07-21 04:21:40 | Beijing, China | ||
483404 | 483404 | 2021-07-19 | China | Jiangsu | 751 | 0 | 739 | 12 | 32.9711 | 119.455 | 2021-07-20 04:21:48 | Jiangsu, China | ||
483389 | 483389 | 2021-07-19 | China | Beijing | 1085 | 9 | 1064 | 12 | 40.1824 | 116.4142 | 2021-07-20 04:21:48 | Beijing, China | ||
2673660 | 2673660 | 2021-07-18 | Colombia | Guainia | 2175 | 28 | 2135 | 12 | 2.5854 | -68.5247 | 2021-07-19 04:21:24 | Guainia, Colombia | ||
2673627 | 2673627 | 2021-07-18 | China | Jiangsu | 751 | 0 | 739 | 12 | 32.9711 | 119.455 | 2021-07-19 04:21:24 | Jiangsu, China | ||
3705934 | 3705934 | 2021-07-17 | China | Henan | 1325 | 22 | 1291 | 12 | 33.882 | 113.614 | 2021-07-18 04:22:07 | Henan, China | ||
2947170 | 2947170 | 2021-07-16 | China | Jiangsu | 750 | 0 | 738 | 12 | 32.9711 | 119.455 | 2021-07-17 04:22:22 | Jiangsu, China | ||
2947165 | 2947165 | 2021-07-16 | China | Henan | 1325 | 22 | 1291 | 12 | 33.882 | 113.614 | 2021-07-17 04:22:22 | Henan, China | ||
295833 | 295833 | 2021-07-15 | China | Shaanxi | 638 | 3 | 623 | 12 | 35.1917 | 108.8701 | 2021-07-16 04:21:22 | Shaanxi, China | ||
295826 | 295826 | 2021-07-15 | China | Jiangsu | 750 | 0 | 738 | 12 | 32.9711 | 119.455 | 2021-07-16 04:21:22 | Jiangsu, China | ||
295821 | 295821 | 2021-07-15 | China | Henan | 1325 | 22 | 1291 | 12 | 33.882 | 113.614 | 2021-07-16 04:21:22 | Henan, China | ||
578711 | 578711 | 2021-07-13 | Djibouti | 11621 | 155 | 11454 | 12 | 11.8251 | 42.5903 | 2021-07-14 04:21:35 | Djibouti | |||
3741199 | 3741199 | 2021-07-12 | Netherlands | Bonaire, Sint Eustatius and Saba | 1660 | 17 | 1631 | 12 | 12.1784 | -68.2385 | 2021-07-13 04:21:18 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
3740974 | 3740974 | 2021-07-12 | France | French Polynesia | 19034 | 144 | 18878 | 12 | -17.6797 | -149.4068 | 2021-07-13 04:21:18 | French Polynesia, France | ||
3740960 | 3740960 | 2021-07-12 | Djibouti | 11621 | 155 | 11454 | 12 | 11.8251 | 42.5903 | 2021-07-13 04:21:18 | Djibouti | |||
3740902 | 3740902 | 2021-07-12 | China | Shaanxi | 636 | 3 | 621 | 12 | 35.1917 | 108.8701 | 2021-07-13 04:21:18 | Shaanxi, China | ||
3659420 | 3659420 | 2021-07-11 | China | Tianjin | 406 | 3 | 391 | 12 | 39.3054 | 117.323 | 2021-07-12 04:21:34 | Tianjin, China | ||
625704 | 625704 | 2021-07-10 | China | Tianjin | 406 | 3 | 391 | 12 | 39.3054 | 117.323 | 2021-07-11 04:21:43 | Tianjin, China | ||
829533 | 829533 | 2021-07-09 | India | Andaman and Nicobar Islands | 7492 | 128 | 7352 | 12 | 11.225999 | 92.968178 | 2021-07-10 04:21:25 | Andaman and Nicobar Islands, India | ||
829461 | 829461 | 2021-07-09 | Colombia | Vaupes | 1684 | 16 | 1656 | 12 | 0.8554 | -70.812 | 2021-07-10 04:21:25 | Vaupes, Colombia | ||
829423 | 829423 | 2021-07-09 | China | Tianjin | 406 | 3 | 391 | 12 | 39.3054 | 117.323 | 2021-07-10 04:21:25 | Tianjin, China | ||
782041 | 782041 | 2021-07-08 | Malaysia | Perlis | 602 | 8 | 582 | 12 | 6.4449 | 100.2048 | 2021-07-09 04:21:21 | Perlis, Malaysia | ||
778225 | 778225 | 2021-07-08 | Colombia | Vaupes | 1684 | 16 | 1656 | 12 | 0.8554 | -70.812 | 2021-07-09 04:21:21 | Vaupes, Colombia | ||
1440701 | 1440701 | 2021-07-07 | Netherlands | Bonaire, Sint Eustatius and Saba | 1652 | 17 | 1623 | 12 | 12.1784 | -68.2385 | 2021-07-08 04:21:26 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1440599 | 1440599 | 2021-07-07 | Japan | Kagawa | 2103 | 31 | 2060 | 12 | 34.217292 | 133.969047 | 2021-07-08 04:21:26 | Kagawa, Japan | ||
1440285 | 1440285 | 2021-07-07 | Australia | Western Australia | 1033 | 9 | 1012 | 12 | -31.9505 | 115.8605 | 2021-07-08 04:21:26 | Western Australia, Australia | ||
2693806 | 2693806 | 2021-07-06 | Netherlands | Bonaire, Sint Eustatius and Saba | 1652 | 17 | 1623 | 12 | 12.1784 | -68.2385 | 2021-07-07 04:21:20 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1936086 | 1936086 | 2021-07-05 | United Kingdom | Bermuda | 2516 | 33 | 2471 | 12 | 32.3078 | -64.7505 | 2021-07-06 04:21:32 | Bermuda, United Kingdom | ||
1932555 | 1932555 | 2021-07-05 | Netherlands | Bonaire, Sint Eustatius and Saba | 1652 | 17 | 1623 | 12 | 12.1784 | -68.2385 | 2021-07-06 04:21:32 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1932139 | 1932139 | 2021-07-05 | Australia | Western Australia | 1032 | 9 | 1011 | 12 | -31.9505 | 115.8605 | 2021-07-06 04:21:32 | Western Australia, Australia | ||
1168817 | 1168817 | 2021-07-04 | United Kingdom | Bermuda | 2516 | 33 | 2471 | 12 | 32.3078 | -64.7505 | 2021-07-05 04:21:28 | Bermuda, United Kingdom | ||
1499251 | 1499251 | 2021-07-03 | United Kingdom | Bermuda | 2516 | 33 | 2471 | 12 | 32.3078 | -64.7505 | 2021-07-04 04:21:38 | Bermuda, United Kingdom | ||
2072190 | 2072190 | 2021-07-02 | Sao Tome and Principe | 2369 | 37 | 2320 | 12 | 0.1864 | 6.6131 | 2021-07-03 04:21:37 | Sao Tome and Principe | |||
2071963 | 2071963 | 2021-07-02 | Japan | Yamagata | 2022 | 47 | 1963 | 12 | 38.448396 | 140.102154 | 2021-07-03 04:21:37 | Yamagata, Japan | ||
2071716 | 2071716 | 2021-07-02 | China | Beijing | 1078 | 9 | 1057 | 12 | 40.1824 | 116.4142 | 2021-07-03 04:21:37 | Beijing, China | ||
2071674 | 2071674 | 2021-07-02 | Burkina Faso | 13488 | 168 | 13308 | 12 | 12.2383 | -1.5616 | 2021-07-03 04:21:37 | Burkina Faso | |||
2765206 | 2765206 | 2021-07-01 | Sao Tome and Principe | 2369 | 37 | 2320 | 12 | 0.1864 | 6.6131 | 2021-07-02 04:21:47 | Sao Tome and Principe | |||
2764979 | 2764979 | 2021-07-01 | Japan | Yamagata | 2020 | 47 | 1961 | 12 | 38.448396 | 140.102154 | 2021-07-02 04:21:47 | Yamagata, Japan | ||
2764732 | 2764732 | 2021-07-01 | China | Beijing | 1078 | 9 | 1057 | 12 | 40.1824 | 116.4142 | 2021-07-02 04:21:47 | Beijing, China | ||
1893187 | 1893187 | 2021-06-30 | Japan | Yamagata | 2020 | 47 | 1961 | 12 | 38.448396 | 140.102154 | 2021-07-01 04:21:19 | Yamagata, Japan | ||
1892940 | 1892940 | 2021-06-30 | China | Beijing | 1078 | 9 | 1057 | 12 | 40.1824 | 116.4142 | 2021-07-01 04:21:19 | Beijing, China | ||
400310 | 400310 | 2021-06-29 | Japan | Yamagata | 2020 | 47 | 1961 | 12 | 38.448396 | 140.102154 | 2021-06-30 04:21:41 | Yamagata, Japan | ||
400306 | 400306 | 2021-06-29 | Japan | Tottori | 469 | 2 | 455 | 12 | 35.359069 | 133.863619 | 2021-06-30 04:21:41 | Tottori, Japan | ||
2590042 | 2590042 | 2021-06-27 | Japan | Tokushima | 1655 | 63 | 1580 | 12 | 33.919178 | 134.242091 | 2021-06-28 04:21:29 | Tokushima, Japan | ||
3958546 | 3958546 | 2021-06-26 | Japan | Tokushima | 1655 | 63 | 1580 | 12 | 33.919178 | 134.242091 | 2021-06-27 04:21:39 | Tokushima, Japan | ||
1712200 | 1712200 | 2021-06-25 | Denmark | Faroe Islands | 770 | 1 | 757 | 12 | 61.8926 | -6.9118 | 2021-06-26 04:21:43 | Faroe Islands, Denmark | ||
1712082 | 1712082 | 2021-06-25 | Burkina Faso | 13477 | 168 | 13297 | 12 | 12.2383 | -1.5616 | 2021-06-26 04:21:43 | Burkina Faso | |||
2295314 | 2295314 | 2021-06-24 | Colombia | Vaupes | 1666 | 15 | 1639 | 12 | 0.8554 | -70.812 | 2021-06-25 04:21:33 | Vaupes, Colombia | ||
2295271 | 2295271 | 2021-06-24 | China | Shaanxi | 624 | 3 | 609 | 12 | 35.1917 | 108.8701 | 2021-06-25 04:21:33 | Shaanxi, China | ||
2422915 | 2422915 | 2021-06-23 | Japan | Nagano | 5002 | 91 | 4899 | 12 | 36.132134 | 138.045528 | 2021-06-24 04:21:55 | Nagano, Japan | ||
2422711 | 2422711 | 2021-06-23 | China | Shaanxi | 624 | 3 | 609 | 12 | 35.1917 | 108.8701 | 2021-06-24 04:21:55 | Shaanxi, China | ||
562788 | 562788 | 2021-06-22 | China | Shaanxi | 624 | 3 | 609 | 12 | 35.1917 | 108.8701 | 2021-06-23 04:21:46 | Shaanxi, China | ||
3358544 | 3358544 | 2021-06-21 | Denmark | Faroe Islands | 768 | 1 | 755 | 12 | 61.8926 | -6.9118 | 2021-06-22 04:21:34 | Faroe Islands, Denmark | ||
2910880 | 2910880 | 2021-06-17 | Barbados | 4039 | 47 | 3980 | 12 | 13.1939 | -59.5432 | 2021-06-18 04:22:16 | Barbados | |||
3030332 | 3030332 | 2021-06-16 | Japan | Tottori | 466 | 2 | 452 | 12 | 35.359069 | 133.863619 | 2021-06-17 04:22:36 | Tottori, Japan | ||
3385023 | 3385023 | 2021-06-13 | United Kingdom | Cayman Islands | 592 | 2 | 578 | 12 | 19.3133 | -81.2546 | 2021-06-14 04:22:46 | Cayman Islands, United Kingdom | ||
1740157 | 1740157 | 2021-06-12 | United Kingdom | Cayman Islands | 592 | 2 | 578 | 12 | 19.3133 | -81.2546 | 2021-06-13 04:22:44 | Cayman Islands, United Kingdom | ||
1736308 | 1736308 | 2021-06-12 | China | Beijing | 1069 | 9 | 1048 | 12 | 40.1824 | 116.4142 | 2021-06-13 04:22:44 | Beijing, China | ||
3974198 | 3974198 | 2021-06-11 | United Kingdom | Cayman Islands | 592 | 2 | 578 | 12 | 19.3133 | -81.2546 | 2021-06-12 04:22:22 | Cayman Islands, United Kingdom | ||
3970416 | 3970416 | 2021-06-11 | Comoros | 3894 | 146 | 3736 | 12 | -11.6455 | 43.3333 | 2021-06-12 04:22:22 | Comoros | |||
3970349 | 3970349 | 2021-06-11 | China | Beijing | 1069 | 9 | 1048 | 12 | 40.1824 | 116.4142 | 2021-06-12 04:22:22 | Beijing, China | ||
2720624 | 2720624 | 2021-06-10 | United Kingdom | Gibraltar | 4306 | 94 | 4200 | 12 | 36.1408 | -5.3536 | 2021-06-11 04:23:20 | Gibraltar, United Kingdom | ||
2720620 | 2720620 | 2021-06-10 | United Kingdom | Cayman Islands | 592 | 2 | 578 | 12 | 19.3133 | -81.2546 | 2021-06-11 04:23:20 | Cayman Islands, United Kingdom | ||
2717243 | 2717243 | 2021-06-10 | Sao Tome and Principe | 2355 | 37 | 2306 | 12 | 0.1864 | 6.6131 | 2021-06-11 04:23:20 | Sao Tome and Principe | |||
2716838 | 2716838 | 2021-06-10 | Comoros | 3894 | 146 | 3736 | 12 | -11.6455 | 43.3333 | 2021-06-11 04:23:20 | Comoros | |||
2716771 | 2716771 | 2021-06-10 | China | Beijing | 1068 | 9 | 1047 | 12 | 40.1824 | 116.4142 | 2021-06-11 04:23:20 | Beijing, China | ||
2716750 | 2716750 | 2021-06-10 | Canada | Yukon | 96 | 2 | 82 | 12 | 64.2823 | -135.0 | 2021-06-11 04:23:20 | Yukon, Canada | ||
522967 | 522967 | 2021-06-09 | Monaco | 2514 | 33 | 2469 | 12 | 43.7333 | 7.4167 | 2021-06-10 04:23:17 | Monaco | |||
522612 | 522612 | 2021-06-09 | Brunei | 246 | 3 | 231 | 12 | 4.5353 | 114.7277 | 2021-06-10 04:23:17 | Brunei | |||
3472568 | 3472568 | 2021-06-08 | Sao Tome and Principe | 2353 | 37 | 2304 | 12 | 0.1864 | 6.6131 | 2021-06-09 04:23:31 | Sao Tome and Principe | |||
3472096 | 3472096 | 2021-06-08 | China | Beijing | 1067 | 9 | 1046 | 12 | 40.1824 | 116.4142 | 2021-06-09 04:23:31 | Beijing, China | ||
3472052 | 3472052 | 2021-06-08 | Brunei | 246 | 3 | 231 | 12 | 4.5353 | 114.7277 | 2021-06-09 04:23:31 | Brunei | |||
3145852 | 3145852 | 2021-06-07 | Sao Tome and Principe | 2353 | 37 | 2304 | 12 | 0.1864 | 6.6131 | 2021-06-08 04:22:35 | Sao Tome and Principe | |||
2589640 | 2589640 | 2021-06-05 | United Kingdom | Gibraltar | 4300 | 94 | 4194 | 12 | 36.1408 | -5.3536 | 2021-06-06 04:24:03 | Gibraltar, United Kingdom | ||
2318954 | 2318954 | 2021-06-04 | United Kingdom | Gibraltar | 4300 | 94 | 4194 | 12 | 36.1408 | -5.3536 | 2021-06-05 04:23:03 | Gibraltar, 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]);