johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6,617 rows where active = 13 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 5,555
- Japan 171
- China 144
- Netherlands 133
- Canada 77
- Colombia 56
- Australia 55
- Malaysia 50
- United Kingdom 47
- Dominica 24
- France 23
- Comoros 19
- India 19
- Italy 18
- Chad 17
- Antigua and Barbuda 15
- Denmark 14
- Barbados 13
- Namibia 13
- Brunei 9
- Cambodia 9
- Laos 9
- Saint Vincent and the Grenadines 9
- Sao Tome and Principe 8
- Bhutan 7
- Chile 6
- Iceland 6
- Saint Lucia 6
- Burkina Faso 5
- Eritrea 5
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331675 | 331675 | 2021-08-04 | Canada | Newfoundland and Labrador | 1441 | 7 | 1421 | 13 | 53.1355 | -57.6604 | 2021-08-05 04:21:51 | Newfoundland and Labrador, Canada | ||
3467999 | 3467999 | 2021-08-03 | China | Shandong | 896 | 7 | 876 | 13 | 36.3427 | 118.1498 | 2021-08-04 04:21:25 | Shandong, China | ||
3903820 | 3903820 | 2021-07-31 | Colombia | Guainia | 2214 | 29 | 2172 | 13 | 2.5854 | -68.5247 | 2021-08-01 04:21:50 | Guainia, Colombia | ||
3903772 | 3903772 | 2021-07-31 | China | Beijing | 1089 | 9 | 1067 | 13 | 40.1824 | 116.4142 | 2021-08-01 04:21:50 | Beijing, China | ||
3295977 | 3295977 | 2021-07-30 | China | Beijing | 1089 | 9 | 1067 | 13 | 40.1824 | 116.4142 | 2021-07-31 04:21:35 | Beijing, China | ||
3385188 | 3385188 | 2021-07-29 | China | Beijing | 1089 | 9 | 1067 | 13 | 40.1824 | 116.4142 | 2021-07-30 04:21:34 | Beijing, China | ||
3385157 | 3385157 | 2021-07-29 | Canada | New Brunswick | 2358 | 46 | 2299 | 13 | 46.5653 | -66.4619 | 2021-07-30 04:21:34 | New Brunswick, Canada | ||
408160 | 408160 | 2021-07-28 | Comoros | 4024 | 147 | 3864 | 13 | -11.6455 | 43.3333 | 2021-07-29 04:21:33 | Comoros | |||
1306035 | 1306035 | 2021-07-27 | Dominica | 209 | 0 | 196 | 13 | 15.415 | -61.371 | 2021-07-28 04:21:39 | Dominica | |||
1306021 | 1306021 | 2021-07-27 | Comoros | 4024 | 147 | 3864 | 13 | -11.6455 | 43.3333 | 2021-07-28 04:21:39 | Comoros | |||
3218178 | 3218178 | 2021-07-26 | Dominica | 209 | 0 | 196 | 13 | 15.415 | -61.371 | 2021-07-27 04:21:18 | Dominica | |||
3218164 | 3218164 | 2021-07-26 | Comoros | 4024 | 147 | 3864 | 13 | -11.6455 | 43.3333 | 2021-07-27 04:21:18 | Comoros | |||
3218078 | 3218078 | 2021-07-26 | Chad | 4969 | 174 | 4782 | 13 | 15.4542 | 18.7322 | 2021-07-27 04:21:18 | Chad | |||
3218069 | 3218069 | 2021-07-26 | Canada | Nova Scotia | 5883 | 93 | 5777 | 13 | 44.682 | -63.7443 | 2021-07-27 04:21:18 | Nova Scotia, Canada | ||
1378387 | 1378387 | 2021-07-25 | Dominica | 209 | 0 | 196 | 13 | 15.415 | -61.371 | 2021-07-26 04:21:28 | Dominica | |||
1378354 | 1378354 | 2021-07-25 | Colombia | Guainia | 2208 | 29 | 2166 | 13 | 2.5854 | -68.5247 | 2021-07-26 04:21:28 | Guainia, Colombia | ||
1378287 | 1378287 | 2021-07-25 | Chad | 4969 | 174 | 4782 | 13 | 15.4542 | 18.7322 | 2021-07-26 04:21:28 | Chad | |||
1330127 | 1330127 | 2021-07-24 | Dominica | 209 | 0 | 196 | 13 | 15.415 | -61.371 | 2021-07-25 04:22:12 | Dominica | |||
1330126 | 1330126 | 2021-07-24 | Djibouti | 11634 | 155 | 11466 | 13 | 11.8251 | 42.5903 | 2021-07-25 04:22:12 | Djibouti | |||
1330094 | 1330094 | 2021-07-24 | Colombia | Guainia | 2207 | 29 | 2165 | 13 | 2.5854 | -68.5247 | 2021-07-25 04:22:12 | Guainia, Colombia | ||
1330027 | 1330027 | 2021-07-24 | Chad | 4969 | 174 | 4782 | 13 | 15.4542 | 18.7322 | 2021-07-25 04:22:12 | Chad | |||
3137431 | 3137431 | 2021-07-23 | Dominica | 209 | 0 | 196 | 13 | 15.415 | -61.371 | 2021-07-24 00:21:36 | Dominica | |||
3137430 | 3137430 | 2021-07-23 | Djibouti | 11634 | 155 | 11466 | 13 | 11.8251 | 42.5903 | 2021-07-24 00:21:36 | Djibouti | |||
3137331 | 3137331 | 2021-07-23 | Chad | 4967 | 174 | 4780 | 13 | 15.4542 | 18.7322 | 2021-07-24 00:21:36 | Chad | |||
3476191 | 3476191 | 2021-07-22 | Dominica | 209 | 0 | 196 | 13 | 15.415 | -61.371 | 2021-07-23 04:21:29 | Dominica | |||
3476120 | 3476120 | 2021-07-22 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-23 04:21:29 | Henan, China | ||
3331339 | 3331339 | 2021-07-21 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-22 04:21:19 | Henan, China | ||
2371320 | 2371320 | 2021-07-20 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-21 04:21:40 | Henan, China | ||
483399 | 483399 | 2021-07-19 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-20 04:21:48 | Henan, China | ||
483370 | 483370 | 2021-07-19 | Chad | 4964 | 174 | 4777 | 13 | 15.4542 | 18.7322 | 2021-07-20 04:21:48 | Chad | |||
2673622 | 2673622 | 2021-07-18 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-19 04:21:24 | Henan, China | ||
2673593 | 2673593 | 2021-07-18 | Chad | 4964 | 174 | 4777 | 13 | 15.4542 | 18.7322 | 2021-07-19 04:21:24 | Chad | |||
3705939 | 3705939 | 2021-07-17 | China | Jiangsu | 751 | 0 | 738 | 13 | 32.9711 | 119.455 | 2021-07-18 04:22:07 | Jiangsu, China | ||
3705905 | 3705905 | 2021-07-17 | Chad | 4964 | 174 | 4777 | 13 | 15.4542 | 18.7322 | 2021-07-18 04:22:07 | Chad | |||
2947393 | 2947393 | 2021-07-16 | Japan | Shimane | 567 | 2 | 552 | 13 | 35.07076 | 132.55406399999998 | 2021-07-17 04:22:22 | Shimane, Japan | ||
2947177 | 2947177 | 2021-07-16 | China | Shaanxi | 640 | 3 | 624 | 13 | 35.1917 | 108.8701 | 2021-07-17 04:22:22 | Shaanxi, China | ||
2947136 | 2947136 | 2021-07-16 | Chad | 4964 | 174 | 4777 | 13 | 15.4542 | 18.7322 | 2021-07-17 04:22:22 | Chad | |||
299692 | 299692 | 2021-07-15 | Malaysia | Perlis | 614 | 8 | 593 | 13 | 6.4449 | 100.2048 | 2021-07-16 04:21:22 | Perlis, Malaysia | ||
296130 | 296130 | 2021-07-15 | Netherlands | Bonaire, Sint Eustatius and Saba | 1661 | 17 | 1631 | 13 | 12.1784 | -68.2385 | 2021-07-16 04:21:22 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
295948 | 295948 | 2021-07-15 | India | Andaman and Nicobar Islands | 7501 | 129 | 7359 | 13 | 11.225999 | 92.968178 | 2021-07-16 04:21:22 | Andaman and Nicobar Islands, India | ||
3632075 | 3632075 | 2021-07-14 | Netherlands | Bonaire, Sint Eustatius and Saba | 1661 | 17 | 1631 | 13 | 12.1784 | -68.2385 | 2021-07-15 04:21:48 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
3631783 | 3631783 | 2021-07-14 | China | Tianjin | 408 | 3 | 392 | 13 | 39.3054 | 117.323 | 2021-07-15 04:21:48 | Tianjin, China | ||
3631778 | 3631778 | 2021-07-14 | China | Shaanxi | 637 | 3 | 621 | 13 | 35.1917 | 108.8701 | 2021-07-15 04:21:48 | Shaanxi, China | ||
578950 | 578950 | 2021-07-13 | Netherlands | Bonaire, Sint Eustatius and Saba | 1661 | 17 | 1631 | 13 | 12.1784 | -68.2385 | 2021-07-14 04:21:35 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
578872 | 578872 | 2021-07-13 | Japan | Tokushima | 1668 | 63 | 1592 | 13 | 33.919178 | 134.242091 | 2021-07-14 04:21:35 | Tokushima, Japan | ||
578708 | 578708 | 2021-07-13 | Denmark | Greenland | 64 | 0 | 51 | 13 | 71.7069 | -42.6043 | 2021-07-14 04:21:35 | Greenland, Denmark | ||
578658 | 578658 | 2021-07-13 | China | Tianjin | 408 | 3 | 392 | 13 | 39.3054 | 117.323 | 2021-07-14 04:21:35 | Tianjin, China | ||
578653 | 578653 | 2021-07-13 | China | Shaanxi | 637 | 3 | 621 | 13 | 35.1917 | 108.8701 | 2021-07-14 04:21:35 | Shaanxi, China | ||
3740907 | 3740907 | 2021-07-12 | China | Tianjin | 407 | 3 | 391 | 13 | 39.3054 | 117.323 | 2021-07-13 04:21:18 | Tianjin, China | ||
3659296 | 3659296 | 2021-07-11 | Australia | Western Australia | 1036 | 9 | 1014 | 13 | -31.9505 | 115.8605 | 2021-07-12 04:21:34 | Western Australia, Australia | ||
629558 | 629558 | 2021-07-10 | Malaysia | Perlis | 607 | 8 | 586 | 13 | 6.4449 | 100.2048 | 2021-07-11 04:21:43 | Perlis, Malaysia | ||
829613 | 829613 | 2021-07-09 | Japan | Kagawa | 2111 | 31 | 2067 | 13 | 34.217292 | 133.969047 | 2021-07-10 04:21:25 | Kagawa, Japan | ||
778388 | 778388 | 2021-07-08 | Japan | Nara | 8282 | 132 | 8137 | 13 | 34.317451 | 135.871644 | 2021-07-09 04:21:21 | Nara, Japan | ||
778297 | 778297 | 2021-07-08 | India | Andaman and Nicobar Islands | 7492 | 128 | 7351 | 13 | 11.225999 | 92.968178 | 2021-07-09 04:21:21 | Andaman and Nicobar Islands, India | ||
2693445 | 2693445 | 2021-07-06 | Burkina Faso | 13494 | 168 | 13313 | 13 | 12.2383 | -1.5616 | 2021-07-07 04:21:20 | Burkina Faso | |||
1932330 | 1932330 | 2021-07-05 | France | French Polynesia | 19017 | 143 | 18861 | 13 | -17.6797 | -149.4068 | 2021-07-06 04:21:32 | French Polynesia, France | ||
1932194 | 1932194 | 2021-07-05 | Burkina Faso | 13494 | 168 | 13313 | 13 | 12.2383 | -1.5616 | 2021-07-06 04:21:32 | Burkina Faso | |||
1165184 | 1165184 | 2021-07-04 | Japan | Kagawa | 2099 | 31 | 2055 | 13 | 34.217292 | 133.969047 | 2021-07-05 04:21:28 | Kagawa, Japan | ||
1165043 | 1165043 | 2021-07-04 | Denmark | Faroe Islands | 781 | 1 | 767 | 13 | 61.8926 | -6.9118 | 2021-07-05 04:21:28 | Faroe Islands, Denmark | ||
1495618 | 1495618 | 2021-07-03 | Japan | Kagawa | 2098 | 31 | 2054 | 13 | 34.217292 | 133.969047 | 2021-07-04 04:21:38 | Kagawa, Japan | ||
1495477 | 1495477 | 2021-07-03 | Denmark | Faroe Islands | 781 | 1 | 767 | 13 | 61.8926 | -6.9118 | 2021-07-04 04:21:38 | Faroe Islands, Denmark | ||
2071792 | 2071792 | 2021-07-02 | Denmark | Faroe Islands | 778 | 1 | 764 | 13 | 61.8926 | -6.9118 | 2021-07-03 04:21:37 | Faroe Islands, Denmark | ||
2768583 | 2768583 | 2021-07-01 | United Kingdom | British Virgin Islands | 313 | 1 | 299 | 13 | 18.4207 | -64.64 | 2021-07-02 04:21:47 | British Virgin Islands, United Kingdom | ||
2764808 | 2764808 | 2021-07-01 | Denmark | Faroe Islands | 778 | 1 | 764 | 13 | 61.8926 | -6.9118 | 2021-07-02 04:21:47 | Faroe Islands, Denmark | ||
403920 | 403920 | 2021-06-29 | United Kingdom | Isle of Man | 1611 | 29 | 1569 | 13 | 54.2361 | -4.5481 | 2021-06-30 04:21:41 | Isle of Man, United Kingdom | ||
400139 | 400139 | 2021-06-29 | Denmark | Faroe Islands | 775 | 1 | 761 | 13 | 61.8926 | -6.9118 | 2021-06-30 04:21:41 | Faroe Islands, Denmark | ||
399963 | 399963 | 2021-06-29 | Australia | South Australia | 801 | 4 | 784 | 13 | -34.9285 | 138.6007 | 2021-06-30 04:21:41 | South Australia, Australia | ||
3129156 | 3129156 | 2021-06-28 | United Kingdom | Bermuda | 2510 | 33 | 2464 | 13 | 32.3078 | -64.7505 | 2021-06-29 04:21:28 | Bermuda, United Kingdom | ||
3125553 | 3125553 | 2021-06-28 | Japan | Yamagata | 2020 | 47 | 1960 | 13 | 38.448396 | 140.102154 | 2021-06-29 04:21:28 | Yamagata, Japan | ||
3125321 | 3125321 | 2021-06-28 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-29 04:21:28 | Jiangsu, China | ||
2593651 | 2593651 | 2021-06-27 | United Kingdom | Bermuda | 2510 | 33 | 2464 | 13 | 32.3078 | -64.7505 | 2021-06-28 04:21:29 | Bermuda, United Kingdom | ||
2590048 | 2590048 | 2021-06-27 | Japan | Yamagata | 2020 | 47 | 1960 | 13 | 38.448396 | 140.102154 | 2021-06-28 04:21:29 | Yamagata, Japan | ||
2590006 | 2590006 | 2021-06-27 | Japan | Ehime | 2752 | 75 | 2664 | 13 | 33.624835 | 132.856842 | 2021-06-28 04:21:29 | Ehime, Japan | ||
2589816 | 2589816 | 2021-06-27 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-28 04:21:29 | Jiangsu, China | ||
2589759 | 2589759 | 2021-06-27 | Burkina Faso | 13478 | 168 | 13297 | 13 | 12.2383 | -1.5616 | 2021-06-28 04:21:29 | Burkina Faso | |||
3962155 | 3962155 | 2021-06-26 | United Kingdom | Bermuda | 2510 | 33 | 2464 | 13 | 32.3078 | -64.7505 | 2021-06-27 04:21:39 | Bermuda, United Kingdom | ||
3958381 | 3958381 | 2021-06-26 | Denmark | Faroe Islands | 771 | 1 | 757 | 13 | 61.8926 | -6.9118 | 2021-06-27 04:21:39 | Faroe Islands, Denmark | ||
3958370 | 3958370 | 2021-06-26 | Colombia | Vaupes | 1669 | 15 | 1641 | 13 | 0.8554 | -70.812 | 2021-06-27 04:21:39 | Vaupes, Colombia | ||
3958320 | 3958320 | 2021-06-26 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-27 04:21:39 | Jiangsu, China | ||
3958263 | 3958263 | 2021-06-26 | Burkina Faso | 13478 | 168 | 13297 | 13 | 12.2383 | -1.5616 | 2021-06-27 04:21:39 | Burkina Faso | |||
1715974 | 1715974 | 2021-06-25 | United Kingdom | Bermuda | 2510 | 33 | 2464 | 13 | 32.3078 | -64.7505 | 2021-06-26 04:21:43 | Bermuda, United Kingdom | ||
1712365 | 1712365 | 2021-06-25 | Japan | Tokushima | 1654 | 63 | 1578 | 13 | 33.919178 | 134.242091 | 2021-06-26 04:21:43 | Tokushima, Japan | ||
1712139 | 1712139 | 2021-06-25 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-26 04:21:43 | Jiangsu, China | ||
2295490 | 2295490 | 2021-06-24 | Japan | Tokushima | 1654 | 63 | 1578 | 13 | 33.919178 | 134.242091 | 2021-06-25 04:21:33 | Tokushima, Japan | ||
2295325 | 2295325 | 2021-06-24 | Denmark | Faroe Islands | 770 | 1 | 756 | 13 | 61.8926 | -6.9118 | 2021-06-25 04:21:33 | Faroe Islands, Denmark | ||
2295264 | 2295264 | 2021-06-24 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-25 04:21:33 | Jiangsu, China | ||
2422898 | 2422898 | 2021-06-23 | Japan | Gifu | 9218 | 185 | 9020 | 13 | 35.778671 | 137.055925 | 2021-06-24 04:21:55 | Gifu, Japan | ||
2422765 | 2422765 | 2021-06-23 | Denmark | Faroe Islands | 770 | 1 | 756 | 13 | 61.8926 | -6.9118 | 2021-06-24 04:21:55 | Faroe Islands, Denmark | ||
2422754 | 2422754 | 2021-06-23 | Colombia | Vaupes | 1664 | 15 | 1636 | 13 | 0.8554 | -70.812 | 2021-06-24 04:21:55 | Vaupes, Colombia | ||
2422598 | 2422598 | 2021-06-23 | Barbados | 4052 | 47 | 3992 | 13 | 13.1939 | -59.5432 | 2021-06-24 04:21:55 | Barbados | |||
562842 | 562842 | 2021-06-22 | Denmark | Faroe Islands | 769 | 1 | 755 | 13 | 61.8926 | -6.9118 | 2021-06-23 04:21:46 | Faroe Islands, Denmark | ||
3358696 | 3358696 | 2021-06-21 | Japan | Nara | 8035 | 126 | 7896 | 13 | 34.317451 | 135.871644 | 2021-06-22 04:21:34 | Nara, Japan | ||
3358490 | 3358490 | 2021-06-21 | China | Shaanxi | 624 | 3 | 608 | 13 | 35.1917 | 108.8701 | 2021-06-22 04:21:34 | Shaanxi, China | ||
1125712 | 1125712 | 2021-06-18 | Netherlands | Bonaire, Sint Eustatius and Saba | 1629 | 17 | 1599 | 13 | 12.1784 | -68.2385 | 2021-06-19 04:22:33 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
1125302 | 1125302 | 2021-06-18 | Barbados | 4040 | 47 | 3980 | 13 | 13.1939 | -59.5432 | 2021-06-19 04:22:33 | Barbados | |||
2911290 | 2911290 | 2021-06-17 | Netherlands | Bonaire, Sint Eustatius and Saba | 1629 | 17 | 1599 | 13 | 12.1784 | -68.2385 | 2021-06-18 04:22:16 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
3030327 | 3030327 | 2021-06-16 | Japan | Shimane | 551 | 1 | 537 | 13 | 35.07076 | 132.55406399999998 | 2021-06-17 04:22:36 | Shimane, Japan | ||
2343048 | 2343048 | 2021-06-15 | United Kingdom | Gibraltar | 4312 | 94 | 4205 | 13 | 36.1408 | -5.3536 | 2021-06-16 04:22:32 | Gibraltar, United Kingdom | ||
2339275 | 2339275 | 2021-06-15 | Djibouti | 11575 | 154 | 11408 | 13 | 11.8251 | 42.5903 | 2021-06-16 04:22:32 | Djibouti | |||
1567744 | 1567744 | 2021-06-14 | United Kingdom | Gibraltar | 4312 | 94 | 4205 | 13 | 36.1408 | -5.3536 | 2021-06-15 04:22:22 | 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]);