This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31607 | 31607 | 1916-09-30 | 2 | a-b | Editorial on Lu Rongting's governance in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095422 | 24095422 | |
31611 | 31611 | 1916-09-30 | 3 | c-d | Report in foreign newspapers on the new treaty between Russia and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095421 | 24095421 | |
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 | |
31620 | 31620 | 1916-09-30 | 8 | e | A notice issued by the Dongguan Gong Yi Tang in Sydney on the transfer of remains of their native fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095427 | 24095427 |
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]);