This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25022 | 25022 | 1911-09-23 | 2 | c-d | China's foreign loans | China intends to borrow more foreign loans for its sealine and railways. | Other... | http://trove.nla.gov.au/newspaper/page/24091930 | 24091930 |
25034 | 25034 | 1911-09-23 | 3 | c-d | Guangdong news | The issue of gangsters. Revolutionary activities in Guangdong. The expenses of spies in Hong Kong. The cost of governor's office. Number of police in Guangdong. Gangsters and robberies in Gangming and Qingxiang counties. | Other... | http://trove.nla.gov.au/newspaper/page/24091929 | 24091929 |
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]);