ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
172 rows where cases = 2890 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 13
- Indiana 10
- Utah 10
- Michigan 9
- Minnesota 9
- Missouri 9
- Texas 9
- Kansas 8
- Georgia 7
- Iowa 7
- Arkansas 6
- Kentucky 6
- Illinois 5
- New York 5
- South Dakota 5
- Tennessee 5
- Virginia 5
- Colorado 4
- Louisiana 4
- Massachusetts 4
- West Virginia 4
- California 3
- Ohio 3
- South Carolina 3
- Alabama 2
- Maryland 2
- North Carolina 2
- Puerto Rico 2
- Alaska 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500375 | 2500375 | 2022-05-13 | Allamakee | Iowa | 19005 | 2890 | 60 |
2497117 | 2497117 | 2022-05-12 | Allamakee | Iowa | 19005 | 2890 | 60 |
2493351 | 2493351 | 2022-05-11 | Park | Colorado | 8093 | 2890 | 20 |
2493859 | 2493859 | 2022-05-11 | Allamakee | Iowa | 19005 | 2890 | 60 |
2489866 | 2489866 | 2022-05-10 | Wilcox | Alabama | 1131 | 2890 | 46 |
2466404 | 2466404 | 2022-05-02 | Callahan | Texas | 48059 | 2890 | 72 |
2440593 | 2440593 | 2022-04-24 | Juab | Utah | 49023 | 2890 | 25 |
2437337 | 2437337 | 2022-04-23 | Juab | Utah | 49023 | 2890 | 25 |
2434081 | 2434081 | 2022-04-22 | Juab | Utah | 49023 | 2890 | 25 |
2430825 | 2430825 | 2022-04-21 | Juab | Utah | 49023 | 2890 | 25 |
2427569 | 2427569 | 2022-04-20 | Juab | Utah | 49023 | 2890 | 25 |
2424313 | 2424313 | 2022-04-19 | Juab | Utah | 49023 | 2890 | 25 |
2294696 | 2294696 | 2022-03-11 | Stone | Arkansas | 5137 | 2890 | 61 |
2290160 | 2290160 | 2022-03-09 | Vinton | Ohio | 39163 | 2890 | 55 |
2283656 | 2283656 | 2022-03-07 | Vinton | Ohio | 39163 | 2890 | 55 |
2237398 | 2237398 | 2022-02-21 | Watonwan | Minnesota | 27165 | 2890 | 22 |
2234147 | 2234147 | 2022-02-20 | Watonwan | Minnesota | 27165 | 2890 | 22 |
2230896 | 2230896 | 2022-02-19 | Watonwan | Minnesota | 27165 | 2890 | 22 |
2227645 | 2227645 | 2022-02-18 | Watonwan | Minnesota | 27165 | 2890 | 22 |
2213438 | 2213438 | 2022-02-14 | Mariposa | California | 6043 | 2890 | 20 |
2212454 | 2212454 | 2022-02-13 | Charles Mix | South Dakota | 46023 | 2890 | 32 |
2209201 | 2209201 | 2022-02-12 | Charles Mix | South Dakota | 46023 | 2890 | 32 |
2205948 | 2205948 | 2022-02-11 | Charles Mix | South Dakota | 46023 | 2890 | 32 |
2188675 | 2188675 | 2022-02-06 | Perry | Mississippi | 28111 | 2890 | 58 |
2185422 | 2185422 | 2022-02-05 | Perry | Mississippi | 28111 | 2890 | 58 |
2182170 | 2182170 | 2022-02-04 | Perry | Mississippi | 28111 | 2890 | 58 |
2175413 | 2175413 | 2022-02-02 | Kent | Maryland | 24029 | 2890 | 64 |
2171466 | 2171466 | 2022-02-01 | Telfair | Georgia | 13271 | 2890 | 76 |
2142770 | 2142770 | 2022-01-23 | Trigg | Kentucky | 21221 | 2890 | 34 |
2139515 | 2139515 | 2022-01-22 | Trigg | Kentucky | 21221 | 2890 | 34 |
2136259 | 2136259 | 2022-01-21 | Trigg | Kentucky | 21221 | 2890 | 34 |
2126676 | 2126676 | 2022-01-18 | Leelanau | Michigan | 26089 | 2890 | 43 |
2123368 | 2123368 | 2022-01-17 | Dukes | Massachusetts | 25007 | 2890 | 0 |
2123424 | 2123424 | 2022-01-17 | Leelanau | Michigan | 26089 | 2890 | 43 |
2120116 | 2120116 | 2022-01-16 | Dukes | Massachusetts | 25007 | 2890 | 0 |
2120172 | 2120172 | 2022-01-16 | Leelanau | Michigan | 26089 | 2890 | 43 |
2116864 | 2116864 | 2022-01-15 | Dukes | Massachusetts | 25007 | 2890 | 0 |
2116920 | 2116920 | 2022-01-15 | Leelanau | Michigan | 26089 | 2890 | 43 |
2113613 | 2113613 | 2022-01-14 | Dukes | Massachusetts | 25007 | 2890 | 0 |
2113669 | 2113669 | 2022-01-14 | Leelanau | Michigan | 26089 | 2890 | 43 |
2110688 | 2110688 | 2022-01-13 | Macon | Missouri | 29121 | 2890 | 39 |
2084510 | 2084510 | 2022-01-05 | Renville | Minnesota | 27129 | 2890 | 52 |
2082764 | 2082764 | 2022-01-04 | San Juan | Utah | 49037 | 2890 | 46 |
2057245 | 2057245 | 2021-12-28 | Franklin | Arkansas | 5047 | 2890 | 58 |
2034279 | 2034279 | 2021-12-20 | Crawford | Wisconsin | 55023 | 2890 | 25 |
1987513 | 1987513 | 2021-12-06 | Avery | North Carolina | 37011 | 2890 | 39 |
1960563 | 1960563 | 2021-11-28 | Neosho | Kansas | 20133 | 2890 | 53 |
1957312 | 1957312 | 2021-11-27 | Neosho | Kansas | 20133 | 2890 | 53 |
1954061 | 1954061 | 2021-11-26 | Neosho | Kansas | 20133 | 2890 | 53 |
1950810 | 1950810 | 2021-11-25 | Neosho | Kansas | 20133 | 2890 | 53 |
1947559 | 1947559 | 2021-11-24 | Neosho | Kansas | 20133 | 2890 | 53 |
1944869 | 1944869 | 2021-11-23 | Cooper | Missouri | 29053 | 2890 | 52 |
1941956 | 1941956 | 2021-11-22 | Essex | New York | 36031 | 2890 | 37 |
1910981 | 1910981 | 2021-11-13 | Grant | Arkansas | 5053 | 2890 | 50 |
1907732 | 1907732 | 2021-11-12 | Grant | Arkansas | 5053 | 2890 | 50 |
1811705 | 1811705 | 2021-10-13 | Ray | Missouri | 29177 | 2890 | 49 |
1803746 | 1803746 | 2021-10-11 | Cross | Arkansas | 5037 | 2890 | 64 |
1800497 | 1800497 | 2021-10-10 | Cross | Arkansas | 5037 | 2890 | 64 |
1778095 | 1778095 | 2021-10-03 | Jeff Davis | Georgia | 13161 | 2890 | 55 |
1774845 | 1774845 | 2021-10-02 | Jeff Davis | Georgia | 13161 | 2890 | 55 |
1771595 | 1771595 | 2021-10-01 | Jeff Davis | Georgia | 13161 | 2890 | 55 |
1768346 | 1768346 | 2021-09-30 | Jeff Davis | Georgia | 13161 | 2890 | 55 |
1762157 | 1762157 | 2021-09-28 | Starke | Indiana | 18149 | 2890 | 67 |
1762985 | 1762985 | 2021-09-28 | Texas | Missouri | 29215 | 2890 | 40 |
1746713 | 1746713 | 2021-09-23 | Perry | Missouri | 29157 | 2890 | 32 |
1741402 | 1741402 | 2021-09-21 | Lamb | Texas | 48279 | 2890 | 87 |
1724830 | 1724830 | 2021-09-16 | Hampton | South Carolina | 45049 | 2890 | 66 |
1716544 | 1716544 | 2021-09-14 | Lawrence | Illinois | 17101 | 2890 | 39 |
1678592 | 1678592 | 2021-09-02 | Cass | Nebraska | 31025 | 2890 | 17 |
1678872 | 1678872 | 2021-09-02 | Martin | North Carolina | 37117 | 2890 | 53 |
1667361 | 1667361 | 2021-08-30 | Del Norte | California | 6015 | 2890 | 23 |
1667456 | 1667456 | 2021-08-30 | Morgan | Colorado | 8087 | 2890 | 96 |
1670142 | 1670142 | 2021-08-30 | Gloucester | Virginia | 51073 | 2890 | 53 |
1648135 | 1648135 | 2021-08-24 | Grady | Georgia | 13131 | 2890 | 67 |
1650620 | 1650620 | 2021-08-24 | Botetourt | Virginia | 51023 | 2890 | 38 |
1619880 | 1619880 | 2021-08-15 | Grenada | Mississippi | 28043 | 2890 | 89 |
1616632 | 1616632 | 2021-08-14 | Grenada | Mississippi | 28043 | 2890 | 89 |
1613384 | 1613384 | 2021-08-13 | Grenada | Mississippi | 28043 | 2890 | 89 |
1610568 | 1610568 | 2021-08-12 | Lewis | New York | 36049 | 2890 | 36 |
1556162 | 1556162 | 2021-07-26 | Dimmit | Texas | 48127 | 2890 | 37 |
1551173 | 1551173 | 2021-07-25 | Labette | Kansas | 20099 | 2890 | 51 |
1552915 | 1552915 | 2021-07-25 | Dimmit | Texas | 48127 | 2890 | 37 |
1547926 | 1547926 | 2021-07-24 | Labette | Kansas | 20099 | 2890 | 51 |
1549668 | 1549668 | 2021-07-24 | Dimmit | Texas | 48127 | 2890 | 37 |
1544679 | 1544679 | 2021-07-23 | Labette | Kansas | 20099 | 2890 | 51 |
1536539 | 1536539 | 2021-07-20 | DeKalb | Tennessee | 47041 | 2890 | 56 |
1496502 | 1496502 | 2021-07-08 | Prentiss | Mississippi | 28117 | 2890 | 61 |
1470647 | 1470647 | 2021-06-30 | Saline | Missouri | 29195 | 2890 | 38 |
1460127 | 1460127 | 2021-06-27 | Bremer | Iowa | 19017 | 2890 | 62 |
1462431 | 1462431 | 2021-06-27 | Greenbrier | West Virginia | 54025 | 2890 | 64 |
1459186 | 1459186 | 2021-06-26 | Greenbrier | West Virginia | 54025 | 2890 | 64 |
1455941 | 1455941 | 2021-06-25 | Greenbrier | West Virginia | 54025 | 2890 | 64 |
1450391 | 1450391 | 2021-06-24 | Bremer | Iowa | 19017 | 2890 | 62 |
1452487 | 1452487 | 2021-06-24 | Uintah | Utah | 49047 | 2890 | 25 |
1449241 | 1449241 | 2021-06-23 | Uintah | Utah | 49047 | 2890 | 25 |
1415209 | 1415209 | 2021-06-13 | Wexford | Michigan | 26165 | 2890 | 47 |
1411963 | 1411963 | 2021-06-12 | Wexford | Michigan | 26165 | 2890 | 47 |
1408718 | 1408718 | 2021-06-11 | Wexford | Michigan | 26165 | 2890 | 47 |
1359371 | 1359371 | 2021-05-27 | McDonough | Illinois | 17109 | 2890 | 62 |
1356125 | 1356125 | 2021-05-26 | McDonough | Illinois | 17109 | 2890 | 62 |
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);