ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
673 rows where cases = 547 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 77
- Texas 65
- Minnesota 42
- Kansas 37
- Oklahoma 33
- Virginia 29
- Georgia 28
- Missouri 26
- Kentucky 25
- Idaho 20
- West Virginia 20
- Indiana 19
- Puerto Rico 19
- Alabama 17
- Mississippi 17
- Illinois 16
- Tennessee 14
- Arkansas 13
- Iowa 13
- North Carolina 13
- North Dakota 12
- Colorado 11
- Ohio 11
- South Dakota 11
- Montana 9
- Pennsylvania 9
- California 7
- Louisiana 6
- Michigan 6
- New York 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290395 | 2290395 | 2022-03-09 | Maricao | Puerto Rico | 72093 | 547 | |
2290820 | 2290820 | 2022-03-09 | Oldham | Texas | 48359 | 547 | 6 |
2287143 | 2287143 | 2022-03-08 | Maricao | Puerto Rico | 72093 | 547 | |
2283553 | 2283553 | 2022-03-07 | Renville | North Dakota | 38075 | 547 | 15 |
2283891 | 2283891 | 2022-03-07 | Maricao | Puerto Rico | 72093 | 547 | |
2280301 | 2280301 | 2022-03-06 | Renville | North Dakota | 38075 | 547 | 15 |
2277048 | 2277048 | 2022-03-05 | Renville | North Dakota | 38075 | 547 | 15 |
2245815 | 2245815 | 2022-02-24 | Haines Borough | Alaska | 2100 | 547 | 1 |
2242564 | 2242564 | 2022-02-23 | Haines Borough | Alaska | 2100 | 547 | 1 |
2183424 | 2183424 | 2022-02-04 | Hardeman | Texas | 48197 | 547 | 14 |
2179940 | 2179940 | 2022-02-03 | Hand | South Dakota | 46059 | 547 | 8 |
2175947 | 2175947 | 2022-02-02 | Sherman | Nebraska | 31163 | 547 | 4 |
2176689 | 2176689 | 2022-02-02 | Hand | South Dakota | 46059 | 547 | 8 |
2170210 | 2170210 | 2022-01-31 | Sanborn | South Dakota | 46111 | 547 | 5 |
2163205 | 2163205 | 2022-01-29 | Griggs | North Dakota | 38039 | 547 | 2 |
2150867 | 2150867 | 2022-01-25 | Fisher | Texas | 48151 | 547 | 20 |
2132154 | 2132154 | 2022-01-20 | Custer | Colorado | 8027 | 547 | 16 |
2128901 | 2128901 | 2022-01-19 | Custer | Colorado | 8027 | 547 | 16 |
2101897 | 2101897 | 2022-01-10 | Stanley | South Dakota | 46117 | 547 | 3 |
2061952 | 2061952 | 2021-12-29 | Schuyler | Missouri | 29197 | 547 | 22 |
2062876 | 2062876 | 2021-12-29 | Perkins | South Dakota | 46105 | 547 | 16 |
2037300 | 2037300 | 2021-12-21 | Bath | Virginia | 51017 | 547 | 15 |
2028856 | 2028856 | 2021-12-19 | Trego | Kansas | 20195 | 547 | 9 |
2025605 | 2025605 | 2021-12-18 | Trego | Kansas | 20195 | 547 | 9 |
2022354 | 2022354 | 2021-12-17 | Trego | Kansas | 20195 | 547 | 9 |
2019871 | 2019871 | 2021-12-16 | Webster | Nebraska | 31181 | 547 | 9 |
2016225 | 2016225 | 2021-12-15 | Lake of the Woods | Minnesota | 27077 | 547 | 5 |
2016621 | 2016621 | 2021-12-15 | Webster | Nebraska | 31181 | 547 | 9 |
2012575 | 2012575 | 2021-12-14 | Osborne | Kansas | 20141 | 547 | 15 |
2013370 | 2013370 | 2021-12-14 | Webster | Nebraska | 31181 | 547 | 9 |
2009324 | 2009324 | 2021-12-13 | Osborne | Kansas | 20141 | 547 | 15 |
2005375 | 2005375 | 2021-12-12 | Gilpin | Colorado | 8047 | 547 | 4 |
2006733 | 2006733 | 2021-12-12 | Fallon | Montana | 30025 | 547 | 8 |
2002124 | 2002124 | 2021-12-11 | Gilpin | Colorado | 8047 | 547 | 4 |
2003482 | 2003482 | 2021-12-11 | Fallon | Montana | 30025 | 547 | 8 |
1998874 | 1998874 | 2021-12-10 | Gilpin | Colorado | 8047 | 547 | 4 |
2000232 | 2000232 | 2021-12-10 | Fallon | Montana | 30025 | 547 | 8 |
1996981 | 1996981 | 2021-12-09 | Fallon | Montana | 30025 | 547 | 8 |
1993730 | 1993730 | 2021-12-08 | Fallon | Montana | 30025 | 547 | 8 |
1994130 | 1994130 | 2021-12-08 | Hettinger | North Dakota | 38041 | 547 | 7 |
1989816 | 1989816 | 2021-12-07 | Ness | Kansas | 20135 | 547 | 17 |
1986566 | 1986566 | 2021-12-06 | Ness | Kansas | 20135 | 547 | 17 |
1973576 | 1973576 | 2021-12-02 | Rawlins | Kansas | 20153 | 547 | 7 |
1970326 | 1970326 | 2021-12-01 | Rawlins | Kansas | 20153 | 547 | 7 |
1963410 | 1963410 | 2021-11-29 | Adams | Idaho | 16003 | 547 | 14 |
1960159 | 1960159 | 2021-11-28 | Adams | Idaho | 16003 | 547 | 14 |
1956908 | 1956908 | 2021-11-27 | Adams | Idaho | 16003 | 547 | 14 |
1953657 | 1953657 | 2021-11-26 | Adams | Idaho | 16003 | 547 | 14 |
1950406 | 1950406 | 2021-11-25 | Adams | Idaho | 16003 | 547 | 14 |
1947155 | 1947155 | 2021-11-24 | Adams | Idaho | 16003 | 547 | 14 |
1943904 | 1943904 | 2021-11-23 | Adams | Idaho | 16003 | 547 | 14 |
1944286 | 1944286 | 2021-11-23 | Jewell | Kansas | 20089 | 547 | 11 |
1941036 | 1941036 | 2021-11-22 | Jewell | Kansas | 20089 | 547 | 11 |
1937751 | 1937751 | 2021-11-21 | Chautauqua | Kansas | 20019 | 547 | 12 |
1937824 | 1937824 | 2021-11-21 | Rush | Kansas | 20165 | 547 | 16 |
1934501 | 1934501 | 2021-11-20 | Chautauqua | Kansas | 20019 | 547 | 12 |
1934574 | 1934574 | 2021-11-20 | Rush | Kansas | 20165 | 547 | 16 |
1931250 | 1931250 | 2021-11-19 | Chautauqua | Kansas | 20019 | 547 | 12 |
1931323 | 1931323 | 2021-11-19 | Rush | Kansas | 20165 | 547 | 16 |
1913121 | 1913121 | 2021-11-13 | Cameron | Pennsylvania | 42023 | 547 | 11 |
1904639 | 1904639 | 2021-11-11 | Phillips | Colorado | 8095 | 547 | 15 |
1907163 | 1907163 | 2021-11-11 | Real | Texas | 48385 | 547 | 19 |
1901389 | 1901389 | 2021-11-10 | Phillips | Colorado | 8095 | 547 | 15 |
1903115 | 1903115 | 2021-11-10 | Eddy | North Dakota | 38027 | 547 | 6 |
1903914 | 1903914 | 2021-11-10 | Real | Texas | 48385 | 547 | 19 |
1900664 | 1900664 | 2021-11-09 | Real | Texas | 48385 | 547 | 19 |
1897414 | 1897414 | 2021-11-08 | Real | Texas | 48385 | 547 | 19 |
1894164 | 1894164 | 2021-11-07 | Real | Texas | 48385 | 547 | 19 |
1890914 | 1890914 | 2021-11-06 | Real | Texas | 48385 | 547 | 19 |
1887664 | 1887664 | 2021-11-05 | Real | Texas | 48385 | 547 | 18 |
1884414 | 1884414 | 2021-11-04 | Real | Texas | 48385 | 547 | 18 |
1881165 | 1881165 | 2021-11-03 | Real | Texas | 48385 | 547 | 18 |
1877916 | 1877916 | 2021-11-02 | Real | Texas | 48385 | 547 | 18 |
1874667 | 1874667 | 2021-11-01 | Real | Texas | 48385 | 547 | 18 |
1869194 | 1869194 | 2021-10-31 | Oneida | Idaho | 16071 | 547 | 9 |
1871418 | 1871418 | 2021-10-31 | Real | Texas | 48385 | 547 | 18 |
1871557 | 1871557 | 2021-10-31 | Craig | Virginia | 51045 | 547 | 7 |
1865945 | 1865945 | 2021-10-30 | Oneida | Idaho | 16071 | 547 | 9 |
1868169 | 1868169 | 2021-10-30 | Real | Texas | 48385 | 547 | 18 |
1868308 | 1868308 | 2021-10-30 | Craig | Virginia | 51045 | 547 | 7 |
1862696 | 1862696 | 2021-10-29 | Oneida | Idaho | 16071 | 547 | 9 |
1864920 | 1864920 | 2021-10-29 | Real | Texas | 48385 | 547 | 18 |
1865059 | 1865059 | 2021-10-29 | Craig | Virginia | 51045 | 547 | 7 |
1859447 | 1859447 | 2021-10-28 | Oneida | Idaho | 16071 | 547 | 8 |
1861671 | 1861671 | 2021-10-28 | Real | Texas | 48385 | 547 | 18 |
1827038 | 1827038 | 2021-10-18 | Pope | Illinois | 17151 | 547 | 6 |
1827415 | 1827415 | 2021-10-18 | Hickman | Kentucky | 21105 | 547 | 19 |
1824166 | 1824166 | 2021-10-17 | Hickman | Kentucky | 21105 | 547 | 19 |
1820917 | 1820917 | 2021-10-16 | Hickman | Kentucky | 21105 | 547 | 19 |
1817668 | 1817668 | 2021-10-15 | Hickman | Kentucky | 21105 | 547 | 19 |
1803149 | 1803149 | 2021-10-10 | Mason | Texas | 48319 | 547 | 7 |
1792448 | 1792448 | 2021-10-07 | Hidalgo | New Mexico | 35023 | 547 | 11 |
1783196 | 1783196 | 2021-10-04 | Sullivan | Pennsylvania | 42113 | 547 | 24 |
1770692 | 1770692 | 2021-09-30 | Reagan | Texas | 48383 | 547 | 9 |
1745408 | 1745408 | 2021-09-23 | Huerfano | Colorado | 8055 | 547 | 17 |
1741524 | 1741524 | 2021-09-21 | Garfield | Utah | 49017 | 547 | 11 |
1741684 | 1741684 | 2021-09-21 | Surry | Virginia | 51181 | 547 | 10 |
1738435 | 1738435 | 2021-09-20 | Surry | Virginia | 51181 | 547 | 9 |
1733889 | 1733889 | 2021-09-19 | Sheridan | Nebraska | 31161 | 547 | 21 |
1730639 | 1730639 | 2021-09-18 | Sheridan | Nebraska | 31161 | 547 | 21 |
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);