This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50760 | 50760 | 1931-10-03 | 8 | a | The League of Nations mediate the conflict between China and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50761 | 50761 | 1931-10-03 | 8 | a | Japan dispatches naval fleet to Shanghai. | Japan | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50762 | 50762 | 1931-10-03 | 8 | a | Chinese nationals in Hong Kong have demonstration against Japan and the violence. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50763 | 50763 | 1931-10-03 | 8 | a | Japanese ambassador in Washington denies any invasion of Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50764 | 50764 | 1931-10-03 | 8 | a | Japan says Chinese side deliberately provoke the conflict in Manchuria. Japanese war planes bomb trains in Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50765 | 50765 | 1931-10-03 | 8 | b | America exports wheat to China. | America | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50766 | 50766 | 1931-10-03 | 8 | b | Bandits hijack trains between Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50767 | 50767 | 1931-10-03 | 8 | b | Demonstrations in Nanjing and other cities request Chinese government to declare war on Japan. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50768 | 50768 | 1931-10-03 | 8 | c | Rumours on the independence of Manchuria and Mongolia. | Japan | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50769 | 50769 | 1931-10-03 | 8 | c | Chinese Communist Party requests to atone for their crimes by doing good deeds. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50770 | 50770 | 1931-10-03 | 8 | c | The League of Nations to discuss the Manchuria issues. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50771 | 50771 | 1931-10-03 | 8 | c | Police in Hong Kong shoot Chinese nationals. | China | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50772 | 50772 | 1931-10-03 | 8 | c | Chinese communities in Sydney organise an association to fight Japanese and to save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
50773 | 50773 | 1931-10-03 | 8 | e | Chinese passengers write in praise of services on board of liner Danda. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 |
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]);