This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13456 | 13456 | 1904-07-02 | Suppl't | a | An article, published in Sydney's Sunday Times, says Chinese businesses in Sydney are now in crisis as many Chinese businessmen are leaving. The article is written after interviewing with Chen Xia and Sun Junchen, two Chinese businessmen in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/26800471 | 26800471 |
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]);