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 |
---|---|---|---|---|---|---|---|---|---|
50585 | 50585 | 1931-08-08 | 2 | b | Japanese government appoints new General Manager for the railways in Manchuria and the second part of comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090477 | 24090477 | |
50588 | 50588 | 1931-08-08 | 3 | b | British newspaper comments that China should not pay compensation for the Manchurian railways. | Britain | http://trove.nla.gov.au/newspaper/page/24090476 | 24090476 | |
50596 | 50596 | 1931-08-08 | 8 | b | Pirates hijack British merchant ship in Zhenjiang, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24090485 | 24090485 | |
50597 | 50597 | 1931-08-08 | 8 | b | More disasters strike China. | China | http://trove.nla.gov.au/newspaper/page/24090485 | 24090485 | |
50598 | 50598 | 1931-08-08 | 8 | b | Ms Johnson is flying across Russia for Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24090485 | 24090485 | |
50599 | 50599 | 1931-08-08 | 8 | b | Australia news/ Hong Kong General Chamber of Commerce and Tung Wah Hospital write to the Sydney Chinese Chamber of Commerce and call for donations to the flooding areas in China. The bankruptcy of the Savings Bank of New South Wales and its clients. Clashes between police, workers and the communists in New Zealand. Newspapers and politicians in Sydney comments on the refusal by the Shanghai commercial chamber to introduce Australian flour to the China market. Chinese in Sydney protest against a court judge for his discriminative words. Theatre in Sydney is closed down. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090485 | 24090485 |
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]);