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 |
---|---|---|---|---|---|---|---|---|---|
46351 | 46351 | 1927-10-29 | 2 | b | First part of editorial by Tung Wah Times on the failure of the international disarmament conference in Geneva. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098576 | 24098576 | |
46356 | 46356 | 1927-10-29 | 3 | b | The navigation in the Yangtze River after the cooperation between Wuhan and Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46357 | 46357 | 1927-10-29 | 3 | b | Wang Tianpei is executed and the report. | China | http://trove.nla.gov.au/newspaper/page/24098575 | 24098575 | |
46366 | 46366 | 1927-10-29 | 5 | b | Industrial progress in the Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46367 | 46367 | 1927-10-29 | 5 | b | Secretary of the British coal miners' union will not go to Poland. | Britain | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46368 | 46368 | 1927-10-29 | 5 | b | Soviet Russia appoints new ambassador to France. | Britain | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46369 | 46369 | 1927-10-29 | 5 | b | Cases of kidnap in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46375 | 46375 | 1927-10-29 | 7 | b | Australia news/ Illegal Chinese immigrants in Sydney and the tragedy. Two Chinese brothers in Melbourne fight and injure each others. State government of New South Wales tries to retain the police commissioner. Two ships collide near Sydney. New South Wales government appoints new representative to London. The Melbourne Cup and horse racing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 |
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]);