Article Index

3 rows where date = "1923-04-28" and trove_id = 24094390

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
39805 39805 1923-04-28 8 a-d   Guangdong news/ Some temples in Guangzhou have turned into schools. The first female employee in the provincial treasury. Public properties in See Yup region are auctioned for military funds. Troops detain residents in Guangzhou. Troops under Zhang Xishi and Chen Tiantai prepare for the war. A new army organised under the commandership of Li Yaohan. Why Xu Shaozheng could become the provincial governor and the deals. Spy in Guangzhou. Huang Bihun is executed in Guangzhou. Bandit robbery in Zhaoqing. Hu Hanmin recuperates from an illness near the West Lake in Hangzhou. Woman gamblers in Guangzhou. Monster found in bridal chamber in Foshan. Tung Wah http://trove.nla.gov.au/newspaper/page/24094390 24094390
39806 39806 1923-04-28 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094390 24094390
39807 39807 1923-04-28 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094390 24094390

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