This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42771 | 42771 | 1925-02-28 | 5 | a-d | Articles written by anonymous authors condemn Huang Laiwang, Liu Boming, Xu Richu, and other Nationalist Party (Guomindang) members in Sydney and their radical propaganda. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101047 | 24101047 | |
42788 | 42788 | 1925-02-28 | 8 | a-d | Guangdong news/ Homicide case in Guangzhou and involvement of servicemen. Guangzhou Chamber of Commerce elects new chairman. Charity institutions in Guangzhou protect interest of businessmen. Shen Hongying moves all his troops to Zhaoqing. Defence in Zengcheng county. Military situation in Dongguan county. Military officers are forbidden to occupy house of local residents. A woman in Xiangshan county murders her husband. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101052 | 24101052 |
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]);