This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44070 | 44070 | 1925-10-31 | 9 | One page | China-Australia Navigation Company Ltd (zhong ao hang ye you xian gong si) is trying to raise more funds by floating shares. Chinese shops & businessmen involved are Wing Sang & Co, Lee Sang & Co, Wing On & Co, Kwong War Chong, Sun Chong Shing, Yuen Tiy Tong Kee, John Hoe & Co, Quinn Young & Co, Chew Lee & Co, Guan Kangqi, Liu Zuozhou, Lei Miaohui, Deng Jia, Huang Zhu, Chen Lin, Zhan Fu, Lei Ji, Liu Guangfu, and Wu Gen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101335 | 24101335 |
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]);