This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 40759 | 40759 | 1923-12-01 | 7 | d | Report from New Guinea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |
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]);