This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31575 | 31575 | 1916-09-16 | 6 | a-b | Collection of telegrams (Kang Youwei to Li Yuanhong and Duan Qirui and their separate reply, Duan Qirui to Qin Chunxuan, Tang Jiyao to Long Jiguang). | China | http://trove.nla.gov.au/newspaper/page/24095410 | 24095410 | |
31576 | 31576 | 1916-09-16 | 6 | b-c | American comments on the new dispute between China and Japan and Japan's demands. American government closely watches the negotiation between China and Japan. Japanese company is likely to lend money to China. | America | http://trove.nla.gov.au/newspaper/page/24095410 | 24095410 | |
31577 | 31577 | 1916-09-16 | 6 | c | Collection of maxims. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095410 | 24095410 |
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]);