Article Index

1 row where column = "b-d" and date = "1923-08-11"

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date page column title description source page_url trove_id
40243 40243 1923-08-11 8 b-d   Guangdong news/ Local villagers in Lingnan write and oppose to Sun Yatsen. Refugees in Boluo county write to their compatriots in Hong Kong. Yang Ximin detains Tang Chisheng and the aftermath. Guangdong army have arrived Heyuan county on their way to backup Huizhou. District director in Guangzhou Li Yinzhong is under investigation for misconduct. Tung Wah http://trove.nla.gov.au/newspaper/page/24094510 24094510

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