This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31484 | 31484 | 1916-08-12 | 7 | a-b | Australia news/ The son of a Sydney Chinese businessman is kidnapped in Xinning county, Guangdong, and ransom demanded. The third government bonds to be issued by the Commonwealth. James Stedman Ltd moves to Haymarket, Sydney. More donations to the Chinese Constitutionalist Association on 73 George Street North, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095368 | 24095368 | |
31485 | 31485 | 1916-08-12 | 7 | b | Storm in Wellington, New Zealand. New Zealand government raises more funds for the War. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095368 | 24095368 | |
31486 | 31486 | 1916-08-12 | 7 | b-c | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095368 | 24095368 | |
31487 | 31487 | 1916-08-12 | 7 | c | Poems by Zhou Guozheng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095368 | 24095368 | |
31488 | 31488 | 1916-08-12 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095368 | 24095368 |
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]);