This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47754 | 47754 | 1929-01-19 | 2 | e | Members of the Chinese National Anti-Japanese Association attack foreign minister Wang Zhengting's house. | China | http://trove.nla.gov.au/newspaper/page/24099090 | 24099090 | |
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 | |
47763 | 47763 | 1929-01-19 | 5 | e | A young couple in Guangzhou commit suicide for love. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099091 | 24099091 |
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]);