ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
231 rows where cases = 2614 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 19
- Oklahoma 15
- Texas 15
- Georgia 14
- Mississippi 12
- Indiana 11
- Kansas 10
- Minnesota 10
- Missouri 10
- Tennessee 10
- Virginia 9
- Iowa 8
- Montana 8
- Wisconsin 7
- Colorado 6
- Nebraska 6
- Pennsylvania 6
- Puerto Rico 6
- Louisiana 5
- North Carolina 5
- Illinois 4
- Kentucky 4
- Wyoming 4
- Alabama 3
- South Carolina 3
- South Dakota 3
- Michigan 2
- New Hampshire 2
- Ohio 2
- West Virginia 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500552 | 2500552 | 2022-05-13 | Rice | Kansas | 20159 | 2614 | 23 |
2479109 | 2479109 | 2022-05-06 | Adjuntas | Puerto Rico | 72001 | 2614 | |
2405301 | 2405301 | 2022-04-14 | Pike | Arkansas | 5109 | 2614 | 44 |
2408096 | 2408096 | 2022-04-14 | Clarke | Virginia | 51043 | 2614 | 42 |
2401585 | 2401585 | 2022-04-12 | Clarke | Virginia | 51043 | 2614 | 42 |
2395687 | 2395687 | 2022-04-11 | Unknown | Connecticut | 2614 | 1 | |
2392280 | 2392280 | 2022-04-10 | Pike | Arkansas | 5109 | 2614 | 44 |
2389024 | 2389024 | 2022-04-09 | Pike | Arkansas | 5109 | 2614 | 44 |
2385769 | 2385769 | 2022-04-08 | Pike | Arkansas | 5109 | 2614 | 44 |
2388358 | 2388358 | 2022-04-08 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2382514 | 2382514 | 2022-04-07 | Pike | Arkansas | 5109 | 2614 | 44 |
2385103 | 2385103 | 2022-04-07 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2379259 | 2379259 | 2022-04-06 | Pike | Arkansas | 5109 | 2614 | 44 |
2381848 | 2381848 | 2022-04-06 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2378593 | 2378593 | 2022-04-05 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2375339 | 2375339 | 2022-04-04 | Jim Hogg | Texas | 48247 | 2614 | 22 |
2359740 | 2359740 | 2022-03-31 | Pike | Arkansas | 5109 | 2614 | 43 |
2356486 | 2356486 | 2022-03-30 | Pike | Arkansas | 5109 | 2614 | 43 |
2353233 | 2353233 | 2022-03-29 | Pike | Arkansas | 5109 | 2614 | 43 |
2349981 | 2349981 | 2022-03-28 | Pike | Arkansas | 5109 | 2614 | 43 |
2346728 | 2346728 | 2022-03-27 | Pike | Arkansas | 5109 | 2614 | 43 |
2343475 | 2343475 | 2022-03-26 | Pike | Arkansas | 5109 | 2614 | 43 |
2340222 | 2340222 | 2022-03-25 | Pike | Arkansas | 5109 | 2614 | 43 |
2336969 | 2336969 | 2022-03-24 | Pike | Arkansas | 5109 | 2614 | 42 |
2333715 | 2333715 | 2022-03-23 | Pike | Arkansas | 5109 | 2614 | 42 |
2330461 | 2330461 | 2022-03-22 | Pike | Arkansas | 5109 | 2614 | 42 |
2325448 | 2325448 | 2022-03-20 | Richland | Montana | 30083 | 2614 | 32 |
2322194 | 2322194 | 2022-03-19 | Richland | Montana | 30083 | 2614 | 32 |
2318940 | 2318940 | 2022-03-18 | Richland | Montana | 30083 | 2614 | 32 |
2315687 | 2315687 | 2022-03-17 | Richland | Montana | 30083 | 2614 | 32 |
2301535 | 2301535 | 2022-03-13 | Screven | Georgia | 13251 | 2614 | 67 |
2302423 | 2302423 | 2022-03-13 | Stevens | Minnesota | 27149 | 2614 | 13 |
2298283 | 2298283 | 2022-03-12 | Screven | Georgia | 13251 | 2614 | 67 |
2299171 | 2299171 | 2022-03-12 | Stevens | Minnesota | 27149 | 2614 | 13 |
2295031 | 2295031 | 2022-03-11 | Screven | Georgia | 13251 | 2614 | 67 |
2295919 | 2295919 | 2022-03-11 | Stevens | Minnesota | 27149 | 2614 | 13 |
2291779 | 2291779 | 2022-03-10 | Screven | Georgia | 13251 | 2614 | 67 |
2241810 | 2241810 | 2022-02-22 | Houston | Tennessee | 47083 | 2614 | 58 |
2238559 | 2238559 | 2022-02-21 | Houston | Tennessee | 47083 | 2614 | 58 |
2235308 | 2235308 | 2022-02-20 | Houston | Tennessee | 47083 | 2614 | 58 |
2232057 | 2232057 | 2022-02-19 | Houston | Tennessee | 47083 | 2614 | 58 |
2228806 | 2228806 | 2022-02-18 | Houston | Tennessee | 47083 | 2614 | 58 |
2225555 | 2225555 | 2022-02-17 | Houston | Tennessee | 47083 | 2614 | 58 |
2222304 | 2222304 | 2022-02-16 | Houston | Tennessee | 47083 | 2614 | 58 |
2195895 | 2195895 | 2022-02-08 | Haskell | Oklahoma | 40061 | 2614 | 33 |
2192641 | 2192641 | 2022-02-07 | Haskell | Oklahoma | 40061 | 2614 | 33 |
2189387 | 2189387 | 2022-02-06 | Haskell | Oklahoma | 40061 | 2614 | 33 |
2186134 | 2186134 | 2022-02-05 | Haskell | Oklahoma | 40061 | 2614 | 33 |
2182882 | 2182882 | 2022-02-04 | Haskell | Oklahoma | 40061 | 2614 | 33 |
2179630 | 2179630 | 2022-02-03 | Haskell | Oklahoma | 40061 | 2614 | 33 |
2175698 | 2175698 | 2022-02-02 | Barton | Missouri | 29011 | 2614 | 46 |
2176379 | 2176379 | 2022-02-02 | Haskell | Oklahoma | 40061 | 2614 | 33 |
2172976 | 2172976 | 2022-02-01 | McLean | North Dakota | 38055 | 2614 | 48 |
2108273 | 2108273 | 2022-01-12 | Salinas | Puerto Rico | 72123 | 2614 | |
2108883 | 2108883 | 2022-01-12 | Martinsville city | Virginia | 51690 | 2614 | 100 |
2102898 | 2102898 | 2022-01-11 | Gunnison | Colorado | 8051 | 2614 | 13 |
2070154 | 2070154 | 2022-01-01 | Macon | Alabama | 1087 | 2614 | 69 |
2066903 | 2066903 | 2021-12-31 | Macon | Alabama | 1087 | 2614 | 69 |
2061022 | 2061022 | 2021-12-29 | Massac | Illinois | 17127 | 2614 | 61 |
2021044 | 2021044 | 2021-12-16 | Appomattox | Virginia | 51011 | 2614 | 37 |
2016061 | 2016061 | 2021-12-15 | Washington | Maine | 23029 | 2614 | 37 |
1965146 | 1965146 | 2021-11-29 | Fulton | Pennsylvania | 42057 | 2614 | 39 |
1945091 | 1945091 | 2021-11-23 | Saline | Nebraska | 31151 | 2614 | 6 |
1937098 | 1937098 | 2021-11-21 | Chaffee | Colorado | 8015 | 2614 | 34 |
1938548 | 1938548 | 2021-11-21 | Gage | Nebraska | 31067 | 2614 | 30 |
1940079 | 1940079 | 2021-11-21 | Goshen | Wyoming | 56015 | 2614 | 46 |
1933848 | 1933848 | 2021-11-20 | Chaffee | Colorado | 8015 | 2614 | 34 |
1935298 | 1935298 | 2021-11-20 | Gage | Nebraska | 31067 | 2614 | 30 |
1936829 | 1936829 | 2021-11-20 | Goshen | Wyoming | 56015 | 2614 | 46 |
1930596 | 1930596 | 2021-11-19 | Chaffee | Colorado | 8015 | 2614 | 34 |
1932048 | 1932048 | 2021-11-19 | Gage | Nebraska | 31067 | 2614 | 30 |
1933579 | 1933579 | 2021-11-19 | Goshen | Wyoming | 56015 | 2614 | 46 |
1922175 | 1922175 | 2021-11-16 | Pike | Missouri | 29163 | 2614 | 40 |
1909906 | 1909906 | 2021-11-12 | Montour | Pennsylvania | 42093 | 2614 | 73 |
1897294 | 1897294 | 2021-11-08 | Falls | Texas | 48145 | 2614 | 48 |
1879915 | 1879915 | 2021-11-03 | Moniteau | Missouri | 29135 | 2614 | 39 |
1877299 | 1877299 | 2021-11-02 | Murray | Oklahoma | 40099 | 2614 | 53 |
1874050 | 1874050 | 2021-11-01 | Murray | Oklahoma | 40099 | 2614 | 53 |
1870801 | 1870801 | 2021-10-31 | Murray | Oklahoma | 40099 | 2614 | 53 |
1867552 | 1867552 | 2021-10-30 | Murray | Oklahoma | 40099 | 2614 | 53 |
1862658 | 1862658 | 2021-10-29 | Kauai | Hawaii | 15007 | 2614 | 9 |
1864303 | 1864303 | 2021-10-29 | Murray | Oklahoma | 40099 | 2614 | 53 |
1861054 | 1861054 | 2021-10-28 | Murray | Oklahoma | 40099 | 2614 | 53 |
1857805 | 1857805 | 2021-10-27 | Murray | Oklahoma | 40099 | 2614 | 53 |
1847043 | 1847043 | 2021-10-24 | Winn | Louisiana | 22127 | 2614 | 58 |
1843793 | 1843793 | 2021-10-23 | Winn | Louisiana | 22127 | 2614 | 58 |
1840543 | 1840543 | 2021-10-22 | Winn | Louisiana | 22127 | 2614 | 58 |
1842054 | 1842054 | 2021-10-22 | Falls | Texas | 48145 | 2614 | 45 |
1837294 | 1837294 | 2021-10-21 | Winn | Louisiana | 22127 | 2614 | 58 |
1830492 | 1830492 | 2021-10-19 | Tama | Iowa | 19171 | 2614 | 76 |
1827243 | 1827243 | 2021-10-18 | Tama | Iowa | 19171 | 2614 | 76 |
1823994 | 1823994 | 2021-10-17 | Tama | Iowa | 19171 | 2614 | 76 |
1820745 | 1820745 | 2021-10-16 | Tama | Iowa | 19171 | 2614 | 76 |
1817496 | 1817496 | 2021-10-15 | Tama | Iowa | 19171 | 2614 | 76 |
1814248 | 1814248 | 2021-10-14 | Tama | Iowa | 19171 | 2614 | 76 |
1810999 | 1810999 | 2021-10-13 | Tama | Iowa | 19171 | 2614 | 76 |
1807642 | 1807642 | 2021-10-12 | Rush | Indiana | 18139 | 2614 | 32 |
1804964 | 1804964 | 2021-10-11 | Dodge | Minnesota | 27039 | 2614 | 9 |
1791232 | 1791232 | 2021-10-07 | Cass | Illinois | 17017 | 2614 | 38 |
1781916 | 1781916 | 2021-10-04 | Garrard | Kentucky | 21079 | 2614 | 42 |
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);