This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55754 | 55754 | 1936-01-25 | 8 | a | Comments by Tung Wah Times condemn the Republic News (min bao) in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096725 | 24096725 | |
55755 | 55755 | 1936-01-25 | 8 | e | King George V of Britain passed away. | Britain | http://trove.nla.gov.au/newspaper/page/24096725 | 24096725 | |
55756 | 55756 | 1936-01-25 | 8 | e | Inner Mongolia seeks for independence. | China | http://trove.nla.gov.au/newspaper/page/24096725 | 24096725 | |
55757 | 55757 | 1936-01-25 | 8 | f | Australia news/ Federal Reserve Bank sees more savings. Chinese businessman in Sydney Zhou Caiyun dies. Illegal Chinese immgrants on aboard of Greek ship. Zhu Mingjie, former employee of the Republic News (min bao) in Sydney, is arrested in Cairns, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096725 | 24096725 | |
55758 | 55758 | 1936-01-25 | 8 | f | The Chinese School in Wellington, New Zealand, is on holiday and its meeting. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096725 | 24096725 | |
55759 | 55759 | 1936-01-25 | 8 | g | Acknowledgement of the Sydney Chinese Christian Association for the condolences of teh death of Zhou Caiyun. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096725 | 24096725 |
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]);