This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30954 | 30954 | 1916-01-29 | 8 | a | Special issue/ Tan Xueheng's plan for regulating rivers in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24095131 | 24095131 | |
30955 | 30955 | 1916-01-29 | 8 | a-b | Chen Qi, chief official in Panama International Contest, says that Chinese products in American Philadelphia Exhibition are of poor quality and demands Chinese government to send some good ones. | China | http://trove.nla.gov.au/newspaper/page/24095131 | 24095131 | |
30956 | 30956 | 1916-01-29 | 8 | b-c | Guangdong news/ A huge snake is found in Hushan, Guangdong. Bandits in Panyu, Guangdong, are very active and government troops cannot deal with them. Government troops conflict with villagers in Xinhui, Guangdong, resulting many casualties. A police branch is set up in Qingxiang, Guangdong. Two detectives are sentenced to death for slanting innocent people. Some weapons of the revolutionary party are transported through Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24095131 | 24095131 |
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]);