This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50854 | 50854 | 1931-11-07 | 2 | b | Open telegram jointly issued by Li Liejun, Xu Qian, Zhang Zhiben, Cheng Qian and others calls for stopping internal conflicts and fighting Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090583 | 24090583 | |
50855 | 50855 | 1931-11-07 | 2 | c | Miscellaneous report on Japanese invasion of Manchuria (Gu Weijun is acting foreign minister, talks by Zhang Xueliang, Hankou people boycott to Japanese goods, American government recalls its ambassador from Japan, university students in Shanxi are armed, run on banks in Shanghai, Liaoning provincial government moves to Jinzhou, and others). | China | http://trove.nla.gov.au/newspaper/page/24090583 | 24090583 | |
50856 | 50856 | 1931-11-07 | 2 | e | Declaration issued by the Chinese communities in Britain on Japanese invasion of Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24090583 | 24090583 |
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]);