This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43695 | 43695 | 1925-08-22 | 7 | a | Chinese Consul General in Australia Wei Zijing arrives Sydney to supervise the election of representatives to the national conference in Beijing. Wu Zhaoquan is elected and will be represented by Tang Longxiang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 | |
43696 | 43696 | 1925-08-22 | 7 | a | Some Chinese businessmen in Sydney are preparing to set up another navigation company and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 | |
43697 | 43697 | 1925-08-22 | 7 | b | A boy in New Castle dies of laughing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 | |
43698 | 43698 | 1925-08-22 | 7 | b | A Melbourne man is planning to travel around the world with a small boat. | Australia | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 | |
43699 | 43699 | 1925-08-22 | 7 | b | Australian warship Brisbane is returning from Hong Kong. | Australia | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 | |
43700 | 43700 | 1925-08-22 | 7 | c | Sugar price is going down in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 | |
43701 | 43701 | 1925-08-22 | 7 | c | Leader of the Australian Workers Union has another anti-Chinese speech in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 | |
43702 | 43702 | 1925-08-22 | 7 | c | Australian Oriental Company has a new liner in service. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 | |
43703 | 43703 | 1925-08-22 | 7 | c | Post office workers in Shanghai are on strike for more pay and the report. | China | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 | |
43704 | 43704 | 1925-08-22 | 7 | d | Business in Guangzhou is influenced by the communist propaganda. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101253 | 24101253 |
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]);