This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54862 | 54862 | 1935-02-09 | 6 | a | British government on the coming crisis in the Far East. | Britain | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54863 | 54863 | 1935-02-09 | 6 | a | The Seventh Congress of the Soviet Communist Party in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54864 | 54864 | 1935-02-09 | 6 | b | Conflicts on the border of Mongolia, Russia and Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54865 | 54865 | 1935-02-09 | 6 | b | American government opposes to the establishment of an international court. | America | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54866 | 54866 | 1935-02-09 | 6 | c | Jiang Jieshi reaches agreement with Japanese. | Japan | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54867 | 54867 | 1935-02-09 | 6 | c | Japanese seek to topple the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54868 | 54868 | 1935-02-09 | 6 | d | The communists in Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54869 | 54869 | 1935-02-09 | 6 | e | Diplomatic relations between America and Russia may break off. | America | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54870 | 54870 | 1935-02-09 | 6 | e | Fiji welcomes Prince of Britain. | Other... | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
54871 | 54871 | 1935-02-09 | 6 | f | Australia news/ Australia and Japan start talks on trade agreement. Women in Queensland demand equal fights with men. Chinese communities in Brisbane welcome Chinese general Qiu Zhaoshen. Japanese confidence on the New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 |
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]);