This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51081 | 51081 | 1932-01-16 | 8 | a | Zhang Xueliang may fight the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 | |
51082 | 51082 | 1932-01-16 | 8 | a | American president on the international treaties and Japanese invasion of Manchuria. American government on the Japanese invasion of China. | America | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 | |
51083 | 51083 | 1932-01-16 | 8 | b | British government on the Japanese invasion of China. | Britain | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 | |
51084 | 51084 | 1932-01-16 | 8 | c | Germany is unable to repay the debts of war. | Germany | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 | |
51085 | 51085 | 1932-01-16 | 8 | c | Fighting Japanese invaders in Jinzhou, Liaoning province. Chinese people in Beijing on American's attitudes towards Japanese invasion. Zhang Xueliang during the Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 | |
51086 | 51086 | 1932-01-16 | 8 | d | Japanese in Qingdao, Shandong province, close Chinese newspapers. | China | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 | |
51087 | 51087 | 1932-01-16 | 8 | d | Australia news/ Deadline for application for family endowment payment. Chinese Consul-General in Australia Chen Weipin on illegal Chinese immigration. Zhu Songqing, chairman of the Chinese Chamber of Commerce in Sydney, criticises NSW state senator. Chinese communities in Australia request the Nanjing government to fight Japanese invaders. The Tung Wah Hospital in Hong Kong acknowledges receipt of donations of Australian Chinese communities to the floods victims in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 |
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]);