This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41825 | 41825 | 1924-07-19 | 2 | a-b | People in Guangdong are determined to protect themselves, an editorial by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100793 | 24100793 | |
41827 | 41827 | 1924-07-19 | 2 | c-f | Picture of the building of The Sun Sun Company Ltd in Shanghai, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100793 | 24100793 | |
41838 | 41838 | 1924-07-19 | 6 | a-b | Chinese Consulate General in Melbourne writes to the Chinese Chamber of Commerce in New South Wales on the proposed national industrial conference that to be held in Beijing. And the Proposal for the national conference. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100797 | 24100797 | |
41842 | 41842 | 1924-07-19 | 7 | a | Chinese students in New South Wales organise their own association and the constitution. Organisers include students Su Guanqing, Luo Fuquan, Chen Qingyi, Wu Lianyun, Su Yiguang, Xiao Songfen, Ye Lin, Zeng Zhensheng, Liu Xiliang and Zhou You, and their temporary office is in the Lai Gee Club (li zhi hui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 | |
41844 | 41844 | 1924-07-19 | 7 | b | A young man dies in a train accident while another one injured seriously. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 | |
41846 | 41846 | 1924-07-19 | 7 | b-c | Chinese football team explains their travel with Japanese liner. Members of the Chinese football team. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 | |
41847 | 41847 | 1924-07-19 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 | |
41848 | 41848 | 1924-07-19 | 8 | a-d | Guangdong news/ The officialdom in Guangzhou (conflict between Xu Chongzhi and Fan Shisheng, relation between Gu Yingfen and Zou Lu, reconciliation between Sun Yatsen and Chen Jiongming). Illness of Sun Yatsen. Xu Chongzhi controls tax collection in Xinhui and other counties. A circular telegram issued by shareholders of the Guangzhou-Hankou railway. Sun Yatsen borrows loans from Zou Lu. Civil corps organised by the business communities in Guangzhou and their conflict with government troops. The unity of business communities in Nanhai and Heshan counties. Xiqiao in Nanhai county refuses the entry of any government troops. Merchants and residents in Shunde county unite themselves. Pressgang in Taishan and the tragedy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100799 | 24100799 | |
41849 | 41849 | 1924-07-19 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100799 | 24100799 | |
41850 | 41850 | 1924-07-19 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100799 | 24100799 |
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]);