This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45192 | 45192 | 1926-10-02 | 6 | a-b | A survey on the Guangdong business in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101732 | 24101732 | |
45193 | 45193 | 1926-10-02 | 6 | b | Commercial Bank of Australia makes huge profit. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101732 | 24101732 | |
45194 | 45194 | 1926-10-02 | 6 | b | Chinese community in Sydney prepares for the birthday celebration of Confucius and the detailed report. Photograph of Mrs Wu Yangshou (Mrs U. Young Show), honorary organiser, Ladies' Committee of the Confucius Commemoration picnic under the auspices of the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101732 | 24101732 |
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]);