This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40698 | 40698 | 1923-11-17 | 8 | a-d | Guangdong news/ Rumour says Xu Chongzhi might be new governor of Guangdong. Some private properties in Guangzhou are auctioned as public property. Lu Chunrong leads his army to take over Yangjiang county. Yunnan army demand return of weapons from Zhou Zhizheng. Guangdong army take over Heyuan county. Deng Benyin takes over Anpu. A foreign consul in Guangzhou refuses to recognise the National Party flag. Mo Xiong and Liang Ruogu's army in Shilong and their looting. A visit to Songlong town, of Gaoyao county. Public property for sale in Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094622 | 24094622 | |
40699 | 40699 | 1923-11-17 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094622 | 24094622 | |
40700 | 40700 | 1923-11-17 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094622 | 24094622 |
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]);