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 |
---|---|---|---|---|---|---|---|---|---|
20582 | 20582 | 1909-01-23 | 16 | one page | Pedigree (family tree) of emperors of the Qing dynasty. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802044 | 26802044 | |
22375 | 22375 | 1910-02-12 | 16 | a-b | Photograph of H.I.C.M.'s ship, Haiqi (Hai-Chi) and Hairong (Hai-Yung), flagship of Chinese navy. And report on rebuilding of Chinese navy. | Tung Wah | https://trove.nla.gov.au/newspaper/page/26802508 | 26802508 | |
24267 | 24267 | 1911-02-04 | 16 | a-b | Mr Nanhai's speech on the anniversary of Confucius' birthday in Singapore | Mr Nanhai made a speech on the anniversary of Confucius birthday. A photograph of Confucius' temple. | Other... | http://trove.nla.gov.au/newspaper/page/24091637 | 24091637 |
24268 | 24268 | 1911-02-04 | 16 | b | Four chapters from the Song of Sage | Chen Huanzhang wrote the Song of Sage. He created Chuangjiaohui (Society of Promoting Education) in Yanzhou (ppp) and America. | Other... | http://trove.nla.gov.au/newspaper/page/24091637 | 24091637 |
31976 | 31976 | 1917-01-27 | 16 | a | Photograph of the new king of Austria, his wife and family. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095579 | 24095579 | |
31977 | 31977 | 1917-01-27 | 16 | a | A tour visit to the official palace in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095579 | 24095579 | |
31978 | 31978 | 1917-01-27 | 16 | a-b | The manufacturing of warship and its history. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095579 | 24095579 | |
31979 | 31979 | 1917-01-27 | 16 | b | American philanthropists are trying to organise a world peace conference and to end the World War I. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095579 | 24095579 | |
31980 | 31980 | 1917-01-27 | 16 | c | Advertisement for the Gilbey's Dry Gin, Tucker & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095579 | 24095579 | |
33014 | 33014 | 1918-02-16 | 16 | a | Advertisement for Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33015 | 33015 | 1918-02-16 | 16 | a | Advertisement for S. Jueyow & Sons, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33016 | 33016 | 1918-02-16 | 16 | a | Advertisement for Sun Suey War & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33017 | 33017 | 1918-02-16 | 16 | a | Advertisement for Fong Lee Jang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33018 | 33018 | 1918-02-16 | 16 | a | Advertisement for Thorne's Whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33019 | 33019 | 1918-02-16 | 16 | b | Advertisement for Tiy Loy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33020 | 33020 | 1918-02-16 | 16 | b | Advertisement for G. Tong, oriental herbalist, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33021 | 33021 | 1918-02-16 | 16 | b | Advertisement for Goon Lee Shing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33022 | 33022 | 1918-02-16 | 16 | c | Advertisement for War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33023 | 33023 | 1918-02-16 | 16 | c | Advertisement for On War Chong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33024 | 33024 | 1918-02-16 | 16 | c | Advertisement for Peter Dawson's Whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33025 | 33025 | 1918-02-16 | 16 | d | Advertisement for Tim Young & Co, wholesale fruit merchants and commissioning agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33026 | 33026 | 1918-02-16 | 16 | d | Advertisement for The New South Wales Chinese Merchants Society, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33027 | 33027 | 1918-02-16 | 16 | d | Advertisement for Yuen Tiy Tong Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33028 | 33028 | 1918-02-16 | 16 | d | Advertisement for Wing War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33029 | 33029 | 1918-02-16 | 16 | d | Advertisement for Chong Bing Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
33030 | 33030 | 1918-02-16 | 16 | d | Advertisement for Edward Hill & Co, Chair Maker and French Polisher, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
34146 | 34146 | 1919-02-08 | 16 | a | Advertisement for Hop Lee & Co, wholesale fruits and produce merchants, and general commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34147 | 34147 | 1919-02-08 | 16 | a | Advertisement for Tiy Lee & Co, fruit merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34148 | 34148 | 1919-02-08 | 16 | a | Advertisement for Ping On Chahn & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34149 | 34149 | 1919-02-08 | 16 | a | Advertisement for Canton Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34150 | 34150 | 1919-02-08 | 16 | a | Advertisement for Thorne's Whisky. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34151 | 34151 | 1919-02-08 | 16 | b | Advertisement for Tiy Loy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34152 | 34152 | 1919-02-08 | 16 | b | Advertisement for G. Tong, oriental herbalist, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34153 | 34153 | 1919-02-08 | 16 | b | Advertisement for Goon Lee Shing & Co, general merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34154 | 34154 | 1919-02-08 | 16 | c | Advertisement for William J. L. Liu (Liu Guangfu) and the China-Australia Steamship Company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34155 | 34155 | 1919-02-08 | 16 | c | Advertisement for Louey Way Shung, c/o Sing Lee Lung, Chinese medicine practitioner, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34156 | 34156 | 1919-02-08 | 16 | c | Advertisement for Chong Sing Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34157 | 34157 | 1919-02-08 | 16 | c | Advertisement for On War Chong & Co, storekeepers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34158 | 34158 | 1919-02-08 | 16 | c | Advertisement for Peter Dawson's whisky. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34159 | 34159 | 1919-02-08 | 16 | d | Advertisement for The New South Wales Chinese Merchants' Society, Dixon Street, Haymarket, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34160 | 34160 | 1919-02-08 | 16 | d | Advertisement for Yuen Tiy Tong Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34161 | 34161 | 1919-02-08 | 16 | d | Advertisement for Wing War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
34162 | 34162 | 1919-02-08 | 16 | d | Advertisement for War Hing Tiy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097613 | 24097613 | |
35376 | 35376 | 1920-02-21 | 16 | a | Photograph of Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098064 | 24098064 | |
35377 | 35377 | 1920-02-21 | 16 | a | Advertisement for Tillock & Co Ltd, merchants and manufacturers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098064 | 24098064 | |
35378 | 35378 | 1920-02-21 | 16 | a | Advertisement for Wing Tiy & Co, fruit merchants and commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098064 | 24098064 | |
35379 | 35379 | 1920-02-21 | 16 | a | Advertisement for Dr Williams' pink pills for pale people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098064 | 24098064 | |
35380 | 35380 | 1920-02-21 | 16 | a | Advertisement for Black & White Whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098064 | 24098064 | |
35381 | 35381 | 1920-02-21 | 16 | b | Advertisement for Mr McCorquodale, builder, contractor and decorator, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098064 | 24098064 | |
35382 | 35382 | 1920-02-21 | 16 | b | Advertisement for N. Solomon, Newtown, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098064 | 24098064 | |
35383 | 35383 | 1920-02-21 | 16 | b | Advertisement for W. Mow Sang & Co, fruit and vegetable merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098064 | 24098064 | |
36638 | 36638 | 1921-02-12 | 16 | a | Photograph of the Hundred Flower Island (bai hua zhou) in Nanchang, Jiangxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093441 | 24093441 | |
36640 | 36640 | 1921-02-12 | 16 | b | Photograph of Yantai Harbour, Shandong province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093441 | 24093441 | |
38236 | 38236 | 1922-01-28 | 16 | a | Photograph of the dancing aboriginal people in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093853 | 24093853 | |
38237 | 38237 | 1922-01-28 | 16 | b | Photograph of an airship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093853 | 24093853 | |
38238 | 38238 | 1922-01-28 | 16 | b | British colony George Town in Malaya. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093853 | 24093853 | |
39498 | 39498 | 1923-02-17 | 16 | a | Photograph of fortress in Jiangyin, of Jiangsu province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094309 | 24094309 | |
39499 | 39499 | 1923-02-17 | 16 | a | Situation changes in Tianjin, Baoding and Luoyang, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094309 | 24094309 | |
39501 | 39501 | 1923-02-17 | 16 | c | Advertisement for David Cohen & Co, 10 Spring Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094309 | 24094309 | |
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 | |
41114 | 41114 | 1924-02-09 | 16 | a-b | History of overseas Chinese (in Australia and New Zealand), a translation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100614 | 24100614 | |
41116 | 41116 | 1924-02-09 | 16 | c | Advertisement for Sargents Ltd, high-class pastrycooks and caterers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100614 | 24100614 |
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]);