ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 100, fips = 39039 and state = "Ohio" 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 |
---|---|---|---|---|---|---|---|
1737469 | 1737469 | 2021-09-20 | Defiance | Ohio | 39039 | 5396 | 100 |
1734219 | 1734219 | 2021-09-19 | Defiance | Ohio | 39039 | 5387 | 100 |
1730969 | 1730969 | 2021-09-18 | Defiance | Ohio | 39039 | 5361 | 100 |
1727719 | 1727719 | 2021-09-17 | Defiance | Ohio | 39039 | 5337 | 100 |
1724470 | 1724470 | 2021-09-16 | Defiance | Ohio | 39039 | 5304 | 100 |
1721221 | 1721221 | 2021-09-15 | Defiance | Ohio | 39039 | 5278 | 100 |
1717973 | 1717973 | 2021-09-14 | Defiance | Ohio | 39039 | 5242 | 100 |
1714725 | 1714725 | 2021-09-13 | Defiance | Ohio | 39039 | 5209 | 100 |
1711479 | 1711479 | 2021-09-12 | Defiance | Ohio | 39039 | 5199 | 100 |
1708232 | 1708232 | 2021-09-11 | Defiance | Ohio | 39039 | 5188 | 100 |
1704985 | 1704985 | 2021-09-10 | Defiance | Ohio | 39039 | 5171 | 100 |
1701735 | 1701735 | 2021-09-09 | Defiance | Ohio | 39039 | 5124 | 100 |
1698486 | 1698486 | 2021-09-08 | Defiance | Ohio | 39039 | 5085 | 100 |
1695238 | 1695238 | 2021-09-07 | Defiance | Ohio | 39039 | 5047 | 100 |
1691990 | 1691990 | 2021-09-06 | Defiance | Ohio | 39039 | 5038 | 100 |
1688741 | 1688741 | 2021-09-05 | Defiance | Ohio | 39039 | 5011 | 100 |
1685491 | 1685491 | 2021-09-04 | Defiance | Ohio | 39039 | 4988 | 100 |
1682240 | 1682240 | 2021-09-03 | Defiance | Ohio | 39039 | 4961 | 100 |
1678990 | 1678990 | 2021-09-02 | Defiance | Ohio | 39039 | 4926 | 100 |
1675742 | 1675742 | 2021-09-01 | Defiance | Ohio | 39039 | 4885 | 100 |
1672495 | 1672495 | 2021-08-31 | Defiance | Ohio | 39039 | 4851 | 100 |
1669247 | 1669247 | 2021-08-30 | Defiance | Ohio | 39039 | 4824 | 100 |
1666000 | 1666000 | 2021-08-29 | Defiance | Ohio | 39039 | 4814 | 100 |
1662752 | 1662752 | 2021-08-28 | Defiance | Ohio | 39039 | 4795 | 100 |
1659504 | 1659504 | 2021-08-27 | Defiance | Ohio | 39039 | 4782 | 100 |
1656255 | 1656255 | 2021-08-26 | Defiance | Ohio | 39039 | 4761 | 100 |
1653008 | 1653008 | 2021-08-25 | Defiance | Ohio | 39039 | 4737 | 100 |
1649761 | 1649761 | 2021-08-24 | Defiance | Ohio | 39039 | 4728 | 100 |
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);