This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17724 | 17724 | 1907-07-06 | 6 | a-b | Colony suffers. Local authority in Transvaal, South Africa, bans Chinese labourers from drinking wine, and a report on the case. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801392 | 26801392 | |
17725 | 17725 | 1907-07-06 | 6 | b | Important report. Governor Duan Fang, of Jiangsu province, writes to the educational officer in regards to selection of Chinese students to study in America, and number of scholarships offered by American universities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801392 | 26801392 | |
17726 | 17726 | 1907-07-06 | 6 | b-c | Miscellaneous report. Report on Bushido organisations in Taiwan, membership and social functions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801392 | 26801392 | |
17727 | 17727 | 1907-07-06 | 6 | c | Help our compatriots. Chinese communities in Western Australia, New South Wales and Queensland donate to flooding victims in north Jiangsu province. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801392 | 26801392 |
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]);