ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
416 rows where cases = 1237 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 43
- Virginia 27
- Iowa 24
- Kansas 23
- Georgia 21
- Idaho 18
- Kentucky 17
- Oklahoma 17
- Puerto Rico 15
- West Virginia 15
- Illinois 14
- Michigan 12
- North Carolina 12
- Alabama 11
- Arkansas 10
- Mississippi 10
- South Dakota 10
- Indiana 8
- Nebraska 8
- Oregon 8
- Tennessee 8
- Wisconsin 8
- Colorado 7
- Louisiana 7
- Missouri 6
- Montana 5
- New Mexico 5
- Pennsylvania 5
- South Carolina 5
- Washington 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2440790 | 2440790 | 2022-04-24 | San Juan | Washington | 53055 | 1237 | 2 |
2437534 | 2437534 | 2022-04-23 | San Juan | Washington | 53055 | 1237 | 2 |
2434278 | 2434278 | 2022-04-22 | San Juan | Washington | 53055 | 1237 | 2 |
2352649 | 2352649 | 2022-03-28 | San Saba | Texas | 48411 | 1237 | 35 |
2349397 | 2349397 | 2022-03-27 | San Saba | Texas | 48411 | 1237 | 35 |
2346144 | 2346144 | 2022-03-26 | San Saba | Texas | 48411 | 1237 | 35 |
2342891 | 2342891 | 2022-03-25 | San Saba | Texas | 48411 | 1237 | 35 |
2339634 | 2339634 | 2022-03-24 | Sabine | Texas | 48403 | 1237 | 88 |
2339638 | 2339638 | 2022-03-24 | San Saba | Texas | 48411 | 1237 | 35 |
2336384 | 2336384 | 2022-03-23 | San Saba | Texas | 48411 | 1237 | 35 |
2333130 | 2333130 | 2022-03-22 | San Saba | Texas | 48411 | 1237 | 35 |
2328776 | 2328776 | 2022-03-21 | Morrill | Nebraska | 31123 | 1237 | 18 |
2329877 | 2329877 | 2022-03-21 | San Saba | Texas | 48411 | 1237 | 35 |
2326625 | 2326625 | 2022-03-20 | San Saba | Texas | 48411 | 1237 | 35 |
2323372 | 2323372 | 2022-03-19 | San Saba | Texas | 48411 | 1237 | 35 |
2319016 | 2319016 | 2022-03-18 | Morrill | Nebraska | 31123 | 1237 | 18 |
2320118 | 2320118 | 2022-03-18 | San Saba | Texas | 48411 | 1237 | 35 |
2315763 | 2315763 | 2022-03-17 | Morrill | Nebraska | 31123 | 1237 | 18 |
2316864 | 2316864 | 2022-03-17 | San Saba | Texas | 48411 | 1237 | 35 |
2312510 | 2312510 | 2022-03-16 | Morrill | Nebraska | 31123 | 1237 | 18 |
2309257 | 2309257 | 2022-03-15 | Morrill | Nebraska | 31123 | 1237 | 18 |
2307233 | 2307233 | 2022-03-14 | Cumberland | Virginia | 51049 | 1237 | 24 |
2303982 | 2303982 | 2022-03-13 | Cumberland | Virginia | 51049 | 1237 | 24 |
2300730 | 2300730 | 2022-03-12 | Cumberland | Virginia | 51049 | 1237 | 24 |
2297478 | 2297478 | 2022-03-11 | Cumberland | Virginia | 51049 | 1237 | 24 |
2292998 | 2292998 | 2022-03-10 | Morrill | Nebraska | 31123 | 1237 | 18 |
2294226 | 2294226 | 2022-03-10 | Cumberland | Virginia | 51049 | 1237 | 24 |
2262938 | 2262938 | 2022-03-01 | Kearny | Kansas | 20093 | 1237 | 20 |
2259687 | 2259687 | 2022-02-28 | Kearny | Kansas | 20093 | 1237 | 20 |
2247358 | 2247358 | 2022-02-24 | Broadwater | Montana | 30007 | 1237 | 18 |
2217068 | 2217068 | 2022-02-15 | Lemhi | Idaho | 16059 | 1237 | 25 |
2211642 | 2211642 | 2022-02-13 | Teton | Montana | 30099 | 1237 | 20 |
2208389 | 2208389 | 2022-02-12 | Teton | Montana | 30099 | 1237 | 20 |
2205136 | 2205136 | 2022-02-11 | Teton | Montana | 30099 | 1237 | 20 |
2197651 | 2197651 | 2022-02-09 | Scott | Illinois | 17171 | 1237 | 11 |
2194397 | 2194397 | 2022-02-08 | Scott | Illinois | 17171 | 1237 | 11 |
2196390 | 2196390 | 2022-02-08 | Crane | Texas | 48103 | 1237 | 21 |
2196498 | 2196498 | 2022-02-08 | McCulloch | Texas | 48307 | 1237 | 43 |
2175876 | 2175876 | 2022-02-02 | Burt | Nebraska | 31021 | 1237 | 15 |
2171924 | 2171924 | 2022-02-01 | Scott | Kansas | 20171 | 1237 | 33 |
2168671 | 2168671 | 2022-01-31 | Scott | Kansas | 20171 | 1237 | 33 |
2151690 | 2151690 | 2022-01-26 | Huerfano | Colorado | 8055 | 1237 | 28 |
2126699 | 2126699 | 2022-01-18 | Oscoda | Michigan | 26135 | 1237 | 51 |
2123447 | 2123447 | 2022-01-17 | Oscoda | Michigan | 26135 | 1237 | 51 |
2124607 | 2124607 | 2022-01-17 | Brule | South Dakota | 46015 | 1237 | 18 |
2120195 | 2120195 | 2022-01-16 | Oscoda | Michigan | 26135 | 1237 | 51 |
2121355 | 2121355 | 2022-01-16 | Brule | South Dakota | 46015 | 1237 | 18 |
2116943 | 2116943 | 2022-01-15 | Oscoda | Michigan | 26135 | 1237 | 51 |
2118103 | 2118103 | 2022-01-15 | Brule | South Dakota | 46015 | 1237 | 18 |
2113692 | 2113692 | 2022-01-14 | Oscoda | Michigan | 26135 | 1237 | 51 |
2114852 | 2114852 | 2022-01-14 | Brule | South Dakota | 46015 | 1237 | 18 |
2102570 | 2102570 | 2022-01-10 | Menominee | Wisconsin | 55078 | 1237 | 12 |
2075305 | 2075305 | 2022-01-02 | Gates | North Carolina | 37073 | 1237 | 18 |
2072054 | 2072054 | 2022-01-01 | Gates | North Carolina | 37073 | 1237 | 18 |
2068803 | 2068803 | 2021-12-31 | Gates | North Carolina | 37073 | 1237 | 18 |
2059990 | 2059990 | 2021-12-28 | Beaver | Utah | 49001 | 1237 | 14 |
2026953 | 2026953 | 2021-12-18 | Barceloneta | Puerto Rico | 72017 | 1237 | |
2018589 | 2018589 | 2021-12-16 | Lincoln | Georgia | 13181 | 1237 | 33 |
1993515 | 1993515 | 2021-12-08 | Wilkin | Minnesota | 27167 | 1237 | 16 |
1979263 | 1979263 | 2021-12-04 | Newton | Arkansas | 5101 | 1237 | 40 |
1972488 | 1972488 | 2021-12-01 | Pendleton | West Virginia | 54071 | 1237 | 15 |
1945180 | 1945180 | 2021-11-23 | Quay | New Mexico | 35037 | 1237 | 25 |
1939860 | 1939860 | 2021-11-21 | Northumberland | Virginia | 51133 | 1237 | 36 |
1936610 | 1936610 | 2021-11-20 | Northumberland | Virginia | 51133 | 1237 | 36 |
1933360 | 1933360 | 2021-11-19 | Northumberland | Virginia | 51133 | 1237 | 36 |
1930108 | 1930108 | 2021-11-18 | Northumberland | Virginia | 51133 | 1237 | 35 |
1921437 | 1921437 | 2021-11-16 | Ida | Iowa | 19093 | 1237 | 41 |
1921714 | 1921714 | 2021-11-16 | Wolfe | Kentucky | 21237 | 1237 | 12 |
1918187 | 1918187 | 2021-11-15 | Ida | Iowa | 19093 | 1237 | 41 |
1914937 | 1914937 | 2021-11-14 | Ida | Iowa | 19093 | 1237 | 41 |
1911687 | 1911687 | 2021-11-13 | Ida | Iowa | 19093 | 1237 | 41 |
1908438 | 1908438 | 2021-11-12 | Ida | Iowa | 19093 | 1237 | 41 |
1905189 | 1905189 | 2021-11-11 | Ida | Iowa | 19093 | 1237 | 41 |
1901939 | 1901939 | 2021-11-10 | Ida | Iowa | 19093 | 1237 | 41 |
1900233 | 1900233 | 2021-11-09 | Orocovis | Puerto Rico | 72107 | 1237 | |
1896983 | 1896983 | 2021-11-08 | Orocovis | Puerto Rico | 72107 | 1237 | |
1893733 | 1893733 | 2021-11-07 | Orocovis | Puerto Rico | 72107 | 1237 | |
1890483 | 1890483 | 2021-11-06 | Orocovis | Puerto Rico | 72107 | 1237 | |
1887233 | 1887233 | 2021-11-05 | Orocovis | Puerto Rico | 72107 | 1237 | |
1882122 | 1882122 | 2021-11-04 | Terrell | Georgia | 13273 | 1237 | 56 |
1882159 | 1882159 | 2021-11-04 | Benewah | Idaho | 16009 | 1237 | 26 |
1882387 | 1882387 | 2021-11-04 | Warren | Indiana | 18171 | 1237 | 18 |
1878873 | 1878873 | 2021-11-03 | Terrell | Georgia | 13273 | 1237 | 56 |
1877971 | 1877971 | 2021-11-02 | Winkler | Texas | 48495 | 1237 | 29 |
1874722 | 1874722 | 2021-11-01 | Winkler | Texas | 48495 | 1237 | 29 |
1851736 | 1851736 | 2021-10-25 | Archer | Texas | 48009 | 1237 | 19 |
1846387 | 1846387 | 2021-10-24 | Treutlen | Georgia | 13283 | 1237 | 48 |
1848486 | 1848486 | 2021-10-24 | Archer | Texas | 48009 | 1237 | 19 |
1843137 | 1843137 | 2021-10-23 | Treutlen | Georgia | 13283 | 1237 | 48 |
1845236 | 1845236 | 2021-10-23 | Archer | Texas | 48009 | 1237 | 19 |
1839887 | 1839887 | 2021-10-22 | Treutlen | Georgia | 13283 | 1237 | 48 |
1816788 | 1816788 | 2021-10-15 | Searcy | Arkansas | 5129 | 1237 | 24 |
1813540 | 1813540 | 2021-10-14 | Searcy | Arkansas | 5129 | 1237 | 24 |
1813061 | 1813061 | 2021-10-13 | Buena Vista city | Virginia | 51530 | 1237 | 23 |
1773134 | 1773134 | 2021-10-01 | Benson | North Dakota | 38005 | 1237 | 20 |
1759744 | 1759744 | 2021-09-27 | Beaverhead | Montana | 30001 | 1237 | 14 |
1746498 | 1746498 | 2021-09-23 | Koochiching | Minnesota | 27071 | 1237 | 19 |
1742433 | 1742433 | 2021-09-22 | Wilcox | Georgia | 13315 | 1237 | 51 |
1710392 | 1710392 | 2021-09-12 | Thomas | Kansas | 20193 | 1237 | 21 |
1707145 | 1707145 | 2021-09-11 | Thomas | Kansas | 20193 | 1237 | 21 |
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);