Article Index

7 rows where date = "1936-08-22" and trove_id = 24096962

Filter results

This data as json, CSV (advanced)

Suggested facets: column, date (date)

Link rowid ▼ date page column title description source page_url trove_id
56172 56172 1936-08-22 2 b   Wang Kemin arrives Beijing and the exercise of Japanese troops. China http://trove.nla.gov.au/newspaper/page/24096962 24096962
56173 56173 1936-08-22 2 d   Registration of opium smokers in Shanghai. China http://trove.nla.gov.au/newspaper/page/24096962 24096962
56174 56174 1936-08-22 2 d   Guangxi provincial government to collect more grains for storage. China http://trove.nla.gov.au/newspaper/page/24096962 24096962
56175 56175 1936-08-22 2 e   Song Zheyuan's troops have conflict with Japanese troops in Tianjin. China http://trove.nla.gov.au/newspaper/page/24096962 24096962
56176 56176 1936-08-22 2 f   Japanese purchase rice in south Anhui province. China http://trove.nla.gov.au/newspaper/page/24096962 24096962
56177 56177 1936-08-22 2 f   A meeting of Japanese army officers in Shanghai. China http://trove.nla.gov.au/newspaper/page/24096962 24096962
56178 56178 1936-08-22 2 f   Chinese Ministry of Finance to help the Bank of Transportation. China http://trove.nla.gov.au/newspaper/page/24096962 24096962

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