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 |
|---|---|---|---|---|---|---|---|---|---|
| 51858 | 51858 | 1932-09-03 | 2 | a | Third and final part of editorial by the Tung Wah Times on the open letter from Chen Mingshu to the 19th Route Army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090930 | 24090930 | |
| 51859 | 51859 | 1932-09-03 | 2 | d | Report on the truth of crisis in Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24090930 | 24090930 | |
| 51860 | 51860 | 1932-09-03 | 2 | d | Wang Zhaoming and Zhu Jiahua to discipline the education system in China. | China | http://trove.nla.gov.au/newspaper/page/24090930 | 24090930 | |
| 51861 | 51861 | 1932-09-03 | 2 | e | Wang Zhaoming issues a circular telegram to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090930 | 24090930 | |
| 51862 | 51862 | 1932-09-03 | 2 | f | Nanjing government to develop air force army. Zhang Xueliang appoint Wang Yizhe to command army forces in Rehe. Army commanders to guard Beijing and Tianjin. Japanese in Shanghai set up a post office. Mass movement in Liaoning province to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090930 | 24090930 | |
| 51863 | 51863 | 1932-09-03 | 3 | a | Ma Zhanshan's son Ma Kui leaves Shanghai for the north. | China | http://trove.nla.gov.au/newspaper/page/24090929 | 24090929 | |
| 51864 | 51864 | 1932-09-03 | 3 | c | Japanese invasion of Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24090929 | 24090929 | |
| 51865 | 51865 | 1932-09-03 | 3 | e | Japan purchases more weapons from overseas. | America | http://trove.nla.gov.au/newspaper/page/24090929 | 24090929 | |
| 51866 | 51866 | 1932-09-03 | 5 | a | Second part of an open letter from Chen Mingshu to the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24090932 | 24090932 | |
| 51867 | 51867 | 1932-09-03 | 5 | c | A notice issued by the Chinese Chamber of Commerce in New South Wales on the exports to China. Regulations issued by the Chinese government on the exports to China (by overseas Chinese businessmen). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090932 | 24090932 | |
| 51868 | 51868 | 1932-09-03 | 6-7 | a-g | Guangdong news/ Movement in Guangdong to eliminate the Communist forces. Communist troops invade Guangdong. A talk by Zhang Huichang. Li Qingwen arrives Hong Kong. Tan Qixiu on the way to Xiamen, Fujian province. Jiang Guanglai in his hometown. Newspapers in Guangdong appeal for support to the volunteer armies in Manchuria in their fighting Japanese invaders. Bridge project on Zhujiang River to be completed. Chen Jitang to organise a new army. Government troops in Chaozhou and Shantou to suppress the communists. Martial law proclaimed in the Dongjiang area. Bandits in Taishan county. Prisoners run away in Zhongshan county. Bandits in Enping county eat human flesh. | China | http://trove.nla.gov.au/newspaper/page/24090934 | 24090934 | |
| 51869 | 51869 | 1932-09-03 | 8 | a | Japanese Prime Minister seeks recognition of the Manchurian state. | Japan | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
| 51870 | 51870 | 1932-09-03 | 8 | b | Attitude of the American government towards Japan. | America | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
| 51871 | 51871 | 1932-09-03 | 8 | b | Delegation of the League of Nation recognises Manchuria as Chinese territory. | Other... | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
| 51872 | 51872 | 1932-09-03 | 8 | c | Deterioration of relations between Japan and America. | Japan | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
| 51873 | 51873 | 1932-09-03 | 8 | c | Prince of Japan helps the flooding relief in north Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
| 51874 | 51874 | 1932-09-03 | 8 | c | Report prepared by the delegation of the League of Nations on the Chinese situation. | China | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
| 51875 | 51875 | 1932-09-03 | 8 | d | Chinese volunteer army fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
| 51876 | 51876 | 1932-09-03 | 8 | d | Chinese sailors on strike on aboard of British ship. | Britain | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
| 51877 | 51877 | 1932-09-03 | 8 | d | A speech by Luo Wengan. | China | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 | |
| 51878 | 51878 | 1932-09-03 | 8 | e | Australia news/ Chinese communities in Sydney welcome Zhao Yu. Tariff increased for the Chinese textile products and the protest by Chinese Chamber of Commerce in Sydney. Mid-Autumn cakes available from the Lean Sun Low & Co, Sydney. New moves of Chinese consul in Auckland and Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090936 | 24090936 |
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]);