ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
129 rows where cases = 4099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Arkansas 9
- Kentucky 9
- Virginia 9
- Iowa 8
- Minnesota 8
- Mississippi 7
- Alabama 6
- Michigan 6
- Missouri 6
- Illinois 5
- Ohio 5
- Idaho 4
- Kansas 4
- West Virginia 3
- Georgia 2
- Indiana 2
- Montana 2
- New Jersey 2
- New York 2
- Oregon 2
- Utah 2
- Colorado 1
- Hawaii 1
- Louisiana 1
- North Carolina 1
- North Dakota 1
- Oklahoma 1
- Puerto Rico 1
- Tennessee 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499588 | 2499588 | 2022-05-13 | Clay | Alabama | 1027 | 4099 | 82 |
2437089 | 2437089 | 2022-04-23 | Bosque | Texas | 48035 | 4099 | 70 |
2433833 | 2433833 | 2022-04-22 | Bosque | Texas | 48035 | 4099 | 70 |
2388238 | 2388238 | 2022-04-08 | Aransas | Texas | 48007 | 4099 | 83 |
2379497 | 2379497 | 2022-04-06 | Brantley | Georgia | 13025 | 4099 | 107 |
2359696 | 2359696 | 2022-03-31 | Clay | Arkansas | 5021 | 4099 | 92 |
2356442 | 2356442 | 2022-03-30 | Clay | Arkansas | 5021 | 4099 | 92 |
2356724 | 2356724 | 2022-03-30 | Brantley | Georgia | 13025 | 4099 | 107 |
2353189 | 2353189 | 2022-03-29 | Clay | Arkansas | 5021 | 4099 | 91 |
2349937 | 2349937 | 2022-03-28 | Clay | Arkansas | 5021 | 4099 | 91 |
2346684 | 2346684 | 2022-03-27 | Clay | Arkansas | 5021 | 4099 | 91 |
2343431 | 2343431 | 2022-03-26 | Clay | Arkansas | 5021 | 4099 | 91 |
2340178 | 2340178 | 2022-03-25 | Clay | Arkansas | 5021 | 4099 | 90 |
2336925 | 2336925 | 2022-03-24 | Clay | Arkansas | 5021 | 4099 | 90 |
2324825 | 2324825 | 2022-03-20 | Estill | Kentucky | 21065 | 4099 | 44 |
2321571 | 2321571 | 2022-03-19 | Estill | Kentucky | 21065 | 4099 | 44 |
2318317 | 2318317 | 2022-03-18 | Estill | Kentucky | 21065 | 4099 | 44 |
2315064 | 2315064 | 2022-03-17 | Estill | Kentucky | 21065 | 4099 | 44 |
2311811 | 2311811 | 2022-03-16 | Estill | Kentucky | 21065 | 4099 | 44 |
2308558 | 2308558 | 2022-03-15 | Estill | Kentucky | 21065 | 4099 | 44 |
2305307 | 2305307 | 2022-03-14 | Estill | Kentucky | 21065 | 4099 | 44 |
2297936 | 2297936 | 2022-03-12 | Polk | Arkansas | 5113 | 4099 | 142 |
2285600 | 2285600 | 2022-03-08 | Hardin | Iowa | 19083 | 4099 | 58 |
2282348 | 2282348 | 2022-03-07 | Hardin | Iowa | 19083 | 4099 | 58 |
2279095 | 2279095 | 2022-03-06 | Hardin | Iowa | 19083 | 4099 | 58 |
2275842 | 2275842 | 2022-03-05 | Hardin | Iowa | 19083 | 4099 | 58 |
2272589 | 2272589 | 2022-03-04 | Hardin | Iowa | 19083 | 4099 | 58 |
2269337 | 2269337 | 2022-03-03 | Hardin | Iowa | 19083 | 4099 | 58 |
2266084 | 2266084 | 2022-03-02 | Hardin | Iowa | 19083 | 4099 | 58 |
2243994 | 2243994 | 2022-02-23 | Benton | Missouri | 29015 | 4099 | 88 |
2213096 | 2213096 | 2022-02-13 | Hardy | West Virginia | 54031 | 4099 | 47 |
2198392 | 2198392 | 2022-02-09 | Clarke | Mississippi | 28023 | 4099 | 100 |
2196481 | 2196481 | 2022-02-08 | Lavaca | Texas | 48285 | 4099 | 107 |
2171654 | 2171654 | 2022-02-01 | Carroll | Indiana | 18015 | 4099 | 58 |
2132835 | 2132835 | 2022-01-20 | Jefferson | Kansas | 20087 | 4099 | 54 |
2129582 | 2129582 | 2022-01-19 | Jefferson | Kansas | 20087 | 4099 | 54 |
2118424 | 2118424 | 2022-01-15 | Milam | Texas | 48331 | 4099 | 93 |
2089058 | 2089058 | 2022-01-06 | Dimmit | Texas | 48127 | 4099 | 47 |
2056012 | 2056012 | 2021-12-27 | Wyandot | Ohio | 39175 | 4099 | 81 |
2052763 | 2052763 | 2021-12-26 | Wyandot | Ohio | 39175 | 4099 | 81 |
2031017 | 2031017 | 2021-12-19 | Wyoming | West Virginia | 54109 | 4099 | 75 |
1983457 | 1983457 | 2021-12-05 | Russell | Kentucky | 21207 | 4099 | 63 |
1980207 | 1980207 | 2021-12-04 | Russell | Kentucky | 21207 | 4099 | 63 |
1946286 | 1946286 | 2021-11-23 | Botetourt | Virginia | 51023 | 4099 | 55 |
1856188 | 1856188 | 2021-10-27 | Jefferson | Idaho | 16051 | 4099 | 43 |
1837443 | 1837443 | 2021-10-21 | Brown | Minnesota | 27015 | 4099 | 47 |
1825206 | 1825206 | 2021-10-17 | Hardin | Ohio | 39065 | 4099 | 76 |
1821925 | 1821925 | 2021-10-16 | Adams | Ohio | 39001 | 4099 | 87 |
1780558 | 1780558 | 2021-10-03 | Amherst | Virginia | 51009 | 4099 | 53 |
1776428 | 1776428 | 2021-10-02 | Stutsman | North Dakota | 38093 | 4099 | 82 |
1777308 | 1777308 | 2021-10-02 | Amherst | Virginia | 51009 | 4099 | 53 |
1774058 | 1774058 | 2021-10-01 | Amherst | Virginia | 51009 | 4099 | 53 |
1767616 | 1767616 | 2021-09-29 | Isle of Wight | Virginia | 51093 | 4099 | 77 |
1756342 | 1756342 | 2021-09-26 | Marion | Mississippi | 28091 | 4099 | 104 |
1753094 | 1753094 | 2021-09-25 | Marion | Mississippi | 28091 | 4099 | 104 |
1749846 | 1749846 | 2021-09-24 | Marion | Mississippi | 28091 | 4099 | 104 |
1745174 | 1745174 | 2021-09-23 | Lawrence | Alabama | 1079 | 4099 | 108 |
1747794 | 1747794 | 2021-09-23 | Cass | Texas | 48067 | 4099 | 115 |
1724273 | 1724273 | 2021-09-16 | Otsego | New York | 36077 | 4099 | 50 |
1710882 | 1710882 | 2021-09-12 | Tate | Mississippi | 28137 | 4099 | 96 |
1707635 | 1707635 | 2021-09-11 | Tate | Mississippi | 28137 | 4099 | 96 |
1704388 | 1704388 | 2021-09-10 | Tate | Mississippi | 28137 | 4099 | 96 |
1700818 | 1700818 | 2021-09-09 | Sabine | Louisiana | 22085 | 4099 | 69 |
1691238 | 1691238 | 2021-09-06 | Becker | Minnesota | 27005 | 4099 | 58 |
1687988 | 1687988 | 2021-09-05 | Becker | Minnesota | 27005 | 4099 | 58 |
1684738 | 1684738 | 2021-09-04 | Becker | Minnesota | 27005 | 4099 | 58 |
1681487 | 1681487 | 2021-09-03 | Becker | Minnesota | 27005 | 4099 | 58 |
1669396 | 1669396 | 2021-08-30 | Benton | Oregon | 41003 | 4099 | 23 |
1654188 | 1654188 | 2021-08-26 | Clarke | Alabama | 1025 | 4099 | 67 |
1608983 | 1608983 | 2021-08-12 | Logan | Colorado | 8075 | 4099 | 69 |
1606851 | 1606851 | 2021-08-11 | Steele | Minnesota | 27147 | 4099 | 19 |
1588856 | 1588856 | 2021-08-05 | Sanpete | Utah | 49039 | 4099 | 25 |
1576964 | 1576964 | 2021-08-02 | Miami | Indiana | 18103 | 4099 | 74 |
1554104 | 1554104 | 2021-07-26 | Fulton | Illinois | 17057 | 4099 | 67 |
1554748 | 1554748 | 2021-07-26 | Huron | Michigan | 26063 | 4099 | 82 |
1551501 | 1551501 | 2021-07-25 | Huron | Michigan | 26063 | 4099 | 82 |
1548254 | 1548254 | 2021-07-24 | Huron | Michigan | 26063 | 4099 | 82 |
1545007 | 1545007 | 2021-07-23 | Huron | Michigan | 26063 | 4099 | 82 |
1538780 | 1538780 | 2021-07-21 | Howell | Missouri | 29091 | 4099 | 50 |
1340738 | 1340738 | 2021-05-21 | Camden | Missouri | 29029 | 4099 | 87 |
1331146 | 1331146 | 2021-05-18 | Silver Bow | Montana | 30093 | 4099 | 86 |
1318161 | 1318161 | 2021-05-14 | Silver Bow | Montana | 30093 | 4099 | 86 |
1293392 | 1293392 | 2021-05-06 | Wharton | Texas | 48481 | 4099 | 115 |
1252412 | 1252412 | 2021-04-24 | Jasper | Iowa | 19099 | 4099 | 70 |
1241113 | 1241113 | 2021-04-20 | Campbell | Tennessee | 47013 | 4099 | 62 |
1231876 | 1231876 | 2021-04-17 | Shenandoah | Virginia | 51171 | 4099 | 129 |
1226144 | 1226144 | 2021-04-16 | Maui | Hawaii | 15009 | 4099 | 47 |
1200246 | 1200246 | 2021-04-08 | Jefferson | Illinois | 17081 | 4099 | 119 |
1192555 | 1192555 | 2021-04-05 | Erath | Texas | 48143 | 4099 | 67 |
1189306 | 1189306 | 2021-04-04 | Erath | Texas | 48143 | 4099 | 67 |
1186059 | 1186059 | 2021-04-03 | Erath | Texas | 48143 | 4099 | 67 |
1179618 | 1179618 | 2021-04-01 | Jim Wells | Texas | 48249 | 4099 | 95 |
1176283 | 1176283 | 2021-03-31 | Cherokee | Texas | 48073 | 4099 | 135 |
1166738 | 1166738 | 2021-03-28 | Van Zandt | Texas | 48467 | 4099 | 113 |
1163490 | 1163490 | 2021-03-27 | Van Zandt | Texas | 48467 | 4099 | 113 |
1160241 | 1160241 | 2021-03-26 | Van Zandt | Texas | 48467 | 4099 | 112 |
1156994 | 1156994 | 2021-03-25 | Van Zandt | Texas | 48467 | 4099 | 112 |
1134412 | 1134412 | 2021-03-18 | Manassas city | Virginia | 51683 | 4099 | 44 |
1127017 | 1127017 | 2021-03-16 | Knox | Ohio | 39083 | 4099 | 107 |
1106105 | 1106105 | 2021-03-10 | Monroe | Illinois | 17133 | 4099 | 89 |
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);