This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4917 | 4917 | 1900-04-07 | 3 | a-b | Four executives of Chinese Empire Reform Association from Sydney, Liu Ruxing, Ouyang Wanqing, Miu Dianchen and Chen Shou, travel to New Castle to promote the Protect Emperor movement there. Su Jingling presided over the meeting. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102758 | 24102758 | |
4918 | 4918 | 1900-04-07 | 3 | b | A reader's letter from New Castle saying Chinese audience was deeply moved by speeches of the four executives of Sydney Chinese Empire Reform Association. Letter written by Miu Qiao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102758 | 24102758 | |
4919 | 4919 | 1900-04-07 | 3 | c | Reports on the war between Britain and Transvaal, South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102758 | 24102758 | |
4920 | 4920 | 1900-04-07 | 3 | c | Bandits Ou Xin and Ou Biao in Panyu surrendered themselves to the local government. | China | http://trove.nla.gov.au/newspaper/page/24102758 | 24102758 | |
4921 | 4921 | 1900-04-07 | 3 | d | Five Chinese, on the way from New Zealand to China, were permitted to land in Sydney to visit their friends and family members. The landing was guaranteed by Zheng Tianlu, editor of Tung Wah. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102758 | 24102758 |
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]);