This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41391 | 41391 | 1924-04-12 | 2 | a-c | Second and final part of the editorial on the fast replacement of politicians one after another in China (Yuan Shikai, Duan Qirui, Feng Guozhang, Xu Shichang, Li Yuanhong, Sun Yatsen, Chen Jiongming, Tang Jiyao, Lu Yongxiang and many others). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100680 | 24100680 | |
41412 | 41412 | 1924-04-12 | 7 | b | Sydney welcomes the arrival of British naval fleet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100683 | 24100683 | |
41414 | 41414 | 1924-04-12 | 7 | b-c | A circus performance in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100683 | 24100683 | |
41416 | 41416 | 1924-04-12 | 7 | c-d | Recent battle in Dongjiang area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100683 | 24100683 | |
41417 | 41417 | 1924-04-12 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100683 | 24100683 | |
41418 | 41418 | 1924-04-12 | 7 | e | A notice issued by the Chinese Consulate General in Melbourne says some government bonds can be cashed now. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100683 | 24100683 | |
41419 | 41419 | 1924-04-12 | 8 | a-d | Guangdong news/ Sun Yatsen starts his communist policy in order to collect more army provisions. Wu Tiecheng orders to bring 45 pirates to trial in Xiangshan county. Sale of public property in Guangzhou. Many shops are under reconstruction in Gaoyao county after the army's looting and the detailed report. Zengcheng people complain about their magistrate Huang Guomin and the investigation. Army looting in Xinhui county town. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100686 | 24100686 | |
41420 | 41420 | 1924-04-12 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100686 | 24100686 | |
41421 | 41421 | 1924-04-12 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100686 | 24100686 |
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]);