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 |
---|---|---|---|---|---|---|---|---|---|
53878 | 53878 | 1934-02-24 | 2 | e | Mongolian representatives meet Wang Jingwei in Nanjing for the issues of autonomous administration. | China | http://trove.nla.gov.au/newspaper/page/24091541 | 24091541 | |
53879 | 53879 | 1934-02-24 | 2 | e | Fujian troops retreat under the pressure of the Central Government army. | China | http://trove.nla.gov.au/newspaper/page/24091541 | 24091541 | |
53885 | 53885 | 1934-02-24 | 3 | e | Britain and France dispute over trade issues. | Britain | http://trove.nla.gov.au/newspaper/page/24091540 | 24091540 | |
53886 | 53886 | 1934-02-24 | 3 | e | Japanese organise economic association in north China. | China | http://trove.nla.gov.au/newspaper/page/24091540 | 24091540 | |
53899 | 53899 | 1934-02-24 | 6 | e | Yan Xishan starts to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53900 | 53900 | 1934-02-24 | 6 | e | Australia news/ Federal government appoints trade commissioner to the Far East. Two Chinese men on trial in Sydney for defraud. Russian tourist talks about Manchuria on his arrival in Australia. Chinese man arrested for being involved in theft. Storm in New South Wales and the damages. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 |
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]);