This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40734 | 40734 | 1923-11-24 | 8 | a-d | Guangdong news/ Power struggle and military conflict in Guangdong. Yunnan army and the coming governor of Guangdong province. Report on battle in Dongjiang River area. Yang Ximin recalls troops from Beijiang River area. Troops and bandits are looting together in Taishan county. Pressgang in Zhaoqing and the tragedy. Troops occupy shops for temporary accommodation in Guangzhou. A passenger liner in hijacked on the way to Hong Kong. Shops in Shiqi town, of Xiangshan county, are closed and the owners are preparing for self-defence. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094630 | 24094630 | |
40735 | 40735 | 1923-11-24 | 8 | d | Farewell message by Lei Daotang, native of Taishan county, on his leaving Melbourne for hometown. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094630 | 24094630 | |
40736 | 40736 | 1923-11-24 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094630 | 24094630 | |
40737 | 40737 | 1923-11-24 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094630 | 24094630 |
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]);