This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47756 | 47756 | 1929-01-19 | 3 | b | Song Ziwen admits that he once tries to borrow loans from Japan. | China | http://trove.nla.gov.au/newspaper/page/24099089 | 24099089 | |
47757 | 47757 | 1929-01-19 | 3 | c | Journalism in Yunnan has trouble. | China | http://trove.nla.gov.au/newspaper/page/24099089 | 24099089 | |
47758 | 47758 | 1929-01-19 | 3 | d | Leftists have a meeting in Shanghai. Dai Jitao supports Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24099089 | 24099089 | |
47759 | 47759 | 1929-01-19 | 3 | d | Japanese seek to monopolise navigation across the Pacific. | China | http://trove.nla.gov.au/newspaper/page/24099089 | 24099089 | |
47760 | 47760 | 1929-01-19 | 3 | e | Jiang Jieshi's son Jiang Jingguo is arrested in Soviet Russia. Duan Qirui's comments on the current affairs. Cao Kun's house in Tianjin is burgled. Preparation for the national Party Congress in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099089 | 24099089 |
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]);