Article Index

10 rows where date = "1923-09-01" and page_url = "http://trove.nla.gov.au/newspaper/page/24094527"

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
40320 40320 1923-09-01 3 a   A circular telegram issued by the Guangdong public security association. China http://trove.nla.gov.au/newspaper/page/24094527 24094527
40321 40321 1923-09-01 3 a-b   A letter from Cao Kun to Yang Du. China http://trove.nla.gov.au/newspaper/page/24094527 24094527
40322 40322 1923-09-01 3 b-c   Campaign for presidential election in China. China http://trove.nla.gov.au/newspaper/page/24094527 24094527
40323 40323 1923-09-01 3 c   Wu Peifu supports to unify China by force. China http://trove.nla.gov.au/newspaper/page/24094527 24094527
40324 40324 1923-09-01 3 c-d   Army from the north enter Guangdong. China http://trove.nla.gov.au/newspaper/page/24094527 24094527
40325 40325 1923-09-01 3 d   American government will not change its China policy. America http://trove.nla.gov.au/newspaper/page/24094527 24094527
40326 40326 1923-09-01 3 e   A cargo ship is on fire on its way from Shanghai to Tokyo. China http://trove.nla.gov.au/newspaper/page/24094527 24094527
40327 40327 1923-09-01 3 e   A Japanese submarine sinks in a test near Kobe. Japan http://trove.nla.gov.au/newspaper/page/24094527 24094527
40328 40328 1923-09-01 3 e   Japanese prime minister Kato Takaaki dies. Japan http://trove.nla.gov.au/newspaper/page/24094527 24094527
40329 40329 1923-09-01 3 e   A train derails in Poland. Other... http://trove.nla.gov.au/newspaper/page/24094527 24094527

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