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 |
|---|---|---|---|---|---|---|---|---|---|
| 46768 | 46768 | 1928-02-25 | 2 | b-c | First part of an article written by Guo Shaozong on Japan's privileges in Manchuria and Mongolia and their negotiations with China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098704 | 24098704 | |
| 46769 | 46769 | 1928-02-25 | 2 | c | Jiang Jieshi (Chiang Kai-shek) totally controls the Nationalist Party and the country and some cases. | China | http://trove.nla.gov.au/newspaper/page/24098704 | 24098704 | |
| 46770 | 46770 | 1928-02-25 | 2 | d | Military officers of the north-western army enjoy free courtship and the ban by Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24098704 | 24098704 | |
| 46771 | 46771 | 1928-02-25 | 2 | e | Members of the Nationalist Party in Beijing write to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24098704 | 24098704 | |
| 46772 | 46772 | 1928-02-25 | 2 | e | Sun Chuanfang talks to journalists in Tianjin on the cultural tradition of China. | China | http://trove.nla.gov.au/newspaper/page/24098704 | 24098704 | |
| 46773 | 46773 | 1928-02-25 | 3 | b-c | Tang Shengzhi's troops and his relations with various sides. | China | http://trove.nla.gov.au/newspaper/page/24098703 | 24098703 | |
| 46774 | 46774 | 1928-02-25 | 3 | c | Zhu Peide and Li Zongren write to Jiang Jieshi and the Executive Committee of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24098703 | 24098703 | |
| 46775 | 46775 | 1928-02-25 | 3 | e | Sun Ke, Wu Chaoshu, Hu Hanmin and other members of the Nationalist central committee are going for overseas visit. Feng Yuxiang borrows money from German businessmen and leads his troops to attack Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098703 | 24098703 | |
| 46776 | 46776 | 1928-02-25 | 3 | e | General information about New York. | America | http://trove.nla.gov.au/newspaper/page/24098703 | 24098703 | |
| 46777 | 46777 | 1928-02-25 | 5 | a | Hong Kong news/ Jiang Jieshi and Song Ziwen try to bail out Wang Zongzhu. Trial of Wang Zongzhu and Zhao Pushan in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098705 | 24098705 | |
| 46778 | 46778 | 1928-02-25 | 5 | c | First part of a report on various business activities in Guangzhou last year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098705 | 24098705 | |
| 46779 | 46779 | 1928-02-25 | 7 | a | Li Jishen is doing his best to wipe out the Communist activists from Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098707 | 24098707 | |
| 46780 | 46780 | 1928-02-25 | 7 | a | Jiang Jieshi might retreat once again. | China | http://trove.nla.gov.au/newspaper/page/24098707 | 24098707 | |
| 46781 | 46781 | 1928-02-25 | 7 | a | The Nationalist government in Nanjing might collapse. | China | http://trove.nla.gov.au/newspaper/page/24098707 | 24098707 | |
| 46782 | 46782 | 1928-02-25 | 5 | a | The world is astonished by the rapid development of German naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/24098705 | 24098705 | |
| 46783 | 46783 | 1928-02-25 | 5 | b | Guangzhou and Nanjing authorities have different view on Sun Yatsen's testament. | China | http://trove.nla.gov.au/newspaper/page/24098705 | 24098705 | |
| 46784 | 46784 | 1928-02-25 | 5 | b | Australia news/ The tunnel building for railway in Sydney is to be completed soon. Floods in New South Wales and other states. Prospect for harvest in New South Wales. A father in New South Wales kills his daughter. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098705 | 24098705 | |
| 46785 | 46785 | 1928-02-25 | 8 | a-d | Guangdong news/ Trade unions in Guangzhou are ordered to disband for their collaboration with the Communists. The Communist Party is trying to instigate another strike in Guangzhou. The disbanded trade unions in Shunde county. Feng Zhuwan becomes provincial treasurer once again. The Chinese Communist Party members in Hainan island. Relief work in the Nanhai and other areas after the Communist disaster. Dai Jitao hides in Hong Kong. Electricity company in Guangzhou to be closed because of the deficit. | China | http://trove.nla.gov.au/newspaper/page/24098710 | 24098710 |
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]);