Article Index

3 rows where date = "1923-05-05" and trove_id = 24094398

Filter results

This data as json, CSV (advanced)

Suggested facets: column, date (date)

trove_id 1 ✖

  • 24094398 · 3 ✖

page_url 1 ✖

Link rowid ▼ date page column title description source page_url trove_id
39831 39831 1923-05-05 8 a-d   Guangdong news/ Provincial governor Xu Shaozheng issues a public notice on local civil administration. Railway passengers on the Guangzhou-Kowloon line are prohibited to travel with weapons. Pessimism on fiscal situation in Guangdong. Army from the north arrive Nanxiong. A female spy arrested in Guangzhou. Sun Yatsen's offers to foreign loans. Self-defence army organised in Xiangshan county. Governor Xu Shaozheng promotes Confucianism. Sun Yatsen arrives Yongxiang. Sun Yatsen is urged to disband Hu Wencan's troops. Chen Dechun's property in Guangzhou will be protected by Li Yibiao. Damages of war in Zhaoqing. Sun Yatsen orders Zhou Zhizheng, Chen Ce and Liang Hongkai to take over Jiangmen. Looting in Kaiping county. Sun Yatsen and Chen Ce. Chen Dechun retreats to Kaiping and Enping. Civil corps occupy Enping. Tung Wah http://trove.nla.gov.au/newspaper/page/24094398 24094398
39832 39832 1923-05-05 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094398 24094398
39833 39833 1923-05-05 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094398 24094398

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 
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]);