pages
1 row where "date" is on date 2005-01-25 and text = "on the meetings from this week, include any Peer Review Reports and any letters from the City to the contractor directing them to address any outstanding issues regarding compliance."
This data as json, CSV (advanced)
Link | body | date | text | page | path |
---|---|---|---|---|---|
PublicWorksCommittee/2005-01-25.pdf,5 | PublicWorksCommittee | 2005-01-25 | on the meetings from this week, include any Peer Review Reports and any letters from the City to the contractor directing them to address any outstanding issues regarding compliance. | 5 | PublicWorksCommittee/2005-01-25.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]) );