ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
619 rows where cases = 472 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 45
- Nebraska 38
- Georgia 37
- Missouri 34
- South Dakota 25
- Illinois 22
- Kansas 22
- Kentucky 18
- Oregon 18
- Virginia 17
- Idaho 16
- Indiana 16
- Michigan 16
- North Dakota 16
- Oklahoma 16
- Puerto Rico 16
- California 15
- Alabama 14
- Arkansas 14
- Colorado 14
- Mississippi 14
- Ohio 13
- Iowa 12
- Minnesota 12
- New Mexico 10
- Nevada 9
- Pennsylvania 9
- Wisconsin 9
- Wyoming 9
- North Carolina 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2278349 | 2278349 | 2022-03-06 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 472 | 5 |
2275096 | 2275096 | 2022-03-05 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 472 | 5 |
2271843 | 2271843 | 2022-03-04 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 472 | 5 |
2260766 | 2260766 | 2022-02-28 | Golden Valley | North Dakota | 38033 | 472 | 4 |
2223552 | 2223552 | 2022-02-17 | Butte | Idaho | 16023 | 472 | 8 |
2220301 | 2220301 | 2022-02-16 | Butte | Idaho | 16023 | 472 | 8 |
2217050 | 2217050 | 2022-02-15 | Butte | Idaho | 16023 | 472 | 8 |
2213799 | 2213799 | 2022-02-14 | Butte | Idaho | 16023 | 472 | 8 |
2173732 | 2173732 | 2022-02-01 | Menard | Texas | 48327 | 472 | 12 |
2169717 | 2169717 | 2022-01-31 | Kidder | North Dakota | 38043 | 472 | 13 |
2167068 | 2167068 | 2022-01-30 | Armstrong | Texas | 48011 | 472 | 8 |
2163813 | 2163813 | 2022-01-29 | Armstrong | Texas | 48011 | 472 | 8 |
2155668 | 2155668 | 2022-01-27 | Wichita | Kansas | 20203 | 472 | 8 |
2156349 | 2156349 | 2022-01-27 | Brown | Nebraska | 31017 | 472 | 4 |
2152415 | 2152415 | 2022-01-26 | Wichita | Kansas | 20203 | 472 | 8 |
2152760 | 2152760 | 2022-01-26 | Cook | Minnesota | 27031 | 472 | 2 |
2149879 | 2149879 | 2022-01-25 | Hitchcock | Nebraska | 31087 | 472 | 6 |
2110815 | 2110815 | 2022-01-13 | Cherry | Nebraska | 31031 | 472 | 8 |
2107564 | 2107564 | 2022-01-12 | Cherry | Nebraska | 31031 | 472 | 8 |
2099633 | 2099633 | 2022-01-10 | Costilla | Colorado | 8023 | 472 | 14 |
2101874 | 2101874 | 2022-01-10 | Jackson | South Dakota | 46071 | 472 | 19 |
2095597 | 2095597 | 2022-01-08 | Hardeman | Texas | 48197 | 472 | 14 |
2088856 | 2088856 | 2022-01-06 | Faulk | South Dakota | 46049 | 472 | 16 |
2088888 | 2088888 | 2022-01-06 | Sanborn | South Dakota | 46111 | 472 | 4 |
2085605 | 2085605 | 2022-01-05 | Faulk | South Dakota | 46049 | 472 | 16 |
2082353 | 2082353 | 2022-01-04 | Faulk | South Dakota | 46049 | 472 | 16 |
2075196 | 2075196 | 2022-01-02 | Mora | New Mexico | 35033 | 472 | 14 |
2071945 | 2071945 | 2022-01-01 | Mora | New Mexico | 35033 | 472 | 14 |
2068694 | 2068694 | 2021-12-31 | Mora | New Mexico | 35033 | 472 | 14 |
2068867 | 2068867 | 2021-12-31 | Adams | North Dakota | 38001 | 472 | 8 |
2065443 | 2065443 | 2021-12-30 | Mora | New Mexico | 35033 | 472 | 14 |
2063281 | 2063281 | 2021-12-29 | Unknown | Vermont | 472 | 0 | |
2053700 | 2053700 | 2021-12-26 | San Juan | Washington | 53055 | 472 | 0 |
2050450 | 2050450 | 2021-12-25 | San Juan | Washington | 53055 | 472 | 0 |
2047200 | 2047200 | 2021-12-24 | San Juan | Washington | 53055 | 472 | 0 |
2043950 | 2043950 | 2021-12-23 | San Juan | Washington | 53055 | 472 | 0 |
2026973 | 2026973 | 2021-12-18 | Guanica | Puerto Rico | 72055 | 472 | |
2019702 | 2019702 | 2021-12-16 | Scotland | Missouri | 29199 | 472 | 15 |
2007578 | 2007578 | 2021-12-12 | Buffalo | South Dakota | 46017 | 472 | 16 |
2004327 | 2004327 | 2021-12-11 | Buffalo | South Dakota | 46017 | 472 | 16 |
2001076 | 2001076 | 2021-12-10 | Buffalo | South Dakota | 46017 | 472 | 16 |
1997826 | 1997826 | 2021-12-09 | Buffalo | South Dakota | 46017 | 472 | 16 |
1994575 | 1994575 | 2021-12-08 | Buffalo | South Dakota | 46017 | 472 | 16 |
1989111 | 1989111 | 2021-12-07 | Custer | Colorado | 8027 | 472 | 12 |
1991324 | 1991324 | 2021-12-07 | Buffalo | South Dakota | 46017 | 472 | 16 |
1977416 | 1977416 | 2021-12-03 | Mercer | Missouri | 29129 | 472 | 9 |
1974166 | 1974166 | 2021-12-02 | Mercer | Missouri | 29129 | 472 | 9 |
1940085 | 1940085 | 2021-11-21 | Niobrara | Wyoming | 56027 | 472 | 7 |
1936835 | 1936835 | 2021-11-20 | Niobrara | Wyoming | 56027 | 472 | 7 |
1933585 | 1933585 | 2021-11-19 | Niobrara | Wyoming | 56027 | 472 | 7 |
1930333 | 1930333 | 2021-11-18 | Niobrara | Wyoming | 56027 | 472 | 7 |
1899713 | 1899713 | 2021-11-09 | Hamilton | New York | 36041 | 472 | 3 |
1881181 | 1881181 | 2021-11-03 | Shackelford | Texas | 48417 | 472 | 5 |
1861319 | 1861319 | 2021-10-28 | Bennett | South Dakota | 46007 | 472 | 9 |
1858070 | 1858070 | 2021-10-27 | Bennett | South Dakota | 46007 | 472 | 9 |
1853284 | 1853284 | 2021-10-26 | Gove | Kansas | 20063 | 472 | 22 |
1850035 | 1850035 | 2021-10-25 | Gove | Kansas | 20063 | 472 | 22 |
1806954 | 1806954 | 2021-10-12 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 472 | 5 |
1807862 | 1807862 | 2021-10-12 | Trego | Kansas | 20195 | 472 | 8 |
1804176 | 1804176 | 2021-10-11 | Adams | Idaho | 16003 | 472 | 7 |
1804611 | 1804611 | 2021-10-11 | Trego | Kansas | 20195 | 472 | 8 |
1800927 | 1800927 | 2021-10-10 | Adams | Idaho | 16003 | 472 | 7 |
1801362 | 1801362 | 2021-10-10 | Trego | Kansas | 20195 | 472 | 8 |
1798113 | 1798113 | 2021-10-09 | Trego | Kansas | 20195 | 472 | 8 |
1794864 | 1794864 | 2021-10-08 | Trego | Kansas | 20195 | 472 | 8 |
1791586 | 1791586 | 2021-10-07 | Ness | Kansas | 20135 | 472 | 17 |
1788337 | 1788337 | 2021-10-06 | Ness | Kansas | 20135 | 472 | 17 |
1786304 | 1786304 | 2021-10-05 | Harper | Oklahoma | 40059 | 472 | 8 |
1783055 | 1783055 | 2021-10-04 | Harper | Oklahoma | 40059 | 472 | 8 |
1779806 | 1779806 | 2021-10-03 | Harper | Oklahoma | 40059 | 472 | 8 |
1776556 | 1776556 | 2021-10-02 | Harper | Oklahoma | 40059 | 472 | 8 |
1773306 | 1773306 | 2021-10-01 | Harper | Oklahoma | 40059 | 472 | 8 |
1770056 | 1770056 | 2021-09-30 | Harper | Oklahoma | 40059 | 472 | 8 |
1766807 | 1766807 | 2021-09-29 | Harper | Oklahoma | 40059 | 472 | 8 |
1732815 | 1732815 | 2021-09-19 | Pope | Illinois | 17151 | 472 | 5 |
1733984 | 1733984 | 2021-09-19 | Union | New Mexico | 35059 | 472 | 10 |
1729565 | 1729565 | 2021-09-18 | Pope | Illinois | 17151 | 472 | 5 |
1730734 | 1730734 | 2021-09-18 | Union | New Mexico | 35059 | 472 | 10 |
1726315 | 1726315 | 2021-09-17 | Pope | Illinois | 17151 | 472 | 5 |
1727484 | 1727484 | 2021-09-17 | Union | New Mexico | 35059 | 472 | 10 |
1723779 | 1723779 | 2021-09-16 | Red Lake | Minnesota | 27125 | 472 | 7 |
1724034 | 1724034 | 2021-09-16 | Mineral | Montana | 30061 | 472 | 9 |
1720315 | 1720315 | 2021-09-15 | Tensas | Louisiana | 22107 | 472 | 8 |
1714195 | 1714195 | 2021-09-13 | Knox | Missouri | 29103 | 472 | 3 |
1710949 | 1710949 | 2021-09-12 | Knox | Missouri | 29103 | 472 | 3 |
1698420 | 1698420 | 2021-09-08 | Cavalier | North Dakota | 38019 | 472 | 5 |
1699221 | 1699221 | 2021-09-08 | Reagan | Texas | 48383 | 472 | 9 |
1679875 | 1679875 | 2021-09-02 | Falls Church city | Virginia | 51610 | 472 | 8 |
1670978 | 1670978 | 2021-08-31 | Boise | Idaho | 16015 | 472 | 4 |
1666988 | 1666988 | 2021-08-29 | Ferry | Washington | 53019 | 472 | 9 |
1667024 | 1667024 | 2021-08-29 | Calhoun | West Virginia | 54013 | 472 | 1 |
1663740 | 1663740 | 2021-08-28 | Ferry | Washington | 53019 | 472 | 9 |
1660492 | 1660492 | 2021-08-27 | Ferry | Washington | 53019 | 472 | 9 |
1649698 | 1649698 | 2021-08-24 | Eddy | North Dakota | 38027 | 472 | 6 |
1647479 | 1647479 | 2021-08-23 | Surry | Virginia | 51181 | 472 | 9 |
1625212 | 1625212 | 2021-08-17 | Huerfano | Colorado | 8055 | 472 | 18 |
1597946 | 1597946 | 2021-08-08 | Harney | Oregon | 41025 | 472 | 11 |
1594697 | 1594697 | 2021-08-07 | Harney | Oregon | 41025 | 472 | 11 |
1591448 | 1591448 | 2021-08-06 | Harney | Oregon | 41025 | 472 | 11 |
1573078 | 1573078 | 2021-08-01 | Calhoun | Arkansas | 5013 | 472 | 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);