This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55108 | 55108 | 1935-05-11 | 8 | a | Number of ships passing through the Suez Canal. | Britain | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 | |
55109 | 55109 | 1935-05-11 | 8 | a | New military weapons invented in Germany. | France | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 | |
55110 | 55110 | 1935-05-11 | 8 | c | Canada refuses Japanese goods. | Canada | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 | |
55111 | 55111 | 1935-05-11 | 8 | c | Army parade in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 | |
55112 | 55112 | 1935-05-11 | 8 | d | Referendum on independence in the Philippines. | Britain | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 | |
55113 | 55113 | 1935-05-11 | 8 | e | Anniversary celebration in Hong Kong for the King of Britain. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 | |
55114 | 55114 | 1935-05-11 | 8 | e | Australia news/ Chinese communities in the Philippines welcome General Cai Tingkai. Penalty on the breach of new wages regulations in Sydney. Price of imported tobacco going up. Anniversary celebration in Sydney for the King of Britain. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 |
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]);