This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54762 | 54762 | 1935-01-05 | 2 | a | New Year's greetings from Tung Wah Times and the hope for 1935. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096279 | 24096279 | |
54763 | 54763 | 1935-01-05 | 2 | b | The communist disasters in Jiangxi and Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24096279 | 24096279 | |
54764 | 54764 | 1935-01-05 | 2 | c | The independence movement in Korea. | China | http://trove.nla.gov.au/newspaper/page/24096279 | 24096279 | |
54765 | 54765 | 1935-01-05 | 2 | d | Ji Hongchang and Ren Yingqi are executed for their collaboration with the communists. Wang Chonghui meets Jiang Jieshi in Nanjing and their discussions. Import of perfume increased significantly. Jiang Jieshi sends photographer to make a film about northwest China. All communists in Fujian province are eradicated already. Chinese foreign ministry prohibits its diplomats from marrying foreign women. Huang Fu is appointed Minister of Internal Affairs. | http://trove.nla.gov.au/newspaper/page/24096279 | 24096279 |
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]);