ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where cases = 2095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 26
- Georgia 17
- Kentucky 14
- Arkansas 13
- Mississippi 13
- Wisconsin 12
- Illinois 11
- Iowa 11
- Missouri 11
- North Carolina 10
- Puerto Rico 9
- Kansas 8
- West Virginia 8
- Idaho 6
- Indiana 6
- North Dakota 6
- South Dakota 6
- Alabama 5
- Nebraska 5
- South Carolina 5
- Virginia 5
- Washington 5
- Colorado 4
- Louisiana 4
- Michigan 4
- Oregon 4
- New York 3
- Tennessee 3
- Maryland 2
- Montana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498987 | 2498987 | 2022-05-12 | Clay | Texas | 48077 | 2095 | 35 |
2495729 | 2495729 | 2022-05-11 | Clay | Texas | 48077 | 2095 | 35 |
2492471 | 2492471 | 2022-05-10 | Clay | Texas | 48077 | 2095 | 35 |
2473564 | 2473564 | 2022-05-05 | Perry | Alabama | 1105 | 2095 | 46 |
2474080 | 2474080 | 2022-05-05 | Boundary | Idaho | 16021 | 2095 | 62 |
2470307 | 2470307 | 2022-05-04 | Perry | Alabama | 1105 | 2095 | 46 |
2470823 | 2470823 | 2022-05-04 | Boundary | Idaho | 16021 | 2095 | 62 |
2453693 | 2453693 | 2022-04-28 | Falls Church city | Virginia | 51610 | 2095 | 17 |
2445581 | 2445581 | 2022-04-26 | Marshall | Minnesota | 27089 | 2095 | 23 |
2311188 | 2311188 | 2022-03-16 | Candler | Georgia | 13043 | 2095 | 94 |
2303393 | 2303393 | 2022-03-13 | Jayuya | Puerto Rico | 72073 | 2095 | |
2297943 | 2297943 | 2022-03-12 | Searcy | Arkansas | 5129 | 2095 | 42 |
2269512 | 2269512 | 2022-03-03 | Bracken | Kentucky | 21023 | 2095 | 24 |
2258332 | 2258332 | 2022-02-27 | Somervell | Texas | 48425 | 2095 | 34 |
2255081 | 2255081 | 2022-02-26 | Somervell | Texas | 48425 | 2095 | 34 |
2251830 | 2251830 | 2022-02-25 | Somervell | Texas | 48425 | 2095 | 34 |
2248579 | 2248579 | 2022-02-24 | Somervell | Texas | 48425 | 2095 | 34 |
2241920 | 2241920 | 2022-02-22 | Dallam | Texas | 48111 | 2095 | 39 |
2238669 | 2238669 | 2022-02-21 | Dallam | Texas | 48111 | 2095 | 39 |
2235418 | 2235418 | 2022-02-20 | Dallam | Texas | 48111 | 2095 | 39 |
2232167 | 2232167 | 2022-02-19 | Dallam | Texas | 48111 | 2095 | 39 |
2228916 | 2228916 | 2022-02-18 | Dallam | Texas | 48111 | 2095 | 38 |
2223952 | 2223952 | 2022-02-17 | Pawnee | Kansas | 20145 | 2095 | 23 |
2225665 | 2225665 | 2022-02-17 | Dallam | Texas | 48111 | 2095 | 38 |
2220701 | 2220701 | 2022-02-16 | Pawnee | Kansas | 20145 | 2095 | 23 |
2220894 | 2220894 | 2022-02-16 | Red River | Louisiana | 22081 | 2095 | 51 |
2188915 | 2188915 | 2022-02-06 | Hamilton | Nebraska | 31081 | 2095 | 22 |
2185662 | 2185662 | 2022-02-05 | Hamilton | Nebraska | 31081 | 2095 | 22 |
2182410 | 2182410 | 2022-02-04 | Hamilton | Nebraska | 31081 | 2095 | 22 |
2158525 | 2158525 | 2022-01-28 | Washington | Idaho | 16087 | 2095 | 52 |
2155271 | 2155271 | 2022-01-27 | Washington | Idaho | 16087 | 2095 | 52 |
2138296 | 2138296 | 2022-01-21 | Summers | West Virginia | 54089 | 2095 | 43 |
2124604 | 2124604 | 2022-01-17 | Bon Homme | South Dakota | 46009 | 2095 | 33 |
2121352 | 2121352 | 2022-01-16 | Bon Homme | South Dakota | 46009 | 2095 | 33 |
2118100 | 2118100 | 2022-01-15 | Bon Homme | South Dakota | 46009 | 2095 | 33 |
2114849 | 2114849 | 2022-01-14 | Bon Homme | South Dakota | 46009 | 2095 | 33 |
2107435 | 2107435 | 2022-01-12 | Linn | Missouri | 29115 | 2095 | 59 |
2104626 | 2104626 | 2022-01-11 | Washington | North Carolina | 37187 | 2095 | 39 |
2088026 | 2088026 | 2022-01-06 | Richland | Montana | 30083 | 2095 | 30 |
2035856 | 2035856 | 2021-12-21 | Webster | Mississippi | 28155 | 2095 | 49 |
2028815 | 2028815 | 2021-12-19 | Marion | Kansas | 20115 | 2095 | 35 |
2030767 | 2030767 | 2021-12-19 | Unknown | Utah | 2095 | 50 | |
2025564 | 2025564 | 2021-12-18 | Marion | Kansas | 20115 | 2095 | 35 |
2027516 | 2027516 | 2021-12-18 | Unknown | Utah | 2095 | 50 | |
2022313 | 2022313 | 2021-12-17 | Marion | Kansas | 20115 | 2095 | 35 |
2013959 | 2013959 | 2021-12-14 | Cayey | Puerto Rico | 72035 | 2095 | |
2010708 | 2010708 | 2021-12-13 | Cayey | Puerto Rico | 72035 | 2095 | |
2006696 | 2006696 | 2021-12-12 | Ripley | Missouri | 29181 | 2095 | 51 |
2007457 | 2007457 | 2021-12-12 | Cayey | Puerto Rico | 72035 | 2095 | |
2004206 | 2004206 | 2021-12-11 | Cayey | Puerto Rico | 72035 | 2095 | |
2000955 | 2000955 | 2021-12-10 | Cayey | Puerto Rico | 72035 | 2095 | |
1996440 | 1996440 | 2021-12-09 | Metcalfe | Kentucky | 21169 | 2095 | 48 |
1972681 | 1972681 | 2021-12-02 | Ketchikan Gateway Borough | Alaska | 2130 | 2095 | 11 |
1974635 | 1974635 | 2021-12-02 | McLean | North Dakota | 38055 | 2095 | 44 |
1961018 | 1961018 | 2021-11-28 | Amite | Mississippi | 28005 | 2095 | 57 |
1957767 | 1957767 | 2021-11-27 | Amite | Mississippi | 28005 | 2095 | 57 |
1954516 | 1954516 | 2021-11-26 | Amite | Mississippi | 28005 | 2095 | 57 |
1951265 | 1951265 | 2021-11-25 | Amite | Mississippi | 28005 | 2095 | 57 |
1948014 | 1948014 | 2021-11-24 | Amite | Mississippi | 28005 | 2095 | 57 |
1944763 | 1944763 | 2021-11-23 | Amite | Mississippi | 28005 | 2095 | 57 |
1941512 | 1941512 | 2021-11-22 | Amite | Mississippi | 28005 | 2095 | 57 |
1942337 | 1942337 | 2021-11-22 | Hood River | Oregon | 41027 | 2095 | 37 |
1896562 | 1896562 | 2021-11-08 | Mitchell | North Carolina | 37121 | 2095 | 21 |
1874828 | 1874828 | 2021-11-01 | Grayson | Virginia | 51077 | 2095 | 46 |
1868482 | 1868482 | 2021-10-30 | Monroe | West Virginia | 54063 | 2095 | 26 |
1859966 | 1859966 | 2021-10-28 | Trigg | Kentucky | 21221 | 2095 | 22 |
1806827 | 1806827 | 2021-10-11 | Rusk | Wisconsin | 55107 | 2095 | 32 |
1802789 | 1802789 | 2021-10-10 | Bamberg | South Carolina | 45009 | 2095 | 63 |
1799540 | 1799540 | 2021-10-09 | Bamberg | South Carolina | 45009 | 2095 | 63 |
1796291 | 1796291 | 2021-10-08 | Bamberg | South Carolina | 45009 | 2095 | 63 |
1785699 | 1785699 | 2021-10-05 | Osage | Missouri | 29151 | 2095 | 22 |
1778124 | 1778124 | 2021-10-03 | Oglethorpe | Georgia | 13221 | 2095 | 38 |
1778206 | 1778206 | 2021-10-03 | Gooding | Idaho | 16047 | 2095 | 33 |
1774874 | 1774874 | 2021-10-02 | Oglethorpe | Georgia | 13221 | 2095 | 38 |
1771624 | 1771624 | 2021-10-01 | Oglethorpe | Georgia | 13221 | 2095 | 38 |
1765645 | 1765645 | 2021-09-29 | Caldwell | Kentucky | 21033 | 2095 | 45 |
1745902 | 1745902 | 2021-09-23 | Pike | Indiana | 18125 | 2095 | 39 |
1734194 | 1734194 | 2021-09-19 | Walsh | North Dakota | 38099 | 2095 | 27 |
1730944 | 1730944 | 2021-09-18 | Walsh | North Dakota | 38099 | 2095 | 27 |
1717008 | 1717008 | 2021-09-14 | Washington | Kentucky | 21229 | 2095 | 42 |
1700707 | 1700707 | 2021-09-09 | Henry | Kentucky | 21103 | 2095 | 21 |
1700772 | 1700772 | 2021-09-09 | Webster | Kentucky | 21233 | 2095 | 29 |
1697101 | 1697101 | 2021-09-08 | Warren | Illinois | 17187 | 2095 | 56 |
1693969 | 1693969 | 2021-09-07 | Cedar | Iowa | 19031 | 2095 | 24 |
1690720 | 1690720 | 2021-09-06 | Cedar | Iowa | 19031 | 2095 | 24 |
1687470 | 1687470 | 2021-09-05 | Cedar | Iowa | 19031 | 2095 | 24 |
1684220 | 1684220 | 2021-09-04 | Cedar | Iowa | 19031 | 2095 | 24 |
1680969 | 1680969 | 2021-09-03 | Cedar | Iowa | 19031 | 2095 | 24 |
1677721 | 1677721 | 2021-09-02 | Cedar | Iowa | 19031 | 2095 | 24 |
1679366 | 1679366 | 2021-09-02 | Saluda | South Carolina | 45081 | 2095 | 49 |
1679551 | 1679551 | 2021-09-02 | Bosque | Texas | 48035 | 2095 | 43 |
1674474 | 1674474 | 2021-09-01 | Cedar | Iowa | 19031 | 2095 | 24 |
1664074 | 1664074 | 2021-08-29 | Madison | Arkansas | 5087 | 2095 | 32 |
1665963 | 1665963 | 2021-08-29 | Richland | North Dakota | 38077 | 2095 | 18 |
1662715 | 1662715 | 2021-08-28 | Richland | North Dakota | 38077 | 2095 | 18 |
1653176 | 1653176 | 2021-08-25 | Lincoln | Oregon | 41041 | 2095 | 25 |
1637560 | 1637560 | 2021-08-20 | Zavala | Texas | 48507 | 2095 | 46 |
1622389 | 1622389 | 2021-08-16 | Wayne | Illinois | 17191 | 2095 | 55 |
1611067 | 1611067 | 2021-08-12 | Isabela | Puerto Rico | 72071 | 2095 | |
1603416 | 1603416 | 2021-08-10 | Garrett | Maryland | 24023 | 2095 | 66 |
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);