Article Index

5 rows where column = "a" and date = "1923-07-07"

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
40064 40064 1923-07-07 3 a   Wu Peifu in Luoyang suggests to protect old palaces in Beijing. China http://trove.nla.gov.au/newspaper/page/24094463 24094463
40072 40072 1923-07-07 6 a   Miao Huili provides advice to the proposed establishment of Chinese school in Sydney by the Chinese Chamber of Commerce and the Chinese businessmen. Tung Wah http://trove.nla.gov.au/newspaper/page/24094468 24094468
40074 40074 1923-07-07 7 a   A report from Hong Kong on the war disaster in Zhaoqing and the refugees. Hong Kong http://trove.nla.gov.au/newspaper/page/24094467 24094467
40082 40082 1923-07-07 8 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/24094470 24094470
40083 40083 1923-07-07 8 a   Message of thanks by Yang Yingrong, a native of Nanhai county, who as a sailor was sentenced to eight years' imprisonment in Sydney for fighting and bailed out by Chinese priest Liu Junchen, businessmen Gan Baisheng and white priest, and is now returning to China by Victoria, a passenger of the China-Australia Steamship Line. Tung Wah http://trove.nla.gov.au/newspaper/page/24094470 24094470

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