ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 9698 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- South Carolina 7
- Texas 2
- Alabama 1
- California 1
- Georgia 1
- Idaho 1
- Indiana 1
- Kentucky 1
- Montana 1
- New Hampshire 1
- New York 1
- Pennsylvania 1
- Utah 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2420600 | 2420600 | 2022-04-18 | Dillon | South Carolina | 45033 | 9698 | 143 |
2417344 | 2417344 | 2022-04-17 | Dillon | South Carolina | 45033 | 9698 | 143 |
2414088 | 2414088 | 2022-04-16 | Dillon | South Carolina | 45033 | 9698 | 143 |
2410832 | 2410832 | 2022-04-15 | Dillon | South Carolina | 45033 | 9698 | 143 |
2407576 | 2407576 | 2022-04-14 | Dillon | South Carolina | 45033 | 9698 | 143 |
2404320 | 2404320 | 2022-04-13 | Dillon | South Carolina | 45033 | 9698 | 143 |
2401065 | 2401065 | 2022-04-12 | Dillon | South Carolina | 45033 | 9698 | 143 |
2186281 | 2186281 | 2022-02-05 | Wayne | Pennsylvania | 42127 | 9698 | 154 |
2095673 | 2095673 | 2022-01-08 | Navarro | Texas | 48349 | 9698 | 196 |
1929983 | 1929983 | 2021-11-18 | Iron | Utah | 49021 | 9698 | 59 |
1901294 | 1901294 | 2021-11-10 | Humboldt | California | 6023 | 9698 | 117 |
1741776 | 1741776 | 2021-09-21 | Raleigh | West Virginia | 54081 | 9698 | 130 |
1498315 | 1498315 | 2021-07-09 | Lauderdale | Alabama | 1077 | 9698 | 252 |
1493568 | 1493568 | 2021-07-07 | Merrimack | New Hampshire | 33013 | 9698 | 116 |
1410486 | 1410486 | 2021-06-11 | Whatcom | Washington | 53073 | 9698 | 99 |
1382027 | 1382027 | 2021-06-03 | Twin Falls | Idaho | 16083 | 9698 | 129 |
1070763 | 1070763 | 2021-02-27 | Daviess | Kentucky | 21059 | 9698 | 159 |
1048910 | 1048910 | 2021-02-20 | Ulster | New York | 36111 | 9698 | 226 |
948028 | 948028 | 2021-01-20 | Flathead | Montana | 30029 | 9698 | 60 |
904961 | 904961 | 2021-01-07 | Madison | Indiana | 18095 | 9698 | 213 |
900889 | 900889 | 2021-01-05 | Eau Claire | Wisconsin | 55035 | 9698 | 90 |
878673 | 878673 | 2020-12-30 | Columbia | Georgia | 13073 | 9698 | 98 |
676685 | 676685 | 2020-10-28 | Williamson | Texas | 48491 | 9698 | 154 |
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);