ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 9957 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Tennessee 4
- North Dakota 3
- Vermont 3
- Virginia 3
- California 2
- North Carolina 2
- Texas 2
- Wisconsin 2
- Alabama 1
- Georgia 1
- Hawaii 1
- Illinois 1
- Kentucky 1
- Mississippi 1
- Montana 1
- New Jersey 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395043 | 2395043 | 2022-04-10 | Washington | Vermont | 50023 | 9957 | 47 |
2391787 | 2391787 | 2022-04-09 | Washington | Vermont | 50023 | 9957 | 47 |
2388531 | 2388531 | 2022-04-08 | Washington | Vermont | 50023 | 9957 | 47 |
2338794 | 2338794 | 2022-03-24 | Scotland | North Carolina | 37165 | 9957 | 126 |
2271550 | 2271550 | 2022-03-03 | Tazewell | Virginia | 51185 | 9957 | 157 |
2245548 | 2245548 | 2022-02-23 | Wise | Virginia | 51195 | 9957 | 176 |
1975334 | 1975334 | 2021-12-02 | Henderson | Texas | 48213 | 9957 | 350 |
1878904 | 1878904 | 2021-11-03 | Maui | Hawaii | 15009 | 9957 | 94 |
1790625 | 1790625 | 2021-10-07 | Blount | Alabama | 1009 | 9957 | 167 |
1725578 | 1725578 | 2021-09-16 | Manitowoc | Wisconsin | 55071 | 9957 | 99 |
1607096 | 1607096 | 2021-08-11 | Missoula | Montana | 30063 | 9957 | 103 |
1487740 | 1487740 | 2021-07-05 | Oconee | South Carolina | 45073 | 9957 | 139 |
1461922 | 1461922 | 2021-06-27 | Robertson | Tennessee | 47147 | 9957 | 141 |
1458677 | 1458677 | 2021-06-26 | Robertson | Tennessee | 47147 | 9957 | 141 |
1455432 | 1455432 | 2021-06-25 | Robertson | Tennessee | 47147 | 9957 | 141 |
1452187 | 1452187 | 2021-06-24 | Robertson | Tennessee | 47147 | 9957 | 140 |
1448396 | 1448396 | 2021-06-23 | Ward | North Dakota | 38101 | 9957 | 200 |
1445151 | 1445151 | 2021-06-22 | Ward | North Dakota | 38101 | 9957 | 200 |
1440899 | 1440899 | 2021-06-21 | Hardin | Kentucky | 21093 | 9957 | 167 |
1428921 | 1428921 | 2021-06-17 | Ward | North Dakota | 38101 | 9957 | 199 |
1398350 | 1398350 | 2021-06-08 | Vermilion | Illinois | 17183 | 9957 | 156 |
1372161 | 1372161 | 2021-05-31 | Jackson | Georgia | 13157 | 9957 | 146 |
1230296 | 1230296 | 2021-04-17 | Madison | Mississippi | 28089 | 9957 | 212 |
816508 | 816508 | 2020-12-10 | Fond du Lac | Wisconsin | 55039 | 9957 | 63 |
803306 | 803306 | 2020-12-06 | Chesterfield | Virginia | 51041 | 9957 | 135 |
721162 | 721162 | 2020-11-11 | Durham | North Carolina | 37063 | 9957 | 105 |
687022 | 687022 | 2020-11-01 | Santa Barbara | California | 6083 | 9957 | 128 |
449986 | 449986 | 2020-08-19 | Webb | Texas | 48479 | 9957 | 212 |
427983 | 427983 | 2020-08-13 | Imperial | California | 6025 | 9957 | 256 |
371641 | 371641 | 2020-07-26 | Monmouth | New Jersey | 34025 | 9957 | 854 |
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);