This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49862 | 49862 | 1931-01-10 | 2 | b | Thoughts and hope of the Tung Wah Times on the occasion of New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090232 | 24090232 | |
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 |
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]);