This data as json, CSV (advanced)
Suggested facets: source, 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 | |
31903 | 31903 | 1917-01-20 | 2 | b-e | Eighth part of the diary written by Wu Guanyin on his service in the Chinese army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095555 | 24095555 | |
31904 | 31904 | 1917-01-20 | 2 | e-f | A letter from Kang Youwei to President Li Yuanhong and Premier Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24095555 | 24095555 |
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]);