This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31902 | 31902 | 1917-01-20 | 2 | a-b | Second and final part of an article written by Zhou Guozheng suggests that overseas Chinese should return to do business in China in order to help the people and the nation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095555 | 24095555 | |
31903 | 31903 | 1917-01-20 | 2 | b-e | Eighth part of the diary written by Wu Guanyin on his service in the Chinese army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095555 | 24095555 | |
31911 | 31911 | 1917-01-20 | 6 | a | Poems by Zhou Guozheng and Cai Yuankai on the death of Cai E. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095559 | 24095559 | |
31914 | 31914 | 1917-01-20 | 7 | a | Australia news/ Police in Sydney raid gambling dens on Sussex Street. Thousands of frogs found in Gippsland, Victoria. A 11 year-old girl is raped in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095558 | 24095558 | |
31916 | 31916 | 1917-01-20 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095558 | 24095558 | |
31917 | 31917 | 1917-01-20 | 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/24095560 | 24095560 |
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]);