pages
1 row where "date" is on date 2013-02-12 and page = 4
This data as json, CSV (advanced)
Link | body | date | page | text | path |
---|---|---|---|---|---|
GolfCommission/2013-02-12.pdf,4 | GolfCommission | 2013-02-12 | 4 | The agenda for the meeting was posted seven days in advance in compliance with the Alameda Sunshine Ordinance, which also complies with the 72-hour requirement of the Brown Act. 4 Golf Commission Minutes - Tuesday, February 12, 2013 | GolfCommission/2013-02-12.pdf |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "pages" ( [body] TEXT, [date] TEXT, [page] INTEGER, [text] TEXT, [path] TEXT, PRIMARY KEY ([path], [page]) );