ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
519 rows where cases = 865 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 44
- Georgia 33
- Kansas 27
- Iowa 26
- Missouri 25
- Virginia 23
- North Carolina 20
- Arkansas 19
- Louisiana 19
- Minnesota 19
- Ohio 19
- Nebraska 17
- Colorado 16
- Puerto Rico 16
- Alabama 14
- Indiana 14
- Kentucky 13
- Montana 13
- Idaho 11
- Michigan 11
- California 9
- Washington 8
- West Virginia 8
- Mississippi 7
- North Dakota 7
- Oklahoma 7
- Tennessee 7
- Florida 6
- Illinois 6
- South Carolina 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444499 | 2444499 | 2022-04-26 | Ouray | Colorado | 8091 | 865 | 6 |
2335419 | 2335419 | 2022-03-23 | Hamilton | New York | 36041 | 865 | 5 |
2314125 | 2314125 | 2022-03-17 | Unknown | American Samoa | 865 | 0 | |
2263714 | 2263714 | 2022-03-01 | Johnson | Nebraska | 31097 | 865 | 10 |
2260463 | 2260463 | 2022-02-28 | Johnson | Nebraska | 31097 | 865 | 10 |
2242155 | 2242155 | 2022-02-22 | Grand Isle | Vermont | 50013 | 865 | 4 |
2171531 | 2171531 | 2022-02-01 | Lincoln | Idaho | 16063 | 865 | 14 |
2157560 | 2157560 | 2022-01-27 | Garfield | Utah | 49017 | 865 | 12 |
2148471 | 2148471 | 2022-01-25 | Washington | Colorado | 8121 | 865 | 26 |
2150159 | 2150159 | 2022-01-25 | Tyrrell | North Carolina | 37177 | 865 | 7 |
2145182 | 2145182 | 2022-01-24 | Gilpin | Colorado | 8047 | 865 | 4 |
2146498 | 2146498 | 2022-01-24 | Putnam | Missouri | 29171 | 865 | 20 |
2143432 | 2143432 | 2022-01-23 | Lincoln | Nevada | 32017 | 865 | 5 |
2140177 | 2140177 | 2022-01-22 | Lincoln | Nevada | 32017 | 865 | 5 |
2136921 | 2136921 | 2022-01-21 | Lincoln | Nevada | 32017 | 865 | 5 |
2121934 | 2121934 | 2022-01-16 | Surry | Virginia | 51181 | 865 | 13 |
2118682 | 2118682 | 2022-01-15 | Surry | Virginia | 51181 | 865 | 13 |
2115430 | 2115430 | 2022-01-14 | Surry | Virginia | 51181 | 865 | 13 |
2111861 | 2111861 | 2022-01-13 | Hemphill | Texas | 48211 | 865 | 3 |
2096645 | 2096645 | 2022-01-09 | Talbot | Georgia | 13263 | 865 | 30 |
2093393 | 2093393 | 2022-01-08 | Talbot | Georgia | 13263 | 865 | 30 |
2090141 | 2090141 | 2022-01-07 | Talbot | Georgia | 13263 | 865 | 30 |
2086890 | 2086890 | 2022-01-06 | Talbot | Georgia | 13263 | 865 | 30 |
2083638 | 2083638 | 2022-01-05 | Talbot | Georgia | 13263 | 865 | 30 |
2084794 | 2084794 | 2022-01-05 | Boone | Nebraska | 31011 | 865 | 4 |
2080454 | 2080454 | 2022-01-04 | Lewis | Idaho | 16061 | 865 | 23 |
2060024 | 2060024 | 2021-12-28 | Essex | Vermont | 50009 | 865 | 2 |
2055880 | 2055880 | 2021-12-27 | Dunn | North Dakota | 38025 | 865 | 7 |
2056775 | 2056775 | 2021-12-27 | Essex | Vermont | 50009 | 865 | 2 |
2052630 | 2052630 | 2021-12-26 | Dunn | North Dakota | 38025 | 865 | 7 |
2036868 | 2036868 | 2021-12-21 | Lyman | South Dakota | 46085 | 865 | 12 |
2032152 | 2032152 | 2021-12-20 | Fulton | Kentucky | 21075 | 865 | 22 |
2010130 | 2010130 | 2021-12-13 | Lander | Nevada | 32015 | 865 | 16 |
1997308 | 1997308 | 2021-12-09 | Hyde | North Carolina | 37095 | 865 | 12 |
1994057 | 1994057 | 2021-12-08 | Hyde | North Carolina | 37095 | 865 | 12 |
1989985 | 1989985 | 2021-12-07 | Cameron | Louisiana | 22023 | 865 | 9 |
1990352 | 1990352 | 2021-12-07 | Atchison | Missouri | 29005 | 865 | 17 |
1990806 | 1990806 | 2021-12-07 | Hyde | North Carolina | 37095 | 865 | 12 |
1986735 | 1986735 | 2021-12-06 | Cameron | Louisiana | 22023 | 865 | 9 |
1983485 | 1983485 | 2021-12-05 | Cameron | Louisiana | 22023 | 865 | 9 |
1985133 | 1985133 | 2021-12-05 | Martin | Texas | 48317 | 865 | 24 |
1980235 | 1980235 | 2021-12-04 | Cameron | Louisiana | 22023 | 865 | 9 |
1976985 | 1976985 | 2021-12-03 | Cameron | Louisiana | 22023 | 865 | 9 |
1973736 | 1973736 | 2021-12-02 | Cameron | Louisiana | 22023 | 865 | 9 |
1970486 | 1970486 | 2021-12-01 | Cameron | Louisiana | 22023 | 865 | 9 |
1967236 | 1967236 | 2021-11-30 | Cameron | Louisiana | 22023 | 865 | 9 |
1963984 | 1963984 | 2021-11-29 | Cameron | Louisiana | 22023 | 865 | 9 |
1961250 | 1961250 | 2021-11-28 | Phillips | Montana | 30071 | 865 | 28 |
1957999 | 1957999 | 2021-11-27 | Phillips | Montana | 30071 | 865 | 28 |
1954748 | 1954748 | 2021-11-26 | Phillips | Montana | 30071 | 865 | 28 |
1951497 | 1951497 | 2021-11-25 | Phillips | Montana | 30071 | 865 | 28 |
1948246 | 1948246 | 2021-11-24 | Phillips | Montana | 30071 | 865 | 28 |
1928051 | 1928051 | 2021-11-18 | Mitchell | Kansas | 20123 | 865 | 17 |
1924801 | 1924801 | 2021-11-17 | Mitchell | Kansas | 20123 | 865 | 17 |
1926913 | 1926913 | 2021-11-17 | Ferry | Washington | 53019 | 865 | 15 |
1915812 | 1915812 | 2021-11-14 | Jefferson | Nebraska | 31095 | 865 | 3 |
1912562 | 1912562 | 2021-11-13 | Jefferson | Nebraska | 31095 | 865 | 3 |
1909312 | 1909312 | 2021-11-12 | Jefferson | Nebraska | 31095 | 865 | 3 |
1910746 | 1910746 | 2021-11-12 | Wirt | West Virginia | 54105 | 865 | 13 |
1898732 | 1898732 | 2021-11-09 | Van Buren | Iowa | 19177 | 865 | 21 |
1900246 | 1900246 | 2021-11-09 | Santa Isabel | Puerto Rico | 72133 | 865 | |
1895482 | 1895482 | 2021-11-08 | Van Buren | Iowa | 19177 | 865 | 21 |
1896996 | 1896996 | 2021-11-08 | Santa Isabel | Puerto Rico | 72133 | 865 | |
1891933 | 1891933 | 2021-11-07 | Lemhi | Idaho | 16059 | 865 | 19 |
1892232 | 1892232 | 2021-11-07 | Van Buren | Iowa | 19177 | 865 | 21 |
1892699 | 1892699 | 2021-11-07 | Grant | Minnesota | 27051 | 865 | 9 |
1893746 | 1893746 | 2021-11-07 | Santa Isabel | Puerto Rico | 72133 | 865 | |
1888683 | 1888683 | 2021-11-06 | Lemhi | Idaho | 16059 | 865 | 19 |
1888982 | 1888982 | 2021-11-06 | Van Buren | Iowa | 19177 | 865 | 21 |
1889449 | 1889449 | 2021-11-06 | Grant | Minnesota | 27051 | 865 | 9 |
1885433 | 1885433 | 2021-11-05 | Lemhi | Idaho | 16059 | 865 | 19 |
1885732 | 1885732 | 2021-11-05 | Van Buren | Iowa | 19177 | 865 | 21 |
1886199 | 1886199 | 2021-11-05 | Grant | Minnesota | 27051 | 865 | 9 |
1882359 | 1882359 | 2021-11-04 | Ohio | Indiana | 18115 | 865 | 13 |
1882483 | 1882483 | 2021-11-04 | Van Buren | Iowa | 19177 | 865 | 21 |
1883261 | 1883261 | 2021-11-04 | Teton | Montana | 30099 | 865 | 13 |
1879234 | 1879234 | 2021-11-03 | Van Buren | Iowa | 19177 | 865 | 21 |
1871392 | 1871392 | 2021-10-31 | Mills | Texas | 48333 | 865 | 27 |
1868143 | 1868143 | 2021-10-30 | Mills | Texas | 48333 | 865 | 27 |
1861530 | 1861530 | 2021-10-28 | Crane | Texas | 48103 | 865 | 18 |
1858281 | 1858281 | 2021-10-27 | Crane | Texas | 48103 | 865 | 18 |
1853882 | 1853882 | 2021-10-26 | Dade | Missouri | 29057 | 865 | 17 |
1855032 | 1855032 | 2021-10-26 | Crane | Texas | 48103 | 865 | 18 |
1850633 | 1850633 | 2021-10-25 | Dade | Missouri | 29057 | 865 | 17 |
1847383 | 1847383 | 2021-10-24 | Dade | Missouri | 29057 | 865 | 17 |
1844133 | 1844133 | 2021-10-23 | Dade | Missouri | 29057 | 865 | 17 |
1844655 | 1844655 | 2021-10-23 | Sioux | North Dakota | 38085 | 865 | 15 |
1840883 | 1840883 | 2021-10-22 | Dade | Missouri | 29057 | 865 | 17 |
1837634 | 1837634 | 2021-10-21 | Dade | Missouri | 29057 | 865 | 17 |
1834385 | 1834385 | 2021-10-20 | Dade | Missouri | 29057 | 865 | 17 |
1831136 | 1831136 | 2021-10-19 | Dade | Missouri | 29057 | 865 | 17 |
1832789 | 1832789 | 2021-10-19 | Iron | Wisconsin | 55051 | 865 | 42 |
1827887 | 1827887 | 2021-10-18 | Dade | Missouri | 29057 | 865 | 17 |
1824638 | 1824638 | 2021-10-17 | Dade | Missouri | 29057 | 865 | 17 |
1813377 | 1813377 | 2021-10-14 | Choctaw | Alabama | 1023 | 865 | 27 |
1814341 | 1814341 | 2021-10-14 | Republic | Kansas | 20157 | 865 | 15 |
1811092 | 1811092 | 2021-10-13 | Republic | Kansas | 20157 | 865 | 15 |
1784992 | 1784992 | 2021-10-05 | Osceola | Iowa | 19143 | 865 | 17 |
1781743 | 1781743 | 2021-10-04 | Osceola | Iowa | 19143 | 865 | 17 |
1778493 | 1778493 | 2021-10-03 | Osceola | Iowa | 19143 | 865 | 17 |
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);