This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48253 | 48253 | 1929-07-06 | 2 | c | People in the Northwest China suffer from the war. Sun Chuanfang refuses to guard Beijing and Tianjin. Feng Yuxiang's plan for cooperation with the Soviet Russian. Feng Yuxiang escapes from an assassination in Henan province. Feng Yuxiang gathers his troops in Tongguan, Henan province. Feng Yuxiang's tricks. The assets owned by Feng Yuxiang. Feng Yuxiang issues a circular telegram to step down. | China | http://trove.nla.gov.au/newspaper/page/24099272 | 24099272 | |
48265 | 48265 | 1929-07-06 | 5 | c | Second part of the report on the opium dens and brothels along the Yalu River in Heilongjiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099273 | 24099273 |
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]);