This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32094 | 32094 | 1917-02-17 | 6 | a | Elegiac couplets written by Kang Youwei on the death of Cai E. | China | http://trove.nla.gov.au/newspaper/page/24095605 | 24095605 | |
32095 | 32095 | 1917-02-17 | 6 | a | Poems by Zhou Ruiting. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095605 | 24095605 | |
32096 | 32096 | 1917-02-17 | 6 | b | Beijing news/ Liang Qichao arrives in Beijing and the report. Court hearing on the fighting in the national parliament. Zhou Shumo seeks to resign. China ceases to borrow loans from Japan. | China | http://trove.nla.gov.au/newspaper/page/24095605 | 24095605 | |
32097 | 32097 | 1917-02-17 | 6 | b-c | Guangdong news/ A memorial pagoda to be built in Haizhu. Zhang Mingqi is awarded medal for the Guangdong independence. Lu Rongting on the cleanups of bandits in local villages. Long Jiguang's troops are in desperate need of food. Joint Local Security Committee established in the Si Yi (See Yup) counties (Xinhui, Xinning, Kaiping and Enping). Governor Zhu Qinglan is seeking to permit gambling for more tax income. Xinhui county magistrate Zhuang Yi is charged for harassment. | China | http://trove.nla.gov.au/newspaper/page/24095605 | 24095605 |
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]);