This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50627 | 50627 | 1931-08-22 | 2 | d | Famine victims in Chengdu, Sichuan province, rob rice shops. Tibet troops refuse to retreat from Ganzi. Negotiation between China and Japan over the atrocities of Japanese police in Jilin province. Chinese consul in Seoul reports the anti-Chinese movement. Japanese goods enter Chinese market before the boycott started. Ministry of Finance borrows from banks in Wuhan. Businessmen in Shanghai call for breaking off diplomatic relations with Japan. Nanjing government on the atrocity of Japanese police in Jilin province. The Nationalist troops win victory over the Communist forces in Jiangxi province. Chen Youren arrives Tokyo. Wu Peifu arrives Chengdu. Mother of Song Meiling and Song Qingling dies. Japanese troops in Tianjin. Survey on bandits in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24090495 | 24090495 | |
50630 | 50630 | 1931-08-22 | 3 | d | He Jian in Changsha, Hunan province, urges the Nanjing government to pay the provisions. | China | http://trove.nla.gov.au/newspaper/page/24090494 | 24090494 | |
50634 | 50634 | 1931-08-22 | 5 | d | Five public notices issued by the Chinese Consulates in Sydney and Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090496 | 24090496 |
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]);