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 |
---|---|---|---|---|---|---|---|---|---|
54794 | 54794 | 1935-01-19 | 2 | b | Editorial on the victory of suppression of communists in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096295 | 24096295 | |
54801 | 54801 | 1935-01-19 | 5 | a | The fourth part of a study on the development of the northwest China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096296 | 24096296 | |
54802 | 54802 | 1935-01-19 | 5 | c | A breakfast of Napoleon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096296 | 24096296 | |
54807 | 54807 | 1935-01-19 | 6 | d | Australia news/ Storm in Victoria and the damages. Chinese ferry in Melbourne has an accident. Chinese swimmer Guo Zhenheng joins the competition in Canberra. Chinese government murders journalists. Japanese are very confident in the New Year. Chinese General Qiu Zhaoshen tours Albury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096299 | 24096299 |
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]);