ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 8114 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Iowa 7
- Oklahoma 7
- Alabama 4
- Ohio 4
- Georgia 3
- North Carolina 3
- California 2
- Pennsylvania 2
- Texas 2
- Virginia 2
- West Virginia 2
- Colorado 1
- Florida 1
- Indiana 1
- Maryland 1
- Mississippi 1
- New Mexico 1
- New York 1
- Puerto Rico 1
- South Carolina 1
- Vermont 1
- Virgin Islands 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473186 | 2473186 | 2022-05-04 | St. Croix | Virgin Islands | 78010 | 8114 | 47 |
2456302 | 2456302 | 2022-04-29 | Snyder | Pennsylvania | 42109 | 8114 | 157 |
2446581 | 2446581 | 2022-04-26 | Humacao | Puerto Rico | 72069 | 8114 | |
2369381 | 2369381 | 2022-04-03 | Marion | Alabama | 1093 | 8114 | 151 |
2366128 | 2366128 | 2022-04-02 | Marion | Alabama | 1093 | 8114 | 151 |
2362875 | 2362875 | 2022-04-01 | Marion | Alabama | 1093 | 8114 | 151 |
2359621 | 2359621 | 2022-03-31 | Marion | Alabama | 1093 | 8114 | 151 |
2316788 | 2316788 | 2022-03-17 | Kendall | Texas | 48259 | 8114 | 117 |
2196635 | 2196635 | 2022-02-08 | Washington | Vermont | 50023 | 8114 | 44 |
2149586 | 2149586 | 2022-01-25 | Bolivar | Mississippi | 28011 | 8114 | 157 |
2100122 | 2100122 | 2022-01-10 | Knox | Indiana | 18083 | 8114 | 126 |
2083322 | 2083322 | 2022-01-05 | Lassen | California | 6035 | 8114 | 61 |
2034604 | 2034604 | 2021-12-21 | Tuolumne | California | 6109 | 8114 | 148 |
2007056 | 2007056 | 2021-12-12 | Haywood | North Carolina | 37087 | 8114 | 155 |
2003805 | 2003805 | 2021-12-11 | Haywood | North Carolina | 37087 | 8114 | 155 |
2000554 | 2000554 | 2021-12-10 | Haywood | North Carolina | 37087 | 8114 | 155 |
1921482 | 1921482 | 2021-11-16 | Warren | Iowa | 19181 | 8114 | 101 |
1918232 | 1918232 | 2021-11-15 | Warren | Iowa | 19181 | 8114 | 101 |
1914982 | 1914982 | 2021-11-14 | Warren | Iowa | 19181 | 8114 | 101 |
1911732 | 1911732 | 2021-11-13 | Warren | Iowa | 19181 | 8114 | 101 |
1908483 | 1908483 | 2021-11-12 | Warren | Iowa | 19181 | 8114 | 101 |
1905234 | 1905234 | 2021-11-11 | Warren | Iowa | 19181 | 8114 | 101 |
1901984 | 1901984 | 2021-11-10 | Warren | Iowa | 19181 | 8114 | 101 |
1893450 | 1893450 | 2021-11-07 | Knox | Ohio | 39083 | 8114 | 156 |
1880481 | 1880481 | 2021-11-03 | Sandusky | Ohio | 39143 | 8114 | 155 |
1851253 | 1851253 | 2021-10-25 | Washington | Ohio | 39167 | 8114 | 144 |
1838933 | 1838933 | 2021-10-21 | Rusk | Texas | 48401 | 8114 | 172 |
1745662 | 1745662 | 2021-09-23 | Tift | Georgia | 13277 | 8114 | 156 |
1743109 | 1743109 | 2021-09-22 | St. Mary's | Maryland | 24037 | 8114 | 142 |
1628100 | 1628100 | 2021-08-17 | Chippewa | Wisconsin | 55017 | 8114 | 99 |
1585861 | 1585861 | 2021-08-04 | Wood | West Virginia | 54107 | 8114 | 177 |
1560506 | 1560506 | 2021-07-28 | Walker | Georgia | 13295 | 8114 | 91 |
1549063 | 1549063 | 2021-07-24 | Erie | Ohio | 39043 | 8114 | 166 |
1481766 | 1481766 | 2021-07-03 | Frederick | Virginia | 51069 | 8114 | 103 |
1354439 | 1354439 | 2021-05-25 | Wagoner | Oklahoma | 40145 | 8114 | 116 |
1351193 | 1351193 | 2021-05-24 | Wagoner | Oklahoma | 40145 | 8114 | 116 |
1347947 | 1347947 | 2021-05-23 | Wagoner | Oklahoma | 40145 | 8114 | 116 |
1344699 | 1344699 | 2021-05-22 | Wagoner | Oklahoma | 40145 | 8114 | 116 |
1341451 | 1341451 | 2021-05-21 | Wagoner | Oklahoma | 40145 | 8114 | 116 |
1338203 | 1338203 | 2021-05-20 | Wagoner | Oklahoma | 40145 | 8114 | 116 |
1334956 | 1334956 | 2021-05-19 | Wagoner | Oklahoma | 40145 | 8114 | 116 |
1296213 | 1296213 | 2021-05-07 | Greenwood | South Carolina | 45047 | 8114 | 172 |
1267587 | 1267587 | 2021-04-28 | Roanoke | Virginia | 51161 | 8114 | 138 |
1229203 | 1229203 | 2021-04-17 | Nassau | Florida | 12089 | 8114 | 124 |
1131265 | 1131265 | 2021-03-17 | Cabell | West Virginia | 54011 | 8114 | 172 |
1104503 | 1104503 | 2021-03-09 | Northumberland | Pennsylvania | 42097 | 8114 | 326 |
876877 | 876877 | 2020-12-29 | Niagara | New York | 36063 | 8114 | 172 |
831404 | 831404 | 2020-12-15 | San Juan | New Mexico | 35045 | 8114 | 265 |
551022 | 551022 | 2020-09-20 | Chatham | Georgia | 13051 | 8114 | 146 |
473219 | 473219 | 2020-08-27 | Arapahoe | Colorado | 8005 | 8114 | 367 |
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);