This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39077 | 39077 | 1922-12-02 | 2 | a-b | Editorial on the crisis encountered by Chen Jiongming. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094204 | 24094204 | |
39086 | 39086 | 1922-12-02 | 3 | c-d | An investigation on the cement factory in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094203 | 24094203 | |
39091 | 39091 | 1922-12-02 | 6 | a | Advertisement for the Wing On Textile Company Ltd in Shanghai (Guo Le, Guo Shun and Liang Chuang). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094208 | 24094208 | |
39092 | 39092 | 1922-12-02 | 6 | a-b | Tung Wah Times comments on the bomb blast in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094208 | 24094208 | |
39094 | 39094 | 1922-12-02 | 7 | a | Two bank robbers are arrested in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094207 | 24094207 | |
39097 | 39097 | 1922-12-02 | 7 | b | Chinese community in Tamworth, New South Wales, celebrates the birthday of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094207 | 24094207 | |
39098 | 39098 | 1922-12-02 | 7 | b | Business hours for the coming Christmas holiday in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094207 | 24094207 | |
39100 | 39100 | 1922-12-02 | 7 | b-c | Bandit suppressed in Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094207 | 24094207 | |
39101 | 39101 | 1922-12-02 | 8 | a-c | Guangdong news/ Provincial legislature assembly approves to borrow foreign loans in order to save the currency system. Chen Jiongming is planning to organise a political party. Journalist in Guangzhou and the threat to them. Investigation on the bomb blast in Guangzhou. More than 50 county magistrates are sued. Division commander Guan Guoxiong dies of disease. Bandits hijack the ferry from Jiangmen to Shiqi. Even women are kidnapped in Xiangshan county. River dam construction in Songlong, of Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094210 | 24094210 | |
39102 | 39102 | 1922-12-02 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094210 | 24094210 | |
39103 | 39103 | 1922-12-02 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094210 | 24094210 |
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]);