Article Index

7 rows where column = "d" and date = "1936-02-22"

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
55810 55810 1936-02-22 2 d   Jiang Jieshi to set Sichuan and Shaanxi as the basis to save China. China http://trove.nla.gov.au/newspaper/page/24096752 24096752
55811 55811 1936-02-22 2 d   Yan Xishan prefers to stay in Taiyuan, Shanxi province. China http://trove.nla.gov.au/newspaper/page/24096752 24096752
55812 55812 1936-02-22 2 d   Sun Dianying arrives Beijing to see doctor. Traitor Zhao Lei and others and their collaboration with Japanese invaders to taking over Tianjin. Economic Commission plans to dredge the Huaihe River to the sea. Ma Zhanshan puts forward his proposals to Jiang Jieshi. China http://trove.nla.gov.au/newspaper/page/24096752 24096752
55817 55817 1936-02-22 3 d   British government to expand its military forces. Britain http://trove.nla.gov.au/newspaper/page/24096751 24096751
55818 55818 1936-02-22 3 d   Japanese exploit natural resources in Manchuria. China http://trove.nla.gov.au/newspaper/page/24096751 24096751
55819 55819 1936-02-22 3 d   Military agreement between France and Britain and the response of Germany. Britain http://trove.nla.gov.au/newspaper/page/24096751 24096751
55820 55820 1936-02-22 3 d   Japanese army commander in China returns to Changchun, Jilin province. China http://trove.nla.gov.au/newspaper/page/24096751 24096751

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