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 |
---|---|---|---|---|---|---|---|---|---|
50907 | 50907 | 1931-11-28 | 5 | a | Second part of a letter from Chen Jiongming to Cai Yuanpei and Zhang Xueliang. | China | http://trove.nla.gov.au/newspaper/page/24090614 | 24090614 | |
50911 | 50911 | 1931-11-28 | 6 | a | Guangdong news/ Gu Yingfen dies. Bandits in Guangzhou sends human's head for ransom. Zhang Fakui returns the weapons he detained. The First Group Army in financial shortage. A survey on the shops in Guangzhou that closed down last year. Guangdong owes army provisions and the amount. Arsenal explodes in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24090617 | 24090617 | |
50912 | 50912 | 1931-11-28 | 7 | a | Chinese communities in Sydney gather and mourn the death of countrymen in Manchuria during the Japanese invasion, and collection of the memorial writings. Chinese communities in Melbourne donate to the Saving China Military Funds. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090616 | 24090616 | |
50913 | 50913 | 1931-11-28 | 8 | a | Japanese troops occupy Qiqihar in Heilongjiang province. Other report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090619 | 24090619 | |
50914 | 50914 | 1931-11-28 | 8 | a | Chinese ambassador Shi Zhaojin requests the League of Nations to mediate. | Britain | http://trove.nla.gov.au/newspaper/page/24090619 | 24090619 |
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]);