This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34854 | 34854 | 1919-09-06 | 2 | a-b | Second part of the editorial by Tung Wah Times expresses pessimism on the peace talks in China between the south and the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097852 | 24097852 | |
34855 | 34855 | 1919-09-06 | 2 | b-d | An article written by Zhen Zixiu says overseas Chinese should organise patriotic association to save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097852 | 24097852 | |
34857 | 34857 | 1919-09-06 | 2 | f | Chinese delegates to the Paris Peace Conference (Lu Zhengxiang, Wang Zhengting, Gu Weijun, Shi Zhaoji, Guo Bingwen, Xu Qian and Wang Zhaoming) write to Tang Shaoyi and urge to resume peace talks between the south and the north in China. | China | http://trove.nla.gov.au/newspaper/page/24097852 | 24097852 | |
34858 | 34858 | 1919-09-06 | 2 | f | Commercial chambers in China urge to resume peace talks between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24097852 | 24097852 |
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]);