ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
307 rows where cases = 1832 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 38
- Georgia 22
- Iowa 19
- Missouri 19
- Kentucky 15
- Indiana 13
- Michigan 11
- Alabama 10
- Tennessee 10
- Mississippi 9
- Ohio 9
- Illinois 8
- North Carolina 8
- Puerto Rico 8
- Arkansas 7
- Kansas 7
- Louisiana 7
- West Virginia 6
- Wisconsin 6
- Colorado 5
- Virginia 5
- Florida 4
- Maine 4
- New York 4
- Oregon 4
- Utah 4
- Wyoming 4
- Idaho 3
- Maryland 3
- Nebraska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401737 | 2401737 | 2022-04-12 | Calhoun | West Virginia | 54013 | 1832 | 13 |
2398482 | 2398482 | 2022-04-11 | Calhoun | West Virginia | 54013 | 1832 | 13 |
2375430 | 2375430 | 2022-04-04 | Stephens | Texas | 48429 | 1832 | 45 |
2372178 | 2372178 | 2022-04-03 | Stephens | Texas | 48429 | 1832 | 45 |
2368425 | 2368425 | 2022-04-02 | Arroyo | Puerto Rico | 72015 | 1832 | |
2368452 | 2368452 | 2022-04-02 | Hormigueros | Puerto Rico | 72067 | 1832 | |
2368925 | 2368925 | 2022-04-02 | Stephens | Texas | 48429 | 1832 | 45 |
2365672 | 2365672 | 2022-04-01 | Stephens | Texas | 48429 | 1832 | 45 |
2362419 | 2362419 | 2022-03-31 | Stephens | Texas | 48429 | 1832 | 45 |
2359165 | 2359165 | 2022-03-30 | Stephens | Texas | 48429 | 1832 | 45 |
2355911 | 2355911 | 2022-03-29 | Stephens | Texas | 48429 | 1832 | 45 |
2308810 | 2308810 | 2022-03-15 | Lake | Michigan | 26085 | 1832 | 36 |
2305559 | 2305559 | 2022-03-14 | Lake | Michigan | 26085 | 1832 | 36 |
2302307 | 2302307 | 2022-03-13 | Lake | Michigan | 26085 | 1832 | 36 |
2299055 | 2299055 | 2022-03-12 | Lake | Michigan | 26085 | 1832 | 36 |
2295803 | 2295803 | 2022-03-11 | Lake | Michigan | 26085 | 1832 | 36 |
2292551 | 2292551 | 2022-03-10 | Lake | Michigan | 26085 | 1832 | 36 |
2289299 | 2289299 | 2022-03-09 | Lake | Michigan | 26085 | 1832 | 36 |
2263937 | 2263937 | 2022-03-01 | Gates | North Carolina | 37073 | 1832 | 19 |
2233044 | 2233044 | 2022-02-20 | Yuma | Colorado | 8125 | 1832 | 23 |
2229793 | 2229793 | 2022-02-19 | Yuma | Colorado | 8125 | 1832 | 23 |
2226542 | 2226542 | 2022-02-18 | Yuma | Colorado | 8125 | 1832 | 23 |
2216468 | 2216468 | 2022-02-14 | Johnson | Wyoming | 56019 | 1832 | 18 |
2213217 | 2213217 | 2022-02-13 | Johnson | Wyoming | 56019 | 1832 | 18 |
2209964 | 2209964 | 2022-02-12 | Johnson | Wyoming | 56019 | 1832 | 18 |
2206711 | 2206711 | 2022-02-11 | Johnson | Wyoming | 56019 | 1832 | 18 |
2203014 | 2203014 | 2022-02-10 | Mitchell | Texas | 48335 | 1832 | 46 |
2155790 | 2155790 | 2022-01-27 | Wolfe | Kentucky | 21237 | 1832 | 16 |
2152991 | 2152991 | 2022-01-26 | Oregon | Missouri | 29149 | 1832 | 27 |
2153806 | 2153806 | 2022-01-26 | Patillas | Puerto Rico | 72109 | 1832 | |
2148447 | 2148447 | 2022-01-25 | Lincoln | Colorado | 8073 | 1832 | 9 |
2141710 | 2141710 | 2022-01-23 | Perry | Alabama | 1105 | 1832 | 40 |
2132306 | 2132306 | 2022-01-20 | Candler | Georgia | 13043 | 1832 | 91 |
2129804 | 2129804 | 2022-01-19 | Red River | Louisiana | 22081 | 1832 | 49 |
2121277 | 2121277 | 2022-01-16 | Rincon | Puerto Rico | 72117 | 1832 | |
2115156 | 2115156 | 2022-01-14 | Live Oak | Texas | 48297 | 1832 | 39 |
2103919 | 2103919 | 2022-01-11 | Mackinac | Michigan | 26097 | 1832 | 23 |
2100668 | 2100668 | 2022-01-10 | Mackinac | Michigan | 26097 | 1832 | 23 |
2099012 | 2099012 | 2022-01-09 | Emery | Utah | 49015 | 1832 | 25 |
2095760 | 2095760 | 2022-01-08 | Emery | Utah | 49015 | 1832 | 25 |
2081435 | 2081435 | 2022-01-04 | Montgomery | Missouri | 29139 | 1832 | 34 |
2075337 | 2075337 | 2022-01-02 | Pamlico | North Carolina | 37137 | 1832 | 26 |
2072086 | 2072086 | 2022-01-01 | Pamlico | North Carolina | 37137 | 1832 | 26 |
2068835 | 2068835 | 2021-12-31 | Pamlico | North Carolina | 37137 | 1832 | 26 |
2064142 | 2064142 | 2021-12-30 | Turner | Georgia | 13287 | 1832 | 50 |
2060938 | 2060938 | 2021-12-29 | Franklin | Idaho | 16041 | 1832 | 27 |
2059612 | 2059612 | 2021-12-28 | Lake | South Dakota | 46079 | 1832 | 22 |
2037026 | 2037026 | 2021-12-21 | Childress | Texas | 48075 | 1832 | 22 |
2026904 | 2026904 | 2021-12-18 | Forest | Pennsylvania | 42053 | 1832 | 31 |
2018623 | 2018623 | 2021-12-16 | Screven | Georgia | 13251 | 1832 | 62 |
2015373 | 2015373 | 2021-12-15 | Screven | Georgia | 13251 | 1832 | 62 |
2012122 | 2012122 | 2021-12-14 | Screven | Georgia | 13251 | 1832 | 62 |
2012462 | 2012462 | 2021-12-14 | Louisa | Iowa | 19115 | 1832 | 53 |
2008871 | 2008871 | 2021-12-13 | Screven | Georgia | 13251 | 1832 | 62 |
2009211 | 2009211 | 2021-12-13 | Louisa | Iowa | 19115 | 1832 | 53 |
2009821 | 2009821 | 2021-12-13 | Montgomery | Mississippi | 28097 | 1832 | 57 |
2005960 | 2005960 | 2021-12-12 | Louisa | Iowa | 19115 | 1832 | 53 |
2002709 | 2002709 | 2021-12-11 | Louisa | Iowa | 19115 | 1832 | 53 |
1999459 | 1999459 | 2021-12-10 | Louisa | Iowa | 19115 | 1832 | 53 |
1996208 | 1996208 | 2021-12-09 | Louisa | Iowa | 19115 | 1832 | 53 |
1996979 | 1996979 | 2021-12-09 | Dawson | Montana | 30021 | 1832 | 50 |
1992957 | 1992957 | 2021-12-08 | Louisa | Iowa | 19115 | 1832 | 53 |
1982866 | 1982866 | 2021-12-05 | Screven | Georgia | 13251 | 1832 | 62 |
1979616 | 1979616 | 2021-12-04 | Screven | Georgia | 13251 | 1832 | 62 |
1982245 | 1982245 | 2021-12-04 | Roane | West Virginia | 54087 | 1832 | 25 |
1976366 | 1976366 | 2021-12-03 | Screven | Georgia | 13251 | 1832 | 62 |
1961117 | 1961117 | 2021-11-28 | Cedar | Missouri | 29039 | 1832 | 42 |
1957866 | 1957866 | 2021-11-27 | Cedar | Missouri | 29039 | 1832 | 42 |
1954615 | 1954615 | 2021-11-26 | Cedar | Missouri | 29039 | 1832 | 42 |
1951364 | 1951364 | 2021-11-25 | Cedar | Missouri | 29039 | 1832 | 42 |
1948113 | 1948113 | 2021-11-24 | Cedar | Missouri | 29039 | 1832 | 42 |
1941722 | 1941722 | 2021-11-22 | Fergus | Montana | 30027 | 1832 | 46 |
1927184 | 1927184 | 2021-11-18 | Valdez-Cordova Census Area | Alaska | 2261 | 1832 | 9 |
1928046 | 1928046 | 2021-11-18 | Marion | Kansas | 20115 | 1832 | 35 |
1924796 | 1924796 | 2021-11-17 | Marion | Kansas | 20115 | 1832 | 35 |
1915999 | 1915999 | 2021-11-14 | Yates | New York | 36123 | 1832 | 30 |
1906188 | 1906188 | 2021-11-11 | Socorro | New Mexico | 35053 | 1832 | 64 |
1902939 | 1902939 | 2021-11-10 | Socorro | New Mexico | 35053 | 1832 | 64 |
1871504 | 1871504 | 2021-10-31 | Unknown | Utah | 1832 | 39 | |
1868255 | 1868255 | 2021-10-30 | Unknown | Utah | 1832 | 39 | |
1864136 | 1864136 | 2021-10-29 | McLean | North Dakota | 38055 | 1832 | 40 |
1854451 | 1854451 | 2021-10-26 | Harrison | Ohio | 39067 | 1832 | 47 |
1835429 | 1835429 | 2021-10-20 | Houston | Tennessee | 47083 | 1832 | 43 |
1807760 | 1807760 | 2021-10-12 | Winnebago | Iowa | 19189 | 1832 | 32 |
1804509 | 1804509 | 2021-10-11 | Winnebago | Iowa | 19189 | 1832 | 32 |
1801260 | 1801260 | 2021-10-10 | Winnebago | Iowa | 19189 | 1832 | 32 |
1798011 | 1798011 | 2021-10-09 | Winnebago | Iowa | 19189 | 1832 | 32 |
1794762 | 1794762 | 2021-10-08 | Winnebago | Iowa | 19189 | 1832 | 32 |
1795068 | 1795068 | 2021-10-08 | Sagadahoc | Maine | 23023 | 1832 | 12 |
1791514 | 1791514 | 2021-10-07 | Winnebago | Iowa | 19189 | 1832 | 32 |
1788265 | 1788265 | 2021-10-06 | Winnebago | Iowa | 19189 | 1832 | 32 |
1782465 | 1782465 | 2021-10-04 | Ripley | Missouri | 29181 | 1832 | 21 |
1776498 | 1776498 | 2021-10-02 | Noble | Ohio | 39121 | 1832 | 44 |
1766968 | 1766968 | 2021-09-29 | Barranquitas | Puerto Rico | 72019 | 1832 | |
1744143 | 1744143 | 2021-09-22 | Tillamook | Oregon | 41057 | 1832 | 23 |
1745046 | 1745046 | 2021-09-22 | Burnett | Wisconsin | 55013 | 1832 | 29 |
1736572 | 1736572 | 2021-09-20 | West Carroll | Louisiana | 22123 | 1832 | 46 |
1733174 | 1733174 | 2021-09-19 | Fleming | Kentucky | 21069 | 1832 | 26 |
1729924 | 1729924 | 2021-09-18 | Fleming | Kentucky | 21069 | 1832 | 26 |
1726674 | 1726674 | 2021-09-17 | Fleming | Kentucky | 21069 | 1832 | 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);