This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42001 | 42001 | 1924-08-23 | 8 | a-d | Guangdong news/ Guangzhou businessmen visit their counterparts in Nanhai county. Yunnan army leaves Guangdong. Zhang Fulai and his army arrive Guangdong. Zhu Hegeng and Li Hun on peace talks. United army take back Kaiping county. A meeting at the Headquarters of Sun Yatsen. Hunan army occupy the cement factory in Guangzhou. Recent strange talks by Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100839 | 24100839 | |
42002 | 42002 | 1924-08-23 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100839 | 24100839 | |
42003 | 42003 | 1924-08-23 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100839 | 24100839 |
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]);