This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44437 | 44437 | 1926-02-13 | 11 | a-c | Photographs of The Solar Electrical and Manufacturing Co. Ltd (guang ming zhi zao dian qi you xian gong si), Shanghai, China, and photographs of its factory, office, machinery department, glassmaking department, power room, electric wiring department, electric department and the glass department. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101462 | 24101462 | |
44438 | 44438 | 1926-02-13 | 11 | c | Photograph of Dr A. John Sing (Liu Junchen), at 188 Oxford Street, Woollahra, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101462 | 24101462 |
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]);