This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42076 | 42076 | 1924-09-13 | 7 | a | A notice issued by the Chinese Consul-General in Melbourne Wei Zijiu on the personnel changes in the consulate. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100860 | 24100860 | |
42077 | 42077 | 1924-09-13 | 7 | a | A Sydney court orders Chinese missionary to pay penalty for kicking a policeman but the priest refused. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100860 | 24100860 | |
42078 | 42078 | 1924-09-13 | 7 | a | Urgent telegram from Guangzhou commercial self-defence association to the Chinese Chamber of Commerce in New South Wales on their concession to Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100860 | 24100860 | |
42079 | 42079 | 1924-09-13 | 7 | a | Guangdong situation also changes following the war between Zhejiang and Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24100860 | 24100860 | |
42080 | 42080 | 1924-09-13 | 7 | a-b | Zhang Zuolin declares war with the central government in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100860 | 24100860 | |
42081 | 42081 | 1924-09-13 | 7 | b | The war between Jiangsu and Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24100860 | 24100860 | |
42082 | 42082 | 1924-09-13 | 7 | b | Sun Yatsen delays the north expedition. | China | http://trove.nla.gov.au/newspaper/page/24100860 | 24100860 | |
42083 | 42083 | 1924-09-13 | 7 | b | A notice by the Chinese Chamber of Commerce in New South Wales for an emergency meeting on the Guangdong situation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100860 | 24100860 | |
42084 | 42084 | 1924-09-13 | 7 | c-d | 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/24100860 | 24100860 |
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]);