This data as json, CSV (advanced)
Suggested facets: page, source, 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 | |
43680 | 43680 | 1925-08-22 | 5 | a | A bus in Hong Kong is bombed. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101251 | 24101251 | |
43681 | 43681 | 1925-08-22 | 5 | a | Macao has been isolated following the massive strike. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101251 | 24101251 | |
43682 | 43682 | 1925-08-22 | 5 | a | Strike in Shanghai and the report. | China | http://trove.nla.gov.au/newspaper/page/24101251 | 24101251 | |
43683 | 43683 | 1925-08-22 | 5 | a | Japan to build more warships. | Japan | http://trove.nla.gov.au/newspaper/page/24101251 | 24101251 | |
43684 | 43684 | 1925-08-22 | 5 | a | Japan and America on the proposed tariff conference in Beijing. | Japan | http://trove.nla.gov.au/newspaper/page/24101251 | 24101251 | |
43688 | 43688 | 1925-08-22 | 6 | a | A Chinese ship disappears on its way from Haikou, Hainan island, to Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101254 | 24101254 | |
43689 | 43689 | 1925-08-22 | 6 | a | Japanese properties in Tianjin are damaged during the chaos and the protest by Japanese ambassador. | China | http://trove.nla.gov.au/newspaper/page/24101254 | 24101254 | |
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 |
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]);