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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
45381 | 45381 | 1926-12-25 | 2 | e | Strike in Wuhan, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101824 | 24101824 | |
45386 | 45386 | 1926-12-25 | 3 | f | The birthplace of George Washington found. | America | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
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 |
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]);