ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
217 rows where cases = 2316 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 20
- Texas 17
- Mississippi 16
- Kentucky 13
- Virginia 12
- Arkansas 10
- Iowa 10
- Missouri 10
- Tennessee 10
- Idaho 9
- Kansas 8
- Alabama 5
- Colorado 5
- Illinois 5
- Indiana 5
- Louisiana 5
- Michigan 5
- Minnesota 5
- Nebraska 5
- North Carolina 5
- Montana 4
- Ohio 4
- South Dakota 4
- South Carolina 3
- Utah 3
- West Virginia 3
- Wisconsin 3
- New Hampshire 2
- New York 2
- Puerto Rico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484713 | 2484713 | 2022-05-08 | Choctaw | Mississippi | 28019 | 2316 | 33 |
2481455 | 2481455 | 2022-05-07 | Choctaw | Mississippi | 28019 | 2316 | 33 |
2478197 | 2478197 | 2022-05-06 | Choctaw | Mississippi | 28019 | 2316 | 33 |
2474939 | 2474939 | 2022-05-05 | Choctaw | Mississippi | 28019 | 2316 | 33 |
2471682 | 2471682 | 2022-05-04 | Choctaw | Mississippi | 28019 | 2316 | 33 |
2468426 | 2468426 | 2022-05-03 | Choctaw | Mississippi | 28019 | 2316 | 33 |
2465171 | 2465171 | 2022-05-02 | Choctaw | Mississippi | 28019 | 2316 | 33 |
2449840 | 2449840 | 2022-04-27 | Jayuya | Puerto Rico | 72073 | 2316 | |
2280761 | 2280761 | 2022-03-06 | Lake | South Dakota | 46079 | 2316 | 27 |
2277508 | 2277508 | 2022-03-05 | Lake | South Dakota | 46079 | 2316 | 27 |
2274255 | 2274255 | 2022-03-04 | Lake | South Dakota | 46079 | 2316 | 27 |
2271002 | 2271002 | 2022-03-03 | Lake | South Dakota | 46079 | 2316 | 27 |
2266923 | 2266923 | 2022-03-02 | Box Butte | Nebraska | 31013 | 2316 | 17 |
2217576 | 2217576 | 2022-02-15 | Owen | Kentucky | 21187 | 2316 | 32 |
2218018 | 2218018 | 2022-02-15 | Grundy | Missouri | 29079 | 2316 | 63 |
2214767 | 2214767 | 2022-02-14 | Grundy | Missouri | 29079 | 2316 | 62 |
2199716 | 2199716 | 2022-02-09 | Jim Hogg | Texas | 48247 | 2316 | 20 |
2164597 | 2164597 | 2022-01-30 | Perry | Arkansas | 5105 | 2316 | 27 |
2161342 | 2161342 | 2022-01-29 | Perry | Arkansas | 5105 | 2316 | 27 |
2158086 | 2158086 | 2022-01-28 | Perry | Arkansas | 5105 | 2316 | 27 |
2130145 | 2130145 | 2022-01-19 | Barton | Missouri | 29011 | 2316 | 43 |
2126267 | 2126267 | 2022-01-18 | Shelby | Iowa | 19165 | 2316 | 46 |
2123015 | 2123015 | 2022-01-17 | Shelby | Iowa | 19165 | 2316 | 46 |
2123584 | 2123584 | 2022-01-17 | Jefferson Davis | Mississippi | 28065 | 2316 | 43 |
2119763 | 2119763 | 2022-01-16 | Shelby | Iowa | 19165 | 2316 | 46 |
2120332 | 2120332 | 2022-01-16 | Jefferson Davis | Mississippi | 28065 | 2316 | 43 |
2116511 | 2116511 | 2022-01-15 | Shelby | Iowa | 19165 | 2316 | 46 |
2117080 | 2117080 | 2022-01-15 | Jefferson Davis | Mississippi | 28065 | 2316 | 43 |
2113260 | 2113260 | 2022-01-14 | Shelby | Iowa | 19165 | 2316 | 46 |
2113829 | 2113829 | 2022-01-14 | Jefferson Davis | Mississippi | 28065 | 2316 | 43 |
2113898 | 2113898 | 2022-01-14 | Cedar | Missouri | 29039 | 2316 | 43 |
2110008 | 2110008 | 2022-01-13 | Shelby | Iowa | 19165 | 2316 | 46 |
2106757 | 2106757 | 2022-01-12 | Shelby | Iowa | 19165 | 2316 | 46 |
2080152 | 2080152 | 2022-01-04 | Moffat | Colorado | 8081 | 2316 | 48 |
2082744 | 2082744 | 2022-01-04 | Zapata | Texas | 48505 | 2316 | 46 |
2078050 | 2078050 | 2022-01-03 | Greene | Mississippi | 28041 | 2316 | 50 |
2057730 | 2057730 | 2021-12-28 | Cumberland | Illinois | 17035 | 2316 | 41 |
2051136 | 2051136 | 2021-12-26 | Telfair | Georgia | 13271 | 2316 | 75 |
2047886 | 2047886 | 2021-12-25 | Telfair | Georgia | 13271 | 2316 | 75 |
2044636 | 2044636 | 2021-12-24 | Telfair | Georgia | 13271 | 2316 | 75 |
2041387 | 2041387 | 2021-12-23 | Telfair | Georgia | 13271 | 2316 | 75 |
2040606 | 2040606 | 2021-12-22 | King William | Virginia | 51101 | 2316 | 27 |
2015554 | 2015554 | 2021-12-15 | Wabash | Illinois | 17185 | 2316 | 22 |
1982622 | 1982622 | 2021-12-05 | Grand | Colorado | 8049 | 2316 | 16 |
1979372 | 1979372 | 2021-12-04 | Grand | Colorado | 8049 | 2316 | 16 |
1976122 | 1976122 | 2021-12-03 | Grand | Colorado | 8049 | 2316 | 16 |
1960014 | 1960014 | 2021-11-28 | Charlton | Georgia | 13049 | 2316 | 56 |
1956763 | 1956763 | 2021-11-27 | Charlton | Georgia | 13049 | 2316 | 56 |
1953512 | 1953512 | 2021-11-26 | Charlton | Georgia | 13049 | 2316 | 56 |
1950261 | 1950261 | 2021-11-25 | Charlton | Georgia | 13049 | 2316 | 56 |
1947010 | 1947010 | 2021-11-24 | Charlton | Georgia | 13049 | 2316 | 56 |
1949577 | 1949577 | 2021-11-24 | Greene | Virginia | 51079 | 2316 | 45 |
1943759 | 1943759 | 2021-11-23 | Charlton | Georgia | 13049 | 2316 | 56 |
1925370 | 1925370 | 2021-11-17 | Dallas | Missouri | 29059 | 2316 | 43 |
1915628 | 1915628 | 2021-11-14 | Gasconade | Missouri | 29073 | 2316 | 51 |
1908176 | 1908176 | 2021-11-12 | Gooding | Idaho | 16047 | 2316 | 42 |
1904927 | 1904927 | 2021-11-11 | Gooding | Idaho | 16047 | 2316 | 42 |
1901677 | 1901677 | 2021-11-10 | Gooding | Idaho | 16047 | 2316 | 42 |
1882364 | 1882364 | 2021-11-04 | Pike | Indiana | 18125 | 2316 | 45 |
1872634 | 1872634 | 2021-11-01 | Tipton | Indiana | 18159 | 2316 | 61 |
1813050 | 1813050 | 2021-10-13 | Appomattox | Virginia | 51011 | 2316 | 35 |
1793663 | 1793663 | 2021-10-07 | Southampton | Virginia | 51175 | 2316 | 61 |
1777526 | 1777526 | 2021-10-02 | Wetzel | West Virginia | 54103 | 2316 | 46 |
1763927 | 1763927 | 2021-09-28 | Decatur | Tennessee | 47039 | 2316 | 42 |
1739751 | 1739751 | 2021-09-21 | Union | Kentucky | 21225 | 2316 | 25 |
1738270 | 1738270 | 2021-09-20 | Carbon | Utah | 49007 | 2316 | 21 |
1735020 | 1735020 | 2021-09-19 | Carbon | Utah | 49007 | 2316 | 21 |
1731770 | 1731770 | 2021-09-18 | Carbon | Utah | 49007 | 2316 | 21 |
1725658 | 1725658 | 2021-09-17 | Crenshaw | Alabama | 1041 | 2316 | 64 |
1723003 | 1723003 | 2021-09-16 | Clay | Illinois | 17025 | 2316 | 52 |
1720155 | 1720155 | 2021-09-15 | Breckinridge | Kentucky | 21027 | 2316 | 20 |
1713039 | 1713039 | 2021-09-13 | Bacon | Georgia | 13005 | 2316 | 48 |
1711977 | 1711977 | 2021-09-12 | Lewis | Tennessee | 47101 | 2316 | 30 |
1712276 | 1712276 | 2021-09-12 | Zavala | Texas | 48507 | 2316 | 50 |
1708730 | 1708730 | 2021-09-11 | Lewis | Tennessee | 47101 | 2316 | 30 |
1709029 | 1709029 | 2021-09-11 | Zavala | Texas | 48507 | 2316 | 50 |
1705483 | 1705483 | 2021-09-10 | Lewis | Tennessee | 47101 | 2316 | 30 |
1705782 | 1705782 | 2021-09-10 | Zavala | Texas | 48507 | 2316 | 49 |
1701001 | 1701001 | 2021-09-09 | Dodge | Minnesota | 27039 | 2316 | 3 |
1691543 | 1691543 | 2021-09-06 | Hill | Montana | 30041 | 2316 | 47 |
1688293 | 1688293 | 2021-09-05 | Hill | Montana | 30041 | 2316 | 47 |
1685043 | 1685043 | 2021-09-04 | Hill | Montana | 30041 | 2316 | 47 |
1681792 | 1681792 | 2021-09-03 | Hill | Montana | 30041 | 2316 | 47 |
1674272 | 1674272 | 2021-09-01 | Cass | Illinois | 17017 | 2316 | 36 |
1676839 | 1676839 | 2021-09-01 | Iowa | Wisconsin | 55049 | 2316 | 14 |
1659037 | 1659037 | 2021-08-27 | Wright | Missouri | 29229 | 2316 | 43 |
1660128 | 1660128 | 2021-08-27 | Freestone | Texas | 48161 | 2316 | 55 |
1628041 | 1628041 | 2021-08-17 | Brooke | West Virginia | 54009 | 2316 | 61 |
1619527 | 1619527 | 2021-08-15 | Meade | Kentucky | 21163 | 2316 | 27 |
1616279 | 1616279 | 2021-08-14 | Meade | Kentucky | 21163 | 2316 | 27 |
1613030 | 1613030 | 2021-08-13 | Meade | Kentucky | 21163 | 2316 | 27 |
1602230 | 1602230 | 2021-08-10 | Fayette | Alabama | 1057 | 2316 | 65 |
1576987 | 1576987 | 2021-08-02 | Starke | Indiana | 18149 | 2316 | 61 |
1564485 | 1564485 | 2021-07-29 | Gladwin | Michigan | 26051 | 2316 | 61 |
1560140 | 1560140 | 2021-07-28 | Randolph | Arkansas | 5121 | 2316 | 48 |
1561237 | 1561237 | 2021-07-28 | Gladwin | Michigan | 26051 | 2316 | 61 |
1557989 | 1557989 | 2021-07-27 | Gladwin | Michigan | 26051 | 2316 | 61 |
1556106 | 1556106 | 2021-07-26 | Austin | Texas | 48015 | 2316 | 37 |
1547014 | 1547014 | 2021-07-24 | Hale | Alabama | 1065 | 2316 | 78 |
1534485 | 1534485 | 2021-07-20 | Morgan | Georgia | 13211 | 2316 | 31 |
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);