Article Index

8 rows where date = "1923-12-22" and source = "China"

Filter results

This data as json, CSV (advanced)

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

Link rowid ▼ date page column title description source page_url trove_id
40816 40816 1923-12-22 2 d   Appointment of local inspectors (xun yue shi): Wu Peifu in Henan, Shandong and Zhili province; Xiao Yaonan in Hunan and Hubei; and Qie Xieyuan in Jiangsu, Anhui and Jiangxi province. China http://trove.nla.gov.au/newspaper/page/24094656 24094656
40817 40817 1923-12-22 2 d-e   Wu Peifu in Luoyang is against new parliament members. China http://trove.nla.gov.au/newspaper/page/24094656 24094656
40820 40820 1923-12-22 3 a   Sun Yatsen sells the mint in Guangzhou. China http://trove.nla.gov.au/newspaper/page/24094655 24094655
40821 40821 1923-12-22 3 a-b   Students in Anqing, capital of Anhui province, besiege the residence of national parliamentarian. China http://trove.nla.gov.au/newspaper/page/24094655 24094655
40822 40822 1923-12-22 3 b   Leaders of Anfu faction are pardoned. China http://trove.nla.gov.au/newspaper/page/24094655 24094655
40823 40823 1923-12-22 3 b-c   The war in Sichuan province and some predictions. China http://trove.nla.gov.au/newspaper/page/24094655 24094655
40824 40824 1923-12-22 3 c-d   Chinese government transfers indemnity payable to Russia to pay its overseas missions. China http://trove.nla.gov.au/newspaper/page/24094655 24094655
40831 40831 1923-12-22 6 c   Ye Ju pleas for help to the refugees in Huizhou. China http://trove.nla.gov.au/newspaper/page/24094660 24094660

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