This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47442 | 47442 | 1928-09-22 | 5 | a | Notice issued by the Special Committee of the Chinese Chamber of Commerce in NSW for the National Day celebration and the birthday celebration for Confucius. Photographs of the Special Committee members: catering and welfare supervisor Zhu Hechou (Albert Hing) and Cai Tian (Chas Tein). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098955 | 24098955 | |
47443 | 47443 | 1928-09-22 | 5 | a | People from Zengcheng county flee to Hong Kong. A case of swindling at the Bank of Guangdong. Ma Yushan's company is joined by others. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098955 | 24098955 |
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]);