This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54808 | 54808 | 1935-01-26 | 2 | a | Notice issued by the Chinese Chamber of Commerce in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096303 | 24096303 | |
54809 | 54809 | 1935-01-26 | 2 | a | Notice issued by Ye Bingnan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096303 | 24096303 | |
54810 | 54810 | 1935-01-26 | 2 | a | Notice issued by Chinese General Qiu Zhaoshen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096303 | 24096303 | |
54811 | 54811 | 1935-01-26 | 2 | a | Advertisement of the Wing On Bank, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096303 | 24096303 | |
54812 | 54812 | 1935-01-26 | 2 | b | Editorial on the freedom of speech in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096303 | 24096303 | |
54813 | 54813 | 1935-01-26 | 2 | c | Jiang Jieshi flies to Shanghai. Shang Lizi talks in Xuzhou, north Jiangsu province. Comet seen in Tangshan, Hebei province. Huang Shaoxiong to Zhejiang. Railway construction in Shandong. Chen Cheng on the victory of suppression of the communist troops in Fujian. Liu Xiang on the way to Nanjing. Yan Xishan observes a period of mourning for his deceased father. Construction of the Longhai railway to be completed. | China | http://trove.nla.gov.au/newspaper/page/24096303 | 24096303 |
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]);