ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where cases = 302 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 67
- Georgia 38
- Oklahoma 33
- Virginia 30
- Missouri 27
- South Dakota 27
- Michigan 24
- Nebraska 24
- Indiana 22
- North Dakota 22
- Kentucky 21
- Montana 21
- Puerto Rico 21
- Tennessee 21
- Illinois 19
- Iowa 19
- Mississippi 17
- North Carolina 16
- Ohio 16
- Colorado 15
- Kansas 15
- Alabama 14
- Arkansas 14
- Minnesota 13
- New York 13
- Idaho 11
- South Carolina 10
- Vermont 10
- California 9
- Utah 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2238883 | 2238883 | 2022-02-21 | Piute | Utah | 49031 | 302 | 6 |
2235632 | 2235632 | 2022-02-20 | Piute | Utah | 49031 | 302 | 6 |
2232381 | 2232381 | 2022-02-19 | Piute | Utah | 49031 | 302 | 6 |
2229130 | 2229130 | 2022-02-18 | Piute | Utah | 49031 | 302 | 6 |
2225879 | 2225879 | 2022-02-17 | Piute | Utah | 49031 | 302 | 6 |
2222628 | 2222628 | 2022-02-16 | Piute | Utah | 49031 | 302 | 6 |
2218979 | 2218979 | 2022-02-15 | Hyde | South Dakota | 46069 | 302 | 6 |
2212237 | 2212237 | 2022-02-13 | Sherman | Oregon | 41055 | 302 | 3 |
2208984 | 2208984 | 2022-02-12 | Sherman | Oregon | 41055 | 302 | 3 |
2205731 | 2205731 | 2022-02-11 | Sherman | Oregon | 41055 | 302 | 3 |
2149833 | 2149833 | 2022-01-25 | Wheatland | Montana | 30107 | 302 | 13 |
2147756 | 2147756 | 2022-01-24 | Stonewall | Texas | 48433 | 302 | 7 |
2133600 | 2133600 | 2022-01-20 | Garden | Nebraska | 31069 | 302 | 1 |
2130347 | 2130347 | 2022-01-19 | Garden | Nebraska | 31069 | 302 | 1 |
2131717 | 2131717 | 2022-01-19 | Garfield | Washington | 53023 | 302 | 7 |
2127093 | 2127093 | 2022-01-18 | Garden | Nebraska | 31069 | 302 | 1 |
2111778 | 2111778 | 2022-01-13 | Briscoe | Texas | 48045 | 302 | 8 |
2107577 | 2107577 | 2022-01-12 | Dundy | Nebraska | 31057 | 302 | 6 |
2080804 | 2080804 | 2022-01-04 | Hodgeman | Kansas | 20083 | 302 | 10 |
2077552 | 2077552 | 2022-01-03 | Hodgeman | Kansas | 20083 | 302 | 10 |
2060018 | 2060018 | 2021-12-28 | Wayne | Utah | 49055 | 302 | 0 |
2056769 | 2056769 | 2021-12-27 | Wayne | Utah | 49055 | 302 | 0 |
2000218 | 2000218 | 2021-12-10 | Worth | Missouri | 29227 | 302 | 2 |
1996967 | 1996967 | 2021-12-09 | Worth | Missouri | 29227 | 302 | 2 |
1984058 | 1984058 | 2021-12-05 | Garfield | Nebraska | 31071 | 302 | 2 |
1980808 | 1980808 | 2021-12-04 | Garfield | Nebraska | 31071 | 302 | 2 |
1977558 | 1977558 | 2021-12-03 | Garfield | Nebraska | 31071 | 302 | 2 |
1974311 | 1974311 | 2021-12-02 | Greeley | Nebraska | 31077 | 302 | 2 |
1972448 | 1972448 | 2021-12-01 | Wahkiakum | Washington | 53069 | 302 | 5 |
1969198 | 1969198 | 2021-11-30 | Wahkiakum | Washington | 53069 | 302 | 5 |
1964494 | 1964494 | 2021-11-29 | McCone | Montana | 30055 | 302 | 3 |
1964588 | 1964588 | 2021-11-29 | Pawnee | Nebraska | 31133 | 302 | 4 |
1965948 | 1965948 | 2021-11-29 | Wahkiakum | Washington | 53069 | 302 | 5 |
1960943 | 1960943 | 2021-11-28 | Cook | Minnesota | 27031 | 302 | 0 |
1961224 | 1961224 | 2021-11-28 | Daniels | Montana | 30019 | 302 | 9 |
1961243 | 1961243 | 2021-11-28 | McCone | Montana | 30055 | 302 | 3 |
1962436 | 1962436 | 2021-11-28 | Sherman | Texas | 48421 | 302 | 15 |
1957692 | 1957692 | 2021-11-27 | Cook | Minnesota | 27031 | 302 | 0 |
1957973 | 1957973 | 2021-11-27 | Daniels | Montana | 30019 | 302 | 9 |
1957992 | 1957992 | 2021-11-27 | McCone | Montana | 30055 | 302 | 3 |
1959185 | 1959185 | 2021-11-27 | Sherman | Texas | 48421 | 302 | 15 |
1954441 | 1954441 | 2021-11-26 | Cook | Minnesota | 27031 | 302 | 0 |
1954722 | 1954722 | 2021-11-26 | Daniels | Montana | 30019 | 302 | 9 |
1954741 | 1954741 | 2021-11-26 | McCone | Montana | 30055 | 302 | 3 |
1955934 | 1955934 | 2021-11-26 | Sherman | Texas | 48421 | 302 | 15 |
1951471 | 1951471 | 2021-11-25 | Daniels | Montana | 30019 | 302 | 9 |
1951490 | 1951490 | 2021-11-25 | McCone | Montana | 30055 | 302 | 3 |
1952683 | 1952683 | 2021-11-25 | Sherman | Texas | 48421 | 302 | 15 |
1948220 | 1948220 | 2021-11-24 | Daniels | Montana | 30019 | 302 | 9 |
1948239 | 1948239 | 2021-11-24 | McCone | Montana | 30055 | 302 | 3 |
1949432 | 1949432 | 2021-11-24 | Sherman | Texas | 48421 | 302 | 15 |
1944969 | 1944969 | 2021-11-23 | Daniels | Montana | 30019 | 302 | 9 |
1944988 | 1944988 | 2021-11-23 | McCone | Montana | 30055 | 302 | 3 |
1946181 | 1946181 | 2021-11-23 | Sherman | Texas | 48421 | 302 | 15 |
1941718 | 1941718 | 2021-11-22 | Daniels | Montana | 30019 | 302 | 9 |
1941737 | 1941737 | 2021-11-22 | McCone | Montana | 30055 | 302 | 3 |
1938487 | 1938487 | 2021-11-21 | McCone | Montana | 30055 | 302 | 3 |
1935237 | 1935237 | 2021-11-20 | McCone | Montana | 30055 | 302 | 3 |
1931987 | 1931987 | 2021-11-19 | McCone | Montana | 30055 | 302 | 3 |
1923092 | 1923092 | 2021-11-16 | Jerauld | South Dakota | 46073 | 302 | 17 |
1919843 | 1919843 | 2021-11-15 | Jerauld | South Dakota | 46073 | 302 | 17 |
1876012 | 1876012 | 2021-11-02 | Comanche | Kansas | 20033 | 302 | 12 |
1872763 | 1872763 | 2021-11-01 | Comanche | Kansas | 20033 | 302 | 12 |
1869522 | 1869522 | 2021-10-31 | Elk | Kansas | 20049 | 302 | 6 |
1866273 | 1866273 | 2021-10-30 | Elk | Kansas | 20049 | 302 | 6 |
1863024 | 1863024 | 2021-10-29 | Elk | Kansas | 20049 | 302 | 6 |
1812141 | 1812141 | 2021-10-13 | Grant | North Dakota | 38037 | 302 | 7 |
1809031 | 1809031 | 2021-10-12 | Cimarron | Oklahoma | 40025 | 302 | 2 |
1805781 | 1805781 | 2021-10-11 | Cimarron | Oklahoma | 40025 | 302 | 2 |
1802531 | 1802531 | 2021-10-10 | Cimarron | Oklahoma | 40025 | 302 | 2 |
1799282 | 1799282 | 2021-10-09 | Cimarron | Oklahoma | 40025 | 302 | 2 |
1796033 | 1796033 | 2021-10-08 | Cimarron | Oklahoma | 40025 | 302 | 2 |
1792784 | 1792784 | 2021-10-07 | Cimarron | Oklahoma | 40025 | 302 | 2 |
1789535 | 1789535 | 2021-10-06 | Cimarron | Oklahoma | 40025 | 302 | 2 |
1783384 | 1783384 | 2021-10-04 | Mellette | South Dakota | 46095 | 302 | 2 |
1779458 | 1779458 | 2021-10-03 | Mora | New Mexico | 35033 | 302 | 10 |
1780133 | 1780133 | 2021-10-03 | McPherson | South Dakota | 46089 | 302 | 7 |
1776208 | 1776208 | 2021-10-02 | Mora | New Mexico | 35033 | 302 | 10 |
1776883 | 1776883 | 2021-10-02 | McPherson | South Dakota | 46089 | 302 | 7 |
1772958 | 1772958 | 2021-10-01 | Mora | New Mexico | 35033 | 302 | 10 |
1773633 | 1773633 | 2021-10-01 | McPherson | South Dakota | 46089 | 302 | 7 |
1766261 | 1766261 | 2021-09-29 | Granite | Montana | 30039 | 302 | 2 |
1760151 | 1760151 | 2021-09-27 | Golden Valley | North Dakota | 38033 | 302 | 4 |
1756903 | 1756903 | 2021-09-26 | Golden Valley | North Dakota | 38033 | 302 | 4 |
1753655 | 1753655 | 2021-09-25 | Golden Valley | North Dakota | 38033 | 302 | 4 |
1753662 | 1753662 | 2021-09-25 | Logan | North Dakota | 38047 | 302 | 10 |
1750414 | 1750414 | 2021-09-24 | Logan | North Dakota | 38047 | 302 | 10 |
1748375 | 1748375 | 2021-09-23 | Niobrara | Wyoming | 56027 | 302 | 4 |
1726214 | 1726214 | 2021-09-17 | Custer | Idaho | 16037 | 302 | 3 |
1724878 | 1724878 | 2021-09-16 | Haakon | South Dakota | 46055 | 302 | 11 |
1721629 | 1721629 | 2021-09-15 | Haakon | South Dakota | 46055 | 302 | 11 |
1702442 | 1702442 | 2021-09-09 | Menard | Texas | 48327 | 302 | 10 |
1696825 | 1696825 | 2021-09-08 | Clay | Georgia | 13061 | 302 | 3 |
1693577 | 1693577 | 2021-09-07 | Clay | Georgia | 13061 | 302 | 3 |
1671318 | 1671318 | 2021-08-31 | Chase | Kansas | 20017 | 302 | 3 |
1673218 | 1673218 | 2021-08-31 | Oldham | Texas | 48359 | 302 | 4 |
1673350 | 1673350 | 2021-08-31 | Bath | Virginia | 51017 | 302 | 11 |
1668071 | 1668071 | 2021-08-30 | Chase | Kansas | 20017 | 302 | 3 |
1669970 | 1669970 | 2021-08-30 | Oldham | Texas | 48359 | 302 | 4 |
1666723 | 1666723 | 2021-08-29 | Oldham | Texas | 48359 | 302 | 4 |
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);