Article Index

6 rows where column = "e" and date = "1936-02-01"

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
55762 55762 1936-02-01 2 e   Japanese in north China force Song Zheyuan to withdraw troops from Tongzhou, between Beijing and Tianjin. China http://trove.nla.gov.au/newspaper/page/24096728 24096728
55763 55763 1936-02-01 2 e   Newly-appointed Deputy Transportation Minister of the Nanjing government Tang Youren is assassinated in Shanghai. China http://trove.nla.gov.au/newspaper/page/24096728 24096728
55767 55767 1936-02-01 3 e   Britain refuses to sign air defence agreement with Germany. Britain http://trove.nla.gov.au/newspaper/page/24096727 24096727
55768 55768 1936-02-01 3 e   More Japanese troops are gathering in north China. China http://trove.nla.gov.au/newspaper/page/24096727 24096727
55769 55769 1936-02-01 3 e   Eruption of the volcano in Hawaii. America http://trove.nla.gov.au/newspaper/page/24096727 24096727
55779 55779 1936-02-01 8 e   Australia news/ Chinese gardens robbed in the Sydney suburb. Chinese gardener is drowned in NSW. Tax to be exempted for flour sales. Some savings in the Savings Bank of New South Wales can not find owners. Chinese gardener is injured in an accident. Opium seized from passenger liner Taiping. Tung Wah http://trove.nla.gov.au/newspaper/page/24096734 24096734

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