ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 4157 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 15
- Louisiana 9
- Indiana 8
- Kentucky 7
- Nebraska 7
- South Carolina 7
- North Carolina 6
- Missouri 5
- Tennessee 5
- Virginia 5
- California 3
- Colorado 3
- Montana 3
- Puerto Rico 3
- Texas 3
- Washington 3
- Wisconsin 3
- Arkansas 2
- Georgia 2
- Illinois 2
- Michigan 2
- Minnesota 2
- New Hampshire 2
- New York 2
- Pennsylvania 2
- West Virginia 2
- Alabama 1
- Alaska 1
- Florida 1
- Iowa 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472890 | 2472890 | 2022-05-04 | Aransas | Texas | 48007 | 4157 | 85 |
2466145 | 2466145 | 2022-05-02 | San German | Puerto Rico | 72125 | 4157 | |
2315536 | 2315536 | 2022-03-17 | Benton | Missouri | 29015 | 4157 | 95 |
2284642 | 2284642 | 2022-03-07 | Monroe | West Virginia | 54063 | 4157 | 40 |
2214344 | 2214344 | 2022-02-14 | Union | Kentucky | 21225 | 4157 | 54 |
2211067 | 2211067 | 2022-02-13 | Morgan | Kentucky | 21175 | 4157 | 17 |
2207814 | 2207814 | 2022-02-12 | Morgan | Kentucky | 21175 | 4157 | 17 |
2204561 | 2204561 | 2022-02-11 | Morgan | Kentucky | 21175 | 4157 | 17 |
2170045 | 2170045 | 2022-01-31 | Coamo | Puerto Rico | 72043 | 4157 | |
2126151 | 2126151 | 2022-01-18 | Orange | Indiana | 18117 | 4157 | 87 |
2106659 | 2106659 | 2022-01-12 | Sullivan | Indiana | 18153 | 4157 | 65 |
2088738 | 2088738 | 2022-01-06 | Isabela | Puerto Rico | 72071 | 4157 | |
2085010 | 2085010 | 2022-01-05 | Seneca | New York | 36099 | 4157 | 81 |
2059528 | 2059528 | 2021-12-28 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2056279 | 2056279 | 2021-12-27 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2053030 | 2053030 | 2021-12-26 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2049780 | 2049780 | 2021-12-25 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2046530 | 2046530 | 2021-12-24 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2043280 | 2043280 | 2021-12-23 | Abbeville | South Carolina | 45001 | 4157 | 53 |
2034650 | 2034650 | 2021-12-21 | Montezuma | Colorado | 8083 | 4157 | 51 |
2024733 | 2024733 | 2021-12-18 | Cleburne | Arkansas | 5023 | 4157 | 99 |
2021087 | 2021087 | 2021-12-16 | Gloucester | Virginia | 51073 | 4157 | 82 |
2013063 | 2013063 | 2021-12-14 | Leake | Mississippi | 28079 | 4157 | 92 |
1974535 | 1974535 | 2021-12-02 | Dare | North Carolina | 37055 | 4157 | 15 |
1970421 | 1970421 | 2021-12-01 | Letcher | Kentucky | 21133 | 4157 | 76 |
1967179 | 1967179 | 2021-11-30 | Marion | Kentucky | 21155 | 4157 | 52 |
1958219 | 1958219 | 2021-11-27 | Lewis | New York | 36049 | 4157 | 40 |
1946098 | 1946098 | 2021-11-23 | Karnes | Texas | 48255 | 4157 | 58 |
1941468 | 1941468 | 2021-11-22 | Meeker | Minnesota | 27093 | 4157 | 57 |
1942847 | 1942847 | 2021-11-22 | Karnes | Texas | 48255 | 4157 | 58 |
1926771 | 1926771 | 2021-11-17 | Accomack | Virginia | 51001 | 4157 | 80 |
1815913 | 1815913 | 2021-10-14 | DeKalb | Tennessee | 47041 | 4157 | 67 |
1807662 | 1807662 | 2021-10-12 | Wells | Indiana | 18179 | 4157 | 88 |
1777628 | 1777628 | 2021-10-03 | Bibb | Alabama | 1007 | 4157 | 83 |
1756312 | 1756312 | 2021-09-26 | Covington | Mississippi | 28031 | 4157 | 92 |
1753064 | 1753064 | 2021-09-25 | Covington | Mississippi | 28031 | 4157 | 92 |
1749816 | 1749816 | 2021-09-24 | Covington | Mississippi | 28031 | 4157 | 92 |
1735190 | 1735190 | 2021-09-19 | Warren | Virginia | 51187 | 4157 | 65 |
1731940 | 1731940 | 2021-09-18 | Warren | Virginia | 51187 | 4157 | 65 |
1728690 | 1728690 | 2021-09-17 | Warren | Virginia | 51187 | 4157 | 65 |
1719089 | 1719089 | 2021-09-14 | Oneida | Wisconsin | 55085 | 4157 | 83 |
1713097 | 1713097 | 2021-09-13 | Gilmer | Georgia | 13123 | 4157 | 105 |
1699487 | 1699487 | 2021-09-08 | Mason | Washington | 53045 | 4157 | 45 |
1693930 | 1693930 | 2021-09-07 | Ripley | Indiana | 18137 | 4157 | 73 |
1654459 | 1654459 | 2021-08-26 | Logan | Colorado | 8075 | 4157 | 69 |
1611767 | 1611767 | 2021-08-12 | Douglas | Washington | 53017 | 4157 | 23 |
1561426 | 1561426 | 2021-07-28 | Lincoln | Mississippi | 28085 | 4157 | 116 |
1557517 | 1557517 | 2021-07-27 | Whitley | Indiana | 18183 | 4157 | 45 |
1522727 | 1522727 | 2021-07-16 | Lincoln | Nebraska | 31111 | 4157 | 81 |
1519478 | 1519478 | 2021-07-15 | Lincoln | Nebraska | 31111 | 4157 | 81 |
1516231 | 1516231 | 2021-07-14 | Lincoln | Nebraska | 31111 | 4157 | 81 |
1512985 | 1512985 | 2021-07-13 | Lincoln | Nebraska | 31111 | 4157 | 81 |
1509738 | 1509738 | 2021-07-12 | Lincoln | Nebraska | 31111 | 4157 | 81 |
1506492 | 1506492 | 2021-07-11 | Lincoln | Nebraska | 31111 | 4157 | 81 |
1503246 | 1503246 | 2021-07-10 | Lincoln | Nebraska | 31111 | 4157 | 81 |
1451247 | 1451247 | 2021-06-24 | Silver Bow | Montana | 30093 | 4157 | 86 |
1448001 | 1448001 | 2021-06-23 | Silver Bow | Montana | 30093 | 4157 | 86 |
1437760 | 1437760 | 2021-06-20 | Natchitoches | Louisiana | 22069 | 4157 | 93 |
1438067 | 1438067 | 2021-06-20 | Monroe | Mississippi | 28095 | 4157 | 135 |
1438092 | 1438092 | 2021-06-20 | Union | Mississippi | 28145 | 4157 | 77 |
1434513 | 1434513 | 2021-06-19 | Natchitoches | Louisiana | 22069 | 4157 | 93 |
1434820 | 1434820 | 2021-06-19 | Monroe | Mississippi | 28095 | 4157 | 135 |
1434845 | 1434845 | 2021-06-19 | Union | Mississippi | 28145 | 4157 | 77 |
1431267 | 1431267 | 2021-06-18 | Natchitoches | Louisiana | 22069 | 4157 | 93 |
1431573 | 1431573 | 2021-06-18 | Monroe | Mississippi | 28095 | 4157 | 135 |
1431598 | 1431598 | 2021-06-18 | Union | Mississippi | 28145 | 4157 | 77 |
1428353 | 1428353 | 2021-06-17 | Union | Mississippi | 28145 | 4157 | 77 |
1428646 | 1428646 | 2021-06-17 | Belknap | New Hampshire | 33001 | 4157 | 100 |
1425401 | 1425401 | 2021-06-16 | Belknap | New Hampshire | 33001 | 4157 | 100 |
1404826 | 1404826 | 2021-06-10 | Randolph | Illinois | 17157 | 4157 | 93 |
1391644 | 1391644 | 2021-06-06 | Liberty | Georgia | 13179 | 4157 | 65 |
1393097 | 1393097 | 2021-06-06 | Davie | North Carolina | 37059 | 4157 | 39 |
1389852 | 1389852 | 2021-06-05 | Davie | North Carolina | 37059 | 4157 | 39 |
1386607 | 1386607 | 2021-06-04 | Davie | North Carolina | 37059 | 4157 | 39 |
1353398 | 1353398 | 2021-05-25 | Webster | Louisiana | 22119 | 4157 | 113 |
1306048 | 1306048 | 2021-05-10 | Campbell | Tennessee | 47013 | 4157 | 63 |
1301849 | 1301849 | 2021-05-09 | Platte | Missouri | 29165 | 4157 | 47 |
1272557 | 1272557 | 2021-04-30 | Butler | Missouri | 29023 | 4157 | 42 |
1268844 | 1268844 | 2021-04-29 | Graves | Kentucky | 21083 | 4157 | 92 |
1266641 | 1266641 | 2021-04-28 | Fulton | Ohio | 39051 | 4157 | 68 |
1216602 | 1216602 | 2021-04-13 | Montgomery | Indiana | 18107 | 4157 | 87 |
1206436 | 1206436 | 2021-04-10 | DeSoto | Florida | 12027 | 4157 | 86 |
1191331 | 1191331 | 2021-04-05 | Pontotoc | Mississippi | 28115 | 4157 | 72 |
1191367 | 1191367 | 2021-04-05 | Butler | Missouri | 29023 | 4157 | 40 |
1188083 | 1188083 | 2021-04-04 | Pontotoc | Mississippi | 28115 | 4157 | 72 |
1184836 | 1184836 | 2021-04-03 | Pontotoc | Mississippi | 28115 | 4157 | 72 |
1174971 | 1174971 | 2021-03-31 | Douglas | Minnesota | 27041 | 4157 | 70 |
1155329 | 1155329 | 2021-03-25 | Kennebec | Maine | 23011 | 4157 | 54 |
1144552 | 1144552 | 2021-03-22 | Miller | Arkansas | 5091 | 4157 | 35 |
1146828 | 1146828 | 2021-03-22 | Dillon | South Carolina | 45033 | 4157 | 81 |
1119604 | 1119604 | 2021-03-14 | Washington | Louisiana | 22117 | 4157 | 123 |
1109940 | 1109940 | 2021-03-11 | Cass | Michigan | 26027 | 4157 | 65 |
1086589 | 1086589 | 2021-03-04 | Franklin | Illinois | 17055 | 4157 | 78 |
1065222 | 1065222 | 2021-02-25 | Richmond | North Carolina | 37153 | 4157 | 89 |
1057501 | 1057501 | 2021-02-23 | Lawrence | Indiana | 18093 | 4157 | 114 |
1046830 | 1046830 | 2021-02-19 | Cowlitz | Washington | 53015 | 4157 | 57 |
1009623 | 1009623 | 2021-02-08 | Lincoln | Missouri | 29113 | 4157 | 27 |
1007724 | 1007724 | 2021-02-07 | Wasatch | Utah | 49051 | 4157 | 17 |
997675 | 997675 | 2021-02-04 | Obion | Tennessee | 47131 | 4157 | 91 |
974306 | 974306 | 2021-01-28 | Halifax | North Carolina | 37083 | 4157 | 80 |
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);