This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45697 | 45697 | 1927-05-07 | 7 | a-b | Australia news/ Wu Elou reports safety on his way back to China. An old woman in Sydney commits suicide. Advertisement article for New Zealand Redwood Forests Ltd. Expenditure for the welcome of Prince Edward, Duke of York. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101977 | 24101977 | |
45698 | 45698 | 1927-05-07 | 7 | b | The first woman magistrate in Pinnan county, of Fujian province, Wang Xiaoying and her story. | China | http://trove.nla.gov.au/newspaper/page/24101977 | 24101977 |
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]);