This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
1488 | 1488 | 1898-12-31 | 2 | a-b | Story of New Party, Kang Youwei and his followers. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 | ||
1489 | 1489 | 1898-12-31 | 2 | b | Criminal escapes from Hong Kong, flees to Japan. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 | ||
1490 | 1490 | 1898-12-31 | 2 | b-c | Woman refused to remarry after her husband died. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 | ||
1491 | 1491 | 1898-12-31 | 2 | c | Mei Liji, from Xiangshan, disappeared in forest in New South Wales. His body was found days later. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 | ||
1492 | 1492 | 1898-12-31 | 2 | c | Three people die in crowded horse racing stadium. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 | ||
1493 | 1493 | 1898-12-31 | 2 | d | Empress moved to Palace; Emperor's hearing worsens. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 | ||
1494 | 1494 | 1898-12-31 | 2 | d-e | Quite a few burglary cases in Sydney during Christmas Day holiday. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 | ||
1495 | 1495 | 1898-12-31 | 2 | e | French and Chinese governments continue to negotiate over missionary case in Sichuan. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 | ||
1496 | 1496 | 1898-12-31 | 2 | e-f | Two brothers from China, Wei Kang and Wei Yi, quarrell over money issue in Bendigo. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 | ||
1497 | 1497 | 1898-12-31 | 2 | f | Lu Chuanlin to be governor of Zhejiang and Fujian, Wang Zhichun will be governor of Guangdong. | http://trove.nla.gov.au/newspaper/page/24102247 | 24102247 |
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]);