This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45499 | 45499 | 1927-02-26 | 2 | c | Editorial on the end of Sun Chuanfang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101892 | 24101892 | |
45500 | 45500 | 1927-02-26 | 2 | d | The provisional court in the international court in Shanghai and the legal cases. | China | http://trove.nla.gov.au/newspaper/page/24101892 | 24101892 | |
45501 | 45501 | 1927-02-26 | 2 | d | Reform of judicial system in Manchuria and the involvement of Japanese experts. | China | http://trove.nla.gov.au/newspaper/page/24101892 | 24101892 | |
45502 | 45502 | 1927-02-26 | 2 | e | German ship and smuggled weapons detained in Qingdao and the report. | China | http://trove.nla.gov.au/newspaper/page/24101892 | 24101892 | |
45503 | 45503 | 1927-02-26 | 3 | c | Jiang Jieshi's recent talks to his followers. | China | http://trove.nla.gov.au/newspaper/page/24101891 | 24101891 | |
45504 | 45504 | 1927-02-26 | 3 | c | Wu Peifu removes Jin Yunpeng and the report. | China | http://trove.nla.gov.au/newspaper/page/24101891 | 24101891 | |
45505 | 45505 | 1927-02-26 | 3 | d | Japanese strategy for foreign investment. | China | http://trove.nla.gov.au/newspaper/page/24101891 | 24101891 | |
45506 | 45506 | 1927-02-26 | 3 | d | No kiss allowed in European and American countries. | China | http://trove.nla.gov.au/newspaper/page/24101891 | 24101891 | |
45507 | 45507 | 1927-02-26 | 3 | f | Zhang Zuolin recruits many political and diplomatic talents. | China | http://trove.nla.gov.au/newspaper/page/24101891 | 24101891 | |
45508 | 45508 | 1927-02-26 | 5 | a-c | Foreign report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101893 | 24101893 | |
45509 | 45509 | 1927-02-26 | 7 | a-b | Australia news/ A boy in Sydney is stung by spider. Robbery in a Sydney church. Two women are arrested on board of German liner for pretending to be man. Bomb explosion in Sydney. Chinese community in Sydney donate to Dongguan hospital. Duke of York arrives Auckland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101895 | 24101895 | |
45510 | 45510 | 1927-02-26 | 7 | b-c | County magistrate in Xiangshan is besieged by bandits and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101895 | 24101895 | |
45511 | 45511 | 1927-02-26 | 7 | c-d | Names listed for donations to the Dongguan hospital. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101895 | 24101895 | |
45512 | 45512 | 1927-02-26 | 8 | a-d | Guangdong news/ Jiang Jieshi invites Wang Jingwei and Hu Hanmin back to office. Proposal to reform civil administration in local counties. Preparation for the set-up of military office in Guangzhou. Order to wipe out bandits from Guangzhou. Si yi people in Guangzhou request to eradicate pirates. Fighting between rickshaw men and taxi driver for the limited jobs. Labour movement in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24101898 | 24101898 |
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]);