This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45680 | 45680 | 1927-05-07 | 2 | b | Editorial acclaims the removal of unqualified judges in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101974 | 24101974 | |
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 | |
45700 | 45700 | 1927-05-07 | 8 | e | Liner timetable. Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101982 | 24101982 |
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]);