This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24696 | 24696 | 1911-07-15 | 2 | c-d | The sad news about China's new foreign loans | Several sad news about China's new foreign loans. | Other... | http://trove.nla.gov.au/newspaper/page/24091843 | 24091843 |
24712 | 24712 | 1911-07-15 | 3 | c-d | Guangdong news | Governor intends to borrow more foreign loans. Governor held meetings about Macao. Use a revolutionary as spy. Governor appeals for reduction of tax. Two officials return to Guangdong. Twenty students were kidnapped. About 20 people who advocate pigtail cutting from Japan are to be in Guangdong soon. | Other... | http://trove.nla.gov.au/newspaper/page/24091842 | 24091842 |
24720 | 24720 | 1911-07-15 | 8 | c-d | An alcohol workship burned down | An alcohol workshop was burned down in Fushan, Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24091849 | 24091849 |
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]);