This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51373 | 51373 | 1932-04-09 | 2 | a | Chinese societies & associations in Sydney jointly call for donations to the war of resistance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 | |
51374 | 51374 | 1932-04-09 | 2 | b | Editorial by Tung Wah Times on the efforts in China to eliminate the communists during the national crisis. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 | |
51375 | 51375 | 1932-04-09 | 2 | c | Chinese troops give up the Wusong in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 | |
51376 | 51376 | 1932-04-09 | 2 | d | Chinese foreign ministry issues a declaration on the peace talks with Japan. | China | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 | |
51377 | 51377 | 1932-04-09 | 2 | e | Methods to prevent gas bombs. | Germany | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 | |
51378 | 51378 | 1932-04-09 | 2 | f | Bombs found in Sun Ke's residence in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 | |
51379 | 51379 | 1932-04-09 | 2 | f | Wang Geng, Chinese army commander, is freed. | China | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 |
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]);