This data as json, CSV (advanced)
Suggested facets: page, column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46605 | 46605 | 1927-12-31 | 2 | b | Editorial by Tung Wah Times expresses worries about China under the pernicious influence of the Communist movement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098648 | 24098648 | |
46606 | 46606 | 1927-12-31 | 2 | c | Chu Yupu, commander under Feng Yuxiang, and his troops in Dangshan county, north Anhui province. | Other... | http://trove.nla.gov.au/newspaper/page/24098648 | 24098648 | |
46607 | 46607 | 1927-12-31 | 2 | d | The Nationalist army and the take-over of Wuhan, telegrams between Tan Yankai, Cheng Qian, Li Zongren, He Yingqin, Bai Chongxi, Zhu Peide and Yang Shuzhuang. | China | http://trove.nla.gov.au/newspaper/page/24098648 | 24098648 | |
46608 | 46608 | 1927-12-31 | 2 | e | Zhang Zongchang's army are defeated in Henan and the reasons. | China | http://trove.nla.gov.au/newspaper/page/24098648 | 24098648 | |
46609 | 46609 | 1927-12-31 | 2j | f | The war in north Shanxi province and the peace talks with Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098648 | 24098648 | |
46610 | 46610 | 1927-12-31 | 2 | f | Whereabouts of Tang Shengzhi. | China | http://trove.nla.gov.au/newspaper/page/24098648 | 24098648 |
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]);