This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29702 | 29702 | 1915-02-13 | 7 | a-b | Australia news/A reply letter of Guangdong governor to Chinese counsellor in Australia on crime issues in Guangdong. Aboriginal population is declining due to white people's policy. A French and an Italian seamen in Sydney are severely punished for dealing illegal immigration. The case of Huang Yianzhao killing Liu Yunbo in New South Wales is being convicted. An European man is arrested for suspect of killing Huang Ji in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094723 | 24094723 |
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]);