This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54568 | 54568 | 1934-10-06 | 2 | a | First part of an editorial on Confucianism and the national crisis in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096182 | 24096182 | |
54579 | 54579 | 1934-10-06 | 5 | d | A visit to the grave of Hai Rui, official of the Ming Dynasty. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096183 | 24096183 | |
54589 | 54589 | 1934-10-06 | 6 | e | Australia news/ Statistics about Australia for the first half of this year. The Labour Party is defeated in the federal election. Performance of Chinese boxing coach Huang Boquan. Population on the Nauru island. More European women are smoking. Furniture industry in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 |
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]);