This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42053 | 42053 | 1924-09-06 | 7 | a | The Chinese Chamber of Commerce in New South Wales to have an emergency meeting on the situations in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100852 | 24100852 | |
42054 | 42054 | 1924-09-06 | 7 | a | A Chinese missionary is brought to the Parramatta court for kicking policeman. | Australia | http://trove.nla.gov.au/newspaper/page/24100852 | 24100852 | |
42055 | 42055 | 1924-09-06 | 7 | a | Thieves visit a restaurant on George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100852 | 24100852 | |
42056 | 42056 | 1924-09-06 | 7 | a | Bank robbery in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100852 | 24100852 | |
42057 | 42057 | 1924-09-06 | 7 | b | Governor of Jiangsu province Qi Xieyuan prepares for war with Lu Yongxiang of Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24100852 | 24100852 | |
42058 | 42058 | 1924-09-06 | 7 | b | Wu Peifu is preparing for a war with Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24100852 | 24100852 | |
42059 | 42059 | 1924-09-06 | 7 | b | H. L. & S. Simpson & Company Ltd to build a big department store for China product at 414 - 418 Pitt Street, Sydney, and raises funds by floating shares. Directors of the company include Li Rufu, Guo Chao, Huang Zhu, Li Chun, Chen Zanhua, Li Xiangbo, Ye Bingyuan, Zhang Maokuan, Ouyang Nan, Wu Jianquan, Wu Zizhi, Cong Yefang, Zhang Fu, Wu Elou, Li Shaoqin, Wu Hongnan an other Chinese shops in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100852 | 24100852 |
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]);