pages
1 row where "date" is on date 2010-04-01 and page = 5
This data as json, CSV (advanced)
Link | body | date | text | page | path |
---|---|---|---|---|---|
OaklandRedevelopmentAgencyAndCityCouncil/2010-04-01.pdf,5 | OaklandRedevelopmentAgencyAndCityCouncil | 2010-04-01 | - C.J. Hirshfield - Xavier Agustis Lynum - Amina Michell Scott - Ayinde Pendleton Webb - Sandra Noriega - Mustafa Lynum - Gema Pele - Dohee Lee - Herna Cruz-Louie - Jalyn Burns - Alexander Giovianni Snyder - Michael Fried - Carl Chan - Lily Yang - Tomye - Helen Stoltzfus - Jordan Eyre - Nina Toro Majid - Albert Greenberg - Ruben Guzman - Sharon Dolan - Denise Pate - Georgia Webb - La Mantia - Michael Sturtz - Michael Morgan - Lori Zook - Matheww Webb - Lejon Andre Loggins - Claudia Goodman-Hough - Debbie Koppman - Stuart Kandell - Margo Dunlap - Max Allstadt - Sanjiv Handa City of Oakland Page 5 Printed on 8/15/14 | 5 | OaklandRedevelopmentAgencyAndCityCouncil/2010-04-01.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]) );