This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23203 | 23203 | 1910-07-23 | 6 | a | Chinese graduates from Columbia University and University of North California, including Chen Huanzhang and Chen Huabing. | America | http://trove.nla.gov.au/newspaper/page/26802710 | 26802710 | |
23204 | 23204 | 1910-07-23 | 6 | a | Correspondence from Beijing/ Recent diplomatic negotiations with foreign countries. Na Tong in the ministry of foreign affairs. Russian ambassador in Beijing talks to Chinese authority on the building of Dongqing railway. Guangdong governor general Yuan Shuxun deserves punishment. | China | http://trove.nla.gov.au/newspaper/page/26802710 | 26802710 | |
23205 | 23205 | 1910-07-23 | 6 | b | A notice issued by Chinese consul general in New Zealand Huang Rongliang regarding to the return certificate required by New Zealand government on all Chinese who are leaving and will return. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802710 | 26802710 | |
23206 | 23206 | 1910-07-23 | 6 | b | Message from priest. Extracts of the New Testament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802710 | 26802710 |
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]);