This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39269 | 39269 | 1923-01-13 | 6 | a-d | National Commercial Association in Shanghai sends telegram to President Li Yuanhong on the arrest of treasurer Luo Wengan. Kang Youwei comments on the arrest of Chinese treasurer Luo Wengan. Internal Affairs Minister Sun Danlin on the arrest of Luo Wengan. | China | http://trove.nla.gov.au/newspaper/page/24094256 | 24094256 |
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]);