This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28374 | 28374 | 1914-01-03 | 8 | a-b | First part of a detailed report on the new administrative divisions in China. | China | http://trove.nla.gov.au/newspaper/page/24092951 | 24092951 | |
28375 | 28375 | 1914-01-03 | 8 | b | More Korean people immigrate to Manchuria and their distributions. | China | http://trove.nla.gov.au/newspaper/page/24092951 | 24092951 | |
28376 | 28376 | 1914-01-03 | 8 | b-c | Guangdong news/ Guan Renfu and Liao Dating will be promoted for their help in the cancellation of independence. Disputes in Nanhai county over the lime mine. Authority in Foshan to ban begging. Execution of ten more revolutionary rebels and the report. Funeral for Kang Youwei's mother. | China | http://trove.nla.gov.au/newspaper/page/24092951 | 24092951 |
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]);