This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
55708 | 55708 | 1936-01-11 | 3 | a | The Nanjing government issues a declaration on the situation in north China. | China | http://trove.nla.gov.au/newspaper/page/24096703 | 24096703 | |
55721 | 55721 | 1936-01-11 | 6 | a-f | Guangdong news/ The southwest authority issues a second declaration on the current situation. Jiahua Bank to have a shareholders meeting. Bank of Guangdong to reopen some branches. Students of Zhongshan University and their demonstration against Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096708 | 24096708 | |
55723 | 55723 | 1936-01-11 | 7 | a | Students demonstration in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096707 | 24096707 | |
55724 | 55724 | 1936-01-11 | 7 | a | Tang Youren is shot in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096707 | 24096707 |
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]);