ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
339 rows where cases = 1528 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 49
- Georgia 34
- Montana 21
- Louisiana 18
- Iowa 17
- Kentucky 12
- Alabama 11
- Missouri 11
- Nebraska 11
- Kansas 10
- Virginia 10
- Minnesota 9
- Wisconsin 9
- Tennessee 8
- Illinois 7
- Indiana 7
- Michigan 7
- North Carolina 7
- Puerto Rico 7
- West Virginia 7
- Mississippi 6
- North Dakota 6
- Oklahoma 6
- Arkansas 5
- Oregon 5
- Ohio 4
- South Carolina 4
- Washington 4
- Alaska 3
- New Mexico 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491488 | 2491488 | 2022-05-10 | Cedar | Nebraska | 31027 | 1528 | 14 |
2488230 | 2488230 | 2022-05-09 | Cedar | Nebraska | 31027 | 1528 | 14 |
2446871 | 2446871 | 2022-04-26 | Carson | Texas | 48065 | 1528 | 36 |
2443616 | 2443616 | 2022-04-25 | Carson | Texas | 48065 | 1528 | 36 |
2440360 | 2440360 | 2022-04-24 | Carson | Texas | 48065 | 1528 | 36 |
2437104 | 2437104 | 2022-04-23 | Carson | Texas | 48065 | 1528 | 36 |
2433848 | 2433848 | 2022-04-22 | Carson | Texas | 48065 | 1528 | 36 |
2430592 | 2430592 | 2022-04-21 | Carson | Texas | 48065 | 1528 | 36 |
2427336 | 2427336 | 2022-04-20 | Carson | Texas | 48065 | 1528 | 36 |
2393780 | 2393780 | 2022-04-10 | Stillwater | Montana | 30095 | 1528 | 30 |
2390524 | 2390524 | 2022-04-09 | Stillwater | Montana | 30095 | 1528 | 30 |
2387268 | 2387268 | 2022-04-08 | Stillwater | Montana | 30095 | 1528 | 30 |
2384013 | 2384013 | 2022-04-07 | Stillwater | Montana | 30095 | 1528 | 30 |
2369868 | 2369868 | 2022-04-03 | Twiggs | Georgia | 13289 | 1528 | 69 |
2366615 | 2366615 | 2022-04-02 | Twiggs | Georgia | 13289 | 1528 | 69 |
2363362 | 2363362 | 2022-04-01 | Twiggs | Georgia | 13289 | 1528 | 69 |
2324324 | 2324324 | 2022-03-20 | Twiggs | Georgia | 13289 | 1528 | 69 |
2321070 | 2321070 | 2022-03-19 | Twiggs | Georgia | 13289 | 1528 | 69 |
2317816 | 2317816 | 2022-03-18 | Twiggs | Georgia | 13289 | 1528 | 69 |
2314563 | 2314563 | 2022-03-17 | Twiggs | Georgia | 13289 | 1528 | 69 |
2301554 | 2301554 | 2022-03-13 | Twiggs | Georgia | 13289 | 1528 | 68 |
2298302 | 2298302 | 2022-03-12 | Twiggs | Georgia | 13289 | 1528 | 68 |
2295050 | 2295050 | 2022-03-11 | Twiggs | Georgia | 13289 | 1528 | 68 |
2291798 | 2291798 | 2022-03-10 | Twiggs | Georgia | 13289 | 1528 | 68 |
2288546 | 2288546 | 2022-03-09 | Twiggs | Georgia | 13289 | 1528 | 68 |
2282043 | 2282043 | 2022-03-07 | Twiggs | Georgia | 13289 | 1528 | 67 |
2278790 | 2278790 | 2022-03-06 | Twiggs | Georgia | 13289 | 1528 | 67 |
2275537 | 2275537 | 2022-03-05 | Twiggs | Georgia | 13289 | 1528 | 67 |
2272284 | 2272284 | 2022-03-04 | Twiggs | Georgia | 13289 | 1528 | 67 |
2269032 | 2269032 | 2022-03-03 | Twiggs | Georgia | 13289 | 1528 | 67 |
2265779 | 2265779 | 2022-03-02 | Twiggs | Georgia | 13289 | 1528 | 67 |
2266967 | 2266967 | 2022-03-02 | Keith | Nebraska | 31101 | 1528 | 17 |
2219731 | 2219731 | 2022-02-15 | Weston | Wyoming | 56045 | 1528 | 17 |
2215472 | 2215472 | 2022-02-14 | Grant | Oregon | 41023 | 1528 | 18 |
2212221 | 2212221 | 2022-02-13 | Grant | Oregon | 41023 | 1528 | 18 |
2208968 | 2208968 | 2022-02-12 | Grant | Oregon | 41023 | 1528 | 18 |
2205715 | 2205715 | 2022-02-11 | Grant | Oregon | 41023 | 1528 | 18 |
2179008 | 2179008 | 2022-02-03 | Maries | Missouri | 29125 | 1528 | 28 |
2167217 | 2167217 | 2022-01-30 | Marion | Texas | 48315 | 1528 | 55 |
2153174 | 2153174 | 2022-01-26 | Thurston | Nebraska | 31173 | 1528 | 19 |
2130983 | 2130983 | 2022-01-19 | Arroyo | Puerto Rico | 72015 | 1528 | |
2124823 | 2124823 | 2022-01-17 | Delta | Texas | 48119 | 1528 | 22 |
2120645 | 2120645 | 2022-01-16 | Wayne | Nebraska | 31179 | 1528 | 11 |
2117393 | 2117393 | 2022-01-15 | Wayne | Nebraska | 31179 | 1528 | 11 |
2114142 | 2114142 | 2022-01-14 | Wayne | Nebraska | 31179 | 1528 | 11 |
2086470 | 2086470 | 2022-01-06 | Greenlee | Arizona | 4011 | 1528 | 27 |
2087350 | 2087350 | 2022-01-06 | Russell | Kansas | 20167 | 1528 | 34 |
2088761 | 2088761 | 2022-01-06 | Rincon | Puerto Rico | 72117 | 1528 | |
2084098 | 2084098 | 2022-01-05 | Russell | Kansas | 20167 | 1528 | 34 |
2061150 | 2061150 | 2021-12-29 | Warren | Indiana | 18171 | 1528 | 22 |
2063179 | 2063179 | 2021-12-29 | Red River | Texas | 48387 | 1528 | 57 |
2063510 | 2063510 | 2021-12-29 | Webster | West Virginia | 54101 | 1528 | 27 |
2059929 | 2059929 | 2021-12-28 | Red River | Texas | 48387 | 1528 | 57 |
2060192 | 2060192 | 2021-12-28 | Lincoln | Washington | 53043 | 1528 | 26 |
2000149 | 2000149 | 2021-12-10 | Iron | Missouri | 29093 | 1528 | 28 |
2001741 | 2001741 | 2021-12-10 | Pleasants | West Virginia | 54073 | 1528 | 31 |
1996277 | 1996277 | 2021-12-09 | Ellsworth | Kansas | 20053 | 1528 | 31 |
1993026 | 1993026 | 2021-12-08 | Ellsworth | Kansas | 20053 | 1528 | 31 |
1988857 | 1988857 | 2021-12-07 | Bullock | Alabama | 1011 | 1528 | 45 |
1985607 | 1985607 | 2021-12-06 | Bullock | Alabama | 1011 | 1528 | 45 |
1986357 | 1986357 | 2021-12-06 | Martin | Indiana | 18101 | 1528 | 20 |
1982357 | 1982357 | 2021-12-05 | Bullock | Alabama | 1011 | 1528 | 45 |
1984043 | 1984043 | 2021-12-05 | Custer | Nebraska | 31041 | 1528 | 23 |
1979107 | 1979107 | 2021-12-04 | Bullock | Alabama | 1011 | 1528 | 45 |
1980793 | 1980793 | 2021-12-04 | Custer | Nebraska | 31041 | 1528 | 23 |
1977543 | 1977543 | 2021-12-03 | Custer | Nebraska | 31041 | 1528 | 23 |
1944595 | 1944595 | 2021-11-23 | Baraga | Michigan | 26013 | 1528 | 47 |
1941344 | 1941344 | 2021-11-22 | Baraga | Michigan | 26013 | 1528 | 47 |
1938898 | 1938898 | 2021-11-21 | Traill | North Dakota | 38097 | 1528 | 21 |
1935648 | 1935648 | 2021-11-20 | Traill | North Dakota | 38097 | 1528 | 21 |
1924925 | 1924925 | 2021-11-17 | McLean | Kentucky | 21149 | 1528 | 40 |
1921410 | 1921410 | 2021-11-16 | Clarke | Iowa | 19039 | 1528 | 29 |
1918160 | 1918160 | 2021-11-15 | Clarke | Iowa | 19039 | 1528 | 29 |
1920159 | 1920159 | 2021-11-15 | Rains | Texas | 48379 | 1528 | 47 |
1914910 | 1914910 | 2021-11-14 | Clarke | Iowa | 19039 | 1528 | 29 |
1915457 | 1915457 | 2021-11-14 | Koochiching | Minnesota | 27071 | 1528 | 21 |
1916909 | 1916909 | 2021-11-14 | Rains | Texas | 48379 | 1528 | 47 |
1911660 | 1911660 | 2021-11-13 | Clarke | Iowa | 19039 | 1528 | 29 |
1912207 | 1912207 | 2021-11-13 | Koochiching | Minnesota | 27071 | 1528 | 21 |
1913659 | 1913659 | 2021-11-13 | Rains | Texas | 48379 | 1528 | 47 |
1908411 | 1908411 | 2021-11-12 | Clarke | Iowa | 19039 | 1528 | 29 |
1908957 | 1908957 | 2021-11-12 | Koochiching | Minnesota | 27071 | 1528 | 21 |
1910409 | 1910409 | 2021-11-12 | Rains | Texas | 48379 | 1528 | 47 |
1905162 | 1905162 | 2021-11-11 | Clarke | Iowa | 19039 | 1528 | 29 |
1907160 | 1907160 | 2021-11-11 | Rains | Texas | 48379 | 1528 | 47 |
1907263 | 1907263 | 2021-11-11 | Orange | Vermont | 50017 | 1528 | 6 |
1901912 | 1901912 | 2021-11-10 | Clarke | Iowa | 19039 | 1528 | 29 |
1903911 | 1903911 | 2021-11-10 | Rains | Texas | 48379 | 1528 | 47 |
1900661 | 1900661 | 2021-11-09 | Rains | Texas | 48379 | 1528 | 47 |
1876918 | 1876918 | 2021-11-02 | Colfax | New Mexico | 35007 | 1528 | 48 |
1871775 | 1871775 | 2021-10-31 | Forest | Wisconsin | 55041 | 1528 | 31 |
1868526 | 1868526 | 2021-10-30 | Forest | Wisconsin | 55041 | 1528 | 31 |
1865277 | 1865277 | 2021-10-29 | Forest | Wisconsin | 55041 | 1528 | 31 |
1861657 | 1861657 | 2021-10-28 | Ochiltree | Texas | 48357 | 1528 | 37 |
1858408 | 1858408 | 2021-10-27 | Ochiltree | Texas | 48357 | 1528 | 37 |
1854898 | 1854898 | 2021-10-26 | Clay | Tennessee | 47027 | 1528 | 37 |
1850676 | 1850676 | 2021-10-25 | Montgomery | Missouri | 29139 | 1528 | 19 |
1847426 | 1847426 | 2021-10-24 | Montgomery | Missouri | 29139 | 1528 | 19 |
1833352 | 1833352 | 2021-10-20 | Montgomery | Georgia | 13209 | 1528 | 39 |
1830103 | 1830103 | 2021-10-19 | Montgomery | Georgia | 13209 | 1528 | 39 |
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);