Article Index

2 rows where column = "a" and date = "1918-08-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
33525 33525 1918-08-17 3 a   Long Jiguang in Beijing and Tianjin and his activities. China http://trove.nla.gov.au/newspaper/page/24097395 24097395
33539 33539 1918-08-17 8 a   The New South Wales Chinese Chamber of Commerce and the Lin Yik Tong jointly call for donations to the flooding victims in Guangdong and names listed for all donations. Tung Wah http://trove.nla.gov.au/newspaper/page/24097402 24097402

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