ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
751 rows where cases = 301 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 103
- Georgia 42
- Kansas 36
- Virginia 33
- South Dakota 30
- North Carolina 29
- Nebraska 28
- North Dakota 27
- Puerto Rico 25
- Kentucky 24
- New York 24
- Mississippi 21
- Missouri 19
- Washington 18
- Minnesota 17
- Oklahoma 17
- Arkansas 16
- Colorado 16
- Indiana 15
- Ohio 14
- Pennsylvania 13
- West Virginia 13
- Oregon 12
- Wisconsin 12
- Illinois 11
- Montana 11
- New Mexico 11
- South Carolina 11
- Tennessee 11
- Alabama 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2388285 | 2388285 | 2022-04-08 | Cottle | Texas | 48101 | 301 | 9 |
2257264 | 2257264 | 2022-02-27 | Eureka | Nevada | 32011 | 301 | 1 |
2254013 | 2254013 | 2022-02-26 | Eureka | Nevada | 32011 | 301 | 1 |
2250762 | 2250762 | 2022-02-25 | Eureka | Nevada | 32011 | 301 | 1 |
2202478 | 2202478 | 2022-02-10 | Sherman | Oregon | 41055 | 301 | 3 |
2199224 | 2199224 | 2022-02-09 | Sherman | Oregon | 41055 | 301 | 3 |
2188899 | 2188899 | 2022-02-06 | Deuel | Nebraska | 31049 | 301 | 2 |
2185646 | 2185646 | 2022-02-05 | Deuel | Nebraska | 31049 | 301 | 2 |
2182394 | 2182394 | 2022-02-04 | Deuel | Nebraska | 31049 | 301 | 2 |
2156449 | 2156449 | 2022-01-27 | Storey | Nevada | 32029 | 301 | 9 |
2097941 | 2097941 | 2022-01-09 | Catron | New Mexico | 35003 | 301 | 11 |
2094689 | 2094689 | 2022-01-08 | Catron | New Mexico | 35003 | 301 | 11 |
2091437 | 2091437 | 2022-01-07 | Catron | New Mexico | 35003 | 301 | 11 |
2088186 | 2088186 | 2022-01-06 | Catron | New Mexico | 35003 | 301 | 11 |
2084934 | 2084934 | 2022-01-05 | Catron | New Mexico | 35003 | 301 | 11 |
2065661 | 2065661 | 2021-12-30 | Steele | North Dakota | 38091 | 301 | 2 |
2053520 | 2053520 | 2021-12-26 | Wayne | Utah | 49055 | 301 | 0 |
2050270 | 2050270 | 2021-12-25 | Wayne | Utah | 49055 | 301 | 0 |
2047020 | 2047020 | 2021-12-24 | Wayne | Utah | 49055 | 301 | 0 |
2043770 | 2043770 | 2021-12-23 | Wayne | Utah | 49055 | 301 | 0 |
1971062 | 1971062 | 2021-12-01 | Greeley | Nebraska | 31077 | 301 | 2 |
1964194 | 1964194 | 2021-11-29 | Cook | Minnesota | 27031 | 301 | 0 |
1961337 | 1961337 | 2021-11-28 | Pawnee | Nebraska | 31133 | 301 | 4 |
1962696 | 1962696 | 2021-11-28 | Wahkiakum | Washington | 53069 | 301 | 5 |
1958086 | 1958086 | 2021-11-27 | Pawnee | Nebraska | 31133 | 301 | 4 |
1959445 | 1959445 | 2021-11-27 | Wahkiakum | Washington | 53069 | 301 | 5 |
1954835 | 1954835 | 2021-11-26 | Pawnee | Nebraska | 31133 | 301 | 4 |
1956194 | 1956194 | 2021-11-26 | Wahkiakum | Washington | 53069 | 301 | 5 |
1951584 | 1951584 | 2021-11-25 | Pawnee | Nebraska | 31133 | 301 | 4 |
1952943 | 1952943 | 2021-11-25 | Wahkiakum | Washington | 53069 | 301 | 5 |
1948333 | 1948333 | 2021-11-24 | Pawnee | Nebraska | 31133 | 301 | 4 |
1949692 | 1949692 | 2021-11-24 | Wahkiakum | Washington | 53069 | 301 | 5 |
1945082 | 1945082 | 2021-11-23 | Pawnee | Nebraska | 31133 | 301 | 4 |
1946441 | 1946441 | 2021-11-23 | Wahkiakum | Washington | 53069 | 301 | 5 |
1942930 | 1942930 | 2021-11-22 | Sherman | Texas | 48421 | 301 | 15 |
1943190 | 1943190 | 2021-11-22 | Wahkiakum | Washington | 53069 | 301 | 5 |
1939680 | 1939680 | 2021-11-21 | Sherman | Texas | 48421 | 301 | 15 |
1939940 | 1939940 | 2021-11-21 | Wahkiakum | Washington | 53069 | 301 | 5 |
1936430 | 1936430 | 2021-11-20 | Sherman | Texas | 48421 | 301 | 15 |
1936690 | 1936690 | 2021-11-20 | Wahkiakum | Washington | 53069 | 301 | 5 |
1933180 | 1933180 | 2021-11-19 | Sherman | Texas | 48421 | 301 | 15 |
1933440 | 1933440 | 2021-11-19 | Wahkiakum | Washington | 53069 | 301 | 5 |
1929110 | 1929110 | 2021-11-18 | Divide | North Dakota | 38023 | 301 | 3 |
1930188 | 1930188 | 2021-11-18 | Wahkiakum | Washington | 53069 | 301 | 5 |
1925860 | 1925860 | 2021-11-17 | Divide | North Dakota | 38023 | 301 | 3 |
1926938 | 1926938 | 2021-11-17 | Wahkiakum | Washington | 53069 | 301 | 5 |
1922415 | 1922415 | 2021-11-16 | De Baca | New Mexico | 35011 | 301 | 3 |
1922611 | 1922611 | 2021-11-16 | Divide | North Dakota | 38023 | 301 | 3 |
1916593 | 1916593 | 2021-11-14 | Jerauld | South Dakota | 46073 | 301 | 17 |
1913343 | 1913343 | 2021-11-13 | Jerauld | South Dakota | 46073 | 301 | 17 |
1910093 | 1910093 | 2021-11-12 | Jerauld | South Dakota | 46073 | 301 | 17 |
1906844 | 1906844 | 2021-11-11 | Jerauld | South Dakota | 46073 | 301 | 17 |
1903595 | 1903595 | 2021-11-10 | Jerauld | South Dakota | 46073 | 301 | 17 |
1900345 | 1900345 | 2021-11-09 | Jerauld | South Dakota | 46073 | 301 | 17 |
1897095 | 1897095 | 2021-11-08 | Jerauld | South Dakota | 46073 | 301 | 17 |
1892344 | 1892344 | 2021-11-07 | Wichita | Kansas | 20203 | 301 | 6 |
1893845 | 1893845 | 2021-11-07 | Jerauld | South Dakota | 46073 | 301 | 17 |
1889094 | 1889094 | 2021-11-06 | Wichita | Kansas | 20203 | 301 | 6 |
1890595 | 1890595 | 2021-11-06 | Jerauld | South Dakota | 46073 | 301 | 17 |
1885844 | 1885844 | 2021-11-05 | Wichita | Kansas | 20203 | 301 | 6 |
1887345 | 1887345 | 2021-11-05 | Jerauld | South Dakota | 46073 | 301 | 17 |
1882595 | 1882595 | 2021-11-04 | Wichita | Kansas | 20203 | 301 | 6 |
1884095 | 1884095 | 2021-11-04 | Jerauld | South Dakota | 46073 | 301 | 17 |
1879346 | 1879346 | 2021-11-03 | Wichita | Kansas | 20203 | 301 | 6 |
1880846 | 1880846 | 2021-11-03 | Jerauld | South Dakota | 46073 | 301 | 17 |
1877597 | 1877597 | 2021-11-02 | Jerauld | South Dakota | 46073 | 301 | 17 |
1806380 | 1806380 | 2021-10-11 | Knox | Texas | 48275 | 301 | 20 |
1803130 | 1803130 | 2021-10-10 | Knox | Texas | 48275 | 301 | 20 |
1799881 | 1799881 | 2021-10-09 | Knox | Texas | 48275 | 301 | 20 |
1796632 | 1796632 | 2021-10-08 | Knox | Texas | 48275 | 301 | 20 |
1793383 | 1793383 | 2021-10-07 | Knox | Texas | 48275 | 301 | 20 |
1786287 | 1786287 | 2021-10-05 | Cimarron | Oklahoma | 40025 | 301 | 2 |
1783038 | 1783038 | 2021-10-04 | Cimarron | Oklahoma | 40025 | 301 | 2 |
1778194 | 1778194 | 2021-10-03 | Butte | Idaho | 16023 | 301 | 3 |
1779789 | 1779789 | 2021-10-03 | Cimarron | Oklahoma | 40025 | 301 | 2 |
1780135 | 1780135 | 2021-10-03 | Mellette | South Dakota | 46095 | 301 | 2 |
1774944 | 1774944 | 2021-10-02 | Butte | Idaho | 16023 | 301 | 3 |
1776539 | 1776539 | 2021-10-02 | Cimarron | Oklahoma | 40025 | 301 | 2 |
1776885 | 1776885 | 2021-10-02 | Mellette | South Dakota | 46095 | 301 | 2 |
1771694 | 1771694 | 2021-10-01 | Butte | Idaho | 16023 | 301 | 3 |
1773289 | 1773289 | 2021-10-01 | Cimarron | Oklahoma | 40025 | 301 | 2 |
1773635 | 1773635 | 2021-10-01 | Mellette | South Dakota | 46095 | 301 | 2 |
1770039 | 1770039 | 2021-09-30 | Cimarron | Oklahoma | 40025 | 301 | 2 |
1770383 | 1770383 | 2021-09-30 | McPherson | South Dakota | 46089 | 301 | 7 |
1766790 | 1766790 | 2021-09-29 | Cimarron | Oklahoma | 40025 | 301 | 2 |
1763012 | 1763012 | 2021-09-28 | Granite | Montana | 30039 | 301 | 2 |
1763130 | 1763130 | 2021-09-28 | Sherman | Nebraska | 31163 | 301 | 4 |
1755984 | 1755984 | 2021-09-26 | Robertson | Kentucky | 21201 | 301 | 15 |
1752736 | 1752736 | 2021-09-25 | Robertson | Kentucky | 21201 | 301 | 15 |
1749487 | 1749487 | 2021-09-24 | Robertson | Kentucky | 21201 | 301 | 15 |
1746237 | 1746237 | 2021-09-23 | Robertson | Kentucky | 21201 | 301 | 15 |
1739739 | 1739739 | 2021-09-21 | Robertson | Kentucky | 21201 | 301 | 15 |
1736490 | 1736490 | 2021-09-20 | Robertson | Kentucky | 21201 | 301 | 15 |
1716880 | 1716880 | 2021-09-14 | Smith | Kansas | 20183 | 301 | 3 |
1713634 | 1713634 | 2021-09-13 | Smith | Kansas | 20183 | 301 | 3 |
1710308 | 1710308 | 2021-09-12 | Clark | Kansas | 20025 | 301 | 7 |
1707061 | 1707061 | 2021-09-11 | Clark | Kansas | 20025 | 301 | 7 |
1703813 | 1703813 | 2021-09-10 | Clark | Kansas | 20025 | 301 | 7 |
1695163 | 1695163 | 2021-09-07 | Adams | North Dakota | 38001 | 301 | 3 |
1682185 | 1682185 | 2021-09-03 | Kidder | North Dakota | 38043 | 301 | 10 |
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);