johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
95 rows where confirmed = 6472 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1149425 | 1149425 | 2022-12-12 | US | Arkansas | Columbia | 5027 | 6472 | 104 | 0 | 33.21230701 | -93.22642793 | 2022-12-13 04:21:01 | Columbia, Arkansas, US | |
869279 | 869279 | 2022-12-11 | US | Arkansas | Columbia | 5027 | 6472 | 104 | 0 | 33.21230701 | -93.22642793 | 2022-12-12 04:21:01 | Columbia, Arkansas, US | |
1622919 | 1622919 | 2022-11-22 | US | Oregon | Wasco | 41065 | 6472 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-23 04:21:06 | Wasco, Oregon, US | |
3462807 | 3462807 | 2022-11-21 | US | Oregon | Wasco | 41065 | 6472 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-22 04:20:47 | Wasco, Oregon, US | |
1642992 | 1642992 | 2022-11-20 | US | Oregon | Wasco | 41065 | 6472 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-21 04:21:05 | Wasco, Oregon, US | |
2066549 | 2066549 | 2022-11-19 | US | Oregon | Wasco | 41065 | 6472 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-20 04:21:08 | Wasco, Oregon, US | |
1757943 | 1757943 | 2022-11-18 | US | Oregon | Wasco | 41065 | 6472 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-19 04:21:14 | Wasco, Oregon, US | |
3028936 | 3028936 | 2022-11-17 | US | Oregon | Wasco | 41065 | 6472 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-18 04:21:15 | Wasco, Oregon, US | |
2488647 | 2488647 | 2022-11-16 | US | Oregon | Wasco | 41065 | 6472 | 73 | 0 | 45.16292781 | -121.1670954 | 2022-11-17 04:21:11 | Wasco, Oregon, US | |
618380 | 618380 | 2022-11-05 | US | Arkansas | Ouachita | 5103 | 6472 | 119 | 0 | 33.58839816 | -92.87795984 | 2022-11-06 04:21:24 | Ouachita, Arkansas, US | |
1022884 | 1022884 | 2022-11-04 | US | Arkansas | Ouachita | 5103 | 6472 | 119 | 0 | 33.58839816 | -92.87795984 | 2022-11-05 04:21:52 | Ouachita, Arkansas, US | |
2162750 | 2162750 | 2022-10-16 | US | Texas | San Jacinto | 48407 | 6472 | 106 | 0 | 30.57933681 | -95.16260304 | 2022-10-17 04:20:31 | San Jacinto, Texas, US | |
518947 | 518947 | 2022-10-15 | US | Texas | San Jacinto | 48407 | 6472 | 106 | 0 | 30.57933681 | -95.16260304 | 2022-10-16 04:22:39 | San Jacinto, Texas, US | |
2036004 | 2036004 | 2022-10-14 | US | Texas | San Jacinto | 48407 | 6472 | 106 | 0 | 30.57933681 | -95.16260304 | 2022-10-15 04:22:00 | San Jacinto, Texas, US | |
3995282 | 3995282 | 2022-09-27 | US | Colorado | Morgan | 8087 | 6472 | 140 | 0 | 40.2627981 | -103.8093302 | 2022-09-28 04:23:01 | Morgan, Colorado, US | |
3747834 | 3747834 | 2022-09-07 | US | Puerto Rico | Barceloneta | 72017 | 6472 | 0 | 0 | 18.445533 | -66.560531 | 2022-09-08 04:21:02 | Barceloneta, Puerto Rico, US | |
116968 | 116968 | 2022-09-06 | US | New Mexico | Taos | 35055 | 6472 | 97 | 0 | 36.58006022 | -105.6310198 | 2022-09-07 04:20:59 | Taos, New Mexico, US | |
2099040 | 2099040 | 2022-08-27 | US | Tennessee | Chester | 47023 | 6472 | 100 | 0 | 35.42527478 | -88.6095842 | 2022-08-28 04:21:02 | Chester, Tennessee, US | |
1534855 | 1534855 | 2022-08-26 | US | Tennessee | Chester | 47023 | 6472 | 100 | 0 | 35.42527478 | -88.6095842 | 2022-08-27 04:20:57 | Chester, Tennessee, US | |
1162323 | 1162323 | 2022-08-18 | US | Indiana | Washington | 18175 | 6472 | 89 | 0 | 38.60219804 | -86.1049363 | 2022-08-19 04:20:54 | Washington, Indiana, US | |
3951647 | 3951647 | 2022-08-17 | US | Indiana | Washington | 18175 | 6472 | 89 | 0 | 38.60219804 | -86.1049363 | 2022-08-18 04:21:11 | Washington, Indiana, US | |
673724 | 673724 | 2022-07-21 | US | Virginia | Waynesboro | 51820 | 6472 | 68 | 0 | 38.06451466 | -78.90293905 | 2022-07-22 04:21:15 | Waynesboro, Virginia, US | |
1651313 | 1651313 | 2022-06-23 | US | Tennessee | DeKalb | 47041 | 6472 | 102 | 0 | 35.97616272 | -85.83689361 | 2022-06-24 04:20:58 | DeKalb, Tennessee, US | |
3595297 | 3595297 | 2022-05-23 | US | New York | Seneca | 36099 | 6472 | 92 | 0 | 42.78081007 | -76.82497064 | 2022-05-24 04:20:57 | Seneca, New York, US | |
1188173 | 1188173 | 2022-05-18 | US | Virginia | Winchester | 51840 | 6472 | 80 | 0 | 39.17054517 | -78.17325058 | 2022-05-19 04:20:54 | Winchester, Virginia, US | |
223520 | 223520 | 2022-05-09 | US | Louisiana | Plaquemines | 22075 | 6472 | 45 | 0 | 29.42245447 | -89.60322085 | 2022-05-10 04:20:50 | Plaquemines, Louisiana, US | |
1326622 | 1326622 | 2022-04-26 | US | Alabama | Geneva | 1061 | 6472 | 163 | 0 | 31.09389027 | -85.83572839 | 2022-04-27 04:20:52 | Geneva, Alabama, US | |
2895484 | 2895484 | 2022-04-21 | US | Texas | DeWitt | 48123 | 6472 | 99 | 0 | 29.08101855 | -97.35681170000001 | 2022-04-22 04:20:45 | DeWitt, Texas, US | |
2734180 | 2734180 | 2022-02-27 | US | Indiana | Wells | 18179 | 6472 | 127 | 0 | 40.72934187 | -85.22132966 | 2022-02-28 04:21:05 | Wells, Indiana, US | |
3047333 | 3047333 | 2022-02-26 | US | Indiana | Wells | 18179 | 6472 | 127 | 0 | 40.72934187 | -85.22132966 | 2022-02-27 04:21:04 | Wells, Indiana, US | |
575988 | 575988 | 2022-02-25 | US | Indiana | Wells | 18179 | 6472 | 127 | 0 | 40.72934187 | -85.22132966 | 2022-02-26 04:21:12 | Wells, Indiana, US | |
2450089 | 2450089 | 2022-02-22 | US | Virginia | Carroll | 51035 | 6472 | 132 | 0 | 36.73066666 | -80.73455942 | 2022-02-23 04:21:09 | Carroll, Virginia, US | |
188133 | 188133 | 2022-02-13 | US | Nebraska | Dakota | 31043 | 6472 | 65 | 0 | 42.39040144 | -96.56656425 | 2022-02-14 04:20:51 | Dakota, Nebraska, US | |
187942 | 187942 | 2022-02-13 | US | Missouri | Barry | 29009 | 6472 | 105 | 0 | 36.70978521 | -93.82919888 | 2022-02-14 04:20:51 | Barry, Missouri, US | |
317979 | 317979 | 2022-02-12 | US | Nebraska | Dakota | 31043 | 6472 | 65 | 0 | 42.39040144 | -96.56656425 | 2022-02-13 04:21:00 | Dakota, Nebraska, US | |
317788 | 317788 | 2022-02-12 | US | Missouri | Barry | 29009 | 6472 | 105 | 0 | 36.70978521 | -93.82919888 | 2022-02-13 04:21:00 | Barry, Missouri, US | |
235305 | 235305 | 2022-02-11 | US | Nebraska | Dakota | 31043 | 6472 | 65 | 0 | 42.39040144 | -96.56656425 | 2022-02-12 04:21:06 | Dakota, Nebraska, US | |
235114 | 235114 | 2022-02-11 | US | Missouri | Barry | 29009 | 6472 | 105 | 0 | 36.70978521 | -93.82919888 | 2022-02-12 04:21:06 | Barry, Missouri, US | |
1465956 | 1465956 | 2022-02-10 | US | Missouri | Barry | 29009 | 6472 | 105 | 0 | 36.70978521 | -93.82919888 | 2022-02-11 04:21:09 | Barry, Missouri, US | |
1365477 | 1365477 | 2022-02-08 | US | Texas | Howard | 48227 | 6472 | 165 | 0 | 32.30621324 | -101.4356444 | 2022-02-09 04:21:04 | Howard, Texas, US | |
462993 | 462993 | 2022-02-02 | US | Wyoming | Park | 56029 | 6472 | 129 | 0 | 44.52157546 | -109.58528249999999 | 2022-02-03 04:21:21 | Park, Wyoming, US | |
1472888 | 1472888 | 2022-01-17 | US | Georgia | Chattahoochee | 13053 | 6472 | 21 | 0 | 32.34341231 | -84.78809239 | 2022-01-18 04:21:04 | Chattahoochee, Georgia, US | |
2611077 | 2611077 | 2022-01-06 | US | Illinois | Morgan | 17137 | 6472 | 106 | 0 | 39.71654544 | -90.20255104 | 2022-01-07 04:22:09 | Morgan, Illinois, US | |
3816795 | 3816795 | 2021-12-23 | US | Alabama | Franklin | 1059 | 6472 | 110 | 0 | 34.44235334 | -87.84289505 | 2021-12-24 04:21:34 | Franklin, Alabama, US | |
800342 | 800342 | 2021-12-22 | US | Missouri | Howell | 29091 | 6472 | 174 | 0 | 36.77383887 | -91.88683935 | 2021-12-23 04:21:21 | Howell, Missouri, US | |
1032165 | 1032165 | 2021-12-06 | US | Mississippi | Bolivar | 28011 | 6472 | 151 | 0 | 33.79696941 | -90.87372121 | 2021-12-07 04:22:34 | Bolivar, Mississippi, US | |
3513124 | 3513124 | 2021-11-01 | US | Minnesota | Goodhue | 27049 | 6472 | 87 | 0 | 44.40849741 | -92.72341949999999 | 2021-11-02 04:22:03 | Goodhue, Minnesota, US | |
3794993 | 3794993 | 2021-10-25 | US | Indiana | Huntington | 18069 | 6472 | 100 | 0 | 40.82907273 | -85.48822092 | 2021-10-26 04:22:09 | Huntington, Indiana, US | |
635470 | 635470 | 2021-10-13 | US | Louisiana | Webster | 22119 | 6472 | 146 | 0 | 32.70847669 | -93.33121835 | 2021-10-14 04:21:29 | Webster, Louisiana, US | |
1494720 | 1494720 | 2021-10-12 | US | Texas | Hill | 48217 | 6472 | 142 | 0 | 31.99045053 | -97.13423143 | 2021-10-13 04:20:51 | Hill, Texas, US | |
990250 | 990250 | 2021-10-04 | US | Utah | Summit | 49043 | 6472 | 18 | 0 | 40.86688146 | -110.9535882 | 2021-10-05 04:21:27 | Summit, Utah, US | |
811273 | 811273 | 2021-09-20 | US | Minnesota | Benton | 27009 | 6472 | 101 | 0 | 45.69804958 | -93.99514135 | 2021-09-21 04:21:26 | Benton, Minnesota, US | |
70447 | 70447 | 2021-09-01 | US | Virginia | Pittsylvania | 51143 | 6472 | 88 | 0 | 36.81980341 | -79.39731264 | 2021-09-02 04:21:15 | Pittsylvania, Virginia, US | |
1777652 | 1777652 | 2021-08-30 | US | North Carolina | Carteret | 37031 | 6472 | 58 | 0 | 34.8932941 | -76.54120135 | 2021-08-31 04:21:46 | Carteret, North Carolina, US | |
246954 | 246954 | 2021-08-17 | US | Michigan | St. Joseph | 26149 | 6472 | 104 | 0 | 41.91441767 | -85.52797979 | 2021-08-18 04:21:35 | St. Joseph, Michigan, US | |
1605917 | 1605917 | 2021-08-16 | US | Michigan | St. Joseph | 26149 | 6472 | 104 | 0 | 41.91441767 | -85.52797979 | 2021-08-17 04:21:49 | St. Joseph, Michigan, US | |
2205098 | 2205098 | 2021-08-07 | US | Kentucky | Pike | 21195 | 6472 | 113 | 0 | 37.47088263 | -82.39487445 | 2021-08-08 04:21:33 | Pike, Kentucky, US | |
1117626 | 1117626 | 2021-08-06 | Japan | Shiga | 6472 | 94 | 0 | 35.21582700000001 | 136.138064 | 2021-08-07 04:21:30 | Shiga, Japan | |||
334712 | 334712 | 2021-08-04 | US | South Carolina | Cherokee | 45021 | 6472 | 159 | 0 | 35.05122251 | -81.61828622 | 2021-08-05 04:21:51 | Cherokee, South Carolina, US | |
578664 | 578664 | 2021-07-13 | Colombia | Amazonas | 6472 | 248 | 6160 | 64 | -1.4429 | -71.5724 | 2021-07-14 04:21:35 | Amazonas, Colombia | ||
2886000 | 2886000 | 2021-06-20 | US | Michigan | Grand Traverse | 26055 | 6472 | 99 | 0 | 44.69565625 | -85.55585247 | 2021-06-21 04:21:41 | Grand Traverse, Michigan, US | |
109083 | 109083 | 2021-06-19 | US | Michigan | Grand Traverse | 26055 | 6472 | 99 | 0 | 44.69565625 | -85.55585247 | 2021-06-20 04:21:48 | Grand Traverse, Michigan, US | |
1127226 | 1127226 | 2021-06-18 | US | Michigan | Grand Traverse | 26055 | 6472 | 99 | 0 | 44.69565625 | -85.55585247 | 2021-06-19 04:22:33 | Grand Traverse, Michigan, US | |
1565722 | 1565722 | 2021-06-14 | US | Michigan | Grand Traverse | 26055 | 6472 | 99 | 0 | 44.69565625 | -85.55585247 | 2021-06-15 04:22:22 | Grand Traverse, Michigan, US | |
525971 | 525971 | 2021-06-09 | US | Texas | Hood | 48221 | 6472 | 132 | 0 | 32.42990927 | -97.83242024 | 2021-06-10 04:23:17 | Hood, Texas, US | |
3147401 | 3147401 | 2021-06-07 | US | Mississippi | Lowndes | 28087 | 6472 | 149 | 0 | 33.47386518 | -88.44191529999998 | 2021-06-08 04:22:35 | Lowndes, Mississippi, US | |
83856 | 83856 | 2021-05-25 | US | Georgia | Catoosa | 13047 | 6472 | 71 | 0 | 34.89872298 | -85.13757014 | 2021-05-26 04:20:35 | Catoosa, Georgia, US | |
2504294 | 2504294 | 2021-05-07 | US | New York | Sullivan | 36105 | 6472 | 72 | 0 | 41.71579493 | -74.76394559 | 2021-05-08 04:21:04 | Sullivan, New York, US | |
647673 | 647673 | 2021-05-05 | US | Minnesota | Kandiyohi | 27067 | 6472 | 82 | 0 | 45.1526059 | -95.00586446 | 2021-05-06 04:20:38 | Kandiyohi, Minnesota, US | |
2450707 | 2450707 | 2021-05-02 | Iceland | 6472 | 29 | 6253 | 190 | 64.9631 | -19.0208 | 2021-05-03 04:20:39 | Iceland | |||
2824720 | 2824720 | 2021-05-01 | Iceland | 6472 | 29 | 6253 | 190 | 64.9631 | -19.0208 | 2021-05-02 04:20:48 | Iceland | |||
380128 | 380128 | 2021-04-30 | Iceland | 6472 | 29 | 6253 | 190 | 64.9631 | -19.0208 | 2021-05-01 04:20:47 | Iceland | |||
3396327 | 3396327 | 2021-04-28 | US | Tennessee | Gibson | 47053 | 6472 | 143 | 0 | 35.99438059 | -88.93358327 | 2021-04-29 04:20:55 | Gibson, Tennessee, US | |
2646095 | 2646095 | 2021-04-08 | US | Alabama | Blount | 1009 | 6472 | 134 | 0 | 33.98210918 | -86.56790593 | 2021-04-09 04:21:13 | Blount, Alabama, US | |
391498 | 391498 | 2021-04-04 | US | Vermont | Chittenden | 50007 | 6472 | 98 | 0 | 44.46322849 | -73.08359212 | 2021-04-05 04:20:35 | Chittenden, Vermont, US | |
3621496 | 3621496 | 2021-03-17 | US | Alaska | Fairbanks North Star | 2090 | 6472 | 30 | 0 | 64.80726247 | -146.5692662 | 2021-03-18 05:26:22 | Fairbanks North Star, Alaska, US | |
3052533 | 3052533 | 2021-02-16 | US | North Carolina | Stanly | 37167 | 6472 | 104 | 0 | 6368 | 35.31647813 | -80.25093221 | 2021-02-17 05:23:10 | Stanly, North Carolina, US |
977731 | 977731 | 2021-02-06 | US | South Carolina | Greenwood | 45047 | 6472 | 144 | 0 | 6328 | 34.15272415 | -82.12715789 | 2021-02-07 05:23:00 | Greenwood, South Carolina, US |
2568463 | 2568463 | 2021-01-25 | US | Georgia | Glynn | 13127 | 6472 | 147 | 0 | 6325 | 31.23279254 | -81.53811412 | 2021-01-26 05:22:02 | Glynn, Georgia, US |
2225051 | 2225051 | 2020-12-26 | US | Maine | Cumberland | 23005 | 6472 | 90 | 0 | 6382 | 43.8370751 | -70.37226999 | 2020-12-27 05:22:55 | Cumberland, Maine, US |
203798 | 203798 | 2020-12-25 | US | Maine | Cumberland | 23005 | 6472 | 90 | 0 | 6382 | 43.8370751 | -70.37226999 | 2020-12-26 05:22:28 | Cumberland, Maine, US |
930568 | 930568 | 2020-12-21 | US | South Dakota | Lincoln | 46083 | 6472 | 61 | 0 | 6411 | 43.27841182 | -96.7203905 | 2020-12-22 05:22:33 | Lincoln, South Dakota, US |
847917 | 847917 | 2020-12-12 | US | North Carolina | Randolph | 37151 | 6472 | 101 | 0 | 6371 | 35.71015088 | -79.80570339 | 2020-12-13 05:27:20 | Randolph, North Carolina, US |
78380 | 78380 | 2020-12-03 | US | Virginia | Arlington | 51013 | 6472 | 157 | 0 | 6315 | 38.8767675 | -77.10139853 | 2020-12-04 05:27:27 | Arlington, Virginia, US |
3569007 | 3569007 | 2020-11-29 | US | Ohio | Clermont | 39025 | 6472 | 77 | 0 | 6395 | 39.04847534 | -84.15375786 | 2020-11-30 05:26:13 | Clermont, Ohio, US |
125358 | 125358 | 2020-11-18 | US | Pennsylvania | Dauphin | 42043 | 6472 | 206 | 0 | 6266 | 40.41377078 | -76.77993242 | 2020-11-19 05:25:23 | Dauphin, Pennsylvania, US |
2920849 | 2920849 | 2020-11-04 | US | Michigan | Ottawa | 26139 | 6472 | 82 | 0 | 6390 | 42.95996803 | -85.9969107 | 2020-11-05 06:05:03 | Ottawa, Michigan, US |
2083272 | 2083272 | 2020-10-31 | US | Virginia | Henrico | 51087 | 6472 | 240 | 0 | 6232 | 37.53460572 | -77.39326555 | 2020-11-01 04:36:19 | Henrico, Virginia, US |
2859150 | 2859150 | 2020-10-16 | US | North Carolina | Gaston | 37071 | 6472 | 102 | 0 | 6370 | 35.29373559 | -81.17477045 | 2020-10-17 04:24:12 | Gaston, North Carolina, US |
3117877 | 3117877 | 2020-10-06 | US | Alabama | Shelby | 1117 | 6472 | 54 | 0 | 6418 | 33.26879845 | -86.66232561 | 2020-10-07 04:23:40 | Shelby, Alabama, US |
1122131 | 1122131 | 2020-09-17 | US | California | Marin | 6041 | 6472 | 81 | 0 | 6391 | 38.07122463 | -122.7210631 | 2020-09-18 05:05:00 | Marin, California, US |
1173475 | 1173475 | 2020-09-10 | Spain | La Rioja | 6472 | 381 | 3107 | 2984 | 42.2871 | -2.5396 | 2020-09-11 04:46:23 | La Rioja, Spain | ||
3165062 | 3165062 | 2020-09-06 | US | Washington | Snohomish | 53061 | 6472 | 200 | 0 | 6272 | 48.04615983 | -121.7170703 | 2020-09-07 04:28:30 | Snohomish, Washington, US |
3178526 | 3178526 | 2020-08-18 | US | Arkansas | Washington | 5143 | 6472 | 53 | 0 | 6419 | 35.976844 | -94.21800746 | 2020-08-19 04:27:00 | Washington, Arkansas, US |
802795 | 802795 | 2020-06-01 | US | Texas | Dallas | 48113 | 6472 | 273 | 0 | 10189 | 32.76670599 | -96.7779605 | 2020-06-02 02:33:08 | Dallas, Texas, 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]);