pages
1 row where "date" is on date 2004-10-12 and page = 36
This data as json, CSV (advanced)
Link | body | date | text | page | path |
---|---|---|---|---|---|
FinanceAndManagementCommittee/2004-10-12.pdf,36 | FinanceAndManagementCommittee | 2004-10-12 | Attorney 5); Measurements on customer feedback (i.e. response time, problem resolution, and overall happiness of citizen's with regards to the resolution) should be included. 6) Attract New Residents to Oakland should also include | 36 | FinanceAndManagementCommittee/2004-10-12.pdf |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "pages" ( [body] TEXT, [date] TEXT, [text] TEXT, [page] INTEGER, [path] TEXT, PRIMARY KEY ([path], [page]) );