ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
947 rows where cases = 267 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 160
- Texas 56
- North Dakota 51
- Georgia 48
- South Dakota 42
- Virginia 39
- Kentucky 33
- Puerto Rico 30
- Missouri 27
- Montana 26
- Indiana 24
- Iowa 23
- Arkansas 22
- Nebraska 21
- Mississippi 20
- North Carolina 20
- Colorado 19
- Pennsylvania 19
- New York 18
- Ohio 18
- Illinois 17
- Minnesota 16
- California 15
- New Mexico 15
- Utah 14
- Alabama 13
- Idaho 13
- Michigan 13
- Oklahoma 12
- Tennessee 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491292 | 2491292 | 2022-05-10 | Unknown | Mississippi | 267 | 2 | |
2446686 | 2446686 | 2022-04-26 | Campbell | South Dakota | 46021 | 267 | 7 |
2443431 | 2443431 | 2022-04-25 | Campbell | South Dakota | 46021 | 267 | 7 |
2440175 | 2440175 | 2022-04-24 | Campbell | South Dakota | 46021 | 267 | 7 |
2436919 | 2436919 | 2022-04-23 | Campbell | South Dakota | 46021 | 267 | 7 |
2433663 | 2433663 | 2022-04-22 | Campbell | South Dakota | 46021 | 267 | 7 |
2430407 | 2430407 | 2022-04-21 | Campbell | South Dakota | 46021 | 267 | 7 |
2427151 | 2427151 | 2022-04-20 | Campbell | South Dakota | 46021 | 267 | 7 |
2423895 | 2423895 | 2022-04-19 | Campbell | South Dakota | 46021 | 267 | 7 |
2420639 | 2420639 | 2022-04-18 | Campbell | South Dakota | 46021 | 267 | 7 |
2417383 | 2417383 | 2022-04-17 | Campbell | South Dakota | 46021 | 267 | 7 |
2414127 | 2414127 | 2022-04-16 | Campbell | South Dakota | 46021 | 267 | 7 |
2410871 | 2410871 | 2022-04-15 | Campbell | South Dakota | 46021 | 267 | 7 |
2407615 | 2407615 | 2022-04-14 | Campbell | South Dakota | 46021 | 267 | 7 |
2404359 | 2404359 | 2022-04-13 | Campbell | South Dakota | 46021 | 267 | 7 |
2310376 | 2310376 | 2022-03-15 | Throckmorton | Texas | 48447 | 267 | 8 |
2307123 | 2307123 | 2022-03-14 | Throckmorton | Texas | 48447 | 267 | 8 |
2303872 | 2303872 | 2022-03-13 | Throckmorton | Texas | 48447 | 267 | 8 |
2300620 | 2300620 | 2022-03-12 | Throckmorton | Texas | 48447 | 267 | 8 |
2297368 | 2297368 | 2022-03-11 | Throckmorton | Texas | 48447 | 267 | 8 |
2294116 | 2294116 | 2022-03-10 | Throckmorton | Texas | 48447 | 267 | 8 |
2290864 | 2290864 | 2022-03-09 | Throckmorton | Texas | 48447 | 267 | 8 |
2287612 | 2287612 | 2022-03-08 | Throckmorton | Texas | 48447 | 267 | 8 |
2284360 | 2284360 | 2022-03-07 | Throckmorton | Texas | 48447 | 267 | 8 |
2225782 | 2225782 | 2022-02-17 | Motley | Texas | 48345 | 267 | 12 |
2222531 | 2222531 | 2022-02-16 | Motley | Texas | 48345 | 267 | 12 |
2169737 | 2169737 | 2022-01-31 | Sheridan | North Dakota | 38083 | 267 | 6 |
2166482 | 2166482 | 2022-01-30 | Sheridan | North Dakota | 38083 | 267 | 6 |
2163227 | 2163227 | 2022-01-29 | Sheridan | North Dakota | 38083 | 267 | 6 |
2157347 | 2157347 | 2022-01-27 | Cottle | Texas | 48101 | 267 | 9 |
2154094 | 2154094 | 2022-01-26 | Cottle | Texas | 48101 | 267 | 9 |
2150842 | 2150842 | 2022-01-25 | Cottle | Texas | 48101 | 267 | 9 |
2147411 | 2147411 | 2022-01-24 | Hyde | South Dakota | 46069 | 267 | 5 |
2147590 | 2147590 | 2022-01-24 | Cottle | Texas | 48101 | 267 | 9 |
2125620 | 2125620 | 2022-01-18 | Sierra | California | 6091 | 267 | 0 |
2115224 | 2115224 | 2022-01-14 | Stonewall | Texas | 48433 | 267 | 6 |
2009997 | 2009997 | 2021-12-13 | Liberty | Montana | 30051 | 267 | 2 |
2006746 | 2006746 | 2021-12-12 | Liberty | Montana | 30051 | 267 | 2 |
2003495 | 2003495 | 2021-12-11 | Liberty | Montana | 30051 | 267 | 2 |
2000245 | 2000245 | 2021-12-10 | Liberty | Montana | 30051 | 267 | 2 |
1996994 | 1996994 | 2021-12-09 | Liberty | Montana | 30051 | 267 | 2 |
1998043 | 1998043 | 2021-12-09 | Dickens | Texas | 48125 | 267 | 14 |
1993919 | 1993919 | 2021-12-08 | Catron | New Mexico | 35003 | 267 | 8 |
1990668 | 1990668 | 2021-12-07 | Catron | New Mexico | 35003 | 267 | 8 |
1987242 | 1987242 | 2021-12-06 | Liberty | Montana | 30051 | 267 | 2 |
1987301 | 1987301 | 2021-12-06 | Dundy | Nebraska | 31057 | 267 | 5 |
1987418 | 1987418 | 2021-12-06 | Catron | New Mexico | 35003 | 267 | 8 |
1983992 | 1983992 | 2021-12-05 | Liberty | Montana | 30051 | 267 | 2 |
1984168 | 1984168 | 2021-12-05 | Catron | New Mexico | 35003 | 267 | 8 |
1980742 | 1980742 | 2021-12-04 | Liberty | Montana | 30051 | 267 | 2 |
1980918 | 1980918 | 2021-12-04 | Catron | New Mexico | 35003 | 267 | 8 |
1977492 | 1977492 | 2021-12-03 | Liberty | Montana | 30051 | 267 | 2 |
1977668 | 1977668 | 2021-12-03 | Catron | New Mexico | 35003 | 267 | 8 |
1974242 | 1974242 | 2021-12-02 | Liberty | Montana | 30051 | 267 | 2 |
1970993 | 1970993 | 2021-12-01 | Liberty | Montana | 30051 | 267 | 2 |
1964464 | 1964464 | 2021-11-29 | Worth | Missouri | 29227 | 267 | 2 |
1952743 | 1952743 | 2021-11-25 | Rich | Utah | 49033 | 267 | 0 |
1949492 | 1949492 | 2021-11-24 | Rich | Utah | 49033 | 267 | 0 |
1946241 | 1946241 | 2021-11-23 | Rich | Utah | 49033 | 267 | 0 |
1943002 | 1943002 | 2021-11-22 | Wayne | Utah | 49055 | 267 | 0 |
1928737 | 1928737 | 2021-11-18 | Meagher | Montana | 30059 | 267 | 9 |
1929989 | 1929989 | 2021-11-18 | Rich | Utah | 49033 | 267 | 0 |
1925487 | 1925487 | 2021-11-17 | Meagher | Montana | 30059 | 267 | 9 |
1920240 | 1920240 | 2021-11-15 | Rich | Utah | 49033 | 267 | 0 |
1915762 | 1915762 | 2021-11-14 | Wheatland | Montana | 30107 | 267 | 13 |
1916990 | 1916990 | 2021-11-14 | Rich | Utah | 49033 | 267 | 0 |
1912512 | 1912512 | 2021-11-13 | Wheatland | Montana | 30107 | 267 | 13 |
1913740 | 1913740 | 2021-11-13 | Rich | Utah | 49033 | 267 | 0 |
1909262 | 1909262 | 2021-11-12 | Wheatland | Montana | 30107 | 267 | 13 |
1910490 | 1910490 | 2021-11-12 | Rich | Utah | 49033 | 267 | 0 |
1906013 | 1906013 | 2021-11-11 | Wheatland | Montana | 30107 | 267 | 13 |
1907241 | 1907241 | 2021-11-11 | Rich | Utah | 49033 | 267 | 0 |
1902764 | 1902764 | 2021-11-10 | Wheatland | Montana | 30107 | 267 | 13 |
1903992 | 1903992 | 2021-11-10 | Rich | Utah | 49033 | 267 | 0 |
1898389 | 1898389 | 2021-11-09 | Webster | Georgia | 13307 | 267 | 6 |
1899189 | 1899189 | 2021-11-09 | Cook | Minnesota | 27031 | 267 | 0 |
1900742 | 1900742 | 2021-11-09 | Rich | Utah | 49033 | 267 | 0 |
1896302 | 1896302 | 2021-11-08 | Garfield | Nebraska | 31071 | 267 | 2 |
1860497 | 1860497 | 2021-10-28 | McCone | Montana | 30055 | 267 | 3 |
1850750 | 1850750 | 2021-10-25 | McCone | Montana | 30055 | 267 | 3 |
1819021 | 1819021 | 2021-10-15 | Vieques | Puerto Rico | 72147 | 267 | |
1815772 | 1815772 | 2021-10-14 | Vieques | Puerto Rico | 72147 | 267 | |
1805677 | 1805677 | 2021-10-11 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1800453 | 1800453 | 2021-10-10 | Petersburg Borough | Alaska | 2195 | 267 | 2 |
1802428 | 1802428 | 2021-10-10 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1797204 | 1797204 | 2021-10-09 | Petersburg Borough | Alaska | 2195 | 267 | 2 |
1799179 | 1799179 | 2021-10-09 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1793955 | 1793955 | 2021-10-08 | Petersburg Borough | Alaska | 2195 | 267 | 2 |
1795930 | 1795930 | 2021-10-08 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1792681 | 1792681 | 2021-10-07 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1789432 | 1789432 | 2021-10-06 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1763402 | 1763402 | 2021-09-28 | Grant | North Dakota | 38037 | 267 | 7 |
1735957 | 1735957 | 2021-09-20 | Butte | Idaho | 16023 | 267 | 1 |
1732707 | 1732707 | 2021-09-19 | Butte | Idaho | 16023 | 267 | 1 |
1729457 | 1729457 | 2021-09-18 | Butte | Idaho | 16023 | 267 | 1 |
1726207 | 1726207 | 2021-09-17 | Butte | Idaho | 16023 | 267 | 1 |
1727650 | 1727650 | 2021-09-17 | Burke | North Dakota | 38013 | 267 | 3 |
1722460 | 1722460 | 2021-09-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 267 | 0 |
1724401 | 1724401 | 2021-09-16 | Burke | North Dakota | 38013 | 267 | 3 |
1679824 | 1679824 | 2021-09-02 | Grand Isle | Vermont | 50013 | 267 | 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);