This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30814 | 30814 | 1915-12-11 | 7 | a-b | Australia news/Chinese consul general notifies China's Business and Trade Association in Sydney of awards by Chinese government. China's Primary School in Sydney holds its graduation ceremony. China's Business and Trade Association in Sydney meets to elect new directors as some of them are to return to China. Opium is found in a ship from Britain in Sydney. A ship in Sydney is detained by strong wind and a lady aboard is suspected suffering plague. Ya Li, a Chinese in Australia died at age of 117. | Australia | http://trove.nla.gov.au/newspaper/page/24095087 | 24095087 |
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]);