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 |
---|---|---|---|---|---|---|---|---|---|
31905 | 31905 | 1917-01-20 | 3 | a | Auditing Committee in Beijing finds embezzlement. | China | http://trove.nla.gov.au/newspaper/page/24095554 | 24095554 | |
31906 | 31906 | 1917-01-20 | 3 | a | Suggestion to abolish names of the South Army and the North Army. | China | http://trove.nla.gov.au/newspaper/page/24095554 | 24095554 | |
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 | |
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]);