This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55700 | 55700 | 1936-01-11 | 2 | a | Tung Wah Times urges readers to pay the subscription fee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096704 | 24096704 | |
55701 | 55701 | 1936-01-11 | 2 | a | Advertisement of The Wing On Bank Ltd, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096704 | 24096704 | |
55702 | 55702 | 1936-01-11 | 2 | a | Jiang Jieshi talks about the foreign policy at the Fifth Plenary Session. | China | http://trove.nla.gov.au/newspaper/page/24096704 | 24096704 | |
55703 | 55703 | 1936-01-11 | 2 | c | China joins to sanction against Italy. | China | http://trove.nla.gov.au/newspaper/page/24096704 | 24096704 | |
55704 | 55704 | 1936-01-11 | 2 | c | Draft of the Chinese constitution and the preparation for the national people's congress. | China | http://trove.nla.gov.au/newspaper/page/24096704 | 24096704 | |
55705 | 55705 | 1936-01-11 | 2 | d | Circulation of the Da Gong Bao in Tianjin is resumed. | China | http://trove.nla.gov.au/newspaper/page/24096704 | 24096704 | |
55706 | 55706 | 1936-01-11 | 2 | e | Wang Jingwei is sick. | China | http://trove.nla.gov.au/newspaper/page/24096704 | 24096704 | |
55707 | 55707 | 1936-01-11 | 2 | e | New foreign minister of the Chinese government Zhang Qun flies to Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096704 | 24096704 |
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]);