This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18684 | 18684 | 1907-12-28 | 3 | a-b | Guangdong news. Guangdong businessmen raise funds to cultivate wasteland in Heilongjiang province. Guangdong army to recruit soldiers in Hunan and Hubei provinces. Germans investigate the population, local system and other things in Guangdong. Businessmen in Panyu are trying to set up a textile factory. Businessman Ye Yutian's asset has been frozen by the government authority. Governor Zhang Renjun is controlled by his subordinates. Gentry in Xiangshan county are discussing Portuguese occupation of Waichai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801587 | 26801587 | |
18685 | 18685 | 1907-12-28 | 3 | c-d | Railway news. Reports on the chaos in Jiangsu and Zhejiang provinces over railway building and application for foreign loans. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801587 | 26801587 |
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]);