ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
186 rows where cases = 2882 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 10
- Kentucky 10
- Missouri 10
- Minnesota 9
- Mississippi 9
- Oklahoma 9
- Virginia 9
- Georgia 8
- Ohio 8
- Tennessee 8
- Texas 8
- Utah 8
- Alaska 7
- Arkansas 7
- West Virginia 6
- Louisiana 5
- Nebraska 5
- Florida 4
- Indiana 4
- Michigan 4
- California 3
- Colorado 3
- Idaho 3
- New York 3
- North Carolina 3
- South Dakota 3
- Wisconsin 3
- Alabama 2
- Iowa 2
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486836 | 2486836 | 2022-05-09 | Park | Colorado | 8093 | 2882 | 20 |
2450125 | 2450125 | 2022-04-27 | Callahan | Texas | 48059 | 2882 | 72 |
2375931 | 2375931 | 2022-04-05 | Valdez-Cordova Census Area | Alaska | 2261 | 2882 | 17 |
2372679 | 2372679 | 2022-04-04 | Valdez-Cordova Census Area | Alaska | 2261 | 2882 | 17 |
2369426 | 2369426 | 2022-04-03 | Valdez-Cordova Census Area | Alaska | 2261 | 2882 | 17 |
2366173 | 2366173 | 2022-04-02 | Valdez-Cordova Census Area | Alaska | 2261 | 2882 | 17 |
2362920 | 2362920 | 2022-04-01 | Valdez-Cordova Census Area | Alaska | 2261 | 2882 | 17 |
2349457 | 2349457 | 2022-03-27 | Juab | Utah | 49023 | 2882 | 24 |
2346204 | 2346204 | 2022-03-26 | Juab | Utah | 49023 | 2882 | 24 |
2342951 | 2342951 | 2022-03-25 | Juab | Utah | 49023 | 2882 | 24 |
2339698 | 2339698 | 2022-03-24 | Juab | Utah | 49023 | 2882 | 23 |
2326688 | 2326688 | 2022-03-20 | Morgan | Utah | 49029 | 2882 | 14 |
2323435 | 2323435 | 2022-03-19 | Morgan | Utah | 49029 | 2882 | 14 |
2320181 | 2320181 | 2022-03-18 | Morgan | Utah | 49029 | 2882 | 14 |
2284911 | 2284911 | 2022-03-08 | Lee | Arkansas | 5077 | 2882 | 58 |
2254388 | 2254388 | 2022-02-26 | Vinton | Ohio | 39163 | 2882 | 55 |
2199441 | 2199441 | 2022-02-09 | Charles Mix | South Dakota | 46023 | 2882 | 32 |
2155379 | 2155379 | 2022-01-27 | Blackford | Indiana | 18009 | 2882 | 62 |
2123223 | 2123223 | 2022-01-17 | Monroe | Kentucky | 21171 | 2882 | 69 |
2125069 | 2125069 | 2022-01-17 | Alleghany | Virginia | 51005 | 2882 | 90 |
2119971 | 2119971 | 2022-01-16 | Monroe | Kentucky | 21171 | 2882 | 69 |
2116719 | 2116719 | 2022-01-15 | Monroe | Kentucky | 21171 | 2882 | 69 |
2113468 | 2113468 | 2022-01-14 | Monroe | Kentucky | 21171 | 2882 | 69 |
2111248 | 2111248 | 2022-01-13 | Monroe | Ohio | 39111 | 2882 | 67 |
2089663 | 2089663 | 2022-01-07 | Macon | Alabama | 1087 | 2882 | 69 |
2076307 | 2076307 | 2022-01-02 | Buckingham | Virginia | 51029 | 2882 | 41 |
2073056 | 2073056 | 2022-01-01 | Buckingham | Virginia | 51029 | 2882 | 41 |
2069805 | 2069805 | 2021-12-31 | Buckingham | Virginia | 51029 | 2882 | 41 |
2060503 | 2060503 | 2021-12-29 | Izard | Arkansas | 5065 | 2882 | 57 |
2063553 | 2063553 | 2021-12-29 | Marquette | Wisconsin | 55077 | 2882 | 39 |
2047496 | 2047496 | 2021-12-25 | Franklin | Arkansas | 5047 | 2882 | 58 |
2006676 | 2006676 | 2021-12-12 | Morgan | Missouri | 29141 | 2882 | 73 |
1988139 | 1988139 | 2021-12-06 | Cannon | Tennessee | 47015 | 2882 | 44 |
1988340 | 1988340 | 2021-12-06 | Houston | Texas | 48225 | 2882 | 87 |
1969436 | 1969436 | 2021-12-01 | North Slope Borough | Alaska | 2185 | 2882 | 8 |
1966186 | 1966186 | 2021-11-30 | North Slope Borough | Alaska | 2185 | 2882 | 8 |
1960299 | 1960299 | 2021-11-28 | White | Illinois | 17193 | 2882 | 43 |
1957048 | 1957048 | 2021-11-27 | White | Illinois | 17193 | 2882 | 43 |
1953797 | 1953797 | 2021-11-26 | White | Illinois | 17193 | 2882 | 43 |
1950546 | 1950546 | 2021-11-25 | White | Illinois | 17193 | 2882 | 43 |
1947295 | 1947295 | 2021-11-24 | White | Illinois | 17193 | 2882 | 43 |
1925794 | 1925794 | 2021-11-17 | Hertford | North Carolina | 37091 | 2882 | 72 |
1915409 | 1915409 | 2021-11-14 | Roscommon | Michigan | 26143 | 2882 | 71 |
1915489 | 1915489 | 2021-11-14 | Roseau | Minnesota | 27135 | 2882 | 31 |
1912159 | 1912159 | 2021-11-13 | Roscommon | Michigan | 26143 | 2882 | 71 |
1912239 | 1912239 | 2021-11-13 | Roseau | Minnesota | 27135 | 2882 | 31 |
1908909 | 1908909 | 2021-11-12 | Roscommon | Michigan | 26143 | 2882 | 71 |
1908989 | 1908989 | 2021-11-12 | Roseau | Minnesota | 27135 | 2882 | 31 |
1904981 | 1904981 | 2021-11-11 | Hancock | Illinois | 17067 | 2882 | 45 |
1901386 | 1901386 | 2021-11-10 | Otero | Colorado | 8089 | 2882 | 85 |
1901731 | 1901731 | 2021-11-10 | Hancock | Illinois | 17067 | 2882 | 45 |
1876323 | 1876323 | 2021-11-02 | Talbot | Maryland | 24041 | 2882 | 54 |
1816390 | 1816390 | 2021-10-14 | Prince Edward | Virginia | 51147 | 2882 | 50 |
1805205 | 1805205 | 2021-10-11 | Ray | Missouri | 29177 | 2882 | 48 |
1805689 | 1805689 | 2021-10-11 | Carroll | Ohio | 39019 | 2882 | 57 |
1796704 | 1796704 | 2021-10-08 | Shelby | Texas | 48419 | 2882 | 102 |
1773919 | 1773919 | 2021-10-01 | Montague | Texas | 48337 | 2882 | 86 |
1753240 | 1753240 | 2021-09-25 | Texas | Missouri | 29215 | 2882 | 40 |
1744457 | 1744457 | 2021-09-22 | Humphreys | Tennessee | 47085 | 2882 | 42 |
1741769 | 1741769 | 2021-09-21 | Nicholas | West Virginia | 54067 | 2882 | 30 |
1733566 | 1733566 | 2021-09-19 | Clay | Mississippi | 28025 | 2882 | 73 |
1730316 | 1730316 | 2021-09-18 | Clay | Mississippi | 28025 | 2882 | 73 |
1727066 | 1727066 | 2021-09-17 | Clay | Mississippi | 28025 | 2882 | 73 |
1728403 | 1728403 | 2021-09-17 | Lamb | Texas | 48279 | 2882 | 87 |
1719196 | 1719196 | 2021-09-15 | Randolph | Alabama | 1111 | 2882 | 55 |
1713298 | 1713298 | 2021-09-13 | Lawrence | Illinois | 17101 | 2882 | 39 |
1707373 | 1707373 | 2021-09-11 | Somerset | Maryland | 24039 | 2882 | 45 |
1694293 | 1694293 | 2021-09-07 | Concordia | Louisiana | 22029 | 2882 | 67 |
1653520 | 1653520 | 2021-08-25 | Morgan | Tennessee | 47129 | 2882 | 41 |
1648427 | 1648427 | 2021-08-24 | LaGrange | Indiana | 18087 | 2882 | 75 |
1650273 | 1650273 | 2021-08-24 | Morgan | Tennessee | 47129 | 2882 | 41 |
1643259 | 1643259 | 2021-08-22 | Coshocton | Ohio | 39031 | 2882 | 63 |
1608862 | 1608862 | 2021-08-12 | Ouachita | Arkansas | 5103 | 2882 | 67 |
1579949 | 1579949 | 2021-08-03 | Monroe | Georgia | 13207 | 2882 | 106 |
1580226 | 1580226 | 2021-08-03 | Posey | Indiana | 18129 | 2882 | 35 |
1582542 | 1582542 | 2021-08-03 | Okanogan | Washington | 53047 | 2882 | 42 |
1565978 | 1565978 | 2021-07-29 | Kleberg | Texas | 48273 | 2882 | 95 |
1554811 | 1554811 | 2021-07-26 | Cass | Minnesota | 27021 | 2882 | 33 |
1554877 | 1554877 | 2021-07-26 | Todd | Minnesota | 27153 | 2882 | 33 |
1555559 | 1555559 | 2021-07-26 | Fayette | Ohio | 39047 | 2882 | 50 |
1556614 | 1556614 | 2021-07-26 | Randolph | West Virginia | 54083 | 2882 | 15 |
1534167 | 1534167 | 2021-07-20 | Sevier | Arkansas | 5133 | 2882 | 24 |
1445996 | 1445996 | 2021-06-22 | Uintah | Utah | 49047 | 2882 | 25 |
1428003 | 1428003 | 2021-06-17 | De Soto | Louisiana | 22031 | 2882 | 78 |
1426730 | 1426730 | 2021-06-16 | Greenbrier | West Virginia | 54025 | 2882 | 64 |
1421450 | 1421450 | 2021-06-15 | Marshall | Kentucky | 21157 | 2882 | 59 |
1422589 | 1422589 | 2021-06-15 | Seminole | Oklahoma | 40133 | 2882 | 78 |
1423484 | 1423484 | 2021-06-15 | Greenbrier | West Virginia | 54025 | 2882 | 62 |
1423613 | 1423613 | 2021-06-15 | Park | Wyoming | 56029 | 2882 | 30 |
1419343 | 1419343 | 2021-06-14 | Seminole | Oklahoma | 40133 | 2882 | 78 |
1420237 | 1420237 | 2021-06-14 | Greenbrier | West Virginia | 54025 | 2882 | 62 |
1420366 | 1420366 | 2021-06-14 | Park | Wyoming | 56029 | 2882 | 30 |
1416098 | 1416098 | 2021-06-13 | Seminole | Oklahoma | 40133 | 2882 | 78 |
1412852 | 1412852 | 2021-06-12 | Seminole | Oklahoma | 40133 | 2882 | 78 |
1409607 | 1409607 | 2021-06-11 | Seminole | Oklahoma | 40133 | 2882 | 78 |
1406362 | 1406362 | 2021-06-10 | Seminole | Oklahoma | 40133 | 2882 | 78 |
1403116 | 1403116 | 2021-06-09 | Seminole | Oklahoma | 40133 | 2882 | 78 |
1343138 | 1343138 | 2021-05-22 | McDonough | Illinois | 17109 | 2882 | 61 |
1338099 | 1338099 | 2021-05-20 | Morrow | Ohio | 39117 | 2882 | 39 |
1301634 | 1301634 | 2021-05-09 | Le Sueur | Minnesota | 27079 | 2882 | 22 |
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);