This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54090 | 54090 | 1934-04-28 | 2 | a | Editorial on the traitors in China and the crisis followed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095994 | 24095994 | |
54091 | 54091 | 1934-04-28 | 2 | b | China news/ Economic Committee of the central government in Nanjing passes resolutions to the loans from America, and Song Ziwen reports to the Committee the loans from America. Third part of the draft constitution of the Republic of China. Sun Dianying's troops are besieged. | China | http://trove.nla.gov.au/newspaper/page/24095994 | 24095994 |
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]);