This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39808 | 39808 | 1923-05-05 | 2 | a-b | Second and final part of an editorial on the role and function of the army in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094392 | 24094392 | |
| 39809 | 39809 | 1923-05-05 | 2 | b | Special report from Hong Kong says Guangzhou is quiet now and gunshots heard only in the northwest. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24094392 | 24094392 | |
| 39810 | 39810 | 1923-05-05 | 2 | b-c | General Commercial Chamber in Shanghai condemn the national parliament in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094392 | 24094392 | |
| 39811 | 39811 | 1923-05-05 | 2 | c-d | Japanese government publicly replies to China on the Twenty-one Demands. | Japan | http://trove.nla.gov.au/newspaper/page/24094392 | 24094392 | |
| 39812 | 39812 | 1923-05-05 | 2 | d-e | Conditions for the possible alliance between Sun Yatsen, Duan Qirui and Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24094392 | 24094392 | |
| 39813 | 39813 | 1923-05-05 | 2 | e-f | Portuguese ambassador makes inquiry to the Beijing authority in regards to Sun Yatsen's effort to borrow foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24094392 | 24094392 | |
| 39814 | 39814 | 1923-05-05 | 3 | a | Telegrams from Wu Peifu to Zhang Shaozeng in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094391 | 24094391 | |
| 39815 | 39815 | 1923-05-05 | 3 | a-b | Zhang Shaozeng's cabinet and Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24094391 | 24094391 | |
| 39816 | 39816 | 1923-05-05 | 3 | b-d | Wu Chaoshu writes to Bai Yuyuan on the tariff changes. | China | http://trove.nla.gov.au/newspaper/page/24094391 | 24094391 | |
| 39817 | 39817 | 1923-05-05 | 3 | d-f | Bai Yuyuan explains why he is against Sun Yatsen, Part I. | China | http://trove.nla.gov.au/newspaper/page/24094391 | 24094391 | |
| 39818 | 39818 | 1923-05-05 | 3 | f | Cao Kun and Wu Peifu are both against Sun Yatsen's marshal headquarters. | China | http://trove.nla.gov.au/newspaper/page/24094391 | 24094391 | |
| 39819 | 39819 | 1923-05-05 | 6 | a-b | Communists make trouble in the world, comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094396 | 24094396 | |
| 39820 | 39820 | 1923-05-05 | 6 | b-c | Second and final part of a speech delivered by Liang Qichao to the students in zhongguo gongxue, Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094396 | 24094396 | |
| 39821 | 39821 | 1923-05-05 | 6 | d | American government negotiates with Chinese authority over the murder of American missionary. | Britain | http://trove.nla.gov.au/newspaper/page/24094396 | 24094396 | |
| 39822 | 39822 | 1923-05-05 | 7 | a | Daily Mail in London reports that Red Army and Communists make trouble in Poland. | Britain | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
| 39823 | 39823 | 1923-05-05 | 7 | a | An employee of the British-American Tobacco Company is kidnapped by bandits in Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
| 39824 | 39824 | 1923-05-05 | 7 | a | Truce and peace talks in Ireland. | Britain | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
| 39825 | 39825 | 1923-05-05 | 7 | a | American consuls in Harbin and Chita are returning. | America | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
| 39826 | 39826 | 1923-05-05 | 7 | a-b | An Irish missionary is prohibited to speak publicly in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
| 39827 | 39827 | 1923-05-05 | 7 | b | A fire in Rockhampton, Queensland, destroys more than 30 shops. | Australia | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
| 39828 | 39828 | 1923-05-05 | 7 | b | A young man in North Sydney is detained for sexual harassment. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
| 39829 | 39829 | 1923-05-05 | 7 | b | A survey on railway operation and profit in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
| 39830 | 39830 | 1923-05-05 | 7 | c | Japanese businessmen want to purchase liner route to Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
| 39831 | 39831 | 1923-05-05 | 8 | a-d | Guangdong news/ Provincial governor Xu Shaozheng issues a public notice on local civil administration. Railway passengers on the Guangzhou-Kowloon line are prohibited to travel with weapons. Pessimism on fiscal situation in Guangdong. Army from the north arrive Nanxiong. A female spy arrested in Guangzhou. Sun Yatsen's offers to foreign loans. Self-defence army organised in Xiangshan county. Governor Xu Shaozheng promotes Confucianism. Sun Yatsen arrives Yongxiang. Sun Yatsen is urged to disband Hu Wencan's troops. Chen Dechun's property in Guangzhou will be protected by Li Yibiao. Damages of war in Zhaoqing. Sun Yatsen orders Zhou Zhizheng, Chen Ce and Liang Hongkai to take over Jiangmen. Looting in Kaiping county. Sun Yatsen and Chen Ce. Chen Dechun retreats to Kaiping and Enping. Civil corps occupy Enping. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094398 | 24094398 | |
| 39832 | 39832 | 1923-05-05 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094398 | 24094398 | |
| 39833 | 39833 | 1923-05-05 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094398 | 24094398 |
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]);