This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42899 | 42899 | 1925-03-28 | 2 | a-b | The end of Sun Yatsen, editorial by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101078 | 24101078 | |
42904 | 42904 | 1925-03-28 | 3 | a-b | Chinese government regains the submarine cable in Qingdao, of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42927 | 42927 | 1925-03-28 | 7 | a-b | Chinese Chamber of Commerce in Sydney gathers to congratulate their new board directors. Speakers include Su Yiguang, Wu Zhaoquan, Zhu Songqing, Chen Qingyi, Guo Jianying, Zheng Fanchang, Pan Yonghan, Liu Junchen, Wu Elou, Guo Jiexiu, Zhang Fu, Chen Zanhua, Lin Run, and Liu Guangfu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 |
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]);