This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48701 | 48701 | 1929-12-07 | 8 | d | Members of the British House of Commons question the foreign secretary on the Russia policy. | Britain | http://trove.nla.gov.au/newspaper/page/24099461 | 24099461 | |
48702 | 48702 | 1929-12-07 | 8 | d | Soviet Russian authority forces Chinese to do hard labour. Truce between Jiang Jieshi and Feng Yuxiang. Chinese ambassador in Germany seeks peace talks with Russian. Attitude of the American government towards the coming conflict between China and Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24099461 | 24099461 | |
48703 | 48703 | 1929-12-07 | 8 | e | Indian authority to ban child marriage. | Other... | http://trove.nla.gov.au/newspaper/page/24099461 | 24099461 | |
48704 | 48704 | 1929-12-07 | 8 | e | German ambassador and the talks between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24099461 | 24099461 | |
48705 | 48705 | 1929-12-07 | 8 | e | British government on the abolition of consular jurisdiction in China. | Britain | http://trove.nla.gov.au/newspaper/page/24099461 | 24099461 | |
48706 | 48706 | 1929-12-07 | 8 | f | Chinese foreign minister Wang Zhengting to resign. Russian authority deploys women troops to fight Chinese army. Mutiny in Pukou, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24099461 | 24099461 | |
48707 | 48707 | 1929-12-07 | 8 | f | Australia news/ Gibbs Bright Company in Sydney entertains Chinese clients and report on the dinner party. Murderer arrested in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099461 | 24099461 |
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]);