ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
821 rows where cases = 375 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 46
- South Dakota 96
- Texas 91
- Kansas 49
- Georgia 43
- Virginia 34
- Nebraska 33
- Puerto Rico 31
- Iowa 30
- Minnesota 28
- Missouri 24
- Kentucky 23
- Idaho 22
- Louisiana 20
- Mississippi 19
- North Dakota 19
- Alaska 17
- Colorado 17
- North Carolina 16
- Illinois 15
- Michigan 15
- West Virginia 15
- Indiana 14
- Oklahoma 14
- Arkansas 13
- New Mexico 13
- Tennessee 12
- Washington 12
- Wisconsin 11
- Montana 10
- Alabama 9
- New York 8
- Florida 7
- Ohio 5
- Nevada 4
- New Hampshire 4
- Oregon 4
- Vermont 4
- Wyoming 4
- Pennsylvania 3
- Utah 3
- California 2
- Connecticut 2
- Maine 2
- South Carolina 2
- Maryland 1
- New Jersey 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463482 | 2463482 | 2022-05-01 | Highland | Virginia | 51091 | 375 | 7 |
2460226 | 2460226 | 2022-04-30 | Highland | Virginia | 51091 | 375 | 7 |
2456970 | 2456970 | 2022-04-29 | Highland | Virginia | 51091 | 375 | 7 |
2325504 | 2325504 | 2022-03-20 | Harlan | Nebraska | 31083 | 375 | 3 |
2322250 | 2322250 | 2022-03-19 | Harlan | Nebraska | 31083 | 375 | 3 |
2318996 | 2318996 | 2022-03-18 | Harlan | Nebraska | 31083 | 375 | 3 |
2315743 | 2315743 | 2022-03-17 | Harlan | Nebraska | 31083 | 375 | 3 |
2312490 | 2312490 | 2022-03-16 | Harlan | Nebraska | 31083 | 375 | 3 |
2309237 | 2309237 | 2022-03-15 | Harlan | Nebraska | 31083 | 375 | 3 |
2305985 | 2305985 | 2022-03-14 | Harlan | Nebraska | 31083 | 375 | 3 |
2302734 | 2302734 | 2022-03-13 | Harlan | Nebraska | 31083 | 375 | 3 |
2299482 | 2299482 | 2022-03-12 | Harlan | Nebraska | 31083 | 375 | 3 |
2296230 | 2296230 | 2022-03-11 | Harlan | Nebraska | 31083 | 375 | 3 |
2292978 | 2292978 | 2022-03-10 | Harlan | Nebraska | 31083 | 375 | 3 |
2289726 | 2289726 | 2022-03-09 | Harlan | Nebraska | 31083 | 375 | 2 |
2286474 | 2286474 | 2022-03-08 | Harlan | Nebraska | 31083 | 375 | 2 |
2283222 | 2283222 | 2022-03-07 | Harlan | Nebraska | 31083 | 375 | 2 |
2245812 | 2245812 | 2022-02-24 | Denali Borough | Alaska | 2068 | 375 | 1 |
2242561 | 2242561 | 2022-02-23 | Denali Borough | Alaska | 2068 | 375 | 1 |
2239310 | 2239310 | 2022-02-22 | Denali Borough | Alaska | 2068 | 375 | 1 |
2236059 | 2236059 | 2022-02-21 | Denali Borough | Alaska | 2068 | 375 | 1 |
2232808 | 2232808 | 2022-02-20 | Denali Borough | Alaska | 2068 | 375 | 1 |
2229557 | 2229557 | 2022-02-19 | Denali Borough | Alaska | 2068 | 375 | 1 |
2226306 | 2226306 | 2022-02-18 | Denali Borough | Alaska | 2068 | 375 | 1 |
2223055 | 2223055 | 2022-02-17 | Denali Borough | Alaska | 2068 | 375 | 1 |
2224651 | 2224651 | 2022-02-17 | Wheatland | Montana | 30107 | 375 | 14 |
2226056 | 2226056 | 2022-02-17 | Garfield | Washington | 53023 | 375 | 7 |
2219804 | 2219804 | 2022-02-16 | Denali Borough | Alaska | 2068 | 375 | 1 |
2222805 | 2222805 | 2022-02-16 | Garfield | Washington | 53023 | 375 | 7 |
2201859 | 2201859 | 2022-02-10 | Liberty | Montana | 30051 | 375 | 2 |
2198643 | 2198643 | 2022-02-09 | Boyd | Nebraska | 31015 | 375 | 6 |
2195354 | 2195354 | 2022-02-08 | McCone | Montana | 30055 | 375 | 9 |
2192100 | 2192100 | 2022-02-07 | McCone | Montana | 30055 | 375 | 9 |
2192169 | 2192169 | 2022-02-07 | Harlan | Nebraska | 31083 | 375 | 2 |
2188916 | 2188916 | 2022-02-06 | Harlan | Nebraska | 31083 | 375 | 2 |
2185663 | 2185663 | 2022-02-05 | Harlan | Nebraska | 31083 | 375 | 2 |
2182411 | 2182411 | 2022-02-04 | Harlan | Nebraska | 31083 | 375 | 2 |
2179159 | 2179159 | 2022-02-03 | Harlan | Nebraska | 31083 | 375 | 2 |
2176247 | 2176247 | 2022-02-02 | Steele | North Dakota | 38091 | 375 | 2 |
2156486 | 2156486 | 2022-01-27 | Catron | New Mexico | 35003 | 375 | 13 |
2153030 | 2153030 | 2022-01-26 | Worth | Missouri | 29227 | 375 | 3 |
2153126 | 2153126 | 2022-01-26 | Greeley | Nebraska | 31077 | 375 | 2 |
2143359 | 2143359 | 2022-01-23 | Franklin | Nebraska | 31061 | 375 | 8 |
2140104 | 2140104 | 2022-01-22 | Franklin | Nebraska | 31061 | 375 | 8 |
2136848 | 2136848 | 2022-01-21 | Franklin | Nebraska | 31061 | 375 | 8 |
2133596 | 2133596 | 2022-01-20 | Franklin | Nebraska | 31061 | 375 | 8 |
2126378 | 2126378 | 2022-01-18 | Stanton | Kansas | 20187 | 375 | 7 |
2123126 | 2123126 | 2022-01-17 | Stanton | Kansas | 20187 | 375 | 7 |
2119874 | 2119874 | 2022-01-16 | Stanton | Kansas | 20187 | 375 | 7 |
2116622 | 2116622 | 2022-01-15 | Stanton | Kansas | 20187 | 375 | 7 |
2113371 | 2113371 | 2022-01-14 | Stanton | Kansas | 20187 | 375 | 7 |
2111638 | 2111638 | 2022-01-13 | McPherson | South Dakota | 46089 | 375 | 9 |
2079124 | 2079124 | 2022-01-03 | Mellette | South Dakota | 46095 | 375 | 4 |
2059942 | 2059942 | 2021-12-28 | Schleicher | Texas | 48413 | 375 | 9 |
2035292 | 2035292 | 2021-12-21 | Graham | Kansas | 20065 | 375 | 12 |
2032042 | 2032042 | 2021-12-20 | Graham | Kansas | 20065 | 375 | 12 |
2028256 | 2028256 | 2021-12-19 | Baker | Georgia | 13007 | 375 | 14 |
2025005 | 2025005 | 2021-12-18 | Baker | Georgia | 13007 | 375 | 14 |
2021754 | 2021754 | 2021-12-17 | Baker | Georgia | 13007 | 375 | 14 |
2016680 | 2016680 | 2021-12-15 | De Baca | New Mexico | 35011 | 375 | 3 |
2012002 | 2012002 | 2021-12-14 | Baker | Georgia | 13007 | 375 | 14 |
2008751 | 2008751 | 2021-12-13 | Baker | Georgia | 13007 | 375 | 14 |
2005500 | 2005500 | 2021-12-12 | Baker | Georgia | 13007 | 375 | 14 |
2002249 | 2002249 | 2021-12-11 | Baker | Georgia | 13007 | 375 | 14 |
1998999 | 1998999 | 2021-12-10 | Baker | Georgia | 13007 | 375 | 14 |
1996275 | 1996275 | 2021-12-09 | Elk | Kansas | 20049 | 375 | 6 |
1992497 | 1992497 | 2021-12-08 | Baker | Georgia | 13007 | 375 | 14 |
1993024 | 1993024 | 2021-12-08 | Elk | Kansas | 20049 | 375 | 6 |
1989246 | 1989246 | 2021-12-07 | Baker | Georgia | 13007 | 375 | 14 |
1985996 | 1985996 | 2021-12-06 | Baker | Georgia | 13007 | 375 | 14 |
1982746 | 1982746 | 2021-12-05 | Baker | Georgia | 13007 | 375 | 14 |
1983637 | 1983637 | 2021-12-05 | Keweenaw | Michigan | 26083 | 375 | 9 |
1979496 | 1979496 | 2021-12-04 | Baker | Georgia | 13007 | 375 | 14 |
1980387 | 1980387 | 2021-12-04 | Keweenaw | Michigan | 26083 | 375 | 9 |
1976246 | 1976246 | 2021-12-03 | Baker | Georgia | 13007 | 375 | 14 |
1977137 | 1977137 | 2021-12-03 | Keweenaw | Michigan | 26083 | 375 | 9 |
1972997 | 1972997 | 2021-12-02 | Baker | Georgia | 13007 | 375 | 14 |
1964874 | 1964874 | 2021-11-29 | Golden Valley | North Dakota | 38033 | 375 | 4 |
1961622 | 1961622 | 2021-11-28 | Golden Valley | North Dakota | 38033 | 375 | 4 |
1962405 | 1962405 | 2021-11-28 | Oldham | Texas | 48359 | 375 | 6 |
1958371 | 1958371 | 2021-11-27 | Golden Valley | North Dakota | 38033 | 375 | 4 |
1959154 | 1959154 | 2021-11-27 | Oldham | Texas | 48359 | 375 | 6 |
1955120 | 1955120 | 2021-11-26 | Golden Valley | North Dakota | 38033 | 375 | 4 |
1955903 | 1955903 | 2021-11-26 | Oldham | Texas | 48359 | 375 | 6 |
1951869 | 1951869 | 2021-11-25 | Golden Valley | North Dakota | 38033 | 375 | 4 |
1952652 | 1952652 | 2021-11-25 | Oldham | Texas | 48359 | 375 | 6 |
1948618 | 1948618 | 2021-11-24 | Golden Valley | North Dakota | 38033 | 375 | 4 |
1949401 | 1949401 | 2021-11-24 | Oldham | Texas | 48359 | 375 | 6 |
1945367 | 1945367 | 2021-11-23 | Golden Valley | North Dakota | 38033 | 375 | 4 |
1946150 | 1946150 | 2021-11-23 | Oldham | Texas | 48359 | 375 | 6 |
1942899 | 1942899 | 2021-11-22 | Oldham | Texas | 48359 | 375 | 6 |
1939649 | 1939649 | 2021-11-21 | Oldham | Texas | 48359 | 375 | 6 |
1936399 | 1936399 | 2021-11-20 | Oldham | Texas | 48359 | 375 | 6 |
1930912 | 1930912 | 2021-11-19 | Butte | Idaho | 16023 | 375 | 4 |
1927662 | 1927662 | 2021-11-18 | Butte | Idaho | 16023 | 375 | 4 |
1924412 | 1924412 | 2021-11-17 | Butte | Idaho | 16023 | 375 | 4 |
1921163 | 1921163 | 2021-11-16 | Butte | Idaho | 16023 | 375 | 4 |
1917913 | 1917913 | 2021-11-15 | Butte | Idaho | 16023 | 375 | 4 |
1919023 | 1919023 | 2021-11-15 | Brown | Nebraska | 31017 | 375 | 4 |
1913760 | 1913760 | 2021-11-13 | Grand Isle | Vermont | 50013 | 375 | 2 |
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);