This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51032 | 51032 | 1932-01-09 | 2 | a | Editorial by Tung Wah Times on the occasion of New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090653 | 24090653 | |
51033 | 51033 | 1932-01-09 | 2 | b | Ma Zhanshan fights Japanese invaders to death. Feng Yong and Wang Jialie request to fight Japanese. Financial panic in Jinan, Shandong province. Shang Zhen entertains journalists. Du Xuantai is escorted to Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24090653 | 24090653 | |
51034 | 51034 | 1932-01-09 | 2 | d | Chinese foreign minister Gu Weijun explains the Jinzhou Incident in Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24090653 | 24090653 | |
51035 | 51035 | 1932-01-09 | 2 | e | Military reform plan passed by Japanese cabinet. | Japan | http://trove.nla.gov.au/newspaper/page/24090653 | 24090653 | |
51036 | 51036 | 1932-01-09 | 2 | e | Miscellaneous report on the Japanese invasion of Manchuria and north China. | China | http://trove.nla.gov.au/newspaper/page/24090653 | 24090653 |
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]);