This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56006 | 56006 | 1936-05-02 | 2 | b | Editorial by Tung Wah Times on the unforgetable Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096832 | 24096832 | |
56007 | 56007 | 1936-05-02 | 2 | d | China news/ The meeting of Japanese counsels in Shanghai decide to maintain the current situations in north China. Overseas Chinese Commission in Nanjing notifies overseas Chinese communities on the election of delegates to the National Congress that to be held soon. Japan dispatches more troops to north China. Only Japan protests over the return of international settlements in Shanghai to China. Feng Yuxiang praises hygiene arrangement in the front battlefields. | China | http://trove.nla.gov.au/newspaper/page/24096832 | 24096832 | |
56008 | 56008 | 1936-05-02 | 3 | a | Japanese start cultural and economic invasion of China. | China | http://trove.nla.gov.au/newspaper/page/24096831 | 24096831 | |
56009 | 56009 | 1936-05-02 | 3 | b | Bank of China sets up branch in America. | America | http://trove.nla.gov.au/newspaper/page/24096831 | 24096831 | |
56010 | 56010 | 1936-05-02 | 3 | c | Singaporean authority imposes strict restrictions upon entry of foreigners. | Singapore | http://trove.nla.gov.au/newspaper/page/24096831 | 24096831 | |
56011 | 56011 | 1936-05-02 | 3 | c | http://trove.nla.gov.au/newspaper/page/24096831 | 24096831 |
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]);