This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24986 | 24986 | 1911-09-16 | 2 | c | Recent military events | New administration and management in the army. Navy chief intends to borrow 8 hundred million pounds from Britain to strengthen China's navy. The navy orders three torpedo boats from Germany. | http://trove.nla.gov.au/newspaper/page/24091921 | 24091921 | |
24987 | 24987 | 1911-09-16 | 2 | c | Events of diplomatic relations | China negotiates with Britain about the issue of Pianma (ppp). China negotiates with Russia the extension of their treaty. China discusses with Mexico on the issue of the killing of Chinese in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24091921 | 24091921 |
24999 | 24999 | 1911-09-16 | 3 | c | Beijing news | The army employed three Germans. Chairman of the state advisory committee asks for retirement. New appointments for the office of the Hunan-Guangdong-Wuhan railway. Budget for emperor's study. Gao Erqian's new appointment. New governor for Sichuan province. Application for visit to the military exercise in autumn. | Other... | http://trove.nla.gov.au/newspaper/page/24091920 | 24091920 |
25011 | 25011 | 1911-09-16 | 7 | c | A banter | A banter is on the explanation of the proverb 'being smashes to pieces'. | Other... | http://trove.nla.gov.au/newspaper/page/24091924 | 24091924 |
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]);