This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32150 | 32150 | 1917-03-17 | 3 | c | Yang Shanguo takes office as military governor of Zhejiang province and the ceremony. | China | http://trove.nla.gov.au/newspaper/page/24095624 | 24095624 | |
32151 | 32151 | 1917-03-17 | 3 | c | Chinese Ministry of Agriculture and Commerce promotes local products and its notice to provincial governments. | China | http://trove.nla.gov.au/newspaper/page/24095624 | 24095624 | |
32156 | 32156 | 1917-03-17 | 6 | c | Guangdong news/ Zhu Qinglan on the celebration of unification of the south and the north in China. Shops in Guangzhou will be closed for the celebration parade for the unification of the south and the north. Wuhua county magistrate Lin Daren is appreciated for his justice. Zhang Mingqi in Guangdong. Further report on the welcome of Xu Mian. | China | http://trove.nla.gov.au/newspaper/page/24095629 | 24095629 | |
32159 | 32159 | 1917-03-17 | 7 | c | Casualties of the World War I. | Canada | http://trove.nla.gov.au/newspaper/page/24095628 | 24095628 | |
32160 | 32160 | 1917-03-17 | 7 | c | China's negotiation with Japan over the case of Zhengjiatun. Chinese Chamber of Commerce in Nanyang reports to the Beijing government on its relations with Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24095628 | 24095628 | |
32161 | 32161 | 1917-03-17 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095628 | 24095628 |
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]);