This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40953 | 40953 | 1924-01-19 | 3 | c-d | Shanghai businessmen ask Sun Yatsen to stop withholding tariff income. | China | http://trove.nla.gov.au/newspaper/page/24100573 | 24100573 | |
40971 | 40971 | 1924-01-19 | 7 | c-d | Sydney Chinese School is opened at the Chinese Chamber of Commerce on 52 Dixon Street. Its name, address, timetable, mission, organisation and others. Directors of the school include Ye Tonggui, Ye Bingnan, Zheng Fanchang, Zhu Hechou, Chen Lin, Liu Guangfu, Guo Chao, Ye Guoen, Chen Yin, Ma Zanfen, Lin Dasan, and Cai Rong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100577 | 24100577 |
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]);