This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51503 | 51503 | 1932-05-07 | 8 | a | Police in Canada arrest communist activists. | Canada | http://trove.nla.gov.au/newspaper/page/24090798 | 24090798 | |
51504 | 51504 | 1932-05-07 | 8 | a | British foreign secretary questioned in the parliament. | Britain | http://trove.nla.gov.au/newspaper/page/24090798 | 24090798 | |
51505 | 51505 | 1932-05-07 | 8 | a | War imminent between Russia and Japan. | China | http://trove.nla.gov.au/newspaper/page/24090798 | 24090798 | |
51506 | 51506 | 1932-05-07 | 8 | a | Japanese military commander bombed in Shanghai, and response of the British government. | China | http://trove.nla.gov.au/newspaper/page/24090798 | 24090798 | |
51507 | 51507 | 1932-05-07 | 8 | b | The League of Nations to have a special session. | Britain | http://trove.nla.gov.au/newspaper/page/24090798 | 24090798 | |
51508 | 51508 | 1932-05-07 | 8 | b | A survey on the Japanese troops in Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24090798 | 24090798 | |
51509 | 51509 | 1932-05-07 | 8 | c | Australia news/ Good news for the unemployed people in NSW. The Dalwood Health Home in Sydney helps to raise Chinese children. Underground office crushed in Sydney for forging postage stamps. Acting justice minister of NSW seeks to impeach the premier. NSW state premier awarded by the ordinary people. Advertisement for Mitchell Knitting Mills in Sydney. Tax commissioner of NSW under investigation. Police on parade in Sydney. Advertisement of the Redfern Cabinet Works. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090798 | 24090798 | |
51510 | 51510 | 1932-05-07 | 8 | e | Advertisement of the British America Assurance Company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090798 | 24090798 |
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]);