This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54128 | 54128 | 1934-05-12 | 2 | a | First part of comments on the constitution and the constitutional politics in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096010 | 24096010 | |
54129 | 54129 | 1934-05-12 | 2 | b | China news/ The southwest of China will be under the command of the Central government in Nanjing. The fifth part of the draft constitution of the Republic of China. Jiang Jieshi on the selection and appointment of local administrators. Wang Jingwei and Jiang Jieshi write to Chen Jitang on the reform of provincial system. | China | http://trove.nla.gov.au/newspaper/page/24096010 | 24096010 |
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]);