This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44932 | 44932 | 1926-07-10 | 7 | a-b | Australia news/ A very conservative priest and his speech in Goulburn, New South Wales. Prisoners in Brisbane are on strike. Two young men are punished in Sydney for frivolous behaviour. The dance party of the League of Nations Union in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
44933 | 44933 | 1926-07-10 | 7 | b | The anti-Chinese sentiment in New Zealand. Flu and the casualties in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
44934 | 44934 | 1926-07-10 | 7 | b | Floods in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
44935 | 44935 | 1926-07-10 | 7 | c | British delegate issues declaration on the international tariff conference. | China | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
44936 | 44936 | 1926-07-10 | 7 | c | American consul and his attitude towards the Guangzhou government. | China | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
44937 | 44937 | 1926-07-10 | 7 | c | Earthquake in Sumatra. | Britain | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
44938 | 44938 | 1926-07-10 | 7 | c | Class strike in a Chinese school in Singapore and the report. | Singapore | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 |
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]);