This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29394 | 29394 | 1914-11-14 | 7 | a | A notice issued by Chinese Consul-General in Australia Zeng Zongjian on the arrival of Chinese businessmen, family reunion and others. A reply from Zong Zengjian on the family tragedy of Chinese businessman Ouyang Yexun. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093323 | 24093323 | |
29395 | 29395 | 1914-11-14 | 7 | a-b | Australia news/ Two men quarrel in a Sydney restaurant for the World War I. Survey on the export of flour and rice from Sydney. Chinese boxer Chen Tianshang, son of businessman Chen Yong and born in New Castle, wins a match in Sydney. Chinese gamblers are detained in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093323 | 24093323 | |
29396 | 29396 | 1914-11-14 | 7 | b-c | Miscellaneous report on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24093323 | 24093323 | |
29397 | 29397 | 1914-11-14 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093323 | 24093323 |
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]);