pages
1 row where "date" is on date 2004-08-31 and page = 3
This data as json, CSV (advanced)
Link | body | date | text | page | path |
---|---|---|---|---|---|
OfficeoftheMayorAnnualRecessAgenda/2004-08-31.pdf,3 | OfficeoftheMayorAnnualRecessAgenda | 2004-08-31 | 2004-46 C.M.S. pdf 2 Subject: Market Analysis From: Community and Economic Development Agency Recommendation: Receive an informational report on the social compact proposal to develop a detailed market analysis on three neighborhoods in Oakland (AR2004-26) Item 2 8.31.04.pdf City Clerk and Clerk of the Council | 3 | OfficeoftheMayorAnnualRecessAgenda/2004-08-31.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]) );