This data as json, CSV (advanced)
Suggested facets: page, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43013 | 43013 | 1925-04-18 | 2 | a-b | Editorial on the Guangdong government and its policy to deal with the aftermath. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101102 | 24101102 | |
43014 | 43014 | 1925-04-18 | 2 | b-d | First part of a declaration issued by Duan Qirui on national construction. | China | http://trove.nla.gov.au/newspaper/page/24101102 | 24101102 | |
43015 | 43015 | 1925-04-18 | 2-3 | d-a | Duan Qirui puts forward his proposal for arms control. | China | http://trove.nla.gov.au/newspaper/page/24101102 | 24101102 | |
43016 | 43016 | 1925-04-18 | 2 | e | Simpsons Company Ltd, Sydney, owned by Li Rufu and his Western partners, is to raise more funds by floating shares. People to contact are Guo Chao, Li Chun, Ye Bingyuan, Ouyang Nan, Wu Zizhi, Li Rufu, Li Shaoqin, Chen Yin, Yu Rong, Huang Zhu, Chen Zanhua, Li Xiangbo, Li Xingyang, Wu Zhaoquan, Zhan Fu, Su Congfang, Wu Elou, Lei Peng and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101102 | 24101102 |
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]);