Article Index

5 rows where column = "a" and date = "1923-05-26"

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
39895 39895 1923-05-26 6 a   To betray one's country or to love one's country, comments by Tung Wah Times. Tung Wah http://trove.nla.gov.au/newspaper/page/24094420 24094420
39898 39898 1923-05-26 7 a   A Sydney missionary has magic skills to cure patients. Australia http://trove.nla.gov.au/newspaper/page/24094419 24094419
39899 39899 1923-05-26 7 a   A meeting of the Chinese Chamber of Commerce in New South Wales and the discussions on new membership, Chinese school, sale of public property in Guangzhou, negotiation with Japan over the Twenty-one Demands, and the visit of Chines football students to Australia. Tung Wah http://trove.nla.gov.au/newspaper/page/24094419 24094419
39900 39900 1923-05-26 7 a   A Chinese businessman in Sydney is robbed. Tung Wah http://trove.nla.gov.au/newspaper/page/24094419 24094419
39901 39901 1923-05-26 7 a   Counterfeit bank notes found in Sydney. Australia http://trove.nla.gov.au/newspaper/page/24094419 24094419

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