This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54999 | 54999 | 1935-04-06 | 6 | a | Democratic political system in Poland comes to an end. | Britain | http://trove.nla.gov.au/newspaper/page/24096387 | 24096387 | |
55000 | 55000 | 1935-04-06 | 6 | a | Persia changes its name to Iran. | Britain | http://trove.nla.gov.au/newspaper/page/24096387 | 24096387 | |
55001 | 55001 | 1935-04-06 | 6 | a | Japan quits the League of Nations. | Japan | http://trove.nla.gov.au/newspaper/page/24096387 | 24096387 | |
55002 | 55002 | 1935-04-06 | 6 | b | Revolutionaries arrested in Greece. | Other... | http://trove.nla.gov.au/newspaper/page/24096387 | 24096387 | |
55003 | 55003 | 1935-04-06 | 6 | b | King of Thailand has settled in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096387 | 24096387 | |
55004 | 55004 | 1935-04-06 | 6 | b | Britain and Russia co-operatively keep the world peace. | Britain | http://trove.nla.gov.au/newspaper/page/24096387 | 24096387 | |
55005 | 55005 | 1935-04-06 | 6 | c | Australia news/ Chinese communities in Melbourne and Brisbane welcome General Cai Tingkai. Federal government reform tax rate. Price of flour going up. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096387 | 24096387 |
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]);