This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41736 | 41736 | 1924-06-28 | 2 | a-b | Editorial on the current Guangdong government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100769 | 24100769 | |
41750 | 41750 | 1924-06-28 | 6 | a-b | Tung Wah Times comments on the united self-defence of villagers in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100773 | 24100773 | |
41751 | 41751 | 1924-06-28 | 6 | b-c | Kang Youwei issues a circular telegram on the case of Gold Franc. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100773 | 24100773 | |
41752 | 41752 | 1924-06-28 | 6 | d | Tang Zhanrong issues a circular telegram to attack Shen Hongying. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100773 | 24100773 | |
41754 | 41754 | 1924-06-28 | 7 | a | Tang Longxiang publishes an argument on the order issued by Guangdong government to capture him. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100772 | 24100772 | |
41755 | 41755 | 1924-06-28 | 7 | a-b | Chinese businessman Zhao Qisheng, of New Castle, denies his involvement in the Nationalist Party. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100772 | 24100772 | |
41756 | 41756 | 1924-06-28 | 7 | b | Nine illegal Chinese immigrants are penalised in Adelaide. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100772 | 24100772 | |
41757 | 41757 | 1924-06-28 | 7 | c | A woman is robbed in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100772 | 24100772 | |
41758 | 41758 | 1924-06-28 | 7 | c | Fighting in a Sydney hotel. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100772 | 24100772 | |
41760 | 41760 | 1924-06-28 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100772 | 24100772 | |
41761 | 41761 | 1924-06-28 | 8 | a-d | Guangdong news/ Businessmen in Guangzhou request the government to give up their monopoly over some properties for ever. Yang Shukan is leaving Guangdong. Guangzhou businessmen send telegram to Chen Jiongming. Sun Yatsen complains his army commanders. United army asks for help from the Dongjiang area. Yunnan military officers have emergency meeting day and night. Villagers in Nanhai and Shunde county and their united self-defence. More troops are moving out to the suburbs of Guangzhou. Panic in Guangzhou. Market are closed in Guangzhou. Herbalist shops in Foshan are closed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100775 | 24100775 | |
41762 | 41762 | 1924-06-28 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100775 | 24100775 | |
41763 | 41763 | 1924-06-28 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100775 | 24100775 |
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]);