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 |
---|---|---|---|---|---|---|---|---|---|
45570 | 45570 | 1927-03-26 | 2 | d | Treaty talks between China and Belgium. | China | http://trove.nla.gov.au/newspaper/page/24101924 | 24101924 | |
45571 | 45571 | 1927-03-26 | 2 | e | Preparation for the set-up of provincial government in Hubei. | China | http://trove.nla.gov.au/newspaper/page/24101924 | 24101924 | |
45572 | 45572 | 1927-03-26 | 2 | e | Talks between China and Britain on the case of Hankou. | China | http://trove.nla.gov.au/newspaper/page/24101924 | 24101924 | |
45573 | 45573 | 1927-03-26 | 3 | c | People in Hunan on the Guangzhou-Hankou railway. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
45574 | 45574 | 1927-03-26 | 3 | c | Strike in Shanghai and the report. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
45575 | 45575 | 1927-03-26 | 3 | d | Riots in Nanchang on the New Year's eve. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
45576 | 45576 | 1927-03-26 | 3 | e | Japan and the Nationalist government in Guangzhou. Japanese policy in Manchuria and Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
45577 | 45577 | 1927-03-26 | 3 | f | Chinese residents in the international concessions in Shanghai. Strike in preparation in Xiamen, of Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24101923 | 24101923 | |
45583 | 45583 | 1927-03-26 | 8 | a-d | Guangdong news/ Provincial government to reduce land tax. Li Jishen to appoint Zhen Runqi. Tan Pingshan returns to Guangdong. Chen Yaozu reports road construction in local counties. Road construction in Heshan county. Pharmacy workers on strike in Guangzhou. Big garrison to be built in Zhaoqing. Shops reopened in Shilong town, of Nanhai. Decline of silk industry in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101930 | 24101930 |
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]);