This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25862 | 25862 | 1912-03-16 | 2 | a-b | Ask prince to surrender | Letter to ask prince Tao Beile to surrender to republic. | Other... | http://trove.nla.gov.au/newspaper/page/24092165 | 24092165 |
25882 | 25882 | 1912-03-16 | 6 | a-b | Notice of Chinese consul-general to New Zealand | Public notice of Chinese consul-general to New Zealand asking Chinese there to give up drug smoking and gambling. | Other... | http://trove.nla.gov.au/newspaper/page/24092170 | 24092170 |
25885 | 25885 | 1912-03-16 | 7 | a-b | Australian news | Chinese consulate in Melbourne passes on President Yuan Shikai's message to Chinese organisations in Sydney for their support. Several Australian warships are to be ready for service. Australian wool export increased. Robbery caught. German consulate robbed. Young girl charged for theft. Several Chinese beaten by westerners. Illegal entrees from Hong Kong. Two ships collided. | Other... | http://trove.nla.gov.au/newspaper/page/24092169 | 24092169 |
25891 | 25891 | 1912-03-16 | 8 | a-b | Issue of Guangdong railway | Guangdong railway shareholders company telegrams republic president Sun for borrowing money for building Guangdong railway. | Other... | http://trove.nla.gov.au/newspaper/page/24092172 | 24092172 |
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]);