This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53893 | 53893 | 1934-02-24 | 6 | a | Cannons used during the World War I. | Britain | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53894 | 53894 | 1934-02-24 | 6 | c | Earthquake in India. | Britain | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53895 | 53895 | 1934-02-24 | 6 | c | Chaos in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53896 | 53896 | 1934-02-24 | 6 | c | Indian parliament passes the budget report. | Other... | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53897 | 53897 | 1934-02-24 | 6 | d | Britain to expand its navy. | Britain | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53898 | 53898 | 1934-02-24 | 6 | d | Chaos in Austria. | Other... | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53899 | 53899 | 1934-02-24 | 6 | e | Yan Xishan starts to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53900 | 53900 | 1934-02-24 | 6 | e | Australia news/ Federal government appoints trade commissioner to the Far East. Two Chinese men on trial in Sydney for defraud. Russian tourist talks about Manchuria on his arrival in Australia. Chinese man arrested for being involved in theft. Storm in New South Wales and the damages. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 |
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]);