Article Index

4 rows where column = "c" and date = "1923-08-04"

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
40191 40191 1923-08-04 3 c   Cabinet in Beijing takes over administration since President Li Yuanhong left. China http://trove.nla.gov.au/newspaper/page/24094495 24094495
40204 40204 1923-08-04 7 c   Chinese Nanhua (South China) Football (Soccer) Team comes to visit Australian by Japanese liner and the explanation of the travel. They will have matches with Australian teams in Sydney, New Castle, Wollongong, and Brisbane. Tung Wah http://trove.nla.gov.au/newspaper/page/24094499 24094499
40205 40205 1923-08-04 7 c   Flood in Anhui province. China http://trove.nla.gov.au/newspaper/page/24094499 24094499
40206 40206 1923-08-04 7 c   German economy in crisis. Britain http://trove.nla.gov.au/newspaper/page/24094499 24094499

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