This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26101 | 26101 | 1912-05-04 | 6 | a-b | Headline news | Sun Yatsen is to make foreign loans to build railways. Li Yuanhong is worring about the social disorders resulted from many selfish parties. Mu Jipeng criticises the republican government in being unable to keep social order. Xu Maoshan criticises the republican government is worse than Qing government in making foreign loans. Some Ally members suggest that Ally Association should be dissolved and a new party should be set up. | China | http://trove.nla.gov.au/newspaper/page/24092228 | 24092228 |
26102 | 26102 | 1912-05-04 | 6 | b-c | Issues of the case of Shanghai newspapers being slandered by the Ally Association | Newspaper circle in China are shocked by the slander of Guangdong branch of China's Ally Association which refused to admit. | China | http://trove.nla.gov.au/newspaper/page/24092228 | 24092228 |
26103 | 26103 | 1912-05-04 | 6 | c | Stubborn Sheng Yong | Sheng Yong explains that his rebel is forced by both the previous Qing government and the current republican government. | China | http://trove.nla.gov.au/newspaper/page/24092228 | 24092228 |
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]);