This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51893 | 51893 | 1932-09-10 | 5 | a | Fourth part of the open letter from Chen Mingshu to the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24090939 | 24090939 | |
51894 | 51894 | 1932-09-10 | 5 | a | The Chinese Chamber of Commerce in NSW passes a letter from the Chinese volunteer army in Manchuria to the Chinese communities in Australia. And a draft reply by Xu Shiying. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090939 | 24090939 | |
51895 | 51895 | 1932-09-10 | 5 | c | A speech by Zhao Yu at the welcome ceremony organised by the Chinese communities in Sydney. Urgent notice issued by the Chinese Chamber of Commerce in NSW on the exports to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090939 | 24090939 |
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]);