This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44966 | 44966 | 1926-07-17 | 8 | a-d | Guangdong news/ A meeting of four commercial chambers in Guangzhou. Guangzhou government and the local county authorities. Court hearing on the assassination of Liao Zhongkai. The strike and the police in Guangzhou. News from Xiangshan county. | China | http://trove.nla.gov.au/newspaper/page/24101638 | 24101638 | |
44967 | 44967 | 1926-07-17 | 8 | c | A notice by The Sun company in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101638 | 24101638 | |
44968 | 44968 | 1926-07-17 | 8 | d | A notice by the Young Chinese Association of Australia (li zhi hui) in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101638 | 24101638 |
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]);