ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
471 rows where cases = 837 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 47
- Iowa 40
- Georgia 38
- Nebraska 25
- Missouri 23
- South Dakota 20
- Puerto Rico 18
- Kansas 17
- Kentucky 16
- Virginia 15
- Minnesota 14
- Colorado 12
- Arkansas 11
- Indiana 11
- Michigan 11
- Oklahoma 11
- Idaho 9
- North Dakota 9
- North Carolina 8
- Tennessee 8
- Vermont 8
- Wisconsin 8
- Florida 6
- Illinois 6
- Louisiana 6
- Montana 6
- New Mexico 6
- Ohio 6
- Washington 6
- West Virginia 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2278548 | 2278548 | 2022-03-06 | Ouray | Colorado | 8091 | 837 | 6 |
2280125 | 2280125 | 2022-03-06 | Hamilton | New York | 36041 | 837 | 5 |
2275295 | 2275295 | 2022-03-05 | Ouray | Colorado | 8091 | 837 | 6 |
2272042 | 2272042 | 2022-03-04 | Ouray | Colorado | 8091 | 837 | 6 |
2268790 | 2268790 | 2022-03-03 | Ouray | Colorado | 8091 | 837 | 6 |
2269405 | 2269405 | 2022-03-03 | Chautauqua | Kansas | 20019 | 837 | 17 |
2265537 | 2265537 | 2022-03-02 | Ouray | Colorado | 8091 | 837 | 6 |
2266152 | 2266152 | 2022-03-02 | Chautauqua | Kansas | 20019 | 837 | 17 |
2268091 | 2268091 | 2022-03-02 | Sutton | Texas | 48435 | 837 | 12 |
2264838 | 2264838 | 2022-03-01 | Sutton | Texas | 48435 | 837 | 12 |
2261588 | 2261588 | 2022-02-28 | Sutton | Texas | 48435 | 837 | 12 |
2258337 | 2258337 | 2022-02-27 | Sutton | Texas | 48435 | 837 | 12 |
2255086 | 2255086 | 2022-02-26 | Sutton | Texas | 48435 | 837 | 12 |
2251835 | 2251835 | 2022-02-25 | Sutton | Texas | 48435 | 837 | 12 |
2248584 | 2248584 | 2022-02-24 | Sutton | Texas | 48435 | 837 | 12 |
2245333 | 2245333 | 2022-02-23 | Sutton | Texas | 48435 | 837 | 12 |
2084873 | 2084873 | 2022-01-05 | Thayer | Nebraska | 31169 | 837 | 8 |
2085499 | 2085499 | 2022-01-05 | Maunabo | Puerto Rico | 72095 | 837 | |
2057411 | 2057411 | 2021-12-28 | Saguache | Colorado | 8109 | 837 | 9 |
2024275 | 2024275 | 2021-12-17 | Essex | Vermont | 50009 | 837 | 2 |
2012484 | 2012484 | 2021-12-14 | Ringgold | Iowa | 19159 | 837 | 30 |
2009233 | 2009233 | 2021-12-13 | Ringgold | Iowa | 19159 | 837 | 30 |
2005982 | 2005982 | 2021-12-12 | Ringgold | Iowa | 19159 | 837 | 30 |
2002731 | 2002731 | 2021-12-11 | Ringgold | Iowa | 19159 | 837 | 30 |
1999481 | 1999481 | 2021-12-10 | Ringgold | Iowa | 19159 | 837 | 30 |
1996230 | 1996230 | 2021-12-09 | Ringgold | Iowa | 19159 | 837 | 30 |
1997395 | 1997395 | 2021-12-09 | Pierce | North Dakota | 38069 | 837 | 29 |
1992979 | 1992979 | 2021-12-08 | Ringgold | Iowa | 19159 | 837 | 30 |
1994144 | 1994144 | 2021-12-08 | Pierce | North Dakota | 38069 | 837 | 29 |
1990893 | 1990893 | 2021-12-07 | Pierce | North Dakota | 38069 | 837 | 29 |
1987353 | 1987353 | 2021-12-06 | Sheridan | Nebraska | 31161 | 837 | 23 |
1978225 | 1978225 | 2021-12-03 | Lajas | Puerto Rico | 72079 | 837 | |
1974975 | 1974975 | 2021-12-02 | Lajas | Puerto Rico | 72079 | 837 | |
1970392 | 1970392 | 2021-12-01 | Fulton | Kentucky | 21075 | 837 | 21 |
1967071 | 1967071 | 2021-11-30 | Ottawa | Kansas | 20143 | 837 | 14 |
1963819 | 1963819 | 2021-11-29 | Ottawa | Kansas | 20143 | 837 | 14 |
1961296 | 1961296 | 2021-11-28 | Dixon | Nebraska | 31051 | 837 | 11 |
1958045 | 1958045 | 2021-11-27 | Dixon | Nebraska | 31051 | 837 | 11 |
1954794 | 1954794 | 2021-11-26 | Dixon | Nebraska | 31051 | 837 | 11 |
1951543 | 1951543 | 2021-11-25 | Dixon | Nebraska | 31051 | 837 | 11 |
1948292 | 1948292 | 2021-11-24 | Dixon | Nebraska | 31051 | 837 | 11 |
1942607 | 1942607 | 2021-11-22 | Moody | South Dakota | 46101 | 837 | 21 |
1915834 | 1915834 | 2021-11-14 | Pierce | Nebraska | 31139 | 837 | 21 |
1916575 | 1916575 | 2021-11-14 | Day | South Dakota | 46037 | 837 | 30 |
1912584 | 1912584 | 2021-11-13 | Pierce | Nebraska | 31139 | 837 | 21 |
1913325 | 1913325 | 2021-11-13 | Day | South Dakota | 46037 | 837 | 30 |
1909334 | 1909334 | 2021-11-12 | Pierce | Nebraska | 31139 | 837 | 21 |
1910075 | 1910075 | 2021-11-12 | Day | South Dakota | 46037 | 837 | 30 |
1906137 | 1906137 | 2021-11-11 | Unknown | New Hampshire | 837 | 4 | |
1902464 | 1902464 | 2021-11-10 | Lincoln | Minnesota | 27081 | 837 | 5 |
1902888 | 1902888 | 2021-11-10 | Unknown | New Hampshire | 837 | 4 | |
1897377 | 1897377 | 2021-11-08 | Martin | Texas | 48317 | 837 | 24 |
1894127 | 1894127 | 2021-11-07 | Martin | Texas | 48317 | 837 | 24 |
1890877 | 1890877 | 2021-11-06 | Martin | Texas | 48317 | 837 | 24 |
1887627 | 1887627 | 2021-11-05 | Martin | Texas | 48317 | 837 | 24 |
1884066 | 1884066 | 2021-11-04 | Brule | South Dakota | 46015 | 837 | 11 |
1881128 | 1881128 | 2021-11-03 | Martin | Texas | 48317 | 837 | 24 |
1877879 | 1877879 | 2021-11-02 | Martin | Texas | 48317 | 837 | 24 |
1873183 | 1873183 | 2021-11-01 | Big Stone | Minnesota | 27011 | 837 | 5 |
1874630 | 1874630 | 2021-11-01 | Martin | Texas | 48317 | 837 | 24 |
1871381 | 1871381 | 2021-10-31 | Martin | Texas | 48317 | 837 | 24 |
1868132 | 1868132 | 2021-10-30 | Martin | Texas | 48317 | 837 | 24 |
1858382 | 1858382 | 2021-10-27 | Lynn | Texas | 48305 | 837 | 27 |
1855133 | 1855133 | 2021-10-26 | Lynn | Texas | 48305 | 837 | 27 |
1851884 | 1851884 | 2021-10-25 | Lynn | Texas | 48305 | 837 | 27 |
1848634 | 1848634 | 2021-10-24 | Lynn | Texas | 48305 | 837 | 27 |
1845384 | 1845384 | 2021-10-23 | Lynn | Texas | 48305 | 837 | 27 |
1842134 | 1842134 | 2021-10-22 | Lynn | Texas | 48305 | 837 | 27 |
1838885 | 1838885 | 2021-10-21 | Lynn | Texas | 48305 | 837 | 27 |
1833268 | 1833268 | 2021-10-20 | Calhoun | Georgia | 13037 | 837 | 20 |
1830442 | 1830442 | 2021-10-19 | Fremont | Iowa | 19071 | 837 | 11 |
1827193 | 1827193 | 2021-10-18 | Fremont | Iowa | 19071 | 837 | 11 |
1823944 | 1823944 | 2021-10-17 | Fremont | Iowa | 19071 | 837 | 11 |
1820695 | 1820695 | 2021-10-16 | Fremont | Iowa | 19071 | 837 | 11 |
1817446 | 1817446 | 2021-10-15 | Fremont | Iowa | 19071 | 837 | 11 |
1814198 | 1814198 | 2021-10-14 | Fremont | Iowa | 19071 | 837 | 11 |
1810879 | 1810879 | 2021-10-13 | Ohio | Indiana | 18115 | 837 | 12 |
1810949 | 1810949 | 2021-10-13 | Fremont | Iowa | 19071 | 837 | 11 |
1807015 | 1807015 | 2021-10-12 | Lafayette | Arkansas | 5073 | 837 | 25 |
1807630 | 1807630 | 2021-10-12 | Ohio | Indiana | 18115 | 837 | 12 |
1805665 | 1805665 | 2021-10-11 | Sioux | North Dakota | 38085 | 837 | 14 |
1803602 | 1803602 | 2021-10-10 | Hot Springs | Wyoming | 56017 | 837 | 8 |
1800353 | 1800353 | 2021-10-09 | Hot Springs | Wyoming | 56017 | 837 | 8 |
1797104 | 1797104 | 2021-10-08 | Hot Springs | Wyoming | 56017 | 837 | 8 |
1770667 | 1770667 | 2021-09-30 | Mills | Texas | 48333 | 837 | 26 |
1766452 | 1766452 | 2021-09-29 | Guadalupe | New Mexico | 35019 | 837 | 15 |
1763203 | 1763203 | 2021-09-28 | Guadalupe | New Mexico | 35019 | 837 | 15 |
1746380 | 1746380 | 2021-09-23 | Alger | Michigan | 26003 | 837 | 7 |
1743131 | 1743131 | 2021-09-22 | Alger | Michigan | 26003 | 837 | 7 |
1739505 | 1739505 | 2021-09-21 | Osceola | Iowa | 19143 | 837 | 17 |
1736256 | 1736256 | 2021-09-20 | Osceola | Iowa | 19143 | 837 | 17 |
1733006 | 1733006 | 2021-09-19 | Osceola | Iowa | 19143 | 837 | 17 |
1733973 | 1733973 | 2021-09-19 | Quay | New Mexico | 35037 | 837 | 13 |
1729756 | 1729756 | 2021-09-18 | Osceola | Iowa | 19143 | 837 | 17 |
1730723 | 1730723 | 2021-09-18 | Quay | New Mexico | 35037 | 837 | 13 |
1726506 | 1726506 | 2021-09-17 | Osceola | Iowa | 19143 | 837 | 17 |
1727473 | 1727473 | 2021-09-17 | Quay | New Mexico | 35037 | 837 | 13 |
1723257 | 1723257 | 2021-09-16 | Osceola | Iowa | 19143 | 837 | 17 |
1720008 | 1720008 | 2021-09-15 | Osceola | Iowa | 19143 | 837 | 17 |
1720805 | 1720805 | 2021-09-15 | Toole | Montana | 30101 | 837 | 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);