This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16602 | 16602 | 1906-12-22 | 2 | a-b | Seventh part of the article written by Kang Youwei, Break down barriers between family clans. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801167 | 26801167 | |
16603 | 16603 | 1906-12-22 | 2 | b-c | Correspondence from America. A letter from Chinese community in Panama reports on suffering of Chinese labourers there, and warns other Chinese compatriots not to be fooled by American government. Senders of the letter include Qin Zi'an, Huang Wupin, Huang Langxuan, Li Shixi, Luo Qing, Yu Sheng, Xu Shijing, Chen Yu, Chen Jianneng, Wu Mei, Chen Wenhui, and Chen Caixian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801167 | 26801167 | |
16604 | 16604 | 1906-12-22 | 2 | c-d | Railways around the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801167 | 26801167 |
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]);