This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31111 | 31111 | 1916-04-08 | 3 | a-b | Telegram from the Chinese Ministry of Foreign Affairs in Beijing and translated by the Chinese Consul-General in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24095219 | 24095219 | |
31119 | 31119 | 1916-04-08 | 7 | a-b | Australia news/ A notice issued by Zeng Zongjian, Chinese Consul-General in Australia on the trade with Chinese business partners. Australian authority bars any export to China. Chinese gambling den in Melbourne is raided and the arrests. Small pox found in New Castle. Chinese community in Wilcannia, New South Wales, donates to the philanthropist foundation in China and their names listed. | Australia | http://trove.nla.gov.au/newspaper/page/24095223 | 24095223 |
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]);