This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44866 | 44866 | 1926-06-19 | 8 | a-d | Guangdong news/ Jiang Jieshi seeks alliance from Sun Chuanfang. Xu Qian sends another telegram to the Guangzhou government. Envoy of Xu Chongzhi on the way to Guangzhou. Guarantee needed for the release of Li Zhilong. | China | http://trove.nla.gov.au/newspaper/page/24101606 | 24101606 |
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]);