This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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]);