This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54754 | 54754 | 1934-12-22 | 6 | a | Chinese General Qiu Zhaoshen to deliver a speech in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
54755 | 54755 | 1934-12-22 | 6 | a | Japanese ambassador in Washington and his talks. | America | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
54756 | 54756 | 1934-12-22 | 6 | a | The search for Australian plane fails. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
54757 | 54757 | 1934-12-22 | 6 | b | Japanese business in Poland. | Britain | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
54758 | 54758 | 1934-12-22 | 6 | c | American businessmen secure huge profit during the World War I. | America | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
54759 | 54759 | 1934-12-22 | 6 | d | American missionary is injured in China. | China | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
54760 | 54760 | 1934-12-22 | 6 | d | British army in Singapore and their exercise. | Singapore | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 | |
54761 | 54761 | 1934-12-22 | 6 | e | Australia news/ Chinese associations in Sydney entertain General Qiu Zhaoshen. Chinese businessmen come to buy Australian ships. Federal Bank of Reserve reduces the interest rate. Northern Territory government subsidises old Chinese people for their return. Federal government pay pensions to the families of pilot. Hot weather in Queensland. Another storm in Victoria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096275 | 24096275 |
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]);