Article Index

3 rows where date = "1923-12-22" and page_url = "http://trove.nla.gov.au/newspaper/page/24094662"

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
40841 40841 1923-12-22 8 a-d   Guangdong news/ The war between Chen Jiongming and Sun Yatsen. United Army (lian jun) decides to stay in Guangzhou. Corpse found everywhere in Dongjiang area. Guangzhou newspapers are not allowed by report the defeat of Tan Yankai. Zhong Sheng issues an open letter to the associations in Guangzhou. Zou Lu's wife is assassinated. An army officer forces Sun Ke to provide army provisions. Yunnan army may retreat to Beijiang. The Third Division declares independence. Tung Wah http://trove.nla.gov.au/newspaper/page/24094662 24094662
40842 40842 1923-12-22 8 e   Gold price in Hong Kong. Tung Wah http://trove.nla.gov.au/newspaper/page/24094662 24094662
40843 40843 1923-12-22 8 e   Liner timetable. Tung Wah http://trove.nla.gov.au/newspaper/page/24094662 24094662

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