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 |
---|---|---|---|---|---|---|---|---|---|
45786 | 45786 | 1927-06-11 | 2 | b | Editorial on Chinese internal politics and foreign policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102018 | 24102018 | |
45787 | 45787 | 1927-06-11 | 2 | c-d | Germany and its naval forces. | Germany | http://trove.nla.gov.au/newspaper/page/24102018 | 24102018 | |
45788 | 45788 | 1927-06-11 | 2 | e | Prostitution in the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24102018 | 24102018 | |
45789 | 45789 | 1927-06-11 | 2 | e | Japan is preparing for the war in the Far East. | Japan | http://trove.nla.gov.au/newspaper/page/24102018 | 24102018 | |
45790 | 45790 | 1927-06-11 | 2 | e | Yan Huiqing is to leave China for Geneva and London. | China | http://trove.nla.gov.au/newspaper/page/24102018 | 24102018 | |
45791 | 45791 | 1927-06-11 | 2 | f | The Nationalist government moves its capital to Nanjing and the report. | China | http://trove.nla.gov.au/newspaper/page/24102018 | 24102018 | |
45792 | 45792 | 1927-06-11 | 3 | b | Defence in Jilin and Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45793 | 45793 | 1927-06-11 | 3 | c | Li Yuanhong is to arrive in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45794 | 45794 | 1927-06-11 | 3 | c | Navy in Shanghai to support Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45795 | 45795 | 1927-06-11 | 3 | c | Beijing government replies to the protest of Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45796 | 45796 | 1927-06-11 | 3 | d | Foreign missions in Beijing read the documents seized in the Soviet Russian embassy. | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45797 | 45797 | 1927-06-11 | 3 | d | A circular telegram issued by the Overseas Chinese Association in Shanghai on the san min zhu yi (Three People's Principles). | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45798 | 45798 | 1927-06-11 | 3 | e | Rumours on the comprise in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45799 | 45799 | 1927-06-11 | 3 | e | Troops from Shaanxi province to attack Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45800 | 45800 | 1927-06-11 | 3 | f | Ye Kaixin has new appointment. | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45801 | 45801 | 1927-06-11 | 3 | f | Li Jinglin on the way to Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24102017 | 24102017 | |
45802 | 45802 | 1927-06-11 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24102019 | 24102019 | |
45803 | 45803 | 1927-06-11 | 5 | c | War clouds over the Balkan peninsula. | Britain | http://trove.nla.gov.au/newspaper/page/24102019 | 24102019 | |
45804 | 45804 | 1927-06-11 | 7 | a-b | Australia news/ A failed shop robbery in Sydney. Czech football team wins the New South Wales team in Sydney. Chinese football team wins again in Perth. A reply from the Chinese consulate-general on the tax of imported rice. Chinese gamblers are detained in Sydney. New South Wales state health authority prohibit chefs from smoking while working. An old man in Sydney is charged with sexual harassment. Many Italian immigrants arrive Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102021 | 24102021 | |
45805 | 45805 | 1927-06-11 | 7 | b | Soviet Russian ambassador in Poland is assassinated and the report. | Other... | http://trove.nla.gov.au/newspaper/page/24102021 | 24102021 | |
45806 | 45806 | 1927-06-11 | 9 | a-d | Guangdong news/ Government authority is closely watching labour movement. The first step to take back the consular jurisdiction and the case in Qiongshan county that involves French businessman. Wu Tiecheng and Fu Bingchang to take appointment in Guangdong. Gan Naiguang to study in Germany. Chen Shuren on the way to study in Japan. Bandit groups in the Xijiang area. Ferry hijacked in Shiqi, of Nanhai county. Prisoners in Guangzhou fail to escape and the report. Village are looted in Xinhui county. Li Jishen asks for release of Liang Hongkai. Qian Dajun to lead the army to Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24102025 | 24102025 |
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]);