pages
1 row where "date" is on date 2012-06-04 and page = 3
This data as json, CSV (advanced)
Link | body | date | text | page | path |
---|---|---|---|---|---|
OaklandCityCouncilandtheYouthAdvisoryCommission/2012-06-04.pdf,3 | OaklandCityCouncilandtheYouthAdvisoryCommission | 2012-06-04 | * Special Meeting of the Oakland Meeting Minutes June 4, 2012 City Council City Clerk and Clerk of the Council City of Oakland Page 3 Printed on 7/20/12 | 3 | OaklandCityCouncilandtheYouthAdvisoryCommission/2012-06-04.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]) );