This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45599 | 45599 | 1927-04-09 | 2 | c | Editorial by Tung Wah Times on the national strength of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101940 | 24101940 | |
45600 | 45600 | 1927-04-09 | 2 | c-d | The citizenship issues of the marriage between Russian and Chinese people. | China | http://trove.nla.gov.au/newspaper/page/24101940 | 24101940 | |
45601 | 45601 | 1927-04-09 | 2 | e | Commercial chambers in local Guangdong and their declaration on the industrial disputes (Qujiang and Foshan). | China | http://trove.nla.gov.au/newspaper/page/24101940 | 24101940 | |
45602 | 45602 | 1927-04-09 | 3 | c | Economic development in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24101939 | 24101939 | |
45603 | 45603 | 1927-04-09 | 3 | c | The ambition of Liang Shiyi. | China | http://trove.nla.gov.au/newspaper/page/24101939 | 24101939 | |
45604 | 45604 | 1927-04-09 | 3 | d | British government and its plan for naval growth. | China | http://trove.nla.gov.au/newspaper/page/24101939 | 24101939 | |
45605 | 45605 | 1927-04-09 | 3 | d | Current situation in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24101939 | 24101939 | |
45606 | 45606 | 1927-04-09 | 3 | e | Qi Xieyuan issues a circular telegram and steps down. | China | http://trove.nla.gov.au/newspaper/page/24101939 | 24101939 | |
45607 | 45607 | 1927-04-09 | 3 | e | The conspiracy of the Chinese Communist party. | China | http://trove.nla.gov.au/newspaper/page/24101939 | 24101939 | |
45608 | 45608 | 1927-04-09 | 3 | f | Liang Qichao reports the completion of the library project in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101939 | 24101939 | |
45609 | 45609 | 1927-04-09 | 3 | f | The Chinese Nationalist government and its offices in Hankou, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101939 | 24101939 | |
45610 | 45610 | 1927-04-09 | 5 | a-c | Foreign reports on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101941 | 24101941 | |
45611 | 45611 | 1927-04-09 | 7 | a-b | Australia news/ A Sydney man fights his rival in love. A Chinese gardener is beaten by his friends. Burglary of a bakery shop in Sydney. New committee of the Chinese Chamber of Committee, its meeting and speakers include Wu Elou (Xiuguang), Wu Zhaoquan, Liu Guangfu, Guo Jianying, Zheng Fanchang, Ye Bingnan, Liu Chunxi, Tan Liangnan, Huang Guangzhao, Peng Lichuan, Zhu Peiqing and others. Police in Sydney raid Chinese gambling dens. Tobacco growers in north New South Wales and the new requirements by the state government. Bus ticket price to be increased in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101943 | 24101943 | |
45612 | 45612 | 1927-04-09 | 7 | d | News from Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101943 | 24101943 | |
45613 | 45613 | 1927-04-09 | 7 | d | Stories of Qian Jiang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101943 | 24101943 | |
45614 | 45614 | 1927-04-09 | 8 | a-d | Guangdong news/ Provincial government to draft labour laws. A survey on the county magistrates in Guangdong. Jiang Jieshi to discipline his troops. The Nationalist government sets up special committee for overseas Chinese affairs. Businessmen and residents in Foshan support the river project. Labour organisation in Shantou. Provincial government dispatches troops to take over the Ningyan railway line. Clashes in Xiangshan county over the closure of shops. International Labour Organisation and its representatives in Guangzhou. People in Taishan county have different opinions on the county magistrate Liu Zhaifu. | China | http://trove.nla.gov.au/newspaper/page/24101946 | 24101946 |
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]);