This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5841 | 5841 | 1900-08-15 | 2 | c-d | A report to Rong Lu and zongli yamen from local governors supporting efforts to supress bandits. Governors include Li Bingheng, Liu Kunyi, Zhang Zhidong, Lu Chuanlin, Wang Zhichun, Yu Yinlin, and Yu Liansan. | China | http://trove.nla.gov.au/newspaper/page/24102908 | 24102908 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] ( [date] TEXT, [page] TEXT, [column] TEXT, [title] TEXT, [description] TEXT, [source] TEXT, [page_url] TEXT, [trove_id] TEXT ); CREATE INDEX [idx_article_index_date] ON [article_index] ([date]);