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 |
---|---|---|---|---|---|---|---|---|---|
50491 | 50491 | 1931-07-11 | 3 | d | Chinese national commercial chamber requests the government to undertake investigation on its consul-general in Korea. | China | http://trove.nla.gov.au/newspaper/page/24090444 | 24090444 | |
50495 | 50495 | 1931-07-11 | 5 | d | A statue, which is set up in Guangzhou in memory of the Communist disasters, is destroyed by Chen Jitang, with approval of Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24090446 | 24090446 | |
50496 | 50496 | 1931-07-11 | 5 | d | Wives of Chinese politicians and their influence upon the political struggle. A dancing girl in Japan insures her leg for 2 million dollars. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090446 | 24090446 | |
50509 | 50509 | 1931-07-11 | 8 | d | Australia news/ Storm in Sydney and the damages. China purchases railway sleepers from Australia. Australia repays debts to Britain with gold. Snow in Broken Hill, NSW. The future of the Savings Bank of New South Wales unclear. Australia exports railway sleepers to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 |
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]);