This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42018 | 42018 | 1924-08-30 | 6 | a-b | Comments written by Yu Wenhou on the American new restriction on Japanese immigrant. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100845 | 24100845 | |
42019 | 42019 | 1924-08-30 | 6 | b-c | Opposition to the establishment of another province in south Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100845 | 24100845 | |
42020 | 42020 | 1924-08-30 | 6 | c | Sugar industry on strike in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100845 | 24100845 | |
42021 | 42021 | 1924-08-30 | 6 | b-d | The National Commercial & Savings Bank Ltd, Hong Kong, to set up three more branches in Guangzhou, Shanghai and Hankou, and to raise more funds by floating shares. The statement and constitution of the bank. Directors include Wang Guoxuan, Ma Yingbiao, Li Hanshan, Tang Xin, Guo Quan, Chen Shaoxia, Ou Liang, Cai Chang, Cai Xing, Ma Yongcan, Kuang Mingjue, Ma Zurong, Huang Zaichao, Chen Ganshi, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100845 | 24100845 |
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]);