ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
317 rows where cases = 1639 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 23
- Georgia 23
- Iowa 21
- Kentucky 19
- Indiana 15
- North Carolina 15
- Texas 15
- Puerto Rico 14
- Mississippi 12
- Alabama 11
- Louisiana 10
- Michigan 10
- Missouri 10
- Tennessee 10
- Montana 9
- Virginia 9
- Florida 8
- Oklahoma 8
- Idaho 7
- Illinois 7
- Minnesota 7
- Nebraska 6
- Ohio 6
- North Dakota 5
- Washington 5
- West Virginia 5
- Colorado 4
- Kansas 4
- South Carolina 4
- Wisconsin 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472928 | 2472928 | 2022-05-04 | Coleman | Texas | 48083 | 1639 | 71 |
2248521 | 2248521 | 2022-02-24 | Marion | Texas | 48315 | 1639 | 58 |
2174380 | 2174380 | 2022-02-02 | Woodruff | Arkansas | 5147 | 1639 | 24 |
2168367 | 2168367 | 2022-01-31 | Pulaski | Illinois | 17153 | 1639 | 16 |
2164595 | 2164595 | 2022-01-30 | Newton | Arkansas | 5101 | 1639 | 45 |
2166355 | 2166355 | 2022-01-30 | Camden | North Carolina | 37029 | 1639 | 9 |
2161340 | 2161340 | 2022-01-29 | Newton | Arkansas | 5101 | 1639 | 45 |
2163100 | 2163100 | 2022-01-29 | Camden | North Carolina | 37029 | 1639 | 9 |
2158084 | 2158084 | 2022-01-28 | Newton | Arkansas | 5101 | 1639 | 45 |
2159845 | 2159845 | 2022-01-28 | Camden | North Carolina | 37029 | 1639 | 9 |
2131645 | 2131645 | 2022-01-19 | Lunenburg | Virginia | 51111 | 1639 | 24 |
2124816 | 2124816 | 2022-01-17 | Crosby | Texas | 48107 | 1639 | 42 |
2117672 | 2117672 | 2022-01-15 | Pembina | North Dakota | 38067 | 1639 | 16 |
2115532 | 2115532 | 2022-01-14 | Webster | West Virginia | 54101 | 1639 | 27 |
2104077 | 2104077 | 2022-01-11 | Kemper | Mississippi | 28069 | 1639 | 42 |
2096631 | 2096631 | 2022-01-09 | Pulaski | Georgia | 13235 | 1639 | 68 |
2093379 | 2093379 | 2022-01-08 | Pulaski | Georgia | 13235 | 1639 | 68 |
2090127 | 2090127 | 2022-01-07 | Pulaski | Georgia | 13235 | 1639 | 68 |
2086876 | 2086876 | 2022-01-06 | Pulaski | Georgia | 13235 | 1639 | 68 |
2087293 | 2087293 | 2022-01-06 | Ellsworth | Kansas | 20053 | 1639 | 30 |
2083624 | 2083624 | 2022-01-05 | Pulaski | Georgia | 13235 | 1639 | 68 |
2084041 | 2084041 | 2022-01-05 | Ellsworth | Kansas | 20053 | 1639 | 30 |
2080796 | 2080796 | 2022-01-04 | Grant | Kansas | 20067 | 1639 | 33 |
2077544 | 2077544 | 2022-01-03 | Grant | Kansas | 20067 | 1639 | 33 |
2064128 | 2064128 | 2021-12-30 | Stewart | Georgia | 13259 | 1639 | 30 |
2066006 | 2066006 | 2021-12-30 | San German | Puerto Rico | 72125 | 1639 | |
2055404 | 2055404 | 2021-12-27 | Howard | Missouri | 29089 | 1639 | 19 |
2051659 | 2051659 | 2021-12-26 | Hancock | Kentucky | 21091 | 1639 | 19 |
2048409 | 2048409 | 2021-12-25 | Hancock | Kentucky | 21091 | 1639 | 19 |
2045159 | 2045159 | 2021-12-24 | Hancock | Kentucky | 21091 | 1639 | 19 |
2041910 | 2041910 | 2021-12-23 | Hancock | Kentucky | 21091 | 1639 | 19 |
2038660 | 2038660 | 2021-12-22 | Hancock | Kentucky | 21091 | 1639 | 19 |
2039127 | 2039127 | 2021-12-22 | Carroll | Missouri | 29033 | 1639 | 39 |
2000134 | 2000134 | 2021-12-10 | DeKalb | Missouri | 29063 | 1639 | 37 |
1989934 | 1989934 | 2021-12-07 | McLean | Kentucky | 21149 | 1639 | 40 |
1986181 | 1986181 | 2021-12-06 | Fremont | Idaho | 16043 | 1639 | 18 |
1987089 | 1987089 | 2021-12-06 | Tunica | Mississippi | 28143 | 1639 | 39 |
1975577 | 1975577 | 2021-12-02 | Galax city | Virginia | 51640 | 1639 | 64 |
1966811 | 1966811 | 2021-11-30 | Benton | Indiana | 18007 | 1639 | 17 |
1965705 | 1965705 | 2021-11-29 | Trinity | Texas | 48455 | 1639 | 61 |
1961277 | 1961277 | 2021-11-28 | Box Butte | Nebraska | 31013 | 1639 | 16 |
1962197 | 1962197 | 2021-11-28 | Perry | Tennessee | 47135 | 1639 | 34 |
1958026 | 1958026 | 2021-11-27 | Box Butte | Nebraska | 31013 | 1639 | 16 |
1958946 | 1958946 | 2021-11-27 | Perry | Tennessee | 47135 | 1639 | 34 |
1954775 | 1954775 | 2021-11-26 | Box Butte | Nebraska | 31013 | 1639 | 16 |
1955695 | 1955695 | 2021-11-26 | Perry | Tennessee | 47135 | 1639 | 34 |
1951524 | 1951524 | 2021-11-25 | Box Butte | Nebraska | 31013 | 1639 | 15 |
1952444 | 1952444 | 2021-11-25 | Perry | Tennessee | 47135 | 1639 | 34 |
1948273 | 1948273 | 2021-11-24 | Box Butte | Nebraska | 31013 | 1639 | 15 |
1949193 | 1949193 | 2021-11-24 | Perry | Tennessee | 47135 | 1639 | 34 |
1939931 | 1939931 | 2021-11-21 | Pend Oreille | Washington | 53051 | 1639 | 24 |
1936681 | 1936681 | 2021-11-20 | Pend Oreille | Washington | 53051 | 1639 | 24 |
1933431 | 1933431 | 2021-11-19 | Pend Oreille | Washington | 53051 | 1639 | 24 |
1927537 | 1927537 | 2021-11-18 | Evans | Georgia | 13109 | 1639 | 54 |
1928232 | 1928232 | 2021-11-18 | East Carroll | Louisiana | 22035 | 1639 | 31 |
1928719 | 1928719 | 2021-11-18 | Deer Lodge | Montana | 30023 | 1639 | 27 |
1924982 | 1924982 | 2021-11-17 | East Carroll | Louisiana | 22035 | 1639 | 31 |
1906637 | 1906637 | 2021-11-11 | Forest | Pennsylvania | 42053 | 1639 | 25 |
1898421 | 1898421 | 2021-11-09 | Clearwater | Idaho | 16035 | 1639 | 26 |
1896504 | 1896504 | 2021-11-08 | Alleghany | North Carolina | 37005 | 1639 | 6 |
1876724 | 1876724 | 2021-11-02 | Dawson | Montana | 30021 | 1639 | 46 |
1856199 | 1856199 | 2021-10-27 | Owyhee | Idaho | 16073 | 1639 | 39 |
1856203 | 1856203 | 2021-10-27 | Teton | Idaho | 16081 | 1639 | 5 |
1836186 | 1836186 | 2021-10-21 | Ketchikan Gateway Borough | Alaska | 2130 | 1639 | 9 |
1807304 | 1807304 | 2021-10-12 | Dooly | Georgia | 13093 | 1639 | 54 |
1808086 | 1808086 | 2021-10-12 | Kent | Maryland | 24029 | 1639 | 55 |
1789346 | 1789346 | 2021-10-06 | Pamlico | North Carolina | 37137 | 1639 | 23 |
1784958 | 1784958 | 2021-10-05 | Grundy | Iowa | 19075 | 1639 | 36 |
1781709 | 1781709 | 2021-10-04 | Grundy | Iowa | 19075 | 1639 | 36 |
1778459 | 1778459 | 2021-10-03 | Grundy | Iowa | 19075 | 1639 | 36 |
1774440 | 1774440 | 2021-10-02 | Wilcox | Alabama | 1131 | 1639 | 37 |
1775209 | 1775209 | 2021-10-02 | Grundy | Iowa | 19075 | 1639 | 36 |
1771959 | 1771959 | 2021-10-01 | Grundy | Iowa | 19075 | 1639 | 36 |
1768710 | 1768710 | 2021-09-30 | Grundy | Iowa | 19075 | 1639 | 36 |
1765461 | 1765461 | 2021-09-29 | Grundy | Iowa | 19075 | 1639 | 36 |
1758265 | 1758265 | 2021-09-27 | Fulton | Arkansas | 5049 | 1639 | 55 |
1744357 | 1744357 | 2021-09-22 | Butte | South Dakota | 46019 | 1639 | 24 |
1732156 | 1732156 | 2021-09-19 | Coosa | Alabama | 1037 | 1639 | 31 |
1730924 | 1730924 | 2021-09-18 | Mountrail | North Dakota | 38061 | 1639 | 21 |
1683081 | 1683081 | 2021-09-03 | Windham | Vermont | 50025 | 1639 | 16 |
1677490 | 1677490 | 2021-09-02 | Gooding | Idaho | 16047 | 1639 | 27 |
1672061 | 1672061 | 2021-08-31 | Park | Montana | 30067 | 1639 | 24 |
1668253 | 1668253 | 2021-08-30 | Monroe | Kentucky | 21171 | 1639 | 48 |
1657575 | 1657575 | 2021-08-27 | Little River | Arkansas | 5081 | 1639 | 43 |
1657151 | 1657151 | 2021-08-26 | Goochland | Virginia | 51075 | 1639 | 24 |
1650025 | 1650025 | 2021-08-24 | Camuy | Puerto Rico | 72027 | 1639 | |
1627131 | 1627131 | 2021-08-17 | Love | Oklahoma | 40085 | 1639 | 23 |
1623884 | 1623884 | 2021-08-16 | Love | Oklahoma | 40085 | 1639 | 23 |
1620637 | 1620637 | 2021-08-15 | Love | Oklahoma | 40085 | 1639 | 23 |
1617389 | 1617389 | 2021-08-14 | Love | Oklahoma | 40085 | 1639 | 23 |
1614141 | 1614141 | 2021-08-13 | Love | Oklahoma | 40085 | 1639 | 23 |
1610892 | 1610892 | 2021-08-12 | Love | Oklahoma | 40085 | 1639 | 23 |
1607644 | 1607644 | 2021-08-11 | Love | Oklahoma | 40085 | 1639 | 23 |
1598897 | 1598897 | 2021-08-08 | Marquette | Wisconsin | 55077 | 1639 | 28 |
1595648 | 1595648 | 2021-08-07 | Marquette | Wisconsin | 55077 | 1639 | 28 |
1592399 | 1592399 | 2021-08-06 | Marquette | Wisconsin | 55077 | 1639 | 28 |
1586998 | 1586998 | 2021-08-05 | Garrard | Kentucky | 21079 | 1639 | 37 |
1582286 | 1582286 | 2021-08-03 | San Jacinto | Texas | 48407 | 1639 | 39 |
1551381 | 1551381 | 2021-07-25 | Madison | Louisiana | 22065 | 1639 | 40 |
1552776 | 1552776 | 2021-07-25 | Decatur | Tennessee | 47039 | 1639 | 39 |
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);