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 |
---|---|---|---|---|---|---|---|---|---|
52489 | 52489 | 1933-02-04 | 2 | e | Huang Xuchu, chairman of the Guangxi provincial government, leads a delegation to visit Vietnam and the report. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52490 | 52490 | 1933-02-04 | 2 | e | The aftermath in Fujian province following the execution of Chen Guohui. | China | http://trove.nla.gov.au/newspaper/page/24091106 | 24091106 | |
52500 | 52500 | 1933-02-04 | 5 | e | An old man of 109 years old in Shandong province, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091107 | 24091107 | |
52511 | 52511 | 1933-02-04 | 8 | e | British government shields Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24091112 | 24091112 | |
52512 | 52512 | 1933-02-04 | 8 | e | Australia news/ Japanese ship discovered in the northern Australian territorial waters. A meeting of federal cabinet on the trade with the Far East. Australian Labour Party on Japanese invasion of China. Federal government to reduce salary payment to its employees. League of Nations saves its expenses. Police in Sydney raid Chinese opium den. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091112 | 24091112 |
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]);