This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48252 | 48252 | 1929-07-06 | 2 | b | Declaration for the set-up of the Honolulu Branch of the Confucian Society. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099272 | 24099272 | |
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 | |
48254 | 48254 | 1929-07-06 | 2 | e | Mongolian people are plotting a rebellion and the high alert in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099272 | 24099272 | |
48255 | 48255 | 1929-07-06 | 2 | f | Harassment to the newspaper offices in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099272 | 24099272 | |
48256 | 48256 | 1929-07-06 | 2 | f | American charity organisations donate to the famine areas in north China, report by Wu Chaoshu. | America | http://trove.nla.gov.au/newspaper/page/24099272 | 24099272 | |
48257 | 48257 | 1929-07-06 | 2 | f | Recent railway transportation in China. | China | http://trove.nla.gov.au/newspaper/page/24099272 | 24099272 | |
48258 | 48258 | 1929-07-06 | 2 | f | Muslims support the suppression of Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24099272 | 24099272 |
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]);