Article Index

5 rows where date = "1936-02-08" and page_url = "http://trove.nla.gov.au/newspaper/page/24096742"

Filter results

This data as json, CSV (advanced)

Suggested facets: column, source, date (date)

Link rowid ▼ date page column title description source page_url trove_id
55791 55791 1936-02-08 8 a   Japanese seek to invade Inner Mongolia. China http://trove.nla.gov.au/newspaper/page/24096742 24096742
55792 55792 1936-02-08 8 c   Funeral of King George V in London. Britain http://trove.nla.gov.au/newspaper/page/24096742 24096742
55793 55793 1936-02-08 8 c   Liu Guitang leads his troops fleeing into Shandong province. China http://trove.nla.gov.au/newspaper/page/24096742 24096742
55794 55794 1936-02-08 8 d   The communist bandits in Guizhou and Hebei province. China http://trove.nla.gov.au/newspaper/page/24096742 24096742
55795 55795 1936-02-08 8 e   Australia news/ People in Sydney mourn the death of King George V. Australia exports wheat to overseas countries. Bandits in Melbourne. Japanese come to promote business in Australia. Tung Wah http://trove.nla.gov.au/newspaper/page/24096742 24096742

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