This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31445 | 31445 | 1916-07-29 | 7 | a-b | Australia news/ Federal audition of the building industry in Adelaide. German detainees in Australia dig tunnel and escape. Australian troops and their fighting in France. British commander reports the fighting of Australian army in the World War I. | Australia | http://trove.nla.gov.au/newspaper/page/24095350 | 24095350 | |
31446 | 31446 | 1916-07-29 | 7 | b | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095350 | 24095350 | |
31447 | 31447 | 1916-07-29 | 7 | c | The new agreement between Japan and Russia and its influence upon China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095350 | 24095350 | |
31448 | 31448 | 1916-07-29 | 7 | c | The Chinese Constitutionalist Association, 73 George Street North, Sydney, stop to receive any donations. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095350 | 24095350 |
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]);