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 |
---|---|---|---|---|---|---|---|---|---|
51050 | 51050 | 1932-01-09 | 6 | c | Chinese communities in Sydney publish a brochure about the Japanese invasion of Manchuria which is available from the min bao, gong bao, Tung Wah Times and min guo bao in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090657 | 24090657 | |
51051 | 51051 | 1932-01-09 | 6 | c | Guangdong news/ Quarrel and fighting at the Fourth Session Plenary in Guangzhou. Demonstration of the students of five high schools in Guangzhou. War planes return to Guangzhou for defence purpose. Fortifications are being built in the suburbs of Guangzhou. A telegram from Ma Zhanshan to civilian associations in Guangzhou. Li Bai requests to be sent to the front. | China | http://trove.nla.gov.au/newspaper/page/24090657 | 24090657 | |
51056 | 51056 | 1932-01-09 | 8 | c | Chinese delegate to the League of Nations Shi Zhaoji speaks at a conference. The League of Nations is disappointing. | Britain | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
51057 | 51057 | 1932-01-09 | 8 | c | A foreign diplomat in Beijing talks to Sydney newspaper on the Chinese situations. | Australia | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
51058 | 51058 | 1932-01-09 | 8 | c | The Nanjing government and the fall of Jinzhou, Liaoning province. Japanese teacher is murdered in Fuzhou, of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 |
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]);