ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where deaths = 125 and fips = 1017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1624948 | 1624948 | 2021-08-17 | Chambers | Alabama | 1017 | 4322 | 125 |
1621701 | 1621701 | 2021-08-16 | Chambers | Alabama | 1017 | 4284 | 125 |
1618453 | 1618453 | 2021-08-15 | Chambers | Alabama | 1017 | 4263 | 125 |
1615205 | 1615205 | 2021-08-14 | Chambers | Alabama | 1017 | 4225 | 125 |
1611956 | 1611956 | 2021-08-13 | Chambers | Alabama | 1017 | 4225 | 125 |
1608709 | 1608709 | 2021-08-12 | Chambers | Alabama | 1017 | 4209 | 125 |
1605460 | 1605460 | 2021-08-11 | Chambers | Alabama | 1017 | 4181 | 125 |
1602210 | 1602210 | 2021-08-10 | Chambers | Alabama | 1017 | 4151 | 125 |
1598962 | 1598962 | 2021-08-09 | Chambers | Alabama | 1017 | 4119 | 125 |
1595713 | 1595713 | 2021-08-08 | Chambers | Alabama | 1017 | 4088 | 125 |
1592464 | 1592464 | 2021-08-07 | Chambers | Alabama | 1017 | 4088 | 125 |
1589215 | 1589215 | 2021-08-06 | Chambers | Alabama | 1017 | 4058 | 125 |
1585966 | 1585966 | 2021-08-05 | Chambers | Alabama | 1017 | 4033 | 125 |
1582716 | 1582716 | 2021-08-04 | Chambers | Alabama | 1017 | 4007 | 125 |
1579466 | 1579466 | 2021-08-03 | Chambers | Alabama | 1017 | 3987 | 125 |
1576218 | 1576218 | 2021-08-02 | Chambers | Alabama | 1017 | 3968 | 125 |
1572970 | 1572970 | 2021-08-01 | Chambers | Alabama | 1017 | 3949 | 125 |
1569722 | 1569722 | 2021-07-31 | Chambers | Alabama | 1017 | 3936 | 125 |
1566474 | 1566474 | 2021-07-30 | Chambers | Alabama | 1017 | 3915 | 125 |
1563226 | 1563226 | 2021-07-29 | Chambers | Alabama | 1017 | 3915 | 125 |
1559978 | 1559978 | 2021-07-28 | Chambers | Alabama | 1017 | 3898 | 125 |
1556731 | 1556731 | 2021-07-27 | Chambers | Alabama | 1017 | 3880 | 125 |
1553484 | 1553484 | 2021-07-26 | Chambers | Alabama | 1017 | 3857 | 125 |
1550237 | 1550237 | 2021-07-25 | Chambers | Alabama | 1017 | 3852 | 125 |
1546990 | 1546990 | 2021-07-24 | Chambers | Alabama | 1017 | 3842 | 125 |
1543743 | 1543743 | 2021-07-23 | Chambers | Alabama | 1017 | 3829 | 125 |
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);