This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49988 | 49988 | 1931-02-14 | 2 | b | First part of editorial by Tung Wah Times on the silver price and the foreign debts. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090272 | 24090272 | |
49989 | 49989 | 1931-02-14 | 2 | d | American-born Chinese Liu Chengji of New York wins more medals than any other American soldiers for his bravery during the World War I. | America | http://trove.nla.gov.au/newspaper/page/24090272 | 24090272 | |
49990 | 49990 | 1931-02-14 | 2 | d | American government implements stricter restrictions on foreign immigration. | America | http://trove.nla.gov.au/newspaper/page/24090272 | 24090272 | |
49991 | 49991 | 1931-02-14 | 2 | d | Shang Zhen demands more provisions from Song Ziwen. Shocking price of gold in Shanghai. Zhang Zuoxiang replaces Zhang Xueliang to command the troops in Manchuria. Hebei province after the abolition of likin. Russian dispatches more troops to the border of Jilin province. New regulations for business taxes. Central government reorganises troops formerly under Yan Xishan and Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24090272 | 24090272 |
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]);