This data as json, CSV (advanced)
Suggested facets: column, source, 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 | |
40202 | 40202 | 1923-08-04 | 7 | b | Chinese Nanhua (South China) Football Team arrives Townsville, Queensland, and their telegram to the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
40203 | 40203 | 1923-08-04 | 7 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
40204 | 40204 | 1923-08-04 | 7 | c | Chinese Nanhua (South China) Football (Soccer) Team comes to visit Australian by Japanese liner and the explanation of the travel. They will have matches with Australian teams in Sydney, New Castle, Wollongong, and Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
40205 | 40205 | 1923-08-04 | 7 | c | Flood in Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24094499 | 24094499 | |
40206 | 40206 | 1923-08-04 | 7 | c | German economy in crisis. | Britain | 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]);