This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50787 | 50787 | 1931-10-10 | 8 | a | The League of Nations mediates the conflict between China and Japan, and the resolutions. | China | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 | |
50788 | 50788 | 1931-10-10 | 8 | a | British foreign secretary reports to the House of Commons the military conflict between China and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 | |
50789 | 50789 | 1931-10-10 | 8 | a | Clash between workers and police in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 | |
50790 | 50790 | 1931-10-10 | 8 | a | British newspaper comments on the Japanese immigration in Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 | |
50791 | 50791 | 1931-10-10 | 8 | b | Zhang Xueliang on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 | |
50792 | 50792 | 1931-10-10 | 8 | b | Japanese government dispatches more warships to China. | Japan | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 | |
50793 | 50793 | 1931-10-10 | 8 | b | Atrocities of Japanese in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 | |
50794 | 50794 | 1931-10-10 | 8 | b | Indian authority detains opium smugglers. | Other... | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 | |
50795 | 50795 | 1931-10-10 | 8 | c | Australia news/ False report on the execution of Chinese nationals in French colony. Chinese community in Queensland complains about the acting consul appointed by the Chinese Consul-General in Australia. Sydney astronomical observatory predicts earthquake. Chinese Chamber of Commerce in Sydney calls for boycott to Japanese goods. Declaration issued by the Sydney Chinese Association to Fight Japan and to Save China. Fellow returned from Zhongshan county, Guangdong, talks about the situations there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 | |
50796 | 50796 | 1931-10-10 | 8 | e | Meeting notice issued by the Chinese Chamber of Commerce in New South Wales and its declaration on Japanese invasion of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090557 | 24090557 |
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]);