This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30643 | 30643 | 1915-10-30 | 6 | a-b | Australia news/An European man named Zhan Shi He Di Li (nnn) in Melbourne celebrates his 100-year birthday. The European man stealing a Chinese shop named Shenhe is charged. An European man named James is fined for his slanting a Chinese named Ya Shen having adultery with his wife. Rai (nnn) is to replace Fei Sa (nnn) as Australian premier and the latter is to be ambassador in Britain. Lin Yunzao, a Chinese ambassador to Sa Mo (ppp), goes to Sa Ma island through Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24095039 | 24095039 |
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]);