Article Index

10 rows where date = "1923-11-24" and page_url = "http://trove.nla.gov.au/newspaper/page/24094623"

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
40703 40703 1923-11-24 3 a   Military governor of Zhejiang province Lu Yongxiang claims that Sun Yatsen has lost the trust of the people. China http://trove.nla.gov.au/newspaper/page/24094623 24094623
40704 40704 1923-11-24 3 a-b   American archeologist and his Asian colleagues have new findings in Mongolia. America http://trove.nla.gov.au/newspaper/page/24094623 24094623
40705 40705 1923-11-24 3 b   Wu Peifu congratulates Cao Kun as the new Chinese president. China http://trove.nla.gov.au/newspaper/page/24094623 24094623
40706 40706 1923-11-24 3 b-c   A circular telegram issued by Cao Kun as the newly-elected Chinese president. China http://trove.nla.gov.au/newspaper/page/24094623 24094623
40707 40707 1923-11-24 3 c   Tang Shaoyi comments on Cao Kun, the presidential election and the bribery. China http://trove.nla.gov.au/newspaper/page/24094623 24094623
40708 40708 1923-11-24 3 c   Wu Weijun, Gao Lingwei, Zhang Hu, and others declare the end of a regent cabinet in China. China http://trove.nla.gov.au/newspaper/page/24094623 24094623
40709 40709 1923-11-24 3 c-d   Wu Peifu organises a police headquarters in Hunan province. China http://trove.nla.gov.au/newspaper/page/24094623 24094623
40710 40710 1923-11-24 3 d-e   Inland navigation and shipping industry in China. Tung Wah http://trove.nla.gov.au/newspaper/page/24094623 24094623
40711 40711 1923-11-24 3 e   Pirates hijack a Japanese ship near Hong Kong. China http://trove.nla.gov.au/newspaper/page/24094623 24094623
40712 40712 1923-11-24 3 e   A bank robber in New York. America http://trove.nla.gov.au/newspaper/page/24094623 24094623

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