This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21472 | 21472 | 1909-08-14 | 3 | a | Correspondence from America/ American engineer is involved in river dredge project in Tianjin. Mai Hongjun is to visit America. Huang Kaijia's children attend American school. Chinese student Xiang Xiang in Columbia University. Chinese Empire Reform Association in America sets up a Chinese school. | America | http://trove.nla.gov.au/newspaper/page/26802287 | 26802287 | |
21493 | 21493 | 1909-08-14 | 7 | a | Chinese consul general in Australia Liang Lanxun returns by Japanese liner on the death of his father, which is criticised by Tung Wah Times and the Chinese communities as they boycott to Japanese goods and service. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802291 | 26802291 |
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]);