This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25488 | 25488 | 1911-12-30 | 2 | c | Japanese views | British troops may occupy railways in Northeast China. Troops of other countries are reluctant to interfere China's affairs but Japan is waiting for chance. America is helping revolutionaries and has ambition in China. Russia is going to help Man government for benefits in Mongolia and Manchu. | Japan | http://trove.nla.gov.au/newspaper/page/24092051 | 24092051 |
25500 | 25500 | 1911-12-30 | 3 | b | Letters from Japan | Overseas Chinese students studying military in Japan are allowed to return to China. A Chinese consulate in Japan sold office properties and fled. Chinese students in Japan are short of fund and Chinese ambassador returns to China. | Japan | http://trove.nla.gov.au/newspaper/page/24092050 | 24092050 |
25507 | 25507 | 1911-12-30 | 6 | b | Overseas Chinese students in Japan | All Chinese students in Japan decide to return to China and serve for revolutionary government. | Japan | http://trove.nla.gov.au/newspaper/page/24092055 | 24092055 |
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]);