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 |
|---|---|---|---|---|---|---|---|---|---|
| 47578 | 47578 | 1928-11-17 | 2 | b | Editorial on the abolition of likin in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099018 | 24099018 | |
| 47579 | 47579 | 1928-11-17 | 2 | c | Meeting of the Central Executive Committee of the Nationalist Party and its resolutions. | China | http://trove.nla.gov.au/newspaper/page/24099018 | 24099018 | |
| 47580 | 47580 | 1928-11-17 | 2 | c | The Nanjing government condemns Yan Xishan but welcomes Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24099018 | 24099018 | |
| 47581 | 47581 | 1928-11-17 | 2 | d | Foreign missions suggest China to start a unified tax rate throughout the country. | China | http://trove.nla.gov.au/newspaper/page/24099018 | 24099018 | |
| 47582 | 47582 | 1928-11-17 | 2 | d | New members of the Nationalist government elected in Nanjing including Jiang Jieshi, Tan Yankai, Hu Hanmin, Cai Yuanpei, Dai Jitao, Wang Chonghui, Feng Yuxiang, Sun Ke, Chen Guofu, He Yingqin, Li Zongren, Yang Shuzhuang, Yan Xishan, Li Jishen, and Lin Sen. The Nationalist government in Nanjing to issue some more bonds in order to raise funds. | China | http://trove.nla.gov.au/newspaper/page/24099018 | 24099018 | |
| 47583 | 47583 | 1928-11-17 | 2 | e | Japanese troops in Jinan have an military exercise. | China | http://trove.nla.gov.au/newspaper/page/24099018 | 24099018 | |
| 47584 | 47584 | 1928-11-17 | 2 | f | Current situation in Sichuan province is still pessimistic. | China | http://trove.nla.gov.au/newspaper/page/24099018 | 24099018 | |
| 47585 | 47585 | 1928-11-17 | 3 | b | Foreign minister Wang Zhengting on the foreign policy of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24099017 | 24099017 | |
| 47586 | 47586 | 1928-11-17 | 3 | c | Soviet Russia control the economy in north Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099017 | 24099017 | |
| 47587 | 47587 | 1928-11-17 | 3 | d | Students in Beijing and the school life. | China | http://trove.nla.gov.au/newspaper/page/24099017 | 24099017 | |
| 47588 | 47588 | 1928-11-17 | 3 | f | Chinese Maritime Customs Bureau moves its office to Nanjing and the report. | China | http://trove.nla.gov.au/newspaper/page/24099017 | 24099017 | |
| 47589 | 47589 | 1928-11-17 | 3 | f | Preparation for the third national congress of the Nationalist Party in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099017 | 24099017 | |
| 47590 | 47590 | 1928-11-17 | 5 | a | Hong Kong news/ Journalism in Hong Kong and their attitude towards foreign invasion. Chinese and British warships jointly suppress pirates near Hong Kong. Sugar and ginger shops in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099019 | 24099019 | |
| 47591 | 47591 | 1928-11-17 | 6-7 | a-d | Guangdong news/ Military headquarters orders to disband all self-defence street associations. The Communists in Haifeng county. Arrest of Communist Party members in Guangzhou on the National Day of October 10. Precautions against the Communist Party in Guangzhou. Chen Jitang is keen to promote new education. Businessmen protest against new levies. Group of Soviet Russian tourists arrive Guangdong. Social custom in Chaozhou. Many bandits from north Guangzhou are fleeing to Nanyang. News from Taishan county. The Yao minority people elect their chief of tribe. Ancient tablet found in Huizhou. Bandits rob mails in Xinhui county. | China | http://trove.nla.gov.au/newspaper/page/24099022 | 24099022 | |
| 47592 | 47592 | 1928-11-17 | 8 | a | Emperor of Japan is enthroned. | Japan | http://trove.nla.gov.au/newspaper/page/24099024 | 24099024 | |
| 47593 | 47593 | 1928-11-17 | 8 | a | A ship sinks near New York. | America | http://trove.nla.gov.au/newspaper/page/24099024 | 24099024 | |
| 47594 | 47594 | 1928-11-17 | 8 | a-c | Australia news/ Chinese passenger from Fijin is stolen on his way to Sydney. A white girl is robbed in Sydney. Federal election and the comments by election commissioner. Wool export from Australia last year. Gypsy people and their women. A letter from postal service authority to the readers of the Tung Wah Times. People in south Europe celebrate the National Day of Soviet Russia. Pirates hijack ship near Xiamen, of Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099024 | 24099024 |
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]);