This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
42789 | 42789 | 1925-02-28 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101052 | 24101052 | |
42790 | 42790 | 1925-02-28 | 8 | e | Liner timetable. | 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]);