This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30933 | 30933 | 1916-01-29 | 2 | b-c | Comment on current situation/ Prediction of China's future after restoring imperial system. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095126 | 24095126 | |
30945 | 30945 | 1916-01-29 | 3 | b-c | Treaty of Japan and Russia on Near East is to declared soon. | Japan | http://trove.nla.gov.au/newspaper/page/24095125 | 24095125 | |
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]);