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 |
|---|---|---|---|---|---|---|---|---|---|
| 40555 | 40555 | 1923-10-20 | 2 | a-b | Commercial development is the way to save China, an editorial by the Tung Wah Times | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094584 | 24094584 | |
| 40556 | 40556 | 1923-10-20 | 2 | b-c | Second part of a report on the establishment of National Education Promotion Association of China (zhong hua ping min jiao yu zong hui), its mission, regulation and organisation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094584 | 24094584 | |
| 40557 | 40557 | 1923-10-20 | 2 | c-d | Second and final part of a report that the Chinese community in France oppose to the condominium of railway in China. | France | http://trove.nla.gov.au/newspaper/page/24094584 | 24094584 | |
| 40558 | 40558 | 1923-10-20 | 2-3 | d-a | The war in Sichuan. | China | http://trove.nla.gov.au/newspaper/page/24094584 | 24094584 | |
| 40559 | 40559 | 1923-10-20 | 3 | a-b | Banking Corporation of Britain, France, America and Japan meets in Paris on the China's repayment of indemnity and the mortgage. | France | http://trove.nla.gov.au/newspaper/page/24094583 | 24094583 | |
| 40560 | 40560 | 1923-10-20 | 3 | b-c | Zhu Fucheng, Qi Xieyuan and Wang Yuzhi oppose to China's effort to borrow foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24094583 | 24094583 | |
| 40561 | 40561 | 1923-10-20 | 3 | c | Cao Kun talks to Japanese journalist in Baoding. | China | http://trove.nla.gov.au/newspaper/page/24094583 | 24094583 | |
| 40562 | 40562 | 1923-10-20 | 3 | d | Cao Kun assumes office of the President of China, and issues a declaration as the new president. | China | http://trove.nla.gov.au/newspaper/page/24094583 | 24094583 | |
| 40563 | 40563 | 1923-10-20 | 3 | d | Typhoon hits Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24094583 | 24094583 | |
| 40564 | 40564 | 1923-10-20 | 3 | d-e | Chinese government discusses requests of foreign missions in Beijing on the train hijack in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24094583 | 24094583 | |
| 40565 | 40565 | 1923-10-20 | 3 | e | Bandits in America hijack train. | America | http://trove.nla.gov.au/newspaper/page/24094583 | 24094583 | |
| 40566 | 40566 | 1923-10-20 | 6 | a | Poems by Yang Yusan farewell Su Jinbo on his return to China, and poems in reply by Su Jinbo. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094588 | 24094588 | |
| 40567 | 40567 | 1923-10-20 | 6 | a-b | Editor of Tung Wah Times comments on the heavy tax imposed by Guangdong provincial government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094588 | 24094588 | |
| 40568 | 40568 | 1923-10-20 | 6 | b-c | Li Yuanhong in Shanghai and an observation on his situations. | China | http://trove.nla.gov.au/newspaper/page/24094588 | 24094588 | |
| 40569 | 40569 | 1923-10-20 | 6 | d | Hong Kong businessman He Dong arrives in Shanghai and his mediation for peace in China. | China | http://trove.nla.gov.au/newspaper/page/24094588 | 24094588 | |
| 40570 | 40570 | 1923-10-20 | 7 | a | Chinese community in Adelaide welcomes the Chinese football team and speakers include Zhu He, Xie Zhenkuan, Mo Qing, Lin You and other guests. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40571 | 40571 | 1923-10-20 | 7 | a-b | Chinese community in Tamworth, New South Wales, celebrates the birthday of Confucius and the National Day, and a detailed report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40572 | 40572 | 1923-10-20 | 7 | b | Queensland government issues new regulation on sugar sales. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40573 | 40573 | 1923-10-20 | 7 | b | An Italian immigrant in Sydney sues Italian consul for adultery with his wife. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40574 | 40574 | 1923-10-20 | 7 | b | Thief hurts a white man in Manly, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40575 | 40575 | 1923-10-20 | 7 | c | Smuggled weapons found in a Dutch ship while docking in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40576 | 40576 | 1923-10-20 | 7 | c | Workers of the gas factory are in strike in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40577 | 40577 | 1923-10-20 | 7 | c | A convict on the run is captured again in Geelong, Victoria. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40578 | 40578 | 1923-10-20 | 7 | c | An American tourist reports to Sydney police that he was stolen by a woman. | Australia | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40579 | 40579 | 1923-10-20 | 7 | c | Two trams collide in Sydney that causes injury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40580 | 40580 | 1923-10-20 | 7 | c | Sun Junchen, owner of the Chinese Australian Herald in Sydney, goes bankrupt and the Chinese newspaper is closed down. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40581 | 40581 | 1923-10-20 | 7 | c | Sun Yatsen opposes to Cao Kun as the Chinese president. | America | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40582 | 40582 | 1923-10-20 | 7 | d | Ammunition depot explodes in Poland. | Britain | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40583 | 40583 | 1923-10-20 | 7 | d | Foreign missions in Beijing congratulate Cao Kun as the new Chinese president. | China | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40584 | 40584 | 1923-10-20 | 7 | d | A peanut shop owner in Beijing sees a ghost in broad daylight. | China | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40585 | 40585 | 1923-10-20 | 7 | e | Gong yi tang (The Dong Guan Goon Yee Tong) in Sydney calls for donations to the flood victims in their home county. Contact details are: Lee Sang & Co, Hay and Harbour Streets, Sydney; Yuen Tiy Tong Kee, 54 Campbell Street, Sydney; Chung Lung, 120 Gloucester Street, Sydney; and King Young, 51 Dixon Street, Sydney. Chinese community in Sydney donates to the victims and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094587 | 24094587 | |
| 40586 | 40586 | 1923-10-20 | 8 | a | Melbourne Chinese communities donate to the building of Confucian temple. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094590 | 24094590 | |
| 40587 | 40587 | 1923-10-20 | 8 | a-d | Guangdong news/ Sun Yatsen to borrow loans from the Bank of China. Everything is liable for taxation in Guangzhou. Hong Kong authority issues new punishment regulation on weapon smuggling. Battles in Beijiang River area. Lu Chunrong declares independence. Guangdong army starts counterattack in Danshui county. A passenger ferry explodes in Dongjiang area. Battles in the southeast of Guangdong. New waves of pressgang in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094590 | 24094590 | |
| 40588 | 40588 | 1923-10-20 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094590 | 24094590 | |
| 40589 | 40589 | 1923-10-20 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094590 | 24094590 |
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]);