This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29676 | 29676 | 1915-02-06 | 7 | a-b | Australia news/Germany government does not send Australian people to the camp. Colour-skinned children are not allowed to go to school in Bei Na Da (ppp). Huang Yinzhao killed Liu Bao in Da Bu (ppp), New South Wales. Huang Ji, an old Chinese in Townsville, is dying in hospital from a violent robbery. Thieves steal money from houses of Tian Chen, Li Yuhua, and Huang Zi in New South Wales. Cornell in south Australia is suffering bad draught. Australian government treats Kenya people, | Australia | http://trove.nla.gov.au/newspaper/page/24094715 | 24094715 |
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]);