Article Index

3 rows where column = "c" and date = "1936-12-12"

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
56481 56481 1936-12-12 2 c   China news/ Birthday celebration in Nanjing for Jiang Jieshi. Duan Qirui dies in Shanghai and his will. Foreign minister Zhang Qun meets Japanese envoy in Nanjing. More than 200 Japanese soldiers are deserted. Song Zheyuan seeks to resign as governor of Hebei province. China http://trove.nla.gov.au/newspaper/page/24097093 24097093
56490 56490 1936-12-12 8 c   Japanese attitude towards Britain. Japan http://trove.nla.gov.au/newspaper/page/24097099 24097099
56491 56491 1936-12-12 8 c   Japanese sailors land in Qingdao, Shandong province. China http://trove.nla.gov.au/newspaper/page/24097099 24097099

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