This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33498 | 33498 | 1918-08-10 | 2 | a-c | Editorial by Tung Wah Times worries about China's foreign loans. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097386 | 24097386 | |
33519 | 33519 | 1918-08-10 | 8 | a-c | Beijing news/ The budget report of Chinese government and the deficit. Chinese judicial authority outlines new challenge system. Chinese government seeks to borrow more loans from Japan. Zhang Zuolin on his plan to attack Guangdong. Zhao Hengti in Hunan defeats troops from the north. Zhang Huaizhi and Long Jiguang in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24097393 | 24097393 |
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]);