Article Index

5 rows where column = "a" and date = "1923-08-04"

Filter results

This data as json, CSV (advanced)

Suggested facets: page, source, page_url, trove_id, date (date)

Link rowid ▼ date page column title description source page_url trove_id
40189 40189 1923-08-04 3 a   Sun Chuanfang resigns once again from his governorship post in Fujian province. China http://trove.nla.gov.au/newspaper/page/24094495 24094495
40196 40196 1923-08-04 6 a   China should set up more schools and other technical training institution, written by Zhou Xianchao. Tung Wah http://trove.nla.gov.au/newspaper/page/24094500 24094500
40200 40200 1923-08-04 7 a   Message from Zhong Baoxuan, professor of the Agriculture School, Lingnan University, Guangzhou, who comes to Sydney to raise funds for the school development. Photograph of Zhong Baoxuan. Ma Yingbiao and other Chinese businessmen in Hong Kong donate to the Agriculture School of Lingnan University. Tung Wah http://trove.nla.gov.au/newspaper/page/24094499 24094499
40201 40201 1923-08-04 7 a   Chinese Nanhua Football (Soccer) Team to have match with New South Wales team in Sydney. Advertisement for the match. And photograph of a Chinese football team member. Tung Wah http://trove.nla.gov.au/newspaper/page/24094499 24094499
40207 40207 1923-08-04 8 a   Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. Names listed. Tung Wah http://trove.nla.gov.au/newspaper/page/24094502 24094502

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