This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30981 | 30981 | 1916-02-26 | 3 | a-b | The public cable by the Yunnan Republican Troops to all soldiers on keeping social stabilities and to Chinese people on preserving republicanism. | China | http://trove.nla.gov.au/newspaper/page/24095170 | 24095170 | |
30991 | 30991 | 1916-02-26 | 7 | a-b | Australia news/Some false paper money is found in Sydney. Ye Bingnan thanks the passenger ship staff for their good service during his trip to China. Ye Ai'yu, daughter of influential businessman Ye Tonggui, marries Liu Guangfu. An European woman is fined for cheating a Chinese cook Li. 'East ' passenger-ship warns people not to believe rumours that it is used for military purpose. | Australia | http://trove.nla.gov.au/newspaper/page/24095174 | 24095174 |
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]);