ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
605 rows where cases = 466 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 62
- Missouri 51
- Georgia 43
- South Dakota 41
- Virginia 27
- Puerto Rico 22
- Iowa 18
- Kentucky 18
- Nebraska 18
- Indiana 17
- Illinois 16
- Colorado 15
- Utah 15
- Oregon 14
- California 13
- Louisiana 13
- Mississippi 13
- West Virginia 13
- Michigan 12
- Montana 12
- North Dakota 12
- Minnesota 11
- North Carolina 11
- Ohio 10
- Alabama 9
- Kansas 9
- Alaska 8
- Arkansas 8
- New York 8
- Pennsylvania 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476212 | 2476212 | 2022-05-05 | Edwards | Texas | 48137 | 466 | 11 |
2472955 | 2472955 | 2022-05-04 | Edwards | Texas | 48137 | 466 | 11 |
2469699 | 2469699 | 2022-05-03 | Edwards | Texas | 48137 | 466 | 11 |
2466443 | 2466443 | 2022-05-02 | Edwards | Texas | 48137 | 466 | 11 |
2463188 | 2463188 | 2022-05-01 | Edwards | Texas | 48137 | 466 | 11 |
2459932 | 2459932 | 2022-04-30 | Edwards | Texas | 48137 | 466 | 11 |
2456676 | 2456676 | 2022-04-29 | Edwards | Texas | 48137 | 466 | 11 |
2453420 | 2453420 | 2022-04-28 | Edwards | Texas | 48137 | 466 | 11 |
2450164 | 2450164 | 2022-04-27 | Edwards | Texas | 48137 | 466 | 11 |
2446907 | 2446907 | 2022-04-26 | Edwards | Texas | 48137 | 466 | 11 |
2443652 | 2443652 | 2022-04-25 | Edwards | Texas | 48137 | 466 | 11 |
2440396 | 2440396 | 2022-04-24 | Edwards | Texas | 48137 | 466 | 11 |
2437140 | 2437140 | 2022-04-23 | Edwards | Texas | 48137 | 466 | 11 |
2433884 | 2433884 | 2022-04-22 | Edwards | Texas | 48137 | 466 | 11 |
2430628 | 2430628 | 2022-04-21 | Edwards | Texas | 48137 | 466 | 11 |
2427372 | 2427372 | 2022-04-20 | Edwards | Texas | 48137 | 466 | 11 |
2424116 | 2424116 | 2022-04-19 | Edwards | Texas | 48137 | 466 | 11 |
2420860 | 2420860 | 2022-04-18 | Edwards | Texas | 48137 | 466 | 11 |
2268591 | 2268591 | 2022-03-03 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 466 | 5 |
2265338 | 2265338 | 2022-03-02 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 466 | 5 |
2208748 | 2208748 | 2022-02-12 | Golden Valley | North Dakota | 38033 | 466 | 4 |
2205495 | 2205495 | 2022-02-11 | Golden Valley | North Dakota | 38033 | 466 | 4 |
2202242 | 2202242 | 2022-02-10 | Golden Valley | North Dakota | 38033 | 466 | 4 |
2170480 | 2170480 | 2022-01-31 | Menard | Texas | 48327 | 466 | 12 |
2150797 | 2150797 | 2022-01-25 | Armstrong | Texas | 48011 | 466 | 8 |
2143372 | 2143372 | 2022-01-23 | Hitchcock | Nebraska | 31087 | 466 | 6 |
2140117 | 2140117 | 2022-01-22 | Hitchcock | Nebraska | 31087 | 466 | 6 |
2136861 | 2136861 | 2022-01-21 | Hitchcock | Nebraska | 31087 | 466 | 6 |
2137529 | 2137529 | 2022-01-21 | Maricao | Puerto Rico | 72093 | 466 | |
2133609 | 2133609 | 2022-01-20 | Hitchcock | Nebraska | 31087 | 466 | 6 |
2085143 | 2085143 | 2022-01-05 | Griggs | North Dakota | 38039 | 466 | 2 |
2085637 | 2085637 | 2022-01-05 | Sanborn | South Dakota | 46111 | 466 | 4 |
2082625 | 2082625 | 2022-01-04 | Kimble | Texas | 48267 | 466 | 11 |
2036416 | 2036416 | 2021-12-21 | Towner | North Dakota | 38095 | 466 | 11 |
2033584 | 2033584 | 2021-12-20 | Buffalo | South Dakota | 46017 | 466 | 16 |
2030334 | 2030334 | 2021-12-19 | Buffalo | South Dakota | 46017 | 466 | 16 |
2027083 | 2027083 | 2021-12-18 | Buffalo | South Dakota | 46017 | 466 | 16 |
2023832 | 2023832 | 2021-12-17 | Buffalo | South Dakota | 46017 | 466 | 16 |
2019029 | 2019029 | 2021-12-16 | Edwards | Kansas | 20047 | 466 | 13 |
2020581 | 2020581 | 2021-12-16 | Buffalo | South Dakota | 46017 | 466 | 16 |
2020883 | 2020883 | 2021-12-16 | Lipscomb | Texas | 48295 | 466 | 12 |
2015779 | 2015779 | 2021-12-15 | Edwards | Kansas | 20047 | 466 | 13 |
2009950 | 2009950 | 2021-12-13 | Scotland | Missouri | 29199 | 466 | 15 |
2006699 | 2006699 | 2021-12-12 | Scotland | Missouri | 29199 | 466 | 15 |
1966362 | 1966362 | 2021-11-30 | Custer | Colorado | 8027 | 466 | 11 |
1967695 | 1967695 | 2021-11-30 | Schuyler | Missouri | 29197 | 466 | 22 |
1965345 | 1965345 | 2021-11-29 | Hanson | South Dakota | 46061 | 466 | 5 |
1874683 | 1874683 | 2021-11-01 | Shackelford | Texas | 48417 | 466 | 5 |
1871434 | 1871434 | 2021-10-31 | Shackelford | Texas | 48417 | 466 | 5 |
1868185 | 1868185 | 2021-10-30 | Shackelford | Texas | 48417 | 466 | 5 |
1815119 | 1815119 | 2021-10-14 | Stanton | Nebraska | 31167 | 466 | 11 |
1800454 | 1800454 | 2021-10-10 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 466 | 5 |
1797205 | 1797205 | 2021-10-09 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 466 | 5 |
1793956 | 1793956 | 2021-10-08 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 466 | 5 |
1768469 | 1768469 | 2021-09-30 | Oneida | Idaho | 16071 | 466 | 6 |
1755175 | 1755175 | 2021-09-26 | Phillips | Colorado | 8095 | 466 | 14 |
1756528 | 1756528 | 2021-09-26 | Musselshell | Montana | 30065 | 466 | 14 |
1751927 | 1751927 | 2021-09-25 | Phillips | Colorado | 8095 | 466 | 14 |
1753280 | 1753280 | 2021-09-25 | Musselshell | Montana | 30065 | 466 | 14 |
1748678 | 1748678 | 2021-09-24 | Phillips | Colorado | 8095 | 466 | 14 |
1750032 | 1750032 | 2021-09-24 | Musselshell | Montana | 30065 | 466 | 14 |
1746782 | 1746782 | 2021-09-23 | Musselshell | Montana | 30065 | 466 | 14 |
1743546 | 1743546 | 2021-09-22 | Sheridan | Montana | 30091 | 466 | 5 |
1720530 | 1720530 | 2021-09-15 | Red Lake | Minnesota | 27125 | 466 | 7 |
1702684 | 1702684 | 2021-09-09 | Rappahannock | Virginia | 51157 | 466 | 3 |
1696500 | 1696500 | 2021-09-08 | Yukon-Koyukuk Census Area | Alaska | 2290 | 466 | 4 |
1698665 | 1698665 | 2021-09-08 | Wallowa | Oregon | 41063 | 466 | 6 |
1690962 | 1690962 | 2021-09-06 | Hickman | Kentucky | 21105 | 466 | 16 |
1687712 | 1687712 | 2021-09-05 | Hickman | Kentucky | 21105 | 466 | 16 |
1688209 | 1688209 | 2021-09-05 | Knox | Missouri | 29103 | 466 | 3 |
1684462 | 1684462 | 2021-09-04 | Hickman | Kentucky | 21105 | 466 | 16 |
1684959 | 1684959 | 2021-09-04 | Knox | Missouri | 29103 | 466 | 3 |
1681211 | 1681211 | 2021-09-03 | Hickman | Kentucky | 21105 | 466 | 16 |
1681708 | 1681708 | 2021-09-03 | Knox | Missouri | 29103 | 466 | 3 |
1666912 | 1666912 | 2021-08-29 | King and Queen | Virginia | 51097 | 466 | 7 |
1663664 | 1663664 | 2021-08-28 | King and Queen | Virginia | 51097 | 466 | 7 |
1660416 | 1660416 | 2021-08-27 | King and Queen | Virginia | 51097 | 466 | 7 |
1655112 | 1655112 | 2021-08-26 | Haskell | Kansas | 20081 | 466 | 8 |
1657244 | 1657244 | 2021-08-26 | Ferry | Washington | 53019 | 466 | 9 |
1651865 | 1651865 | 2021-08-25 | Haskell | Kansas | 20081 | 466 | 8 |
1646488 | 1646488 | 2021-08-23 | Wells | North Dakota | 38103 | 466 | 8 |
1643239 | 1643239 | 2021-08-22 | Wells | North Dakota | 38103 | 466 | 8 |
1644230 | 1644230 | 2021-08-22 | Surry | Virginia | 51181 | 466 | 9 |
1639989 | 1639989 | 2021-08-21 | Wells | North Dakota | 38103 | 466 | 8 |
1640980 | 1640980 | 2021-08-21 | Surry | Virginia | 51181 | 466 | 9 |
1636739 | 1636739 | 2021-08-20 | Wells | North Dakota | 38103 | 466 | 8 |
1637730 | 1637730 | 2021-08-20 | Surry | Virginia | 51181 | 466 | 9 |
1633489 | 1633489 | 2021-08-19 | Wells | North Dakota | 38103 | 466 | 8 |
1619449 | 1619449 | 2021-08-15 | Ballard | Kentucky | 21007 | 466 | 10 |
1616201 | 1616201 | 2021-08-14 | Ballard | Kentucky | 21007 | 466 | 10 |
1612952 | 1612952 | 2021-08-13 | Ballard | Kentucky | 21007 | 466 | 10 |
1604676 | 1604676 | 2021-08-10 | Clark | South Dakota | 46025 | 466 | 5 |
1604930 | 1604930 | 2021-08-10 | Haskell | Texas | 48207 | 466 | 28 |
1599540 | 1599540 | 2021-08-09 | Lewis | Idaho | 16061 | 466 | 12 |
1601427 | 1601427 | 2021-08-09 | Clark | South Dakota | 46025 | 466 | 5 |
1598179 | 1598179 | 2021-08-08 | Clark | South Dakota | 46025 | 466 | 5 |
1594930 | 1594930 | 2021-08-07 | Clark | South Dakota | 46025 | 466 | 5 |
1591681 | 1591681 | 2021-08-06 | Clark | South Dakota | 46025 | 466 | 5 |
1588432 | 1588432 | 2021-08-05 | Clark | South Dakota | 46025 | 466 | 5 |
1584949 | 1584949 | 2021-08-04 | Harney | Oregon | 41025 | 466 | 11 |
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);