This data as json, CSV (advanced)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35354 | 35354 | 1920-02-21 | 11 | a | Photograph of Li Shuying, envoy from the south for peace talks in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098057 | 24098057 | |
35353 | 35353 | 1920-02-21 | 10 | c | Advertisement for Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098058 | 24098058 | |
35352 | 35352 | 1920-02-21 | 10 | b | Photograph of munitions factory in Hanyang, of Hubei province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098058 | 24098058 | |
35351 | 35351 | 1920-02-21 | 10 | a | Photograph of Zhang Shizhao, delegate to the peace talks in Shanghai between the south and the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098058 | 24098058 | |
35350 | 35350 | 1920-02-21 | 10 | a | Greetings by Tung Wah editor on the New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098058 | 24098058 | |
35349 | 35349 | 1920-02-21 | 8-9 | a | Photograph of Wei Zijing (Ouei Tze King), Chinese Consul-General in Melbourne. Photographs of the committee members of the Chinese Chamber of Commerce in New South Wales: Ye Bingnan (Ping Nam), Guo Shun (W. M. Gockson), Chen Zhuchen (Chee Sung), Liu Zhiting (Jack T. On), Guo Chao (Gock Chew), Ye Bingyuan (Ping Fong), Zheng Fanchang (H. Fine), Lin Dasan (Leem Bew), Zhang Maokuan (J. Young), Su Shutang (Shee Tong), Li Rufu (James Lee), Wu Shangqu (WM Hing Oong), Deng Weixi (W. Garb), Cai Rong (Choy Young), Chen Wudi (Charlie Took Lee), Wu Elou (Ung Shue Kwong), Ma Zanfen (S. Mah Hing), Li Chun (Phillip Lee Chun), Ye Tonggui (G. Y. T. Quoy), Ma Xinsi (Mar Sun Ghee), Cai Yu (Choy Yock), Chen Yin (Charlie Young), Zhan Fu (James Kwong Sing), Cai Tian (Charlie Tein), Chen Lin (Chung Lun), Tang Huiyuan (C. Tong), and Wu Zhaoquan (H. Foy). (two copies of each photograph). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098054 | 24098054 | |
35348 | 35348 | 1920-02-21 | 7 | c | Advertisement for Lea & Perrin's sauce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098051 | 24098051 | |
35347 | 35347 | 1920-02-21 | 7 | a-b | Red Cross in Xiangshan county, Guangdong, calls for donations among the Chinese communities in Australia, and its advertisement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098051 | 24098051 | |
35346 | 35346 | 1920-02-21 | 6 | c | Advertisement for Lindeman's Ltd, Queen Victoria Markets, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098052 | 24098052 | |
35345 | 35345 | 1920-02-21 | 6 | b | Photograph of Ruan Rongkai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098052 | 24098052 | |
35344 | 35344 | 1920-02-21 | 6 | a | Photograph of Peng Lichuan (Pang Lai Choon), Chinese herbalist, and chairman of the Chinese Youth Patriotic Association in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098052 | 24098052 | |
35343 | 35343 | 1920-02-21 | 2 | a | Advertisement for Eastern and Australian Steamship Co Ltd. (Liner name: St Albans). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098048 | 24098048 | |
35342 | 35342 | 1920-02-21 | 1 | a | Advertisement for the On Chong & Company, importers, exporters and shipping merchants, Sydney. (Liner names: Alexia, St George) | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098046 | 24098046 |
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]);