This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49669 | 49669 | 1930-11-08 | 5 | a | Hong Kong news/ Brother of the King of Thailand visits Hong Kong. Dr Chen Zhongyuan delivers speech on Confucianism in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099840 | 24099840 | |
49670 | 49670 | 1930-11-08 | 5 | b | Marriage system of the Miao minority in Yunnan province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099840 | 24099840 | |
49671 | 49671 | 1930-11-08 | 5 | c | Bandit chieftain arrested in Zhejiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099840 | 24099840 | |
49672 | 49672 | 1930-11-08 | 5 | d | Romance in Paris. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099840 | 24099840 | |
49673 | 49673 | 1930-11-08 | 5 | d | Monkey found in Huangpu. University students and their love letters. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099840 | 24099840 |
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]);