ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
573 rows where cases = 481 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 42
- Puerto Rico 41
- Nebraska 40
- Texas 39
- Missouri 38
- Kansas 37
- South Dakota 32
- Kentucky 25
- Virginia 19
- Minnesota 18
- Illinois 15
- Indiana 15
- North Carolina 15
- Colorado 14
- Louisiana 14
- Iowa 11
- North Dakota 11
- Mississippi 10
- Montana 10
- Oklahoma 10
- Oregon 10
- Pennsylvania 10
- Ohio 9
- Florida 8
- South Carolina 7
- Utah 7
- West Virginia 7
- Alabama 6
- New Mexico 6
- Arkansas 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2350119 | 2350119 | 2022-03-28 | Sedgwick | Colorado | 8115 | 481 | 9 |
2346866 | 2346866 | 2022-03-27 | Sedgwick | Colorado | 8115 | 481 | 9 |
2343613 | 2343613 | 2022-03-26 | Sedgwick | Colorado | 8115 | 481 | 9 |
2340360 | 2340360 | 2022-03-25 | Sedgwick | Colorado | 8115 | 481 | 9 |
2337107 | 2337107 | 2022-03-24 | Sedgwick | Colorado | 8115 | 481 | 9 |
2209490 | 2209490 | 2022-02-12 | Knox | Texas | 48275 | 481 | 23 |
2206237 | 2206237 | 2022-02-11 | Knox | Texas | 48275 | 481 | 23 |
2202984 | 2202984 | 2022-02-10 | Knox | Texas | 48275 | 481 | 22 |
2199730 | 2199730 | 2022-02-09 | Knox | Texas | 48275 | 481 | 22 |
2192485 | 2192485 | 2022-02-07 | Kidder | North Dakota | 38043 | 481 | 13 |
2193090 | 2193090 | 2022-02-07 | Armstrong | Texas | 48011 | 481 | 8 |
2188113 | 2188113 | 2022-02-06 | Clark | Kansas | 20025 | 481 | 7 |
2189836 | 2189836 | 2022-02-06 | Armstrong | Texas | 48011 | 481 | 8 |
2184860 | 2184860 | 2022-02-05 | Clark | Kansas | 20025 | 481 | 7 |
2186583 | 2186583 | 2022-02-05 | Armstrong | Texas | 48011 | 481 | 8 |
2181608 | 2181608 | 2022-02-04 | Clark | Kansas | 20025 | 481 | 7 |
2178446 | 2178446 | 2022-02-03 | Wichita | Kansas | 20203 | 481 | 8 |
2175193 | 2175193 | 2022-02-02 | Wichita | Kansas | 20203 | 481 | 8 |
2172656 | 2172656 | 2022-02-01 | Hitchcock | Nebraska | 31087 | 481 | 6 |
2169403 | 2169403 | 2022-01-31 | Hitchcock | Nebraska | 31087 | 481 | 6 |
2158499 | 2158499 | 2022-01-28 | Custer | Idaho | 16037 | 481 | 7 |
2155246 | 2155246 | 2022-01-27 | Custer | Idaho | 16037 | 481 | 7 |
2154098 | 2154098 | 2022-01-26 | Culberson | Texas | 48109 | 481 | 13 |
2142052 | 2142052 | 2022-01-23 | Baker | Georgia | 13007 | 481 | 14 |
2138797 | 2138797 | 2022-01-22 | Baker | Georgia | 13007 | 481 | 14 |
2135541 | 2135541 | 2022-01-21 | Baker | Georgia | 13007 | 481 | 14 |
2127074 | 2127074 | 2022-01-18 | Cherry | Nebraska | 31031 | 481 | 8 |
2123822 | 2123822 | 2022-01-17 | Cherry | Nebraska | 31031 | 481 | 8 |
2111854 | 2111854 | 2022-01-13 | Hardeman | Texas | 48197 | 481 | 14 |
2102884 | 2102884 | 2022-01-11 | Costilla | Colorado | 8023 | 481 | 14 |
2103576 | 2103576 | 2022-01-11 | Lincoln | Kansas | 20105 | 481 | 7 |
2104633 | 2104633 | 2022-01-11 | Adams | North Dakota | 38001 | 481 | 9 |
2100325 | 2100325 | 2022-01-10 | Lincoln | Kansas | 20105 | 481 | 7 |
2101382 | 2101382 | 2022-01-10 | Adams | North Dakota | 38001 | 481 | 9 |
2102135 | 2102135 | 2022-01-10 | Kimble | Texas | 48267 | 481 | 11 |
2087315 | 2087315 | 2022-01-06 | Kiowa | Kansas | 20097 | 481 | 7 |
2084063 | 2084063 | 2022-01-05 | Kiowa | Kansas | 20097 | 481 | 7 |
2085787 | 2085787 | 2022-01-05 | Collingsworth | Texas | 48087 | 481 | 11 |
2075416 | 2075416 | 2022-01-02 | Towner | North Dakota | 38095 | 481 | 11 |
2072165 | 2072165 | 2022-01-01 | Towner | North Dakota | 38095 | 481 | 11 |
2072487 | 2072487 | 2022-01-01 | Las Marias | Puerto Rico | 72083 | 481 | |
2069236 | 2069236 | 2021-12-31 | Las Marias | Puerto Rico | 72083 | 481 | |
2033642 | 2033642 | 2021-12-20 | Ziebach | South Dakota | 46137 | 481 | 11 |
2030392 | 2030392 | 2021-12-19 | Ziebach | South Dakota | 46137 | 481 | 10 |
2027141 | 2027141 | 2021-12-18 | Ziebach | South Dakota | 46137 | 481 | 10 |
2022953 | 2022953 | 2021-12-17 | Scotland | Missouri | 29199 | 481 | 15 |
2023890 | 2023890 | 2021-12-17 | Ziebach | South Dakota | 46137 | 481 | 10 |
2020639 | 2020639 | 2021-12-16 | Ziebach | South Dakota | 46137 | 481 | 10 |
2012608 | 2012608 | 2021-12-14 | Woodson | Kansas | 20207 | 481 | 10 |
2009357 | 2009357 | 2021-12-13 | Woodson | Kansas | 20207 | 481 | 10 |
2010851 | 2010851 | 2021-12-13 | Hanson | South Dakota | 46061 | 481 | 5 |
2007600 | 2007600 | 2021-12-12 | Hanson | South Dakota | 46061 | 481 | 5 |
2004349 | 2004349 | 2021-12-11 | Hanson | South Dakota | 46061 | 481 | 5 |
2001098 | 2001098 | 2021-12-10 | Hanson | South Dakota | 46061 | 481 | 5 |
1997848 | 1997848 | 2021-12-09 | Hanson | South Dakota | 46061 | 481 | 5 |
1968624 | 1968624 | 2021-11-30 | Stanley | South Dakota | 46117 | 481 | 3 |
1916600 | 1916600 | 2021-11-14 | Marshall | South Dakota | 46091 | 481 | 8 |
1913350 | 1913350 | 2021-11-13 | Marshall | South Dakota | 46091 | 481 | 8 |
1909461 | 1909461 | 2021-11-12 | Hamilton | New York | 36041 | 481 | 3 |
1910100 | 1910100 | 2021-11-12 | Marshall | South Dakota | 46091 | 481 | 8 |
1894887 | 1894887 | 2021-11-08 | Ouray | Colorado | 8091 | 481 | 5 |
1896355 | 1896355 | 2021-11-08 | Valley | Nebraska | 31175 | 481 | 4 |
1860608 | 1860608 | 2021-10-28 | Stanton | Nebraska | 31167 | 481 | 11 |
1857359 | 1857359 | 2021-10-27 | Stanton | Nebraska | 31167 | 481 | 11 |
1837102 | 1837102 | 2021-10-21 | Trego | Kansas | 20195 | 481 | 8 |
1833853 | 1833853 | 2021-10-20 | Trego | Kansas | 20195 | 481 | 8 |
1760889 | 1760889 | 2021-09-27 | Kinney | Texas | 48271 | 481 | 8 |
1750396 | 1750396 | 2021-09-24 | Bowman | North Dakota | 38011 | 481 | 6 |
1742563 | 1742563 | 2021-09-22 | Pope | Illinois | 17151 | 481 | 5 |
1739812 | 1739812 | 2021-09-21 | Tensas | Louisiana | 22107 | 481 | 8 |
1740188 | 1740188 | 2021-09-21 | Knox | Missouri | 29103 | 481 | 3 |
1736563 | 1736563 | 2021-09-20 | Tensas | Louisiana | 22107 | 481 | 8 |
1733117 | 1733117 | 2021-09-19 | Rush | Kansas | 20165 | 481 | 15 |
1733313 | 1733313 | 2021-09-19 | Tensas | Louisiana | 22107 | 481 | 8 |
1729867 | 1729867 | 2021-09-18 | Rush | Kansas | 20165 | 481 | 15 |
1730063 | 1730063 | 2021-09-18 | Tensas | Louisiana | 22107 | 481 | 8 |
1726617 | 1726617 | 2021-09-17 | Rush | Kansas | 20165 | 481 | 15 |
1726813 | 1726813 | 2021-09-17 | Tensas | Louisiana | 22107 | 481 | 8 |
1724383 | 1724383 | 2021-09-16 | Tyrrell | North Carolina | 37177 | 481 | 6 |
1717907 | 1717907 | 2021-09-14 | Cavalier | North Dakota | 38019 | 481 | 5 |
1714904 | 1714904 | 2021-09-13 | Wallowa | Oregon | 41063 | 481 | 6 |
1700591 | 1700591 | 2021-09-09 | Haskell | Kansas | 20081 | 481 | 8 |
1697342 | 1697342 | 2021-09-08 | Haskell | Kansas | 20081 | 481 | 8 |
1698463 | 1698463 | 2021-09-08 | Wells | North Dakota | 38103 | 481 | 8 |
1695478 | 1695478 | 2021-09-07 | Sullivan | Pennsylvania | 42113 | 481 | 22 |
1691927 | 1691927 | 2021-09-06 | Dunn | North Dakota | 38025 | 481 | 7 |
1689345 | 1689345 | 2021-09-05 | Delta | Texas | 48119 | 481 | 15 |
1651202 | 1651202 | 2021-08-25 | Huerfano | Colorado | 8055 | 481 | 18 |
1631739 | 1631739 | 2021-08-19 | Washington | Colorado | 8121 | 481 | 13 |
1628492 | 1628492 | 2021-08-18 | Washington | Colorado | 8121 | 481 | 13 |
1625245 | 1625245 | 2021-08-17 | Washington | Colorado | 8121 | 481 | 13 |
1626764 | 1626764 | 2021-08-17 | Hidalgo | New Mexico | 35023 | 481 | 9 |
1621998 | 1621998 | 2021-08-16 | Washington | Colorado | 8121 | 481 | 13 |
1623517 | 1623517 | 2021-08-16 | Hidalgo | New Mexico | 35023 | 481 | 9 |
1624842 | 1624842 | 2021-08-16 | Wirt | West Virginia | 54105 | 481 | 4 |
1620907 | 1620907 | 2021-08-15 | Aurora | South Dakota | 46003 | 481 | 15 |
1617659 | 1617659 | 2021-08-14 | Aurora | South Dakota | 46003 | 481 | 15 |
1614411 | 1614411 | 2021-08-13 | Aurora | South Dakota | 46003 | 481 | 15 |
1609000 | 1609000 | 2021-08-12 | Saguache | Colorado | 8109 | 481 | 8 |
1611162 | 1611162 | 2021-08-12 | Aurora | South Dakota | 46003 | 481 | 15 |
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);