This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41808 | 41808 | 1924-07-12 | 6 | a | Chinese business community in Sydney farewells Tang Longxiang and thanks for his contributions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
41809 | 41809 | 1924-07-12 | 6 | b-d | The new restriction issued by American authority to the Chinese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
41810 | 41810 | 1924-07-12 | 6 | d | Shareholders meeting of the Shanghai Wing On Textile Company Ltd in Sydney and election of the board directors including Guo Le, Guo Quan, Ma Zuxing, Yang Huiting, Guo Biao, Guo Ruixiang, Du Zewen, Lin Haichou, Guo Yongshao, Hu Yaoting, Li Yanxiang, Guo Xianwen, Ouyang Minqing, Chen Zhuchen, Guo Ganxun, Liu Shengchu, and Li Jiongtang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
41811 | 41811 | 1924-07-12 | 6 | d-e | Anti-Chinese movement in Peru. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 |
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]);