ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
368 rows where cases = 1630 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 35
- Florida 31
- Missouri 25
- Kentucky 24
- Alabama 19
- Tennessee 18
- Montana 17
- Arkansas 15
- Georgia 15
- Puerto Rico 15
- Virginia 15
- Illinois 13
- Oklahoma 12
- Mississippi 11
- North Carolina 10
- Indiana 9
- Iowa 9
- Michigan 8
- West Virginia 7
- Wisconsin 6
- Minnesota 5
- South Dakota 5
- Colorado 4
- Utah 4
- New York 3
- Oregon 3
- Pennsylvania 3
- Wyoming 3
- Alaska 2
- Kansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401298 | 2401298 | 2022-04-12 | Coleman | Texas | 48083 | 1630 | 71 |
2350346 | 2350346 | 2022-03-28 | Treutlen | Georgia | 13283 | 1630 | 60 |
2347093 | 2347093 | 2022-03-27 | Treutlen | Georgia | 13283 | 1630 | 60 |
2343840 | 2343840 | 2022-03-26 | Treutlen | Georgia | 13283 | 1630 | 60 |
2340587 | 2340587 | 2022-03-25 | Treutlen | Georgia | 13283 | 1630 | 60 |
2337334 | 2337334 | 2022-03-24 | Treutlen | Georgia | 13283 | 1630 | 60 |
2217991 | 2217991 | 2022-02-15 | Caldwell | Missouri | 29025 | 1630 | 32 |
2218148 | 2218148 | 2022-02-15 | Valley | Montana | 30105 | 1630 | 35 |
2211496 | 2211496 | 2022-02-13 | Chariton | Missouri | 29041 | 1630 | 34 |
2208243 | 2208243 | 2022-02-12 | Chariton | Missouri | 29041 | 1630 | 34 |
2204990 | 2204990 | 2022-02-11 | Chariton | Missouri | 29041 | 1630 | 34 |
2201737 | 2201737 | 2022-02-10 | Chariton | Missouri | 29041 | 1630 | 34 |
2198483 | 2198483 | 2022-02-09 | Chariton | Missouri | 29041 | 1630 | 34 |
2177303 | 2177303 | 2022-02-02 | Calhoun | West Virginia | 54013 | 1630 | 10 |
2167819 | 2167819 | 2022-01-31 | Dallas | Arkansas | 5039 | 1630 | 22 |
2135178 | 2135178 | 2022-01-21 | Greene | Alabama | 1063 | 1630 | 47 |
2126986 | 2126986 | 2022-01-18 | St. Clair | Missouri | 29185 | 1630 | 29 |
2128585 | 2128585 | 2022-01-18 | Menominee | Wisconsin | 55078 | 1630 | 12 |
2123256 | 2123256 | 2022-01-17 | Wolfe | Kentucky | 21237 | 1630 | 15 |
2120004 | 2120004 | 2022-01-16 | Wolfe | Kentucky | 21237 | 1630 | 15 |
2116752 | 2116752 | 2022-01-15 | Wolfe | Kentucky | 21237 | 1630 | 15 |
2113501 | 2113501 | 2022-01-14 | Wolfe | Kentucky | 21237 | 1630 | 15 |
2103417 | 2103417 | 2022-01-11 | Warren | Indiana | 18171 | 1630 | 22 |
2084733 | 2084733 | 2022-01-05 | Beaverhead | Montana | 30001 | 1630 | 23 |
2062019 | 2062019 | 2021-12-29 | Sanders | Montana | 30089 | 1630 | 40 |
2053276 | 2053276 | 2021-12-26 | Clay | Texas | 48077 | 1630 | 26 |
2050026 | 2050026 | 2021-12-25 | Clay | Texas | 48077 | 1630 | 26 |
2046776 | 2046776 | 2021-12-24 | Clay | Texas | 48077 | 1630 | 26 |
2043526 | 2043526 | 2021-12-23 | Clay | Texas | 48077 | 1630 | 26 |
2043872 | 2043872 | 2021-12-23 | Nelson | Virginia | 51125 | 1630 | 22 |
2028957 | 2028957 | 2021-12-19 | Owen | Kentucky | 21187 | 1630 | 29 |
2025706 | 2025706 | 2021-12-18 | Owen | Kentucky | 21187 | 1630 | 29 |
2022455 | 2022455 | 2021-12-17 | Owen | Kentucky | 21187 | 1630 | 29 |
2018001 | 2018001 | 2021-12-15 | Ritchie | West Virginia | 54085 | 1630 | 24 |
2008520 | 2008520 | 2021-12-13 | Perry | Arkansas | 5105 | 1630 | 23 |
1990591 | 1990591 | 2021-12-07 | Phelps | Nebraska | 31137 | 1630 | 10 |
1986684 | 1986684 | 2021-12-06 | McLean | Kentucky | 21149 | 1630 | 40 |
1975599 | 1975599 | 2021-12-02 | Lexington city | Virginia | 51678 | 1630 | 37 |
1944832 | 1944832 | 2021-11-23 | Tunica | Mississippi | 28143 | 1630 | 39 |
1945344 | 1945344 | 2021-11-23 | Washington | North Carolina | 37187 | 1630 | 37 |
1918055 | 1918055 | 2021-11-15 | Brown | Indiana | 18013 | 1630 | 50 |
1892063 | 1892063 | 2021-11-07 | Crawford | Indiana | 18025 | 1630 | 30 |
1888813 | 1888813 | 2021-11-06 | Crawford | Indiana | 18025 | 1630 | 30 |
1885563 | 1885563 | 2021-11-05 | Crawford | Indiana | 18025 | 1630 | 30 |
1875740 | 1875740 | 2021-11-02 | Jasper | Illinois | 17079 | 1630 | 23 |
1876493 | 1876493 | 2021-11-02 | Rock | Minnesota | 27133 | 1630 | 19 |
1878070 | 1878070 | 2021-11-02 | Franklin city | Virginia | 51620 | 1630 | 44 |
1872491 | 1872491 | 2021-11-01 | Jasper | Illinois | 17079 | 1630 | 23 |
1848323 | 1848323 | 2021-10-24 | Bon Homme | South Dakota | 46009 | 1630 | 29 |
1845016 | 1845016 | 2021-10-23 | Yabucoa | Puerto Rico | 72151 | 1630 | |
1845073 | 1845073 | 2021-10-23 | Bon Homme | South Dakota | 46009 | 1630 | 29 |
1841823 | 1841823 | 2021-10-22 | Bon Homme | South Dakota | 46009 | 1630 | 29 |
1838574 | 1838574 | 2021-10-21 | Bon Homme | South Dakota | 46009 | 1630 | 29 |
1832943 | 1832943 | 2021-10-20 | Northwest Arctic Borough | Alaska | 2188 | 1630 | 7 |
1835325 | 1835325 | 2021-10-20 | Bon Homme | South Dakota | 46009 | 1630 | 29 |
1832857 | 1832857 | 2021-10-19 | Washakie | Wyoming | 56043 | 1630 | 32 |
1811319 | 1811319 | 2021-10-13 | Washington | Maine | 23029 | 1630 | 20 |
1811672 | 1811672 | 2021-10-13 | Lewis | Missouri | 29111 | 1630 | 22 |
1812452 | 1812452 | 2021-10-13 | Aguas Buenas | Puerto Rico | 72007 | 1630 | |
1809203 | 1809203 | 2021-10-12 | Aguas Buenas | Puerto Rico | 72007 | 1630 | |
1809664 | 1809664 | 2021-10-12 | Morris | Texas | 48343 | 1630 | 50 |
1787552 | 1787552 | 2021-10-06 | Stone | Arkansas | 5137 | 1630 | 40 |
1787623 | 1787623 | 2021-10-06 | Bent | Colorado | 8011 | 1630 | 23 |
1782392 | 1782392 | 2021-10-04 | Cedar | Missouri | 29039 | 1630 | 30 |
1782849 | 1782849 | 2021-10-04 | Pamlico | North Carolina | 37137 | 1630 | 20 |
1779142 | 1779142 | 2021-10-03 | Cedar | Missouri | 29039 | 1630 | 30 |
1775892 | 1775892 | 2021-10-02 | Cedar | Missouri | 29039 | 1630 | 30 |
1772642 | 1772642 | 2021-10-01 | Cedar | Missouri | 29039 | 1630 | 30 |
1769299 | 1769299 | 2021-09-30 | Carroll | Mississippi | 28015 | 1630 | 37 |
1769634 | 1769634 | 2021-09-30 | Unknown | Nebraska | 1630 | 148 | |
1766133 | 1766133 | 2021-09-29 | Bollinger | Missouri | 29017 | 1630 | 18 |
1767706 | 1767706 | 2021-09-29 | Klickitat | Washington | 53039 | 1630 | 14 |
1736466 | 1736466 | 2021-09-20 | Martin | Kentucky | 21159 | 1630 | 28 |
1737630 | 1737630 | 2021-09-20 | Hood River | Oregon | 41027 | 1630 | 35 |
1732626 | 1732626 | 2021-09-19 | McIntosh | Georgia | 13191 | 1630 | 24 |
1733204 | 1733204 | 2021-09-19 | Lee | Kentucky | 21129 | 1630 | 29 |
1733235 | 1733235 | 2021-09-19 | Pendleton | Kentucky | 21191 | 1630 | 12 |
1729376 | 1729376 | 2021-09-18 | McIntosh | Georgia | 13191 | 1630 | 24 |
1729954 | 1729954 | 2021-09-18 | Lee | Kentucky | 21129 | 1630 | 29 |
1729985 | 1729985 | 2021-09-18 | Pendleton | Kentucky | 21191 | 1630 | 12 |
1726126 | 1726126 | 2021-09-17 | McIntosh | Georgia | 13191 | 1630 | 24 |
1726704 | 1726704 | 2021-09-17 | Lee | Kentucky | 21129 | 1630 | 29 |
1726735 | 1726735 | 2021-09-17 | Pendleton | Kentucky | 21191 | 1630 | 12 |
1723979 | 1723979 | 2021-09-16 | Ripley | Missouri | 29181 | 1630 | 19 |
1710413 | 1710413 | 2021-09-12 | Breathitt | Kentucky | 21025 | 1630 | 14 |
1707166 | 1707166 | 2021-09-11 | Breathitt | Kentucky | 21025 | 1630 | 14 |
1709261 | 1709261 | 2021-09-11 | Grant | West Virginia | 54023 | 1630 | 30 |
1703918 | 1703918 | 2021-09-10 | Breathitt | Kentucky | 21025 | 1630 | 14 |
1696486 | 1696486 | 2021-09-08 | Kusilvak Census Area | Alaska | 2158 | 1630 | 5 |
1694291 | 1694291 | 2021-09-07 | Catahoula | Louisiana | 22025 | 1630 | 44 |
1695338 | 1695338 | 2021-09-07 | Haskell | Oklahoma | 40061 | 1630 | 20 |
1692090 | 1692090 | 2021-09-06 | Haskell | Oklahoma | 40061 | 1630 | 20 |
1688841 | 1688841 | 2021-09-05 | Haskell | Oklahoma | 40061 | 1630 | 20 |
1685591 | 1685591 | 2021-09-04 | Haskell | Oklahoma | 40061 | 1630 | 20 |
1682340 | 1682340 | 2021-09-03 | Haskell | Oklahoma | 40061 | 1630 | 20 |
1679090 | 1679090 | 2021-09-02 | Haskell | Oklahoma | 40061 | 1630 | 20 |
1675842 | 1675842 | 2021-09-01 | Haskell | Oklahoma | 40061 | 1630 | 20 |
1665551 | 1665551 | 2021-08-29 | Glacier | Montana | 30035 | 1630 | 45 |
1665567 | 1665567 | 2021-08-29 | Park | Montana | 30067 | 1630 | 23 |
1666295 | 1666295 | 2021-08-29 | Loiza | Puerto Rico | 72087 | 1630 |
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);