This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44426 | 44426 | 1926-02-13 | 6 | a-c | Ye Gongchuo and the loans for construction of the Jilin-Dunhua railway in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24101459 | 24101459 | |
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 |
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]);