This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50457 | 50457 | 1931-07-04 | 2 | b | A reply from Jiang Jieshi to Sun Ke. A reply from Sun Ke to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24090437 | 24090437 | |
50458 | 50458 | 1931-07-04 | 2 | b | A meeting of the Nanjing authority on the Guangdong situation and Sun Ke is wanted. Jiang Jieshi seeks reconciliation in north China. Businessmen in Beijing on demonstration. Xikang people in Nanjing request to stop invasion of Dalai Lama's Tibet troops. New alliance in north China against Jiang Jieshi. Zhang Xueliang's attitude towards the political conflicts. Feng Yuxiang's army have a meeting in Taiyuan. Jiang Jieshi purchases weapons. Zhang Xueliang is said ill. | China | http://trove.nla.gov.au/newspaper/page/24090437 | 24090437 |
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]);