This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26955 | 26955 | 1913-02-08 | 2 | a-b | Liang Qichao's article on provincical government. | Other... | http://trove.nla.gov.au/newspaper/page/24092569 | 24092569 | |
26963 | 26963 | 1913-02-08 | 3 | a-b | American arrested for abducting and trafficking women. | Other... | http://trove.nla.gov.au/newspaper/page/24092568 | 24092568 | |
26979 | 26979 | 1913-02-08 | 6 | a-b | Inspector Chen Xilin's communication with influential figure in Fujian over Fujian social order. | Other... | http://trove.nla.gov.au/newspaper/page/24092573 | 24092573 | |
26984 | 26984 | 1913-02-08 | 7 | a-b | Australian news/ National revenue. Australian commercial association unhappy with government's new money. Japanese warship receives welcome in Melbourne. Taiyuan ship safely arrives in Sydney. Rich businessman dies in Sydney. Chinese arrested for smoking opium. Australian prostitutes around Chinese community arrested. Flood in Queensland. | Other... | http://trove.nla.gov.au/newspaper/page/24092572 | 24092572 | |
26988 | 26988 | 1913-02-08 | 8 | a-b | Sad announcement to all Chinese over French intention of occupation of Guangzhou Bay. | Other... | http://trove.nla.gov.au/newspaper/page/24092575 | 24092575 |
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]);