This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33612 | 33612 | 1918-09-14 | 2 | a-b | Editorial by Tung Wah Times claims that China should study the benefits of mining. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097428 | 24097428 | |
33613 | 33613 | 1918-09-14 | 2 | c | Chinese President Feng Guozhang and his administration. | China | http://trove.nla.gov.au/newspaper/page/24097428 | 24097428 | |
33614 | 33614 | 1918-09-14 | 2 | d | Feng Guozhang will not seek the second term of Chinese presidency. | China | http://trove.nla.gov.au/newspaper/page/24097428 | 24097428 | |
33615 | 33615 | 1918-09-14 | 2 | d | New secretary-general of the Chinese cabinet and his new policy. | China | http://trove.nla.gov.au/newspaper/page/24097428 | 24097428 | |
33616 | 33616 | 1918-09-14 | 2 | d-f | Report from Beijing on China's dispatch of troops to the World War I and its effort to borrow more loans. | China | http://trove.nla.gov.au/newspaper/page/24097428 | 24097428 | |
33617 | 33617 | 1918-09-14 | 2 | f | Secret fighting between two factions in Sichuan (respectively under Sun Yatsen and Tang Jiyao) | China | http://trove.nla.gov.au/newspaper/page/24097428 | 24097428 |
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]);