This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50484 | 50484 | 1931-07-11 | 2 | b | Comments on the military situations in Nanjing and Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090445 | 24090445 | |
50485 | 50485 | 1931-07-11 | 2 | c | Huang Boheng, a leftist Nationalist Party member, is arrested in Shanghai on his return from Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24090445 | 24090445 | |
50486 | 50486 | 1931-07-11 | 2 | c | Many Chinese businessmen are leaving Mexico and returning to China in order to avoid exorbitant taxes. | America | http://trove.nla.gov.au/newspaper/page/24090445 | 24090445 | |
50487 | 50487 | 1931-07-11 | 2 | c | Alliance of Liaoning and Shanxi to fight Feng Yuxiang. Jiang Jieshi wants to reinstate Wu Peifu. Wen Zongyao calls for peace in China. Jiang Jieshi prepares to attack Guangdong. Alliance in north China against Jiang Jieshi. Zhang Xueliang is still recovering from illness. Steps to solve the Tibet problems by the Nanjing government. Nanjing is preparing for war. Wang Chonghui in Dalian. Japanese troops in Tianjin. Reshuffle of the Railway Ministry in Nanjing. Xikang People in Nanjing request to stop Dalai Lama. Revenue of the railways in China. Russia purchase chemical products from Japan. Hundreds of army horses arrive Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090445 | 24090445 |
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]);