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 |
---|---|---|---|---|---|---|---|---|---|
53959 | 53959 | 1934-03-17 | 2 | e | The 19th Route Army after being reorganised. | China | http://trove.nla.gov.au/newspaper/page/24091565 | 24091565 | |
53960 | 53960 | 1934-03-17 | 2 | e | Jiang Jieshi leaves Hangzhou for Nanchang. | China | http://trove.nla.gov.au/newspaper/page/24091565 | 24091565 | |
53966 | 53966 | 1934-03-17 | 3 | e | Britain may send trade commissioner to Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53967 | 53967 | 1934-03-17 | 3 | e | American report on the secret treaty between Germany and Japan. | America | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53968 | 53968 | 1934-03-17 | 3 | e | China's trade deficit last year. | China | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53971 | 53971 | 1934-03-17 | 5 | e | On divorce. On prostitute. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091566 | 24091566 | |
53981 | 53981 | 1934-03-17 | 6 | e | Australia news/ Dr Kuang Fuzhuo arrives Sydney from New Zealand. Import of tea and wine increases. Court hearing on the defraud of Chinese businessmen in Sydney. Chinese man in Sydney is arrested for laziness. Trial on the theft of Chinese garden in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 |
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]);