ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
213 rows where cases = 2694 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 26
- Georgia 20
- Texas 15
- Iowa 14
- Florida 11
- Illinois 9
- Indiana 9
- Tennessee 9
- Kentucky 8
- Mississippi 8
- Alabama 6
- Arkansas 6
- Ohio 6
- Kansas 5
- Michigan 5
- Missouri 5
- South Carolina 5
- Wyoming 5
- Colorado 4
- North Carolina 4
- Virginia 4
- West Virginia 4
- California 3
- New Mexico 3
- Alaska 2
- Maryland 2
- Minnesota 2
- Oregon 2
- Vermont 2
- Wisconsin 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502758 | 2502758 | 2022-05-13 | Forest | Wisconsin | 55041 | 2694 | 52 |
2453579 | 2453579 | 2022-04-28 | Trinity | Texas | 48455 | 2694 | 72 |
2442088 | 2442088 | 2022-04-25 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2438832 | 2438832 | 2022-04-24 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2435576 | 2435576 | 2022-04-23 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2432320 | 2432320 | 2022-04-22 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2429064 | 2429064 | 2022-04-21 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2425808 | 2425808 | 2022-04-20 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2422552 | 2422552 | 2022-04-19 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2419296 | 2419296 | 2022-04-18 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2416040 | 2416040 | 2022-04-17 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2412784 | 2412784 | 2022-04-16 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2409528 | 2409528 | 2022-04-15 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2406272 | 2406272 | 2022-04-14 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2403016 | 2403016 | 2022-04-13 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2403703 | 2403703 | 2022-04-13 | Colfax | New Mexico | 35007 | 2694 | 65 |
2399762 | 2399762 | 2022-04-12 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2396506 | 2396506 | 2022-04-11 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2393251 | 2393251 | 2022-04-10 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2389995 | 2389995 | 2022-04-09 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2386739 | 2386739 | 2022-04-08 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2383484 | 2383484 | 2022-04-07 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2380229 | 2380229 | 2022-04-06 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2376974 | 2376974 | 2022-04-05 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2373722 | 2373722 | 2022-04-04 | Catahoula | Louisiana | 22025 | 2694 | 55 |
2262874 | 2262874 | 2022-03-01 | Shelby | Iowa | 19165 | 2694 | 50 |
2259623 | 2259623 | 2022-02-28 | Shelby | Iowa | 19165 | 2694 | 50 |
2256372 | 2256372 | 2022-02-27 | Shelby | Iowa | 19165 | 2694 | 50 |
2253121 | 2253121 | 2022-02-26 | Shelby | Iowa | 19165 | 2694 | 50 |
2249870 | 2249870 | 2022-02-25 | Shelby | Iowa | 19165 | 2694 | 50 |
2246619 | 2246619 | 2022-02-24 | Shelby | Iowa | 19165 | 2694 | 50 |
2243368 | 2243368 | 2022-02-23 | Shelby | Iowa | 19165 | 2694 | 50 |
2210459 | 2210459 | 2022-02-13 | Long | Georgia | 13183 | 2694 | 31 |
2207206 | 2207206 | 2022-02-12 | Long | Georgia | 13183 | 2694 | 31 |
2208759 | 2208759 | 2022-02-12 | McLean | North Dakota | 38055 | 2694 | 49 |
2203953 | 2203953 | 2022-02-11 | Long | Georgia | 13183 | 2694 | 31 |
2196711 | 2196711 | 2022-02-08 | Lexington city | Virginia | 51678 | 2694 | 39 |
2190896 | 2190896 | 2022-02-07 | Early | Georgia | 13099 | 2694 | 60 |
2186307 | 2186307 | 2022-02-05 | Comerio | Puerto Rico | 72045 | 2694 | |
2186644 | 2186644 | 2022-02-05 | Eastland | Texas | 48133 | 2694 | 98 |
2172127 | 2172127 | 2022-02-01 | West Feliciana | Louisiana | 22125 | 2694 | 42 |
2148747 | 2148747 | 2022-01-25 | Idaho | Idaho | 16049 | 2694 | 43 |
2151310 | 2151310 | 2022-01-25 | Roane | West Virginia | 54087 | 2694 | 30 |
2133113 | 2133113 | 2022-01-20 | Kent | Maryland | 24029 | 2694 | 62 |
2126158 | 2126158 | 2022-01-18 | Pulaski | Indiana | 18131 | 2694 | 74 |
2118551 | 2118551 | 2022-01-15 | Lamoille | Vermont | 50015 | 2694 | 12 |
2085972 | 2085972 | 2022-01-05 | Tyler | Texas | 48457 | 2694 | 73 |
2080883 | 2080883 | 2022-01-04 | Butler | Kentucky | 21031 | 2694 | 44 |
2063301 | 2063301 | 2021-12-29 | Bristol city | Virginia | 51520 | 2694 | 58 |
2059739 | 2059739 | 2021-12-28 | Aransas | Texas | 48007 | 2694 | 67 |
2053846 | 2053846 | 2021-12-26 | Goshen | Wyoming | 56015 | 2694 | 52 |
2050596 | 2050596 | 2021-12-25 | Goshen | Wyoming | 56015 | 2694 | 52 |
2047346 | 2047346 | 2021-12-24 | Goshen | Wyoming | 56015 | 2694 | 52 |
2044096 | 2044096 | 2021-12-23 | Goshen | Wyoming | 56015 | 2694 | 52 |
2007555 | 2007555 | 2021-12-12 | Lee | South Carolina | 45061 | 2694 | 79 |
2004304 | 2004304 | 2021-12-11 | Lee | South Carolina | 45061 | 2694 | 79 |
2001053 | 2001053 | 2021-12-10 | Lee | South Carolina | 45061 | 2694 | 79 |
1995433 | 1995433 | 2021-12-09 | Kodiak Island Borough | Alaska | 2150 | 2694 | 10 |
1992182 | 1992182 | 2021-12-08 | Kodiak Island Borough | Alaska | 2150 | 2694 | 10 |
1967583 | 1967583 | 2021-11-30 | Smith | Mississippi | 28129 | 2694 | 52 |
1956492 | 1956492 | 2021-11-27 | Izard | Arkansas | 5065 | 2694 | 55 |
1943949 | 1943949 | 2021-11-23 | Bond | Illinois | 17005 | 2694 | 34 |
1919188 | 1919188 | 2021-11-15 | Taos | New Mexico | 35055 | 2694 | 66 |
1891956 | 1891956 | 2021-11-07 | Cass | Illinois | 17017 | 2694 | 40 |
1888706 | 1888706 | 2021-11-06 | Cass | Illinois | 17017 | 2694 | 40 |
1885456 | 1885456 | 2021-11-05 | Cass | Illinois | 17017 | 2694 | 40 |
1882207 | 1882207 | 2021-11-04 | Cass | Illinois | 17017 | 2694 | 40 |
1882653 | 1882653 | 2021-11-04 | Jackson | Kentucky | 21109 | 2694 | 50 |
1872321 | 1872321 | 2021-11-01 | Jefferson | Georgia | 13163 | 2694 | 86 |
1846313 | 1846313 | 2021-10-24 | Greene | Georgia | 13133 | 2694 | 70 |
1843063 | 1843063 | 2021-10-23 | Greene | Georgia | 13133 | 2694 | 70 |
1839813 | 1839813 | 2021-10-22 | Greene | Georgia | 13133 | 2694 | 70 |
1836564 | 1836564 | 2021-10-21 | Greene | Georgia | 13133 | 2694 | 69 |
1830461 | 1830461 | 2021-10-19 | Kossuth | Iowa | 19109 | 2694 | 73 |
1827212 | 1827212 | 2021-10-18 | Kossuth | Iowa | 19109 | 2694 | 73 |
1823963 | 1823963 | 2021-10-17 | Kossuth | Iowa | 19109 | 2694 | 73 |
1824371 | 1824371 | 2021-10-17 | Cheboygan | Michigan | 26031 | 2694 | 63 |
1820714 | 1820714 | 2021-10-16 | Kossuth | Iowa | 19109 | 2694 | 73 |
1821122 | 1821122 | 2021-10-16 | Cheboygan | Michigan | 26031 | 2694 | 63 |
1817465 | 1817465 | 2021-10-15 | Kossuth | Iowa | 19109 | 2694 | 73 |
1817873 | 1817873 | 2021-10-15 | Cheboygan | Michigan | 26031 | 2694 | 63 |
1814217 | 1814217 | 2021-10-14 | Kossuth | Iowa | 19109 | 2694 | 73 |
1810968 | 1810968 | 2021-10-13 | Kossuth | Iowa | 19109 | 2694 | 73 |
1812079 | 1812079 | 2021-10-13 | Madison | North Carolina | 37115 | 2694 | 56 |
1790497 | 1790497 | 2021-10-06 | McDowell | West Virginia | 54047 | 2694 | 40 |
1781162 | 1781162 | 2021-10-04 | Montezuma | Colorado | 8083 | 2694 | 33 |
1780185 | 1780185 | 2021-10-03 | Grundy | Tennessee | 47061 | 2694 | 37 |
1776935 | 1776935 | 2021-10-02 | Grundy | Tennessee | 47061 | 2694 | 37 |
1773685 | 1773685 | 2021-10-01 | Grundy | Tennessee | 47061 | 2694 | 37 |
1763914 | 1763914 | 2021-09-28 | Cannon | Tennessee | 47015 | 2694 | 38 |
1764288 | 1764288 | 2021-09-28 | Bennington | Vermont | 50003 | 2694 | 18 |
1733227 | 1733227 | 2021-09-19 | Morgan | Kentucky | 21175 | 2694 | 6 |
1729977 | 1729977 | 2021-09-18 | Morgan | Kentucky | 21175 | 2694 | 6 |
1726727 | 1726727 | 2021-09-17 | Morgan | Kentucky | 21175 | 2694 | 6 |
1717319 | 1717319 | 2021-09-14 | Clarke | Mississippi | 28023 | 2694 | 84 |
1709538 | 1709538 | 2021-09-12 | Hempstead | Arkansas | 5057 | 2694 | 23 |
1700418 | 1700418 | 2021-09-09 | Owen | Indiana | 18119 | 2694 | 63 |
1700735 | 1700735 | 2021-09-09 | McCreary | Kentucky | 21147 | 2694 | 35 |
1676714 | 1676714 | 2021-09-01 | Waynesboro city | Virginia | 51820 | 2694 | 39 |
1670585 | 1670585 | 2021-08-31 | Randolph | Arkansas | 5121 | 2694 | 50 |
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);