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