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 |
---|---|---|---|---|---|---|---|---|---|
40747 | 40747 | 1923-12-01 | 3 | d-e | American army has new weapons. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
40746 | 40746 | 1923-12-01 | 3 | d | Flood in India. | Other... | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
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 | |
40763 | 40763 | 1923-12-01 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094638 | 24094638 | |
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 | |
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 | |
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 | |
40764 | 40764 | 1923-12-01 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094638 | 24094638 | |
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 | |
40759 | 40759 | 1923-12-01 | 7 | d | Report from New Guinea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);