This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31459 | 31459 | 1916-08-05 | 6 | a-b | Third and final part of the report prepared by Zeng Zongjian, Chinese Consul-General in Australia, on the sale of China products in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095359 | 24095359 | |
31460 | 31460 | 1916-08-05 | 6 | b-c | Collection of telegrams (Huang Xing to Tang Shaoyi, Huang Xing to Lu Rongting, Huang Xing to the military governor of Zhejiang province, Huang Xing to military commander in Guangdong, and Wang Xishan to his school mates of the Baoding Army School). | China | http://trove.nla.gov.au/newspaper/page/24095359 | 24095359 | |
31461 | 31461 | 1916-08-05 | 6 | c | Brief comments on industry by Yang Shaozong: businessmen are advised to take care of the package. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095359 | 24095359 |
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]);