This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24725 | 24725 | 1911-07-22 | 2 | c-d | Minister for transport asks for more foreign loans | Minister for transport asks for more foreign loans. | Other... | http://trove.nla.gov.au/newspaper/page/24091851 | 24091851 |
24738 | 24738 | 1911-07-22 | 3 | c-d | Guangdong news | Governor Zhang appeals for payment for railways shares. Governor Zhang asks for resign. A new governor's house is to be built. Huang Xing and others fled to Vietnam. Riots in Fushan, Guangdong. Two woman work as spies for the revolutionary. Spies are sent to Macao. | Other... | http://trove.nla.gov.au/newspaper/page/24091850 | 24091850 |
24750 | 24750 | 1911-07-22 | 8 | c-d | Treaty for hundred million loans | Details of the treaty for hundred million foreign loan. | Other... | http://trove.nla.gov.au/newspaper/page/24091857 | 24091857 |
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]);