pages
1 row where "date" is on date 2009-03-03 and page = 20
This data as json, CSV (advanced)
Link | body | date | text | page | path |
---|---|---|---|---|---|
OaklandRedevelopmentAgencyAndCityCouncil/2009-03-03.pdf,20 | OaklandRedevelopmentAgencyAndCityCouncil | 2009-03-03 | - Mirella Rangel - Troy Banner - Vincent Saephan - Sunnarose Noun - Susan Montauk - Bo Yee - Prentice Powell - Taffera Samuels - Vay Hoang - Carina Lieu - Howard Matis - Xiao Li - Sau Chin - Nicholas James - Garcia Christian - Zhong Wang - Yen Hsieh - Kim Miyoshi - Ade Mosley - Maua Black - Arneitra Robertson City of Oakland Page 20 Printed on 3/27/09 | 20 | OaklandRedevelopmentAgencyAndCityCouncil/2009-03-03.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]) );