This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50153 | 50153 | 1931-04-04 | 2 | c | Loss of Jilin and Heilongjiang province during the war between China and Russia. Zhang Xueliang to set up a deputy headquarters in Beijing. Nationalist Party branch in Tianjin requests to abolish dissident organisation. Jiang Jieshi speaks to Sun Lianhzong's troops. Communists arrested in Beijing and Tianjin. Mutiny of Shanxi armies. | China | http://trove.nla.gov.au/newspaper/page/24090333 | 24090333 | |
50158 | 50158 | 1931-04-04 | 3 | c | Business in Beijing is prosperious now. | China | http://trove.nla.gov.au/newspaper/page/24090332 | 24090332 | |
50163 | 50163 | 1931-04-04 | 5 | c | Masks in the traditional Chinese operas. A plea for divorce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090334 | 24090334 |
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]);