Article Index

3 rows where column = "c" and date = "1923-06-09"

Filter results

This data as json, CSV (advanced)

Suggested facets: page, source, page_url, trove_id, date (date)

Link rowid ▼ date page column title description source page_url trove_id
39945 39945 1923-06-09 3 c   General naval commander in Nanjing Du Xigui and the naval forces in Shanghai. China http://trove.nla.gov.au/newspaper/page/24094431 24094431
39946 39946 1923-06-09 3 c   Beijing government answers inquiry about bribery in the parliament. China http://trove.nla.gov.au/newspaper/page/24094431 24094431
39963 39963 1923-06-09 7 c   A public notice issued by the Tung Wah Times about its dispute with Min Bao, organ of the Nationalist Party in Sydney, and involvement of Ye Bingnan, Li Ganquan, Yu Rong, Ma Shupei, Huang Yougong, and others. Tung Wah http://trove.nla.gov.au/newspaper/page/24094435 24094435

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