This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17679 | 17679 | 1907-06-29 | 3 | c | The treaty between Japan and France and its possible influence upon China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801379 | 26801379 | |
17680 | 17680 | 1907-06-29 | 3 | c | Several Russian revolutionaries now in Sweden. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801379 | 26801379 | |
17681 | 17681 | 1907-06-29 | 3 | c | Dozens of officers and soldiers are poisoned in France. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801379 | 26801379 | |
17682 | 17682 | 1907-06-29 | 3 | c | King of Britain presides over a banquet in honour of King of Thailand. | Britain | http://trove.nla.gov.au/newspaper/page/26801379 | 26801379 | |
17683 | 17683 | 1907-06-29 | 3 | c | New York has a big reservoir which provides water to the residents. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801379 | 26801379 | |
17684 | 17684 | 1907-06-29 | 3 | c | Emperor of Germany is to visit Britain this coming autumn. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801379 | 26801379 | |
17685 | 17685 | 1907-06-29 | 3 | c | Business associations in Japan protest against American government for attacking Japanese restaurant in San Francisco. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801379 | 26801379 | |
17686 | 17686 | 1907-06-29 | 3 | c | American President Roosevelt has agreed to refund to China some of the Boxer Indemnity. | Britain | http://trove.nla.gov.au/newspaper/page/26801379 | 26801379 | |
17691 | 17691 | 1907-06-29 | 6 | c | Help our compatriots. Chinese community in Queensland donates to flooding victims in north Jiangsu province. Hundreds of names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801384 | 26801384 | |
17704 | 17704 | 1907-06-29 | 8 | c | Jokes. New national style. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801386 | 26801386 | |
17705 | 17705 | 1907-06-29 | 8 | c | Poems written by Xu Tiehua in Tianjin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801386 | 26801386 | |
17706 | 17706 | 1907-06-29 | 8 | c | Comments. Qin Chunxuan after returning to Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801386 | 26801386 |
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]);