This data as json, CSV (advanced)
Suggested facets: source, 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 | |
18686 | 18686 | 1907-12-28 | 6 | a-b | Britons in Hong Kong and their motives in south China, prepared by Cheng Yannong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801592 | 26801592 | |
18707 | 18707 | 1907-12-28 | 8 | a-b | Third and final part of the report, prepared by Chen Huanzhang, on celebrations organised by Chinese communities in New York on the birthday of Confucius. | America | http://trove.nla.gov.au/newspaper/page/26801594 | 26801594 |
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]);