This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39862 | 39862 | 1923-05-19 | 3 | b-c | Guangdong students send telegram to foreign missions in Beijing seeking their sympathy and support in China's negotiation with Japan. | China | http://trove.nla.gov.au/newspaper/page/24094407 | 24094407 | |
39879 | 39879 | 1923-05-19 | 7 | b-c | News in brief/ Emperor Xuantong sends envoy to meet President Li Yuanhong. Chinese ambassadors in Europe send telegram to Beijing on the negotiation with Japan. A telegram from Zhang Shaozeng cabinet in Beijing to Sun Yatsen in Guangzhou. Sichuan, Hunan, Yunnan and Guizhou to defend their alliance. Zhang Shaozeng and Li Yuanhong on Fujian issues. Navy in Shanghai declares neutral. Sun Chuanfang arrives Fuzhou. Wu Peifu's troops arrive Rehe. Cao Kun and Feng Yuxiang on the Fengtian issues. Sun Yatsen replies to Li Yuanhong and Zhang Shaozeng. President Li Yuanhong on the murder of naval commander Cheng Biguang. Naval fleets gather in Shanghai. Military situation in Sichuan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 |
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]);