ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where cases = 5165 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 10
- North Carolina 10
- Tennessee 10
- Colorado 8
- Alabama 7
- Arkansas 7
- Wisconsin 5
- Georgia 4
- Illinois 4
- Indiana 4
- Minnesota 4
- Washington 4
- California 3
- Oregon 3
- Texas 3
- Kansas 2
- Kentucky 2
- Louisiana 2
- Missouri 2
- New Mexico 2
- New York 2
- Ohio 2
- Puerto Rico 2
- South Carolina 2
- Arizona 1
- Florida 1
- Michigan 1
- New Hampshire 1
- Oklahoma 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490482 | 2490482 | 2022-05-10 | Richland | Illinois | 17159 | 5165 | 83 |
2491768 | 2491768 | 2022-05-10 | Madison | North Carolina | 37115 | 5165 | 81 |
2488510 | 2488510 | 2022-05-09 | Madison | North Carolina | 37115 | 5165 | 81 |
2485253 | 2485253 | 2022-05-08 | Madison | North Carolina | 37115 | 5165 | 81 |
2481995 | 2481995 | 2022-05-07 | Madison | North Carolina | 37115 | 5165 | 81 |
2478737 | 2478737 | 2022-05-06 | Madison | North Carolina | 37115 | 5165 | 81 |
2475479 | 2475479 | 2022-05-05 | Madison | North Carolina | 37115 | 5165 | 81 |
2472222 | 2472222 | 2022-05-04 | Madison | North Carolina | 37115 | 5165 | 81 |
2465539 | 2465539 | 2022-05-02 | Unknown | New Hampshire | 5165 | 2 | |
2449359 | 2449359 | 2022-04-27 | Schoharie | New York | 36095 | 5165 | 36 |
2349987 | 2349987 | 2022-03-28 | Randolph | Arkansas | 5121 | 5165 | 83 |
2346734 | 2346734 | 2022-03-27 | Randolph | Arkansas | 5121 | 5165 | 83 |
2343481 | 2343481 | 2022-03-26 | Randolph | Arkansas | 5121 | 5165 | 83 |
2327089 | 2327089 | 2022-03-21 | Marengo | Alabama | 1091 | 5165 | 106 |
2297917 | 2297917 | 2022-03-12 | Lawrence | Arkansas | 5075 | 5165 | 74 |
2289843 | 2289843 | 2022-03-09 | Lincoln | New Mexico | 35027 | 5165 | 64 |
2265298 | 2265298 | 2022-03-02 | Pickens | Alabama | 1107 | 5165 | 97 |
2249111 | 2249111 | 2022-02-25 | Clark | Arkansas | 5019 | 5165 | 74 |
2248861 | 2248861 | 2022-02-24 | Lewis | West Virginia | 54041 | 5165 | 78 |
2223760 | 2223760 | 2022-02-17 | Spencer | Indiana | 18147 | 5165 | 58 |
2221576 | 2221576 | 2022-02-16 | Taos | New Mexico | 35055 | 5165 | 84 |
2193758 | 2193758 | 2022-02-08 | Monroe | Alabama | 1099 | 5165 | 71 |
2177610 | 2177610 | 2022-02-03 | Ouachita | Arkansas | 5103 | 5165 | 92 |
2147285 | 2147285 | 2022-01-24 | Juana Diaz | Puerto Rico | 72075 | 5165 | |
2136757 | 2136757 | 2022-01-21 | Washington | Missouri | 29221 | 5165 | 116 |
2100540 | 2100540 | 2022-01-10 | Sabine | Louisiana | 22085 | 5165 | 99 |
2089317 | 2089317 | 2022-01-06 | Caroline | Virginia | 51033 | 5165 | 58 |
2080673 | 2080673 | 2022-01-04 | Buena Vista | Iowa | 19021 | 5165 | 49 |
2077421 | 2077421 | 2022-01-03 | Buena Vista | Iowa | 19021 | 5165 | 49 |
2074170 | 2074170 | 2022-01-02 | Buena Vista | Iowa | 19021 | 5165 | 49 |
2070919 | 2070919 | 2022-01-01 | Buena Vista | Iowa | 19021 | 5165 | 49 |
2067668 | 2067668 | 2021-12-31 | Buena Vista | Iowa | 19021 | 5165 | 49 |
2064417 | 2064417 | 2021-12-30 | Buena Vista | Iowa | 19021 | 5165 | 49 |
2061167 | 2061167 | 2021-12-29 | Buena Vista | Iowa | 19021 | 5165 | 49 |
1995637 | 1995637 | 2021-12-09 | Logan | Colorado | 8075 | 5165 | 93 |
1960975 | 1960975 | 2021-11-28 | Mille Lacs | Minnesota | 27095 | 5165 | 73 |
1962164 | 1962164 | 2021-11-28 | Hardeman | Tennessee | 47069 | 5165 | 85 |
1957724 | 1957724 | 2021-11-27 | Mille Lacs | Minnesota | 27095 | 5165 | 73 |
1958913 | 1958913 | 2021-11-27 | Hardeman | Tennessee | 47069 | 5165 | 85 |
1954473 | 1954473 | 2021-11-26 | Mille Lacs | Minnesota | 27095 | 5165 | 73 |
1955662 | 1955662 | 2021-11-26 | Hardeman | Tennessee | 47069 | 5165 | 85 |
1952411 | 1952411 | 2021-11-25 | Hardeman | Tennessee | 47069 | 5165 | 85 |
1949160 | 1949160 | 2021-11-24 | Hardeman | Tennessee | 47069 | 5165 | 85 |
1944000 | 1944000 | 2021-11-23 | Logan | Illinois | 17107 | 5165 | 89 |
1945776 | 1945776 | 2021-11-23 | Clarendon | South Carolina | 45027 | 5165 | 136 |
1942525 | 1942525 | 2021-11-22 | Clarendon | South Carolina | 45027 | 5165 | 136 |
1939924 | 1939924 | 2021-11-21 | Kittitas | Washington | 53037 | 5165 | 55 |
1936674 | 1936674 | 2021-11-20 | Kittitas | Washington | 53037 | 5165 | 55 |
1933424 | 1933424 | 2021-11-19 | Kittitas | Washington | 53037 | 5165 | 55 |
1927397 | 1927397 | 2021-11-18 | Summit | Colorado | 8117 | 5165 | 12 |
1915703 | 1915703 | 2021-11-14 | Warren | Missouri | 29219 | 5165 | 50 |
1898619 | 1898619 | 2021-11-09 | Ripley | Indiana | 18137 | 5165 | 93 |
1882533 | 1882533 | 2021-11-04 | Harvey | Kansas | 20079 | 5165 | 84 |
1879284 | 1879284 | 2021-11-03 | Harvey | Kansas | 20079 | 5165 | 84 |
1870835 | 1870835 | 2021-10-31 | Coos | Oregon | 41011 | 5165 | 96 |
1867586 | 1867586 | 2021-10-30 | Coos | Oregon | 41011 | 5165 | 96 |
1864337 | 1864337 | 2021-10-29 | Coos | Oregon | 41011 | 5165 | 96 |
1838233 | 1838233 | 2021-10-21 | Perry | Ohio | 39127 | 5165 | 63 |
1807498 | 1807498 | 2021-10-12 | Fulton | Illinois | 17057 | 5165 | 81 |
1777814 | 1777814 | 2021-10-03 | Amador | California | 6005 | 5165 | 61 |
1774564 | 1774564 | 2021-10-02 | Amador | California | 6005 | 5165 | 61 |
1771314 | 1771314 | 2021-10-01 | Amador | California | 6005 | 5165 | 61 |
1755160 | 1755160 | 2021-09-26 | La Plata | Colorado | 8067 | 5165 | 50 |
1751912 | 1751912 | 2021-09-25 | La Plata | Colorado | 8067 | 5165 | 50 |
1754270 | 1754270 | 2021-09-25 | Bee | Texas | 48025 | 5165 | 110 |
1748663 | 1748663 | 2021-09-24 | La Plata | Colorado | 8067 | 5165 | 50 |
1746536 | 1746536 | 2021-09-23 | Steele | Minnesota | 27147 | 5165 | 21 |
1712826 | 1712826 | 2021-09-13 | Union | Arkansas | 5139 | 5165 | 125 |
1713144 | 1713144 | 2021-09-13 | Oconee | Georgia | 13219 | 5165 | 75 |
1715228 | 1715228 | 2021-09-13 | Marion | Tennessee | 47115 | 5165 | 51 |
1702517 | 1702517 | 2021-09-09 | Washington | Texas | 48477 | 5165 | 106 |
1670368 | 1670368 | 2021-08-30 | Polk | Wisconsin | 55095 | 5165 | 69 |
1667114 | 1667114 | 2021-08-29 | Monroe | Wisconsin | 55081 | 5165 | 52 |
1663866 | 1663866 | 2021-08-28 | Monroe | Wisconsin | 55081 | 5165 | 52 |
1660618 | 1660618 | 2021-08-27 | Monroe | Wisconsin | 55081 | 5165 | 52 |
1645135 | 1645135 | 2021-08-23 | Woodford | Illinois | 17203 | 5165 | 97 |
1615216 | 1615216 | 2021-08-14 | Covington | Alabama | 1039 | 5165 | 128 |
1611967 | 1611967 | 2021-08-13 | Covington | Alabama | 1039 | 5165 | 128 |
1573213 | 1573213 | 2021-08-01 | Broomfield | Colorado | 8014 | 5165 | 77 |
1569965 | 1569965 | 2021-07-31 | Broomfield | Colorado | 8014 | 5165 | 77 |
1566717 | 1566717 | 2021-07-30 | Broomfield | Colorado | 8014 | 5165 | 77 |
1554526 | 1554526 | 2021-07-26 | Henderson | Kentucky | 21101 | 5165 | 79 |
1496039 | 1496039 | 2021-07-08 | Boyd | Kentucky | 21019 | 5165 | 76 |
1471853 | 1471853 | 2021-06-30 | Nacogdoches | Texas | 48347 | 5165 | 173 |
1447232 | 1447232 | 2021-06-23 | Webster | Iowa | 19187 | 5165 | 94 |
1398536 | 1398536 | 2021-06-08 | Sioux | Iowa | 19167 | 5165 | 74 |
1395289 | 1395289 | 2021-06-07 | Sioux | Iowa | 19167 | 5165 | 74 |
1328792 | 1328792 | 2021-05-17 | Franklin | Tennessee | 47051 | 5165 | 90 |
1242996 | 1242996 | 2021-04-21 | St. Martin | Louisiana | 22099 | 5165 | 115 |
1182196 | 1182196 | 2021-04-02 | Darke | Ohio | 39037 | 5165 | 121 |
1115936 | 1115936 | 2021-03-13 | Noble | Indiana | 18113 | 5165 | 82 |
1047516 | 1047516 | 2021-02-20 | Polk | Georgia | 13233 | 5165 | 76 |
1000488 | 1000488 | 2021-02-05 | Cherokee | Oklahoma | 40021 | 5165 | 35 |
994408 | 994408 | 2021-02-03 | Jefferson | Tennessee | 47089 | 5165 | 90 |
979604 | 979604 | 2021-01-30 | Marshall | Indiana | 18099 | 5165 | 84 |
893782 | 893782 | 2021-01-03 | Gibson | Tennessee | 47053 | 5165 | 93 |
881553 | 881553 | 2020-12-31 | Talladega | Alabama | 1121 | 5165 | 75 |
869050 | 869050 | 2020-12-27 | Walton | Georgia | 13297 | 5165 | 88 |
779987 | 779987 | 2020-11-29 | Carolina | Puerto Rico | 72031 | 5165 | |
769886 | 769886 | 2020-11-26 | Randolph | North Carolina | 37151 | 5165 | 79 |
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);