This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40200 | 40200 | 1923-08-04 | 7 | a | Message from Zhong Baoxuan, professor of the Agriculture School, Lingnan University, Guangzhou, who comes to Sydney to raise funds for the school development. Photograph of Zhong Baoxuan. Ma Yingbiao and other Chinese businessmen in Hong Kong donate to the Agriculture School of Lingnan University. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
40201 | 40201 | 1923-08-04 | 7 | a | Chinese Nanhua Football (Soccer) Team to have match with New South Wales team in Sydney. Advertisement for the match. And photograph of a Chinese football team member. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 |
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]);