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 |
---|---|---|---|---|---|---|---|---|---|
51319 | 51319 | 1932-03-26 | 2 | b | Open letter by the Volunteers Unit of Guangdong on their departure to assist the resistance to Japanese invasion in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090744 | 24090744 | |
51332 | 51332 | 1932-03-26 | 5 | b | Angry talks by Hu Hanmin. | China | http://trove.nla.gov.au/newspaper/page/24090745 | 24090745 | |
51336 | 51336 | 1932-03-26 | 6 | b | Guangdong news/ Generous donations of the Guangdong people to the resistance war in Shanghai. Students of the Zhongshan University organise volunteer army to support the resistance to Japanese invasion. Donations of the overseas Chinese communities to the war of resistance to Japanese invasion. Director appointed for the appeasement in the south-west China. Defence arrangements in Shantou. | China | http://trove.nla.gov.au/newspaper/page/24090748 | 24090748 | |
51343 | 51343 | 1932-03-26 | 8 | b | Loss in Shanghai due to the Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090750 | 24090750 | |
51344 | 51344 | 1932-03-26 | 8 | b | Australia news/ Opening ceremony of the Harbour Bridge in Sydney and the arrest of New Guard members. The 23rd meeting of the Chinese Progressive Association in Sydney. A company in Sydney sues the state government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090750 | 24090750 |
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]);