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 |
---|---|---|---|---|---|---|---|---|---|
53212 | 53212 | 1933-08-26 | 2 | d | Wang Jingwei replies to Li Jishen and Chen Mingshu. | China | http://trove.nla.gov.au/newspaper/page/24091342 | 24091342 | |
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 | |
53229 | 53229 | 1933-08-26 | 6 | d | Floods in China. | China | http://trove.nla.gov.au/newspaper/page/24091346 | 24091346 | |
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]);