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 |
---|---|---|---|---|---|---|---|---|---|
43671 | 43671 | 1925-08-22 | 2 | a | An excellent opportunity to promote China products, editorial by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101250 | 24101250 | |
43679 | 43679 | 1925-08-22 | 3 | d | Tung Wah Times reminds readers to pay their subscription fee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101249 | 24101249 | |
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 | |
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 | |
43705 | 43705 | 1925-08-22 | 8 | a-d | Guangdong news/ British troops in Guangzhou fire at the demonstrators and the declaration issued by the provincial government. Guangdong people in Beijing send their representatives to investigate the Shamian Massacre. Xu Chongzhi replies to Guangdong fellows in Beijing on the Shamian massacre. Big gatherings in Guangzhou in protest against the Shamian Massacre. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101256 | 24101256 | |
43706 | 43706 | 1925-08-22 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101256 | 24101256 | |
43707 | 43707 | 1925-08-22 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101256 | 24101256 |
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]);