This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43597 | 43597 | 1925-08-08 | 3 | a-d | Public notices issued or transmitted by the Chinese consulate-general in Melbourne on the proposed national representatives congress to be held in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101233 | 24101233 | |
43618 | 43618 | 1925-08-08 | 6 | a-d | The Guangzhou-Hankou railway company and its secret plan to borrow more foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24101238 | 24101238 | |
43630 | 43630 | 1925-08-08 | 8 | a-d | Guangdong news/ Communism in Guangzhou. Xu Chongzhi and Hunan army moves out of Guangzhou. Most of the Guangxi army have been incorporated. Conflict between Wu Teaching and Hu Hanmin. Military clashes in Chaozhou and Meixian. Chinese communities in American prepare to start air industry in Guangdong. Duan Qirui sends envoy to comfort Yunnan and Guangxi armies. Clashes between Chinese and foreign businessmen in Guangzhou and the casualties. A factory in Guangzhou turns into a brothel. Boycott to American goods in Guangzhou. Hong Kong authority responds to the strike. Chinese newspapers in Hong Kong stop publishing because of the strike. Some Chinese shops in Hong Kong are closed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101240 | 24101240 |
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]);