Article Index

3 rows where date = "1923-12-15" and trove_id = 24094654

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
40811 40811 1923-12-15 8 a-d   Guangdong news/ Chen Qiyuan withdraws money from the bank by force. Sun Yatsen speaks to his troops. Sun Yatsen's English secretary Chen Youren can not assure the takeover of Huizhou. More battles in Guangdong. Guangdong army occupy Boluo and Shilong. Jiang Guangliang escapes. Hong Zhaolin writes to his family. Liu Yushan and Liu Zhenhuan are disbanded. Guangzhou will turn into battle field. Tung Wah http://trove.nla.gov.au/newspaper/page/24094654 24094654
40812 40812 1923-12-15 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094654 24094654
40813 40813 1923-12-15 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094654 24094654

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