This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15762 | 15762 | 1906-06-09 | 3 | a | Japanese government sends three envoys, including Ito Hirobumi, to Manchuria in order to control the railways there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800998 | 26800998 | |
15763 | 15763 | 1906-06-09 | 3 | a | French government is to expand its navy force. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800998 | 26800998 | |
15764 | 15764 | 1906-06-09 | 3 | a | Tens of thousands of people in San Francisco are homeless after the earthquake. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800998 | 26800998 | |
15765 | 15765 | 1906-06-09 | 3 | a | Tsar of Russia meets parliamentarian and the parliamentary speaker. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800998 | 26800998 | |
15766 | 15766 | 1906-06-09 | 3 | a | Russia seeks to retain its control of navigation in Songhuajiang River. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800998 | 26800998 | |
15767 | 15767 | 1906-06-09 | 3 | a-b | King of Spain and prince of Britain engaged, but the ceremony bombed and claimed several lives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800998 | 26800998 | |
15768 | 15768 | 1906-06-09 | 3 | b | Chinese government notifies Britain three times that they would not take back customs administration for the time being. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800998 | 26800998 | |
15769 | 15769 | 1906-06-09 | 3 | b | Chinese businessmen in Sydney gather and call for donations to the Chinese victims of San Francisco earthquake. The meeting attended by Li Chun, Liu Ruxing, Wu Shihua, Zheng Fanchang, Luo Daren, Guo Biao, Chen Zanhua, Wu Yangshou, Liu Xianglan, He Yao, Mai Mei, Guan Zhuobo, and many others. All donations shall be sent to Mr Guo Biao, Wing Sang & Co, 22 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800998 | 26800998 |
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]);