Article Index

2 rows where column = "c" and date = "1934-11-03"

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date page column title description source page_url trove_id
54638 54638 1934-11-03 2 c   China news/ Chinese troops in Liaoning province take over Changbai county town. Jiang Jieshi orders Sichuan army to suppress the communists. Japanese troops in north China. Japanese protest against Chinese government over the murder of Japanese businessman in Shanghai. Construction of the Longhai railway. Japanese plan to invade the west of Mongolia. China http://trove.nla.gov.au/newspaper/page/24096216 24096216
54640 54640 1934-11-03 3 c   Heavy rains in Xuzhou area, north Jiangsu province, and the Yellow River is flooding. China http://trove.nla.gov.au/newspaper/page/24096215 24096215

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