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 |
---|---|---|---|---|---|---|---|---|---|
45163 | 45163 | 1926-09-18 | 8 | a-d | Guangdong news/ The Nationalist government in Guangzhou issues the second bonds. Troops loot in Taishan county. Charity institutions in Guangzhou and their call for help in the disaster relief. Bandits in Gaoyao county. Zou Lu seeks collaboration with bandits in Xiangshan county. | China | http://trove.nla.gov.au/newspaper/page/24101718 | 24101718 | |
45162 | 45162 | 1926-09-18 | 7 | b-c | The arrest and exile of Chinese immigrants in the Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
45161 | 45161 | 1926-09-18 | 7 | b | Heavy rain in New York. | America | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
45160 | 45160 | 1926-09-18 | 7 | a | The war in Wuhan, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
45159 | 45159 | 1926-09-18 | 7 | a | Australia news/ The Labour Party in New South Wales opposes to any interference with the Chinese affairs. Australian naval fleet may join the action in China. A Chinese is robbed in Sydney. Fighting in the Chinese temple in Melbourne. Tragedy of railway accident in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101715 | 24101715 | |
45158 | 45158 | 1926-09-18 | 6 | b-c | The Chinese Chamber of Commerce in Sydney organises a special committee for the birthday celebration of Confucius. Name of the committee members and photograph of Chen Zanhua, chairman of the committee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101716 | 24101716 | |
45157 | 45157 | 1926-09-18 | 5-6 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101713 | 24101713 | |
45156 | 45156 | 1926-09-18 | 3 | f | Defence plan of the Jiangxi authority. | China | http://trove.nla.gov.au/newspaper/page/24101711 | 24101711 | |
45155 | 45155 | 1926-09-18 | 3 | f | Sun Chuanfang's attitude towards Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101711 | 24101711 | |
45154 | 45154 | 1926-09-18 | 3 | d | Jiang Jieshi (Chiang Kai-shek) is keen to occupy Jiangxi province and his strategies. | China | http://trove.nla.gov.au/newspaper/page/24101711 | 24101711 | |
45153 | 45153 | 1926-09-18 | 2 | f | War news from the Northwest China. | China | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
45152 | 45152 | 1926-09-18 | 2 | e | Department of Justice in Beijing orders to reform the prison. | China | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
45151 | 45151 | 1926-09-18 | 2 | d | Wu Peifu on the organisation of Chinese cabinet. | China | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 | |
45150 | 45150 | 1926-09-18 | 2 | c | Editorial on the situation changes in Hunan and Hubei following the war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101712 | 24101712 |
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]);