ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
231 rows where cases = 2089 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 16
- Georgia 15
- Missouri 15
- Illinois 14
- Iowa 14
- Virginia 13
- Texas 12
- Mississippi 11
- Puerto Rico 9
- Louisiana 8
- Ohio 8
- Utah 8
- Minnesota 7
- North Carolina 7
- Alabama 6
- South Dakota 6
- West Virginia 6
- Indiana 5
- Kentucky 5
- Tennessee 4
- Wisconsin 4
- California 3
- Idaho 3
- Nebraska 3
- Colorado 2
- Florida 2
- Kansas 2
- Maine 2
- Maryland 2
- Montana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467567 | 2467567 | 2022-05-03 | Boundary | Idaho | 16021 | 2089 | 62 |
2464312 | 2464312 | 2022-05-02 | Boundary | Idaho | 16021 | 2089 | 62 |
2465111 | 2465111 | 2022-05-02 | Lake | Minnesota | 27075 | 2089 | 28 |
2426045 | 2426045 | 2022-04-20 | Marshall | Minnesota | 27089 | 2089 | 23 |
2406509 | 2406509 | 2022-04-14 | Marshall | Minnesota | 27089 | 2089 | 23 |
2375700 | 2375700 | 2022-04-04 | Gilmer | West Virginia | 54021 | 2089 | 19 |
2353858 | 2353858 | 2022-03-29 | Warren | Indiana | 18171 | 2089 | 30 |
2352526 | 2352526 | 2022-03-28 | Gaines | Texas | 48165 | 2089 | 83 |
2349274 | 2349274 | 2022-03-27 | Gaines | Texas | 48165 | 2089 | 83 |
2346021 | 2346021 | 2022-03-26 | Gaines | Texas | 48165 | 2089 | 83 |
2288065 | 2288065 | 2022-03-09 | Perry | Alabama | 1105 | 2089 | 43 |
2284813 | 2284813 | 2022-03-08 | Perry | Alabama | 1105 | 2089 | 43 |
2284936 | 2284936 | 2022-03-08 | Searcy | Arkansas | 5129 | 2089 | 41 |
2281561 | 2281561 | 2022-03-07 | Perry | Alabama | 1105 | 2089 | 43 |
2275178 | 2275178 | 2022-03-05 | Searcy | Arkansas | 5129 | 2089 | 41 |
2263008 | 2263008 | 2022-03-01 | Bracken | Kentucky | 21023 | 2089 | 24 |
2264625 | 2264625 | 2022-03-01 | Archer | Texas | 48009 | 2089 | 28 |
2257091 | 2257091 | 2022-02-27 | St. Clair | Missouri | 29185 | 2089 | 32 |
2253840 | 2253840 | 2022-02-26 | St. Clair | Missouri | 29185 | 2089 | 32 |
2250589 | 2250589 | 2022-02-25 | St. Clair | Missouri | 29185 | 2089 | 32 |
2217906 | 2217906 | 2022-02-15 | Choctaw | Mississippi | 28019 | 2089 | 30 |
2211140 | 2211140 | 2022-02-13 | Red River | Louisiana | 22081 | 2089 | 50 |
2207887 | 2207887 | 2022-02-12 | Red River | Louisiana | 22081 | 2089 | 50 |
2204634 | 2204634 | 2022-02-11 | Red River | Louisiana | 22081 | 2089 | 50 |
2196046 | 2196046 | 2022-02-08 | Adjuntas | Puerto Rico | 72001 | 2089 | |
2192792 | 2192792 | 2022-02-07 | Adjuntas | Puerto Rico | 72001 | 2089 | |
2189979 | 2189979 | 2022-02-06 | Live Oak | Texas | 48297 | 2089 | 40 |
2167403 | 2167403 | 2022-01-30 | Essex | Virginia | 51057 | 2089 | 22 |
2167546 | 2167546 | 2022-01-30 | Clay | West Virginia | 54015 | 2089 | 31 |
2163576 | 2163576 | 2022-01-29 | Sabana Grande | Puerto Rico | 72121 | 2089 | |
2164148 | 2164148 | 2022-01-29 | Essex | Virginia | 51057 | 2089 | 22 |
2160893 | 2160893 | 2022-01-28 | Essex | Virginia | 51057 | 2089 | 22 |
2151056 | 2151056 | 2022-01-25 | Grand | Utah | 49019 | 2089 | 6 |
2128805 | 2128805 | 2022-01-19 | Perry | Arkansas | 5105 | 2089 | 27 |
2123722 | 2123722 | 2022-01-17 | Ralls | Missouri | 29173 | 2089 | 19 |
2120470 | 2120470 | 2022-01-16 | Ralls | Missouri | 29173 | 2089 | 19 |
2117218 | 2117218 | 2022-01-15 | Ralls | Missouri | 29173 | 2089 | 19 |
2103581 | 2103581 | 2022-01-11 | Marshall | Kansas | 20117 | 2089 | 37 |
2103634 | 2103634 | 2022-01-11 | Bath | Kentucky | 21011 | 2089 | 34 |
2100330 | 2100330 | 2022-01-10 | Marshall | Kansas | 20117 | 2089 | 37 |
2086588 | 2086588 | 2022-01-06 | Plumas | California | 6063 | 2089 | 12 |
2079191 | 2079191 | 2022-01-03 | Lake | Tennessee | 47095 | 2089 | 34 |
2066980 | 2066980 | 2021-12-31 | Chicot | Arkansas | 5017 | 2089 | 48 |
2060004 | 2060004 | 2021-12-28 | Morgan | Utah | 49029 | 2089 | 13 |
2019602 | 2019602 | 2021-12-16 | Webster | Mississippi | 28155 | 2089 | 49 |
2016352 | 2016352 | 2021-12-15 | Webster | Mississippi | 28155 | 2089 | 49 |
1994454 | 1994454 | 2021-12-08 | Cayey | Puerto Rico | 72035 | 2089 | |
1973222 | 1973222 | 2021-12-02 | Cumberland | Illinois | 17035 | 2089 | 39 |
1971345 | 1971345 | 2021-12-01 | Swain | North Carolina | 37173 | 2089 | 28 |
1958469 | 1958469 | 2021-11-27 | Morgan | Ohio | 39115 | 2089 | 38 |
1952738 | 1952738 | 2021-11-25 | Juab | Utah | 49023 | 2089 | 18 |
1949487 | 1949487 | 2021-11-24 | Juab | Utah | 49023 | 2089 | 18 |
1943942 | 1943942 | 2021-11-23 | Shoshone | Idaho | 16079 | 2089 | 63 |
1884616 | 1884616 | 2021-11-04 | Patrick | Virginia | 51141 | 2089 | 55 |
1855487 | 1855487 | 2021-10-26 | Morgan | West Virginia | 54065 | 2089 | 41 |
1836257 | 1836257 | 2021-10-21 | Lee | Arkansas | 5077 | 2089 | 48 |
1839294 | 1839294 | 2021-10-21 | Lafayette | Wisconsin | 55065 | 2089 | 12 |
1812234 | 1812234 | 2021-10-13 | Monroe | Ohio | 39111 | 2089 | 51 |
1810012 | 1810012 | 2021-10-12 | Taylor | West Virginia | 54091 | 2089 | 36 |
1804278 | 1804278 | 2021-10-11 | Mason | Illinois | 17125 | 2089 | 52 |
1801029 | 1801029 | 2021-10-10 | Mason | Illinois | 17125 | 2089 | 52 |
1797780 | 1797780 | 2021-10-09 | Mason | Illinois | 17125 | 2089 | 52 |
1794531 | 1794531 | 2021-10-08 | Mason | Illinois | 17125 | 2089 | 52 |
1774530 | 1774530 | 2021-10-02 | Marion | Arkansas | 5089 | 2089 | 55 |
1768129 | 1768129 | 2021-09-30 | Chaffee | Colorado | 8015 | 2089 | 28 |
1766019 | 1766019 | 2021-09-29 | Renville | Minnesota | 27129 | 2089 | 48 |
1766202 | 1766202 | 2021-09-29 | Osage | Missouri | 29151 | 2089 | 22 |
1759688 | 1759688 | 2021-09-27 | Macon | Missouri | 29121 | 2089 | 20 |
1746669 | 1746669 | 2021-09-23 | Gasconade | Missouri | 29073 | 2089 | 48 |
1743390 | 1743390 | 2021-09-22 | Bates | Missouri | 29013 | 2089 | 38 |
1744826 | 1744826 | 2021-09-22 | Bristol city | Virginia | 51520 | 2089 | 43 |
1732783 | 1732783 | 2021-09-19 | Johnson | Illinois | 17087 | 2089 | 28 |
1729533 | 1729533 | 2021-09-18 | Johnson | Illinois | 17087 | 2089 | 28 |
1726283 | 1726283 | 2021-09-17 | Johnson | Illinois | 17087 | 2089 | 28 |
1719129 | 1719129 | 2021-09-14 | Lincoln | Wyoming | 56023 | 2089 | 14 |
1693986 | 1693986 | 2021-09-07 | Fayette | Iowa | 19065 | 2089 | 44 |
1695089 | 1695089 | 2021-09-07 | Currituck | North Carolina | 37053 | 2089 | 19 |
1690737 | 1690737 | 2021-09-06 | Fayette | Iowa | 19065 | 2089 | 44 |
1692806 | 1692806 | 2021-09-06 | San Juan | Utah | 49037 | 2089 | 39 |
1687487 | 1687487 | 2021-09-05 | Fayette | Iowa | 19065 | 2089 | 44 |
1689557 | 1689557 | 2021-09-05 | San Juan | Utah | 49037 | 2089 | 39 |
1684237 | 1684237 | 2021-09-04 | Fayette | Iowa | 19065 | 2089 | 44 |
1686307 | 1686307 | 2021-09-04 | San Juan | Utah | 49037 | 2089 | 39 |
1680986 | 1680986 | 2021-09-03 | Fayette | Iowa | 19065 | 2089 | 44 |
1683056 | 1683056 | 2021-09-03 | San Juan | Utah | 49037 | 2089 | 39 |
1677738 | 1677738 | 2021-09-02 | Fayette | Iowa | 19065 | 2089 | 44 |
1674491 | 1674491 | 2021-09-01 | Fayette | Iowa | 19065 | 2089 | 44 |
1672204 | 1672204 | 2021-08-31 | Sullivan | New Hampshire | 33019 | 2089 | 29 |
1667433 | 1667433 | 2021-08-30 | Elbert | Colorado | 8039 | 2089 | 16 |
1670208 | 1670208 | 2021-08-30 | Southampton | Virginia | 51175 | 2089 | 58 |
1659025 | 1659025 | 2021-08-27 | Ste. Genevieve | Missouri | 29186 | 2089 | 19 |
1643851 | 1643851 | 2021-08-22 | Colorado | Texas | 48089 | 2089 | 34 |
1634206 | 1634206 | 2021-08-19 | Llano | Texas | 48299 | 2089 | 55 |
1614019 | 1614019 | 2021-08-13 | Carroll | Ohio | 39019 | 2089 | 49 |
1604939 | 1604939 | 2021-08-10 | Houston | Texas | 48225 | 2089 | 60 |
1588343 | 1588343 | 2021-08-05 | Naranjito | Puerto Rico | 72105 | 2089 | |
1589174 | 1589174 | 2021-08-05 | Vernon | Wisconsin | 55123 | 2089 | 43 |
1577615 | 1577615 | 2021-08-02 | Wabasha | Minnesota | 27157 | 2089 | 3 |
1573388 | 1573388 | 2021-08-01 | Cook | Georgia | 13075 | 2089 | 43 |
1570140 | 1570140 | 2021-07-31 | Cook | Georgia | 13075 | 2089 | 43 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);