This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48772 | 48772 | 1930-01-04 | 8 | c | Chinese government refuses to recognise the new Japanese ambassador. The dispute between Russia and China. Chinese government decides to abolish consular jurisdiction. China suffers loss during their conflict with Russian. | China | http://trove.nla.gov.au/newspaper/page/24099484 | 24099484 | |
48773 | 48773 | 1930-01-04 | 8 | d | Japanese police arrest Korean political activists. | Japan | http://trove.nla.gov.au/newspaper/page/24099484 | 24099484 | |
48774 | 48774 | 1930-01-04 | 8 | e | Australia news/ Huang Qiming, principal of the Peizheng School in Guangzhou, arrives Sydney to raise funds. A Chinese man in Sydney accidentally shoots himself and is hospitalised. Farmers' association in Queensland request to postpone the ban on peanut import. Son of Zeng Yinan in Sydney has excellent school performance and may win Rhodes Scholarship and a photograph of the student. A family tragedy in Sydney. Employee of an insurance company in Sydney is arrested. Chinese gardener is beaten in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099484 | 24099484 | |
48775 | 48775 | 1930-01-04 | 8 | f | A notice issued by Song Faxiang, Chinese Consul-General in Australia, thanks Dr Qin Fuyuan in Melbourne for his generosity. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099484 | 24099484 |
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]);