This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42237 | 42237 | 1924-10-25 | 7 | a | English newspaper in Sydney comments Sun Yatsen. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42238 | 42238 | 1924-10-25 | 7 | a | Bandits in Melbourne kidnap policeman. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42239 | 42239 | 1924-10-25 | 7 | a | A Sydney man is penalised for sexual harassment. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42240 | 42240 | 1924-10-25 | 7 | b | Burglary of a jewellery in Newtown, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42241 | 42241 | 1924-10-25 | 7 | b | Investigation of a case of raping in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42242 | 42242 | 1924-10-25 | 7 | b | Optimism on the sale of shares of the Wing On Life Assurance Company Ltd, Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42243 | 42243 | 1924-10-25 | 7 | c | Further report on the looting and burning committed by Sun Yatsen's troops in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42244 | 42244 | 1924-10-25 | 7 | c | Chen Jiongming's army launch a counterattack. | China | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42245 | 42245 | 1924-10-25 | 7 | c | Anti-Chinese movement in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42246 | 42246 | 1924-10-25 | 7 | c | Battle in the Dongjiang area, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42247 | 42247 | 1924-10-25 | 7 | c-d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42248 | 42248 | 1924-10-25 | 7 | d | A notice by the Zhenguang Company Ltd, Hong Kong, to its shareholders. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
42249 | 42249 | 1924-10-25 | 7 | d | A notice by the Chinese Chamber of Commerce in Sydney and their support to the Guangdong commercial chambers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 |
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]);