Article Index

8 rows where "date" is on date 1924-02-09 and trove_id = 24100618

Filter results

This data as json, CSV (advanced)

Suggested facets: column, source, date (date)

Link rowid ▼ date page column title description source page_url trove_id
41128 41128 1924-02-09 20 a   Photograph of Miss Ye Zuyi (Miss Quoy), one of the sopranists of the Chinese Festival Night, at the Sydney Town Hall, on December 15, 1923, in aid of Royal Prince Alfred Hospital, Sydney. Tung Wah http://trove.nla.gov.au/newspaper/page/24100618 24100618
41129 41129 1924-02-09 20 a   News from Guangzhou on the tariff dispute. China http://trove.nla.gov.au/newspaper/page/24100618 24100618
41130 41130 1924-02-09 20 a   Guangdong army occupy Zengcheng county. China http://trove.nla.gov.au/newspaper/page/24100618 24100618
41131 41131 1924-02-09 20 b   Yunnan army station in Baiyun Mountain. China http://trove.nla.gov.au/newspaper/page/24100618 24100618
41132 41132 1924-02-09 20 b   Chen Jiongming supports national unification. China http://trove.nla.gov.au/newspaper/page/24100618 24100618
41133 41133 1924-02-09 20 b   Yu Shiying opposes to the sale of public property in Guangzhou. China http://trove.nla.gov.au/newspaper/page/24100618 24100618
41134 41134 1924-02-09 20 b   Treasury department in Guangzhou seals up temples in order to collect more tax. China http://trove.nla.gov.au/newspaper/page/24100618 24100618
41135 41135 1924-02-09 20 c   Advertisement for Mr Alexander, inspector of the Commonwealth General Insurance, Sydney. Tung Wah http://trove.nla.gov.au/newspaper/page/24100618 24100618

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