This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49863 | 49863 | 1931-01-10 | 2 | e | The zhong hua gong suo (Chinese Society) mediates the conflicts of Chinese societies in the east of America. | America | http://trove.nla.gov.au/newspaper/page/24090232 | 24090232 | |
49864 | 49864 | 1931-01-10 | 2 | e | Chinese government has new proposal to abolish likin. | China | http://trove.nla.gov.au/newspaper/page/24090232 | 24090232 | |
49865 | 49865 | 1931-01-10 | 2 | e | Yuan Deqing defects from Shi Yousan. Chen Diaoyuan celebrates birthday for his mother. Situation in north China man change between Spring and Summer. Zhang Fakui leads his troops into Yunnan. Wang Jingwei leaves Tianjin for Dalian. Soviet Russia agrees to another talk with China. The real power of Yan Xishan and Feng Yuxiang. Feng Zhenwu is free now. Communist disasters in Jiangxi province. Yan Xishan to leave China. | China | http://trove.nla.gov.au/newspaper/page/24090232 | 24090232 | |
49871 | 49871 | 1931-01-10 | 3 | e | Banks in Shanghai and the debt repayment of Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24090231 | 24090231 | |
49872 | 49872 | 1931-01-10 | 3 | e | Chinese ministry of justice prepares for a general pardon. | China | http://trove.nla.gov.au/newspaper/page/24090231 | 24090231 | |
49873 | 49873 | 1931-01-10 | 3 | e | Japanese new police in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24090231 | 24090231 | |
49878 | 49878 | 1931-01-10 | 5 | e | Names listed for donations of the Sydney Chinese community to the Gaoyao hospital in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090233 | 24090233 | |
49888 | 49888 | 1931-01-10 | 8 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090238 | 24090238 |
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]);