This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28547 | 28547 | 1914-03-07 | 7 | a-b | Australia news/ American university president comments in Fremantle, Western Australia, on the world situations and Chinese immigrants worldwide. British marshal to review Australian troops in Sydney. Australian naval fleet leaves Sydney to visit Adelaide and Melbourne. Sydney police offers rewards for the capture of a murder suspect. Strike of the shop assistants in Sydney. Royal rancher from Burma comes to learn in Australia and arrives Fremantle, Western Australia. Australian women in London and their life. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093033 | 24093033 | |
28548 | 28548 | 1914-03-07 | 7 | c | Government troops in Henan province try to wipe out bandits. An association to be founded in Berlin to promote friendship and business between Germany and China. | http://trove.nla.gov.au/newspaper/page/24093033 | 24093033 | ||
28549 | 28549 | 1914-03-07 | 7 | c | King of Spain and his daily life. President of Mexico and his cruelty. An American couple decides to marry while in the church. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093033 | 24093033 | |
28550 | 28550 | 1914-03-07 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093033 | 24093033 |
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]);