This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20889 | 20889 | 1909-04-10 | 2 | a-c | Editorial on the history and future of the Chinese community in Australia and New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802140 | 26802140 | |
20893 | 20893 | 1909-04-10 | 3 | a-c | China news/ China and Russia reach agreement on border trade. Proposal to start ship building. Proposal for power division in the Chinese government. Prince Gong might enter the Bureau of Military Affairs (jun ji chu). Immigration in Heilongjiang province and other area of Manchuria and encouragement from the government authorities. Chinese authorities postpone the issue of government bonds. A legal school in Changzhou, Jiangsu province. Further report on the international opium conference in Shanghai. Wu Chongxi and the railway construction from Luoyang to Tongguan. | China | http://trove.nla.gov.au/newspaper/page/26802139 | 26802139 | |
20912 | 20912 | 1909-04-10 | 8 | a-c | News on railway construction in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802146 | 26802146 |
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]);