This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27274 | 27274 | 1913-04-12 | 7 | a-b | Australian news/ Case of NSW Chinese farmer's shot down. Chinese opium smokers ask for smoking licence. Australian Foreign Affairs Department does not allow Pan Ru wife's visa to be extended. Chinese summoned to court for smuggling illegal migrants to Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092644 | 24092644 | |
27275 | 27275 | 1913-04-12 | 7 | b | Chinese consulate's notice about opening of Chinese parliament. | Other... | http://trove.nla.gov.au/newspaper/page/24092644 | 24092644 | |
27276 | 27276 | 1913-04-12 | 7 | b | Provincial parliament members arrive in Beijing for parliament opening. British ambassador to China says too early for Britain to recognise Republic China. Chinese parliament opened yesterday in Beijing. | Other... | http://trove.nla.gov.au/newspaper/page/24092644 | 24092644 |
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]);