This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44883 | 44883 | 1926-06-26 | 7 | a-d | Australia news/ German consul is leaving Australia. Commercial Bank of Australia loses huge amount of money. Garden and the health problem. First part of the Compensation Act to Workers promulgated by the federal government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101611 | 24101611 | |
44884 | 44884 | 1926-06-26 | 7 | c-d | An open letter from the Chinese community in New Zealand against the White New Zealand policy. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101611 | 24101611 | |
44885 | 44885 | 1926-06-26 | 7 | d | Envoys of Wu Peifu and Zhang Zuolin on the way to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101611 | 24101611 | |
44886 | 44886 | 1926-06-26 | 7 | d | American woman is harassed in Chengdu, Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101611 | 24101611 | |
44887 | 44887 | 1926-06-26 | 7 | d | Warlords in China issues various types of bank notes. | China | http://trove.nla.gov.au/newspaper/page/24101611 | 24101611 |
JSON shape: default, array, newline-delimited
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]);