This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41036 | 41036 | 1924-02-09 | 3 | a | Advertisement for the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100599 | 24100599 | |
41037 | 41037 | 1924-02-09 | 3 | a | Advertisement for On Chong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100599 | 24100599 | |
41038 | 41038 | 1924-02-09 | 3 | a | Advertisement for Mick Simmons Ltd, Tobacco merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100599 | 24100599 | |
41039 | 41039 | 1924-02-09 | 3 | a | Advertisement for W. Gardiner & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100599 | 24100599 | |
41040 | 41040 | 1924-02-09 | 3 | a | Advertisement for China-Australia S. S. Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100599 | 24100599 | |
41046 | 41046 | 1924-02-09 | 4 | a | Advertisement for Ping On Chann & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100602 | 24100602 | |
41047 | 41047 | 1924-02-09 | 4 | a | Advertisement for Yuen Tiy Tong Kee, Sydney,. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100602 | 24100602 | |
41048 | 41048 | 1924-02-09 | 4 | a | Advertisement for M. Grarin & Sons Ltd, Mascot. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100602 | 24100602 | |
41049 | 41049 | 1924-02-09 | 4 | a | Advertisement for Alliance Assurance Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100602 | 24100602 | |
41050 | 41050 | 1924-02-09 | 4 | a | Advertisement for Keen & Beer, jewellers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100602 | 24100602 | |
41051 | 41051 | 1924-02-09 | 4 | a | Advertisement for Thomas Hardy & Sons, wine cellars, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100602 | 24100602 | |
41057 | 41057 | 1924-02-09 | 5 | a | Advertisement for G. Tong, oriental herbalist, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41058 | 41058 | 1924-02-09 | 5 | a | Advertisement for Peter Dawson's whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41059 | 41059 | 1924-02-09 | 5 | a | Advertisement for Lean Sun Low, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100601 | 24100601 | |
41075 | 41075 | 1924-02-09 | 6 | a | Advertisement for Mark Foy's Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41076 | 41076 | 1924-02-09 | 6 | a | Advertisement for Shanghai Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41077 | 41077 | 1924-02-09 | 6 | a | Advertisement for Brunton's flour, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41078 | 41078 | 1924-02-09 | 6 | a | Advertisement for D. S. Ford, printers & publishers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41079 | 41079 | 1924-02-09 | 6 | a | Advertisement for Lowes Baking House, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100604 | 24100604 | |
41090 | 41090 | 1924-02-09 | 10 | a | New Year's greetings from the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100608 | 24100608 | |
41096 | 41096 | 1924-02-09 | 11 | a | Photograph of the Australian ex-servicemen returned from Europe. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100607 | 24100607 | |
41099 | 41099 | 1924-02-09 | 12 | a | Photograph of the wharf in the Pearl River (Zhujiang), in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100610 | 24100610 | |
41101 | 41101 | 1924-02-09 | 13 | a | Photograph of the Shanghai Commercial Press (shang wu yin shu guan). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100609 | 24100609 | |
41109 | 41109 | 1924-02-09 | 15 | a | Scenery photograph from India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100611 | 24100611 | |
41110 | 41110 | 1924-02-09 | 15 | a | A letter from Shanghai on the investment in agriculture and forestry in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100611 | 24100611 | |
41113 | 41113 | 1924-02-09 | 16 | a | Photograph of a coal mine in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100614 | 24100614 | |
41118 | 41118 | 1924-02-09 | 18 | a | Photograph of the Lingnan University (Canton Christian College) in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100616 | 24100616 | |
41122 | 41122 | 1924-02-09 | 19 | a | Photograph of the Chinese ladies who assisted at the Chinese Festival Night, in the Sydney Town Hall, on December 15, 1923, in aid of the Royal Prince Alfred Hospital, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100615 | 24100615 | |
41128 | 41128 | 1924-02-09 | 20 | a | Photograph of Miss Ye Zuyi (Miss Quoy), one of the sopranists of the Chinese Festival Night, at the Sydney Town Hall, on December 15, 1923, in aid of Royal Prince Alfred Hospital, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100618 | 24100618 | |
41129 | 41129 | 1924-02-09 | 20 | a | News from Guangzhou on the tariff dispute. | China | http://trove.nla.gov.au/newspaper/page/24100618 | 24100618 | |
41130 | 41130 | 1924-02-09 | 20 | a | Guangdong army occupy Zengcheng county. | China | http://trove.nla.gov.au/newspaper/page/24100618 | 24100618 | |
41136 | 41136 | 1924-02-09 | 21 | a | Photograph of Liu Junchen (A. John Sing), herbal practitioner, 302 Oxford Street, Woollabra. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100617 | 24100617 | |
41137 | 41137 | 1924-02-09 | 21 | a | Police chief in Zengcheng county Huang Caibo is murdered by bandits. | China | http://trove.nla.gov.au/newspaper/page/24100617 | 24100617 | |
41142 | 41142 | 1924-02-09 | 22 | a | Advertisement for Chinese herbalist Wu Yiluan by Wu Di. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41143 | 41143 | 1924-02-09 | 22 | a | Farewell message by Xie Shenghe on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41144 | 41144 | 1924-02-09 | 22 | a | Advertisement for Chinese herbalist Wu Yiluan by Guo Tinghuang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41145 | 41145 | 1924-02-09 | 22 | a | Holiday notice by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41151 | 41151 | 1924-02-09 | 23 | a | Advertisement for Wing On & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100619 | 24100619 |
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]);