ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
421 rows where cases = 874 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 57
- Virginia 34
- Georgia 32
- Missouri 23
- Puerto Rico 21
- Louisiana 20
- Idaho 15
- Nebraska 15
- Kansas 13
- Minnesota 13
- Arkansas 12
- Tennessee 12
- Illinois 10
- Kentucky 9
- New York 9
- North Carolina 9
- West Virginia 9
- Colorado 8
- Michigan 8
- Mississippi 8
- Iowa 7
- Montana 7
- Wyoming 7
- Alabama 6
- South Carolina 6
- Ohio 5
- Vermont 5
- North Dakota 4
- Oklahoma 4
- Delaware 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486835 | 2486835 | 2022-05-09 | Ouray | Colorado | 8091 | 874 | 6 |
2470576 | 2470576 | 2022-05-04 | Unknown | Delaware | 874 | 0 | |
2467320 | 2467320 | 2022-05-03 | Unknown | Delaware | 874 | 0 | |
2397242 | 2397242 | 2022-04-11 | Hamilton | New York | 36041 | 874 | 5 |
2393987 | 2393987 | 2022-04-10 | Hamilton | New York | 36041 | 874 | 5 |
2390731 | 2390731 | 2022-04-09 | Hamilton | New York | 36041 | 874 | 5 |
2387475 | 2387475 | 2022-04-08 | Hamilton | New York | 36041 | 874 | 5 |
2384220 | 2384220 | 2022-04-07 | Hamilton | New York | 36041 | 874 | 5 |
2356614 | 2356614 | 2022-03-30 | Phillips | Colorado | 8095 | 874 | 18 |
2214949 | 2214949 | 2022-02-14 | Johnson | Nebraska | 31097 | 874 | 10 |
2211697 | 2211697 | 2022-02-13 | Johnson | Nebraska | 31097 | 874 | 10 |
2208444 | 2208444 | 2022-02-12 | Johnson | Nebraska | 31097 | 874 | 10 |
2205191 | 2205191 | 2022-02-11 | Johnson | Nebraska | 31097 | 874 | 10 |
2187793 | 2187793 | 2022-02-06 | Lincoln | Idaho | 16063 | 874 | 14 |
2184540 | 2184540 | 2022-02-05 | Lincoln | Idaho | 16063 | 874 | 14 |
2151686 | 2151686 | 2022-01-26 | Gilpin | Colorado | 8047 | 874 | 4 |
2151978 | 2151978 | 2022-01-26 | Bear Lake | Idaho | 16007 | 874 | 15 |
2147654 | 2147654 | 2022-01-24 | Hudspeth | Texas | 48229 | 874 | 16 |
2141979 | 2141979 | 2022-01-23 | Unknown | Delaware | 874 | 0 | |
2109694 | 2109694 | 2022-01-13 | Boise | Idaho | 16015 | 874 | 11 |
2111612 | 2111612 | 2022-01-13 | Deuel | South Dakota | 46039 | 874 | 12 |
2104299 | 2104299 | 2022-01-11 | Antelope | Nebraska | 31003 | 874 | 12 |
2101434 | 2101434 | 2022-01-10 | Wells | North Dakota | 38103 | 874 | 11 |
2097487 | 2097487 | 2022-01-09 | Kittson | Minnesota | 27069 | 874 | 25 |
2098183 | 2098183 | 2022-01-09 | Wells | North Dakota | 38103 | 874 | 11 |
2094235 | 2094235 | 2022-01-08 | Kittson | Minnesota | 27069 | 874 | 25 |
2090983 | 2090983 | 2022-01-07 | Kittson | Minnesota | 27069 | 874 | 25 |
2087732 | 2087732 | 2022-01-06 | Kittson | Minnesota | 27069 | 874 | 25 |
2078331 | 2078331 | 2022-01-03 | Howard | Nebraska | 31093 | 874 | 15 |
2076277 | 2076277 | 2022-01-02 | Essex | Vermont | 50009 | 874 | 3 |
2073026 | 2073026 | 2022-01-01 | Essex | Vermont | 50009 | 874 | 3 |
2069775 | 2069775 | 2021-12-31 | Essex | Vermont | 50009 | 874 | 3 |
2066524 | 2066524 | 2021-12-30 | Essex | Vermont | 50009 | 874 | 3 |
2057748 | 2057748 | 2021-12-28 | Henderson | Illinois | 17071 | 874 | 24 |
2038746 | 2038746 | 2021-12-22 | Cameron | Louisiana | 22023 | 874 | 8 |
2035496 | 2035496 | 2021-12-21 | Cameron | Louisiana | 22023 | 874 | 8 |
2032246 | 2032246 | 2021-12-20 | Cameron | Louisiana | 22023 | 874 | 8 |
2028493 | 2028493 | 2021-12-19 | Gallatin | Illinois | 17059 | 874 | 11 |
2028995 | 2028995 | 2021-12-19 | Cameron | Louisiana | 22023 | 874 | 8 |
2025242 | 2025242 | 2021-12-18 | Gallatin | Illinois | 17059 | 874 | 11 |
2025744 | 2025744 | 2021-12-18 | Cameron | Louisiana | 22023 | 874 | 8 |
2021991 | 2021991 | 2021-12-17 | Gallatin | Illinois | 17059 | 874 | 11 |
2022493 | 2022493 | 2021-12-17 | Cameron | Louisiana | 22023 | 874 | 8 |
2019242 | 2019242 | 2021-12-16 | Cameron | Louisiana | 22023 | 874 | 8 |
2008965 | 2008965 | 2021-12-13 | Calhoun | Illinois | 17013 | 874 | 5 |
2006074 | 2006074 | 2021-12-12 | Ottawa | Kansas | 20143 | 874 | 15 |
2002823 | 2002823 | 2021-12-11 | Ottawa | Kansas | 20143 | 874 | 15 |
1999573 | 1999573 | 2021-12-10 | Ottawa | Kansas | 20143 | 874 | 15 |
1994885 | 1994885 | 2021-12-08 | Martin | Texas | 48317 | 874 | 24 |
1991645 | 1991645 | 2021-12-07 | Mills | Texas | 48333 | 874 | 28 |
1991923 | 1991923 | 2021-12-07 | Ferry | Washington | 53019 | 874 | 17 |
1988394 | 1988394 | 2021-12-06 | Mills | Texas | 48333 | 874 | 28 |
1985144 | 1985144 | 2021-12-05 | Mills | Texas | 48333 | 874 | 28 |
1981880 | 1981880 | 2021-12-04 | Lynn | Texas | 48305 | 874 | 27 |
1981894 | 1981894 | 2021-12-04 | Mills | Texas | 48333 | 874 | 28 |
1967471 | 1967471 | 2021-11-30 | Lincoln | Minnesota | 27081 | 874 | 5 |
1944034 | 1944034 | 2021-11-23 | Stark | Illinois | 17175 | 874 | 29 |
1929493 | 1929493 | 2021-11-18 | Santa Isabel | Puerto Rico | 72133 | 874 | |
1926243 | 1926243 | 2021-11-17 | Santa Isabel | Puerto Rico | 72133 | 874 | |
1920496 | 1920496 | 2021-11-15 | Wirt | West Virginia | 54105 | 874 | 13 |
1899372 | 1899372 | 2021-11-09 | Dade | Missouri | 29057 | 874 | 17 |
1896122 | 1896122 | 2021-11-08 | Dade | Missouri | 29057 | 874 | 17 |
1896214 | 1896214 | 2021-11-08 | Broadwater | Montana | 30007 | 874 | 17 |
1892872 | 1892872 | 2021-11-07 | Dade | Missouri | 29057 | 874 | 17 |
1889622 | 1889622 | 2021-11-06 | Dade | Missouri | 29057 | 874 | 17 |
1886372 | 1886372 | 2021-11-05 | Dade | Missouri | 29057 | 874 | 17 |
1883422 | 1883422 | 2021-11-04 | Guadalupe | New Mexico | 35019 | 874 | 15 |
1879874 | 1879874 | 2021-11-03 | Dade | Missouri | 29057 | 874 | 17 |
1878333 | 1878333 | 2021-11-02 | Hot Springs | Wyoming | 56017 | 874 | 9 |
1875084 | 1875084 | 2021-11-01 | Hot Springs | Wyoming | 56017 | 874 | 9 |
1857653 | 1857653 | 2021-10-27 | Sioux | North Dakota | 38085 | 874 | 16 |
1852338 | 1852338 | 2021-10-25 | Crook | Wyoming | 56011 | 874 | 18 |
1827731 | 1827731 | 2021-10-18 | Mahnomen | Minnesota | 27087 | 874 | 12 |
1826117 | 1826117 | 2021-10-17 | Mathews | Virginia | 51115 | 874 | 20 |
1822868 | 1822868 | 2021-10-16 | Mathews | Virginia | 51115 | 874 | 20 |
1819619 | 1819619 | 2021-10-15 | Mathews | Virginia | 51115 | 874 | 20 |
1816108 | 1816108 | 2021-10-14 | Jack | Texas | 48237 | 874 | 20 |
1789106 | 1789106 | 2021-10-06 | Nemaha | Nebraska | 31127 | 874 | 15 |
1766348 | 1766348 | 2021-09-29 | Keith | Nebraska | 31101 | 874 | 10 |
1766371 | 1766371 | 2021-09-29 | Richardson | Nebraska | 31147 | 874 | 24 |
1763099 | 1763099 | 2021-09-28 | Keith | Nebraska | 31101 | 874 | 10 |
1756565 | 1756565 | 2021-09-26 | Cedar | Nebraska | 31027 | 874 | 11 |
1753317 | 1753317 | 2021-09-25 | Cedar | Nebraska | 31027 | 874 | 11 |
1754381 | 1754381 | 2021-09-25 | Jim Hogg | Texas | 48247 | 874 | 20 |
1750069 | 1750069 | 2021-09-24 | Cedar | Nebraska | 31027 | 874 | 11 |
1745707 | 1745707 | 2021-09-23 | Caribou | Idaho | 16029 | 874 | 14 |
1738581 | 1738581 | 2021-09-20 | Menominee | Wisconsin | 55078 | 874 | 11 |
1692722 | 1692722 | 2021-09-06 | Presidio | Texas | 48377 | 874 | 25 |
1688253 | 1688253 | 2021-09-05 | Shannon | Missouri | 29203 | 874 | 15 |
1685003 | 1685003 | 2021-09-04 | Shannon | Missouri | 29203 | 874 | 15 |
1682938 | 1682938 | 2021-09-03 | Marion | Texas | 48315 | 874 | 35 |
1683301 | 1683301 | 2021-09-03 | Roane | West Virginia | 54087 | 874 | 10 |
1676994 | 1676994 | 2021-09-02 | Northwest Arctic Borough | Alaska | 2188 | 874 | 3 |
1678321 | 1678321 | 2021-09-02 | Wilkin | Minnesota | 27167 | 874 | 14 |
1672055 | 1672055 | 2021-08-31 | Madison | Montana | 30057 | 874 | 8 |
1657046 | 1657046 | 2021-08-26 | Winkler | Texas | 48495 | 874 | 23 |
1653982 | 1653982 | 2021-08-25 | Williamsburg city | Virginia | 51830 | 874 | 14 |
1649296 | 1649296 | 2021-08-24 | Blaine | Montana | 30005 | 874 | 24 |
1634098 | 1634098 | 2021-08-19 | Coleman | Texas | 48083 | 874 | 36 |
1621971 | 1621971 | 2021-08-16 | Lake | Colorado | 8065 | 874 | 1 |
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);