ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
269 rows where cases = 1752 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 23
- Illinois 19
- Puerto Rico 18
- Texas 17
- Kansas 15
- Georgia 13
- Virginia 12
- Alabama 11
- Indiana 11
- Kentucky 11
- Missouri 11
- Oklahoma 10
- Minnesota 9
- Mississippi 9
- Arkansas 8
- Ohio 8
- Idaho 7
- Louisiana 7
- North Carolina 7
- Florida 6
- Colorado 4
- Nebraska 4
- South Dakota 3
- Tennessee 3
- Wisconsin 3
- Michigan 2
- Montana 2
- New York 2
- Pennsylvania 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468365 | 2468365 | 2022-05-03 | Lac qui Parle | Minnesota | 27073 | 1752 | 29 |
2399482 | 2399482 | 2022-04-12 | Lucas | Iowa | 19117 | 1752 | 32 |
2396226 | 2396226 | 2022-04-11 | Lucas | Iowa | 19117 | 1752 | 32 |
2392971 | 2392971 | 2022-04-10 | Lucas | Iowa | 19117 | 1752 | 32 |
2389715 | 2389715 | 2022-04-09 | Lucas | Iowa | 19117 | 1752 | 32 |
2386459 | 2386459 | 2022-04-08 | Lucas | Iowa | 19117 | 1752 | 32 |
2383205 | 2383205 | 2022-04-07 | Lucas | Iowa | 19117 | 1752 | 32 |
2379950 | 2379950 | 2022-04-06 | Lucas | Iowa | 19117 | 1752 | 32 |
2378900 | 2378900 | 2022-04-05 | Williamsburg city | Virginia | 51830 | 1752 | 22 |
2331191 | 2331191 | 2022-03-22 | Worth | Iowa | 19195 | 1752 | 14 |
2327939 | 2327939 | 2022-03-21 | Worth | Iowa | 19195 | 1752 | 14 |
2324686 | 2324686 | 2022-03-20 | Worth | Iowa | 19195 | 1752 | 14 |
2321432 | 2321432 | 2022-03-19 | Worth | Iowa | 19195 | 1752 | 14 |
2318178 | 2318178 | 2022-03-18 | Worth | Iowa | 19195 | 1752 | 14 |
2314925 | 2314925 | 2022-03-17 | Worth | Iowa | 19195 | 1752 | 14 |
2311672 | 2311672 | 2022-03-16 | Worth | Iowa | 19195 | 1752 | 14 |
2308149 | 2308149 | 2022-03-15 | Edwards | Illinois | 17047 | 1752 | 29 |
2287584 | 2287584 | 2022-03-08 | Refugio | Texas | 48391 | 1752 | 32 |
2284332 | 2284332 | 2022-03-07 | Refugio | Texas | 48391 | 1752 | 32 |
2281080 | 2281080 | 2022-03-06 | Refugio | Texas | 48391 | 1752 | 32 |
2277827 | 2277827 | 2022-03-05 | Refugio | Texas | 48391 | 1752 | 32 |
2274574 | 2274574 | 2022-03-04 | Refugio | Texas | 48391 | 1752 | 32 |
2271321 | 2271321 | 2022-03-03 | Refugio | Texas | 48391 | 1752 | 31 |
2257237 | 2257237 | 2022-02-27 | Richardson | Nebraska | 31147 | 1752 | 24 |
2253986 | 2253986 | 2022-02-26 | Richardson | Nebraska | 31147 | 1752 | 24 |
2250735 | 2250735 | 2022-02-25 | Richardson | Nebraska | 31147 | 1752 | 24 |
2222100 | 2222100 | 2022-02-16 | Hormigueros | Puerto Rico | 72067 | 1752 | |
2210911 | 2210911 | 2022-02-13 | Greenwood | Kansas | 20073 | 1752 | 20 |
2207658 | 2207658 | 2022-02-12 | Greenwood | Kansas | 20073 | 1752 | 20 |
2204405 | 2204405 | 2022-02-11 | Greenwood | Kansas | 20073 | 1752 | 20 |
2201152 | 2201152 | 2022-02-10 | Greenwood | Kansas | 20073 | 1752 | 20 |
2197898 | 2197898 | 2022-02-09 | Greenwood | Kansas | 20073 | 1752 | 20 |
2159933 | 2159933 | 2022-01-28 | Benson | North Dakota | 38005 | 1752 | 22 |
2149145 | 2149145 | 2022-01-25 | Russell | Kansas | 20167 | 1752 | 34 |
2145893 | 2145893 | 2022-01-24 | Russell | Kansas | 20167 | 1752 | 34 |
2132839 | 2132839 | 2022-01-20 | Kingman | Kansas | 20095 | 1752 | 25 |
2128816 | 2128816 | 2022-01-19 | Searcy | Arkansas | 5129 | 1752 | 35 |
2129586 | 2129586 | 2022-01-19 | Kingman | Kansas | 20095 | 1752 | 25 |
2123680 | 2123680 | 2022-01-17 | Iron | Missouri | 29093 | 1752 | 32 |
2120428 | 2120428 | 2022-01-16 | Iron | Missouri | 29093 | 1752 | 32 |
2117176 | 2117176 | 2022-01-15 | Iron | Missouri | 29093 | 1752 | 32 |
2118471 | 2118471 | 2022-01-15 | Somervell | Texas | 48425 | 1752 | 29 |
2109884 | 2109884 | 2022-01-13 | Martin | Indiana | 18101 | 1752 | 21 |
2110200 | 2110200 | 2022-01-13 | Livingston | Kentucky | 21139 | 1752 | 49 |
2083122 | 2083122 | 2022-01-05 | Bullock | Alabama | 1011 | 1752 | 46 |
2083686 | 2083686 | 2022-01-05 | Boundary | Idaho | 16021 | 1752 | 51 |
2082275 | 2082275 | 2022-01-04 | Villalba | Puerto Rico | 72149 | 1752 | |
2073957 | 2073957 | 2022-01-02 | Owyhee | Idaho | 16073 | 1752 | 42 |
2070706 | 2070706 | 2022-01-01 | Owyhee | Idaho | 16073 | 1752 | 42 |
2067455 | 2067455 | 2021-12-31 | Owyhee | Idaho | 16073 | 1752 | 42 |
2064204 | 2064204 | 2021-12-30 | Owyhee | Idaho | 16073 | 1752 | 42 |
2060954 | 2060954 | 2021-12-29 | Owyhee | Idaho | 16073 | 1752 | 41 |
2056833 | 2056833 | 2021-12-27 | Franklin city | Virginia | 51620 | 1752 | 44 |
2017891 | 2017891 | 2021-12-15 | Richmond | Virginia | 51159 | 1752 | 16 |
2008889 | 2008889 | 2021-12-13 | Turner | Georgia | 13287 | 1752 | 50 |
2011390 | 2011390 | 2021-12-13 | Richmond | Virginia | 51159 | 1752 | 16 |
2006554 | 2006554 | 2021-12-12 | Jefferson Davis | Mississippi | 28065 | 1752 | 43 |
2003303 | 2003303 | 2021-12-11 | Jefferson Davis | Mississippi | 28065 | 1752 | 43 |
1999802 | 1999802 | 2021-12-10 | Piscataquis | Maine | 23021 | 1752 | 14 |
2000053 | 2000053 | 2021-12-10 | Jefferson Davis | Mississippi | 28065 | 1752 | 43 |
1983889 | 1983889 | 2021-12-05 | Grundy | Missouri | 29079 | 1752 | 55 |
1974025 | 1974025 | 2021-12-02 | Carroll | Mississippi | 28015 | 1752 | 41 |
1959765 | 1959765 | 2021-11-28 | Pike | Arkansas | 5109 | 1752 | 37 |
1943518 | 1943518 | 2021-11-23 | Scott | Arkansas | 5127 | 1752 | 31 |
1944876 | 1944876 | 2021-11-23 | Douglas | Missouri | 29067 | 1752 | 61 |
1942068 | 1942068 | 2021-11-22 | Pamlico | North Carolina | 37137 | 1752 | 26 |
1929470 | 1929470 | 2021-11-18 | Loiza | Puerto Rico | 72087 | 1752 | |
1926220 | 1926220 | 2021-11-17 | Loiza | Puerto Rico | 72087 | 1752 | |
1922970 | 1922970 | 2021-11-16 | Loiza | Puerto Rico | 72087 | 1752 | |
1919721 | 1919721 | 2021-11-15 | Loiza | Puerto Rico | 72087 | 1752 | |
1916471 | 1916471 | 2021-11-14 | Loiza | Puerto Rico | 72087 | 1752 | |
1913221 | 1913221 | 2021-11-13 | Loiza | Puerto Rico | 72087 | 1752 | |
1892012 | 1892012 | 2021-11-07 | Menard | Illinois | 17129 | 1752 | 17 |
1888762 | 1888762 | 2021-11-06 | Menard | Illinois | 17129 | 1752 | 17 |
1885512 | 1885512 | 2021-11-05 | Menard | Illinois | 17129 | 1752 | 17 |
1875349 | 1875349 | 2021-11-02 | Bent | Colorado | 8011 | 1752 | 27 |
1859965 | 1859965 | 2021-10-28 | Todd | Kentucky | 21219 | 1752 | 31 |
1844977 | 1844977 | 2021-10-23 | Juana Diaz | Puerto Rico | 72075 | 1752 | |
1841727 | 1841727 | 2021-10-22 | Juana Diaz | Puerto Rico | 72075 | 1752 | |
1838478 | 1838478 | 2021-10-21 | Juana Diaz | Puerto Rico | 72075 | 1752 | |
1826316 | 1826316 | 2021-10-17 | Price | Wisconsin | 55099 | 1752 | 11 |
1813020 | 1813020 | 2021-10-13 | Unknown | Utah | 1752 | 37 | |
1804146 | 1804146 | 2021-10-11 | Towns | Georgia | 13281 | 1752 | 78 |
1800897 | 1800897 | 2021-10-10 | Towns | Georgia | 13281 | 1752 | 78 |
1797648 | 1797648 | 2021-10-09 | Towns | Georgia | 13281 | 1752 | 78 |
1793888 | 1793888 | 2021-10-08 | Coosa | Alabama | 1037 | 1752 | 36 |
1794399 | 1794399 | 2021-10-08 | Towns | Georgia | 13281 | 1752 | 78 |
1790639 | 1790639 | 2021-10-07 | Coosa | Alabama | 1037 | 1752 | 36 |
1791151 | 1791151 | 2021-10-07 | Towns | Georgia | 13281 | 1752 | 78 |
1789717 | 1789717 | 2021-10-06 | Camuy | Puerto Rico | 72027 | 1752 | |
1762512 | 1762512 | 2021-09-28 | Catahoula | Louisiana | 22025 | 1752 | 47 |
1755994 | 1755994 | 2021-09-26 | Trigg | Kentucky | 21221 | 1752 | 20 |
1752746 | 1752746 | 2021-09-25 | Trigg | Kentucky | 21221 | 1752 | 20 |
1749497 | 1749497 | 2021-09-24 | Trigg | Kentucky | 21221 | 1752 | 20 |
1747127 | 1747127 | 2021-09-23 | Swain | North Carolina | 37173 | 1752 | 22 |
1722406 | 1722406 | 2021-09-16 | Conecuh | Alabama | 1035 | 1752 | 37 |
1720207 | 1720207 | 2021-09-15 | Leslie | Kentucky | 21131 | 1752 | 11 |
1717524 | 1717524 | 2021-09-14 | Glacier | Montana | 30035 | 1752 | 45 |
1715774 | 1715774 | 2021-09-13 | Monroe | West Virginia | 54063 | 1752 | 19 |
1710742 | 1710742 | 2021-09-12 | Cottonwood | Minnesota | 27033 | 1752 | 24 |
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);