This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32289 | 32289 | 1917-05-12 | 2 | a | Two notices respectively issued by Wing On companies in Hong Kong and Shanghai on share profits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095689 | 24095689 | |
32294 | 32294 | 1917-05-12 | 3 | a | Chinese President Li Yuanhong to convene a national military conference. | China | http://trove.nla.gov.au/newspaper/page/24095688 | 24095688 | |
32302 | 32302 | 1917-05-12 | 7 | a | A notice issued by Zeng Zongjian, Chinese Consul-General in Australia, on the Chinese government bonds. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095692 | 24095692 | |
32306 | 32306 | 1917-05-12 | 8 | a | Advertisement for the Wing On Company Ltd, Shanghai, for its effort to raise more shares in the Australian Chinese communities. And the detailed map of Wing On Company Ltd in Shanghai. Agents include Guo Biao, Guo Shun, Ma Zuxing, Ouyang Jiantang, Chen Jingchen, Li Lihou, Liang Yaoting and Li Jiongtang respectively in Sydney, Shanghai, Thailand, Guangzhou, Tianjin, Hankou and Singapore. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095694 | 24095694 |
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]);