Article Index

6 rows where date = "1923-09-01" and page_url = "http://trove.nla.gov.au/newspaper/page/24094532"

Filter results

This data as json, CSV (advanced)

Suggested facets: column, source, date (date)

Link rowid ▼ date page column title description source page_url trove_id
40330 40330 1923-09-01 6 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/24094532 24094532
40331 40331 1923-09-01 6 a-b   Shareholders of the Xinning railway line issue an open letter. China http://trove.nla.gov.au/newspaper/page/24094532 24094532
40332 40332 1923-09-01 6 b-c   Chinese businessman Liang Chuang celebrates his 60th birthday in Shanghai and congratulations from Liang Qichao, Xiong Xiling, Wang Daxie, Lin Changmin, Wang Chonghui, Li Zhongyue, Li Hanfen, Yang Hao, Wang Tiduan, Wang Zhaoji, Kang Youwei, Zhang Qian, and many others. Liang is major shareholder of Wing On companies in Hong Kong, Shanghai and Sydney, of Wing On textile company in Shanghai and Guangming electronics company in Shanghai. China http://trove.nla.gov.au/newspaper/page/24094532 24094532
40333 40333 1923-09-01 6 c-d   Chinese Association in New Zealand gathers in protest against auction of charity properties in Guangzhou. New Zealand http://trove.nla.gov.au/newspaper/page/24094532 24094532
40334 40334 1923-09-01 6 d   A man talks with a ghost in Guangzhou. Tung Wah http://trove.nla.gov.au/newspaper/page/24094532 24094532
40335 40335 1923-09-01 6 d   A pray for rain in a Beijing village. Tung Wah http://trove.nla.gov.au/newspaper/page/24094532 24094532

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