This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 |
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]);