This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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]);