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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
41447 | 41447 | 1924-04-19 | 7 | b | American navy to build more warships. | America | 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 | |
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 | |
41444 | 41444 | 1924-04-19 | 7 | b | British fleet escorts passenger liner in Sydney. | Australia | 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 | |
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 | |
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 | |
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 | |
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 | |
41430 | 41430 | 1924-04-19 | 3 | b | Zhang Zuolin escapes an assassination. | China | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
41443 | 41443 | 1924-04-19 | 7 | a | Circus performance in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
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 | |
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 | |
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 | |
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 | |
41454 | 41454 | 1924-04-19 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100694 | 24100694 |
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]);