johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,552 rows where active = 97 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 1,309
- Japan 68
- Colombia 18
- Russia 15
- Malaysia 13
- Italy 12
- Yemen 11
- Burundi 9
- Ukraine 9
- Germany 8
- Canada 6
- United Kingdom 6
- China 5
- India 5
- Pakistan 5
- Chile 4
- Belize 3
- France 3
- Mexico 3
- Netherlands 3
- New Zealand 3
- Equatorial Guinea 2
- Iceland 2
- Mali 2
- Monaco 2
- Niger 2
- Taiwan* 2
- Vietnam 2
- Andorra 1
- Angola 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1121270 | 1121270 | 2021-08-06 | Malaysia | Perlis | 765 | 11 | 657 | 97 | 6.4449 | 100.2048 | 2021-08-07 04:21:30 | Perlis, Malaysia | ||
3683588 | 3683588 | 2021-08-02 | Niger | 5637 | 195 | 5345 | 97 | 17.607789 | 8.081666 | 2021-08-03 04:21:39 | Niger | |||
3683521 | 3683521 | 2021-08-02 | Mali | 14589 | 534 | 13958 | 97 | 17.570692 | -3.996166000000001 | 2021-08-03 04:21:39 | Mali | |||
3015487 | 3015487 | 2021-08-01 | Niger | 5637 | 195 | 5345 | 97 | 17.607789 | 8.081666 | 2021-08-02 04:21:36 | Niger | |||
3904202 | 3904202 | 2021-07-31 | Russia | Nenets Autonomous Okrug | 1578 | 11 | 1470 | 97 | 68.27557185 | 57.1686375 | 2021-08-01 04:21:50 | Nenets Autonomous Okrug, Russia | ||
3296200 | 3296200 | 2021-07-30 | Japan | Mie | 5718 | 114 | 5507 | 97 | 34.508018 | 136.376013 | 2021-07-31 04:21:35 | Mie, Japan | ||
3385408 | 3385408 | 2021-07-29 | Japan | Kochi | 2056 | 29 | 1930 | 97 | 33.422519 | 133.367307 | 2021-07-30 04:21:34 | Kochi, Japan | ||
1306160 | 1306160 | 2021-07-27 | Japan | Fukui | 1503 | 36 | 1370 | 97 | 35.846614 | 136.22465400000002 | 2021-07-28 04:21:39 | Fukui, Japan | ||
3218324 | 3218324 | 2021-07-26 | Japan | Nagasaki | 3340 | 69 | 3174 | 97 | 33.235712 | 129.608033 | 2021-07-27 04:21:18 | Nagasaki, Japan | ||
1378555 | 1378555 | 2021-07-25 | Japan | Yamanashi | 2268 | 21 | 2150 | 97 | 35.612364 | 138.61148899999998 | 2021-07-26 04:21:28 | Yamanashi, Japan | ||
1378522 | 1378522 | 2021-07-25 | Japan | Iwate | 1912 | 47 | 1768 | 97 | 39.593287 | 141.361777 | 2021-07-26 04:21:28 | Iwate, Japan | ||
3137578 | 3137578 | 2021-07-23 | Japan | Nara | 8584 | 133 | 8354 | 97 | 34.317451 | 135.871644 | 2021-07-24 00:21:36 | Nara, Japan | ||
2371628 | 2371628 | 2021-07-20 | Netherlands | Aruba | 11257 | 109 | 11051 | 97 | 12.5211 | -69.9683 | 2021-07-21 04:21:40 | Aruba, Netherlands | ||
2371621 | 2371621 | 2021-07-20 | Monaco | 2717 | 33 | 2587 | 97 | 43.7333 | 7.4167 | 2021-07-21 04:21:40 | Monaco | |||
3709747 | 3709747 | 2021-07-17 | Ukraine | Chernivtsi Oblast | 80047 | 1794 | 78156 | 97 | 48.2917 | 25.9352 | 2021-07-18 04:22:07 | Chernivtsi Oblast, Ukraine | ||
3706043 | 3706043 | 2021-07-17 | Germany | Saarland | 41661 | 1030 | 40560 | 97 | 49.3964 | 7.023 | 2021-07-18 04:22:07 | Saarland, Germany | ||
3705983 | 3705983 | 2021-07-17 | Colombia | San Andres y Providencia | 6598 | 132 | 6369 | 97 | 12.5567 | -81.7185 | 2021-07-18 04:22:07 | San Andres y Providencia, Colombia | ||
2950999 | 2950999 | 2021-07-16 | Ukraine | Volyn Oblast | 62246 | 1203 | 60946 | 97 | 50.7472 | 25.3254 | 2021-07-17 04:22:22 | Volyn Oblast, Ukraine | ||
2947274 | 2947274 | 2021-07-16 | Germany | Saarland | 41661 | 1030 | 40560 | 97 | 49.3964 | 7.023 | 2021-07-17 04:22:22 | Saarland, Germany | ||
3631962 | 3631962 | 2021-07-14 | Japan | Fukui | 1403 | 35 | 1271 | 97 | 35.846614 | 136.22465400000002 | 2021-07-15 04:21:48 | Fukui, Japan | ||
3744719 | 3744719 | 2021-07-12 | Ukraine | Rivne Oblast | 79567 | 1206 | 78264 | 97 | 50.6199 | 26.2516 | 2021-07-13 04:21:18 | Rivne Oblast, Ukraine | ||
3740871 | 3740871 | 2021-07-12 | Chile | Magallanes | 29040 | 468 | 28475 | 97 | -52.368 | -70.9863 | 2021-07-13 04:21:18 | Magallanes, Chile | ||
3663232 | 3663232 | 2021-07-11 | Ukraine | Rivne Oblast | 79566 | 1206 | 78263 | 97 | 50.6199 | 26.2516 | 2021-07-12 04:21:34 | Rivne Oblast, Ukraine | ||
629516 | 629516 | 2021-07-10 | Ukraine | Rivne Oblast | 79564 | 1206 | 78261 | 97 | 50.6199 | 26.2516 | 2021-07-11 04:21:43 | Rivne Oblast, Ukraine | ||
1440779 | 1440779 | 2021-07-07 | Russia | Chukotka Autonomous Okrug | 870 | 8 | 765 | 97 | 66.0006475 | 169.4900869 | 2021-07-08 04:21:26 | Chukotka Autonomous Okrug, Russia | ||
1440468 | 1440468 | 2021-07-07 | Equatorial Guinea | 8775 | 122 | 8556 | 97 | 1.6508 | 10.2679 | 2021-07-08 04:21:26 | Equatorial Guinea | |||
2693573 | 2693573 | 2021-07-06 | Equatorial Guinea | 8775 | 122 | 8556 | 97 | 1.6508 | 10.2679 | 2021-07-07 04:21:20 | Equatorial Guinea | |||
1495628 | 1495628 | 2021-07-03 | Japan | Nagasaki | 3212 | 69 | 3046 | 97 | 33.235712 | 129.608033 | 2021-07-04 04:21:38 | Nagasaki, Japan | ||
1893177 | 1893177 | 2021-06-30 | Japan | Shiga | 5555 | 90 | 5368 | 97 | 35.21582700000001 | 136.138064 | 2021-07-01 04:21:19 | Shiga, Japan | ||
3958364 | 3958364 | 2021-06-26 | Colombia | San Andres y Providencia | 6251 | 123 | 6031 | 97 | 12.5567 | -81.7185 | 2021-06-27 04:21:39 | San Andres y Providencia, Colombia | ||
2295308 | 2295308 | 2021-06-24 | Colombia | San Andres y Providencia | 6215 | 123 | 5995 | 97 | 12.5567 | -81.7185 | 2021-06-25 04:21:33 | San Andres y Providencia, Colombia | ||
562972 | 562972 | 2021-06-22 | Japan | Fukui | 1155 | 34 | 1024 | 97 | 35.846614 | 136.22465400000002 | 2021-06-23 04:21:46 | Fukui, Japan | ||
562825 | 562825 | 2021-06-22 | Colombia | San Andres y Providencia | 6184 | 122 | 5965 | 97 | 12.5567 | -81.7185 | 2021-06-23 04:21:46 | San Andres y Providencia, Colombia | ||
3358695 | 3358695 | 2021-06-21 | Japan | Nagasaki | 3115 | 69 | 2949 | 97 | 33.235712 | 129.608033 | 2021-06-22 04:21:34 | Nagasaki, Japan | ||
3358605 | 3358605 | 2021-06-21 | India | Andaman and Nicobar Islands | 7415 | 127 | 7191 | 97 | 11.225999 | 92.968178 | 2021-06-22 04:21:34 | Andaman and Nicobar Islands, India | ||
2884385 | 2884385 | 2021-06-20 | Japan | Kagoshima | 3635 | 35 | 3503 | 97 | 31.009484000000004 | 130.430665 | 2021-06-21 04:21:41 | Kagoshima, Japan | ||
107653 | 107653 | 2021-06-19 | Russia | Jewish Autonomous Okrug | 4593 | 146 | 4350 | 97 | 48.57527615 | 132.66307460000002 | 2021-06-20 04:21:48 | Jewish Autonomous Okrug, Russia | ||
107595 | 107595 | 2021-06-19 | Pakistan | Gilgit-Baltistan | 5771 | 108 | 5566 | 97 | 35.792146 | 74.982138 | 2021-06-20 04:21:48 | Gilgit-Baltistan, Pakistan | ||
107484 | 107484 | 2021-06-19 | Japan | Port Quarantine | 3064 | 4 | 2963 | 97 | 2021-06-20 04:21:48 | Port Quarantine, Japan | ||||
1125738 | 1125738 | 2021-06-18 | Pakistan | Gilgit-Baltistan | 5771 | 108 | 5566 | 97 | 35.792146 | 74.982138 | 2021-06-19 04:22:33 | Gilgit-Baltistan, Pakistan | ||
2910943 | 2910943 | 2021-06-17 | Canada | Nova Scotia | 5773 | 90 | 5586 | 97 | 44.682 | -63.7443 | 2021-06-18 04:22:16 | Nova Scotia, Canada | ||
2339167 | 2339167 | 2021-06-15 | Canada | Nova Scotia | 5751 | 90 | 5564 | 97 | 44.682 | -63.7443 | 2021-06-16 04:22:32 | Nova Scotia, Canada | ||
3381630 | 3381630 | 2021-06-13 | Russia | Tyva Republic | 16038 | 203 | 15738 | 97 | 51.4017149 | 93.8582593 | 2021-06-14 04:22:46 | Tyva Republic, Russia | ||
1736730 | 1736730 | 2021-06-12 | Russia | Magadan Oblast | 8522 | 112 | 8313 | 97 | 62.48858785 | 153.9903764 | 2021-06-13 04:22:44 | Magadan Oblast, Russia | ||
3970593 | 3970593 | 2021-06-11 | Japan | Toyama | 1949 | 37 | 1815 | 97 | 36.637464 | 137.26934599999998 | 2021-06-12 04:22:22 | Toyama, Japan | ||
2717193 | 2717193 | 2021-06-10 | Russia | Magadan Oblast | 8512 | 111 | 8304 | 97 | 62.48858785 | 153.9903764 | 2021-06-11 04:23:20 | Magadan Oblast, Russia | ||
523078 | 523078 | 2021-06-09 | Russia | Magadan Oblast | 8506 | 111 | 8298 | 97 | 62.48858785 | 153.9903764 | 2021-06-10 04:23:17 | Magadan Oblast, Russia | ||
3472343 | 3472343 | 2021-06-08 | Japan | Yamagata | 2000 | 45 | 1858 | 97 | 38.448396 | 140.102154 | 2021-06-09 04:23:31 | Yamagata, Japan | ||
3471987 | 3471987 | 2021-06-08 | Andorra | 13781 | 127 | 13557 | 97 | 42.5063 | 1.5218 | 2021-06-09 04:23:31 | Andorra | |||
3145802 | 3145802 | 2021-06-07 | Russia | Magadan Oblast | 8496 | 111 | 8288 | 97 | 62.48858785 | 153.9903764 | 2021-06-08 04:22:35 | Magadan Oblast, Russia | ||
825305 | 825305 | 2021-06-06 | Belize | 12861 | 325 | 12439 | 97 | 17.1899 | -88.4976 | 2021-06-07 04:22:51 | Belize | |||
2586209 | 2586209 | 2021-06-05 | Russia | Magadan Oblast | 8488 | 111 | 8280 | 97 | 62.48858785 | 153.9903764 | 2021-06-06 04:24:03 | Magadan Oblast, Russia | ||
2585710 | 2585710 | 2021-06-05 | Belize | 12861 | 325 | 12439 | 97 | 17.1899 | -88.4976 | 2021-06-06 04:24:03 | Belize | |||
2315024 | 2315024 | 2021-06-04 | Belize | 12861 | 325 | 12439 | 97 | 17.1899 | -88.4976 | 2021-06-05 04:23:03 | Belize | |||
50795 | 50795 | 2021-05-29 | Japan | Ehime | 2706 | 72 | 2537 | 97 | 33.624835 | 132.856842 | 2021-05-30 04:20:55 | Ehime, Japan | ||
20374 | 20374 | 2021-05-28 | Japan | Ehime | 2699 | 72 | 2530 | 97 | 33.624835 | 132.856842 | 2021-05-29 04:20:41 | Ehime, Japan | ||
1310389 | 1310389 | 2021-05-26 | Russia | Magadan Oblast | 8441 | 108 | 8236 | 97 | 62.48858785 | 153.9903764 | 2021-05-27 04:20:59 | Magadan Oblast, Russia | ||
1309938 | 1309938 | 2021-05-26 | Canada | Newfoundland and Labrador | 1273 | 6 | 1170 | 97 | 53.1355 | -57.6604 | 2021-05-27 04:20:59 | Newfoundland and Labrador, Canada | ||
82864 | 82864 | 2021-05-25 | Canada | Newfoundland and Labrador | 1269 | 6 | 1166 | 97 | 53.1355 | -57.6604 | 2021-05-26 04:20:35 | Newfoundland and Labrador, Canada | ||
1952532 | 1952532 | 2021-05-21 | Japan | Kochi | 1215 | 20 | 1098 | 97 | 33.422519 | 133.367307 | 2021-05-22 04:20:45 | Kochi, Japan | ||
3574365 | 3574365 | 2021-05-17 | Canada | Newfoundland and Labrador | 1203 | 6 | 1100 | 97 | 53.1355 | -57.6604 | 2021-05-18 04:20:33 | Newfoundland and Labrador, Canada | ||
2004777 | 2004777 | 2021-05-12 | Netherlands | Aruba | 10814 | 104 | 10613 | 97 | 12.5211 | -69.9683 | 2021-05-13 04:20:51 | Aruba, Netherlands | ||
1425357 | 1425357 | 2021-05-09 | Russia | Tyva Republic | 15849 | 202 | 15550 | 97 | 51.4017149 | 93.8582593 | 2021-05-10 04:20:38 | Tyva Republic, Russia | ||
3675409 | 3675409 | 2021-05-04 | Burkina Faso | 13339 | 161 | 13081 | 97 | 12.2383 | -1.5616 | 2021-05-05 04:20:43 | Burkina Faso | |||
2824786 | 2824786 | 2021-05-01 | Japan | Akita | 480 | 9 | 374 | 97 | 39.748679 | 140.408228 | 2021-05-02 04:20:48 | Akita, Japan | ||
3393119 | 3393119 | 2021-04-28 | Bhutan | 1059 | 1 | 961 | 97 | 27.5142 | 90.4336 | 2021-04-29 04:20:55 | Bhutan | |||
3924036 | 3924036 | 2021-04-24 | Japan | Miyazaki | 2120 | 22 | 2001 | 97 | 32.193203999999994 | 131.299374 | 2021-04-25 04:20:32 | Miyazaki, Japan | ||
1571791 | 1571791 | 2021-04-22 | Malaysia | Terengganu | 3943 | 14 | 3832 | 97 | 5.3117 | 103.1324 | 2021-04-23 04:20:52 | Terengganu, Malaysia | ||
2410986 | 2410986 | 2021-04-19 | Pakistan | Gilgit-Baltistan | 5191 | 104 | 4990 | 97 | 35.792146 | 74.982138 | 2021-04-20 04:20:41 | Gilgit-Baltistan, Pakistan | ||
2410779 | 2410779 | 2021-04-19 | Iceland | 6329 | 29 | 6203 | 97 | 64.9631 | -19.0208 | 2021-04-20 04:20:41 | Iceland | |||
2571899 | 2571899 | 2021-04-13 | Russia | Magadan Oblast | 8282 | 99 | 8086 | 97 | 62.48858785 | 153.9903764 | 2021-04-14 04:20:41 | Magadan Oblast, Russia | ||
40118 | 40118 | 2021-04-12 | Malaysia | W.P. Putrajaya | 1238 | 9 | 1132 | 97 | 2.9264 | 101.6964 | 2021-04-13 04:20:37 | W.P. Putrajaya, Malaysia | ||
605909 | 605909 | 2021-04-09 | Russia | Magadan Oblast | 8273 | 99 | 8077 | 97 | 62.48858785 | 153.9903764 | 2021-04-10 04:20:59 | Magadan Oblast, Russia | ||
2645718 | 2645718 | 2021-04-08 | India | Sikkim | 6323 | 136 | 6090 | 97 | 27.571671 | 88.472712 | 2021-04-09 04:21:13 | Sikkim, India | ||
241110 | 241110 | 2021-04-02 | Colombia | Putumayo | 8215 | 325 | 7793 | 97 | 0.436 | -75.5277 | 2021-04-03 04:20:44 | Putumayo, Colombia | ||
638194 | 638194 | 2021-03-31 | Sao Tome and Principe | 2223 | 34 | 2092 | 97 | 0.1864 | 6.6131 | 2021-04-01 04:27:05 | Sao Tome and Principe | |||
1880830 | 1880830 | 2021-03-26 | Colombia | Choco | 6660 | 204 | 6359 | 97 | 5.2528 | -76.82600000000002 | 2021-03-27 05:25:04 | Choco, Colombia | ||
1980649 | 1980649 | 2021-03-25 | Japan | Port Quarantine | 2357 | 2 | 2258 | 97 | 2021-03-26 05:26:55 | Port Quarantine, Japan | ||||
3373007 | 3373007 | 2021-03-21 | Malaysia | Pahang | 4011 | 16 | 3898 | 97 | 3.8126 | 103.3256 | 2021-03-22 05:25:43 | Pahang, Malaysia | ||
1744569 | 1744569 | 2021-03-20 | Japan | Okayama | 2611 | 35 | 2479 | 97 | 34.89246 | 133.826252 | 2021-03-21 05:25:44 | Okayama, Japan | ||
3621214 | 3621214 | 2021-03-17 | New Zealand | 2434 | 28 | 2311 | 97 | -40.9006 | 174.886 | 2021-03-18 05:26:22 | New Zealand | |||
702538 | 702538 | 2021-03-16 | New Zealand | 2434 | 28 | 2311 | 97 | -40.9006 | 174.886 | 2021-03-17 05:25:07 | New Zealand | |||
1732828 | 1732828 | 2021-03-14 | Timor-Leste | 196 | 0 | 99 | 97 | -8.874217 | 125.727539 | 2021-03-15 05:25:51 | Timor-Leste | |||
1732523 | 1732523 | 2021-03-14 | Japan | Niigata | 1182 | 16 | 1069 | 97 | 37.521819 | 138.918647 | 2021-03-15 05:25:51 | Niigata, Japan | ||
1580428 | 1580428 | 2021-03-13 | Singapore | 60088 | 30 | 59961 | 97 | 1.2833 | 103.8333 | 2021-03-14 05:25:37 | Singapore | |||
3663749 | 3663749 | 2021-03-09 | Pakistan | Balochistan | 19141 | 202 | 18842 | 97 | 28.328492 | 65.898403 | 2021-03-10 05:24:35 | Balochistan, Pakistan | ||
3667740 | 3667740 | 2021-03-06 | Netherlands | Curacao | 4790 | 22 | 4671 | 97 | 12.1696 | -68.99 | 2021-03-07 05:21:54 | Curacao, Netherlands | ||
1616028 | 1616028 | 2021-03-05 | Chile | Aysen | 3142 | 25 | 3020 | 97 | -45.9864 | -73.7669 | 2021-03-06 04:23:41 | Aysen, Chile | ||
3254482 | 3254482 | 2021-03-02 | Trinidad and Tobago | 7717 | 139 | 7481 | 97 | 10.6918 | -61.2225 | 2021-03-03 05:23:28 | Trinidad and Tobago | |||
998283 | 998283 | 2021-03-01 | Colombia | Choco | 6554 | 201 | 6256 | 97 | 5.2528 | -76.82600000000002 | 2021-03-02 05:23:30 | Choco, Colombia | ||
182047 | 182047 | 2021-02-21 | Japan | Fukushima | 1872 | 68 | 1707 | 97 | 37.378867 | 140.223295 | 2021-02-22 05:24:21 | Fukushima, Japan | ||
474688 | 474688 | 2021-02-19 | US | Vermont | Grand Isle | 50013 | 97 | 0 | 0 | 97 | 44.7975824 | -73.29679772 | 2021-02-20 05:22:51 | Grand Isle, Vermont, US |
471435 | 471435 | 2021-02-19 | Japan | Miyagi | 3540 | 23 | 3420 | 97 | 38.446859 | 140.927086 | 2021-02-20 05:22:51 | Miyagi, Japan | ||
3600995 | 3600995 | 2021-02-17 | India | Lakshadweep | 261 | 0 | 164 | 97 | 13.6999972 | 72.18333259999999 | 2021-02-18 05:22:58 | Lakshadweep, India | ||
2283380 | 2283380 | 2021-02-14 | India | Lakshadweep | 233 | 0 | 136 | 97 | 13.6999972 | 72.18333259999999 | 2021-02-15 05:24:49 | Lakshadweep, India | ||
3542546 | 3542546 | 2021-02-12 | US | Texas | Glasscock | 48173 | 90 | 2 | 0 | 97 | 31.86942909 | -101.5207776 | 2021-02-13 05:22:12 | Glasscock, Texas, US |
3539658 | 3539658 | 2021-02-12 | Russia | Jewish Autonomous Okrug | 4259 | 110 | 4052 | 97 | 48.57527615 | 132.66307460000002 | 2021-02-13 05:22:12 | Jewish Autonomous Okrug, Russia | ||
3539487 | 3539487 | 2021-02-12 | Japan | Niigata | 993 | 13 | 883 | 97 | 37.521819 | 138.918647 | 2021-02-13 05:22:12 | Niigata, Japan | ||
615793 | 615793 | 2021-02-08 | US | Nebraska | Rock | 31149 | 99 | 2 | 0 | 97 | 42.42252217 | -99.44832069 | 2021-02-09 05:23:30 | Rock, Nebraska, US |
1674562 | 1674562 | 2021-02-07 | US | Nebraska | Rock | 31149 | 99 | 2 | 0 | 97 | 42.42252217 | -99.44832069 | 2021-02-08 05:22:39 | Rock, Nebraska, US |
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]);