This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19356 | 19356 | 1908-05-16 | 6 | a | A notice from the Chinese Empire Reform Association in Sydney to its members and other Chinese fellows in Australia regarding the Political Research Society (zheng wen she), a political party established in Tokyo to replace the Chinese Empire Reform Association and now headquartered in Shanghai, admission into this party, Kang Youwei's proposed visit to Australia, and other issues of the Association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801737 | 26801737 | |
19357 | 19357 | 1908-05-16 | 6 | a-c | China's national shame and the boycott of Japanese goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801737 | 26801737 |
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]);