ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 4128 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 11
- Georgia 10
- Texas 9
- Florida 8
- Iowa 8
- Kansas 6
- Missouri 6
- North Carolina 6
- Arkansas 5
- Virginia 5
- Ohio 4
- Tennessee 4
- Indiana 3
- Kentucky 3
- Maryland 3
- Michigan 3
- Minnesota 3
- Pennsylvania 3
- South Carolina 3
- Idaho 2
- Louisiana 2
- Mississippi 2
- Nebraska 2
- New York 2
- West Virginia 2
- Alabama 1
- California 1
- Connecticut 1
- Maine 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2454097 | 2454097 | 2022-04-29 | Clay | Arkansas | 5021 | 4128 | 93 |
2430228 | 2430228 | 2022-04-21 | Fulton | Pennsylvania | 42057 | 4128 | 65 |
2422243 | 2422243 | 2022-04-19 | Dickinson | Iowa | 19059 | 4128 | 72 |
2418987 | 2418987 | 2022-04-18 | Dickinson | Iowa | 19059 | 4128 | 72 |
2415731 | 2415731 | 2022-04-17 | Dickinson | Iowa | 19059 | 4128 | 72 |
2412475 | 2412475 | 2022-04-16 | Dickinson | Iowa | 19059 | 4128 | 72 |
2409219 | 2409219 | 2022-04-15 | Dickinson | Iowa | 19059 | 4128 | 72 |
2405963 | 2405963 | 2022-04-14 | Dickinson | Iowa | 19059 | 4128 | 72 |
2402707 | 2402707 | 2022-04-13 | Dickinson | Iowa | 19059 | 4128 | 72 |
2374516 | 2374516 | 2022-04-04 | Chowan | North Carolina | 37041 | 4128 | 56 |
2272953 | 2272953 | 2022-03-04 | Washington | Maine | 23029 | 4128 | 50 |
2270023 | 2270023 | 2022-03-03 | Cooper | Missouri | 29053 | 4128 | 74 |
2200604 | 2200604 | 2022-02-10 | Union | Florida | 12125 | 4128 | 106 |
2197350 | 2197350 | 2022-02-09 | Union | Florida | 12125 | 4128 | 106 |
2194096 | 2194096 | 2022-02-08 | Union | Florida | 12125 | 4128 | 104 |
2190842 | 2190842 | 2022-02-07 | Union | Florida | 12125 | 4128 | 104 |
2187589 | 2187589 | 2022-02-06 | Union | Florida | 12125 | 4128 | 104 |
2184336 | 2184336 | 2022-02-05 | Union | Florida | 12125 | 4128 | 104 |
2181084 | 2181084 | 2022-02-04 | Union | Florida | 12125 | 4128 | 104 |
2168388 | 2168388 | 2022-01-31 | White | Illinois | 17193 | 4128 | 48 |
2165336 | 2165336 | 2022-01-30 | Bourbon | Kansas | 20011 | 4128 | 46 |
2162081 | 2162081 | 2022-01-29 | Bourbon | Kansas | 20011 | 4128 | 46 |
2158826 | 2158826 | 2022-01-28 | Bourbon | Kansas | 20011 | 4128 | 46 |
2152520 | 2152520 | 2022-01-26 | Rockcastle | Kentucky | 21203 | 4128 | 51 |
2140764 | 2140764 | 2022-01-22 | Fajardo | Puerto Rico | 72053 | 4128 | |
2137863 | 2137863 | 2022-01-21 | Gonzales | Texas | 48177 | 4128 | 92 |
2081009 | 2081009 | 2022-01-04 | Grant | Louisiana | 22043 | 4128 | 79 |
2056761 | 2056761 | 2021-12-27 | Sevier | Utah | 49041 | 4128 | 20 |
2033531 | 2033531 | 2021-12-20 | Abbeville | South Carolina | 45001 | 4128 | 53 |
2034152 | 2034152 | 2021-12-20 | Salem city | Virginia | 51775 | 4128 | 81 |
1998097 | 1998097 | 2021-12-09 | Hutchinson | Texas | 48233 | 4128 | 98 |
1985778 | 1985778 | 2021-12-06 | Sevier | Arkansas | 5133 | 4128 | 61 |
1983015 | 1983015 | 2021-12-05 | McDonough | Illinois | 17109 | 4128 | 78 |
1979765 | 1979765 | 2021-12-04 | McDonough | Illinois | 17109 | 4128 | 78 |
1976515 | 1976515 | 2021-12-03 | McDonough | Illinois | 17109 | 4128 | 78 |
1954319 | 1954319 | 2021-11-26 | Queen Anne's | Maryland | 24035 | 4128 | 75 |
1951068 | 1951068 | 2021-11-25 | Queen Anne's | Maryland | 24035 | 4128 | 75 |
1947817 | 1947817 | 2021-11-24 | Queen Anne's | Maryland | 24035 | 4128 | 75 |
1917022 | 1917022 | 2021-11-14 | Accomack | Virginia | 51001 | 4128 | 80 |
1913772 | 1913772 | 2021-11-13 | Accomack | Virginia | 51001 | 4128 | 80 |
1910522 | 1910522 | 2021-11-12 | Accomack | Virginia | 51001 | 4128 | 80 |
1905090 | 1905090 | 2021-11-11 | Jennings | Indiana | 18079 | 4128 | 68 |
1831698 | 1831698 | 2021-10-19 | Gallia | Ohio | 39053 | 4128 | 66 |
1818477 | 1818477 | 2021-10-15 | Franklin | New York | 36033 | 4128 | 20 |
1813510 | 1813510 | 2021-10-14 | Jackson | Arkansas | 5067 | 4128 | 42 |
1804256 | 1804256 | 2021-10-11 | Iroquois | Illinois | 17075 | 4128 | 78 |
1801007 | 1801007 | 2021-10-10 | Iroquois | Illinois | 17075 | 4128 | 78 |
1797758 | 1797758 | 2021-10-09 | Iroquois | Illinois | 17075 | 4128 | 78 |
1794509 | 1794509 | 2021-10-08 | Iroquois | Illinois | 17075 | 4128 | 78 |
1753165 | 1753165 | 2021-09-25 | Dunklin | Missouri | 29069 | 4128 | 58 |
1700220 | 1700220 | 2021-09-09 | Bonner | Idaho | 16017 | 4128 | 51 |
1683282 | 1683282 | 2021-09-03 | Marshall | West Virginia | 54051 | 4128 | 86 |
1638110 | 1638110 | 2021-08-21 | St. Francis | Arkansas | 5123 | 4128 | 49 |
1640668 | 1640668 | 2021-08-21 | Hopkins | Texas | 48223 | 4128 | 120 |
1618973 | 1618973 | 2021-08-15 | Toombs | Georgia | 13279 | 4128 | 123 |
1615725 | 1615725 | 2021-08-14 | Toombs | Georgia | 13279 | 4128 | 123 |
1612476 | 1612476 | 2021-08-13 | Toombs | Georgia | 13279 | 4128 | 123 |
1605640 | 1605640 | 2021-08-11 | Amador | California | 6005 | 4128 | 49 |
1602793 | 1602793 | 2021-08-10 | Nez Perce | Idaho | 16069 | 4128 | 61 |
1584086 | 1584086 | 2021-08-04 | Nobles | Minnesota | 27105 | 4128 | 50 |
1571782 | 1571782 | 2021-07-31 | Brown | Ohio | 39015 | 4128 | 62 |
1565295 | 1565295 | 2021-07-29 | Crawford | Ohio | 39033 | 4128 | 111 |
1520009 | 1520009 | 2021-07-15 | Polk | Oregon | 41053 | 4128 | 56 |
1485699 | 1485699 | 2021-07-05 | Camden | Georgia | 13039 | 4128 | 39 |
1482453 | 1482453 | 2021-07-04 | Camden | Georgia | 13039 | 4128 | 39 |
1479206 | 1479206 | 2021-07-03 | Camden | Georgia | 13039 | 4128 | 39 |
1475960 | 1475960 | 2021-07-02 | Camden | Georgia | 13039 | 4128 | 39 |
1419454 | 1419454 | 2021-06-14 | Wayne | Pennsylvania | 42127 | 4128 | 82 |
1396190 | 1396190 | 2021-06-07 | Belknap | New Hampshire | 33001 | 4128 | 100 |
1347713 | 1347713 | 2021-05-23 | Stokes | North Carolina | 37169 | 4128 | 80 |
1344465 | 1344465 | 2021-05-22 | Stokes | North Carolina | 37169 | 4128 | 80 |
1341217 | 1341217 | 2021-05-21 | Stokes | North Carolina | 37169 | 4128 | 80 |
1310686 | 1310686 | 2021-05-12 | Randolph | Illinois | 17157 | 4128 | 90 |
1304194 | 1304194 | 2021-05-10 | Randolph | Illinois | 17157 | 4128 | 90 |
1302888 | 1302888 | 2021-05-09 | Weakley | Tennessee | 47183 | 4128 | 65 |
1299641 | 1299641 | 2021-05-08 | Weakley | Tennessee | 47183 | 4128 | 65 |
1294427 | 1294427 | 2021-05-07 | Lee | Illinois | 17103 | 4128 | 91 |
1296394 | 1296394 | 2021-05-07 | Weakley | Tennessee | 47183 | 4128 | 65 |
1285776 | 1285776 | 2021-05-04 | Platte | Nebraska | 31141 | 4128 | 48 |
1282106 | 1282106 | 2021-05-03 | Sanilac | Michigan | 26151 | 4128 | 103 |
1274181 | 1274181 | 2021-04-30 | Ohio | West Virginia | 54069 | 4128 | 81 |
1269882 | 1269882 | 2021-04-29 | Defiance | Ohio | 39039 | 4128 | 96 |
1242951 | 1242951 | 2021-04-21 | Avoyelles | Louisiana | 22009 | 4128 | 123 |
1238027 | 1238027 | 2021-04-19 | Erath | Texas | 48143 | 4128 | 68 |
1234780 | 1234780 | 2021-04-18 | Erath | Texas | 48143 | 4128 | 68 |
1231532 | 1231532 | 2021-04-17 | Erath | Texas | 48143 | 4128 | 68 |
1228284 | 1228284 | 2021-04-16 | Erath | Texas | 48143 | 4128 | 68 |
1223922 | 1223922 | 2021-04-15 | Platte | Missouri | 29165 | 4128 | 46 |
1203568 | 1203568 | 2021-04-09 | Clinton | Indiana | 18023 | 4128 | 58 |
1165736 | 1165736 | 2021-03-28 | Clinton | New York | 36019 | 4128 | 30 |
1158893 | 1158893 | 2021-03-26 | Butler | Missouri | 29023 | 4128 | 39 |
1085511 | 1085511 | 2021-03-03 | Nacogdoches | Texas | 48347 | 4128 | 151 |
1081420 | 1081420 | 2021-03-02 | Hoke | North Carolina | 37093 | 4128 | 54 |
1059400 | 1059400 | 2021-02-23 | Burnet | Texas | 48053 | 4128 | 55 |
1049439 | 1049439 | 2021-02-20 | Chesterfield | South Carolina | 45025 | 4128 | 93 |
1037802 | 1037802 | 2021-02-17 | Thomas | Georgia | 13275 | 4128 | 111 |
1020072 | 1020072 | 2021-02-11 | Bradford | Pennsylvania | 42015 | 4128 | 73 |
1012781 | 1012781 | 2021-02-09 | Panola | Mississippi | 28107 | 4128 | 88 |
996639 | 996639 | 2021-02-04 | Lincoln | Missouri | 29113 | 4128 | 27 |
953430 | 953430 | 2021-01-22 | Ware | Georgia | 13299 | 4128 | 105 |
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);