Article Index

1 row where column = "a-c", date = "1923-08-18" and page_url = "http://trove.nla.gov.au/newspaper/page/24094515"

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

page_url 1 ✖

  • http://trove.nla.gov.au/newspaper/page/24094515 · 1 ✖

page 1 ✖

  • 7 1

column 1 ✖

Link rowid ▼ date page column title description source page_url trove_id
40264 40264 1923-08-18 7 a-c   Miscellaneous report on the visit and matches of Chinese football team in Sydney. Coordinators include Liu Guangfu, Zhou Yuanji, Zhu Hechou and Chen Yaoyuan. Comments written by Zhou Jialing on the match in Sydney. Tung Wah http://trove.nla.gov.au/newspaper/page/24094515 24094515

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