This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21799 | 21799 | 1909-10-16 | 2 | a-b | The last word from Manchurian official Yong Lin to Prince Regent. | China | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21800 | 21800 | 1909-10-16 | 2 | b | News on the death of Zhang Zhidong and his photograph. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21801 | 21801 | 1909-10-16 | 2 | b-c | News in brief/ Local governors and the naval building. Na Tong suggests an alliance between China, America and Germany. Demarcation on Macao border is going peacefully. Canadian authority agrees to remove poll tax imposed on Chinese immigrants. Zhang Yintang on the way to America as new ambassador. British ambassador demands contracts for Sichuan-Hubei railway. Sun Jialai seeks to retire. Businessman Zhang Yunan donates to Chinese navy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21802 | 21802 | 1909-10-16 | 2 | c | Duan Fang and Lu Zhengxiang ask for lift of the ban on political party. | China | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21803 | 21803 | 1909-10-16 | 2 | c | Newspapers in Beijing are to organise their own association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21804 | 21804 | 1909-10-16 | 2 | c | A survey of Russian immigrants in the Far East. | Russia | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21805 | 21805 | 1909-10-16 | 2 | c | China's dispute with Japan over the Jiandao island; response of overseas Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 | |
21812 | 21812 | 1909-10-16 | 2 | b | Afghanistan may see crisis on its border with India. | Britain | http://trove.nla.gov.au/newspaper/page/26802360 | 26802360 |
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]);