This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51155 | 51155 | 1932-02-06 | 5 | a | American government closely watching Japanese in Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51156 | 51156 | 1932-02-06 | 5 | a | American parliamentarians suggest to break off economic relations with Japan. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51157 | 51157 | 1932-02-06 | 5 | a | Associations in Shanghai request American government to uphold justice. | China | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51158 | 51158 | 1932-02-06 | 5 | b | Proposal to move the Chinese national capital to Luoyang in order to resistance to Japanese invasion. | Australia | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51159 | 51159 | 1932-02-06 | 5 | b | The League of Nations investigates Japanese troops in Shanghai. | Other... | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51160 | 51160 | 1932-02-06 | 5 | b | American government dispatches warships to Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51161 | 51161 | 1932-02-06 | 5 | c | Peace talks between China and Japan fails. | Britain | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51162 | 51162 | 1932-02-06 | 5 | c | Chinese government declares war to Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51163 | 51163 | 1932-02-06 | 5 | d | Australia news/ Chinese societies & associations in Sydney jointly call for donations to the war of resistance to Japanese invasion (Chinese Chamber of Commerce in New South Wales, the zhi gong tang in Sydney, the Zengcheng lian yi tang, the Gaoyao and Gaoming hong fu tang, Si Yi Society and the Young Chinese Association of Australia or li zhi hui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 |
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]);