This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30886 | 30886 | 1916-01-15 | 3 | d | A Japanese transport ship and a British transport ship are sunken by submarines, resulting in many casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24095109 | 24095109 | |
30887 | 30887 | 1916-01-15 | 3 | d | Statistics of British soldiers wounded and killed in battles of Turkish strait. | Britain | http://trove.nla.gov.au/newspaper/page/24095109 | 24095109 | |
30888 | 30888 | 1916-01-15 | 3 | d | Beijing news/Yang Du, Sun Junsu are angry with responses from foreign countries on restoring imperial system and believe quick move is necessary for the purpose of restoration. North Manchuria suffers heavy snow storm. A fire occurs in Fuyu county, Jilin province. | China | http://trove.nla.gov.au/newspaper/page/24095109 | 24095109 |
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]);