Article Index

9 rows where date = "1923-06-30" and page_url = "http://trove.nla.gov.au/newspaper/page/24094455"

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
40036 40036 1923-06-30 3 a   Bandit chieftain Sun Zhankui and the hijack of train in Shandong province. China http://trove.nla.gov.au/newspaper/page/24094455 24094455
40037 40037 1923-06-30 3 a-b   Negotiations between foreign missions in Beijing and the Chinese government over the bandits' hijack of train in Shandong province. China http://trove.nla.gov.au/newspaper/page/24094455 24094455
40038 40038 1923-06-30 3 b   American ambassador to China denies possible intervention of the League of Nations (with negotiations over the train hijack in Shandong province). China http://trove.nla.gov.au/newspaper/page/24094455 24094455
40039 40039 1923-06-30 3 c-d   Treasury in Beijing issues new plan to abolish likin and to increase taxes. China http://trove.nla.gov.au/newspaper/page/24094455 24094455
40040 40040 1923-06-30 3 c   Conditions of peace talks between Zhang Zuolin and Cao Kun. China http://trove.nla.gov.au/newspaper/page/24094455 24094455
40041 40041 1923-06-30 3 c-d   Motives of the train hijack in Shandong province. China http://trove.nla.gov.au/newspaper/page/24094455 24094455
40042 40042 1923-06-30 3 d   Wang Ruqin and his army have taken over Hechuan and Tongliang in the east of Sichuan province. China http://trove.nla.gov.au/newspaper/page/24094455 24094455
40043 40043 1923-06-30 3 e   Former justice minister Dong Kang returns to China and his suggestions for peace. China http://trove.nla.gov.au/newspaper/page/24094455 24094455
40044 40044 1923-06-30 3 e   A Tianjin sorcerer predicts war disaster in China. China http://trove.nla.gov.au/newspaper/page/24094455 24094455

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