This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42224 | 42224 | 1924-10-25 | 3 | b | Sun Yatsen orders to disband all commercial associations in Guangdong. An urgent telegram from the Guangdong commercial chambers to the Chinese Chamber of Commerce in Sydney over their fighting with the government authority. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
42225 | 42225 | 1924-10-25 | 3 | b-c | The League of Nations and China, a report from London. | Britain | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
42226 | 42226 | 1924-10-25 | 3 | c | Duan Qirui publicly attacks Cao Kun and his Zhixi faction. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
42227 | 42227 | 1924-10-25 | 3 | c-d | The war between Jiangsu and Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
42228 | 42228 | 1924-10-25 | 3 | d | Sun Yatsen orders to disarm all commercial associations. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
42229 | 42229 | 1924-10-25 | 3 | d | Sun Yatsen sets fire in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
42230 | 42230 | 1924-10-25 | 3 | e | Xu Shuzheng and the Anfu faction are back to life in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
42231 | 42231 | 1924-10-25 | 3 | e | International settlement in Shanghai refuses to admit Xu Shuzheng. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 | |
42232 | 42232 | 1924-10-25 | 3 | e | The war between Jiangsu and Zhejiang comes to an end. | China | http://trove.nla.gov.au/newspaper/page/24100904 | 24100904 |
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]);