This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54571 | 54571 | 1934-10-06 | 2 | e | Japanese are busying preparing for the war with Russian. | China | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
54572 | 54572 | 1934-10-06 | 2 | e | Liu Guitang organises East Asian Republic Army in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
54577 | 54577 | 1934-10-06 | 3 | e | Britain prepares for war and the attitudes of its colonies. | Britain | http://trove.nla.gov.au/newspaper/page/24096181 | 24096181 | |
54589 | 54589 | 1934-10-06 | 6 | e | Australia news/ Statistics about Australia for the first half of this year. The Labour Party is defeated in the federal election. Performance of Chinese boxing coach Huang Boquan. Population on the Nauru island. More European women are smoking. Furniture industry in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 |
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]);