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 |
---|---|---|---|---|---|---|---|---|---|
9175 | 9175 | 1901-11-27 | 2 | b-c | An article discusses the meaning of revolution. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100245 | 24100245 | |
9196 | 9196 | 1901-11-27 | 3 | b-d | The fifth part of the report on the lawsuit between Li Bu and Chen Shou, two Chinese businessmen in Sydney. Problems with Lin Yik Tong, Chinese Empire Reform Association and the Chinese community in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9197 | 9197 | 1901-11-27 | 3 | e | Corrections from the newspaper. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 | |
9198 | 9198 | 1901-11-27 | 3 | e | Timetable of ocean liner. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100244 | 24100244 |
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]);