This data as json, CSV (advanced)
Suggested facets: date, column, title, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22379 | 22379 | 1910-02-12 | 21 | a-b | Photograph of Queen's Wharf, Launceston, Tasmania. Brief biography of Ito Hirobumi. | Tung Wah | https://trove.nla.gov.au/newspaper/page/26802511 | 26802511 | |
22380 | 22380 | 1910-02-12 | 21 | b | Photograph of Port Adelaide, South Australia. The last days of the deposed King of Turkey. | Tung Wah | https://trove.nla.gov.au/newspaper/page/26802511 | 26802511 | |
24275 | 24275 | 1911-02-04 | 21 | a | A monument in Korea | A monument in Korea. | Other... | http://trove.nla.gov.au/newspaper/page/24091640 | 24091640 |
24276 | 24276 | 1911-02-04 | 21 | b | In memory of Jiang Chunlin | It is in memory of former Emperor's persaonal servant. A photograph of Jiang Chunlin. | Other... | http://trove.nla.gov.au/newspaper/page/24091640 | 24091640 |
25804 | 25804 | 1912-02-24 | 21 | a | Anecdote of Luo Shou Tou Zi | Luo Shou Tou Zi, a wise and influential man in Shichun, rescued people in town from a war crisis and disappeared when he was told to be promoted soon. | China | http://trove.nla.gov.au/newspaper/page/24092135 | 24092135 |
25805 | 25805 | 1912-02-24 | 21 | b | Poems | Poems of Yang Jingqing and comments on Tan Fusheng's poems. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092135 | 24092135 |
32044 | 32044 | 1917-01-27 | 21 | a | Photograph of Chen Jintao, Minister of Finance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095582 | 24095582 | |
32045 | 32045 | 1917-01-27 | 21 | a | Chronology of the December 1916 in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095582 | 24095582 | |
32046 | 32046 | 1917-01-27 | 21 | b | Photograph of the Dahan Gate in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095582 | 24095582 | |
32047 | 32047 | 1917-01-27 | 21 | c | Advertisement for A. G. Baxter & Chatfield, late of Burns, Philip & Co, Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095582 | 24095582 | |
35421 | 35421 | 1920-02-21 | 21 | a | Advertisement for Ping On Chahn & Co, 21 Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35422 | 35422 | 1920-02-21 | 21 | a | Advertisement for A. C. Baxter & Challfield, 27 Bond Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35423 | 35423 | 1920-02-21 | 21 | a | Advertisement for Messrs. Anderson & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35424 | 35424 | 1920-02-21 | 21 | a | Advertisement for Tie Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35425 | 35425 | 1920-02-21 | 21 | a | Advertisement for The Commonwealth Studio, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35426 | 35426 | 1920-02-21 | 21 | b | Advertisement for Shanghai Case, Chinese Chop Suey House, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35427 | 35427 | 1920-02-21 | 21 | b | Advertisement for Tattersall's consultations, Hobart, Tasmania. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35428 | 35428 | 1920-02-21 | 21 | b | Advertisement for Lewis & Whitty, 158 Sussex Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35429 | 35429 | 1920-02-21 | 21 | b | Advertisement for The State Assurance Co Ltd, and the Law Union and Rock Insurance Co Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35430 | 35430 | 1920-02-21 | 21 | b | Advertisement for Ophir Tea, John Barlow & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35431 | 35431 | 1920-02-21 | 21 | c | Advertisement for Sun Suey Wah & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35432 | 35432 | 1920-02-21 | 21 | c | Advertisement for Kwong Wing Chong, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35433 | 35433 | 1920-02-21 | 21 | c | Advertisement for Kwock Kee, 434 Sussex Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35434 | 35434 | 1920-02-21 | 21 | c | Advertisement for Chong Bing Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35435 | 35435 | 1920-02-21 | 21 | c | Advertisement for John Hoe, cabinet maker and furniture manufacturer, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
35436 | 35436 | 1920-02-21 | 21 | c | Advertisement for Alliance Assurance Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098067 | 24098067 | |
39523 | 39523 | 1923-02-17 | 21 | a | Photograph of a Chinese wedding in Sydney (bridegroom Luo Weixin, son of Chinese businessman in Sydney Luo Daren; bride Ye Meigui, daughter of Chinese businessman in Sydney Ye Tonggui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 | |
39524 | 39524 | 1923-02-17 | 21 | a-b | News in brief/ Political groups in Baoding and Tianjin have different opinion on the presidential election in China. Cao Kun sends telegram to President Li Yuanhong on the case of Luo Wengan. Sun Yatsen sends telegram to Zhang Shaozeng on the national parliament of 1919. Luo Wengan is released. Cao Kun is sleepless at night. Zhang Shaozeng sends envoy Zhang Shizhao to meet Sun Yatsen and Qin Chunxuan in the south for national unification. Army commander Xia Sheng writes to Guangzhou people on the political situation. Li Houji is trying to retain his power. | China | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 | |
39525 | 39525 | 1923-02-17 | 21 | c | Correction to the Guangdong News published on January 20. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 | |
39526 | 39526 | 1923-02-17 | 21 | c | Advertisement for The Eastern House (Residential Chambers), 50 Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 | |
39527 | 39527 | 1923-02-17 | 21 | c | Advertisement for Doctor Wu Yiluan, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 | |
39528 | 39528 | 1923-02-17 | 21 | d | Advertisement for Althouse & Geiger, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 | |
39529 | 39529 | 1923-02-17 | 21 | d | Advertisement for Dr Williams' Pink Pills for Pale People. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094312 | 24094312 | |
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 | |
41138 | 41138 | 1924-02-09 | 21 | a-b | Operation of the Guangzhou-Kowloon railway after the retreat of Guangdong army. | China | http://trove.nla.gov.au/newspaper/page/24100617 | 24100617 | |
41139 | 41139 | 1924-02-09 | 21 | b | Villagers in Shilong, Xiangshan county, unite themselves for self-defence. | China | 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 |
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]);