This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55991 | 55991 | 1936-04-25 | 3 | a | An open letter from the Chinese chamber of commerce in Dutch colonies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096823 | 24096823 | |
55992 | 55992 | 1936-04-25 | 3 | a | Attempt of coup in Thailand and the involvement of Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096823 | 24096823 | |
55993 | 55993 | 1936-04-25 | 3 | a | Japanese are preparing for the invasion of south China. | China | http://trove.nla.gov.au/newspaper/page/24096823 | 24096823 | |
55994 | 55994 | 1936-04-25 | 3 | b | Chinese tourists from Sumatera visit Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096823 | 24096823 | |
55995 | 55995 | 1936-04-25 | 3 | d | An open letter from Chen Wenzhu, principal of the High School of Lingnan University in Guangzhou who comes to raise funds for the school development. Donations of the Chinese communities in Australia to the Lingnan University. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096823 | 24096823 | |
55996 | 55996 | 1936-04-25 | 3 | d | Donations to the Gaoyao county hospital by the Australian Chinese communities and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096823 | 24096823 |
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]);