This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50669 | 50669 | 1931-09-05 | 2 | b | First part of editorial on the negotiation between China and Japan over the atrocity of Japanese police in Jilin province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090511 | 24090511 | |
50674 | 50674 | 1931-09-05 | 3 | c | A comparison of military expenses of different countries last year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090510 | 24090510 | |
50678 | 50678 | 1931-09-05 | 5 | c | Tigers in the Nanyang region. Nuns in Shanghai and their life. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090512 | 24090512 | |
50679 | 50679 | 1931-09-05 | 5 | e | Notices issued by the Chinese Consulates in Melbourne and Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090512 | 24090512 | |
50680 | 50680 | 1931-09-05 | 6 | a | A notice issued by the Dongguan gong yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090515 | 24090515 | |
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]);