This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41031 | 41031 | 1924-02-02 | 8 | a-d | Guangdong news/ Negotiation in Guangzhou over the tariff collections. Businessmen in Guangzhou are required to pay tax for the fourth time. Protection of private property in Guangzhou. Liao Zhongkai is on the way to visit Japan and his mission. Shen Hongying's army enter Guangdong from Hunan in the north. Battle in Beijing area. Shen Hongying's army take over Lianzhou and Li Jiyuan flees to Guangzhou. Sun Yatsen orders his troops to take over Xiangshan county. Xiangshan people in Guangzhou are trying to protect their home town. Warship from Fujian province arrives Shantou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100596 | 24100596 | |
41032 | 41032 | 1924-02-02 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100596 | 24100596 | |
41033 | 41033 | 1924-02-02 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100596 | 24100596 |
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]);