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 |
---|---|---|---|---|---|---|---|---|---|
5990 | 5990 | 1900-09-05 | 2 | c | Li Hongzhang detained in Shanghai by British troops. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102935 | 24102935 | |
6010 | 6010 | 1900-09-05 | 3 | c | Chinese community in Sydney organises an excellent exhibition of Chinese sceneries on York Street, Sydney, in order to raise funds for the famine area in India. More exhibitions will be held in the Town Hall. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102934 | 24102934 | |
6011 | 6011 | 1900-09-05 | 3 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102934 | 24102934 | |
6012 | 6012 | 1900-09-05 | 3 | c | Timetable of ocean liners traveling to and from Asian ports. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102934 | 24102934 |
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]);