This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33097 | 33097 | 1918-03-09 | 8 | a-b | Beijing news/ French ambassador in Beijing urges Chinese government to dispatch troops to Europe. No celebration on the birthday of President Feng Guozhang. Li Yuanhong and his recent attitudes. Lu Rongting comments on the national parliament in Beijing. Chen Jintao seeks to be pardoned. A monk in Zhejiang province is kidnapped for marriage. | China | http://trove.nla.gov.au/newspaper/page/24097214 | 24097214 | |
33098 | 33098 | 1918-03-09 | 8 | b-d | Guangdong news/ Sun Yatsen and the capture of two warships near Guangzhou. Cheng Biguang orders warships to stop. Sun Yatsen entertains social associations in Guangdong and his speech at the party. | China | http://trove.nla.gov.au/newspaper/page/24097214 | 24097214 |
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]);