This data as json, CSV (advanced)
Suggested facets: 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 |
25502 | 25502 | 1911-12-30 | 3 | c | Beijing news | Beijing government delays to refund foreign loans. Beijing people depend on Yuan Shikai to rescue crisis. Republic school and imperial constitutional school meets to solve differences. Many government spies are found in Wuhan. Shangdong announces independent in order to make China separate. Yu Hepu escaped to Shanghai after revolution. Li Laoba, Li Zichun escaped to Shanghai. Wang Yuhong is leading a survey troop. | China | http://trove.nla.gov.au/newspaper/page/24092050 | 24092050 |
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]);