This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51171 | 51171 | 1932-02-06 | 8 | a | Japanese troops invade Shanghai and their fierce battles with the 19th Route Army in the north suburbs. Chinese government to declare war with Japan. Atrocities of Japanese army in Shanghai. Japanese warship fire Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090694 | 24090694 | |
51172 | 51172 | 1932-02-06 | 8 | e | American naval forces have an exercise in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24090694 | 24090694 | |
51173 | 51173 | 1932-02-06 | 8 | e | Jiang Jieshi, Feng Yuxiang and Yan Xishan to jointly fight Japanese invader. | China | http://trove.nla.gov.au/newspaper/page/24090694 | 24090694 | |
51174 | 51174 | 1932-02-06 | 8 | e | Chinese delegate Yan Huiqing requests the League of Nations to apply the international treaties to Japanese invasion of Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24090694 | 24090694 |
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]);