This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23774 | 23774 | 1910-11-12 | 2 | a-b | First part of editorial on the navy and its relation with national defence. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802834 | 26802834 | |
23775 | 23775 | 1910-11-12 | 2 | b | Imperial edict on August 24 on banning opium. | China | http://trove.nla.gov.au/newspaper/page/26802834 | 26802834 | |
23776 | 23776 | 1910-11-12 | 2 | b | A public notice issued by Tang Entong, new Chinese consul general in Australia, and his letter to the Sydney Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802834 | 26802834 | |
23777 | 23777 | 1910-11-12 | 2 | b-c | An open letter from Chinese consul-general in Wellington Huang Rongliang on his negotiations with New Zealand authorities over the working hours of Chinese laundries. Also one of his letters to the New Zealand prime minister. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802834 | 26802834 | |
23778 | 23778 | 1910-11-12 | 2 | c-d | Beijing news/ Russia has already started to take over Mongolia. Zai Tao on the new treaty between Russia and Japan. Chinese government to retain its consulate general in Korea. Yunnan governor is urged to report to Beijing. Imperial scholars report on opium smoking in the Beijing officialdom. Board of Revenue prepares for the issue of new coins. A foreign government demands Liaoyang, of Fengtian province, from China. | China | http://trove.nla.gov.au/newspaper/page/26802834 | 26802834 |
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]);