This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54446 | 54446 | 1934-08-25 | 2 | a | Science is the backbone of cultural development, comments by Tung Wah Times editorial. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
54447 | 54447 | 1934-08-25 | 2 | b | China news/ Drought in north China. Shi Yousan seeks to stage a comeback. Gu Weijun on the international affairs. Russia and Japan may have confrontation. Japanese conspiracy in north China. Authority on the railway from Beijing to Shenyang. Ancient graves found in the east of Xuzhou, north Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
54448 | 54448 | 1934-08-25 | 2 | f | Communist leader Chen Duxiu is sentenced. | China | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
54449 | 54449 | 1934-08-25 | 2 | f | The Nanjing government orders to celebrate the birthday of Confucius. | China | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
54450 | 54450 | 1934-08-25 | 2 | f | Chinese troops in Jilin and Heilongjiang and their resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 |
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]);