This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9138 | 9138 | 1901-11-20 | 3 | b | Members of an American family are fighting for inheritance. | America | http://trove.nla.gov.au/newspaper/page/24100236 | 24100236 | |
9139 | 9139 | 1901-11-20 | 3 | b | The third 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/24100236 | 24100236 |
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]);