This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54697 | 54697 | 1934-12-01 | 2 | a | How to eradicate the communist disasters in China, comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 | |
54698 | 54698 | 1934-12-01 | 2 | b | China news/ Jiang Jieshi moves more troops to suppress the communists. Li Jichun and Shi Yousan plot a comeback. Japanese seeks to utilise the Communist troops in south China. The Communists give up their base in Jiangxi and Fujian province. Shandong and Shanxi troops on the way south. Zhang Junmai on Japanese attitude towards Huang Fu. | China | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 | |
54699 | 54699 | 1934-12-01 | 2 | d | America purchases more silver from overseas. | America | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 | |
54700 | 54700 | 1934-12-01 | 2 | e | Zhang Qun to train more young reserves. The communist troops in Jiangxi province to harass east Guizhou province. Gold mine found in Gansu province. Jiang Jieshi encourages to develop the northwest region. China relax its boycott to Japanese goods. | China | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 |
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]);