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 |
---|---|---|---|---|---|---|---|---|---|
54314 | 54314 | 1934-07-14 | 3 | e | Portugal denies transfer of Timor to Japan. | Other... | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
54315 | 54315 | 1934-07-14 | 3 | e | British textile experts come to train Chinese technicians in China. | Britain | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
54316 | 54316 | 1934-07-14 | 3 | e | America to restrict import of Japanese goods. | America | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
54317 | 54317 | 1934-07-14 | 3 | e | Japanese school set up in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096083 | 24096083 | |
54327 | 54327 | 1934-07-14 | 6 | e | Australia news/ Federal election to be held. Deputy Prime Minister quit politics. Aboriginal people in Darwin beat Chinese. Italian man arrested in Sydney for opium smuggling. Number of population in New South Wales. China purchase Australian flour. Arms smuggling in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 |
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]);