This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31725 | 31725 | 1916-11-11 | 6 | a-b | Collection of telegrams (Secret telegram by President Li Yuanhong for possible restorationist activities, military governors of Hunan, Yunnan, Zhejiang, Sichuan and Guangxi against Zhang Xun, circular telegram issued by Zhang Zuolin on the worship to Confucius). | China | http://trove.nla.gov.au/newspaper/page/24095474 | 24095474 | |
31726 | 31726 | 1916-11-11 | 6 | b-c | Sun Yatsen is organising a republic in south China and the report. | China | http://trove.nla.gov.au/newspaper/page/24095474 | 24095474 | |
31727 | 31727 | 1916-11-11 | 6 | c | Poems by by Zeng Sugang farewell Gui Zhi, Chinese Consul-General in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095474 | 24095474 |
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]);