This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 41796 | 41796 | 1924-07-12 | 2 | a-b | Editorial on Xu Chongzhi and his relationship with armies from other provinces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100785 | 24100785 | |
| 41797 | 41797 | 1924-07-12 | 2 | c-e | Tang Jiyao talks about the current situations in China and his attitude. | China | http://trove.nla.gov.au/newspaper/page/24100785 | 24100785 | |
| 41798 | 41798 | 1924-07-12 | 2 | e-f | Picture of the building of The Sun Sun Company Ltd in Shanghai, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100785 | 24100785 | |
| 41799 | 41799 | 1924-07-12 | 2 | f | American ambassador to China meets American merchants and missionaries in Shanghai, and claims that China returns evil for good. | China | http://trove.nla.gov.au/newspaper/page/24100785 | 24100785 | |
| 41800 | 41800 | 1924-07-12 | 3 | a-b | Zhang Xiaoruo, son of industrialist Zhang Qian, talks in Shanghai his tour and industrial investigation to American and European countries. | China | http://trove.nla.gov.au/newspaper/page/24100784 | 24100784 | |
| 41801 | 41801 | 1924-07-12 | 3 | b-c | Fengtian (Zhang Zuolin) and Zhili (Cao Kun) are still preparing for war, another report. | China | http://trove.nla.gov.au/newspaper/page/24100784 | 24100784 | |
| 41802 | 41802 | 1924-07-12 | 3 | c-d | Wu Peifu in Luoyang, Henan province, is busy with training his troops. | China | http://trove.nla.gov.au/newspaper/page/24100784 | 24100784 | |
| 41803 | 41803 | 1924-07-12 | 3 | d-e | Governor of Zhili province Wang Chengbin orders that hair style should follow Chinese tradition. | China | http://trove.nla.gov.au/newspaper/page/24100784 | 24100784 | |
| 41804 | 41804 | 1924-07-12 | 3 | e | Liang Jianhong and other Guomindang members in Sumatara send their letter of protest to Sun Yatsen for his communist policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100784 | 24100784 | |
| 41805 | 41805 | 1924-07-12 | 3 | f | Chinese Premier Sun Baoqi and his cabinet have resigned. | China | http://trove.nla.gov.au/newspaper/page/24100784 | 24100784 | |
| 41806 | 41806 | 1924-07-12 | 3 | f | British police seize weapons smuggled to Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24100784 | 24100784 | |
| 41807 | 41807 | 1924-07-12 | 3 | f | Tram workers in Japan are on strike. | China | http://trove.nla.gov.au/newspaper/page/24100784 | 24100784 | |
| 41808 | 41808 | 1924-07-12 | 6 | a | Chinese business community in Sydney farewells Tang Longxiang and thanks for his contributions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
| 41809 | 41809 | 1924-07-12 | 6 | b-d | The new restriction issued by American authority to the Chinese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
| 41810 | 41810 | 1924-07-12 | 6 | d | Shareholders meeting of the Shanghai Wing On Textile Company Ltd in Sydney and election of the board directors including Guo Le, Guo Quan, Ma Zuxing, Yang Huiting, Guo Biao, Guo Ruixiang, Du Zewen, Lin Haichou, Guo Yongshao, Hu Yaoting, Li Yanxiang, Guo Xianwen, Ouyang Minqing, Chen Zhuchen, Guo Ganxun, Liu Shengchu, and Li Jiongtang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
| 41811 | 41811 | 1924-07-12 | 6 | d-e | Anti-Chinese movement in Peru. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
| 41812 | 41812 | 1924-07-12 | 7 | a | Xia Congzhou reports from Hong Kong the heavy flooding in Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41813 | 41813 | 1924-07-12 | 7 | a | Zhi Gong Tang in Sydney farewells Tang Longxiang on his return to China. And speakers include Huang Zhu, Wu Gen, Wu Elou, Ye Bingnan, Liu Guangfu, Li Xiangbo, Peng Lichuan, Tang Longxiang and white guests. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41814 | 41814 | 1924-07-12 | 7 | b | Sydney Chinese communities farewell Tang Longxiang, Ye Tonggui, Ye Bingnan and Huang Zaihong, who are returning to China by Victoria, passenger liner of the China-Australia Steamship Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41815 | 41815 | 1924-07-12 | 7 | b | State government of New South Wales and the Salvation Army help the unemployed and homeless people in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41816 | 41816 | 1924-07-12 | 7 | b | Body of baby girl is found in Manly, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41817 | 41817 | 1924-07-12 | 7 | b | Three bandits are detained for trying to steal a car owned by Chilean consul. | Australia | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41818 | 41818 | 1924-07-12 | 7 | b | Dozens of Chinese and white gamblers are arrested in Little Bourke Street, Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41819 | 41819 | 1924-07-12 | 7 | b-c | Chinese football team arrives Sydney on their way to New Zealand. Chinese communities in Sydney refuse to welcome the football team because they travel by Japanese liner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41820 | 41820 | 1924-07-12 | 7 | c | Guangdong army defeat the united armies in Pinghu area, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41821 | 41821 | 1924-07-12 | 7 | c | Farewell message by Xu Yaoyuan and Xu Chengjun on the return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100788 | 24100788 | |
| 41822 | 41822 | 1924-07-12 | 8 | a-d | Guangdong news/ Sun Yatsen to cancel the subsidy for propaganda. Guangdong officials once prepared tax regulation for all herbal shops. Commercial associations in the north suburbs of Guangzhou are ready to counterattack the government troops. Villagers in Nanhai county complain the troops looting. The Guomindang central committee requires all members to pay their membership fee. The office to deal with aftermath affairs to be abolished. Pawn shops to be closed for a strike. Hu Hanmin talks about the provincial governorship. Looting in Enping county. Robbery in Xinhui county. Big battle on the way between Guangdong and the united armies. Another report on the battle in Dongjiang area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100791 | 24100791 | |
| 41823 | 41823 | 1924-07-12 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100791 | 24100791 | |
| 41824 | 41824 | 1924-07-12 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100791 | 24100791 |
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]);