This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32269 | 32269 | 1917-04-28 | 6 | a | Poems by He Chengfang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095677 | 24095677 | |
32270 | 32270 | 1917-04-28 | 6 | a-b | Beijing news/ Premier Duan Qirui supports to join the Alliance, and opposition by Xu Shuzheng. Liang Qichao on China's diplomacy. Feng Guozhang and Zhang Xun claim that China's sovereignty relies upon Liang Qichao. | China | http://trove.nla.gov.au/newspaper/page/24095677 | 24095677 | |
32271 | 32271 | 1917-04-28 | 6 | b-d | Guangdong news/ Lu Rongting's family returns to Guangxi. Long Jiguang applies to attend the national defence conference. Zhang Wohua and 300 other parliamentarians call for support to Chinese foreign policy. German consul leaves Beihai, Guangxi province. A woman condemns Fu Mengsong, member of the provincial legislature assembly. Corruption of police in Shilong, Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24095677 | 24095677 |
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]);