This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54517 | 54517 | 1934-09-15 | 6 | a | Volcano erupts in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54518 | 54518 | 1934-09-15 | 6 | a | Britain seeks to renew their commercial activities in China. | Britain | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54519 | 54519 | 1934-09-15 | 6 | a | Strike in the south of America. | America | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54520 | 54520 | 1934-09-15 | 6 | a | Yellow River is flooding and the damages. | China | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54521 | 54521 | 1934-09-15 | 6 | c | Japan forces China to quit the League of Nations and the response of Chinese government. | Britain | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54522 | 54522 | 1934-09-15 | 6 | c | Japanese government to abrogate the naval agreement signed with Washington. | Japan | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54523 | 54523 | 1934-09-15 | 6 | d | Tourist ferry on fire in New York. | America | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 | |
54524 | 54524 | 1934-09-15 | 6 | e | Australia news/ Flu in Melbourne. Visitor talks about Japan on his return to Sydney. Chinese Chamber of Commerce in Sydney entertains Sydney health authority official. NSW state government offers rewards to the capture of robber. Some girls disappear in Sydney and the report. A mysterious plan near Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 |
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]);