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 |
---|---|---|---|---|---|---|---|---|---|
51408 | 51408 | 1932-04-16 | 2 | c | Wang Jingwei on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24090768 | 24090768 | |
51409 | 51409 | 1932-04-16 | 2 | c | Number of casualties of the 19th Route Army during their fighting with Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24090768 | 24090768 | |
51420 | 51420 | 1932-04-16 | 5 | c | Traitors in Shenyang during the national crisis. | China | http://trove.nla.gov.au/newspaper/page/24090769 | 24090769 | |
51428 | 51428 | 1932-04-16 | 7 | c | Foreign report on the retreat of Chinese troops from Shanghai after the battle with Japanese army. Japanese troops want to occupy Shanghai forever. | China | http://trove.nla.gov.au/newspaper/page/24090771 | 24090771 | |
51438 | 51438 | 1932-04-16 | 8 | c | Australia news/ Internal fighting of the Chinese communities in Darwin. New South Wales state government has no choice but to repay the debts. Judgement on the disputes between the federal and NSW state government over the debt repayment. Chinese communities in Sydney sponsor the George Morrison Lecture in Canberra and Chinese Consul-General in Australia Chen Weipin will be speaker. Earthquake in New Zealand. A case of life in Sydney. Open letter from the Chinese Progressive Association in Sydney to the whole overseas Chinese communities. Federal Prime Minister Joe Lyons on travellers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090774 | 24090774 |
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]);