ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
199 rows where cases = 2870 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 16
- Tennessee 16
- Arkansas 15
- Iowa 15
- Kentucky 13
- Texas 11
- Missouri 9
- Mississippi 7
- Georgia 6
- Michigan 6
- Colorado 5
- Illinois 5
- Nebraska 5
- New York 5
- Louisiana 4
- North Carolina 4
- West Virginia 4
- Alabama 3
- Minnesota 3
- New Mexico 3
- Pennsylvania 3
- Virginia 3
- Washington 3
- Wisconsin 3
- Wyoming 3
- Arizona 2
- Florida 2
- Idaho 2
- Indiana 2
- Kansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492464 | 2492464 | 2022-05-10 | Camp | Texas | 48063 | 2870 | 74 |
2489206 | 2489206 | 2022-05-09 | Camp | Texas | 48063 | 2870 | 74 |
2485949 | 2485949 | 2022-05-08 | Camp | Texas | 48063 | 2870 | 74 |
2281335 | 2281335 | 2022-03-06 | Jefferson | Washington | 53031 | 2870 | 28 |
2278082 | 2278082 | 2022-03-05 | Jefferson | Washington | 53031 | 2870 | 28 |
2274829 | 2274829 | 2022-03-04 | Jefferson | Washington | 53031 | 2870 | 28 |
2256793 | 2256793 | 2022-02-27 | Missaukee | Michigan | 26113 | 2870 | 59 |
2253542 | 2253542 | 2022-02-26 | Missaukee | Michigan | 26113 | 2870 | 59 |
2250291 | 2250291 | 2022-02-25 | Missaukee | Michigan | 26113 | 2870 | 59 |
2228380 | 2228380 | 2022-02-18 | Vinton | Ohio | 39163 | 2870 | 52 |
2216500 | 2216500 | 2022-02-15 | Coosa | Alabama | 1037 | 2870 | 53 |
2213516 | 2213516 | 2022-02-14 | Moffat | Colorado | 8081 | 2870 | 51 |
2213644 | 2213644 | 2022-02-14 | Charlton | Georgia | 13049 | 2870 | 58 |
2111110 | 2111110 | 2022-01-13 | Polk | North Carolina | 37149 | 2870 | 49 |
2108747 | 2108747 | 2022-01-12 | Wilbarger | Texas | 48487 | 2870 | 76 |
2062758 | 2062758 | 2021-12-29 | San Lorenzo | Puerto Rico | 72129 | 2870 | |
2060303 | 2060303 | 2021-12-28 | Marquette | Wisconsin | 55077 | 2870 | 38 |
2035256 | 2035256 | 2021-12-21 | Winneshiek | Iowa | 19191 | 2870 | 44 |
2032006 | 2032006 | 2021-12-20 | Winneshiek | Iowa | 19191 | 2870 | 44 |
2028755 | 2028755 | 2021-12-19 | Winneshiek | Iowa | 19191 | 2870 | 44 |
2025504 | 2025504 | 2021-12-18 | Winneshiek | Iowa | 19191 | 2870 | 44 |
2022253 | 2022253 | 2021-12-17 | Winneshiek | Iowa | 19191 | 2870 | 44 |
2019002 | 2019002 | 2021-12-16 | Winneshiek | Iowa | 19191 | 2870 | 44 |
2015752 | 2015752 | 2021-12-15 | Winneshiek | Iowa | 19191 | 2870 | 44 |
1998506 | 1998506 | 2021-12-09 | Wetzel | West Virginia | 54103 | 2870 | 65 |
1984889 | 1984889 | 2021-12-05 | Cannon | Tennessee | 47015 | 2870 | 44 |
1981639 | 1981639 | 2021-12-04 | Cannon | Tennessee | 47015 | 2870 | 44 |
1978389 | 1978389 | 2021-12-03 | Cannon | Tennessee | 47015 | 2870 | 44 |
1971197 | 1971197 | 2021-12-01 | Taos | New Mexico | 35055 | 2870 | 71 |
1971264 | 1971264 | 2021-12-01 | Avery | North Carolina | 37011 | 2870 | 39 |
1940794 | 1940794 | 2021-11-22 | White | Illinois | 17193 | 2870 | 43 |
1921174 | 1921174 | 2021-11-16 | Gem | Idaho | 16045 | 2870 | 67 |
1918368 | 1918368 | 2021-11-15 | Casey | Kentucky | 21045 | 2870 | 58 |
1914360 | 1914360 | 2021-11-14 | Elbert | Colorado | 8039 | 2870 | 23 |
1915118 | 1915118 | 2021-11-14 | Casey | Kentucky | 21045 | 2870 | 58 |
1911110 | 1911110 | 2021-11-13 | Elbert | Colorado | 8039 | 2870 | 23 |
1911868 | 1911868 | 2021-11-13 | Casey | Kentucky | 21045 | 2870 | 58 |
1907861 | 1907861 | 2021-11-12 | Elbert | Colorado | 8039 | 2870 | 23 |
1896547 | 1896547 | 2021-11-08 | Hertford | North Carolina | 37091 | 2870 | 72 |
1876621 | 1876621 | 2021-11-02 | Clinton | Missouri | 29049 | 2870 | 77 |
1849239 | 1849239 | 2021-10-25 | Drew | Arkansas | 5043 | 2870 | 54 |
1849244 | 1849244 | 2021-10-25 | Grant | Arkansas | 5053 | 2870 | 48 |
1845989 | 1845989 | 2021-10-24 | Drew | Arkansas | 5043 | 2870 | 54 |
1845994 | 1845994 | 2021-10-24 | Grant | Arkansas | 5053 | 2870 | 48 |
1842739 | 1842739 | 2021-10-23 | Drew | Arkansas | 5043 | 2870 | 54 |
1842744 | 1842744 | 2021-10-23 | Grant | Arkansas | 5053 | 2870 | 48 |
1839489 | 1839489 | 2021-10-22 | Drew | Arkansas | 5043 | 2870 | 54 |
1842482 | 1842482 | 2021-10-22 | McDowell | West Virginia | 54047 | 2870 | 47 |
1813142 | 1813142 | 2021-10-13 | Prince Edward | Virginia | 51147 | 2870 | 50 |
1787341 | 1787341 | 2021-10-05 | Vilas | Wisconsin | 55125 | 2870 | 50 |
1771292 | 1771292 | 2021-10-01 | Polk | Arkansas | 5113 | 2870 | 100 |
1755892 | 1755892 | 2021-09-26 | Bourbon | Kentucky | 21017 | 2870 | 24 |
1756305 | 1756305 | 2021-09-26 | Chickasaw | Mississippi | 28017 | 2870 | 65 |
1752644 | 1752644 | 2021-09-25 | Bourbon | Kentucky | 21017 | 2870 | 24 |
1753057 | 1753057 | 2021-09-25 | Chickasaw | Mississippi | 28017 | 2870 | 65 |
1749395 | 1749395 | 2021-09-24 | Bourbon | Kentucky | 21017 | 2870 | 24 |
1749809 | 1749809 | 2021-09-24 | Chickasaw | Mississippi | 28017 | 2870 | 65 |
1743493 | 1743493 | 2021-09-22 | Texas | Missouri | 29215 | 2870 | 39 |
1723577 | 1723577 | 2021-09-16 | Aroostook | Maine | 23003 | 2870 | 68 |
1720142 | 1720142 | 2021-09-15 | Adair | Kentucky | 21001 | 2870 | 64 |
1711257 | 1711257 | 2021-09-12 | Delaware | New York | 36025 | 2870 | 40 |
1703075 | 1703075 | 2021-09-10 | Randolph | Arkansas | 5121 | 2870 | 50 |
1689310 | 1689310 | 2021-09-05 | Burleson | Texas | 48051 | 2870 | 51 |
1686060 | 1686060 | 2021-09-04 | Burleson | Texas | 48051 | 2870 | 51 |
1674284 | 1674284 | 2021-09-01 | Douglas | Illinois | 17041 | 2870 | 42 |
1646530 | 1646530 | 2021-08-23 | Holmes | Ohio | 39075 | 2870 | 103 |
1625050 | 1625050 | 2021-08-17 | Arkansas | Arkansas | 5001 | 2870 | 48 |
1605613 | 1605613 | 2021-08-11 | Ouachita | Arkansas | 5103 | 2870 | 66 |
1608377 | 1608377 | 2021-08-11 | St. Thomas | Virgin Islands | 78030 | 2870 | 23 |
1605128 | 1605128 | 2021-08-10 | St. Thomas | Virgin Islands | 78030 | 2870 | 23 |
1563082 | 1563082 | 2021-07-28 | Hancock | West Virginia | 54029 | 2870 | 90 |
1554686 | 1554686 | 2021-07-26 | Dorchester | Maryland | 24019 | 2870 | 65 |
1548589 | 1548589 | 2021-07-24 | Washington | Missouri | 29221 | 2870 | 53 |
1541392 | 1541392 | 2021-07-22 | Cherokee | Kansas | 20021 | 2870 | 56 |
1538145 | 1538145 | 2021-07-21 | Cherokee | Kansas | 20021 | 2870 | 56 |
1533883 | 1533883 | 2021-07-19 | Randolph | West Virginia | 54083 | 2870 | 15 |
1527673 | 1527673 | 2021-07-18 | Sevier | Arkansas | 5133 | 2870 | 24 |
1529581 | 1529581 | 2021-07-18 | Fayette | Ohio | 39047 | 2870 | 50 |
1524426 | 1524426 | 2021-07-17 | Sevier | Arkansas | 5133 | 2870 | 24 |
1526334 | 1526334 | 2021-07-17 | Fayette | Ohio | 39047 | 2870 | 50 |
1521178 | 1521178 | 2021-07-16 | Sevier | Arkansas | 5133 | 2870 | 24 |
1522502 | 1522502 | 2021-07-16 | Audrain | Missouri | 29007 | 2870 | 58 |
1523087 | 1523087 | 2021-07-16 | Fayette | Ohio | 39047 | 2870 | 50 |
1519839 | 1519839 | 2021-07-15 | Fayette | Ohio | 39047 | 2870 | 50 |
1515909 | 1515909 | 2021-07-14 | Todd | Minnesota | 27153 | 2870 | 33 |
1513344 | 1513344 | 2021-07-13 | Fayette | Ohio | 39047 | 2870 | 50 |
1510098 | 1510098 | 2021-07-12 | Fayette | Ohio | 39047 | 2870 | 50 |
1505855 | 1505855 | 2021-07-11 | Montgomery | Kentucky | 21173 | 2870 | 30 |
1502609 | 1502609 | 2021-07-10 | Montgomery | Kentucky | 21173 | 2870 | 30 |
1499363 | 1499363 | 2021-07-09 | Montgomery | Kentucky | 21173 | 2870 | 30 |
1496116 | 1496116 | 2021-07-08 | Montgomery | Kentucky | 21173 | 2870 | 30 |
1481082 | 1481082 | 2021-07-03 | Elk | Pennsylvania | 42047 | 2870 | 41 |
1473640 | 1473640 | 2021-07-01 | Cass | Minnesota | 27021 | 2870 | 32 |
1459002 | 1459002 | 2021-06-26 | Accomack | Virginia | 51001 | 2870 | 45 |
1451177 | 1451177 | 2021-06-24 | Saline | Missouri | 29195 | 2870 | 38 |
1442437 | 1442437 | 2021-06-21 | McNairy | Tennessee | 47109 | 2870 | 55 |
1437414 | 1437414 | 2021-06-20 | Carroll | Iowa | 19027 | 2870 | 52 |
1439192 | 1439192 | 2021-06-20 | McNairy | Tennessee | 47109 | 2870 | 55 |
1435945 | 1435945 | 2021-06-19 | McNairy | Tennessee | 47109 | 2870 | 55 |
1432698 | 1432698 | 2021-06-18 | McNairy | Tennessee | 47109 | 2870 | 55 |
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);