This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40062 | 40062 | 1923-07-07 | 2 | b-d | Protest movement in Shanghai against Japan. | China | http://trove.nla.gov.au/newspaper/page/24094464 | 24094464 | |
40085 | 40085 | 1923-07-07 | 8 | b-d | Guangdong news/ Old people, the blinds and beggars in Guangzhou plea not to sell the charity institute. The First Park in Guangzhou to be mortgaged for foreign loans. Pressgang in Nanhai and Panyu counties and the panic. Zhaoqing people plea for help. Li Yaohan's troops station in Xinxu town, of Gaoyao county. Yunnan army commander Yang Baili asks for supplies. See Yup area in crisis. Guangdong army takes over Boluo and report from the front line. Shen Hongying is preparing for counterattack. Plea for release of Zhong Xifen, gentry in Guangzhou. Battle report from See Yup. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094470 | 24094470 |
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]);