ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
311 rows where cases = 1914 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 34
- Arkansas 21
- Georgia 20
- Virginia 17
- Louisiana 16
- Kentucky 13
- Texas 13
- Alabama 11
- Missouri 9
- Puerto Rico 9
- Tennessee 9
- West Virginia 9
- Wisconsin 9
- Alaska 8
- Indiana 8
- Mississippi 8
- North Dakota 8
- Illinois 7
- Minnesota 6
- Ohio 6
- Florida 5
- South Dakota 5
- Wyoming 5
- Colorado 4
- Maryland 4
- Michigan 4
- Montana 4
- Nebraska 4
- North Carolina 4
- Arizona 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474681 | 2474681 | 2022-05-05 | St. Helena | Louisiana | 22091 | 1914 | 23 |
2471424 | 2471424 | 2022-05-04 | St. Helena | Louisiana | 22091 | 1914 | 23 |
2467072 | 2467072 | 2022-05-03 | Dillingham Census Area | Alaska | 2070 | 1914 | 11 |
2468168 | 2468168 | 2022-05-03 | St. Helena | Louisiana | 22091 | 1914 | 23 |
2463817 | 2463817 | 2022-05-02 | Dillingham Census Area | Alaska | 2070 | 1914 | 11 |
2460561 | 2460561 | 2022-05-01 | Dillingham Census Area | Alaska | 2070 | 1914 | 11 |
2457305 | 2457305 | 2022-04-30 | Dillingham Census Area | Alaska | 2070 | 1914 | 11 |
2454049 | 2454049 | 2022-04-29 | Dillingham Census Area | Alaska | 2070 | 1914 | 11 |
2450793 | 2450793 | 2022-04-28 | Dillingham Census Area | Alaska | 2070 | 1914 | 11 |
2447537 | 2447537 | 2022-04-27 | Dillingham Census Area | Alaska | 2070 | 1914 | 11 |
2329769 | 2329769 | 2022-03-21 | Hansford | Texas | 48195 | 1914 | 29 |
2326517 | 2326517 | 2022-03-20 | Hansford | Texas | 48195 | 1914 | 29 |
2323264 | 2323264 | 2022-03-19 | Hansford | Texas | 48195 | 1914 | 29 |
2320010 | 2320010 | 2022-03-18 | Hansford | Texas | 48195 | 1914 | 29 |
2293975 | 2293975 | 2022-03-10 | Gaines | Texas | 48165 | 1914 | 83 |
2271909 | 2271909 | 2022-03-04 | Monroe | Arkansas | 5095 | 1914 | 31 |
2268657 | 2268657 | 2022-03-03 | Monroe | Arkansas | 5095 | 1914 | 31 |
2262153 | 2262153 | 2022-03-01 | Monroe | Arkansas | 5095 | 1914 | 31 |
2258902 | 2258902 | 2022-02-28 | Monroe | Arkansas | 5095 | 1914 | 31 |
2258629 | 2258629 | 2022-02-27 | Pendleton | West Virginia | 54071 | 1914 | 16 |
2255378 | 2255378 | 2022-02-26 | Pendleton | West Virginia | 54071 | 1914 | 16 |
2252127 | 2252127 | 2022-02-25 | Pendleton | West Virginia | 54071 | 1914 | 16 |
2245734 | 2245734 | 2022-02-23 | Sublette | Wyoming | 56035 | 1914 | 27 |
2240672 | 2240672 | 2022-02-22 | Franklin | Mississippi | 28037 | 1914 | 36 |
2197994 | 2197994 | 2022-02-09 | Crittenden | Kentucky | 21055 | 1914 | 40 |
2195751 | 2195751 | 2022-02-08 | Pembina | North Dakota | 38067 | 1914 | 16 |
2188895 | 2188895 | 2022-02-06 | Custer | Nebraska | 31041 | 1914 | 27 |
2189046 | 2189046 | 2022-02-06 | Sierra | New Mexico | 35051 | 1914 | 69 |
2185642 | 2185642 | 2022-02-05 | Custer | Nebraska | 31041 | 1914 | 27 |
2185793 | 2185793 | 2022-02-05 | Sierra | New Mexico | 35051 | 1914 | 69 |
2182390 | 2182390 | 2022-02-04 | Custer | Nebraska | 31041 | 1914 | 27 |
2182541 | 2182541 | 2022-02-04 | Sierra | New Mexico | 35051 | 1914 | 69 |
2167863 | 2167863 | 2022-01-31 | Searcy | Arkansas | 5129 | 1914 | 37 |
2157352 | 2157352 | 2022-01-27 | Dallam | Texas | 48111 | 1914 | 34 |
2144498 | 2144498 | 2022-01-23 | Somervell | Texas | 48425 | 1914 | 31 |
2126808 | 2126808 | 2022-01-18 | Benton | Mississippi | 28009 | 1914 | 42 |
2128208 | 2128208 | 2022-01-18 | Red River | Texas | 48387 | 1914 | 58 |
2106910 | 2106910 | 2022-01-12 | Edmonson | Kentucky | 21061 | 1914 | 35 |
2099373 | 2099373 | 2022-01-09 | Washakie | Wyoming | 56043 | 1914 | 39 |
2096122 | 2096122 | 2022-01-08 | Washakie | Wyoming | 56043 | 1914 | 39 |
2092870 | 2092870 | 2022-01-07 | Washakie | Wyoming | 56043 | 1914 | 39 |
2080932 | 2080932 | 2022-01-04 | Lee | Kentucky | 21129 | 1914 | 44 |
2076655 | 2076655 | 2022-01-03 | Lowndes | Alabama | 1085 | 1914 | 68 |
2035074 | 2035074 | 2021-12-21 | Brown | Indiana | 18013 | 1914 | 51 |
2018548 | 2018548 | 2021-12-16 | Early | Georgia | 13099 | 1914 | 58 |
2019852 | 2019852 | 2021-12-16 | Red Willow | Nebraska | 31145 | 1914 | 17 |
2012442 | 2012442 | 2021-12-14 | Grundy | Iowa | 19075 | 1914 | 37 |
2009191 | 2009191 | 2021-12-13 | Grundy | Iowa | 19075 | 1914 | 37 |
2005940 | 2005940 | 2021-12-12 | Grundy | Iowa | 19075 | 1914 | 37 |
2008025 | 2008025 | 2021-12-12 | Orange | Vermont | 50017 | 1914 | 8 |
2002689 | 2002689 | 2021-12-11 | Grundy | Iowa | 19075 | 1914 | 37 |
1999439 | 1999439 | 2021-12-10 | Grundy | Iowa | 19075 | 1914 | 37 |
1996188 | 1996188 | 2021-12-09 | Grundy | Iowa | 19075 | 1914 | 37 |
1992353 | 1992353 | 2021-12-08 | Bent | Colorado | 8011 | 1914 | 32 |
1992937 | 1992937 | 2021-12-08 | Grundy | Iowa | 19075 | 1914 | 37 |
1990488 | 1990488 | 2021-12-07 | Jefferson | Montana | 30043 | 1914 | 18 |
1990887 | 1990887 | 2021-12-07 | Mercer | North Dakota | 38057 | 1914 | 19 |
1987238 | 1987238 | 2021-12-06 | Jefferson | Montana | 30043 | 1914 | 17 |
1983463 | 1983463 | 2021-12-05 | Todd | Kentucky | 21219 | 1914 | 36 |
1980213 | 1980213 | 2021-12-04 | Todd | Kentucky | 21219 | 1914 | 36 |
1976963 | 1976963 | 2021-12-03 | Todd | Kentucky | 21219 | 1914 | 36 |
1969954 | 1969954 | 2021-12-01 | Washington | Idaho | 16087 | 1914 | 47 |
1958240 | 1958240 | 2021-11-27 | Schuyler | New York | 36097 | 1914 | 20 |
1929459 | 1929459 | 2021-11-18 | Hatillo | Puerto Rico | 72065 | 1914 | |
1920611 | 1920611 | 2021-11-16 | Conecuh | Alabama | 1035 | 1914 | 60 |
1903129 | 1903129 | 2021-11-10 | McLean | North Dakota | 38055 | 1914 | 41 |
1884068 | 1884068 | 2021-11-04 | Butte | South Dakota | 46019 | 1914 | 31 |
1878303 | 1878303 | 2021-11-02 | Price | Wisconsin | 55099 | 1914 | 12 |
1869679 | 1869679 | 2021-10-31 | Martin | Kentucky | 21159 | 1914 | 35 |
1866430 | 1866430 | 2021-10-30 | Martin | Kentucky | 21159 | 1914 | 35 |
1863181 | 1863181 | 2021-10-29 | Martin | Kentucky | 21159 | 1914 | 35 |
1850446 | 1850446 | 2021-10-25 | Chippewa | Minnesota | 27023 | 1914 | 40 |
1826271 | 1826271 | 2021-10-17 | Buffalo | Wisconsin | 55011 | 1914 | 8 |
1784985 | 1784985 | 2021-10-05 | Mills | Iowa | 19129 | 1914 | 25 |
1786353 | 1786353 | 2021-10-05 | Baker | Oregon | 41001 | 1914 | 25 |
1781736 | 1781736 | 2021-10-04 | Mills | Iowa | 19129 | 1914 | 25 |
1778486 | 1778486 | 2021-10-03 | Mills | Iowa | 19129 | 1914 | 25 |
1775236 | 1775236 | 2021-10-02 | Mills | Iowa | 19129 | 1914 | 25 |
1771986 | 1771986 | 2021-10-01 | Mills | Iowa | 19129 | 1914 | 25 |
1768737 | 1768737 | 2021-09-30 | Mills | Iowa | 19129 | 1914 | 25 |
1765488 | 1765488 | 2021-09-29 | Mills | Iowa | 19129 | 1914 | 25 |
1767787 | 1767787 | 2021-09-29 | Burnett | Wisconsin | 55013 | 1914 | 29 |
1745251 | 1745251 | 2021-09-23 | Bradley | Arkansas | 5011 | 1914 | 37 |
1745810 | 1745810 | 2021-09-23 | Piatt | Illinois | 17147 | 1914 | 20 |
1743134 | 1743134 | 2021-09-22 | Antrim | Michigan | 26009 | 1914 | 34 |
1723807 | 1723807 | 2021-09-16 | Amite | Mississippi | 28005 | 1914 | 51 |
1671768 | 1671768 | 2021-08-31 | Houston | Minnesota | 27055 | 1914 | 16 |
1624920 | 1624920 | 2021-08-16 | Carbon | Wyoming | 56007 | 1914 | 25 |
1618586 | 1618586 | 2021-08-15 | Howard | Arkansas | 5061 | 1914 | 28 |
1619218 | 1619218 | 2021-08-15 | Rush | Indiana | 18139 | 1914 | 27 |
1619630 | 1619630 | 2021-08-15 | Winn | Louisiana | 22127 | 1914 | 48 |
1621508 | 1621508 | 2021-08-15 | Clallam | Washington | 53009 | 1914 | 17 |
1615970 | 1615970 | 2021-08-14 | Rush | Indiana | 18139 | 1914 | 27 |
1616382 | 1616382 | 2021-08-14 | Winn | Louisiana | 22127 | 1914 | 48 |
1618260 | 1618260 | 2021-08-14 | Clallam | Washington | 53009 | 1914 | 17 |
1612721 | 1612721 | 2021-08-13 | Rush | Indiana | 18139 | 1914 | 27 |
1613133 | 1613133 | 2021-08-13 | Winn | Louisiana | 22127 | 1914 | 48 |
1615012 | 1615012 | 2021-08-13 | Clallam | Washington | 53009 | 1914 | 17 |
1608662 | 1608662 | 2021-08-11 | Sawyer | Wisconsin | 55113 | 1914 | 29 |
1602882 | 1602882 | 2021-08-10 | Richland | Illinois | 17159 | 1914 | 53 |
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);