This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39163 | 39163 | 1922-12-23 | 2 | a-b | Bandits occupy Qingdao and the comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094228 | 24094228 | |
39167 | 39167 | 1922-12-23 | 2 | d-e | The establishment of the Permanent Court of International Justice. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094228 | 24094228 | |
39178 | 39178 | 1922-12-23 | 3 | e | China-Australia Steamship Company Ltd moves its office to Foreman House, 226a George Street, Sydney. And a notice for shareholders meeting. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094227 | 24094227 | |
39179 | 39179 | 1922-12-23 | 6 | a | Yu Wenhou on road construction in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094232 | 24094232 | |
39180 | 39180 | 1922-12-23 | 6 | b | News from Samoa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094232 | 24094232 | |
39183 | 39183 | 1922-12-23 | 7 | a | Prime Minister Billy Hughes sues Sydney Daily Mail for defamation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39185 | 39185 | 1922-12-23 | 7 | a | A shoe factory in Redfern, Sydney, is on fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39186 | 39186 | 1922-12-23 | 7 | a | Former secretary of the Sydney zhi gong tang Yang Du is sentenced to two years' imprisonment for embezzlement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39189 | 39189 | 1922-12-23 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39190 | 39190 | 1922-12-23 | 8 | a | Poems by Shouzhen and Miusheng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094234 | 24094234 | |
39191 | 39191 | 1922-12-23 | 8 | a-c | Guangdong news/ Provincial governor offers assistance to the Fujian border. Zang Zhiping on the Guangdong army. The war in Yanping. Guangdong businessmen oppose to the increase of postal service charges. President Li Yuanhong sends researcher to investigate his family tree in the south. Xiangshan businessmen Ma Yongcan, Guo Quan, Ma Yingbiao, Cai Xing, Zheng Gansheng, Wang Guoxuan and others to build a hospital in the home county which is supported by the magistrate. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094234 | 24094234 | |
39192 | 39192 | 1922-12-23 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094234 | 24094234 | |
39193 | 39193 | 1922-12-23 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094234 | 24094234 |
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]);