This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31751 | 31751 | 1916-11-18 | 8 | c-d | Guangdong news/ Lu Rongting retains Li Shi. Governor Zhu Qinglan and the education in Guangdong. Lu Rongting is arriving Guangzhou. Tan Haoming manages military affairs temporarily. Governor Zhu Qinglan reports that Long Jiguang is leaving Guangzhou. Long Jiguang's army gather in Humen. Qin Chunxuan arrives Guangxi. The sitting of the provincial legislature. | China | http://trove.nla.gov.au/newspaper/page/24095484 | 24095484 |
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]);