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 |
---|---|---|---|---|---|---|---|---|---|
46291 | 46291 | 1927-10-08 | 7 | b | Yan Xishan's army wins. | China | http://trove.nla.gov.au/newspaper/page/24098555 | 24098555 | |
46289 | 46289 | 1927-10-08 | 5 | c | Yan Xishan changes his neutral attitude. | 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 | |
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 | |
46275 | 46275 | 1927-10-08 | 3 | c | The Shanghai after the martial law enforced. | China | http://trove.nla.gov.au/newspaper/page/24098551 | 24098551 | |
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 | |
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 | |
46272 | 46272 | 1927-10-08 | 3 | b | Tan Yankai and Sun Ke in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098551 | 24098551 | |
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 | |
46285 | 46285 | 1927-10-08 | 5 | b | Soviet Russia provides financial assistance to the strikers in London. | Britain | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
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 | |
46278 | 46278 | 1927-10-08 | 5 | a | Japanese liner increases cargo charges. | China | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46271 | 46271 | 1927-10-08 | 2 | f | Japanese businessmen in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46287 | 46287 | 1927-10-08 | 5 | c | Hurricane in St Louis, America. | America | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
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 | |
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 | |
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 | |
46280 | 46280 | 1927-10-08 | 5 | a | Fire in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46283 | 46283 | 1927-10-08 | 5 | a | Customs officers in Holland seize smuggled weapons. | Britain | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46266 | 46266 | 1927-10-08 | 2 | b | Comments by Tung Wah Times on the National Day of October 10. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46282 | 46282 | 1927-10-08 | 5 | a | Catholics in Mexico make trouble. | Other... | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
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 | |
46279 | 46279 | 1927-10-08 | 5 | a | Battle in Kunming, Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46274 | 46274 | 1927-10-08 | 3 | c | Bandits in the south of Zhili province. | China | http://trove.nla.gov.au/newspaper/page/24098551 | 24098551 | |
46290 | 46290 | 1927-10-08 | 7 | a | Australia news/ Unemployed workers in Soviet Russia. Customs officers seize smuggled opium. Liner Taiping from Hong Kong and the passengers. A man keeps dancing for 71 hours. The Young Chinese Association in Australia (li zhi hui) celebrates the birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098555 | 24098555 | |
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 | |
46265 | 46265 | 1927-10-08 | 2 | a | Advertisement for The Primary Producers' Bank of Australia Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46264 | 46264 | 1927-10-08 | 2 | a | Advertisement for Roy Cook, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46263 | 46263 | 1927-10-08 | 2 | a | Advertisement for Anderson & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098552 | 24098552 | |
46281 | 46281 | 1927-10-08 | 5 | a | A Russian woman murders her husband. | Russia | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46292 | 46292 | 1927-10-08 | 7 | b | A Chinese businessman returned from Boston disappears in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098555 | 24098555 |
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]);