This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17616 | 17616 | 1907-06-15 | 6 | a-b | A letter from Liang Zhendong, Chinese ambassador to Washington, to the Beijing ministry of foreign affairs regarding Chinese labourers in Panama Canal. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801368 | 26801368 | |
17617 | 17617 | 1907-06-15 | 6 | b | Important news. Report on the motoring racing from Beijing to Paris. Negotiation and relation between America and Japan. Japan's negotiation and trade agreement with Russia and France. | Britain | http://trove.nla.gov.au/newspaper/page/26801368 | 26801368 | |
17618 | 17618 | 1907-06-15 | 6 | b | Overseas female students. Report on graduation ceremony of Chinese women students in Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801368 | 26801368 | |
17619 | 17619 | 1907-06-15 | 6 | b-c | Tung Wah column. Gold casting to be banned and comments by Tung Wah Times. The end of imperial relatives. Qualifications. Questions for imperial examination. Chinese cabinet (jun ji). Western style army uniform. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801368 | 26801368 | |
17620 | 17620 | 1907-06-15 | 6 | c | Special report. Shanxi students in Japan write to Yuan Shikai regarding the foreign exploitation of mining resources in Shanxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801368 | 26801368 | |
17621 | 17621 | 1907-06-15 | 6 | c | Names listed for donations to flooding victims of Jiangsu province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801368 | 26801368 |
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]);