This data as json, CSV (advanced)
Link | rowid | date | page | column | title | description | source ▼ | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41121 | 41121 | 1924-02-09 | 18 | c | Advertisement for John Bull & Co Ltd, Sydney. | 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 | |
41127 | 41127 | 1924-02-09 | 19 | b | Advertisement for Wing Tiy & Co, 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 | |
41135 | 41135 | 1924-02-09 | 20 | c | Advertisement for Mr Alexander, inspector of the Commonwealth General Insurance, Sydney. | Tung Wah | 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 | |
41140 | 41140 | 1924-02-09 | 21 | b | Land tax to be collected in Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100617 | 24100617 | |
41141 | 41141 | 1924-02-09 | 21 | c | Advertisement for Broomfield Ltd, Sydney. | Tung Wah | 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 | |
41146 | 41146 | 1924-02-09 | 22 | b | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41147 | 41147 | 1924-02-09 | 22 | b | Advertisement for The Ford Service Company, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41148 | 41148 | 1924-02-09 | 22 | c | Advertisement for Pinkettes, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41149 | 41149 | 1924-02-09 | 22 | c | Advertisement for L. & P. sauce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100620 | 24100620 | |
41150 | 41150 | 1924-02-09 | 22 | d | Advertisement for Hop Lee & Co, Sydney. | 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 | |
41152 | 41152 | 1924-02-09 | 23 | b | Advertisement for Arnott's biscuits, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100619 | 24100619 | |
41153 | 41153 | 1924-02-09 | 24 | One page | Advertisement for Australian Oriental Line, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100621 | 24100621 | |
41154 | 41154 | 1924-02-09 | suppl'ment | One page | Chinese and English almanac, supplement to the Tung Wah Times on the Chinese New Year number, 9th February 1924. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100702 | 24100702 |
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]);