ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where cases = 4120 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 15
- Nebraska 9
- Pennsylvania 9
- Tennessee 9
- Kentucky 8
- Wisconsin 8
- Illinois 7
- North Carolina 7
- Oklahoma 7
- Virginia 7
- Georgia 6
- Ohio 6
- Puerto Rico 6
- Missouri 5
- West Virginia 5
- Iowa 4
- Louisiana 4
- Minnesota 4
- Mississippi 4
- New York 4
- Washington 4
- South Dakota 3
- Alabama 2
- Alaska 2
- Arkansas 2
- Indiana 2
- Kansas 2
- Michigan 2
- New Mexico 2
- Oregon 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500393 | 2500393 | 2022-05-13 | Clay | Iowa | 19041 | 4120 | 44 |
2500611 | 2500611 | 2022-05-13 | Estill | Kentucky | 21065 | 4120 | 50 |
2497135 | 2497135 | 2022-05-12 | Clay | Iowa | 19041 | 4120 | 44 |
2497353 | 2497353 | 2022-05-12 | Estill | Kentucky | 21065 | 4120 | 50 |
2493877 | 2493877 | 2022-05-11 | Clay | Iowa | 19041 | 4120 | 44 |
2494095 | 2494095 | 2022-05-11 | Estill | Kentucky | 21065 | 4120 | 50 |
2490837 | 2490837 | 2022-05-10 | Estill | Kentucky | 21065 | 4120 | 50 |
2487580 | 2487580 | 2022-05-09 | Estill | Kentucky | 21065 | 4120 | 50 |
2489192 | 2489192 | 2022-05-09 | Bosque | Texas | 48035 | 4120 | 70 |
2485629 | 2485629 | 2022-05-08 | Aibonito | Puerto Rico | 72009 | 4120 | |
2485935 | 2485935 | 2022-05-08 | Bosque | Texas | 48035 | 4120 | 70 |
2482371 | 2482371 | 2022-05-07 | Aibonito | Puerto Rico | 72009 | 4120 | |
2482677 | 2482677 | 2022-05-07 | Bosque | Texas | 48035 | 4120 | 70 |
2395138 | 2395138 | 2022-04-10 | Nottoway | Virginia | 51135 | 4120 | 88 |
2391882 | 2391882 | 2022-04-09 | Nottoway | Virginia | 51135 | 4120 | 88 |
2388626 | 2388626 | 2022-04-08 | Nottoway | Virginia | 51135 | 4120 | 88 |
2361873 | 2361873 | 2022-03-31 | Fulton | Pennsylvania | 42057 | 4120 | 65 |
2358619 | 2358619 | 2022-03-30 | Fulton | Pennsylvania | 42057 | 4120 | 65 |
2355365 | 2355365 | 2022-03-29 | Fulton | Pennsylvania | 42057 | 4120 | 65 |
2352112 | 2352112 | 2022-03-28 | Fulton | Pennsylvania | 42057 | 4120 | 65 |
2348491 | 2348491 | 2022-03-27 | Chowan | North Carolina | 37041 | 4120 | 54 |
2348860 | 2348860 | 2022-03-27 | Fulton | Pennsylvania | 42057 | 4120 | 65 |
2345238 | 2345238 | 2022-03-26 | Chowan | North Carolina | 37041 | 4120 | 54 |
2341985 | 2341985 | 2022-03-25 | Chowan | North Carolina | 37041 | 4120 | 54 |
2296930 | 2296930 | 2022-03-11 | Yauco | Puerto Rico | 72153 | 4120 | |
2291668 | 2291668 | 2022-03-10 | Brantley | Georgia | 13025 | 4120 | 103 |
2282918 | 2282918 | 2022-03-07 | Wadena | Minnesota | 27159 | 4120 | 52 |
2266751 | 2266751 | 2022-03-02 | Benton | Missouri | 29015 | 4120 | 91 |
2264905 | 2264905 | 2022-03-01 | Addison | Vermont | 50001 | 4120 | 15 |
2261655 | 2261655 | 2022-02-28 | Addison | Vermont | 50001 | 4120 | 15 |
2258625 | 2258625 | 2022-02-27 | Monroe | West Virginia | 54063 | 4120 | 39 |
2255374 | 2255374 | 2022-02-26 | Monroe | West Virginia | 54063 | 4120 | 39 |
2252123 | 2252123 | 2022-02-25 | Monroe | West Virginia | 54063 | 4120 | 39 |
2216565 | 2216565 | 2022-02-15 | North Slope Borough | Alaska | 2185 | 4120 | 10 |
2213314 | 2213314 | 2022-02-14 | North Slope Borough | Alaska | 2185 | 4120 | 10 |
2186362 | 2186362 | 2022-02-05 | Yabucoa | Puerto Rico | 72151 | 4120 | |
2178347 | 2178347 | 2022-02-03 | Atchison | Kansas | 20005 | 4120 | 32 |
2175094 | 2175094 | 2022-02-02 | Atchison | Kansas | 20005 | 4120 | 32 |
2133394 | 2133394 | 2022-01-20 | Andrew | Missouri | 29003 | 4120 | 43 |
2102777 | 2102777 | 2022-01-11 | Lincoln | Arkansas | 5079 | 4120 | 59 |
2008646 | 2008646 | 2021-12-13 | Morgan | Colorado | 8087 | 4120 | 119 |
1997883 | 1997883 | 2021-12-09 | Yankton | South Dakota | 46135 | 4120 | 43 |
1981201 | 1981201 | 2021-12-04 | Hocking | Ohio | 39073 | 4120 | 93 |
1978559 | 1978559 | 2021-12-03 | Frio | Texas | 48163 | 4120 | 77 |
1975787 | 1975787 | 2021-12-02 | Kewaunee | Wisconsin | 55061 | 4120 | 49 |
1970457 | 1970457 | 2021-12-01 | Rowan | Kentucky | 21205 | 4120 | 37 |
1969085 | 1969085 | 2021-11-30 | Halifax | Virginia | 51083 | 4120 | 114 |
1904847 | 1904847 | 2021-11-11 | Peach | Georgia | 13225 | 4120 | 106 |
1901597 | 1901597 | 2021-11-10 | Peach | Georgia | 13225 | 4120 | 106 |
1891244 | 1891244 | 2021-11-06 | Upshur | West Virginia | 54097 | 4120 | 65 |
1810261 | 1810261 | 2021-10-13 | Jackson | Arkansas | 5067 | 4120 | 42 |
1802916 | 1802916 | 2021-10-10 | DeKalb | Tennessee | 47041 | 4120 | 67 |
1799667 | 1799667 | 2021-10-09 | DeKalb | Tennessee | 47041 | 4120 | 67 |
1796418 | 1796418 | 2021-10-08 | DeKalb | Tennessee | 47041 | 4120 | 67 |
1786176 | 1786176 | 2021-10-05 | Stutsman | North Dakota | 38093 | 4120 | 82 |
1786626 | 1786626 | 2021-10-05 | Lawrence | South Dakota | 46081 | 4120 | 54 |
1780183 | 1780183 | 2021-10-03 | Grainger | Tennessee | 47057 | 4120 | 60 |
1776933 | 1776933 | 2021-10-02 | Grainger | Tennessee | 47057 | 4120 | 60 |
1773683 | 1773683 | 2021-10-01 | Grainger | Tennessee | 47057 | 4120 | 60 |
1766528 | 1766528 | 2021-09-29 | Washington | New York | 36115 | 4120 | 65 |
1761575 | 1761575 | 2021-09-28 | Glenn | California | 6021 | 4120 | 36 |
1750679 | 1750679 | 2021-09-24 | Greene | Pennsylvania | 42059 | 4120 | 48 |
1737622 | 1737622 | 2021-09-20 | Coos | Oregon | 41011 | 4120 | 69 |
1712595 | 1712595 | 2021-09-12 | Oneida | Wisconsin | 55085 | 4120 | 83 |
1709348 | 1709348 | 2021-09-11 | Oneida | Wisconsin | 55085 | 4120 | 83 |
1706101 | 1706101 | 2021-09-10 | Oneida | Wisconsin | 55085 | 4120 | 83 |
1702898 | 1702898 | 2021-09-09 | Sheridan | Wyoming | 56033 | 4120 | 35 |
1678296 | 1678296 | 2021-09-02 | Polk | Minnesota | 27119 | 4120 | 75 |
1655312 | 1655312 | 2021-08-26 | De Soto | Louisiana | 22031 | 4120 | 95 |
1656074 | 1656074 | 2021-08-26 | Warren | New York | 36113 | 4120 | 68 |
1632572 | 1632572 | 2021-08-19 | East Feliciana | Louisiana | 22037 | 4120 | 128 |
1624364 | 1624364 | 2021-08-16 | Cooke | Texas | 48097 | 4120 | 72 |
1621117 | 1621117 | 2021-08-15 | Cooke | Texas | 48097 | 4120 | 72 |
1617869 | 1617869 | 2021-08-14 | Cooke | Texas | 48097 | 4120 | 72 |
1606196 | 1606196 | 2021-08-11 | Knox | Indiana | 18083 | 4120 | 91 |
1608520 | 1608520 | 2021-08-11 | Douglas | Washington | 53017 | 4120 | 23 |
1572029 | 1572029 | 2021-07-31 | Pike | Pennsylvania | 42103 | 4120 | 54 |
1568781 | 1568781 | 2021-07-30 | Pike | Pennsylvania | 42103 | 4120 | 54 |
1561825 | 1561825 | 2021-07-28 | Columbia | New York | 36021 | 4120 | 104 |
1562047 | 1562047 | 2021-07-28 | Crawford | Ohio | 39033 | 4120 | 111 |
1558304 | 1558304 | 2021-07-27 | Pulaski | Missouri | 29169 | 4120 | 56 |
1541224 | 1541224 | 2021-07-22 | Huntington | Indiana | 18069 | 4120 | 83 |
1509477 | 1509477 | 2021-07-12 | Neshoba | Mississippi | 28099 | 4120 | 180 |
1494751 | 1494751 | 2021-07-07 | Franklin | Virginia | 51067 | 4120 | 81 |
1438993 | 1438993 | 2021-06-20 | Ponce | Puerto Rico | 72113 | 4120 | |
1405872 | 1405872 | 2021-06-10 | Lincoln | Nebraska | 31111 | 4120 | 80 |
1402626 | 1402626 | 2021-06-09 | Lincoln | Nebraska | 31111 | 4120 | 80 |
1399381 | 1399381 | 2021-06-08 | Lincoln | Nebraska | 31111 | 4120 | 80 |
1396135 | 1396135 | 2021-06-07 | Lincoln | Nebraska | 31111 | 4120 | 80 |
1392889 | 1392889 | 2021-06-06 | Lincoln | Nebraska | 31111 | 4120 | 80 |
1389644 | 1389644 | 2021-06-05 | Lincoln | Nebraska | 31111 | 4120 | 80 |
1386399 | 1386399 | 2021-06-04 | Lincoln | Nebraska | 31111 | 4120 | 80 |
1379843 | 1379843 | 2021-06-02 | Silver Bow | Montana | 30093 | 4120 | 86 |
1375975 | 1375975 | 2021-06-01 | Franklin | Kentucky | 21073 | 4120 | 56 |
1360219 | 1360219 | 2021-05-27 | Camden | Missouri | 29029 | 4120 | 88 |
1347658 | 1347658 | 2021-05-23 | Davie | North Carolina | 37059 | 4120 | 37 |
1344410 | 1344410 | 2021-05-22 | Davie | North Carolina | 37059 | 4120 | 37 |
1341162 | 1341162 | 2021-05-21 | Davie | North Carolina | 37059 | 4120 | 37 |
1337467 | 1337467 | 2021-05-20 | Union | Mississippi | 28145 | 4120 | 76 |
1331703 | 1331703 | 2021-05-18 | Sequoyah | Oklahoma | 40135 | 4120 | 51 |
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);