This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51054 | 51054 | 1932-01-09 | 8 | a | Japanese troops attack Jinzhou in Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
51055 | 51055 | 1932-01-09 | 8 | b | Zhang Xueliang retreats his troops from the front. | China | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
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 | |
51059 | 51059 | 1932-01-09 | 8 | d | Japanese in Shenyang beat American consul. | America | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
51060 | 51060 | 1932-01-09 | 8 | d | Gandhi is imprisoned once again. | Other... | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
51061 | 51061 | 1932-01-09 | 8 | d | Floods in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
51062 | 51062 | 1932-01-09 | 8 | d | Russian in Harbin, of Heilongjiang province, makes troubles. | China | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
51063 | 51063 | 1932-01-09 | 8 | d | Financial difficulties of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24090659 | 24090659 | |
51064 | 51064 | 1932-01-09 | 8 | e | Australia news/ The Savings Bank of New South Wales reopened for business. Bush fire in NSW. The Chinese Society (zhong hua gong hui) in Melbourne organises a drama performance to raise funds for the war of resistance in China and a detailed report. | Tung Wah | 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]);