This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41989 | 41989 | 1924-08-23 | 6 | a-b | First part of the comments written by Yu Wenhou on the open-door policy in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100837 | 24100837 | |
41990 | 41990 | 1924-08-23 | 6 | b | American government issues new restriction on Chinese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100837 | 24100837 | |
41991 | 41991 | 1924-08-23 | 6 | c | Chinese students are barred from entry into America. | America | http://trove.nla.gov.au/newspaper/page/24100837 | 24100837 | |
41992 | 41992 | 1924-08-23 | 6 | c | The anti-Chinese movement in Peru and the negotiations. | Other... | http://trove.nla.gov.au/newspaper/page/24100837 | 24100837 | |
41993 | 41993 | 1924-08-23 | 6 | b-e | 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/24100837 | 24100837 |
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]);