Article Index

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

Filter results

This data as json, CSV (advanced)

Suggested facets: column, source, date (date)

Link rowid ▼ date page column title description source page_url trove_id
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
40825 40825 1923-12-22 3 e   Bandits in Henan province. America http://trove.nla.gov.au/newspaper/page/24094655 24094655
40826 40826 1923-12-22 3 e   Sun Yatsen has come to a dead end, report by The Times in London. Britain http://trove.nla.gov.au/newspaper/page/24094655 24094655
40827 40827 1923-12-22 3 e-f   Earthquake in South America. Canada http://trove.nla.gov.au/newspaper/page/24094655 24094655

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