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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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]);