This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51581 | 51581 | 1932-06-04 | 5 | c | Australia news/ People arrested in Sydney for counterfeit bank notes. A man, 33, jumps over the Sydney Harbour Bridge for suicide. A man in Sydney is charged with sexual harassment. Young girl is raped in Sydney. Old Chinese man in Cairns is robbed. Horden company has a shareholders' meeting. Sailors talks about the war in Shanghai on arrival in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090825 | 24090825 | |
51582 | 51582 | 1932-06-04 | 5 | e | Chinese communities in Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090825 | 24090825 | |
51591 | 51591 | 1932-06-04 | 8 | d | Australia news/ Judgement from Britain over the sacking of NSW state premier Jack Lang. Police find lost Chinese child, 13. Chinese man escapes from a robbery. Anti-Japanese sentiment in Australia. Communist activist in Sydney is attacked. Astronomical observatory predicts another earthquake. Tax officer commit suicide in Sydney. Returned servicemen sabotage jewellery shop in Sydney. Citizenship of Australian women who marry foreigners. Speech by Chinese Consul-General in Australia Chen Weipin at the George Morrison Memorial Lecture in Canberra. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090830 | 24090830 |
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]);