Article Index

3 rows where column = "c", date = "1923-08-04" and trove_id = 24094499

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date page column title description source page_url trove_id
40204 40204 1923-08-04 7 c   Chinese Nanhua (South China) Football (Soccer) Team comes to visit Australian by Japanese liner and the explanation of the travel. They will have matches with Australian teams in Sydney, New Castle, Wollongong, and Brisbane. Tung Wah http://trove.nla.gov.au/newspaper/page/24094499 24094499
40205 40205 1923-08-04 7 c   Flood in Anhui province. China http://trove.nla.gov.au/newspaper/page/24094499 24094499
40206 40206 1923-08-04 7 c   German economy in crisis. Britain http://trove.nla.gov.au/newspaper/page/24094499 24094499

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