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 |
|---|---|---|---|---|---|---|---|---|---|
| 50749 | 50749 | 1931-10-03 | 2 | b | Tung Wah Times comments on Japanese invasion of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090543 | 24090543 | |
| 50750 | 50750 | 1931-10-03 | 2 | c | Xinjiang authority in northwest China requests military assistance to suppress bandits. Muslims in the northwest ask for help to their school education. Gold transported from Shanghai to New York. Conspiracy of the Comintern for communist propaganda in China. A reply from Japan on the Jilin Incident. Floods in Wuhan. Bandits in Jiangxi province. Finnish people set up factory in China without licence. Wang Zhengting on the foreign affairs and the anti-Chinese movement in Mexico. Chinese in Korea experience another panic. Nanjing government appropriates funds for disaster relief. Floods in Henan province and Wuhu, of Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24090543 | 24090543 | |
| 50751 | 50751 | 1931-10-03 | 3 | a | Japanese army officer disappears in China and the investigation. | China | http://trove.nla.gov.au/newspaper/page/24090542 | 24090542 | |
| 50752 | 50752 | 1931-10-03 | 3 | b | Japan's preparation for military action in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090542 | 24090542 | |
| 50753 | 50753 | 1931-10-03 | 3 | b | Changchun, capital of Jilin province, under the Japanese rule. | China | http://trove.nla.gov.au/newspaper/page/24090542 | 24090542 | |
| 50754 | 50754 | 1931-10-03 | 5 | a | Special report on the atrocities of Japanese troops in China. | China | http://trove.nla.gov.au/newspaper/page/24090544 | 24090544 | |
| 50755 | 50755 | 1931-10-03 | 5 | c | Japanese in Manchuria support the invasion of China. | China | http://trove.nla.gov.au/newspaper/page/24090544 | 24090544 | |
| 50756 | 50756 | 1931-10-03 | 5 | e | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090544 | 24090544 | |
| 50757 | 50757 | 1931-10-03 | 5 | e | The Chinese Chamber of Commerce in Sydney to celebrate the National Day on October and the birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090544 | 24090544 | |
| 50758 | 50758 | 1931-10-03 | 5 | e | Business for sale in Greymouth, New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090544 | 24090544 | |
| 50759 | 50759 | 1931-10-03 | 6-7 | a-d | Guangdong news/ Military situations on the northeast border of Guangdong. Poultry businessmen in Guangzhou request to abolish export taxes. Effort of the Government to monopolise sales of tobacco products. Land registration in Guangzhou. Bandits in Guangzhou kidnap victims with car. Standard for the payment of business tax in Guangzhou. Guangzhou to build the Wongjiang River hydroelectric station. Restaurants in Guangzhou and the taxes on luxurious banquet. Dancing in the park is prohibited in Guangzhou. Labour disputes in the Guangzhou tea houses. Military conflict in the Beijiang area affects business activities. Police in Shantou arrest reactionaries. Shantou customs authority implement regular health quarantine on all incoming ships. News from Dongguan. Pressgang in local Guangdong. Bandits in Taishan. Tax on tobacco products in Xinhui. Prison guard in Taishan rape female convicts. Sales of military bonds in Taishan. Police in Zhongshan destroy opium smoking paraphernalia. Bandits in Zengcheng and Nanhai county. A baby in Huiyang is like monkey. | China | http://trove.nla.gov.au/newspaper/page/24090547 | 24090547 | |
| 50760 | 50760 | 1931-10-03 | 8 | a | The League of Nations mediate the conflict between China and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50761 | 50761 | 1931-10-03 | 8 | a | Japan dispatches naval fleet to Shanghai. | Japan | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50762 | 50762 | 1931-10-03 | 8 | a | Chinese nationals in Hong Kong have demonstration against Japan and the violence. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50763 | 50763 | 1931-10-03 | 8 | a | Japanese ambassador in Washington denies any invasion of Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50764 | 50764 | 1931-10-03 | 8 | a | Japan says Chinese side deliberately provoke the conflict in Manchuria. Japanese war planes bomb trains in Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50765 | 50765 | 1931-10-03 | 8 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50766 | 50766 | 1931-10-03 | 8 | b | Bandits hijack trains between Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50767 | 50767 | 1931-10-03 | 8 | b | Demonstrations in Nanjing and other cities request Chinese government to declare war on Japan. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50768 | 50768 | 1931-10-03 | 8 | c | Rumours on the independence of Manchuria and Mongolia. | Japan | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50769 | 50769 | 1931-10-03 | 8 | c | Chinese Communist Party requests to atone for their crimes by doing good deeds. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50770 | 50770 | 1931-10-03 | 8 | c | The League of Nations to discuss the Manchuria issues. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50771 | 50771 | 1931-10-03 | 8 | c | Police in Hong Kong shoot Chinese nationals. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50772 | 50772 | 1931-10-03 | 8 | c | Chinese communities in Sydney organise an association to fight Japanese and to save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
| 50773 | 50773 | 1931-10-03 | 8 | e | Chinese passengers write in praise of services on board of liner Danda. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 |
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]);