This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31615 | 31615 | 1916-09-30 | 7 | a-b | Australia news/ Memorial service on the birthday of Confucius organised by the Chinese community in Sydney, and speakers include Zheng Fanchang, Wu Elou, Peng Yuwen, Guo Jiexiu, Guo Shun, Chen Jinghan, Police raid headquarters of Labour Party in Sydney. Heavy rain in Melbourne and the tragedy. A Chinese man in Sydney hangs himself. Prime Minister talks about the War in Sydney and the coming federal election. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095425 | 24095425 | |
31616 | 31616 | 1916-09-30 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095425 | 24095425 | |
31617 | 31617 | 1916-09-30 | 7 | d | Advertisement for The Sun Co Ltd, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095425 | 24095425 |
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]);