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 |
|---|---|---|---|---|---|---|---|---|---|
| 50250 | 50250 | 1931-05-02 | 2 | b | First part of editorial on the negotiations between China and Japan over the Manchurian railways. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090365 | 24090365 | |
| 50251 | 50251 | 1931-05-02 | 2 | c | Zhang Xueliang purchases more war planes. Mongolian delegates demands the rights of self-government. Civil corps in the south of Fujian province prepare for war. Military officers arrested in Beijing for opium smuggling. Women workers of the silk factory in Shanghai on strike. China and Britain reach agreement on the refund of the Boxer Indemnity. Wu Peifu is leaving China for an overseas tour. Jiang Jieshi to start the presidential system and the obstacles. Truth of the political changes in Yunnan province. Japanese troops in Tianjin and their collaboration with bandits. Shi Yousan is detained and the report. Communist troops loot suburbs of Wuchang. The Communist troops in Wuhan. People of Shenyang are angry with Japanese. Government troops fight bandits in Suining, north Jiangsu province. Tibet troops approach the Sichuan border. The internal fighting in Sichuan. Japanese authority dispatches more troops to Qinhuangdao, Hebei province. Workers of the Japanese textile factory in Qinhuangdao on strike. | China | http://trove.nla.gov.au/newspaper/page/24090365 | 24090365 | |
| 50252 | 50252 | 1931-05-02 | 3 | a | News from Yunnan on the political changes there. | China | http://trove.nla.gov.au/newspaper/page/24090364 | 24090364 | |
| 50253 | 50253 | 1931-05-02 | 3 | a | White Russian commander to fight the communists. | France | http://trove.nla.gov.au/newspaper/page/24090364 | 24090364 | |
| 50254 | 50254 | 1931-05-02 | 3 | b | Disasters of communism, banditry and opium in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090364 | 24090364 | |
| 50255 | 50255 | 1931-05-02 | 3 | c | Japanese seek to expand their industries in China. | Japan | http://trove.nla.gov.au/newspaper/page/24090364 | 24090364 | |
| 50256 | 50256 | 1931-05-02 | 3 | d | Zou Zuohua on an overseas tour for agricultural investigation. | China | http://trove.nla.gov.au/newspaper/page/24090364 | 24090364 | |
| 50257 | 50257 | 1931-05-02 | 3 | e | Chinese deputy consul to San Francisco Gao Yao is sentenced for opium smuggling. | China | http://trove.nla.gov.au/newspaper/page/24090364 | 24090364 | |
| 50258 | 50258 | 1931-05-02 | 3 | e | Zhang Xueming is sworn in as mayor of Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24090364 | 24090364 | |
| 50259 | 50259 | 1931-05-02 | 5 | a | Hong Kong news/ Cases of defraud in Hong Kong. Counterfeit bank notes in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090366 | 24090366 | |
| 50260 | 50260 | 1931-05-02 | 5 | c | A miser and his story. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090366 | 24090366 | |
| 50261 | 50261 | 1931-05-02 | 5 | d | A story of cheating and marriage. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090366 | 24090366 | |
| 50262 | 50262 | 1931-05-02 | 5 | d | First part of story of Liu Jie. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090366 | 24090366 | |
| 50263 | 50263 | 1931-05-02 | 6-7 | a-d | Guangdong news/ Zhang Fakui organises civil corps in Guangxi. Operation of the coach services in Guangzhou. Guangxi authority on the opening of the Longguan customs. All houses in local villages are applicable to taxation. Protest against the tax on fabrics. A bomb explosion in Guangzhou. A visitor returned from Nanjing on the case of Hu Hanmin. Local counties required to set up bureau for land administration. A robbery in Zhongshan county. Zhongshan county government investigates the financial scandal. A joint defence conference of the Guangzhou suburbs. Clan fighting in Zengcheng county and the response of government authority. | China | http://trove.nla.gov.au/newspaper/page/24090369 | 24090369 | |
| 50264 | 50264 | 1931-05-02 | 8 | b | A Spanish warship defects under the instigation of communists. | Britain | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
| 50265 | 50265 | 1931-05-02 | 8 | b | America recognises new government of Spain. | America | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
| 50266 | 50266 | 1931-05-02 | 8 | b | American missionary is kidnapped in Hubei, China. | China | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
| 50267 | 50267 | 1931-05-02 | 8 | b | American government increases charges of some services including air mail. | America | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
| 50268 | 50268 | 1931-05-02 | 8 | b | Australia news/ Arsonist arrested in Sydney. A mail bomb in Sydney. Tram accident in Sydney. Earthquake in New Zealand. NSW state government repays debts to Britain. Another reduction of salary payment in Australia. The Savings Bank of New South Wales is closed down. Communist members make trouble in a government meeting. Heavy rains in the west of NSW. Two bodies found in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 | |
| 50269 | 50269 | 1931-05-02 | 8 | e | A notice for tea party by the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090371 | 24090371 |
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]);