This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51839 | 51839 | 1932-08-27 | 2 | a | First part of editorial by the Tung Wah Times on the open letter from Chen Mingshu to the 19th Route Army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090922 | 24090922 | |
51840 | 51840 | 1932-08-27 | 2 | d | Japanese troops are approaching Chaoyang, Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24090922 | 24090922 | |
51841 | 51841 | 1932-08-27 | 2 | e | Eight small European countries request to ban air force bombing. | Other... | http://trove.nla.gov.au/newspaper/page/24090922 | 24090922 | |
51842 | 51842 | 1932-08-27 | 2 | e | Chinese volunteer armies in Manchuria fight Japanese invaders and the report. | China | http://trove.nla.gov.au/newspaper/page/24090922 | 24090922 | |
51843 | 51843 | 1932-08-27 | 2 | f | Russian troops approach Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090922 | 24090922 | |
51844 | 51844 | 1932-08-27 | 2 | f | Japanese government issues more bonds from today. | Japan | http://trove.nla.gov.au/newspaper/page/24090922 | 24090922 | |
51845 | 51845 | 1932-08-27 | 2 | f | Overseas Chinese communities donate to the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24090922 | 24090922 | |
51846 | 51846 | 1932-08-27 | 2 | f | Chinese government to seal off the customs of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090922 | 24090922 |
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]);