Article Index

2 rows where column = "a-b" and date = "1923-11-17"

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date page column title description source page_url trove_id
40675 40675 1923-11-17 3 a-b   Second and final part of the formal reply issued by the Chinese government to foreign missions in Beijing over the solutions to the kidnap of foreign tourists in Shandong province. China http://trove.nla.gov.au/newspaper/page/24094615 24094615
40682 40682 1923-11-17 6 a-b   Editor of Tung Wah Times questions Sun Yatsen's attack on Cao Kun as the new president of China. Tung Wah http://trove.nla.gov.au/newspaper/page/24094620 24094620

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