This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43153 | 43153 | 1925-05-09 | 7 | a | A policeman in Port Darwin is sacked for accepting bribery from Chinese merchant. | Australia | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43154 | 43154 | 1925-05-09 | 7 | a | Chinese carpenters are arrested in Melbourne for opium smuggling. | Australia | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43155 | 43155 | 1925-05-09 | 7 | a | Three Chinese are arrested from 430 Sussex Street, Sydney, for opium smoking. | Australia | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43156 | 43156 | 1925-05-09 | 7 | a | Leaflets found in Sydney with a purpose to defame leader of the Labour Party. | Australia | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43157 | 43157 | 1925-05-09 | 7 | a-b | Two illegal Chinese immigrants are captured in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43158 | 43158 | 1925-05-09 | 7 | b | Fundraising for the Sydney hospitals and involvement of the Chinese communities (zhi gong tang, the Nationalist Party, Chinese Chamber of Commerce, Ye Si Lu Fu, Zeng Yuchun, Chen Yin, Zhan Xiurong, Sun Jinlian, Luo Yanxia, Wu Lihua, Cai Yanmei, Chen Miaolian, and others). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43159 | 43159 | 1925-05-09 | 7 | b | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43160 | 43160 | 1925-05-09 | 7 | b-c | Guangdong authority removes the post of supreme commander which was once held by Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43161 | 43161 | 1925-05-09 | 7 | c-d | A notice by the Australian Oriental Navigation Ltd for the service of its two new liners, Changte and Taiping. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43162 | 43162 | 1925-05-09 | 7 | d | Property for sale by Austral Wine Company, 623 Harris Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 |
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]);