This data as json, CSV (advanced)
Suggested facets: page, column, description, source, page_url, trove_id, date (date)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45394 | 45394 | 1926-12-25 | 8 | f | Advertisement for Shanghai Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101829 | 24101829 | |
45393 | 45393 | 1926-12-25 | 8 | e | Advertisement for the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101829 | 24101829 | |
45392 | 45392 | 1926-12-25 | 8 | e | Liner timetable. Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101829 | 24101829 | |
45391 | 45391 | 1926-12-25 | 8 | a-d | Guangdong news/ Effort to reform judicial system. Li Liejun has returned to Guangzhou. Chen Yixi reports the solution to railway strikes in Ningyang. Shareholders of the Xinning Railway on the interference by the government. Silk shops are to be closed in Guangzhou. Theft in Foshan. Foreign minister Chen Youren on the registration of overseas Chinese. People in Xiangshan county oppose to extra charges for telephone. Police office in Dongguan county is occupied by bandits. News from Dongguan county. Farewell message Chen Juren on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101829 | 24101829 | |
45390 | 45390 | 1926-12-25 | 7 | c-d | Miscellaneous report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101827 | 24101827 | |
45389 | 45389 | 1926-12-25 | 7 | a-b | Australia news/ Sydney Chinese School and the Chamber of Commerce farewell Luo Fuquan, teacher of the school, on his return to China. Two Chinese are punished in Sydney for opium smoking. Baby girl found abandoned in Sydney. Weather forecast for the Christmas holiday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101827 | 24101827 | |
45388 | 45388 | 1926-12-25 | 5 | a-c | Miscellaneous report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101825 | 24101825 | |
45387 | 45387 | 1926-12-25 | 3 | f | American government on the proposed revision of treaties with China. | America | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
45386 | 45386 | 1926-12-25 | 3 | f | The birthplace of George Washington found. | America | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
45385 | 45385 | 1926-12-25 | 3 | e | Clash between Chinese and Japanese in Jiujiang, of Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
45384 | 45384 | 1926-12-25 | 3 | d | Hubei army on the border of Hubei and Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
45383 | 45383 | 1926-12-25 | 3 | d | Martial law to be enforced in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
45382 | 45382 | 1926-12-25 | 3 | c | New governor of Henan province Xiong Bingqi and the current situation there. | China | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
45381 | 45381 | 1926-12-25 | 2 | e | Strike in Wuhan, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101824 | 24101824 | |
45380 | 45380 | 1926-12-25 | 2 | e | Spanish ambassador in China agrees to revise the treaty with China. | China | http://trove.nla.gov.au/newspaper/page/24101824 | 24101824 | |
45379 | 45379 | 1926-12-25 | 2 | d | Wang Chonghui talks to journalist on Chinese foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24101824 | 24101824 | |
45378 | 45378 | 1926-12-25 | 2 | c-d | Editorial on the unification of China (the south and the north). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101824 | 24101824 |
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]);