ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
321 rows where cases = 1509 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 27
- Kentucky 24
- Georgia 23
- Illinois 17
- Virginia 17
- Iowa 16
- Missouri 12
- Puerto Rico 12
- Minnesota 11
- Oklahoma 10
- Wisconsin 10
- Michigan 9
- Arkansas 8
- Kansas 8
- Louisiana 8
- Montana 7
- Nebraska 7
- North Carolina 7
- Ohio 7
- Alabama 6
- Colorado 6
- South Dakota 6
- California 5
- Indiana 5
- Mississippi 5
- Tennessee 5
- Alaska 4
- Florida 4
- Idaho 4
- Utah 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403567 | 2403567 | 2022-04-13 | Cedar | Nebraska | 31027 | 1509 | 14 |
2400312 | 2400312 | 2022-04-12 | Cedar | Nebraska | 31027 | 1509 | 14 |
2397057 | 2397057 | 2022-04-11 | Cedar | Nebraska | 31027 | 1509 | 14 |
2358006 | 2358006 | 2022-03-30 | Cedar | Nebraska | 31027 | 1509 | 14 |
2353554 | 2353554 | 2022-03-29 | Marion | Georgia | 13197 | 1509 | 50 |
2353891 | 2353891 | 2022-03-29 | Decatur | Iowa | 19053 | 1509 | 26 |
2350302 | 2350302 | 2022-03-28 | Marion | Georgia | 13197 | 1509 | 50 |
2350639 | 2350639 | 2022-03-28 | Decatur | Iowa | 19053 | 1509 | 26 |
2347386 | 2347386 | 2022-03-27 | Decatur | Iowa | 19053 | 1509 | 26 |
2344133 | 2344133 | 2022-03-26 | Decatur | Iowa | 19053 | 1509 | 26 |
2340880 | 2340880 | 2022-03-25 | Decatur | Iowa | 19053 | 1509 | 26 |
2337493 | 2337493 | 2022-03-24 | Stark | Illinois | 17175 | 1509 | 32 |
2337627 | 2337627 | 2022-03-24 | Decatur | Iowa | 19053 | 1509 | 26 |
2334373 | 2334373 | 2022-03-23 | Decatur | Iowa | 19053 | 1509 | 26 |
2330985 | 2330985 | 2022-03-22 | Stark | Illinois | 17175 | 1509 | 32 |
2327733 | 2327733 | 2022-03-21 | Stark | Illinois | 17175 | 1509 | 32 |
2324480 | 2324480 | 2022-03-20 | Stark | Illinois | 17175 | 1509 | 32 |
2321226 | 2321226 | 2022-03-19 | Stark | Illinois | 17175 | 1509 | 32 |
2317972 | 2317972 | 2022-03-18 | Stark | Illinois | 17175 | 1509 | 32 |
2318968 | 2318968 | 2022-03-18 | Cedar | Nebraska | 31027 | 1509 | 14 |
2314719 | 2314719 | 2022-03-17 | Stark | Illinois | 17175 | 1509 | 32 |
2315715 | 2315715 | 2022-03-17 | Cedar | Nebraska | 31027 | 1509 | 14 |
2311466 | 2311466 | 2022-03-16 | Stark | Illinois | 17175 | 1509 | 32 |
2313002 | 2313002 | 2022-03-16 | Tillman | Oklahoma | 40141 | 1509 | 31 |
2307779 | 2307779 | 2022-03-15 | Clear Creek | Colorado | 8019 | 1509 | 11 |
2308213 | 2308213 | 2022-03-15 | Stark | Illinois | 17175 | 1509 | 32 |
2309121 | 2309121 | 2022-03-15 | Shelby | Missouri | 29205 | 1509 | 15 |
2309749 | 2309749 | 2022-03-15 | Tillman | Oklahoma | 40141 | 1509 | 31 |
2304962 | 2304962 | 2022-03-14 | Stark | Illinois | 17175 | 1509 | 32 |
2306496 | 2306496 | 2022-03-14 | Tillman | Oklahoma | 40141 | 1509 | 31 |
2303245 | 2303245 | 2022-03-13 | Tillman | Oklahoma | 40141 | 1509 | 31 |
2299993 | 2299993 | 2022-03-12 | Tillman | Oklahoma | 40141 | 1509 | 31 |
2296741 | 2296741 | 2022-03-11 | Tillman | Oklahoma | 40141 | 1509 | 31 |
2293489 | 2293489 | 2022-03-10 | Tillman | Oklahoma | 40141 | 1509 | 31 |
2279341 | 2279341 | 2022-03-06 | Menifee | Kentucky | 21165 | 1509 | 30 |
2276088 | 2276088 | 2022-03-05 | Menifee | Kentucky | 21165 | 1509 | 30 |
2272835 | 2272835 | 2022-03-04 | Menifee | Kentucky | 21165 | 1509 | 30 |
2239846 | 2239846 | 2022-02-22 | Calhoun | Illinois | 17013 | 1509 | 8 |
2210511 | 2210511 | 2022-02-13 | Twiggs | Georgia | 13289 | 1509 | 66 |
2207258 | 2207258 | 2022-02-12 | Twiggs | Georgia | 13289 | 1509 | 66 |
2204005 | 2204005 | 2022-02-11 | Twiggs | Georgia | 13289 | 1509 | 66 |
2183349 | 2183349 | 2022-02-04 | Brooks | Texas | 48047 | 1509 | 49 |
2152935 | 2152935 | 2022-01-26 | Chariton | Missouri | 29041 | 1509 | 33 |
2139979 | 2139979 | 2022-01-22 | Ozark | Missouri | 29153 | 1509 | 48 |
2115105 | 2115105 | 2022-01-14 | Hansford | Texas | 48195 | 1509 | 27 |
2112267 | 2112267 | 2022-01-13 | Pocahontas | West Virginia | 54075 | 1509 | 23 |
2104052 | 2104052 | 2022-01-11 | Choctaw | Mississippi | 28019 | 1509 | 27 |
2083426 | 2083426 | 2022-01-05 | Yuma | Colorado | 8125 | 1509 | 22 |
2070272 | 2070272 | 2022-01-01 | Nevada | Arkansas | 5099 | 1509 | 42 |
2058141 | 2058141 | 2021-12-28 | Cumberland | Kentucky | 21057 | 1509 | 23 |
2040138 | 2040138 | 2021-12-22 | Turner | South Dakota | 46125 | 1509 | 62 |
2027023 | 2027023 | 2021-12-18 | Yauco | Puerto Rico | 72153 | 1509 | |
1991691 | 1991691 | 2021-12-07 | Somervell | Texas | 48425 | 1509 | 24 |
1988440 | 1988440 | 2021-12-06 | Somervell | Texas | 48425 | 1509 | 24 |
1983738 | 1983738 | 2021-12-05 | Pipestone | Minnesota | 27117 | 1509 | 29 |
1985190 | 1985190 | 2021-12-05 | Somervell | Texas | 48425 | 1509 | 24 |
1980488 | 1980488 | 2021-12-04 | Pipestone | Minnesota | 27117 | 1509 | 29 |
1981940 | 1981940 | 2021-12-04 | Somervell | Texas | 48425 | 1509 | 24 |
1977238 | 1977238 | 2021-12-03 | Pipestone | Minnesota | 27117 | 1509 | 29 |
1960978 | 1960978 | 2021-11-28 | Murray | Minnesota | 27101 | 1509 | 11 |
1957727 | 1957727 | 2021-11-27 | Murray | Minnesota | 27101 | 1509 | 11 |
1954476 | 1954476 | 2021-11-26 | Murray | Minnesota | 27101 | 1509 | 11 |
1945004 | 1945004 | 2021-11-23 | Sanders | Montana | 30089 | 1509 | 29 |
1941713 | 1941713 | 2021-11-22 | Carbon | Montana | 30009 | 1509 | 22 |
1938386 | 1938386 | 2021-11-21 | Howard | Missouri | 29089 | 1509 | 19 |
1921587 | 1921587 | 2021-11-16 | Thomas | Kansas | 20193 | 1509 | 22 |
1918337 | 1918337 | 2021-11-15 | Thomas | Kansas | 20193 | 1509 | 22 |
1905960 | 1905960 | 2021-11-11 | Beaverhead | Montana | 30001 | 1509 | 20 |
1902711 | 1902711 | 2021-11-10 | Beaverhead | Montana | 30001 | 1509 | 20 |
1899125 | 1899125 | 2021-11-09 | Iron | Michigan | 26071 | 1509 | 59 |
1895145 | 1895145 | 2021-11-08 | Wilkinson | Georgia | 13319 | 1509 | 45 |
1895875 | 1895875 | 2021-11-08 | Iron | Michigan | 26071 | 1509 | 59 |
1891638 | 1891638 | 2021-11-07 | Park | Colorado | 8093 | 1509 | 10 |
1891895 | 1891895 | 2021-11-07 | Wilkinson | Georgia | 13319 | 1509 | 45 |
1891946 | 1891946 | 2021-11-07 | Valley | Idaho | 16085 | 1509 | 12 |
1892315 | 1892315 | 2021-11-07 | Pawnee | Kansas | 20145 | 1509 | 16 |
1888388 | 1888388 | 2021-11-06 | Park | Colorado | 8093 | 1509 | 10 |
1888645 | 1888645 | 2021-11-06 | Wilkinson | Georgia | 13319 | 1509 | 45 |
1888696 | 1888696 | 2021-11-06 | Valley | Idaho | 16085 | 1509 | 12 |
1889065 | 1889065 | 2021-11-06 | Pawnee | Kansas | 20145 | 1509 | 16 |
1885138 | 1885138 | 2021-11-05 | Park | Colorado | 8093 | 1509 | 10 |
1885395 | 1885395 | 2021-11-05 | Wilkinson | Georgia | 13319 | 1509 | 45 |
1885815 | 1885815 | 2021-11-05 | Pawnee | Kansas | 20145 | 1509 | 16 |
1847042 | 1847042 | 2021-10-24 | West Feliciana | Louisiana | 22125 | 1509 | 40 |
1843792 | 1843792 | 2021-10-23 | West Feliciana | Louisiana | 22125 | 1509 | 40 |
1840542 | 1840542 | 2021-10-22 | West Feliciana | Louisiana | 22125 | 1509 | 40 |
1837293 | 1837293 | 2021-10-21 | West Feliciana | Louisiana | 22125 | 1509 | 40 |
1834044 | 1834044 | 2021-10-20 | West Feliciana | Louisiana | 22125 | 1509 | 40 |
1830795 | 1830795 | 2021-10-19 | West Feliciana | Louisiana | 22125 | 1509 | 40 |
1827546 | 1827546 | 2021-10-18 | West Feliciana | Louisiana | 22125 | 1509 | 40 |
1825629 | 1825629 | 2021-10-17 | Roberts | South Dakota | 46109 | 1509 | 43 |
1822380 | 1822380 | 2021-10-16 | Roberts | South Dakota | 46109 | 1509 | 43 |
1819131 | 1819131 | 2021-10-15 | Roberts | South Dakota | 46109 | 1509 | 43 |
1810632 | 1810632 | 2021-10-13 | Seminole | Georgia | 13253 | 1509 | 24 |
1807361 | 1807361 | 2021-10-12 | Montgomery | Georgia | 13209 | 1509 | 39 |
1780597 | 1780597 | 2021-10-03 | Franklin city | Virginia | 51620 | 1509 | 40 |
1777347 | 1777347 | 2021-10-02 | Franklin city | Virginia | 51620 | 1509 | 40 |
1774097 | 1774097 | 2021-10-01 | Franklin city | Virginia | 51620 | 1509 | 40 |
1755274 | 1755274 | 2021-09-26 | Atkinson | Georgia | 13003 | 1509 | 26 |
1752026 | 1752026 | 2021-09-25 | Atkinson | Georgia | 13003 | 1509 | 26 |
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);