This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54148 | 54148 | 1934-05-19 | 2 | Second part of comments on the constitution and the constitutional politics in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096018 | 24096018 | ||
54149 | 54149 | 1934-05-19 | 2 | c | China news/ Remains of Sun Dianying's troops. Council of Legislature has a secret discussion on the north China issues. The sixth part of the draft constitution of the Republic of China. Chaos in Guizhou province end. Jiang Jieshi orders provinces to unify their financial management. | China | http://trove.nla.gov.au/newspaper/page/24096018 | 24096018 |
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]);