pages
1 row where "date" is on date 2005-09-20 and page = 80
This data as json, CSV (advanced)
Link | body | date | text | page | path |
---|---|---|---|---|---|
OaklandCityCouncil/2005-09-20.pdf,80 | OaklandCityCouncil | 2005-09-20 | ORA\Councilmember Ayes: 8 - Vice Mayor Brunner, Councilmember Nadel, Councilmember Kernighan, Councilmember Quan, President of the Council De La Fuente, Councilmember Brooks, Councilmember Reid and Councilmember Chang Upon the reading of Item 14.3 by the City Clerk, the Public Hearing was opened 7:36 PM | 80 | OaklandCityCouncil/2005-09-20.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]) );