This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51196 | 51196 | 1932-02-20 | 2 | a | The Chinese communities in Sydney organise the Fund-raising Committee for the Resistance to Japanese Invasion (dui ri zhan fei chou bei hui) which calls for donations. The association is jointly organised by the Chinese Chamber of Commerce in New South Wales, Zengcheng lian yi tang, si yi Society, zhi gong tang, Gaoyao and Gaoming hong fu tang, and li zhi hui. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090704 | 24090704 | |
51198 | 51198 | 1932-02-20 | 3 | a | American newspaper surveys the Japanese troops in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090703 | 24090703 | |
51199 | 51199 | 1932-02-20 | 3 | a | Korean revolutionaries in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090703 | 24090703 | |
51200 | 51200 | 1932-02-20 | 3 | a | Circular telegram issued by prominent people of the National Crisis Salvation Association. | China | http://trove.nla.gov.au/newspaper/page/24090703 | 24090703 | |
51203 | 51203 | 1932-02-20 | 5 | a | British government prepares to deal with Japanese in Asia. | Britain | http://trove.nla.gov.au/newspaper/page/24090705 | 24090705 | |
51204 | 51204 | 1932-02-20 | 5 | a | The League of Nations warns Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090705 | 24090705 | |
51205 | 51205 | 1932-02-20 | 5 | a | British nationals injured during the Japanese invasion of Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090705 | 24090705 | |
51210 | 51210 | 1932-02-20 | 7 | a | A joint declaration issued by the army officers and soldiers in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090707 | 24090707 | |
51213 | 51213 | 1932-02-20 | 8 | a | Chinese ambassador to Germany Liu Wendao reveals secrecy of the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24090710 | 24090710 | |
51214 | 51214 | 1932-02-20 | 8 | a | Former Japanese financial minister is assassinated. | Japan | http://trove.nla.gov.au/newspaper/page/24090710 | 24090710 | |
51215 | 51215 | 1932-02-20 | 8 | a | Japanese troops bombs Shanghai, the international settlement and the resistance of Chinese army. | China | http://trove.nla.gov.au/newspaper/page/24090710 | 24090710 |
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]);