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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 45836 | 45836 | 1927-06-25 | 2 | d | Yan Xishan and his recent attitude. | China | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
| 45837 | 45837 | 1927-06-25 | 2 | e | Shandong provincial authority disciplines girl schools. | China | http://trove.nla.gov.au/newspaper/page/24102036 | 24102036 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 45844 | 45844 | 1927-06-25 | 3 | b | Yang Yuting and his talks in Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
| 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 | |
| 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 | |
| 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 | |
| 45848 | 45848 | 1927-06-25 | 3 | d | Redundancy in the Beijing foreign ministry. | China | http://trove.nla.gov.au/newspaper/page/24102035 | 24102035 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |
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]);