This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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]);