This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53210 | 53210 | 1933-08-26 | 2 | a | First part of an editorial on Japanese conspiracy of their proposed Asian alliance. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091342 | 24091342 | |
53219 | 53219 | 1933-08-26 | 5 | a | Zhi gong tang and the Constitutional Party (xian zheng dang) welcome Zhang Junmai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091343 | 24091343 | |
53220 | 53220 | 1933-08-26 | 5 | d | The girl secretaries in Nanjing and their stories. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091343 | 24091343 | |
53230 | 53230 | 1933-08-26 | 6 | d | Australia news/ Another court hearing on the case of Huang Huazhi. Famous Chinese businessman and accountant of the Chinese Baptism church in Sydney Huang Si dies. Chinese gardener is found embezzlement. Chinese man killed in a tram accident, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 |
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]);