This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46605 | 46605 | 1927-12-31 | 2 | b | Editorial by Tung Wah Times expresses worries about China under the pernicious influence of the Communist movement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098648 | 24098648 | |
46624 | 46624 | 1927-12-31 | 7 | a | Australia news/ Telegram from Tang Shaoyi to the Australian Chinese communities on the Communist riots in Guangdong and the disasters. The Sun and other Australian companies in Hong Kong are safe. Three suspects are arrested in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098651 | 24098651 | |
46625 | 46625 | 1927-12-31 | 7 | b | The anti-Japanese sentiments and associations in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098651 | 24098651 | |
46627 | 46627 | 1927-12-31 | 8 | e | Advertisement for the Commercial Banking Company of Sydney Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098654 | 24098654 |
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]);