This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54905 | 54905 | 1935-02-23 | 6 | a | Chinese General Cai Tingkai comes to visit Australia. Communications between Cai Tingkai and the Chinese Welcome Committee in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54906 | 54906 | 1935-02-23 | 6 | a | Daily Telegraph in London on the future Yellow Peril. | Britain | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54907 | 54907 | 1935-02-23 | 6 | b | British and the naval port in Singapore. | Britain | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54908 | 54908 | 1935-02-23 | 6 | b | Hong Kong and Guangdong to jointly fight pirates. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54909 | 54909 | 1935-02-23 | 6 | c | American defence in the Pacific region. | Britain | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54910 | 54910 | 1935-02-23 | 6 | c | Atrocities of the communists in north Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 | |
54911 | 54911 | 1935-02-23 | 6 | d | Australia news/ Chinese swimmer Guo Zhenheng will not visit Sydney. Indian immigrant permitted to land for a visit to his family in Australia. White man is penalised for opium smuggling. New materials invented in Sydney for ship building. Chinese communities in Sydney prepare to welcome General Cai Tingkai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096339 | 24096339 |
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]);