ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
449 rows where cases = 725 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 32
- Texas 32
- Virginia 23
- West Virginia 23
- Georgia 22
- Nebraska 20
- Missouri 19
- Mississippi 18
- Illinois 17
- Montana 17
- South Dakota 17
- Iowa 15
- Kansas 15
- Tennessee 15
- Puerto Rico 14
- Wisconsin 12
- Minnesota 11
- Kentucky 10
- North Carolina 10
- Indiana 9
- Michigan 9
- New Mexico 9
- Utah 9
- Arkansas 8
- Colorado 7
- Ohio 7
- Alaska 6
- Wyoming 6
- Idaho 5
- Alabama 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2328636 | 2328636 | 2022-03-21 | Schuyler | Missouri | 29197 | 725 | 26 |
2325384 | 2325384 | 2022-03-20 | Schuyler | Missouri | 29197 | 725 | 26 |
2322130 | 2322130 | 2022-03-19 | Schuyler | Missouri | 29197 | 725 | 26 |
2318876 | 2318876 | 2022-03-18 | Schuyler | Missouri | 29197 | 725 | 26 |
2315623 | 2315623 | 2022-03-17 | Schuyler | Missouri | 29197 | 725 | 26 |
2312370 | 2312370 | 2022-03-16 | Schuyler | Missouri | 29197 | 725 | 26 |
2309117 | 2309117 | 2022-03-15 | Schuyler | Missouri | 29197 | 725 | 26 |
2305865 | 2305865 | 2022-03-14 | Schuyler | Missouri | 29197 | 725 | 26 |
2264015 | 2264015 | 2022-03-01 | Emmons | North Dakota | 38029 | 725 | 17 |
2260764 | 2260764 | 2022-02-28 | Emmons | North Dakota | 38029 | 725 | 17 |
2257513 | 2257513 | 2022-02-27 | Emmons | North Dakota | 38029 | 725 | 17 |
2254262 | 2254262 | 2022-02-26 | Emmons | North Dakota | 38029 | 725 | 17 |
2211811 | 2211811 | 2022-02-13 | Mora | New Mexico | 35033 | 725 | 16 |
2208558 | 2208558 | 2022-02-12 | Mora | New Mexico | 35033 | 725 | 16 |
2205305 | 2205305 | 2022-02-11 | Mora | New Mexico | 35033 | 725 | 16 |
2195731 | 2195731 | 2022-02-08 | Eddy | North Dakota | 38027 | 725 | 6 |
2171936 | 2171936 | 2022-02-01 | Trego | Kansas | 20195 | 725 | 9 |
2168683 | 2168683 | 2022-01-31 | Trego | Kansas | 20195 | 725 | 9 |
2111947 | 2111947 | 2022-01-13 | Reagan | Texas | 48383 | 725 | 11 |
2104105 | 2104105 | 2022-01-11 | Sharkey | Mississippi | 28125 | 725 | 21 |
2092334 | 2092334 | 2022-01-07 | Goliad | Texas | 48175 | 725 | 28 |
2055597 | 2055597 | 2021-12-27 | Nuckolls | Nebraska | 31129 | 725 | 13 |
2052347 | 2052347 | 2021-12-26 | Nuckolls | Nebraska | 31129 | 725 | 13 |
2049097 | 2049097 | 2021-12-25 | Nuckolls | Nebraska | 31129 | 725 | 13 |
2045847 | 2045847 | 2021-12-24 | Nuckolls | Nebraska | 31129 | 725 | 13 |
2042597 | 2042597 | 2021-12-23 | Nuckolls | Nebraska | 31129 | 725 | 13 |
2037049 | 2037049 | 2021-12-21 | Delta | Texas | 48119 | 725 | 22 |
2032134 | 2032134 | 2021-12-20 | Carlisle | Kentucky | 21039 | 725 | 12 |
2023694 | 2023694 | 2021-12-17 | Adjuntas | Puerto Rico | 72001 | 725 | |
2018622 | 2018622 | 2021-12-16 | Schley | Georgia | 13249 | 725 | 8 |
2011246 | 2011246 | 2021-12-13 | Garfield | Utah | 49017 | 725 | 12 |
1998086 | 1998086 | 2021-12-09 | Hemphill | Texas | 48211 | 725 | 3 |
1993644 | 1993644 | 2021-12-08 | Holt | Missouri | 29087 | 725 | 23 |
1994835 | 1994835 | 2021-12-08 | Hemphill | Texas | 48211 | 725 | 3 |
1984410 | 1984410 | 2021-12-05 | Wells | North Dakota | 38103 | 725 | 10 |
1927654 | 1927654 | 2021-11-18 | Bear Lake | Idaho | 16007 | 725 | 14 |
1924404 | 1924404 | 2021-11-17 | Bear Lake | Idaho | 16007 | 725 | 14 |
1925543 | 1925543 | 2021-11-17 | Fillmore | Nebraska | 31059 | 725 | 13 |
1922000 | 1922000 | 2021-11-16 | Unknown | Minnesota | 725 | 124 | |
1917952 | 1917952 | 2021-11-15 | Calhoun | Illinois | 17013 | 725 | 5 |
1915797 | 1915797 | 2021-11-14 | Furnas | Nebraska | 31065 | 725 | 5 |
1912547 | 1912547 | 2021-11-13 | Furnas | Nebraska | 31065 | 725 | 5 |
1909297 | 1909297 | 2021-11-12 | Furnas | Nebraska | 31065 | 725 | 5 |
1907304 | 1907304 | 2021-11-11 | Cumberland | Virginia | 51049 | 725 | 18 |
1904055 | 1904055 | 2021-11-10 | Cumberland | Virginia | 51049 | 725 | 18 |
1900805 | 1900805 | 2021-11-09 | Cumberland | Virginia | 51049 | 725 | 18 |
1894869 | 1894869 | 2021-11-08 | Huerfano | Colorado | 8055 | 725 | 19 |
1897306 | 1897306 | 2021-11-08 | Garza | Texas | 48169 | 725 | 22 |
1897555 | 1897555 | 2021-11-08 | Cumberland | Virginia | 51049 | 725 | 18 |
1894056 | 1894056 | 2021-11-07 | Garza | Texas | 48169 | 725 | 22 |
1890806 | 1890806 | 2021-11-06 | Garza | Texas | 48169 | 725 | 22 |
1883857 | 1883857 | 2021-11-04 | Wallowa | Oregon | 41063 | 725 | 12 |
1880836 | 1880836 | 2021-11-03 | Gregory | South Dakota | 46053 | 725 | 30 |
1875193 | 1875193 | 2021-11-02 | Yukon-Koyukuk Census Area | Alaska | 2290 | 725 | 5 |
1875736 | 1875736 | 2021-11-02 | Henderson | Illinois | 17071 | 725 | 23 |
1876771 | 1876771 | 2021-11-02 | Antelope | Nebraska | 31003 | 725 | 9 |
1873522 | 1873522 | 2021-11-01 | Antelope | Nebraska | 31003 | 725 | 9 |
1854860 | 1854860 | 2021-10-26 | Lyman | South Dakota | 46085 | 725 | 11 |
1836711 | 1836711 | 2021-10-21 | Alexander | Illinois | 17003 | 725 | 12 |
1824863 | 1824863 | 2021-10-17 | Sheridan | Nebraska | 31161 | 725 | 23 |
1821614 | 1821614 | 2021-10-16 | Sheridan | Nebraska | 31161 | 725 | 23 |
1818365 | 1818365 | 2021-10-15 | Sheridan | Nebraska | 31161 | 725 | 23 |
1801326 | 1801326 | 2021-10-10 | Mitchell | Kansas | 20123 | 725 | 16 |
1798077 | 1798077 | 2021-10-09 | Mitchell | Kansas | 20123 | 725 | 16 |
1794828 | 1794828 | 2021-10-08 | Mitchell | Kansas | 20123 | 725 | 16 |
1785477 | 1785477 | 2021-10-05 | Grant | Minnesota | 27051 | 725 | 9 |
1780581 | 1780581 | 2021-10-03 | Covington city | Virginia | 51580 | 725 | 14 |
1777331 | 1777331 | 2021-10-02 | Covington city | Virginia | 51580 | 725 | 14 |
1774081 | 1774081 | 2021-10-01 | Covington city | Virginia | 51580 | 725 | 14 |
1761280 | 1761280 | 2021-09-27 | Wirt | West Virginia | 54105 | 725 | 10 |
1739520 | 1739520 | 2021-09-21 | Taylor | Iowa | 19173 | 725 | 12 |
1736271 | 1736271 | 2021-09-20 | Taylor | Iowa | 19173 | 725 | 12 |
1732149 | 1732149 | 2021-09-19 | Choctaw | Alabama | 1023 | 725 | 25 |
1733021 | 1733021 | 2021-09-19 | Taylor | Iowa | 19173 | 725 | 12 |
1729771 | 1729771 | 2021-09-18 | Taylor | Iowa | 19173 | 725 | 12 |
1726521 | 1726521 | 2021-09-17 | Taylor | Iowa | 19173 | 725 | 12 |
1723020 | 1723020 | 2021-09-16 | Gallatin | Illinois | 17059 | 725 | 5 |
1723272 | 1723272 | 2021-09-16 | Taylor | Iowa | 19173 | 725 | 12 |
1720023 | 1720023 | 2021-09-15 | Taylor | Iowa | 19173 | 725 | 12 |
1716870 | 1716870 | 2021-09-14 | Rooks | Kansas | 20163 | 725 | 11 |
1718997 | 1718997 | 2021-09-14 | Calhoun | West Virginia | 54013 | 725 | 1 |
1713624 | 1713624 | 2021-09-13 | Rooks | Kansas | 20163 | 725 | 11 |
1705581 | 1705581 | 2021-09-10 | Crockett | Texas | 48105 | 725 | 15 |
1702431 | 1702431 | 2021-09-09 | Lynn | Texas | 48305 | 725 | 25 |
1699182 | 1699182 | 2021-09-08 | Lynn | Texas | 48305 | 725 | 25 |
1695834 | 1695834 | 2021-09-07 | Crockett | Texas | 48105 | 725 | 15 |
1679736 | 1679736 | 2021-09-02 | San Augustine | Texas | 48405 | 725 | 32 |
1676488 | 1676488 | 2021-09-01 | San Augustine | Texas | 48405 | 725 | 32 |
1667855 | 1667855 | 2021-08-30 | Stark | Illinois | 17175 | 725 | 26 |
1665754 | 1665754 | 2021-08-29 | Quay | New Mexico | 35037 | 725 | 12 |
1666399 | 1666399 | 2021-08-29 | Day | South Dakota | 46037 | 725 | 30 |
1660819 | 1660819 | 2021-08-28 | Lafayette | Arkansas | 5073 | 725 | 11 |
1662506 | 1662506 | 2021-08-28 | Quay | New Mexico | 35037 | 725 | 12 |
1663151 | 1663151 | 2021-08-28 | Day | South Dakota | 46037 | 725 | 30 |
1658620 | 1658620 | 2021-08-27 | Piscataquis | Maine | 23021 | 725 | 7 |
1659258 | 1659258 | 2021-08-27 | Quay | New Mexico | 35037 | 725 | 12 |
1659903 | 1659903 | 2021-08-27 | Day | South Dakota | 46037 | 725 | 30 |
1631730 | 1631730 | 2021-08-19 | Rio Blanco | Colorado | 8103 | 725 | 5 |
1621580 | 1621580 | 2021-08-15 | Pocahontas | West Virginia | 54075 | 725 | 12 |
1617975 | 1617975 | 2021-08-14 | Marion | Texas | 48315 | 725 | 34 |
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);