pages
1 row where "date" is on date 2004-07-06 and text = "Phone: (510) 238-7370 Fax: (510)238-6699 Recorded Agenda: (510)238-2386 Telecommunications Display Device: (510) 839-6451 (TDD) THE HANGING OF BANNERS, POSTERS, SIGNS, OR ANY MATERIAL ON OR OVER THE GALLERY BANNISTERS IS STRICTLY PROHIBITED IN ORDER TO ENSURE THE SAFETY OF THOSE ATTENDING MEETINGS. (...)"
This data as json, CSV (advanced)
text 1 ✖
- Phone: (510) 238-7370 Fax: (510)238-6699 Recorded Agenda: (510)238-2386 Telecommunications Display Device: (510) 839-6451 (TDD) THE HANGING OF BANNERS, POSTERS, SIGNS, OR ANY MATERIAL ON OR OVER THE GALLERY BANNISTERS IS STRICTLY PROHIBITED IN ORDER TO ENSURE THE SAFETY OF THOSE ATTENDING MEETINGS. (...) · 1 ✖
Link | body | date | text | page | path |
---|---|---|---|---|---|
OaklandCityCouncil/2004-07-06.pdf,234 | OaklandCityCouncil | 2004-07-06 | Phone: (510) 238-7370 Fax: (510)238-6699 Recorded Agenda: (510)238-2386 Telecommunications Display Device: (510) 839-6451 (TDD) THE HANGING OF BANNERS, POSTERS, SIGNS, OR ANY MATERIAL ON OR OVER THE GALLERY BANNISTERS IS STRICTLY PROHIBITED IN ORDER TO ENSURE THE SAFETY OF THOSE ATTENDING MEETINGS. (...) | 234 | OaklandCityCouncil/2004-07-06.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]) );