ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where county = "Delaware", deaths = 137 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1542568 | 1542568 | 2021-07-22 | Delaware | Ohio | 39041 | 19077 | 137 |
1539320 | 1539320 | 2021-07-21 | Delaware | Ohio | 39041 | 19054 | 137 |
1536073 | 1536073 | 2021-07-20 | Delaware | Ohio | 39041 | 19028 | 137 |
1532825 | 1532825 | 2021-07-19 | Delaware | Ohio | 39041 | 19019 | 137 |
1529578 | 1529578 | 2021-07-18 | Delaware | Ohio | 39041 | 19013 | 137 |
1526331 | 1526331 | 2021-07-17 | Delaware | Ohio | 39041 | 19010 | 137 |
1523084 | 1523084 | 2021-07-16 | Delaware | Ohio | 39041 | 19006 | 137 |
1519836 | 1519836 | 2021-07-15 | Delaware | Ohio | 39041 | 19003 | 137 |
1516588 | 1516588 | 2021-07-14 | Delaware | Ohio | 39041 | 18992 | 137 |
1513341 | 1513341 | 2021-07-13 | Delaware | Ohio | 39041 | 18980 | 137 |
1510095 | 1510095 | 2021-07-12 | Delaware | Ohio | 39041 | 18971 | 137 |
1506848 | 1506848 | 2021-07-11 | Delaware | Ohio | 39041 | 18965 | 137 |
1503602 | 1503602 | 2021-07-10 | Delaware | Ohio | 39041 | 18963 | 137 |
1500356 | 1500356 | 2021-07-09 | Delaware | Ohio | 39041 | 18956 | 137 |
1497110 | 1497110 | 2021-07-08 | Delaware | Ohio | 39041 | 18952 | 137 |
1493863 | 1493863 | 2021-07-07 | Delaware | Ohio | 39041 | 18943 | 137 |
1490616 | 1490616 | 2021-07-06 | Delaware | Ohio | 39041 | 18938 | 137 |
1487369 | 1487369 | 2021-07-05 | Delaware | Ohio | 39041 | 18935 | 137 |
1484122 | 1484122 | 2021-07-04 | Delaware | Ohio | 39041 | 18926 | 137 |
1480876 | 1480876 | 2021-07-03 | Delaware | Ohio | 39041 | 18926 | 137 |
1477629 | 1477629 | 2021-07-02 | Delaware | Ohio | 39041 | 18924 | 137 |
1474383 | 1474383 | 2021-07-01 | Delaware | Ohio | 39041 | 18923 | 137 |
1471137 | 1471137 | 2021-06-30 | Delaware | Ohio | 39041 | 18920 | 137 |
1467892 | 1467892 | 2021-06-29 | Delaware | Ohio | 39041 | 18916 | 137 |
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);