ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 6709 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2416739 | 2416739 | 2022-04-17 | Luna | New Mexico | 35029 | 6709 | 126 |
2413483 | 2413483 | 2022-04-16 | Luna | New Mexico | 35029 | 6709 | 126 |
2410227 | 2410227 | 2022-04-15 | Luna | New Mexico | 35029 | 6709 | 126 |
2406971 | 2406971 | 2022-04-14 | Luna | New Mexico | 35029 | 6709 | 125 |
2403715 | 2403715 | 2022-04-13 | Luna | New Mexico | 35029 | 6709 | 125 |
2349308 | 2349308 | 2022-03-27 | Hutchinson | Texas | 48233 | 6709 | 135 |
2346055 | 2346055 | 2022-03-26 | Hutchinson | Texas | 48233 | 6709 | 135 |
2292526 | 2292526 | 2022-03-10 | Clare | Michigan | 26035 | 6709 | 154 |
2289274 | 2289274 | 2022-03-09 | Clare | Michigan | 26035 | 6709 | 154 |
2258532 | 2258532 | 2022-02-27 | Russell | Virginia | 51167 | 6709 | 97 |
2255281 | 2255281 | 2022-02-26 | Russell | Virginia | 51167 | 6709 | 97 |
2252030 | 2252030 | 2022-02-25 | Russell | Virginia | 51167 | 6709 | 97 |
2194888 | 2194888 | 2022-02-08 | Union | Louisiana | 22111 | 6709 | 121 |
2127475 | 2127475 | 2022-01-18 | Fayette | Ohio | 39047 | 6709 | 87 |
2115044 | 2115044 | 2022-01-14 | Cherokee | Texas | 48073 | 6709 | 230 |
2104947 | 2104947 | 2022-01-11 | Snyder | Pennsylvania | 42109 | 6709 | 132 |
2028960 | 2028960 | 2021-12-19 | Perry | Kentucky | 21193 | 6709 | 128 |
2025709 | 2025709 | 2021-12-18 | Perry | Kentucky | 21193 | 6709 | 128 |
2022458 | 2022458 | 2021-12-17 | Perry | Kentucky | 21193 | 6709 | 128 |
2010362 | 2010362 | 2021-12-13 | Yadkin | North Carolina | 37197 | 6709 | 76 |
1972259 | 1972259 | 2021-12-01 | Wasatch | Utah | 49051 | 6709 | 29 |
1967683 | 1967683 | 2021-11-30 | Phelps | Missouri | 29161 | 6709 | 193 |
1959670 | 1959670 | 2021-11-28 | Bethel Census Area | Alaska | 2050 | 6709 | 27 |
1956419 | 1956419 | 2021-11-27 | Bethel Census Area | Alaska | 2050 | 6709 | 27 |
1953168 | 1953168 | 2021-11-26 | Bethel Census Area | Alaska | 2050 | 6709 | 27 |
1880123 | 1880123 | 2021-11-03 | Lyon | Nevada | 32019 | 6709 | 110 |
1876447 | 1876447 | 2021-11-02 | Douglas | Minnesota | 27041 | 6709 | 92 |
1859480 | 1859480 | 2021-10-28 | Effingham | Illinois | 17049 | 6709 | 111 |
1763807 | 1763807 | 2021-09-28 | Chesterfield | South Carolina | 45025 | 6709 | 130 |
1677448 | 1677448 | 2021-09-02 | Ware | Georgia | 13299 | 6709 | 200 |
1657384 | 1657384 | 2021-08-26 | Sauk | Wisconsin | 55111 | 6709 | 59 |
1648402 | 1648402 | 2021-08-24 | Dubois | Indiana | 18037 | 6709 | 120 |
1644167 | 1644167 | 2021-08-22 | Harrisonburg city | Virginia | 51660 | 6709 | 95 |
1640917 | 1640917 | 2021-08-21 | Harrisonburg city | Virginia | 51660 | 6709 | 95 |
1637667 | 1637667 | 2021-08-20 | Harrisonburg city | Virginia | 51660 | 6709 | 95 |
1613158 | 1613158 | 2021-08-13 | Cecil | Maryland | 24015 | 6709 | 161 |
1614679 | 1614679 | 2021-08-13 | Henderson | Texas | 48213 | 6709 | 205 |
1611430 | 1611430 | 2021-08-12 | Henderson | Texas | 48213 | 6709 | 203 |
1608182 | 1608182 | 2021-08-11 | Henderson | Texas | 48213 | 6709 | 204 |
1604933 | 1604933 | 2021-08-10 | Henderson | Texas | 48213 | 6709 | 204 |
1585432 | 1585432 | 2021-08-04 | Hardin | Texas | 48199 | 6709 | 119 |
1555238 | 1555238 | 2021-07-26 | Carson City | Nevada | 32510 | 6709 | 125 |
1510568 | 1510568 | 2021-07-12 | Gibson | Tennessee | 47053 | 6709 | 150 |
1506661 | 1506661 | 2021-07-11 | Sullivan | New York | 36105 | 6709 | 76 |
1461850 | 1461850 | 2021-06-27 | Bedford | Tennessee | 47003 | 6709 | 131 |
1458605 | 1458605 | 2021-06-26 | Bedford | Tennessee | 47003 | 6709 | 131 |
1455360 | 1455360 | 2021-06-25 | Bedford | Tennessee | 47003 | 6709 | 131 |
1331487 | 1331487 | 2021-05-18 | Wilkes | North Carolina | 37193 | 6709 | 113 |
1300977 | 1300977 | 2021-05-09 | Boone | Indiana | 18011 | 6709 | 105 |
1214420 | 1214420 | 2021-04-12 | Eddy | New Mexico | 35015 | 6709 | 125 |
1091524 | 1091524 | 2021-03-05 | Somerset | Pennsylvania | 42111 | 6709 | 186 |
1078665 | 1078665 | 2021-03-01 | Kershaw | South Carolina | 45055 | 6709 | 123 |
1011217 | 1011217 | 2021-02-08 | Wood | West Virginia | 54107 | 6709 | 122 |
995267 | 995267 | 2021-02-04 | White | Arkansas | 5145 | 6709 | 94 |
935673 | 935673 | 2021-01-16 | Umatilla | Oregon | 41059 | 6709 | 68 |
888041 | 888041 | 2021-01-02 | St. Clair | Alabama | 1115 | 6709 | 73 |
878867 | 878867 | 2020-12-30 | DeKalb | Illinois | 17037 | 6709 | 77 |
844427 | 844427 | 2020-12-19 | Niagara | New York | 36063 | 6709 | 153 |
818855 | 818855 | 2020-12-11 | Cambria | Pennsylvania | 42021 | 6709 | 133 |
808007 | 808007 | 2020-12-08 | Rapides | Louisiana | 22079 | 6709 | 196 |
805124 | 805124 | 2020-12-07 | Cole | Missouri | 29051 | 6709 | 67 |
778376 | 778376 | 2020-11-29 | Hendricks | Indiana | 18063 | 6709 | 175 |
727707 | 727707 | 2020-11-13 | Union | North Carolina | 37179 | 6709 | 67 |
702946 | 702946 | 2020-11-05 | Kenosha | Wisconsin | 55059 | 6709 | 96 |
656287 | 656287 | 2020-10-22 | Cumberland | North Carolina | 37051 | 6709 | 91 |
157865 | 157865 | 2020-05-19 | Lake | Illinois | 17097 | 6709 | 221 |
131315 | 131315 | 2020-05-10 | Jefferson | Louisiana | 22051 | 6709 | 397 |
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);