Article Index

3 rows where date = "1923-11-10" and trove_id = 24094614

Filter results

This data as json, CSV (advanced)

Suggested facets: column, date (date)

Link rowid ▼ date page column title description source page_url trove_id
40670 40670 1923-11-10 8 a-d   Guangdong news/ Sun Yatsen sets up a fundraising bureau in Guangzhou, headed by Liao Zhongkai, which supplies army provisions. Two aeroplanes are detained by Gongbei Customs Office. Xu Chongzhi and his troops return to Guangdong. Businessmen are required to surrender their weapons. National parliamentarians from Guangdong are punished in Beijing. Dongguan county has turned into a bandit world. A man jumps into river in order to escape the pressgang. A well in Guangzhou is boiled with no reason. A kidnap in Guangzhou and the ransom. Typhoon swallows Guangzhou. Tung Wah http://trove.nla.gov.au/newspaper/page/24094614 24094614
40671 40671 1923-11-10 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094614 24094614
40672 40672 1923-11-10 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094614 24094614

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