ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
852 rows where cases = 260 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 87
- Texas 82
- Georgia 60
- Puerto Rico 42
- North Dakota 41
- Virginia 38
- Kansas 30
- Missouri 29
- Nebraska 28
- New York 28
- Michigan 23
- Ohio 22
- Kentucky 21
- Mississippi 21
- Montana 21
- Arkansas 19
- Iowa 19
- Illinois 16
- Indiana 16
- Colorado 15
- Minnesota 15
- Pennsylvania 13
- Alabama 12
- West Virginia 12
- Nevada 11
- Tennessee 11
- Louisiana 10
- North Carolina 10
- Oklahoma 10
- Washington 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2260187 | 2260187 | 2022-02-28 | Issaquena | Mississippi | 28055 | 260 | 9 |
2256936 | 2256936 | 2022-02-27 | Issaquena | Mississippi | 28055 | 260 | 9 |
2253685 | 2253685 | 2022-02-26 | Issaquena | Mississippi | 28055 | 260 | 9 |
2250434 | 2250434 | 2022-02-25 | Issaquena | Mississippi | 28055 | 260 | 9 |
2247183 | 2247183 | 2022-02-24 | Issaquena | Mississippi | 28055 | 260 | 9 |
2243932 | 2243932 | 2022-02-23 | Issaquena | Mississippi | 28055 | 260 | 9 |
2240681 | 2240681 | 2022-02-22 | Issaquena | Mississippi | 28055 | 260 | 9 |
2237430 | 2237430 | 2022-02-21 | Issaquena | Mississippi | 28055 | 260 | 9 |
2237641 | 2237641 | 2022-02-21 | Prairie | Montana | 30079 | 260 | 3 |
2234179 | 2234179 | 2022-02-20 | Issaquena | Mississippi | 28055 | 260 | 9 |
2234390 | 2234390 | 2022-02-20 | Prairie | Montana | 30079 | 260 | 3 |
2230928 | 2230928 | 2022-02-19 | Issaquena | Mississippi | 28055 | 260 | 9 |
2231139 | 2231139 | 2022-02-19 | Prairie | Montana | 30079 | 260 | 3 |
2227677 | 2227677 | 2022-02-18 | Issaquena | Mississippi | 28055 | 260 | 9 |
2227888 | 2227888 | 2022-02-18 | Prairie | Montana | 30079 | 260 | 3 |
2224426 | 2224426 | 2022-02-17 | Issaquena | Mississippi | 28055 | 260 | 9 |
2224637 | 2224637 | 2022-02-17 | Prairie | Montana | 30079 | 260 | 3 |
2222206 | 2222206 | 2022-02-16 | Campbell | South Dakota | 46021 | 260 | 7 |
2218955 | 2218955 | 2022-02-15 | Campbell | South Dakota | 46021 | 260 | 7 |
2197486 | 2197486 | 2022-02-09 | Taliaferro | Georgia | 13265 | 260 | 3 |
2194232 | 2194232 | 2022-02-08 | Taliaferro | Georgia | 13265 | 260 | 3 |
2187725 | 2187725 | 2022-02-06 | Taliaferro | Georgia | 13265 | 260 | 3 |
2184472 | 2184472 | 2022-02-05 | Taliaferro | Georgia | 13265 | 260 | 3 |
2181220 | 2181220 | 2022-02-04 | Taliaferro | Georgia | 13265 | 260 | 3 |
2177969 | 2177969 | 2022-02-03 | Taliaferro | Georgia | 13265 | 260 | 3 |
2142605 | 2142605 | 2022-01-23 | Lane | Kansas | 20101 | 260 | 10 |
2139350 | 2139350 | 2022-01-22 | Lane | Kansas | 20101 | 260 | 10 |
2136094 | 2136094 | 2022-01-21 | Lane | Kansas | 20101 | 260 | 10 |
2121561 | 2121561 | 2022-01-16 | Cottle | Texas | 48101 | 260 | 9 |
2085156 | 2085156 | 2022-01-05 | Oliver | North Dakota | 38065 | 260 | 4 |
2078309 | 2078309 | 2022-01-03 | Deuel | Nebraska | 31049 | 260 | 2 |
2051120 | 2051120 | 2021-12-26 | Quitman | Georgia | 13239 | 260 | 4 |
2047870 | 2047870 | 2021-12-25 | Quitman | Georgia | 13239 | 260 | 4 |
2044620 | 2044620 | 2021-12-24 | Quitman | Georgia | 13239 | 260 | 4 |
2041371 | 2041371 | 2021-12-23 | Quitman | Georgia | 13239 | 260 | 4 |
2040261 | 2040261 | 2021-12-22 | Briscoe | Texas | 48045 | 260 | 7 |
2032818 | 2032818 | 2021-12-20 | Garden | Nebraska | 31069 | 260 | 1 |
1985424 | 1985424 | 2021-12-05 | Garfield | Washington | 53023 | 260 | 7 |
1982174 | 1982174 | 2021-12-04 | Garfield | Washington | 53023 | 260 | 7 |
1978924 | 1978924 | 2021-12-03 | Garfield | Washington | 53023 | 260 | 7 |
1965540 | 1965540 | 2021-11-29 | Dickens | Texas | 48125 | 260 | 13 |
1961299 | 1961299 | 2021-11-28 | Dundy | Nebraska | 31057 | 260 | 5 |
1958048 | 1958048 | 2021-11-27 | Dundy | Nebraska | 31057 | 260 | 5 |
1954797 | 1954797 | 2021-11-26 | Dundy | Nebraska | 31057 | 260 | 5 |
1951546 | 1951546 | 2021-11-25 | Dundy | Nebraska | 31057 | 260 | 4 |
1948295 | 1948295 | 2021-11-24 | Dundy | Nebraska | 31057 | 260 | 4 |
1943621 | 1943621 | 2021-11-23 | Kiowa | Colorado | 8061 | 260 | 4 |
1926751 | 1926751 | 2021-11-17 | Wayne | Utah | 49055 | 260 | 0 |
1922301 | 1922301 | 2021-11-16 | Gosper | Nebraska | 31073 | 260 | 5 |
1923501 | 1923501 | 2021-11-16 | Wayne | Utah | 49055 | 260 | 0 |
1919051 | 1919051 | 2021-11-15 | Gosper | Nebraska | 31073 | 260 | 5 |
1896647 | 1896647 | 2021-11-08 | Steele | North Dakota | 38091 | 260 | 2 |
1893397 | 1893397 | 2021-11-07 | Steele | North Dakota | 38091 | 260 | 2 |
1890147 | 1890147 | 2021-11-06 | Steele | North Dakota | 38091 | 260 | 2 |
1886897 | 1886897 | 2021-11-05 | Steele | North Dakota | 38091 | 260 | 2 |
1883237 | 1883237 | 2021-11-04 | Liberty | Montana | 30051 | 260 | 2 |
1883648 | 1883648 | 2021-11-04 | Steele | North Dakota | 38091 | 260 | 2 |
1879988 | 1879988 | 2021-11-03 | Liberty | Montana | 30051 | 260 | 2 |
1879992 | 1879992 | 2021-11-03 | Meagher | Montana | 30059 | 260 | 8 |
1880399 | 1880399 | 2021-11-03 | Steele | North Dakota | 38091 | 260 | 2 |
1876739 | 1876739 | 2021-11-02 | Liberty | Montana | 30051 | 260 | 2 |
1877150 | 1877150 | 2021-11-02 | Steele | North Dakota | 38091 | 260 | 2 |
1873901 | 1873901 | 2021-11-01 | Steele | North Dakota | 38091 | 260 | 2 |
1870269 | 1870269 | 2021-10-31 | Wheatland | Montana | 30107 | 260 | 12 |
1867020 | 1867020 | 2021-10-30 | Wheatland | Montana | 30107 | 260 | 12 |
1863771 | 1863771 | 2021-10-29 | Wheatland | Montana | 30107 | 260 | 12 |
1860139 | 1860139 | 2021-10-28 | Keweenaw | Michigan | 26083 | 260 | 4 |
1860522 | 1860522 | 2021-10-28 | Wheatland | Montana | 30107 | 260 | 12 |
1856890 | 1856890 | 2021-10-27 | Keweenaw | Michigan | 26083 | 260 | 4 |
1841374 | 1841374 | 2021-10-22 | Divide | North Dakota | 38023 | 260 | 2 |
1836180 | 1836180 | 2021-10-21 | Denali Borough | Alaska | 2068 | 260 | 1 |
1836651 | 1836651 | 2021-10-21 | Webster | Georgia | 13307 | 260 | 6 |
1805329 | 1805329 | 2021-10-11 | Harlan | Nebraska | 31083 | 260 | 0 |
1802080 | 1802080 | 2021-10-10 | Harlan | Nebraska | 31083 | 260 | 0 |
1798831 | 1798831 | 2021-10-09 | Harlan | Nebraska | 31083 | 260 | 0 |
1795582 | 1795582 | 2021-10-08 | Harlan | Nebraska | 31083 | 260 | 0 |
1792333 | 1792333 | 2021-10-07 | Harlan | Nebraska | 31083 | 260 | 0 |
1793715 | 1793715 | 2021-10-07 | Wahkiakum | Washington | 53069 | 260 | 5 |
1790466 | 1790466 | 2021-10-06 | Wahkiakum | Washington | 53069 | 260 | 5 |
1785045 | 1785045 | 2021-10-05 | Elk | Kansas | 20049 | 260 | 6 |
1781796 | 1781796 | 2021-10-04 | Elk | Kansas | 20049 | 260 | 6 |
1783969 | 1783969 | 2021-10-04 | Wahkiakum | Washington | 53069 | 260 | 5 |
1779334 | 1779334 | 2021-10-03 | Greeley | Nebraska | 31077 | 260 | 1 |
1776084 | 1776084 | 2021-10-02 | Greeley | Nebraska | 31077 | 260 | 1 |
1772834 | 1772834 | 2021-10-01 | Greeley | Nebraska | 31077 | 260 | 1 |
1757288 | 1757288 | 2021-09-26 | Vieques | Puerto Rico | 72147 | 260 | |
1754040 | 1754040 | 2021-09-25 | Vieques | Puerto Rico | 72147 | 260 | |
1750792 | 1750792 | 2021-09-24 | Vieques | Puerto Rico | 72147 | 260 | |
1747159 | 1747159 | 2021-09-23 | Grant | North Dakota | 38037 | 260 | 7 |
1747543 | 1747543 | 2021-09-23 | Vieques | Puerto Rico | 72147 | 260 | |
1744293 | 1744293 | 2021-09-22 | Vieques | Puerto Rico | 72147 | 260 | |
1741044 | 1741044 | 2021-09-21 | Vieques | Puerto Rico | 72147 | 260 | |
1737795 | 1737795 | 2021-09-20 | Vieques | Puerto Rico | 72147 | 260 | |
1734545 | 1734545 | 2021-09-19 | Vieques | Puerto Rico | 72147 | 260 | |
1731295 | 1731295 | 2021-09-18 | Vieques | Puerto Rico | 72147 | 260 | |
1728045 | 1728045 | 2021-09-17 | Vieques | Puerto Rico | 72147 | 260 | |
1724796 | 1724796 | 2021-09-16 | Vieques | Puerto Rico | 72147 | 260 | |
1721547 | 1721547 | 2021-09-15 | Vieques | Puerto Rico | 72147 | 260 | |
1718299 | 1718299 | 2021-09-14 | Vieques | Puerto Rico | 72147 | 260 | |
1715051 | 1715051 | 2021-09-13 | Vieques | Puerto Rico | 72147 | 260 |
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);