ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where cases = 2486 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 18
- Georgia 16
- Texas 16
- Kansas 12
- Mississippi 10
- Alabama 7
- Ohio 7
- Virginia 7
- Missouri 6
- Utah 6
- Arkansas 5
- Indiana 5
- Minnesota 5
- Puerto Rico 5
- Louisiana 4
- Colorado 3
- Iowa 3
- Montana 3
- Pennsylvania 3
- South Dakota 3
- West Virginia 3
- California 2
- Maryland 2
- Michigan 2
- New York 2
- North Carolina 2
- Vermont 2
- Alaska 1
- Florida 1
- Illinois 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502469 | 2502469 | 2022-05-13 | Emery | Utah | 49015 | 2486 | 28 |
2499211 | 2499211 | 2022-05-12 | Emery | Utah | 49015 | 2486 | 28 |
2495953 | 2495953 | 2022-05-11 | Emery | Utah | 49015 | 2486 | 28 |
2391243 | 2391243 | 2022-04-09 | Luquillo | Puerto Rico | 72089 | 2486 | |
2347683 | 2347683 | 2022-03-27 | Wolfe | Kentucky | 21237 | 2486 | 19 |
2344430 | 2344430 | 2022-03-26 | Wolfe | Kentucky | 21237 | 2486 | 19 |
2341177 | 2341177 | 2022-03-25 | Wolfe | Kentucky | 21237 | 2486 | 19 |
2337924 | 2337924 | 2022-03-24 | Wolfe | Kentucky | 21237 | 2486 | 19 |
2334670 | 2334670 | 2022-03-23 | Wolfe | Kentucky | 21237 | 2486 | 19 |
2331416 | 2331416 | 2022-03-22 | Wolfe | Kentucky | 21237 | 2486 | 19 |
2333147 | 2333147 | 2022-03-22 | Terry | Texas | 48445 | 2486 | 84 |
2328164 | 2328164 | 2022-03-21 | Wolfe | Kentucky | 21237 | 2486 | 19 |
2308042 | 2308042 | 2022-03-15 | Stewart | Georgia | 13259 | 2486 | 32 |
2304791 | 2304791 | 2022-03-14 | Stewart | Georgia | 13259 | 2486 | 32 |
2301539 | 2301539 | 2022-03-13 | Stewart | Georgia | 13259 | 2486 | 32 |
2298287 | 2298287 | 2022-03-12 | Stewart | Georgia | 13259 | 2486 | 32 |
2295035 | 2295035 | 2022-03-11 | Stewart | Georgia | 13259 | 2486 | 32 |
2291783 | 2291783 | 2022-03-10 | Stewart | Georgia | 13259 | 2486 | 32 |
2277803 | 2277803 | 2022-03-05 | Morris | Texas | 48343 | 2486 | 69 |
2274550 | 2274550 | 2022-03-04 | Morris | Texas | 48343 | 2486 | 69 |
2220449 | 2220449 | 2022-02-16 | Crawford | Indiana | 18025 | 2486 | 35 |
2197260 | 2197260 | 2022-02-09 | Prowers | Colorado | 8099 | 2486 | 45 |
2178424 | 2178424 | 2022-02-03 | Rice | Kansas | 20159 | 2486 | 18 |
2175171 | 2175171 | 2022-02-02 | Rice | Kansas | 20159 | 2486 | 18 |
2018264 | 2018264 | 2021-12-16 | Marion | Arkansas | 5089 | 2486 | 68 |
2020508 | 2020508 | 2021-12-16 | San Lorenzo | Puerto Rico | 72129 | 2486 | |
2008615 | 2008615 | 2021-12-13 | Crowley | Colorado | 8025 | 2486 | 27 |
2010676 | 2010676 | 2021-12-13 | Potter | Pennsylvania | 42105 | 2486 | 70 |
2006602 | 2006602 | 2021-12-12 | Yalobusha | Mississippi | 28161 | 2486 | 47 |
2006738 | 2006738 | 2021-12-12 | Glacier | Montana | 30035 | 2486 | 62 |
2003351 | 2003351 | 2021-12-11 | Yalobusha | Mississippi | 28161 | 2486 | 47 |
2003487 | 2003487 | 2021-12-11 | Glacier | Montana | 30035 | 2486 | 62 |
2000101 | 2000101 | 2021-12-10 | Yalobusha | Mississippi | 28161 | 2486 | 47 |
2000237 | 2000237 | 2021-12-10 | Glacier | Montana | 30035 | 2486 | 62 |
1996881 | 1996881 | 2021-12-09 | Dallas | Missouri | 29059 | 2486 | 57 |
1989939 | 1989939 | 2021-12-07 | Monroe | Kentucky | 21171 | 2486 | 65 |
1963967 | 1963967 | 2021-11-29 | Washington | Kentucky | 21229 | 2486 | 48 |
1930380 | 1930380 | 2021-11-19 | Lamar | Alabama | 1075 | 2486 | 53 |
1924043 | 1924043 | 2021-11-17 | Inyo | California | 6027 | 2486 | 42 |
1919858 | 1919858 | 2021-11-15 | Oglala Lakota | South Dakota | 46102 | 2486 | 53 |
1913200 | 1913200 | 2021-11-13 | Corozal | Puerto Rico | 72047 | 2486 | |
1907736 | 1907736 | 2021-11-12 | Howard | Arkansas | 5061 | 2486 | 38 |
1884494 | 1884494 | 2021-11-04 | San Juan | Utah | 49037 | 2486 | 41 |
1877900 | 1877900 | 2021-11-02 | Nolan | Texas | 48353 | 2486 | 79 |
1874628 | 1874628 | 2021-11-01 | Madison | Texas | 48313 | 2486 | 43 |
1830679 | 1830679 | 2021-10-19 | Lewis | Kentucky | 21135 | 2486 | 55 |
1810200 | 1810200 | 2021-10-13 | North Slope Borough | Alaska | 2185 | 2486 | 5 |
1807831 | 1807831 | 2021-10-12 | Neosho | Kansas | 20133 | 2486 | 49 |
1804580 | 1804580 | 2021-10-11 | Neosho | Kansas | 20133 | 2486 | 49 |
1802482 | 1802482 | 2021-10-10 | Meigs | Ohio | 39105 | 2486 | 45 |
1756228 | 1756228 | 2021-09-26 | Dodge | Minnesota | 27039 | 2486 | 5 |
1752980 | 1752980 | 2021-09-25 | Dodge | Minnesota | 27039 | 2486 | 5 |
1753138 | 1753138 | 2021-09-25 | Benton | Missouri | 29015 | 2486 | 43 |
1749732 | 1749732 | 2021-09-24 | Dodge | Minnesota | 27039 | 2486 | 5 |
1712308 | 1712308 | 2021-09-12 | Bennington | Vermont | 50003 | 2486 | 16 |
1680010 | 1680010 | 2021-09-02 | Boone | West Virginia | 54005 | 2486 | 37 |
1647819 | 1647819 | 2021-08-24 | Hempstead | Arkansas | 5057 | 2486 | 20 |
1650599 | 1650599 | 2021-08-24 | Rutland | Vermont | 50021 | 2486 | 22 |
1637981 | 1637981 | 2021-08-21 | Monroe | Alabama | 1099 | 2486 | 42 |
1569835 | 1569835 | 2021-07-31 | Cleburne | Arkansas | 5023 | 2486 | 74 |
1561038 | 1561038 | 2021-07-28 | Lincoln | Kentucky | 21137 | 2486 | 60 |
1549068 | 1549068 | 2021-07-24 | Gallia | Ohio | 39053 | 2486 | 50 |
1541508 | 1541508 | 2021-07-22 | Carter | Kentucky | 21043 | 2486 | 35 |
1530868 | 1530868 | 2021-07-19 | Columbia | Arkansas | 5027 | 2486 | 58 |
1497681 | 1497681 | 2021-07-08 | Calhoun | Texas | 48057 | 2486 | 25 |
1494434 | 1494434 | 2021-07-07 | Calhoun | Texas | 48057 | 2486 | 25 |
1471705 | 1471705 | 2021-06-30 | Burleson | Texas | 48051 | 2486 | 48 |
1468575 | 1468575 | 2021-06-29 | Lamb | Texas | 48279 | 2486 | 83 |
1442614 | 1442614 | 2021-06-21 | Lamb | Texas | 48279 | 2486 | 83 |
1438070 | 1438070 | 2021-06-20 | Newton | Mississippi | 28101 | 2486 | 63 |
1439369 | 1439369 | 2021-06-20 | Lamb | Texas | 48279 | 2486 | 83 |
1434823 | 1434823 | 2021-06-19 | Newton | Mississippi | 28101 | 2486 | 63 |
1436122 | 1436122 | 2021-06-19 | Lamb | Texas | 48279 | 2486 | 83 |
1431576 | 1431576 | 2021-06-18 | Newton | Mississippi | 28101 | 2486 | 63 |
1428331 | 1428331 | 2021-06-17 | Newton | Mississippi | 28101 | 2486 | 63 |
1425086 | 1425086 | 2021-06-16 | Newton | Mississippi | 28101 | 2486 | 63 |
1421838 | 1421838 | 2021-06-15 | Newton | Mississippi | 28101 | 2486 | 63 |
1405309 | 1405309 | 2021-06-10 | Richland | Louisiana | 22083 | 2486 | 56 |
1379786 | 1379786 | 2021-06-02 | Stone | Missouri | 29209 | 2486 | 47 |
1340053 | 1340053 | 2021-05-21 | Dickinson | Iowa | 19059 | 2486 | 44 |
1340320 | 1340320 | 2021-05-21 | Ohio | Kentucky | 21183 | 2486 | 55 |
1341591 | 1341591 | 2021-05-21 | Gurabo | Puerto Rico | 72063 | 2486 | |
1330393 | 1330393 | 2021-05-18 | Cherokee | Kansas | 20021 | 2486 | 52 |
1327146 | 1327146 | 2021-05-17 | Cherokee | Kansas | 20021 | 2486 | 52 |
1323900 | 1323900 | 2021-05-16 | Cherokee | Kansas | 20021 | 2486 | 52 |
1325384 | 1325384 | 2021-05-16 | Rio Grande | Puerto Rico | 72119 | 2486 | |
1320654 | 1320654 | 2021-05-15 | Cherokee | Kansas | 20021 | 2486 | 52 |
1317407 | 1317407 | 2021-05-14 | Cherokee | Kansas | 20021 | 2486 | 52 |
1310510 | 1310510 | 2021-05-12 | Pierce | Georgia | 13229 | 2486 | 57 |
1311609 | 1311609 | 2021-05-12 | Stoddard | Missouri | 29207 | 2486 | 37 |
1304656 | 1304656 | 2021-05-10 | Franklin | Louisiana | 22041 | 2486 | 106 |
1285269 | 1285269 | 2021-05-04 | Franklin | Massachusetts | 25011 | 2486 | 113 |
1287258 | 1287258 | 2021-05-04 | Waushara | Wisconsin | 55137 | 2486 | 37 |
1270929 | 1270929 | 2021-04-29 | Mingo | West Virginia | 54059 | 2486 | 39 |
1251364 | 1251364 | 2021-04-23 | Staunton city | Virginia | 51790 | 2486 | 68 |
1246820 | 1246820 | 2021-04-22 | Saunders | Nebraska | 31155 | 2486 | 16 |
1248011 | 1248011 | 2021-04-22 | Botetourt | Virginia | 51023 | 2486 | 36 |
1236490 | 1236490 | 2021-04-19 | Plaquemines | Louisiana | 22075 | 2486 | 26 |
1235072 | 1235072 | 2021-04-18 | Hopewell city | Virginia | 51670 | 2486 | 66 |
1226915 | 1226915 | 2021-04-16 | Wexford | Michigan | 26165 | 2486 | 34 |
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);