This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31824 | 31824 | 1916-12-16 | 8 | a-b | Beijing news/ Correspondence between President Li Yuanhong and Vice-President Feng Guozhang. Gao Erqian is going to Guangzhou for the border demarcation in Macao. Sports game to be organised for Chinese martial arts. France demands to open Yunnan. Catholic fathers in Sichuan province in the Confucianism. Fujian businessmen and the navigation industry. Sichuan people charge Zhang Jingyao. | China | http://trove.nla.gov.au/newspaper/page/24095521 | 24095521 | |
31825 | 31825 | 1916-12-16 | 8 | c--e | Guangdong news/ Lu Rongting arrives Guangzhou and the report. Three naval ports to be built in Guangdong. Lu Rongting suggests joint defence for Guangdong and Guangxi. New road proposed from Guangzhou to Huizhou. Servicemen are disciplined for railway travel. Ling Qichao reports the death of Cai E in Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24095521 | 24095521 | |
31826 | 31826 | 1916-12-16 | 8 | e | Poems by Zhou Yufan and Wu Elou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095521 | 24095521 |
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]);