This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29423 | 29423 | 1914-11-28 | 3 | b | Chinese navy and the defence project in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24093337 | 24093337 | |
29424 | 29424 | 1914-11-28 | 3 | b | Gentry Cai Faping in Fujian province helps to sell the government bonds. | China | http://trove.nla.gov.au/newspaper/page/24093337 | 24093337 | |
29425 | 29425 | 1914-11-28 | 3 | c-d | Miscellaneous report on the World War I (German submarine fires at British warship, French bulletin on the war, British victory in the Persia Gulf, German celebrate their victory, loss of German troops, Italy may be involved in the war, religion in the war, battles between German and Russian troops). | Other... | http://trove.nla.gov.au/newspaper/page/24093337 | 24093337 |
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]);