This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
16635 | 16635 | 1906-12-22 | 7 | b-c | Two folk songs on quit opium smoking. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801170 | 26801170 |
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]);