This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27512 | 27512 | 1913-06-28 | 2 | c | A circular telegram jointly issued by seven provincial governors in China (Zhang Fengxiang, Yan Xishan, Feng Guozhang, Zhang Xiluan, Zhou Ziqi, Zhang Zhenfang, Zhang Binghua, Ma Anliang and Zhang Xingzhi) to suppress rebellions Huang Xing, Li Liejun and Hu Hanmin. | China | http://trove.nla.gov.au/newspaper/page/24092729 | 24092729 | |
27538 | 27538 | 1913-06-28 | 8 | c | Poems by Yi Shunding, Gu Yuan and Zheng Yuan. | China | http://trove.nla.gov.au/newspaper/page/24092735 | 24092735 |
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]);