This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9831 | 9831 | 1902-02-22 | 2 | a | Imperial edicts on November 15. | China | http://trove.nla.gov.au/newspaper/page/24100334 | 24100334 | |
9846 | 9846 | 1902-02-22 | 3 | a | The Chinese community in Western Australia sent a plea telegram to the Beijing government asking their help to stop Australia's ban of Chinese entry. Signatories include Chen He, Zhao Lianji, Ye Xiuhua, Lei Hua, Song Guang, Zhong Hongjie, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100333 | 24100333 | |
9847 | 9847 | 1902-02-22 | 3 | a | America, Italy and the Netherlands will set up their banks in Shanghai in order to collect the Boxer Indemnity. | China | http://trove.nla.gov.au/newspaper/page/24100333 | 24100333 | |
9848 | 9848 | 1902-02-22 | 3 | a | Liu Kunyi has captured some secret society members in the Yangtze River area. | China | http://trove.nla.gov.au/newspaper/page/24100333 | 24100333 | |
9849 | 9849 | 1902-02-22 | 3 | a | Relationship between Liang Dingfen, magistrate of Wuchang, his wife, and Wen Tingshi. | China | http://trove.nla.gov.au/newspaper/page/24100333 | 24100333 | |
9850 | 9850 | 1902-02-22 | 3 | a | Fourth and final part of a report from the Board of Rites regarding reform of the imperial examination. | China | http://trove.nla.gov.au/newspaper/page/24100333 | 24100333 |
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]);