This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39375 | 39375 | 1923-02-03 | 8 | a-b | Chinese Chamber of Commerce in New South Wales calls for donation to the flooding victims in Zhejiang province. Contact details are: Chinese Chamber of Commerce, 52 Dixon Street, Haymarket, Sydney; Lee Sang & Co, Produce Merchants, Corner of Hay and Harbour Streets, Sydney; Wing On & Co, 10-11 Ultimo Road, Sydney; On Chong & Co, 225 George Street North, Sydney; Sun Tuey Wah Chockson & Co, 75-79 Campbell Street, Haymarket, Sydney; Goon Lee Shing & Co, Merchants, 37 Dixon Street, Sydney. Names listed for the donations received. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094284 | 24094284 | |
| 39376 | 39376 | 1923-02-03 | 8 | b-d | Guangdong news/ Army barracks in Qianshan are robbed. Robbery in Dongguan county. Ferry workers in Enping, Kaiping and Taishan counties. Barge explodes in Xiangshan and the injuries. Students are kidnapped in Qianshan. Ferry is hijacked in Gaoming county. Security check ordered in the countryside. Firewood in shortage in Zhaoqing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094284 | 24094284 | |
| 39377 | 39377 | 1923-02-03 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094284 | 24094284 | |
| 39378 | 39378 | 1923-02-03 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094284 | 24094284 |
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]);