This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34387 | 34387 | 1919-04-19 | 2 | c-d | Negotiation between China and Japan on the loans for railway construction. | China | http://trove.nla.gov.au/newspaper/page/24097686 | 24097686 | |
34394 | 34394 | 1919-04-19 | 3 | c-d | Circular telegrams issued by Zhang Qian, Xu Ying, Liu Renxi and others for China's rights at the Paris Peace Conference. | China | http://trove.nla.gov.au/newspaper/page/24097685 | 24097685 | |
34411 | 34411 | 1919-04-19 | 8 | c-d | Guangdong news/ Zhan Tianyou and others ask for protection of the Confucian temple. Telegram from the central government in Beijing on the continuing deportation of German nationals. Mo Rongxin is still in the office. British consul in Guangzhou asks for protection of oil transportation ships. | China | http://trove.nla.gov.au/newspaper/page/24097692 | 24097692 |
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]);