This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40751 | 40751 | 1923-12-01 | 6 | a | Poems by Zhou Yufan. Poems by anonymous author farewells He Zhijing on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094636 | 24094636 | |
40754 | 40754 | 1923-12-01 | 7 | a | Farewell message by the Chinese football team to their compatriots on leaving Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
40742 | 40742 | 1923-12-01 | 3 | a-b | War clouds between Zhili (Wu Peifu) and Fengtian (Zhang Zuolin). | China | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
40752 | 40752 | 1923-12-01 | 6 | a-b | Sun Yatsen publishes an advertisement in the South China Morning Post on October 15 and wants to sell Chinese territory. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094636 | 24094636 | |
40755 | 40755 | 1923-12-01 | 7 | a-b | Chinese consul-general in Australia Wei Zijing talks to the Chinese Chamber of Commerce in Sydney about immigration issues (study, business, and others). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
40738 | 40738 | 1923-12-01 | 2 | a-c | Fourth part of the article written by Wu Xiufeng claims that Chinese culture is the future of our world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094632 | 24094632 | |
40762 | 40762 | 1923-12-01 | 8 | a-d | Guangdong news/ Sun Yatsen orders to collect more taxes in Guangzhou. Ammunition factory explodes near the Headquarters in Guangzhou. Pressgang in Shilong town. Political and military leaders are fleeing Guangdong for Hong Kong and Macao. Ye Ju reports that Huiyang has been taken over. Defence in Humen fortress. Wong Huiteng reports battles. Army from the north have entered Nanxiong county. Sun Yatsen's soldier escape to British settlement and are disarmed. War news from the south and the north of Guangdong. War in the Dongjiang area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094638 | 24094638 | |
40743 | 40743 | 1923-12-01 | 3 | b-c | Report on recent wars in Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
40756 | 40756 | 1923-12-01 | 7 | b-c | Sydney English newspaper reports the underground opium smuggling network. | Australia | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
40753 | 40753 | 1923-12-01 | 6 | b-d | Associations in Guangzhou issue an open letter to Sun Yatsen and his colleagues. | China | http://trove.nla.gov.au/newspaper/page/24094636 | 24094636 | |
40757 | 40757 | 1923-12-01 | 7 | c | Italian consul in Sydney in brought to trial for adultery. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
40758 | 40758 | 1923-12-01 | 7 | c | Investigation on the child's body in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
40739 | 40739 | 1923-12-01 | 2 | c-d | Third part of the constitution of the Republic of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094632 | 24094632 | |
40744 | 40744 | 1923-12-01 | 3 | c-d | Cao Kun's plan to abolish provincial governorship. | China | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
40740 | 40740 | 1923-12-01 | 2 | d | Sun Yatsen delivers message to foreign powers in regards to the presidential election in Beijing, the bribery and Cao Kun's conspiracy. | China | http://trove.nla.gov.au/newspaper/page/24094632 | 24094632 | |
40745 | 40745 | 1923-12-01 | 3 | d | Bandits kidnap an American missionary on the border of Guizhou and Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
40746 | 40746 | 1923-12-01 | 3 | d | Flood in India. | Other... | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
40759 | 40759 | 1923-12-01 | 7 | d | Report from New Guinea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
40741 | 40741 | 1923-12-01 | 2-3 | d-a | First part of an open letter from some parliamentarians in Beijing to Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24094632 | 24094632 | |
40747 | 40747 | 1923-12-01 | 3 | d-e | American army has new weapons. | America | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
40748 | 40748 | 1923-12-01 | 3 | e | Bank robbery in Indiana, United States of America. | America | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
40749 | 40749 | 1923-12-01 | 3 | e | Another earthquake hits Tokyo. | America | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
40750 | 40750 | 1923-12-01 | 3 | e | Six Spanish people try to blow up Spanish and Italian consulates in Philadelphia, America. | America | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
40760 | 40760 | 1923-12-01 | 7 | e | Chinese Chamber of Commerce organises a fundraising concert/ party in the city Town Hall for Sydney hospital and those who are involved include Ye Tonggui and his wife, Zhang Maokuan, Zhu Hechou, Liu Guangfu, and Ma Zanfen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
40763 | 40763 | 1923-12-01 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094638 | 24094638 | |
40764 | 40764 | 1923-12-01 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094638 | 24094638 | |
40761 | 40761 | 1923-12-01 | 7 | f | Farewell message by Hu Kui on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 |
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]);