Article Index

3 rows where date = "1923-06-09" and page = 8

Filter results

This data as json, CSV (advanced)

Suggested facets: column, date (date)

Link rowid ▼ date page column title description source page_url trove_id
39964 39964 1923-06-09 8 a-d   Guangdong news/ Yang Ximin orders troops to stop looting. Appointment from Beijing government on the military commandership in Guangdong. Guangdong students request for abrogation of the Twenty-one Demands. Yang Kunru urges Yao Yuping to return to Huizhou. Precautions against Li Yaohan and Shen Baofan in Jiangmen. Shen Hongying's army takes over Qingyuan county town. Sun Yatsen takes back Jianggu cruiser. Rumours on the truce in the front line. Young men in Guangzhou are forced to join the army. Sun Ke to set up a technical training institute for women in Guangzhou. Female government employee Ma Ruying in Guangzhou. Song Qingling arrives Guangzhou. Panic in Shiqi town, Xiangshan county. More troops arrive Shaozhou. Tung Wah http://trove.nla.gov.au/newspaper/page/24094438 24094438
39965 39965 1923-06-09 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094438 24094438
39966 39966 1923-06-09 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094438 24094438

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]);