This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7225 | 7225 | 1901-03-13 | 2 | d | A man's story in Singapore. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099971 | 24099971 | |
7226 | 7226 | 1901-03-13 | 2 | d | British officers in China see off Australian soldiers; China and Russia sign a treaty on Manchuria; Russia plans to build a railway from Manchuria to Beijing; Japan wants Fujian province from China; Britain advised China not to sign the Manchuria with Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24099971 | 24099971 | |
7242 | 7242 | 1901-03-13 | 3 | d | Tribute from Guangdong province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099970 | 24099970 | |
7243 | 7243 | 1901-03-13 | 3 | d | Famous bandits Ou Xin is now a monk. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099970 | 24099970 | |
7244 | 7244 | 1901-03-13 | 3 | d | Britain contacted Russia on the issue of Manchuria. | Australia | http://trove.nla.gov.au/newspaper/page/24099970 | 24099970 | |
7245 | 7245 | 1901-03-13 | 3 | d | A man threw a stone at the Emperor of Germany. | Other... | http://trove.nla.gov.au/newspaper/page/24099970 | 24099970 |
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]);