This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40465 | 40465 | 1923-09-29 | 6 | a | Message of thanks by Zhong Baoxuan, representative of the Lingnan University who is trying to raise funds in Australia for the agriculture school of the university. Chinese community in Queensland donates to the Lingnan University and the names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094564 | 24094564 | |
40466 | 40466 | 1923-09-29 | 6 | a-b | The end of Guangdong people, an article published in a Java newspaper (on Sun Yatsen and the support in the Nanyang Chinese communities). | Other... | http://trove.nla.gov.au/newspaper/page/24094564 | 24094564 | |
40467 | 40467 | 1923-09-29 | 6 | b-c | The sale of public property in Guangdong, an article published in the World News (shi jie ri bao) in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24094564 | 24094564 | |
40468 | 40468 | 1923-09-29 | 6 | c | A prophet in India talks about the future. | Other... | http://trove.nla.gov.au/newspaper/page/24094564 | 24094564 | |
40469 | 40469 | 1923-09-29 | 6 | c-d | Unique skills of a snake player in Hanyang, Hubei province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094564 | 24094564 | |
40470 | 40470 | 1923-09-29 | 6 | d | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094564 | 24094564 |
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]);