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 |
---|---|---|---|---|---|---|---|---|---|
45844 | 45844 | 1927-06-25 | 3 | b | Yang Yuting and his talks in Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
45839 | 45839 | 1927-06-25 | 2 | e | Yang Shuzhuang is against Japan's proposal to repair the Chinese naval ships. | China | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
45840 | 45840 | 1927-06-25 | 2 | f | Yan Xishan is ready to release Yue Weijun and the conditions. | China | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
45836 | 45836 | 1927-06-25 | 2 | d | Yan Xishan and his recent attitude. | China | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
45849 | 45849 | 1927-06-25 | 3 | e | Wu Chaoshu becomes new foreign minister of the Beijing government and his declaration. | China | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
45846 | 45846 | 1927-06-25 | 3 | c | The Sun Yatsen University in Moscow refuses to permit its students to return to China. | Russia | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
45837 | 45837 | 1927-06-25 | 2 | e | Shandong provincial authority disciplines girl schools. | China | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
45848 | 45848 | 1927-06-25 | 3 | d | Redundancy in the Beijing foreign ministry. | China | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
45852 | 45852 | 1927-06-25 | 7 | a | Poems by Wu Elou (Xiuguang) on his travel back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102039 | 24102039 | |
45842 | 45842 | 1927-06-25 | 3 | b | Overseas Chinese Association in Shanghai calls for abrogation of the treaty with Holland. | China | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
45850 | 45850 | 1927-06-25 | 5 | a-b | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24102037 | 24102037 | |
45845 | 45845 | 1927-06-25 | 3 | c | Many Russian refugees in Harbin, Heilongjiang province, apply for Chinese citizenship. | China | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
45843 | 45843 | 1927-06-25 | 3 | b | Li Yuanhong, Duan Qirui and Wang Chonghui and the comprise between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
45847 | 45847 | 1927-06-25 | 3 | c | Huang Fu is appointed the mayor of Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
45854 | 45854 | 1927-06-25 | 9 | a-d | Guangdong news/ News on the effort in Guangdong to eliminate the communists. Government employees have salary cut. Cheng Xianmeng, magistrate of the Lianxian county, apply for reform of prison system. Activists dispatched to propaganda the san min zhu yi. People's court to be set up in every county. Order to arrest Chen Jiayou. Zhuang Guangdi is appointed magistrate of Zhongshan county. Security forces are being trained in Guangzhou. | China | |||
45835 | 45835 | 1927-06-25 | 2 | c | Former Chinese consul-general Huang Rongliang and his stories. | China | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
45834 | 45834 | 1927-06-25 | 2 | b | Editorial by Tung Wah Times on the class classification in Soviet Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
45841 | 45841 | 1927-06-25 | 2 | f | Chinese foreign ministry in Beijing and its plan to re-organise overseas missions. | China | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
45851 | 45851 | 1927-06-25 | 5 | b-c | Bandits in Guangdong: the past and the present. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102037 | 24102037 | |
45853 | 45853 | 1927-06-25 | 7 | a | Australia news/ Chinese football team wins again in Adelaide. Chinese man dies in accident in Sydney. Storm in Perth. Police raid Chinese gambling den in Sydney. Rev. Li Baoshen is on the way to Fiji for gospel work. Advertisement for the International Ball in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102039 | 24102039 | |
45838 | 45838 | 1927-06-25 | 2 | e | American exploration teams in Xinjiang, Northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 |
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]);