This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51145 | 51145 | 1932-02-06 | 2 | a | First part of an essay on the war between China and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090686 | 24090686 | |
51146 | 51146 | 1932-02-06 | 2 | d | Japanese consul in Shenyang and his diplomatic strategies. Determination of Sun Ke to fight Japanese invader. Declaration issued by Wu Zhihui. Wuhan authority fights the Communist Party. A photograph of unscrupulous merchant Ouyang He in Shanghai on street parade for collaboration with Japanese businessmen. Liu Wenhui urges Wu Peifu to come to Nanjing. Shen Junru protects the youth. An association to deal with national crisis (guo nan jiu ji hui) urges constitutional reform. New Japanese cabinet publicises expenditure for invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090686 | 24090686 | |
51147 | 51147 | 1932-02-06 | 2 | f | New Japanese cabinet publicises expenditure for invasion of Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24090686 | 24090686 |
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]);