This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42119 | 42119 | 1924-09-27 | 2 | a-b | Editorial on the possible national unification by force in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100873 | 24100873 | |
42120 | 42120 | 1924-09-27 | 2 | b | A telegram from the Guangdong commercial chambers to the Chinese Chamber of Commerce in New South Wales on their conflict with government troops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100873 | 24100873 | |
42121 | 42121 | 1924-09-27 | 2 | c-d | Wing On Life Assurance Company Ltd is established and raises more funds by floating shares among the Australian Chinese communities. Initiators are Wing On companies in Shanghai, Hong Kong, Sydney, Wing On Insurance Company Ltd and Wing On Textile Company Ltd, Shanghai. The preparatory committee members include Guo Biao, Ma Zuxing, Guo Le, Guo Quan, Ouyang Minqing, Guo Ruixiang, Du Zewen, Guo Shun, Liang Chuang, Lin Binan and many others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100873 | 24100873 |
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]);