ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
182 rows where cases = 2588 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 19
- Georgia 14
- Kentucky 14
- Virginia 12
- Iowa 10
- Illinois 9
- Mississippi 9
- North Carolina 9
- Indiana 8
- Tennessee 8
- Missouri 7
- Wisconsin 7
- Arkansas 5
- Louisiana 5
- Michigan 5
- Puerto Rico 5
- South Carolina 5
- Guam 3
- Kansas 3
- Ohio 3
- Utah 3
- West Virginia 3
- Alabama 2
- Minnesota 2
- North Dakota 2
- Pennsylvania 2
- Colorado 1
- Idaho 1
- Montana 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428639 | 2428639 | 2022-04-21 | Brown | Indiana | 18013 | 2588 | 62 |
2425383 | 2425383 | 2022-04-20 | Brown | Indiana | 18013 | 2588 | 62 |
2422127 | 2422127 | 2022-04-19 | Brown | Indiana | 18013 | 2588 | 62 |
2418871 | 2418871 | 2022-04-18 | Brown | Indiana | 18013 | 2588 | 62 |
2420518 | 2420518 | 2022-04-18 | Ciales | Puerto Rico | 72039 | 2588 | |
2377477 | 2377477 | 2022-04-05 | Jefferson | Montana | 30043 | 2588 | 23 |
2375622 | 2375622 | 2022-04-04 | Richmond | Virginia | 51159 | 2588 | 25 |
2372370 | 2372370 | 2022-04-03 | Richmond | Virginia | 51159 | 2588 | 25 |
2369117 | 2369117 | 2022-04-02 | Richmond | Virginia | 51159 | 2588 | 25 |
2365864 | 2365864 | 2022-04-01 | Richmond | Virginia | 51159 | 2588 | 25 |
2331105 | 2331105 | 2022-03-22 | Calhoun | Iowa | 19025 | 2588 | 23 |
2327853 | 2327853 | 2022-03-21 | Calhoun | Iowa | 19025 | 2588 | 23 |
2324600 | 2324600 | 2022-03-20 | Calhoun | Iowa | 19025 | 2588 | 23 |
2321346 | 2321346 | 2022-03-19 | Calhoun | Iowa | 19025 | 2588 | 23 |
2318092 | 2318092 | 2022-03-18 | Calhoun | Iowa | 19025 | 2588 | 23 |
2314839 | 2314839 | 2022-03-17 | Calhoun | Iowa | 19025 | 2588 | 23 |
2316006 | 2316006 | 2022-03-17 | Pamlico | North Carolina | 37137 | 2588 | 27 |
2311586 | 2311586 | 2022-03-16 | Calhoun | Iowa | 19025 | 2588 | 23 |
2293930 | 2293930 | 2022-03-10 | Childress | Texas | 48075 | 2588 | 30 |
2290678 | 2290678 | 2022-03-09 | Childress | Texas | 48075 | 2588 | 29 |
2201226 | 2201226 | 2022-02-10 | Bath | Kentucky | 21011 | 2588 | 35 |
2186763 | 2186763 | 2022-02-05 | Pecos | Texas | 48371 | 2588 | 65 |
2168287 | 2168287 | 2022-01-31 | Teton | Idaho | 16081 | 2588 | 8 |
2133366 | 2133366 | 2022-01-20 | Perry | Mississippi | 28111 | 2588 | 57 |
2126824 | 2126824 | 2022-01-18 | Greene | Mississippi | 28041 | 2588 | 50 |
2124173 | 2124173 | 2022-01-17 | Mountrail | North Dakota | 38061 | 2588 | 32 |
2101634 | 2101634 | 2022-01-10 | Tillamook | Oregon | 41057 | 2588 | 51 |
2087936 | 2087936 | 2022-01-06 | Mississippi | Missouri | 29133 | 2588 | 50 |
2065666 | 2065666 | 2021-12-30 | Walsh | North Dakota | 38099 | 2588 | 33 |
2063339 | 2063339 | 2021-12-29 | Grayson | Virginia | 51077 | 2588 | 62 |
2060241 | 2060241 | 2021-12-28 | Monroe | West Virginia | 54063 | 2588 | 31 |
2051687 | 2051687 | 2021-12-26 | Magoffin | Kentucky | 21153 | 2588 | 34 |
2048437 | 2048437 | 2021-12-25 | Magoffin | Kentucky | 21153 | 2588 | 34 |
2045187 | 2045187 | 2021-12-24 | Magoffin | Kentucky | 21153 | 2588 | 34 |
2041938 | 2041938 | 2021-12-23 | Magoffin | Kentucky | 21153 | 2588 | 34 |
2038688 | 2038688 | 2021-12-22 | Magoffin | Kentucky | 21153 | 2588 | 34 |
2040492 | 2040492 | 2021-12-22 | Zavala | Texas | 48507 | 2588 | 56 |
2009122 | 2009122 | 2021-12-13 | Parke | Indiana | 18121 | 2588 | 33 |
1993221 | 1993221 | 2021-12-08 | Webster | Kentucky | 21233 | 2588 | 42 |
1994473 | 1994473 | 2021-12-08 | Isabela | Puerto Rico | 72071 | 2588 | |
1991222 | 1991222 | 2021-12-07 | Isabela | Puerto Rico | 72071 | 2588 | |
1987971 | 1987971 | 2021-12-06 | Isabela | Puerto Rico | 72071 | 2588 | |
1945803 | 1945803 | 2021-11-23 | Saluda | South Carolina | 45081 | 2588 | 55 |
1919792 | 1919792 | 2021-11-15 | Lee | South Carolina | 45061 | 2588 | 75 |
1916992 | 1916992 | 2021-11-14 | San Juan | Utah | 49037 | 2588 | 43 |
1913742 | 1913742 | 2021-11-13 | San Juan | Utah | 49037 | 2588 | 43 |
1907738 | 1907738 | 2021-11-12 | Izard | Arkansas | 5065 | 2588 | 55 |
1910492 | 1910492 | 2021-11-12 | San Juan | Utah | 49037 | 2588 | 43 |
1879427 | 1879427 | 2021-11-03 | Mason | Kentucky | 21161 | 2588 | 68 |
1856658 | 1856658 | 2021-10-27 | Henry | Kentucky | 21103 | 2588 | 26 |
1858559 | 1858559 | 2021-10-27 | Colonial Heights city | Virginia | 51570 | 2588 | 66 |
1848631 | 1848631 | 2021-10-24 | Llano | Texas | 48299 | 2588 | 72 |
1845381 | 1845381 | 2021-10-23 | Llano | Texas | 48299 | 2588 | 72 |
1830224 | 1830224 | 2021-10-19 | Clay | Illinois | 17025 | 2588 | 59 |
1832238 | 1832238 | 2021-10-19 | Aransas | Texas | 48007 | 2588 | 63 |
1785471 | 1785471 | 2021-10-05 | Dodge | Minnesota | 27039 | 2588 | 6 |
1779588 | 1779588 | 2021-10-03 | Madison | North Carolina | 37115 | 2588 | 55 |
1776338 | 1776338 | 2021-10-02 | Madison | North Carolina | 37115 | 2588 | 55 |
1773088 | 1773088 | 2021-10-01 | Madison | North Carolina | 37115 | 2588 | 55 |
1755517 | 1755517 | 2021-09-26 | Hancock | Illinois | 17067 | 2588 | 44 |
1752269 | 1752269 | 2021-09-25 | Hancock | Illinois | 17067 | 2588 | 44 |
1749020 | 1749020 | 2021-09-24 | Hancock | Illinois | 17067 | 2588 | 44 |
1746659 | 1746659 | 2021-09-23 | Cooper | Missouri | 29053 | 2588 | 31 |
1728343 | 1728343 | 2021-09-17 | Freestone | Texas | 48161 | 2588 | 59 |
1702873 | 1702873 | 2021-09-09 | Vilas | Wisconsin | 55125 | 2588 | 47 |
1697184 | 1697184 | 2021-09-08 | Starke | Indiana | 18149 | 2588 | 62 |
1655296 | 1655296 | 2021-08-26 | Woodford | Kentucky | 21239 | 2588 | 23 |
1641673 | 1641673 | 2021-08-22 | Mitchell | Georgia | 13205 | 2588 | 86 |
1643727 | 1643727 | 2021-08-22 | Crockett | Tennessee | 47033 | 2588 | 53 |
1638423 | 1638423 | 2021-08-21 | Mitchell | Georgia | 13205 | 2588 | 86 |
1640477 | 1640477 | 2021-08-21 | Crockett | Tennessee | 47033 | 2588 | 53 |
1635173 | 1635173 | 2021-08-20 | Mitchell | Georgia | 13205 | 2588 | 86 |
1637227 | 1637227 | 2021-08-20 | Crockett | Tennessee | 47033 | 2588 | 53 |
1631967 | 1631967 | 2021-08-19 | Union | Georgia | 13291 | 2588 | 84 |
1626476 | 1626476 | 2021-08-17 | Henry | Missouri | 29083 | 2588 | 41 |
1620406 | 1620406 | 2021-08-15 | Martin | North Carolina | 37117 | 2588 | 46 |
1617158 | 1617158 | 2021-08-14 | Martin | North Carolina | 37117 | 2588 | 46 |
1612073 | 1612073 | 2021-08-13 | Conway | Arkansas | 5029 | 2588 | 37 |
1613910 | 1613910 | 2021-08-13 | Martin | North Carolina | 37117 | 2588 | 46 |
1596774 | 1596774 | 2021-08-08 | Lincoln | Kentucky | 21137 | 2588 | 61 |
1593525 | 1593525 | 2021-08-07 | Lincoln | Kentucky | 21137 | 2588 | 61 |
1590276 | 1590276 | 2021-08-06 | Lincoln | Kentucky | 21137 | 2588 | 61 |
1578862 | 1578862 | 2021-08-02 | Calhoun | Texas | 48057 | 2588 | 26 |
1575614 | 1575614 | 2021-08-01 | Calhoun | Texas | 48057 | 2588 | 26 |
1572366 | 1572366 | 2021-07-31 | Calhoun | Texas | 48057 | 2588 | 25 |
1553962 | 1553962 | 2021-07-26 | McDuffie | Georgia | 13189 | 2588 | 52 |
1551404 | 1551404 | 2021-07-25 | Union | Louisiana | 22111 | 2588 | 84 |
1548157 | 1548157 | 2021-07-24 | Union | Louisiana | 22111 | 2588 | 84 |
1544910 | 1544910 | 2021-07-23 | Union | Louisiana | 22111 | 2588 | 84 |
1533135 | 1533135 | 2021-07-19 | Rio Grande | Puerto Rico | 72119 | 2588 | |
1494532 | 1494532 | 2021-07-07 | Jones | Texas | 48253 | 2588 | 55 |
1488038 | 1488038 | 2021-07-05 | Jones | Texas | 48253 | 2588 | 55 |
1484791 | 1484791 | 2021-07-04 | Jones | Texas | 48253 | 2588 | 55 |
1485263 | 1485263 | 2021-07-04 | Waushara | Wisconsin | 55137 | 2588 | 38 |
1481545 | 1481545 | 2021-07-03 | Jones | Texas | 48253 | 2588 | 55 |
1482017 | 1482017 | 2021-07-03 | Waushara | Wisconsin | 55137 | 2588 | 38 |
1478770 | 1478770 | 2021-07-02 | Waushara | Wisconsin | 55137 | 2588 | 38 |
1437530 | 1437530 | 2021-06-20 | Franklin | Kansas | 20059 | 2588 | 43 |
1434283 | 1434283 | 2021-06-19 | Franklin | Kansas | 20059 | 2588 | 43 |
1431037 | 1431037 | 2021-06-18 | Franklin | Kansas | 20059 | 2588 | 43 |
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);