ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
144 rows where cases = 3969 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 14
- Oklahoma 14
- Mississippi 10
- Iowa 9
- North Carolina 9
- Georgia 8
- Minnesota 7
- Michigan 6
- Ohio 6
- Wisconsin 6
- Louisiana 5
- Texas 5
- Tennessee 4
- Wyoming 4
- Indiana 3
- Missouri 3
- Pennsylvania 3
- South Dakota 3
- Washington 3
- Idaho 2
- Kansas 2
- New York 2
- Oregon 2
- Utah 2
- Virginia 2
- Alabama 1
- Arkansas 1
- California 1
- Florida 1
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493016 | 2493016 | 2022-05-10 | Richland | Wisconsin | 55103 | 3969 | 48 |
2398537 | 2398537 | 2022-04-11 | Burnett | Wisconsin | 55013 | 3969 | 43 |
2385592 | 2385592 | 2022-04-07 | Lincoln | Wyoming | 56023 | 3969 | 31 |
2382337 | 2382337 | 2022-04-06 | Lincoln | Wyoming | 56023 | 3969 | 31 |
2379082 | 2379082 | 2022-04-05 | Lincoln | Wyoming | 56023 | 3969 | 31 |
2336451 | 2336451 | 2022-03-23 | San Juan | Utah | 49037 | 3969 | 47 |
2333197 | 2333197 | 2022-03-22 | San Juan | Utah | 49037 | 3969 | 47 |
2328172 | 2328172 | 2022-03-21 | Bienville | Louisiana | 22013 | 3969 | 111 |
2269166 | 2269166 | 2022-03-03 | Mercer | Illinois | 17131 | 3969 | 47 |
2271479 | 2271479 | 2022-03-03 | Grayson | Virginia | 51077 | 3969 | 77 |
2240808 | 2240808 | 2022-02-22 | Morgan | Missouri | 29141 | 3969 | 100 |
2225510 | 2225510 | 2022-02-17 | Union | South Dakota | 46127 | 3969 | 49 |
2225627 | 2225627 | 2022-02-17 | Bosque | Texas | 48035 | 3969 | 66 |
2172854 | 2172854 | 2022-02-01 | Avery | North Carolina | 37011 | 3969 | 39 |
2144724 | 2144724 | 2022-01-23 | Adams | Washington | 53001 | 3969 | 35 |
2141469 | 2141469 | 2022-01-22 | Adams | Washington | 53001 | 3969 | 35 |
2138213 | 2138213 | 2022-01-21 | Adams | Washington | 53001 | 3969 | 35 |
2126002 | 2126002 | 2022-01-18 | Clay | Illinois | 17025 | 3969 | 66 |
2123631 | 2123631 | 2022-01-17 | Winston | Mississippi | 28159 | 3969 | 95 |
2120379 | 2120379 | 2022-01-16 | Winston | Mississippi | 28159 | 3969 | 95 |
2117127 | 2117127 | 2022-01-15 | Winston | Mississippi | 28159 | 3969 | 95 |
2117758 | 2117758 | 2022-01-15 | Paulding | Ohio | 39125 | 3969 | 63 |
2113876 | 2113876 | 2022-01-14 | Winston | Mississippi | 28159 | 3969 | 95 |
2112250 | 2112250 | 2022-01-13 | Lewis | West Virginia | 54041 | 3969 | 70 |
2067416 | 2067416 | 2021-12-31 | Kauai | Hawaii | 15007 | 3969 | 18 |
2028307 | 2028307 | 2021-12-19 | Fannin | Georgia | 13111 | 3969 | 115 |
2025056 | 2025056 | 2021-12-18 | Fannin | Georgia | 13111 | 3969 | 115 |
2021805 | 2021805 | 2021-12-17 | Fannin | Georgia | 13111 | 3969 | 115 |
2016384 | 2016384 | 2021-12-15 | Crawford | Missouri | 29055 | 3969 | 76 |
1998394 | 1998394 | 2021-12-09 | Salem city | Virginia | 51775 | 3969 | 73 |
1990261 | 1990261 | 2021-12-07 | Waseca | Minnesota | 27161 | 3969 | 34 |
1971453 | 1971453 | 2021-12-01 | Holmes | Ohio | 39075 | 3969 | 140 |
1963424 | 1963424 | 2021-11-29 | Cassia | Idaho | 16031 | 3969 | 43 |
1965380 | 1965380 | 2021-11-29 | Yankton | South Dakota | 46135 | 3969 | 41 |
1949782 | 1949782 | 2021-11-24 | Kewaunee | Wisconsin | 55061 | 3969 | 48 |
1938837 | 1938837 | 2021-11-21 | Transylvania | North Carolina | 37175 | 3969 | 50 |
1940069 | 1940069 | 2021-11-21 | Waushara | Wisconsin | 55137 | 3969 | 56 |
1935587 | 1935587 | 2021-11-20 | Transylvania | North Carolina | 37175 | 3969 | 50 |
1936819 | 1936819 | 2021-11-20 | Waushara | Wisconsin | 55137 | 3969 | 56 |
1932337 | 1932337 | 2021-11-19 | Transylvania | North Carolina | 37175 | 3969 | 50 |
1933569 | 1933569 | 2021-11-19 | Waushara | Wisconsin | 55137 | 3969 | 56 |
1877332 | 1877332 | 2021-11-02 | Columbia | Oregon | 41009 | 3969 | 44 |
1853621 | 1853621 | 2021-10-26 | Dickinson | Michigan | 26043 | 3969 | 80 |
1850372 | 1850372 | 2021-10-25 | Dickinson | Michigan | 26043 | 3969 | 80 |
1808243 | 1808243 | 2021-10-12 | Mille Lacs | Minnesota | 27095 | 3969 | 64 |
1781376 | 1781376 | 2021-10-04 | Peach | Georgia | 13225 | 3969 | 90 |
1770199 | 1770199 | 2021-09-30 | Tioga | Pennsylvania | 42117 | 3969 | 119 |
1758851 | 1758851 | 2021-09-27 | Decatur | Indiana | 18031 | 3969 | 102 |
1758855 | 1758855 | 2021-09-27 | Fayette | Indiana | 18041 | 3969 | 82 |
1755521 | 1755521 | 2021-09-26 | Iroquois | Illinois | 17075 | 3969 | 75 |
1752273 | 1752273 | 2021-09-25 | Iroquois | Illinois | 17075 | 3969 | 75 |
1749024 | 1749024 | 2021-09-24 | Iroquois | Illinois | 17075 | 3969 | 75 |
1746471 | 1746471 | 2021-09-23 | Carlton | Minnesota | 27017 | 3969 | 60 |
1744183 | 1744183 | 2021-09-22 | Jefferson | Pennsylvania | 42065 | 3969 | 103 |
1741145 | 1741145 | 2021-09-21 | Meade | South Dakota | 46093 | 3969 | 38 |
1732141 | 1732141 | 2021-09-19 | Bibb | Alabama | 1007 | 3969 | 77 |
1701538 | 1701538 | 2021-09-09 | Otsego | New York | 36077 | 3969 | 49 |
1702242 | 1702242 | 2021-09-09 | McNairy | Tennessee | 47109 | 3969 | 61 |
1697079 | 1697079 | 2021-09-08 | Perry | Illinois | 17145 | 3969 | 78 |
1699166 | 1699166 | 2021-09-08 | Kleberg | Texas | 48273 | 3969 | 107 |
1628792 | 1628792 | 2021-08-18 | Bureau | Illinois | 17011 | 3969 | 99 |
1619830 | 1619830 | 2021-08-15 | Polk | Minnesota | 27119 | 3969 | 74 |
1616582 | 1616582 | 2021-08-14 | Polk | Minnesota | 27119 | 3969 | 74 |
1613334 | 1613334 | 2021-08-13 | Polk | Minnesota | 27119 | 3969 | 74 |
1592633 | 1592633 | 2021-08-07 | St. Francis | Arkansas | 5123 | 3969 | 46 |
1584815 | 1584815 | 2021-08-04 | Logan | Ohio | 39091 | 3969 | 79 |
1580309 | 1580309 | 2021-08-03 | Lee | Iowa | 19111 | 3969 | 58 |
1576800 | 1576800 | 2021-08-02 | Nez Perce | Idaho | 16069 | 3969 | 60 |
1577060 | 1577060 | 2021-08-02 | Lee | Iowa | 19111 | 3969 | 58 |
1573812 | 1573812 | 2021-08-01 | Lee | Iowa | 19111 | 3969 | 58 |
1570564 | 1570564 | 2021-07-31 | Lee | Iowa | 19111 | 3969 | 58 |
1567316 | 1567316 | 2021-07-30 | Lee | Iowa | 19111 | 3969 | 58 |
1568594 | 1568594 | 2021-07-30 | Preble | Ohio | 39135 | 3969 | 107 |
1564068 | 1564068 | 2021-07-29 | Lee | Iowa | 19111 | 3969 | 58 |
1560820 | 1560820 | 2021-07-28 | Lee | Iowa | 19111 | 3969 | 58 |
1447920 | 1447920 | 2021-06-23 | Phelps | Missouri | 29161 | 3969 | 131 |
1437259 | 1437259 | 2021-06-20 | Logan | Illinois | 17107 | 3969 | 77 |
1434012 | 1434012 | 2021-06-19 | Logan | Illinois | 17107 | 3969 | 77 |
1430766 | 1430766 | 2021-06-18 | Logan | Illinois | 17107 | 3969 | 77 |
1389319 | 1389319 | 2021-06-05 | Steele | Minnesota | 27147 | 3969 | 16 |
1377134 | 1377134 | 2021-06-01 | McCurtain | Oklahoma | 40089 | 3969 | 93 |
1373888 | 1373888 | 2021-05-31 | McCurtain | Oklahoma | 40089 | 3969 | 93 |
1370643 | 1370643 | 2021-05-30 | McCurtain | Oklahoma | 40089 | 3969 | 93 |
1367397 | 1367397 | 2021-05-29 | McCurtain | Oklahoma | 40089 | 3969 | 93 |
1364151 | 1364151 | 2021-05-28 | McCurtain | Oklahoma | 40089 | 3969 | 93 |
1360905 | 1360905 | 2021-05-27 | McCurtain | Oklahoma | 40089 | 3969 | 93 |
1357659 | 1357659 | 2021-05-26 | McCurtain | Oklahoma | 40089 | 3969 | 93 |
1336719 | 1336719 | 2021-05-20 | Huntington | Indiana | 18069 | 3969 | 82 |
1324450 | 1324450 | 2021-05-16 | Lincoln | Mississippi | 28085 | 3969 | 110 |
1321204 | 1321204 | 2021-05-15 | Lincoln | Mississippi | 28085 | 3969 | 110 |
1316911 | 1316911 | 2021-05-14 | Camden | Georgia | 13039 | 3969 | 37 |
1317958 | 1317958 | 2021-05-14 | Lincoln | Mississippi | 28085 | 3969 | 110 |
1308917 | 1308917 | 2021-05-11 | Caddo | Oklahoma | 40015 | 3969 | 88 |
1305671 | 1305671 | 2021-05-10 | Caddo | Oklahoma | 40015 | 3969 | 88 |
1302425 | 1302425 | 2021-05-09 | Caddo | Oklahoma | 40015 | 3969 | 88 |
1299177 | 1299177 | 2021-05-08 | Caddo | Oklahoma | 40015 | 3969 | 88 |
1295931 | 1295931 | 2021-05-07 | Caddo | Oklahoma | 40015 | 3969 | 88 |
1296101 | 1296101 | 2021-05-07 | Wayne | Pennsylvania | 42127 | 3969 | 80 |
1292685 | 1292685 | 2021-05-06 | Caddo | Oklahoma | 40015 | 3969 | 88 |
1289439 | 1289439 | 2021-05-05 | Caddo | Oklahoma | 40015 | 3969 | 88 |
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);