This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10762 | 10762 | 1902-05-31 | 3 | b | Brief outline of the new Manchuria treaty between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24100443 | 24100443 | |
10763 | 10763 | 1902-05-31 | 3 | b | A further report on Dong Fuxiang and his army. | China | http://trove.nla.gov.au/newspaper/page/24100443 | 24100443 | |
10764 | 10764 | 1902-05-31 | 3 | b | School, examination, and modern education in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24100443 | 24100443 | |
10765 | 10765 | 1902-05-31 | 3 | b | Wuxi, Jiangsu province, issues lottery in order to raise money. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100443 | 24100443 | |
10766 | 10766 | 1902-05-31 | 3 | b | A Briton was beaten in Xiangshan county, Guangdong. The case is under investigation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100443 | 24100443 |
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]);