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 |
---|---|---|---|---|---|---|---|---|---|
46267 | 46267 | 1927-10-08 | 2 | c | Battles in the south and west of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46268 | 46268 | 1927-10-08 | 2 | d | Telegram by Zhang Ji on the policy of the Nationalist government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46269 | 46269 | 1927-10-08 | 2 | d | Wang Tianpei is removed and the report on the process. | China | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46270 | 46270 | 1927-10-08 | 2 | d | Talks between Fang Benren and He Chengrui, delegates from the south. | China | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46271 | 46271 | 1927-10-08 | 2 | f | Japanese businessmen in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46272 | 46272 | 1927-10-08 | 3 | b | Tan Yankai and Sun Ke in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098551 | 24098551 | |
46273 | 46273 | 1927-10-08 | 3 | b | American journalist visit Jiang Jieshi and their talks. | China | http://trove.nla.gov.au/newspaper/page/24098551 | 24098551 | |
46274 | 46274 | 1927-10-08 | 3 | c | Bandits in the south of Zhili province. | China | http://trove.nla.gov.au/newspaper/page/24098551 | 24098551 | |
46275 | 46275 | 1927-10-08 | 3 | c | The Shanghai after the martial law enforced. | China | http://trove.nla.gov.au/newspaper/page/24098551 | 24098551 | |
46276 | 46276 | 1927-10-08 | 3 | d | Rumours in Shanghai and the response of the public security bureau. | China | http://trove.nla.gov.au/newspaper/page/24098551 | 24098551 | |
46277 | 46277 | 1927-10-08 | 3 | d | He Long leads his troops to Liuyang, Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098551 | 24098551 | |
46278 | 46278 | 1927-10-08 | 5 | a | Japanese liner increases cargo charges. | China | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46279 | 46279 | 1927-10-08 | 5 | a | Battle in Kunming, Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46284 | 46284 | 1927-10-08 | 5 | b | The Chinese communists are still active in Hubei and south China. | China | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46286 | 46286 | 1927-10-08 | 5 | b | War in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46288 | 46288 | 1927-10-08 | 5 | c | War between Zhang Zuolin and Yan Xishan. | China | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46289 | 46289 | 1927-10-08 | 5 | c | Yan Xishan changes his neutral attitude. | China | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46291 | 46291 | 1927-10-08 | 7 | b | Yan Xishan's army wins. | China | http://trove.nla.gov.au/newspaper/page/24098555 | 24098555 | |
46293 | 46293 | 1927-10-08 | 7 | c | French teacher in the Fujian Shipping School (chuan zheng xue tang) and his Chinese taste. | China | http://trove.nla.gov.au/newspaper/page/24098555 | 24098555 | |
46294 | 46294 | 1927-10-08 | 8 | a-d | Guangdong news/ Ye Ting and He Long lead their troops retreat into Fujian. Overseas Chinese associations on the murder of a returned Chinese businessman in Vietnam. Bandits in Heshan county. Bai Chongxi recruits new forces. Local gentry discuss disputes in Xinhui county. Health authority requests traditional herbalists to sit examinations. Ferry workers are asked to help fight the pirates. Women found weapons smuggling. A survey on the number of trade unions/ labour organisations in Guangdong. Fire in Zhaoqing destroys shops. Hong Kong authority trying to wipe out pirates. News from Shilong Town (security, agriculture, civil administration, education and business). | China | http://trove.nla.gov.au/newspaper/page/24098558 | 24098558 |
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]);