ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
188 rows where cases = 2962 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 25
- Georgia 13
- Missouri 11
- Minnesota 9
- Oklahoma 9
- Texas 8
- West Virginia 8
- Alabama 7
- California 7
- Indiana 7
- North Carolina 7
- Virginia 7
- Illinois 5
- Kentucky 5
- Michigan 5
- South Carolina 5
- Tennessee 5
- Wisconsin 5
- New York 4
- Oregon 4
- Pennsylvania 4
- Puerto Rico 4
- Florida 3
- Mississippi 3
- Ohio 3
- Arkansas 2
- Colorado 2
- Kansas 2
- Louisiana 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500387 | 2500387 | 2022-05-13 | Cass | Iowa | 19029 | 2962 | 78 |
2497129 | 2497129 | 2022-05-12 | Cass | Iowa | 19029 | 2962 | 78 |
2493871 | 2493871 | 2022-05-11 | Cass | Iowa | 19029 | 2962 | 78 |
2490613 | 2490613 | 2022-05-10 | Cass | Iowa | 19029 | 2962 | 78 |
2487356 | 2487356 | 2022-05-09 | Cass | Iowa | 19029 | 2962 | 78 |
2484098 | 2484098 | 2022-05-08 | Cass | Iowa | 19029 | 2962 | 78 |
2480840 | 2480840 | 2022-05-07 | Cass | Iowa | 19029 | 2962 | 78 |
2477582 | 2477582 | 2022-05-06 | Cass | Iowa | 19029 | 2962 | 78 |
2474324 | 2474324 | 2022-05-05 | Cass | Iowa | 19029 | 2962 | 78 |
2471067 | 2471067 | 2022-05-04 | Cass | Iowa | 19029 | 2962 | 78 |
2443212 | 2443212 | 2022-04-25 | Morrow | Oregon | 41049 | 2962 | 34 |
2401899 | 2401899 | 2022-04-13 | Coosa | Alabama | 1037 | 2962 | 58 |
2398644 | 2398644 | 2022-04-12 | Coosa | Alabama | 1037 | 2962 | 58 |
2399441 | 2399441 | 2022-04-12 | Cherokee | Iowa | 19035 | 2962 | 61 |
2396185 | 2396185 | 2022-04-11 | Cherokee | Iowa | 19035 | 2962 | 61 |
2392930 | 2392930 | 2022-04-10 | Cherokee | Iowa | 19035 | 2962 | 61 |
2389674 | 2389674 | 2022-04-09 | Cherokee | Iowa | 19035 | 2962 | 61 |
2386418 | 2386418 | 2022-04-08 | Cherokee | Iowa | 19035 | 2962 | 61 |
2383164 | 2383164 | 2022-04-07 | Cherokee | Iowa | 19035 | 2962 | 61 |
2379909 | 2379909 | 2022-04-06 | Cherokee | Iowa | 19035 | 2962 | 61 |
2316556 | 2316556 | 2022-03-17 | Todd | South Dakota | 46121 | 2962 | 51 |
2302432 | 2302432 | 2022-03-13 | Watonwan | Minnesota | 27165 | 2962 | 23 |
2299180 | 2299180 | 2022-03-12 | Watonwan | Minnesota | 27165 | 2962 | 23 |
2295928 | 2295928 | 2022-03-11 | Watonwan | Minnesota | 27165 | 2962 | 23 |
2267246 | 2267246 | 2022-03-02 | Washington | North Carolina | 37187 | 2962 | 48 |
2203164 | 2203164 | 2022-02-10 | Brunswick | Virginia | 51025 | 2962 | 38 |
2173173 | 2173173 | 2022-02-01 | Baker | Oregon | 41001 | 2962 | 42 |
2170923 | 2170923 | 2022-01-31 | Converse | Wyoming | 56009 | 2962 | 49 |
2156200 | 2156200 | 2022-01-27 | Dent | Missouri | 29065 | 2962 | 66 |
2151222 | 2151222 | 2022-01-25 | Westmoreland | Virginia | 51193 | 2962 | 39 |
2147586 | 2147586 | 2022-01-24 | Comanche | Texas | 48093 | 2962 | 70 |
2131038 | 2131038 | 2022-01-19 | Salinas | Puerto Rico | 72123 | 2962 | |
2126206 | 2126206 | 2022-01-18 | Clayton | Iowa | 19043 | 2962 | 67 |
2127577 | 2127577 | 2022-01-18 | Kingfisher | Oklahoma | 40073 | 2962 | 56 |
2127726 | 2127726 | 2022-01-18 | Aibonito | Puerto Rico | 72009 | 2962 | |
2122954 | 2122954 | 2022-01-17 | Clayton | Iowa | 19043 | 2962 | 67 |
2124325 | 2124325 | 2022-01-17 | Kingfisher | Oklahoma | 40073 | 2962 | 56 |
2119702 | 2119702 | 2022-01-16 | Clayton | Iowa | 19043 | 2962 | 67 |
2121073 | 2121073 | 2022-01-16 | Kingfisher | Oklahoma | 40073 | 2962 | 56 |
2116450 | 2116450 | 2022-01-15 | Clayton | Iowa | 19043 | 2962 | 67 |
2117821 | 2117821 | 2022-01-15 | Kingfisher | Oklahoma | 40073 | 2962 | 56 |
2113199 | 2113199 | 2022-01-14 | Clayton | Iowa | 19043 | 2962 | 67 |
2114570 | 2114570 | 2022-01-14 | Kingfisher | Oklahoma | 40073 | 2962 | 56 |
2109947 | 2109947 | 2022-01-13 | Clayton | Iowa | 19043 | 2962 | 67 |
2111318 | 2111318 | 2022-01-13 | Kingfisher | Oklahoma | 40073 | 2962 | 56 |
2106696 | 2106696 | 2022-01-12 | Clayton | Iowa | 19043 | 2962 | 67 |
2108066 | 2108066 | 2022-01-12 | Kingfisher | Oklahoma | 40073 | 2962 | 56 |
2096596 | 2096596 | 2022-01-09 | Jefferson | Georgia | 13163 | 2962 | 95 |
2093344 | 2093344 | 2022-01-08 | Jefferson | Georgia | 13163 | 2962 | 95 |
2090092 | 2090092 | 2022-01-07 | Jefferson | Georgia | 13163 | 2962 | 95 |
2086841 | 2086841 | 2022-01-06 | Jefferson | Georgia | 13163 | 2962 | 95 |
2087984 | 2087984 | 2022-01-06 | Wright | Missouri | 29229 | 2962 | 68 |
2083589 | 2083589 | 2022-01-05 | Jefferson | Georgia | 13163 | 2962 | 95 |
2082314 | 2082314 | 2022-01-04 | Lee | South Carolina | 45061 | 2962 | 82 |
2060261 | 2060261 | 2021-12-28 | Wetzel | West Virginia | 54103 | 2962 | 68 |
1986216 | 1986216 | 2021-12-06 | Clay | Illinois | 17025 | 2962 | 59 |
1982976 | 1982976 | 2021-12-05 | Edgar | Illinois | 17045 | 2962 | 70 |
1979726 | 1979726 | 2021-12-04 | Edgar | Illinois | 17045 | 2962 | 70 |
1976476 | 1976476 | 2021-12-03 | Edgar | Illinois | 17045 | 2962 | 70 |
1965384 | 1965384 | 2021-11-29 | Benton | Tennessee | 47005 | 2962 | 56 |
1965953 | 1965953 | 2021-11-29 | Barbour | West Virginia | 54001 | 2962 | 52 |
1951255 | 1951255 | 2021-11-25 | Wadena | Minnesota | 27159 | 2962 | 39 |
1948004 | 1948004 | 2021-11-24 | Wadena | Minnesota | 27159 | 2962 | 39 |
1914564 | 1914564 | 2021-11-14 | Jeff Davis | Georgia | 13161 | 2962 | 60 |
1911314 | 1911314 | 2021-11-13 | Jeff Davis | Georgia | 13161 | 2962 | 60 |
1908065 | 1908065 | 2021-11-12 | Jeff Davis | Georgia | 13161 | 2962 | 60 |
1887615 | 1887615 | 2021-11-05 | Lee | Texas | 48287 | 2962 | 51 |
1882856 | 1882856 | 2021-11-04 | Cheboygan | Michigan | 26031 | 2962 | 68 |
1884365 | 1884365 | 2021-11-04 | Lee | Texas | 48287 | 2962 | 51 |
1884722 | 1884722 | 2021-11-04 | McDowell | West Virginia | 54047 | 2962 | 50 |
1879607 | 1879607 | 2021-11-03 | Cheboygan | Michigan | 26031 | 2962 | 68 |
1881116 | 1881116 | 2021-11-03 | Lee | Texas | 48287 | 2962 | 51 |
1875238 | 1875238 | 2021-11-02 | Hempstead | Arkansas | 5057 | 2962 | 39 |
1852845 | 1852845 | 2021-10-26 | Meriwether | Georgia | 13199 | 2962 | 111 |
1839227 | 1839227 | 2021-10-21 | Lewis | West Virginia | 54041 | 2962 | 50 |
1816468 | 1816468 | 2021-10-14 | Brooke | West Virginia | 54009 | 2962 | 68 |
1813334 | 1813334 | 2021-10-13 | Vilas | Wisconsin | 55125 | 2962 | 52 |
1800400 | 1800400 | 2021-10-10 | Hale | Alabama | 1065 | 2962 | 86 |
1744253 | 1744253 | 2021-09-22 | Humacao | Puerto Rico | 72069 | 2962 | |
1739329 | 1739329 | 2021-09-21 | Union | Illinois | 17181 | 2962 | 51 |
1741004 | 1741004 | 2021-09-21 | Humacao | Puerto Rico | 72069 | 2962 | |
1727209 | 1727209 | 2021-09-17 | New Madrid | Missouri | 29143 | 2962 | 50 |
1723510 | 1723510 | 2021-09-16 | Woodford | Kentucky | 21239 | 2962 | 25 |
1720679 | 1720679 | 2021-09-15 | Henry | Missouri | 29083 | 2962 | 46 |
1714139 | 1714139 | 2021-09-13 | Winston | Mississippi | 28159 | 2962 | 90 |
1702835 | 1702835 | 2021-09-09 | Jackson | Wisconsin | 55053 | 2962 | 29 |
1699237 | 1699237 | 2021-09-08 | Scurry | Texas | 48415 | 2962 | 68 |
1647379 | 1647379 | 2021-08-23 | Carroll | Virginia | 51035 | 2962 | 81 |
1619159 | 1619159 | 2021-08-15 | Clay | Indiana | 18021 | 2962 | 49 |
1615911 | 1615911 | 2021-08-14 | Clay | Indiana | 18021 | 2962 | 49 |
1612662 | 1612662 | 2021-08-13 | Clay | Indiana | 18021 | 2962 | 49 |
1580545 | 1580545 | 2021-08-03 | Montgomery | Kentucky | 21173 | 2962 | 30 |
1565988 | 1565988 | 2021-07-29 | Limestone | Texas | 48293 | 2962 | 81 |
1556530 | 1556530 | 2021-07-26 | Winchester city | Virginia | 51840 | 2962 | 48 |
1496100 | 1496100 | 2021-07-08 | Logan | Kentucky | 21141 | 2962 | 73 |
1492043 | 1492043 | 2021-07-07 | Delta | Colorado | 8029 | 2962 | 66 |
1488796 | 1488796 | 2021-07-06 | Delta | Colorado | 8029 | 2962 | 66 |
1491671 | 1491671 | 2021-07-06 | Preston | West Virginia | 54077 | 2962 | 46 |
1466010 | 1466010 | 2021-06-29 | Glenn | California | 6021 | 2962 | 27 |
1420946 | 1420946 | 2021-06-15 | Cassia | Idaho | 16031 | 2962 | 27 |
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);