This data as json, CSV (advanced)
Suggested facets: page, column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 40003 | 40003 | 1923-06-23 | 2 | a-b | Editorial on the chaos in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094448 | 24094448 | |
| 40004 | 40004 | 1923-06-23 | 2 | b-d | Two political groups in Beijing that support or try to overthrow the cabinet. | China | http://trove.nla.gov.au/newspaper/page/24094448 | 24094448 | |
| 40005 | 40005 | 1923-06-23 | 2 | d-f | Both Can Kun in Baoding and Zhang Zuolin in Fengtian deny that they are preparing for a war. | China | http://trove.nla.gov.au/newspaper/page/24094448 | 24094448 | |
| 40006 | 40006 | 1923-06-23 | 2-3 | f-a | A detailed report on the hijack and kidnap in Shandong province (on the railway from Tianjin to Pukou). | China | http://trove.nla.gov.au/newspaper/page/24094448 | 24094448 | |
| 40007 | 40007 | 1923-06-23 | 3 | b | French government has agreed to return the Guangzhou Bay to China. | China | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40008 | 40008 | 1923-06-23 | 3 | b | Wu Peifu issues a circular telegram for peace. | China | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40009 | 40009 | 1923-06-23 | 3 | b | Earthquake on the border between Sichuan and Tibet and the casualties. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40010 | 40010 | 1923-06-23 | 3 | b-c | An American newspaper advocates armed intervention in China. | America | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40011 | 40011 | 1923-06-23 | 3 | c | Member of American House of Representatives advocates condominium in China. | America | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40012 | 40012 | 1923-06-23 | 3 | c-d | Boycott to Japanese goods in Shashi and Yichang, Hubei province, and the Japanese sailors kill five Chinese demonstrators. | China | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40013 | 40013 | 1923-06-23 | 3 | d-e | President Li Yuanhong flees Beijing and has arrived Tianjin. | America | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40014 | 40014 | 1923-06-23 | 3 | e | Chinese President Li Yuanhong is still keen to abolish provincial governorship. | China | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40015 | 40015 | 1923-06-23 | 3 | e | Two white sailors, two blacks and five Chinese are killed in a fighting on board of a British ship near New York. | America | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40016 | 40016 | 1923-06-23 | 3 | f | Boycott to Japanese goods in China. | China | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
| 40017 | 40017 | 1923-06-23 | 6 | a-b | Chinese Chamber of Commerce in New South Wales sends protest telegram to Guangdong provincial authority on the sale of public properties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094452 | 24094452 | |
| 40018 | 40018 | 1923-06-23 | 6 | b | Guangzhou commercial association sends telegram to the Chinese Chamber of Commerce in New South Wales on the Twenty-one Demands and the return of Lushun and Dalian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094452 | 24094452 | |
| 40019 | 40019 | 1923-06-23 | 6-7 | b-c | Report on the shareholders meeting of the Wing On Textile Company Ltd, and speakers include Guo Le, Ma Zuxing, and others. Election of the Board. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094452 | 24094452 | |
| 40020 | 40020 | 1923-06-23 | 6 | c | Advertisement for The Chungwah Navigation Company Ltd (Hong Kong). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094452 | 24094452 | |
| 40021 | 40021 | 1923-06-23 | 7 | a | A jewellery shop in Oxford Street, Sydney, is robbed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094451 | 24094451 | |
| 40022 | 40022 | 1923-06-23 | 7 | b | Two cases of robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094451 | 24094451 | |
| 40023 | 40023 | 1923-06-23 | 7 | b | A motorbike accident in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094451 | 24094451 | |
| 40024 | 40024 | 1923-06-23 | 7 | b | A man in New South Wales is swallowed by shark. | Australia | http://trove.nla.gov.au/newspaper/page/24094451 | 24094451 | |
| 40025 | 40025 | 1923-06-23 | 7 | b | President Li Yuanhong escapes to Tianjin and the Chinese situation. | China | http://trove.nla.gov.au/newspaper/page/24094451 | 24094451 | |
| 40026 | 40026 | 1923-06-23 | 7 | b | Bandits in Hubei province kidnap Italian and British missionaries. | America | http://trove.nla.gov.au/newspaper/page/24094451 | 24094451 | |
| 40027 | 40027 | 1923-06-23 | 7 | b-c | First part of a special report published in the Sydney Morning Herald on the Far Eastern situations (rise of Japan, the future of China and others). | Australia | http://trove.nla.gov.au/newspaper/page/24094451 | 24094451 | |
| 40028 | 40028 | 1923-06-23 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094451 | 24094451 | |
| 40029 | 40029 | 1923-06-23 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094454 | 24094454 | |
| 40030 | 40030 | 1923-06-23 | 8 | a-d | Guangdong news/ Ma Xiaojin condemns Sun Yatsen. Yang Ximin takes precautions against Tang Jiyao. Yunnan military officer comes to see doctor in Hong Kong. Survey on the houses burned down in Zhaoqing. Xu Shurong's army and their looting. Complaints from Qingyuan county on the disaster of war. Bandits in Xiangshan county kidnap three women for ransom. Charity institute in Guangzhou jiu shan tang to transport some rice to Zhaoqing for disaster relief. Complaints from Enping county over the banditry. The war in Chaozhou and Meixian county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094454 | 24094454 | |
| 40031 | 40031 | 1923-06-23 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094454 | 24094454 | |
| 40032 | 40032 | 1923-06-23 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094454 | 24094454 |
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]);