This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40149 | 40149 | 1923-07-21 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094486 | 24094486 | |
40150 | 40150 | 1923-07-21 | 8 | a-d | Guangdong news/ Provincial authority retrieves gold bonds. Guangdong army arrive Shantou and the report. Army movement in Zengcheng and Panyu. A newspaper reporter is pressed into service. Chinese priest in Zengcheng county Wang Qingdu and his 10-year-old son are kidnapped by bandits for ransom. A female robber in Guangzhou. Guangzhou authority confiscates temple property. Wu Peifu's envoy arrives Huizhou. Sun Yatsen reports from the front line. Yunnan army moves from Beijiang to Dongjiang area. Guangdong army have taken over Huizhou. Zhong Xifen is detained. Theatre is robbed and some audience are killed in the battle. Sun Yatsen removes Wen Shude from his naval commander position. Sun Yatsen borrows foreign loans. More disaster of war in Zhaoqing. Battle report from Guangdong army in Boluo and Shenzhen. Homicide in an opium den in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094486 | 24094486 | |
40151 | 40151 | 1923-07-21 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094486 | 24094486 | |
40152 | 40152 | 1923-07-21 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094486 | 24094486 |
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]);