This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56215 | 56215 | 1936-08-29 | 3 | e | Soviet Russian authority releases four Japanese soldiers. | Russia | http://trove.nla.gov.au/newspaper/page/24096969 | 24096969 | |
56224 | 56224 | 1936-08-29 | 8 | e | A naked parade in New York. | America | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
56225 | 56225 | 1936-08-29 | 8 | e | Australia news/ The national defence and the Commonwealth Government. Deadline for the personal income tax. Chinese adventurer Zhang Shangren leaves Australia. Reserve Bank to issue five dollar notes. Trade dispute between Australia and Japan. Japanese immigrant is punished in Darwin for harbouring Aboriginal woman. Shops and factories in NSW are required to register at the state government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 |
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]);