This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55296 | 55296 | 1935-07-27 | 8 | a | Britain repays debts to America and the report. | Britain | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55297 | 55297 | 1935-07-27 | 8 | b | Japanese authority arrests communist activists. | Japan | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55298 | 55298 | 1935-07-27 | 8 | c | Australian Prime Minister Lyon visits Canada and an accident. | Canada | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55299 | 55299 | 1935-07-27 | 8 | c | Another earthquake in Taiwan. | Britain | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55300 | 55300 | 1935-07-27 | 8 | d | Egypt abrogates trade agreement with Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55301 | 55301 | 1935-07-27 | 8 | d | Floods in Shandong and Hubei province in China. | China | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55302 | 55302 | 1935-07-27 | 8 | e | Trade disputes between Japan and Canada. | America | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55303 | 55303 | 1935-07-27 | 8 | e | Japanese envoy comes to visit Australia. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55304 | 55304 | 1935-07-27 | 8 | f | Australia news/ Celebrations in Sydney for the 150th anniversary of the city. Queensland may restrict banana growing. Japanese man is on trial in Sydney for drug smuggling. Bandits in Sydney rob jewellery shop. Sand storm in South Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 |
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]);