This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54477 | 54477 | 1934-09-01 | 6 | a | Britain and Japan may re-establish an alliance. Conspiracy of Britain and Japan in Asian region. | Japan | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
54478 | 54478 | 1934-09-01 | 6 | a | Kidnap in New York. | America | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
54479 | 54479 | 1934-09-01 | 6 | b | American farmers request to deport Japanese immigrants. | America | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
54480 | 54480 | 1934-09-01 | 6 | c | More report on the conflicts between Russia and Japan over the railway ownership. | China | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 | |
54481 | 54481 | 1934-09-01 | 6 | e | Australia news/ Visitor to the East talks about the business there. Chinese man detained in Darwin for opium smuggling. Foreign lotteries are not permitted to sell in Sydney. St Mary Church is burgled in Sydney. Chinese magician Huang Caixin and his performance in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096146 | 24096146 |
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]);