This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21911 | 21911 | 1909-11-06 | 2-3 | d-a | Guangdong news/ Man on trial for the murder of Liu Shiji. Chinese ambassador to Italy Qian Xun proposes that China participate in the coming business fair. Guangdong government is asked to purchase gunboat. Portuguese envoy and the demarcation of Macao border. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802384 | 26802384 |
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]);