This data as json, CSV (advanced)
Link | rowid | date | page | column | title | description | source | page_url ▼ | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
41131 | 41131 | 1924-02-09 | 20 | b | Yunnan army station in Baiyun Mountain. | China | http://trove.nla.gov.au/newspaper/page/24100618 | 24100618 | |
41132 | 41132 | 1924-02-09 | 20 | b | Chen Jiongming supports national unification. | China | http://trove.nla.gov.au/newspaper/page/24100618 | 24100618 | |
41133 | 41133 | 1924-02-09 | 20 | b | Yu Shiying opposes to the sale of public property in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100618 | 24100618 | |
41134 | 41134 | 1924-02-09 | 20 | b | Treasury department in Guangzhou seals up temples in order to collect more tax. | China | 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 | |
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 | |
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 | |
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]);