This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45630 | 45630 | 1927-04-16 | 7 | a-b | Australia news/ A doctor in Melbourne talks to English newspaper on China and the Chinese people. Oriental Arts Company Ltd in Sydney welcomes Chinese artists and their names listed. Royal Agricultural Show opened in Sydney. A case of rape in Surrey Hills, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101951 | 24101951 |
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]);