ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where deaths = 70 and fips = 36045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1721009 | 1721009 | 2021-09-15 | Jefferson | New York | 36045 | 7158 | 70 |
1717761 | 1717761 | 2021-09-14 | Jefferson | New York | 36045 | 7137 | 70 |
1714513 | 1714513 | 2021-09-13 | Jefferson | New York | 36045 | 7118 | 70 |
1711267 | 1711267 | 2021-09-12 | Jefferson | New York | 36045 | 7085 | 70 |
1708020 | 1708020 | 2021-09-11 | Jefferson | New York | 36045 | 7042 | 70 |
1704773 | 1704773 | 2021-09-10 | Jefferson | New York | 36045 | 6984 | 70 |
1701523 | 1701523 | 2021-09-09 | Jefferson | New York | 36045 | 6945 | 70 |
1698274 | 1698274 | 2021-09-08 | Jefferson | New York | 36045 | 6899 | 70 |
1695026 | 1695026 | 2021-09-07 | Jefferson | New York | 36045 | 6872 | 70 |
1691778 | 1691778 | 2021-09-06 | Jefferson | New York | 36045 | 6856 | 70 |
1688528 | 1688528 | 2021-09-05 | Jefferson | New York | 36045 | 6809 | 70 |
1685278 | 1685278 | 2021-09-04 | Jefferson | New York | 36045 | 6793 | 70 |
1682027 | 1682027 | 2021-09-03 | Jefferson | New York | 36045 | 6761 | 70 |
1678778 | 1678778 | 2021-09-02 | Jefferson | New York | 36045 | 6724 | 70 |
1675530 | 1675530 | 2021-09-01 | Jefferson | New York | 36045 | 6698 | 70 |
1672283 | 1672283 | 2021-08-31 | Jefferson | New York | 36045 | 6671 | 70 |
1669035 | 1669035 | 2021-08-30 | Jefferson | New York | 36045 | 6646 | 70 |
1665788 | 1665788 | 2021-08-29 | Jefferson | New York | 36045 | 6629 | 70 |
1662540 | 1662540 | 2021-08-28 | Jefferson | New York | 36045 | 6611 | 70 |
1659292 | 1659292 | 2021-08-27 | Jefferson | New York | 36045 | 6580 | 70 |
1656043 | 1656043 | 2021-08-26 | Jefferson | New York | 36045 | 6549 | 70 |
1652796 | 1652796 | 2021-08-25 | Jefferson | New York | 36045 | 6524 | 70 |
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);