This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50682 | 50682 | 1931-09-05 | 8 | b | The Nationalist government purchases rice in Shanghai for disasters relief. | China | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50683 | 50683 | 1931-09-05 | 8 | b | Concubine of Puyi, the dethroned emperor of Qing dynasty, applies for divorce. | China | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50684 | 50684 | 1931-09-05 | 8 | b | Rebellions in Burma are sentenced to death. | Other... | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50685 | 50685 | 1931-09-05 | 8 | b | Earthquake in India. | Other... | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50686 | 50686 | 1931-09-05 | 8 | b | The Communists and Gandhi in India. | Other... | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50687 | 50687 | 1931-09-05 | 8 | b | Jiang Jieshi helps the relief work in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50688 | 50688 | 1931-09-05 | 8 | c | The flooding Yangtze River area. | China | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50689 | 50689 | 1931-09-05 | 8 | c | Australia news/ Advertisement article for insect killer Cooper's Arsinate of Lead Powder. The Savings Bank of New South Wales to be reopened. Amalgamation of the Bank of New South Wales and the ABC Bank in Sydney. Opium smugglers are penalised in Sydney. Chinese vegetable peddlers in Sydney and the city administrator. Police in Sydney arrest thieves. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50690 | 50690 | 1931-09-05 | 8 | e | The Chinese School in Sydney calls for donations (board members: Ouyang Nan, Guo Chao, Ma Lianghua, Li Jixiang, Liu Guangfu, Ling Mingshu, Xiao Daoming, Guan Chongji, Lin Jiqing, Chen Sida, Qin Fuyuan, Liu Ziqian and others). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 | |
50691 | 50691 | 1931-09-05 | 8 | c | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090517 | 24090517 |
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]);