This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31902 | 31902 | 1917-01-20 | 2 | a-b | Second and final part of an article written by Zhou Guozheng suggests that overseas Chinese should return to do business in China in order to help the people and the nation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095555 | 24095555 | |
31912 | 31912 | 1917-01-20 | 6 | a-b | Beijing news/ The last words of Cai E. China borrows more money from Britain. Li Liejun arrives in Shanghai. Japanese police occupy Hutou Mountain in Xiamen, of Fujian province. Army in Shaanxi province are against the local government. | China | http://trove.nla.gov.au/newspaper/page/24095559 | 24095559 | |
31915 | 31915 | 1917-01-20 | 7 | a-b | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095558 | 24095558 |
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]);