johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
696 rows where active = 275 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 603
- Japan 12
- Chile 9
- France 7
- Mexico 6
- Russia 5
- Ukraine 5
- Malaysia 4
- South Sudan 4
- China 3
- Vietnam 3
- Barbados 2
- Bhutan 2
- Colombia 2
- India 2
- Italy 2
- Spain 2
- Suriname 2
- Trinidad and Tobago 2
- West Bank and Gaza 2
- Burkina Faso 1
- Canada 1
- Cote d'Ivoire 1
- Cyprus 1
- Djibouti 1
- Eritrea 1
- Netherlands 1
- Niger 1
- Paraguay 1
- Peru 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107006 | 107006 | 2021-08-15 | Malaysia | Perlis | 1042 | 13 | 754 | 275 | 6.4449 | 100.2048 | 2021-08-16 04:21:31 | Perlis, Malaysia | ||
3476035 | 3476035 | 2021-07-22 | Bhutan | 2458 | 2 | 2181 | 275 | 27.5142 | 90.4336 | 2021-07-23 04:21:29 | Bhutan | |||
3331416 | 3331416 | 2021-07-21 | Eritrea | 6473 | 32 | 6166 | 275 | 15.1794 | 39.7823 | 2021-07-22 04:21:19 | Eritrea | |||
3331254 | 3331254 | 2021-07-21 | Bhutan | 2456 | 2 | 2179 | 275 | 27.5142 | 90.4336 | 2021-07-22 04:21:19 | Bhutan | |||
2375166 | 2375166 | 2021-07-20 | United Kingdom | Gibraltar | 4671 | 94 | 4302 | 275 | 36.1408 | -5.3536 | 2021-07-21 04:21:40 | Gibraltar, United Kingdom | ||
2677459 | 2677459 | 2021-07-18 | Ukraine | Zhytomyr Oblast | 88647 | 1800 | 86572 | 275 | 50.2547 | 28.6587 | 2021-07-19 04:21:24 | Zhytomyr Oblast, Ukraine | ||
1440862 | 1440862 | 2021-07-07 | Singapore | 62652 | 36 | 62341 | 275 | 1.2833 | 103.8333 | 2021-07-08 04:21:26 | Singapore | |||
2693956 | 2693956 | 2021-07-06 | Saint Kitts and Nevis | 515 | 3 | 237 | 275 | 17.357822 | -62.782998 | 2021-07-07 04:21:20 | Saint Kitts and Nevis | |||
1168803 | 1168803 | 2021-07-04 | Ukraine | Mykolaiv Oblast | 70012 | 1847 | 67890 | 275 | 46.975 | 31.9946 | 2021-07-05 04:21:28 | Mykolaiv Oblast, Ukraine | ||
1893479 | 1893479 | 2021-06-30 | Togo | 13917 | 129 | 13513 | 275 | 8.6195 | 0.8248 | 2021-07-01 04:21:19 | Togo | |||
2339580 | 2339580 | 2021-06-15 | Russia | Altai Republic | 17357 | 247 | 16835 | 275 | 50.7114101 | 86.8572186 | 2021-06-16 04:22:32 | Altai Republic, Russia | ||
1564131 | 1564131 | 2021-06-14 | Japan | Tochigi | 6688 | 80 | 6333 | 275 | 36.689912 | 139.819213 | 2021-06-15 04:22:22 | Tochigi, Japan | ||
3381165 | 3381165 | 2021-06-13 | Chile | Magallanes | 28350 | 427 | 27648 | 275 | -52.368 | -70.9863 | 2021-06-14 04:22:46 | Magallanes, Chile | ||
1736557 | 1736557 | 2021-06-12 | Japan | Yamanashi | 1832 | 20 | 1537 | 275 | 35.612364 | 138.61148899999998 | 2021-06-13 04:22:44 | Yamanashi, Japan | ||
2586191 | 2586191 | 2021-06-05 | Russia | Kalmykia Republic | 20902 | 382 | 20245 | 275 | 46.2313018 | 45.3275745 | 2021-06-06 04:24:03 | Kalmykia Republic, Russia | ||
50631 | 50631 | 2021-05-29 | Colombia | Caqueta | 18219 | 681 | 17263 | 275 | 0.8699 | -73.8419 | 2021-05-30 04:20:55 | Caqueta, Colombia | ||
1310193 | 1310193 | 2021-05-26 | Japan | Miyazaki | 2996 | 25 | 2696 | 275 | 32.193203999999994 | 131.299374 | 2021-05-27 04:20:59 | Miyazaki, Japan | ||
1413083 | 1413083 | 2021-05-24 | Japan | Nagasaki | 2829 | 61 | 2493 | 275 | 33.235712 | 129.608033 | 2021-05-25 04:21:08 | Nagasaki, Japan | ||
1081970 | 1081970 | 2021-05-14 | Japan | Wakayama | 2454 | 35 | 2144 | 275 | 33.911879 | 135.505446 | 2021-05-15 04:20:58 | Wakayama, Japan | ||
2024387 | 2024387 | 2021-04-20 | Vietnam | 2800 | 35 | 2490 | 275 | 14.058324 | 108.277199 | 2021-04-21 04:21:14 | Vietnam | |||
3133185 | 3133185 | 2021-04-18 | Vietnam | 2785 | 35 | 2475 | 275 | 14.058324 | 108.277199 | 2021-04-19 04:20:57 | Vietnam | |||
605717 | 605717 | 2021-04-09 | Japan | Niigata | 1681 | 18 | 1388 | 275 | 37.521819 | 138.918647 | 2021-04-10 04:20:59 | Niigata, Japan | ||
605590 | 605590 | 2021-04-09 | France | St Martin | 1687 | 13 | 1399 | 275 | 18.0708 | -63.0501 | 2021-04-10 04:20:59 | St Martin, France | ||
2645654 | 2645654 | 2021-04-08 | France | St Martin | 1687 | 13 | 1399 | 275 | 18.0708 | -63.0501 | 2021-04-09 04:21:13 | St Martin, France | ||
2247296 | 2247296 | 2021-04-07 | France | St Martin | 1687 | 13 | 1399 | 275 | 18.0708 | -63.0501 | 2021-04-08 04:21:13 | St Martin, France | ||
3003206 | 3003206 | 2021-04-06 | France | St Martin | 1687 | 13 | 1399 | 275 | 18.0708 | -63.0501 | 2021-04-07 04:20:53 | St Martin, France | ||
3085201 | 3085201 | 2021-04-05 | France | St Martin | 1687 | 13 | 1399 | 275 | 18.0708 | -63.0501 | 2021-04-06 04:20:32 | St Martin, France | ||
388124 | 388124 | 2021-04-04 | France | St Martin | 1687 | 13 | 1399 | 275 | 18.0708 | -63.0501 | 2021-04-05 04:20:35 | St Martin, France | ||
3710040 | 3710040 | 2021-04-03 | France | St Martin | 1687 | 13 | 1399 | 275 | 18.0708 | -63.0501 | 2021-04-04 04:20:49 | St Martin, France | ||
241462 | 241462 | 2021-04-02 | Russia | Kemerovo Oblast | 33362 | 615 | 32472 | 275 | 54.53357809999999 | 87.342861 | 2021-04-03 04:20:44 | Kemerovo Oblast, Russia | ||
702284 | 702284 | 2021-03-16 | Djibouti | 6336 | 63 | 5998 | 275 | 11.8251 | 42.5903 | 2021-03-17 05:25:07 | Djibouti | |||
352004 | 352004 | 2021-03-11 | Barbados | 3372 | 37 | 3060 | 275 | 13.1939 | -59.5432 | 2021-03-12 05:26:50 | Barbados | |||
3669572 | 3669572 | 2021-03-06 | US | Missouri | Schuyler | 29197 | 280 | 5 | 0 | 275 | 40.46921489 | -92.52311943 | 2021-03-07 05:21:54 | Schuyler, Missouri, US |
3067552 | 3067552 | 2021-02-27 | US | Maine | Piscataquis | 23021 | 276 | 1 | 0 | 275 | 45.83839062 | -69.2860223 | 2021-02-28 05:22:20 | Piscataquis, Maine, US |
283851 | 283851 | 2021-02-24 | US | Alaska | Chugach | 2063 | 278 | 3 | 0 | 275 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
282413 | 282413 | 2021-02-24 | US | New York | Hamilton | 36041 | 277 | 2 | 0 | 275 | 43.66146647 | -74.49721957 | 2021-02-25 05:24:57 | Hamilton, New York, US |
1938681 | 1938681 | 2021-02-23 | US | New York | Hamilton | 36041 | 277 | 2 | 0 | 275 | 43.66146647 | -74.49721957 | 2021-02-24 05:29:16 | Hamilton, New York, US |
1938437 | 1938437 | 2021-02-23 | US | Montana | Fallon | 30025 | 277 | 2 | 0 | 275 | 46.33478338 | -104.4183565 | 2021-02-24 05:29:16 | Fallon, Montana, US |
532692 | 532692 | 2021-02-22 | US | Montana | Fallon | 30025 | 277 | 2 | 0 | 275 | 46.33478338 | -104.4183565 | 2021-02-23 05:23:41 | Fallon, Montana, US |
184026 | 184026 | 2021-02-21 | US | Montana | Fallon | 30025 | 277 | 2 | 0 | 275 | 46.33478338 | -104.4183565 | 2021-02-22 05:24:21 | Fallon, Montana, US |
182223 | 182223 | 2021-02-21 | Russia | Altai Republic | 16090 | 146 | 15669 | 275 | 50.7114101 | 86.8572186 | 2021-02-22 05:24:21 | Altai Republic, Russia | ||
744300 | 744300 | 2021-02-20 | US | Montana | Fallon | 30025 | 277 | 2 | 0 | 275 | 46.33478338 | -104.4183565 | 2021-02-21 05:24:33 | Fallon, Montana, US |
473398 | 473398 | 2021-02-19 | US | Montana | Fallon | 30025 | 277 | 2 | 0 | 275 | 46.33478338 | -104.4183565 | 2021-02-20 05:22:51 | Fallon, Montana, US |
1154439 | 1154439 | 2021-02-18 | US | Kansas | Osborne | 20141 | 284 | 9 | 0 | 275 | 39.3503437 | -98.76753828 | 2021-02-19 05:24:16 | Osborne, Kansas, US |
3602359 | 3602359 | 2021-02-17 | US | Kansas | Osborne | 20141 | 284 | 9 | 0 | 275 | 39.3503437 | -98.76753828 | 2021-02-18 05:22:58 | Osborne, Kansas, US |
3540486 | 3540486 | 2021-02-12 | US | Illinois | Pope | 17151 | 278 | 3 | 0 | 275 | 37.41391284 | -88.56152109 | 2021-02-13 05:22:12 | Pope, Illinois, US |
617199 | 617199 | 2021-02-08 | US | West Virginia | Webster | 54101 | 275 | 0 | 0 | 275 | 38.49370949 | -80.4202023 | 2021-02-09 05:23:30 | Webster, West Virginia, US |
1675846 | 1675846 | 2021-02-07 | US | Virginia | Rappahannock | 51157 | 277 | 2 | 0 | 275 | 38.68295619 | -78.15826963 | 2021-02-08 05:22:39 | Rappahannock, Virginia, US |
978307 | 978307 | 2021-02-06 | US | Virginia | Rappahannock | 51157 | 277 | 2 | 0 | 275 | 38.68295619 | -78.15826963 | 2021-02-07 05:23:00 | Rappahannock, Virginia, US |
790430 | 790430 | 2021-02-04 | Japan | Yamaguchi | 1279 | 24 | 980 | 275 | 34.201190000000004 | 131.573293 | 2021-02-05 05:22:38 | Yamaguchi, Japan | ||
343351 | 343351 | 2021-02-03 | US | Texas | Fisher | 48151 | 311 | 12 | 0 | 275 | 32.74281316 | -100.4019302 | 2021-02-04 05:22:26 | Fisher, Texas, US |
343323 | 343323 | 2021-02-03 | US | Texas | Concho | 48095 | 335 | 5 | 0 | 275 | 31.32635934 | -99.86473038 | 2021-02-04 05:22:26 | Concho, Texas, US |
1687577 | 1687577 | 2021-02-02 | US | Texas | Fisher | 48151 | 311 | 12 | 0 | 275 | 32.74281316 | -100.4019302 | 2021-02-03 05:22:52 | Fisher, Texas, US |
2212283 | 2212283 | 2021-01-30 | US | Colorado | Huerfano | 8055 | 297 | 16 | 0 | 275 | 37.68473101 | -104.9612585 | 2021-01-31 05:22:42 | Huerfano, Colorado, US |
1897770 | 1897770 | 2021-01-29 | US | Colorado | Huerfano | 8055 | 297 | 16 | 0 | 275 | 37.68473101 | -104.9612585 | 2021-01-30 05:22:49 | Huerfano, Colorado, US |
1897489 | 1897489 | 2021-01-29 | Trinidad and Tobago | 7533 | 134 | 7124 | 275 | 10.6918 | -61.2225 | 2021-01-30 05:22:49 | Trinidad and Tobago | |||
12759 | 12759 | 2021-01-26 | US | Alaska | Ketchikan Gateway | 2130 | 276 | 1 | 0 | 275 | 55.57445008 | -130.975561 | 2021-01-27 05:23:41 | Ketchikan Gateway, Alaska, US |
2568083 | 2568083 | 2021-01-25 | US | Alaska | Ketchikan Gateway | 2130 | 276 | 1 | 0 | 275 | 55.57445008 | -130.975561 | 2021-01-26 05:22:02 | Ketchikan Gateway, Alaska, US |
1762059 | 1762059 | 2021-01-24 | US | Puerto Rico | Rincon | 72117 | 275 | 0 | 0 | 275 | 18.335443 | -67.23174 | 2021-01-25 05:22:16 | Rincon, Puerto Rico, US |
1761302 | 1761302 | 2021-01-24 | US | Montana | Musselshell | 30065 | 283 | 8 | 0 | 275 | 46.49684637 | -108.39498 | 2021-01-25 05:22:16 | Musselshell, Montana, US |
1759715 | 1759715 | 2021-01-24 | US | Alaska | Ketchikan Gateway | 2130 | 276 | 1 | 0 | 275 | 55.57445008 | -130.975561 | 2021-01-25 05:22:16 | Ketchikan Gateway, Alaska, US |
2428909 | 2428909 | 2021-01-23 | US | Montana | Musselshell | 30065 | 283 | 8 | 0 | 275 | 46.49684637 | -108.39498 | 2021-01-24 05:22:35 | Musselshell, Montana, US |
438791 | 438791 | 2021-01-21 | US | Washington | Jefferson | 53031 | 277 | 2 | 0 | 275 | 47.75003077 | -123.56097040000002 | 2021-01-22 05:22:10 | Jefferson, Washington, US |
436681 | 436681 | 2021-01-21 | US | Kansas | Rawlins | 20153 | 281 | 6 | 0 | 275 | 39.78525843 | -101.0761617 | 2021-01-22 05:22:10 | Rawlins, Kansas, US |
1096966 | 1096966 | 2021-01-20 | US | South Dakota | Marshall | 46091 | 280 | 5 | 0 | 275 | 45.75870838 | -97.59855639 | 2021-01-21 05:22:01 | Marshall, South Dakota, US |
1095412 | 1095412 | 2021-01-20 | US | Kansas | Rawlins | 20153 | 281 | 6 | 0 | 275 | 39.78525843 | -101.0761617 | 2021-01-21 05:22:01 | Rawlins, Kansas, US |
909090 | 909090 | 2021-01-19 | US | Idaho | Boise | 16015 | 277 | 2 | 0 | 275 | 43.98829931 | -115.7309284 | 2021-01-20 05:21:54 | Boise, Idaho, US |
3506128 | 3506128 | 2021-01-17 | US | Puerto Rico | Santa Isabel | 72133 | 275 | 0 | 0 | 275 | 17.994525 | -66.388913 | 2021-01-18 05:22:34 | Santa Isabel, Puerto Rico, US |
3505363 | 3505363 | 2021-01-17 | US | Montana | Musselshell | 30065 | 282 | 7 | 0 | 275 | 46.49684637 | -108.39498 | 2021-01-18 05:22:34 | Musselshell, Montana, US |
3103446 | 3103446 | 2021-01-16 | US | Montana | Musselshell | 30065 | 282 | 7 | 0 | 275 | 46.49684637 | -108.39498 | 2021-01-17 05:22:17 | Musselshell, Montana, US |
3518634 | 3518634 | 2021-01-15 | US | Texas | Upton | 48461 | 243 | 7 | 0 | 275 | 31.36868194 | -102.0423217 | 2021-01-16 05:22:40 | Upton, Texas, US |
3516760 | 3516760 | 2021-01-15 | US | Kentucky | Ballard | 21007 | 278 | 3 | 0 | 275 | 37.05842757 | -88.99427697 | 2021-01-16 05:22:40 | Ballard, Kentucky, US |
3308661 | 3308661 | 2021-01-13 | US | Arkansas | Calhoun | 5013 | 276 | 1 | 0 | 275 | 33.55598792 | -92.49974403 | 2021-01-14 05:22:32 | Calhoun, Arkansas, US |
3308220 | 3308220 | 2021-01-13 | Japan | Kagoshima | 1301 | 14 | 1012 | 275 | 31.009484000000004 | 130.430665 | 2021-01-14 05:22:32 | Kagoshima, Japan | ||
774682 | 774682 | 2021-01-12 | Trinidad and Tobago | 7286 | 128 | 6883 | 275 | 10.6918 | -61.2225 | 2021-01-13 05:22:15 | Trinidad and Tobago | |||
191053 | 191053 | 2021-01-11 | US | Illinois | Hardin | 17069 | 283 | 8 | 0 | 275 | 37.51810645 | -88.26873022 | 2021-01-12 05:22:15 | Hardin, Illinois, US |
3899982 | 3899982 | 2021-01-09 | Japan | Mie | 1520 | 22 | 1223 | 275 | 34.508018 | 136.376013 | 2021-01-10 05:22:12 | Mie, Japan | ||
157036 | 157036 | 2021-01-08 | US | Texas | Culberson | 48109 | 253 | 4 | 0 | 275 | 31.44506775 | -104.5185739 | 2021-01-09 05:22:18 | Culberson, Texas, US |
2544677 | 2544677 | 2021-01-07 | US | Vermont | Caledonia | 50005 | 279 | 4 | 0 | 275 | 44.46548598 | -72.10314651 | 2021-01-08 05:22:42 | Caledonia, Vermont, US |
3034943 | 3034943 | 2021-01-05 | US | Colorado | Rio Blanco | 8103 | 318 | 3 | 0 | 275 | 39.97913541 | -108.2179009 | 2021-01-06 05:22:16 | Rio Blanco, Colorado, US |
1062756 | 1062756 | 2021-01-04 | US | Idaho | Bear Lake | 16007 | 277 | 2 | 0 | 275 | 42.28269683 | -111.32892379999998 | 2021-01-05 05:21:49 | Bear Lake, Idaho, US |
1062116 | 1062116 | 2021-01-04 | San Marino | 2463 | 61 | 2127 | 275 | 43.9424 | 12.4578 | 2021-01-05 05:21:49 | San Marino | |||
1061557 | 1061557 | 2021-01-04 | Barbados | 606 | 7 | 324 | 275 | 13.1939 | -59.5432 | 2021-01-05 05:21:49 | Barbados | |||
1139487 | 1139487 | 2021-01-01 | US | Oregon | Curry | 41015 | 278 | 3 | 0 | 275 | 42.45911325 | -124.157282 | 2021-01-02 05:22:33 | Curry, Oregon, US |
1137306 | 1137306 | 2021-01-01 | US | Alaska | Nome | 2180 | 275 | 0 | 0 | 275 | 64.90320724 | -164.0353804 | 2021-01-02 05:22:33 | Nome, Alaska, US |
3698093 | 3698093 | 2020-12-31 | US | Oregon | Curry | 41015 | 278 | 3 | 0 | 275 | 42.45911325 | -124.157282 | 2021-01-01 05:23:07 | Curry, Oregon, US |
3695912 | 3695912 | 2020-12-31 | US | Alaska | Nome | 2180 | 275 | 0 | 0 | 275 | 64.90320724 | -164.0353804 | 2021-01-01 05:23:07 | Nome, Alaska, US |
1010727 | 1010727 | 2020-12-30 | US | Alaska | Nome | 2180 | 275 | 0 | 0 | 275 | 64.90320724 | -164.0353804 | 2020-12-31 05:22:49 | Nome, Alaska, US |
769781 | 769781 | 2020-12-29 | US | West Virginia | Braxton | 54007 | 276 | 1 | 0 | 275 | 38.70036159 | -80.72011184 | 2020-12-30 05:22:34 | Braxton, West Virginia, US |
3765264 | 3765264 | 2020-12-28 | Malaysia | Pulau Pinang | 3268 | 9 | 2984 | 275 | 5.4141 | 100.3288 | 2020-12-29 05:22:37 | Pulau Pinang, Malaysia | ||
3765077 | 3765077 | 2020-12-28 | US | West Virginia | Pendleton | 54071 | 276 | 1 | 0 | 275 | 38.68314479 | -79.35084086 | 2020-12-29 05:22:37 | Pendleton, West Virginia, US |
2226867 | 2226867 | 2020-12-26 | US | Virginia | Madison | 51113 | 279 | 4 | 0 | 275 | 38.41531222 | -78.28220331 | 2020-12-27 05:22:55 | Madison, Virginia, US |
2224089 | 2224089 | 2020-12-26 | US | California | Trinity | 6105 | 291 | 2 | 0 | 275 | 40.64917670000001 | -123.114713 | 2020-12-27 05:22:55 | Trinity, California, US |
2223790 | 2223790 | 2020-12-26 | South Sudan | 3455 | 62 | 3118 | 275 | 6.877000000000002 | 31.307 | 2020-12-27 05:22:55 | South Sudan | |||
202537 | 202537 | 2020-12-25 | South Sudan | 3455 | 62 | 3118 | 275 | 6.877000000000002 | 31.307 | 2020-12-26 05:22:28 | South Sudan | |||
3691760 | 3691760 | 2020-12-24 | South Sudan | 3455 | 62 | 3118 | 275 | 6.877000000000002 | 31.307 | 2020-12-25 05:22:48 | South Sudan | |||
2407112 | 2407112 | 2020-12-23 | South Sudan | 3455 | 62 | 3118 | 275 | 6.877000000000002 | 31.307 | 2020-12-24 05:23:04 | South Sudan | |||
3773381 | 3773381 | 2020-12-22 | US | West Virginia | Tucker | 54093 | 276 | 1 | 0 | 275 | 39.11240885 | -79.57053576 | 2020-12-23 05:22:03 | Tucker, West Virginia, US |
928524 | 928524 | 2020-12-21 | US | Georgia | Marion | 13197 | 285 | 10 | 0 | 275 | 32.3483402 | -84.52733571 | 2020-12-22 05:22:33 | Marion, Georgia, US |
927482 | 927482 | 2020-12-21 | Chile | Coquimbo | 13854 | 290 | 13289 | 275 | -29.959 | -71.3389 | 2020-12-22 05:22:33 | Coquimbo, Chile |
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]);