ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
960 rows where cases = 257 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 115
- Kansas 46
- South Dakota 46
- North Dakota 45
- Georgia 44
- Nebraska 44
- Idaho 42
- Kentucky 38
- Michigan 37
- Virginia 37
- Ohio 31
- New York 30
- Mississippi 27
- North Carolina 21
- Pennsylvania 21
- Illinois 19
- Missouri 19
- Oklahoma 19
- Alabama 17
- Arkansas 17
- California 17
- Indiana 17
- Iowa 17
- Louisiana 17
- Puerto Rico 17
- Washington 15
- Alaska 14
- Colorado 14
- Minnesota 13
- Wisconsin 13
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217924 | 2217924 | 2022-02-15 | Issaquena | Mississippi | 28055 | 257 | 9 |
2214673 | 2214673 | 2022-02-14 | Issaquena | Mississippi | 28055 | 257 | 9 |
2215704 | 2215704 | 2022-02-14 | Campbell | South Dakota | 46021 | 257 | 7 |
2211421 | 2211421 | 2022-02-13 | Issaquena | Mississippi | 28055 | 257 | 9 |
2212453 | 2212453 | 2022-02-13 | Campbell | South Dakota | 46021 | 257 | 7 |
2208168 | 2208168 | 2022-02-12 | Issaquena | Mississippi | 28055 | 257 | 9 |
2209200 | 2209200 | 2022-02-12 | Campbell | South Dakota | 46021 | 257 | 7 |
2204915 | 2204915 | 2022-02-11 | Issaquena | Mississippi | 28055 | 257 | 9 |
2205947 | 2205947 | 2022-02-11 | Campbell | South Dakota | 46021 | 257 | 7 |
2201662 | 2201662 | 2022-02-10 | Issaquena | Mississippi | 28055 | 257 | 9 |
2201873 | 2201873 | 2022-02-10 | Prairie | Montana | 30079 | 257 | 3 |
2202694 | 2202694 | 2022-02-10 | Campbell | South Dakota | 46021 | 257 | 7 |
2189678 | 2189678 | 2022-02-06 | Campbell | South Dakota | 46021 | 257 | 7 |
2186425 | 2186425 | 2022-02-05 | Campbell | South Dakota | 46021 | 257 | 7 |
2183173 | 2183173 | 2022-02-04 | Campbell | South Dakota | 46021 | 257 | 7 |
2179921 | 2179921 | 2022-02-03 | Campbell | South Dakota | 46021 | 257 | 7 |
2174716 | 2174716 | 2022-02-02 | Taliaferro | Georgia | 13265 | 257 | 3 |
2153464 | 2153464 | 2022-01-26 | Sheridan | North Dakota | 38083 | 257 | 6 |
2132842 | 2132842 | 2022-01-20 | Lane | Kansas | 20101 | 257 | 10 |
2134392 | 2134392 | 2022-01-20 | Hyde | South Dakota | 46069 | 257 | 5 |
2129589 | 2129589 | 2022-01-19 | Lane | Kansas | 20101 | 257 | 10 |
2131140 | 2131140 | 2022-01-19 | Hyde | South Dakota | 46069 | 257 | 5 |
2119116 | 2119116 | 2022-01-16 | Sierra | California | 6091 | 257 | 0 |
2115864 | 2115864 | 2022-01-15 | Sierra | California | 6091 | 257 | 0 |
2112613 | 2112613 | 2022-01-14 | Sierra | California | 6091 | 257 | 0 |
2097896 | 2097896 | 2022-01-09 | Eureka | Nevada | 32011 | 257 | 1 |
2094644 | 2094644 | 2022-01-08 | Eureka | Nevada | 32011 | 257 | 1 |
2091392 | 2091392 | 2022-01-07 | Eureka | Nevada | 32011 | 257 | 1 |
2092297 | 2092297 | 2022-01-07 | Cottle | Texas | 48101 | 257 | 9 |
2088141 | 2088141 | 2022-01-06 | Eureka | Nevada | 32011 | 257 | 1 |
2089045 | 2089045 | 2022-01-06 | Cottle | Texas | 48101 | 257 | 9 |
2084889 | 2084889 | 2022-01-05 | Eureka | Nevada | 32011 | 257 | 1 |
2085794 | 2085794 | 2022-01-05 | Cottle | Texas | 48101 | 257 | 9 |
2082542 | 2082542 | 2022-01-04 | Cottle | Texas | 48101 | 257 | 9 |
2079290 | 2079290 | 2022-01-03 | Cottle | Texas | 48101 | 257 | 9 |
2075058 | 2075058 | 2022-01-02 | Deuel | Nebraska | 31049 | 257 | 2 |
2076039 | 2076039 | 2022-01-02 | Cottle | Texas | 48101 | 257 | 9 |
2071807 | 2071807 | 2022-01-01 | Deuel | Nebraska | 31049 | 257 | 2 |
2072788 | 2072788 | 2022-01-01 | Cottle | Texas | 48101 | 257 | 9 |
2068556 | 2068556 | 2021-12-31 | Deuel | Nebraska | 31049 | 257 | 2 |
2069537 | 2069537 | 2021-12-31 | Cottle | Texas | 48101 | 257 | 9 |
2065305 | 2065305 | 2021-12-30 | Deuel | Nebraska | 31049 | 257 | 2 |
2065648 | 2065648 | 2021-12-30 | Oliver | North Dakota | 38065 | 257 | 4 |
2066286 | 2066286 | 2021-12-30 | Cottle | Texas | 48101 | 257 | 9 |
2062055 | 2062055 | 2021-12-29 | Deuel | Nebraska | 31049 | 257 | 2 |
2063036 | 2063036 | 2021-12-29 | Cottle | Texas | 48101 | 257 | 9 |
2059786 | 2059786 | 2021-12-28 | Cottle | Texas | 48101 | 257 | 9 |
2056537 | 2056537 | 2021-12-27 | Cottle | Texas | 48101 | 257 | 9 |
2053288 | 2053288 | 2021-12-26 | Cottle | Texas | 48101 | 257 | 9 |
2050038 | 2050038 | 2021-12-25 | Cottle | Texas | 48101 | 257 | 9 |
2046788 | 2046788 | 2021-12-24 | Cottle | Texas | 48101 | 257 | 9 |
2043538 | 2043538 | 2021-12-23 | Cottle | Texas | 48101 | 257 | 9 |
2040289 | 2040289 | 2021-12-22 | Cottle | Texas | 48101 | 257 | 9 |
2037039 | 2037039 | 2021-12-21 | Cottle | Texas | 48101 | 257 | 9 |
2033789 | 2033789 | 2021-12-20 | Cottle | Texas | 48101 | 257 | 9 |
2029567 | 2029567 | 2021-12-19 | Garden | Nebraska | 31069 | 257 | 1 |
2030539 | 2030539 | 2021-12-19 | Cottle | Texas | 48101 | 257 | 9 |
2026316 | 2026316 | 2021-12-18 | Garden | Nebraska | 31069 | 257 | 1 |
2027288 | 2027288 | 2021-12-18 | Cottle | Texas | 48101 | 257 | 9 |
2023065 | 2023065 | 2021-12-17 | Garden | Nebraska | 31069 | 257 | 1 |
2024037 | 2024037 | 2021-12-17 | Cottle | Texas | 48101 | 257 | 9 |
2010062 | 2010062 | 2021-12-13 | Garden | Nebraska | 31069 | 257 | 1 |
2001253 | 2001253 | 2021-12-10 | Briscoe | Texas | 48045 | 257 | 7 |
1998003 | 1998003 | 2021-12-09 | Briscoe | Texas | 48045 | 257 | 7 |
1966365 | 1966365 | 2021-11-30 | Dolores | Colorado | 8033 | 257 | 5 |
1967041 | 1967041 | 2021-11-30 | Hodgeman | Kansas | 20083 | 257 | 10 |
1963789 | 1963789 | 2021-11-29 | Hodgeman | Kansas | 20083 | 257 | 10 |
1965925 | 1965925 | 2021-11-29 | Garfield | Washington | 53023 | 257 | 7 |
1962673 | 1962673 | 2021-11-28 | Garfield | Washington | 53023 | 257 | 7 |
1959422 | 1959422 | 2021-11-27 | Garfield | Washington | 53023 | 257 | 7 |
1956171 | 1956171 | 2021-11-26 | Garfield | Washington | 53023 | 257 | 7 |
1952920 | 1952920 | 2021-11-25 | Garfield | Washington | 53023 | 257 | 7 |
1949669 | 1949669 | 2021-11-24 | Garfield | Washington | 53023 | 257 | 7 |
1945044 | 1945044 | 2021-11-23 | Dundy | Nebraska | 31057 | 257 | 4 |
1942782 | 1942782 | 2021-11-22 | Dickens | Texas | 48125 | 257 | 13 |
1937121 | 1937121 | 2021-11-21 | Kiowa | Colorado | 8061 | 257 | 4 |
1939532 | 1939532 | 2021-11-21 | Dickens | Texas | 48125 | 257 | 13 |
1933871 | 1933871 | 2021-11-20 | Kiowa | Colorado | 8061 | 257 | 4 |
1936282 | 1936282 | 2021-11-20 | Dickens | Texas | 48125 | 257 | 13 |
1930619 | 1930619 | 2021-11-19 | Kiowa | Colorado | 8061 | 257 | 4 |
1933032 | 1933032 | 2021-11-19 | Dickens | Texas | 48125 | 257 | 13 |
1891439 | 1891439 | 2021-11-07 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 257 | 2 |
1888189 | 1888189 | 2021-11-06 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 257 | 2 |
1884939 | 1884939 | 2021-11-05 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 257 | 2 |
1882105 | 1882105 | 2021-11-04 | Quitman | Georgia | 13239 | 257 | 4 |
1880169 | 1880169 | 2021-11-03 | De Baca | New Mexico | 35011 | 257 | 3 |
1873494 | 1873494 | 2021-11-01 | Meagher | Montana | 30059 | 257 | 8 |
1864154 | 1864154 | 2021-10-29 | Steele | North Dakota | 38091 | 257 | 2 |
1850747 | 1850747 | 2021-10-25 | Liberty | Montana | 30051 | 257 | 1 |
1834502 | 1834502 | 2021-10-20 | McCone | Montana | 30055 | 257 | 2 |
1834876 | 1834876 | 2021-10-20 | Divide | North Dakota | 38023 | 257 | 2 |
1830153 | 1830153 | 2021-10-19 | Webster | Georgia | 13307 | 257 | 6 |
1831627 | 1831627 | 2021-10-19 | Divide | North Dakota | 38023 | 257 | 2 |
1828378 | 1828378 | 2021-10-18 | Divide | North Dakota | 38023 | 257 | 2 |
1825129 | 1825129 | 2021-10-17 | Divide | North Dakota | 38023 | 257 | 2 |
1789084 | 1789084 | 2021-10-06 | Harlan | Nebraska | 31083 | 257 | 0 |
1780960 | 1780960 | 2021-10-04 | Petersburg Borough | Alaska | 2195 | 257 | 2 |
1778546 | 1778546 | 2021-10-03 | Elk | Kansas | 20049 | 257 | 6 |
1775296 | 1775296 | 2021-10-02 | Elk | Kansas | 20049 | 257 | 6 |
1772046 | 1772046 | 2021-10-01 | Elk | Kansas | 20049 | 257 | 6 |
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);