This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31590 | 31590 | 1916-09-23 | 3 | a | Rumours say a new cabinet to be organised in China under Xu Shichang. | China | http://trove.nla.gov.au/newspaper/page/24095413 | 24095413 | |
31591 | 31591 | 1916-09-23 | 3 | a-b | The secret alliance of military governors of nine provinces in China. | China | http://trove.nla.gov.au/newspaper/page/24095413 | 24095413 | |
31592 | 31592 | 1916-09-23 | 3 | b-d | Second part of collection of circular telegrams on the fighting between Long Jiguang and Li Liejun in Guangdong (of Ni Sichong, Zhang Huaizhi and Sun Faxu, Meng Siyuan, Yang Shande, and others). | China | http://trove.nla.gov.au/newspaper/page/24095413 | 24095413 | |
31593 | 31593 | 1916-09-23 | 3 | d-e | Yuan Shikai selects no successor to himself. | China | http://trove.nla.gov.au/newspaper/page/24095413 | 24095413 | |
31594 | 31594 | 1916-09-23 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095413 | 24095413 |
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]);