This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26977 | 26977 | 1913-02-08 | 6 | a | The Chinese Commercial Assoicaiton of New South Wales' notice about change of its name and objectives. | Other... | http://trove.nla.gov.au/newspaper/page/24092573 | 24092573 | |
26978 | 26978 | 1913-02-08 | 6 | a | Chinese consul general's notice about donations to saving China. | Other... | http://trove.nla.gov.au/newspaper/page/24092573 | 24092573 | |
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 | |
26980 | 26980 | 1913-02-08 | 6 | b | Strange things in Guangdong election. | Other... | http://trove.nla.gov.au/newspaper/page/24092573 | 24092573 | |
26981 | 26981 | 1913-02-08 | 6 | b-c | Story about Honolulu people. | Other... | http://trove.nla.gov.au/newspaper/page/24092573 | 24092573 | |
26982 | 26982 | 1913-02-08 | 6 | c | Corruption in Guangdong judicial department. | Other... | http://trove.nla.gov.au/newspaper/page/24092573 | 24092573 |
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]);