This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54664 | 54664 | 1934-11-17 | 2 | a | Editorial on the national heroes in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096232 | 24096232 | |
54665 | 54665 | 1934-11-17 | 2 | c | China news/ Celebrations on the National Day in China. Japanese troops in Manchuria to have an exercise. Jiang Jieshi and Zhang Xueliang to Luoyang in Henan province. Chinese government negotiates with Japan on the deportation of Chinese immigrants. Jiang Bocheng arrives Shanghai from Guangzhou. Jiang Jieshi and his strategies to eradicate the communists. Airport building in Hengyang, Hunan province. Gu Zhutong dies in an air accident. Disasters in south Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24096232 | 24096232 |
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]);