This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5866 | 5866 | 1900-08-18 | 2 | c | A young girl was injured in a traffic accident on a Sydney street. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5869 | 5869 | 1900-08-18 | 2 | d | The Sydney Chinese Empire Reform Association, after its establishment, has received donations from Chinese not only in Sydney but also from other towns, such as Huang Zhu, Liu Yanguang, Lin Dang, Chen Yanyao, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5881 | 5881 | 1900-08-18 | 2 | f | Beijin orders the capture of Liu E and Fang Shijie by Liu Kunyi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5882 | 5882 | 1900-08-18 | 2 | f | Business is slack in Hankou following Boxer rebellions in the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5888 | 5888 | 1900-08-18 | 3 | b | Guangdong experinced a good harvest in a time of turmoil. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102911 | 24102911 | |
5893 | 5893 | 1900-08-18 | 3 | c | It is rumoured that Rong Lu has become mad. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102911 | 24102911 | |
5894 | 5894 | 1900-08-18 | 3 | c | Timetable of ocean liners traveling to and from Asian ports. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102911 | 24102911 |
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]);