This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49889 | 49889 | 1931-01-17 | 2 | b | First part of comments by Tung Wah Times on the independence movement in India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49890 | 49890 | 1931-01-17 | 2 | c | Cultural enterprises of the Chinese communities in America. | America | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49891 | 49891 | 1931-01-17 | 2 | c | Japanese cabinet has finalised its new policy in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49892 | 49892 | 1931-01-17 | 2 | c | Cuba to set up sugar factory in China. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49893 | 49893 | 1931-01-17 | 2 | c | Xiong Shihui and Yang Yongtai are seriously injured in a plane accident. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49894 | 49894 | 1931-01-17 | 2 | d | The Communist Party in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 | |
49895 | 49895 | 1931-01-17 | 2 | d | Jiang Jieshi retains Deng Ying and He Jian. Chinese Communist Party has a Soviet conference in Ningbo, of Zhejiang province. Organisational regulations of the National Conference. Why Zhu Peide resigns. Jiang Jieshi to arrive Wuhan. Jiang Jieshi to take over Manchuria. Zhang Xueliang leaves Tianjin for Shenyang. Salt sale in Jilin and Heilongjiang province. Arsenal explodes in Shanghai. Yan Xishan stays in Puyi's house in Tianjin. Reorganisation of Zhang Xueliang and Yan Xishan's troops. Shi Yousan support Zhang Xueliang. | China | http://trove.nla.gov.au/newspaper/page/24090240 | 24090240 |
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]);