This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56114 | 56114 | 1936-08-01 | 2 | b | Editorial on the survival of the Chinese nation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096938 | 24096938 | |
56115 | 56115 | 1936-08-01 | 2 | c | China news/ Japanese airforce troops in north China. Shi Yousan and other traitors kidnap Song Zheyuan's mother in Tianjin. The Nanjing government to expand its naval forces. Inner Mongolia declares independence. The war clouds in south Hunan province. Japanese regard Song Zheyuan the key enemy. Japanese military police in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096938 | 24096938 | |
56116 | 56116 | 1936-08-01 | 2 | f | The Wing On Company in Shanghai converts its capital to Chinese currency. | China | http://trove.nla.gov.au/newspaper/page/24096938 | 24096938 |
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]);