This data as json, CSV (advanced)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39471 | 39471 | 1923-02-17 | 10 | b | Photograph of Liu Junchen (A. John Sing), herbal practitioner, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094303 | 24094303 | |
39478 | 39478 | 1923-02-17 | 12 | a | Photograph of Moo Yeung Gateway of the Peiking City. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094305 | 24094305 | |
39518 | 39518 | 1923-02-17 | 20 | a | Photograph of Tian Zhongyu, military governor of Shandong province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094313 | 24094313 | |
39491 | 39491 | 1923-02-17 | 14 | a | Photograph of Ye Lijiao, daughter of Sydney Chinese businessman Ye Tonggui, in the Summer Palace, Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094307 | 24094307 | |
39523 | 39523 | 1923-02-17 | 21 | a | Photograph of a Chinese wedding in Sydney (bridegroom Luo Weixin, son of Chinese businessman in Sydney Luo Daren; bride Ye Meigui, daughter of Chinese businessman in Sydney Ye Tonggui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 | |
39503 | 39503 | 1923-02-17 | 17 | b | Photograph of a river in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094308 | 24094308 | |
39510 | 39510 | 1923-02-17 | 19 | a | Photograph of a temple in India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094310 | 24094310 | |
39506 | 39506 | 1923-02-17 | 18 | a | Photograph of bird nests on the coast of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094311 | 24094311 | |
39498 | 39498 | 1923-02-17 | 16 | a | Photograph of fortress in Jiangyin, of Jiangsu province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094309 | 24094309 | |
39507 | 39507 | 1923-02-17 | 18 | b | Photograph of mountain view in the west of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094311 | 24094311 | |
39481 | 39481 | 1923-02-17 | 13 | a | Photograph of the Entrance to some of the Palaces, Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094304 | 24094304 | |
39502 | 39502 | 1923-02-17 | 17 | a | Photograph of the Yudai Bridge in Hangzhou, Zhejiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094308 | 24094308 | |
39530 | 39530 | 1923-02-17 | 22 | a | Photographs of Sun Yatsen, his first and second wives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094315 | 24094315 | |
39519 | 39519 | 1923-02-17 | 20 | b | Poems by He Chengfang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094313 | 24094313 | |
39512 | 39512 | 1923-02-17 | 19 | a | Police forces in the six states of Australia (number, salary payment and others). | Australia | http://trove.nla.gov.au/newspaper/page/24094310 | 24094310 | |
39511 | 39511 | 1923-02-17 | 19 | a | Population in the six states of Australia by 1921. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094310 | 24094310 | |
39484 | 39484 | 1923-02-17 | 13 | b | Population in the state of New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24094304 | 24094304 | |
39508 | 39508 | 1923-02-17 | 18 | b | Preparation for the Far East Sports Games that to be held in Osaka, Japan. | Other... | http://trove.nla.gov.au/newspaper/page/24094311 | 24094311 | |
39494 | 39494 | 1923-02-17 | 15 | a-b | Russian refugees in Beijing and their sufferings. | China | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39499 | 39499 | 1923-02-17 | 16 | a | Situation changes in Tianjin, Baoding and Luoyang, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094309 | 24094309 | |
39488 | 39488 | 1923-02-17 | 14 | a | Statistics on China's national debt prepared by the Treasury in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094307 | 24094307 | |
39413 | 39413 | 1923-02-17 | Suppl'ment | One page | The 1923 Chinese and English Almanac, supplement to the Tung Wah Times Chinese New Year edition, | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094292 | 24094292 | |
39500 | 39500 | 1923-02-17 | 16-17 | b | Tri-alliance of Sun Yatsen, Duan Qirui and Zhang Zuolin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094309 | 24094309 | |
39532 | 39532 | 1923-02-17 | 22 | b | Tung Wah Times increases its subscription fee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094315 | 24094315 | |
39514 | 39514 | 1923-02-17 | 19 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094310 | 24094310 | |
39520 | 39520 | 1923-02-17 | 20 | b | Tung Wah Times will not be available on Chinese New Year's holiday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094313 | 24094313 |
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]);