pages
1 row where "date" is on date 2004-05-18 and text = "Jean Quan, Dist. 4; Desley Brooks, Dist. 6; Larry Reid, Dist. 7; Vice Mayor Henry Chang, At-Large, and President Ignacio De La Fuente, Dist. 5 ORA\Councilmember Excused: 1 - President of the Council De La Fuente ORA\Councilmember Present: 7 - Councilmember Nadel, Councilmember Brunner, Councilmember Wan, Councilmember Quan, Councilmember Brooks, Councilmember Reid and Vice Mayor Chang 3 Open Forum / Citizens Comments (Time Available: 15 minutes) The following individuals spoke under Open Forum: - Sanjiv Handa - Delores Allen - Dorothy Coleman - John Grace 4"
This data as json, CSV (advanced)
text 1 ✖
- Jean Quan, Dist. 4; Desley Brooks, Dist. 6; Larry Reid, Dist. 7; Vice Mayor Henry Chang, At-Large, and President Ignacio De La Fuente, Dist. 5 ORA\Councilmember Excused: 1 - President of the Council De La Fuente ORA\Councilmember Present: 7 - Councilmember Nadel, Councilmember Brunner, Councilmember Wan, Councilmember Quan, Councilmember Brooks, Councilmember Reid and Vice Mayor Chang 3 Open Forum / Citizens Comments (Time Available: 15 minutes) The following individuals spoke under Open Forum: - Sanjiv Handa - Delores Allen - Dorothy Coleman - John Grace 4 · 1 ✖
Link | body | date | text | page | path |
---|---|---|---|---|---|
OaklandCityCouncil/2004-05-18.pdf,2 | OaklandCityCouncil | 2004-05-18 | Jean Quan, Dist. 4; Desley Brooks, Dist. 6; Larry Reid, Dist. 7; Vice Mayor Henry Chang, At-Large, and President Ignacio De La Fuente, Dist. 5 ORA\Councilmember Excused: 1 - President of the Council De La Fuente ORA\Councilmember Present: 7 - Councilmember Nadel, Councilmember Brunner, Councilmember Wan, Councilmember Quan, Councilmember Brooks, Councilmember Reid and Vice Mayor Chang 3 Open Forum / Citizens Comments (Time Available: 15 minutes) The following individuals spoke under Open Forum: - Sanjiv Handa - Delores Allen - Dorothy Coleman - John Grace 4 | 2 | OaklandCityCouncil/2004-05-18.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]) );