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 |
---|---|---|---|---|---|---|---|---|---|
41428 | 41428 | 1924-04-19 | 3 | a | Zhili army purchases huge amount of weapons from Italian supplier. | China | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41430 | 41430 | 1924-04-19 | 3 | b | Zhang Zuolin escapes an assassination. | China | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41423 | 41423 | 1924-04-19 | 2 | b-d | Wang Chonghui talks about the peace and national unification in China. | Other... | http://trove.nla.gov.au/newspaper/page/24100688 | 24100688 | |
41451 | 41451 | 1924-04-19 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41437 | 41437 | 1924-04-19 | 6 | a | Tung Wah Times comments on the Guangdong people without a government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100692 | 24100692 | |
41441 | 41441 | 1924-04-19 | 7 | a | The Sydney pianist is to be executed for murdering his three daughters. | Australia | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41429 | 41429 | 1924-04-19 | 3 | a-b | Tang Jiyu returns power to Liu Xianshi in Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41434 | 41434 | 1924-04-19 | 3 | e | Sun Yatsen's troops and their looting near Huangpu, Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41425 | 41425 | 1924-04-19 | 2 | e-f | Repayment of government bonds in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100688 | 24100688 | |
41435 | 41435 | 1924-04-19 | 3 | f | Pirates hijack a cargo ship near Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41426 | 41426 | 1924-04-19 | 2 | f | People in Shanghai gather to promote the products of China. | China | http://trove.nla.gov.au/newspaper/page/24100688 | 24100688 | |
41449 | 41449 | 1924-04-19 | 7 | b-c | Military situation in the south and southeast of Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41454 | 41454 | 1924-04-19 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100694 | 24100694 | |
41433 | 41433 | 1924-04-19 | 3 | d-e | Japanese authority in Taiwan arrests more than 40 patriotic youth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41452 | 41452 | 1924-04-19 | 8 | a-d | Guangdong news/ Sun Yatsen and his communist experiment in Guangdong (Borodin to recruit more members in the north, Sun Yatsen and American envoys, and the preparation for a communist government). Silver export from China. Sale of shoupiao in Guangzhou. Foreign flag and foreign trademarks in Guangzhou. Zengcheng people flee the troops. Yunnan troops and their looting in Shilong town, Dongguan county. Shen Hongying does not surrender himself to Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100694 | 24100694 | |
41453 | 41453 | 1924-04-19 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100694 | 24100694 | |
41432 | 41432 | 1924-04-19 | 3 | c-d | Foreign countries are to organise a united fleet in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41438 | 41438 | 1924-04-19 | 6 | a-e | First part of a special and detailed report on the Chinese Communist Party: its past, present and the future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100692 | 24100692 | |
41436 | 41436 | 1924-04-19 | 3 | f | Epidemic in India. | Other... | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41422 | 41422 | 1924-04-19 | 2 | a-b | Editorial on the war in Sichuan and Guangdong province and its relationship with national unification. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100688 | 24100688 | |
41443 | 41443 | 1924-04-19 | 7 | a | Circus performance in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41431 | 41431 | 1924-04-19 | 3 | b-c | Chinese students successfully persuade British government to return part of the Boxer Indemnity. | Britain | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41424 | 41424 | 1924-04-19 | 2 | d-e | Chinese students in France demonstrate the case of gold Franc. | France | http://trove.nla.gov.au/newspaper/page/24100688 | 24100688 | |
41444 | 41444 | 1924-04-19 | 7 | b | British fleet escorts passenger liner in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41427 | 41427 | 1924-04-19 | 2-3 | f-a | Army enters Chengdu, capital of Sichuan province, and the report. | China | http://trove.nla.gov.au/newspaper/page/24100688 | 24100688 | |
41450 | 41450 | 1924-04-19 | 7 | e | An open letter from some Chinese immigrants in Samoa thanks Chinese consul general Li Zhaosong for his kind help. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41447 | 41447 | 1924-04-19 | 7 | b | American navy to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41446 | 41446 | 1924-04-19 | 7 | b | American government criticise the tax regulations in Samoa island imposed by New Zealand authority. | America | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41445 | 41445 | 1924-04-19 | 7 | b | American House of Representatives approves to ban entry of Japanese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41439 | 41439 | 1924-04-19 | 7 | a | A visit to The Royal Centenary Show, Moore Park, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41440 | 41440 | 1924-04-19 | 7 | a | A murderer in Melbourne is executed and the report on the process. | Australia | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41442 | 41442 | 1924-04-19 | 7 | a | A coal miner in New South Wales is killed in an accident. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41448 | 41448 | 1924-04-19 | 7 | b | A German teacher is sacked for introducing students to naked exercise. | Germany | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 |
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]);