ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where cases = 3474 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 18
- Texas 11
- Illinois 9
- Iowa 9
- Oregon 9
- Virginia 9
- Michigan 8
- South Dakota 8
- New York 7
- Ohio 7
- Pennsylvania 6
- Indiana 5
- Kentucky 5
- Arkansas 4
- Georgia 4
- Louisiana 4
- North Carolina 4
- West Virginia 4
- Alabama 3
- Missouri 3
- South Carolina 3
- Tennessee 3
- Florida 2
- Kansas 2
- Nebraska 2
- New Mexico 2
- Puerto Rico 2
- Wisconsin 2
- California 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501546 | 2501546 | 2022-05-13 | Mitchell | North Carolina | 37121 | 3474 | 37 |
2498288 | 2498288 | 2022-05-12 | Mitchell | North Carolina | 37121 | 3474 | 37 |
2495030 | 2495030 | 2022-05-11 | Mitchell | North Carolina | 37121 | 3474 | 37 |
2491056 | 2491056 | 2022-05-10 | Benzie | Michigan | 26019 | 3474 | 68 |
2487799 | 2487799 | 2022-05-09 | Benzie | Michigan | 26019 | 3474 | 68 |
2484541 | 2484541 | 2022-05-08 | Benzie | Michigan | 26019 | 3474 | 68 |
2481283 | 2481283 | 2022-05-07 | Benzie | Michigan | 26019 | 3474 | 68 |
2478025 | 2478025 | 2022-05-06 | Benzie | Michigan | 26019 | 3474 | 68 |
2474767 | 2474767 | 2022-05-05 | Benzie | Michigan | 26019 | 3474 | 68 |
2471510 | 2471510 | 2022-05-04 | Benzie | Michigan | 26019 | 3474 | 68 |
2325151 | 2325151 | 2022-03-20 | Kanabec | Minnesota | 27065 | 3474 | 55 |
2321897 | 2321897 | 2022-03-19 | Kanabec | Minnesota | 27065 | 3474 | 55 |
2318643 | 2318643 | 2022-03-18 | Kanabec | Minnesota | 27065 | 3474 | 55 |
2315390 | 2315390 | 2022-03-17 | Kanabec | Minnesota | 27065 | 3474 | 55 |
2312137 | 2312137 | 2022-03-16 | Kanabec | Minnesota | 27065 | 3474 | 55 |
2308884 | 2308884 | 2022-03-15 | Kanabec | Minnesota | 27065 | 3474 | 55 |
2262661 | 2262661 | 2022-03-01 | Menard | Illinois | 17129 | 3474 | 23 |
2225862 | 2225862 | 2022-02-17 | Zapata | Texas | 48505 | 3474 | 49 |
2222209 | 2222209 | 2022-02-16 | Clay | South Dakota | 46027 | 3474 | 20 |
2212238 | 2212238 | 2022-02-13 | Tillamook | Oregon | 41057 | 3474 | 57 |
2208985 | 2208985 | 2022-02-12 | Tillamook | Oregon | 41057 | 3474 | 57 |
2205732 | 2205732 | 2022-02-11 | Tillamook | Oregon | 41057 | 3474 | 57 |
2177384 | 2177384 | 2022-02-02 | Lafayette | Wisconsin | 55065 | 3474 | 20 |
2168160 | 2168160 | 2022-01-31 | Jefferson | Georgia | 13163 | 3474 | 100 |
2144174 | 2144174 | 2022-01-23 | Oglala Lakota | South Dakota | 46102 | 3474 | 55 |
2144435 | 2144435 | 2022-01-23 | Llano | Texas | 48299 | 3474 | 87 |
2140919 | 2140919 | 2022-01-22 | Oglala Lakota | South Dakota | 46102 | 3474 | 55 |
2137663 | 2137663 | 2022-01-21 | Oglala Lakota | South Dakota | 46102 | 3474 | 55 |
2128453 | 2128453 | 2022-01-18 | Asotin | Washington | 53003 | 3474 | 54 |
2124663 | 2124663 | 2022-01-17 | Union | South Dakota | 46127 | 3474 | 47 |
2121411 | 2121411 | 2022-01-16 | Union | South Dakota | 46127 | 3474 | 47 |
2121654 | 2121654 | 2022-01-16 | Lee | Texas | 48287 | 3474 | 55 |
2118159 | 2118159 | 2022-01-15 | Union | South Dakota | 46127 | 3474 | 47 |
2114908 | 2114908 | 2022-01-14 | Union | South Dakota | 46127 | 3474 | 47 |
2103820 | 2103820 | 2022-01-11 | Knox | Maine | 23013 | 3474 | 20 |
2100088 | 2100088 | 2022-01-10 | Carroll | Indiana | 18015 | 3474 | 52 |
2099155 | 2099155 | 2022-01-09 | Radford city | Virginia | 51750 | 3474 | 39 |
2095904 | 2095904 | 2022-01-08 | Radford city | Virginia | 51750 | 3474 | 39 |
2092652 | 2092652 | 2022-01-07 | Radford city | Virginia | 51750 | 3474 | 39 |
2077750 | 2077750 | 2022-01-03 | Concordia | Louisiana | 22029 | 3474 | 80 |
2079229 | 2079229 | 2022-01-03 | Unicoi | Tennessee | 47171 | 3474 | 79 |
2049697 | 2049697 | 2021-12-25 | Aguadilla | Puerto Rico | 72005 | 3474 | |
2035885 | 2035885 | 2021-12-21 | Clinton | Missouri | 29049 | 3474 | 99 |
2031805 | 2031805 | 2021-12-20 | Union | Illinois | 17181 | 3474 | 56 |
2004976 | 2004976 | 2021-12-11 | Lewis | West Virginia | 54041 | 3474 | 60 |
1991152 | 1991152 | 2021-12-07 | Juniata | Pennsylvania | 42067 | 3474 | 134 |
1962999 | 1962999 | 2021-11-29 | Lawrence | Arkansas | 5075 | 3474 | 62 |
1939677 | 1939677 | 2021-11-21 | Scurry | Texas | 48415 | 3474 | 84 |
1936427 | 1936427 | 2021-11-20 | Scurry | Texas | 48415 | 3474 | 84 |
1926093 | 1926093 | 2021-11-17 | Lincoln | Oregon | 41041 | 3474 | 50 |
1926956 | 1926956 | 2021-11-17 | Hampshire | West Virginia | 54027 | 3474 | 50 |
1921414 | 1921414 | 2021-11-16 | Crawford | Iowa | 19047 | 3474 | 47 |
1918164 | 1918164 | 2021-11-15 | Crawford | Iowa | 19047 | 3474 | 47 |
1914914 | 1914914 | 2021-11-14 | Crawford | Iowa | 19047 | 3474 | 47 |
1911664 | 1911664 | 2021-11-13 | Crawford | Iowa | 19047 | 3474 | 47 |
1908415 | 1908415 | 2021-11-12 | Crawford | Iowa | 19047 | 3474 | 47 |
1905166 | 1905166 | 2021-11-11 | Crawford | Iowa | 19047 | 3474 | 47 |
1901823 | 1901823 | 2021-11-10 | Fountain | Indiana | 18045 | 3474 | 62 |
1901916 | 1901916 | 2021-11-10 | Crawford | Iowa | 19047 | 3474 | 47 |
1852028 | 1852028 | 2021-10-25 | Washington | Vermont | 50023 | 3474 | 22 |
1834542 | 1834542 | 2021-10-20 | Cass | Nebraska | 31025 | 3474 | 19 |
1830727 | 1830727 | 2021-10-19 | Wayne | Kentucky | 21231 | 3474 | 59 |
1822682 | 1822682 | 2021-10-16 | Reeves | Texas | 48389 | 3474 | 52 |
1781409 | 1781409 | 2021-10-04 | Union | Georgia | 13291 | 3474 | 105 |
1782838 | 1782838 | 2021-10-04 | Martin | North Carolina | 37117 | 3474 | 62 |
1783912 | 1783912 | 2021-10-04 | Russell | Virginia | 51167 | 3474 | 52 |
1777777 | 1777777 | 2021-10-03 | Logan | Arkansas | 5083 | 3474 | 36 |
1758132 | 1758132 | 2021-09-27 | Barbour | Alabama | 1005 | 3474 | 70 |
1748958 | 1748958 | 2021-09-24 | Cassia | Idaho | 16031 | 3474 | 30 |
1710773 | 1710773 | 2021-09-12 | Mille Lacs | Minnesota | 27095 | 3474 | 60 |
1712325 | 1712325 | 2021-09-12 | Accomack | Virginia | 51001 | 3474 | 57 |
1707526 | 1707526 | 2021-09-11 | Mille Lacs | Minnesota | 27095 | 3474 | 60 |
1709078 | 1709078 | 2021-09-11 | Accomack | Virginia | 51001 | 3474 | 57 |
1704279 | 1704279 | 2021-09-10 | Mille Lacs | Minnesota | 27095 | 3474 | 60 |
1705831 | 1705831 | 2021-09-10 | Accomack | Virginia | 51001 | 3474 | 57 |
1654893 | 1654893 | 2021-08-26 | Daviess | Indiana | 18027 | 3474 | 104 |
1641212 | 1641212 | 2021-08-22 | Geneva | Alabama | 1061 | 3474 | 88 |
1634422 | 1634422 | 2021-08-19 | Isle of Wight | Virginia | 51093 | 3474 | 70 |
1608850 | 1608850 | 2021-08-12 | Lincoln | Arkansas | 5079 | 3474 | 50 |
1588542 | 1588542 | 2021-08-05 | Marion | Tennessee | 47115 | 3474 | 50 |
1580873 | 1580873 | 2021-08-03 | Adams | Mississippi | 28001 | 3474 | 90 |
1575191 | 1575191 | 2021-08-01 | Benton | Oregon | 41003 | 3474 | 22 |
1571943 | 1571943 | 2021-07-31 | Benton | Oregon | 41003 | 3474 | 22 |
1567966 | 1567966 | 2021-07-30 | Barry | Missouri | 29009 | 3474 | 50 |
1568695 | 1568695 | 2021-07-30 | Benton | Oregon | 41003 | 3474 | 22 |
1542558 | 1542558 | 2021-07-22 | Champaign | Ohio | 39021 | 3474 | 60 |
1539310 | 1539310 | 2021-07-21 | Champaign | Ohio | 39021 | 3474 | 60 |
1516389 | 1516389 | 2021-07-14 | Otsego | New York | 36077 | 3474 | 47 |
1513142 | 1513142 | 2021-07-13 | Otsego | New York | 36077 | 3474 | 47 |
1509896 | 1509896 | 2021-07-12 | Otsego | New York | 36077 | 3474 | 47 |
1506649 | 1506649 | 2021-07-11 | Otsego | New York | 36077 | 3474 | 47 |
1503403 | 1503403 | 2021-07-10 | Otsego | New York | 36077 | 3474 | 47 |
1500157 | 1500157 | 2021-07-09 | Otsego | New York | 36077 | 3474 | 47 |
1474707 | 1474707 | 2021-07-01 | Vega Baja | Puerto Rico | 72145 | 3474 | |
1463917 | 1463917 | 2021-06-28 | Freeborn | Minnesota | 27047 | 3474 | 33 |
1460672 | 1460672 | 2021-06-27 | Freeborn | Minnesota | 27047 | 3474 | 33 |
1457427 | 1457427 | 2021-06-26 | Freeborn | Minnesota | 27047 | 3474 | 33 |
1454182 | 1454182 | 2021-06-25 | Freeborn | Minnesota | 27047 | 3474 | 33 |
1450937 | 1450937 | 2021-06-24 | Freeborn | Minnesota | 27047 | 3474 | 33 |
1437377 | 1437377 | 2021-06-20 | Ripley | Indiana | 18137 | 3474 | 71 |
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);