This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29358 | 29358 | 1914-10-31 | 8 | a | Guangdong news/ Central government advises Guangdong not to comment on the victory or defeat of the World War I. Li Guojun and his policy to maintain local security. Tang Hualong recommends Lu Naixiang. Guangdong people purchase government bonds. Assassination in the west of Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24093310 | 24093310 |
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]);