ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
675 rows where cases = 431 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 70
- North Dakota 39
- Texas 38
- Virginia 35
- Nebraska 34
- Georgia 28
- South Dakota 27
- Michigan 24
- Missouri 24
- Iowa 21
- Puerto Rico 21
- Illinois 20
- Mississippi 19
- Colorado 18
- Minnesota 18
- Idaho 17
- Arkansas 16
- Indiana 16
- Kentucky 16
- Montana 16
- Tennessee 14
- Oregon 13
- Pennsylvania 13
- North Carolina 11
- Ohio 9
- Oklahoma 9
- Alabama 8
- Florida 8
- Louisiana 8
- West Virginia 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2293278 | 2293278 | 2022-03-10 | Burke | North Dakota | 38013 | 431 | 3 |
2270528 | 2270528 | 2022-03-03 | Logan | North Dakota | 38047 | 431 | 12 |
2260773 | 2260773 | 2022-02-28 | Logan | North Dakota | 38047 | 431 | 12 |
2257522 | 2257522 | 2022-02-27 | Logan | North Dakota | 38047 | 431 | 12 |
2254271 | 2254271 | 2022-02-26 | Logan | North Dakota | 38047 | 431 | 12 |
2165347 | 2165347 | 2022-01-30 | Comanche | Kansas | 20033 | 431 | 13 |
2162092 | 2162092 | 2022-01-29 | Comanche | Kansas | 20033 | 431 | 13 |
2158837 | 2158837 | 2022-01-28 | Comanche | Kansas | 20033 | 431 | 13 |
2153908 | 2153908 | 2022-01-26 | Haakon | South Dakota | 46055 | 431 | 11 |
2145482 | 2145482 | 2022-01-24 | Butte | Idaho | 16023 | 431 | 7 |
2142227 | 2142227 | 2022-01-23 | Butte | Idaho | 16023 | 431 | 7 |
2138972 | 2138972 | 2022-01-22 | Butte | Idaho | 16023 | 431 | 7 |
2135716 | 2135716 | 2022-01-21 | Butte | Idaho | 16023 | 431 | 7 |
2137172 | 2137172 | 2022-01-21 | Grant | North Dakota | 38037 | 431 | 11 |
2137938 | 2137938 | 2022-01-21 | Menard | Texas | 48327 | 431 | 12 |
2132464 | 2132464 | 2022-01-20 | Butte | Idaho | 16023 | 431 | 7 |
2126297 | 2126297 | 2022-01-18 | Clark | Kansas | 20025 | 431 | 7 |
2123045 | 2123045 | 2022-01-17 | Clark | Kansas | 20025 | 431 | 7 |
2119793 | 2119793 | 2022-01-16 | Clark | Kansas | 20025 | 431 | 7 |
2120912 | 2120912 | 2022-01-16 | Kidder | North Dakota | 38043 | 431 | 13 |
2116541 | 2116541 | 2022-01-15 | Clark | Kansas | 20025 | 431 | 7 |
2113290 | 2113290 | 2022-01-14 | Clark | Kansas | 20025 | 431 | 7 |
2101197 | 2101197 | 2022-01-10 | De Baca | New Mexico | 35011 | 431 | 3 |
2035312 | 2035312 | 2021-12-21 | Lincoln | Kansas | 20105 | 431 | 7 |
2036861 | 2036861 | 2021-12-21 | Jackson | South Dakota | 46071 | 431 | 19 |
2032062 | 2032062 | 2021-12-20 | Lincoln | Kansas | 20105 | 431 | 7 |
2033611 | 2033611 | 2021-12-20 | Jackson | South Dakota | 46071 | 431 | 19 |
2030361 | 2030361 | 2021-12-19 | Jackson | South Dakota | 46071 | 431 | 19 |
2027110 | 2027110 | 2021-12-18 | Jackson | South Dakota | 46071 | 431 | 19 |
2023859 | 2023859 | 2021-12-17 | Jackson | South Dakota | 46071 | 431 | 19 |
2017378 | 2017378 | 2021-12-15 | Sanborn | South Dakota | 46111 | 431 | 3 |
2010071 | 2010071 | 2021-12-13 | Hitchcock | Nebraska | 31087 | 431 | 5 |
1997187 | 1997187 | 2021-12-09 | Mora | New Mexico | 35033 | 431 | 12 |
1990554 | 1990554 | 2021-12-07 | Frontier | Nebraska | 31063 | 431 | 2 |
1984038 | 1984038 | 2021-12-05 | Cherry | Nebraska | 31031 | 431 | 8 |
1980788 | 1980788 | 2021-12-04 | Cherry | Nebraska | 31031 | 431 | 8 |
1977538 | 1977538 | 2021-12-03 | Cherry | Nebraska | 31031 | 431 | 8 |
1972441 | 1972441 | 2021-12-01 | San Juan | Washington | 53055 | 431 | 0 |
1969191 | 1969191 | 2021-11-30 | San Juan | Washington | 53055 | 431 | 0 |
1948649 | 1948649 | 2021-11-24 | Towner | North Dakota | 38095 | 431 | 11 |
1945832 | 1945832 | 2021-11-23 | Faulk | South Dakota | 46049 | 431 | 15 |
1946046 | 1946046 | 2021-11-23 | Fisher | Texas | 48151 | 431 | 17 |
1942795 | 1942795 | 2021-11-22 | Fisher | Texas | 48151 | 431 | 17 |
1938850 | 1938850 | 2021-11-21 | Adams | North Dakota | 38001 | 431 | 5 |
1938887 | 1938887 | 2021-11-21 | Renville | North Dakota | 38075 | 431 | 14 |
1939545 | 1939545 | 2021-11-21 | Fisher | Texas | 48151 | 431 | 17 |
1935600 | 1935600 | 2021-11-20 | Adams | North Dakota | 38001 | 431 | 5 |
1936295 | 1936295 | 2021-11-20 | Fisher | Texas | 48151 | 431 | 17 |
1923366 | 1923366 | 2021-11-16 | Lipscomb | Texas | 48295 | 431 | 12 |
1875420 | 1875420 | 2021-11-02 | Unknown | Delaware | 431 | 0 | |
1853264 | 1853264 | 2021-10-26 | Cheyenne | Kansas | 20023 | 431 | 13 |
1850015 | 1850015 | 2021-10-25 | Cheyenne | Kansas | 20023 | 431 | 13 |
1833150 | 1833150 | 2021-10-20 | Ouray | Colorado | 8091 | 431 | 5 |
1832115 | 1832115 | 2021-10-19 | Marshall | South Dakota | 46091 | 431 | 6 |
1814929 | 1814929 | 2021-10-14 | Mercer | Missouri | 29129 | 431 | 3 |
1810184 | 1810184 | 2021-10-13 | Aleutians East Borough | Alaska | 2013 | 431 | 3 |
1806935 | 1806935 | 2021-10-12 | Aleutians East Borough | Alaska | 2013 | 431 | 3 |
1793285 | 1793285 | 2021-10-07 | Cochran | Texas | 48079 | 431 | 18 |
1782241 | 1782241 | 2021-10-04 | Lake of the Woods | Minnesota | 27077 | 431 | 4 |
1769902 | 1769902 | 2021-09-30 | Hettinger | North Dakota | 38041 | 431 | 4 |
1763137 | 1763137 | 2021-09-28 | Valley | Nebraska | 31175 | 431 | 2 |
1741972 | 1741972 | 2021-09-22 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 431 | 5 |
1744246 | 1744246 | 2021-09-22 | Guanica | Puerto Rico | 72055 | 431 | |
1740042 | 1740042 | 2021-09-21 | Traverse | Minnesota | 27155 | 431 | 5 |
1735947 | 1735947 | 2021-09-20 | Adams | Idaho | 16003 | 431 | 8 |
1738111 | 1738111 | 2021-09-20 | Hardeman | Texas | 48197 | 431 | 13 |
1732731 | 1732731 | 2021-09-19 | Oneida | Idaho | 16071 | 431 | 5 |
1734861 | 1734861 | 2021-09-19 | Hardeman | Texas | 48197 | 431 | 13 |
1729481 | 1729481 | 2021-09-18 | Oneida | Idaho | 16071 | 431 | 5 |
1731611 | 1731611 | 2021-09-18 | Hardeman | Texas | 48197 | 431 | 13 |
1726231 | 1726231 | 2021-09-17 | Oneida | Idaho | 16071 | 431 | 5 |
1702471 | 1702471 | 2021-09-09 | Real | Texas | 48385 | 431 | 14 |
1702610 | 1702610 | 2021-09-09 | Craig | Virginia | 51045 | 431 | 6 |
1692379 | 1692379 | 2021-09-06 | Buffalo | South Dakota | 46017 | 431 | 14 |
1689130 | 1689130 | 2021-09-05 | Buffalo | South Dakota | 46017 | 431 | 14 |
1685880 | 1685880 | 2021-09-04 | Buffalo | South Dakota | 46017 | 431 | 14 |
1682629 | 1682629 | 2021-09-03 | Buffalo | South Dakota | 46017 | 431 | 14 |
1678554 | 1678554 | 2021-09-02 | Mineral | Montana | 30061 | 431 | 9 |
1679379 | 1679379 | 2021-09-02 | Buffalo | South Dakota | 46017 | 431 | 14 |
1676131 | 1676131 | 2021-09-01 | Buffalo | South Dakota | 46017 | 431 | 14 |
1672884 | 1672884 | 2021-08-31 | Buffalo | South Dakota | 46017 | 431 | 14 |
1669636 | 1669636 | 2021-08-30 | Buffalo | South Dakota | 46017 | 431 | 14 |
1665913 | 1665913 | 2021-08-29 | Tyrrell | North Carolina | 37177 | 431 | 6 |
1666389 | 1666389 | 2021-08-29 | Buffalo | South Dakota | 46017 | 431 | 14 |
1662665 | 1662665 | 2021-08-28 | Tyrrell | North Carolina | 37177 | 431 | 6 |
1663141 | 1663141 | 2021-08-28 | Buffalo | South Dakota | 46017 | 431 | 14 |
1663526 | 1663526 | 2021-08-28 | Upton | Texas | 48461 | 431 | 11 |
1659417 | 1659417 | 2021-08-27 | Tyrrell | North Carolina | 37177 | 431 | 6 |
1659893 | 1659893 | 2021-08-27 | Buffalo | South Dakota | 46017 | 431 | 14 |
1656644 | 1656644 | 2021-08-26 | Buffalo | South Dakota | 46017 | 431 | 14 |
1653397 | 1653397 | 2021-08-25 | Buffalo | South Dakota | 46017 | 431 | 14 |
1648733 | 1648733 | 2021-08-24 | Hickman | Kentucky | 21105 | 431 | 16 |
1632982 | 1632982 | 2021-08-19 | Knox | Missouri | 29103 | 431 | 3 |
1629735 | 1629735 | 2021-08-18 | Knox | Missouri | 29103 | 431 | 3 |
1630202 | 1630202 | 2021-08-18 | Dunn | North Dakota | 38025 | 431 | 7 |
1626488 | 1626488 | 2021-08-17 | Knox | Missouri | 29103 | 431 | 3 |
1603861 | 1603861 | 2021-08-10 | Sheridan | Montana | 30091 | 431 | 5 |
1586894 | 1586894 | 2021-08-05 | Haskell | Kansas | 20081 | 431 | 9 |
1583644 | 1583644 | 2021-08-04 | Haskell | Kansas | 20081 | 431 | 9 |
1585675 | 1585675 | 2021-08-04 | Falls Church city | Virginia | 51610 | 431 | 8 |
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);