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 |
---|---|---|---|---|---|---|---|---|---|
20583 | 20583 | 1909-01-23 | 17 | a-b | Key problems facing an alliance between China and America, translated from New York Times. | America | http://trove.nla.gov.au/newspaper/page/26802043 | 26802043 | |
20584 | 20584 | 1909-01-23 | 17 | a | Photograph of wool for auction in a Sydney market. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802043 | 26802043 | |
22376 | 22376 | 1910-02-12 | 17 | a-b | Photograph of H.I.C.M.'s cruiser Nan-Seng and torpedo gunboat Kien-Guan. Report on Chinese naval equipment. | Tung Wah | https://trove.nla.gov.au/newspaper/page/26802507 | 26802507 | |
24269 | 24269 | 1911-02-04 | 17 | a-b | Parliament petition representatives appealed to Regent | Parliament petition representatives appealed to Regent for saving China from poverty and risk of foreign invasion. These representatives include Sun Hongyi, Li Changsheng, Qiao Zhaner, Wen Yao, Yao Wenxu, Shen Maozhao, Yu Dehang, Lu Naixiang, Wu Xianzi, Tang Juetun etc. | Other... | http://trove.nla.gov.au/newspaper/page/24091636 | 24091636 |
25793 | 25793 | 1912-02-24 | 17 | a-b | Record of Russia's expanding its navy | Russia realises that its navy is more backward than other big powers and decides to strengthen it. | Other... | http://trove.nla.gov.au/newspaper/page/24092131 | 24092131 |
25820 | 25820 | 1912-02-24 | 17 | a | Photo of deputy chief of Chinese navy | Photo of Chen Biguang, deputy chief of Chinese navy. | Other... | http://trove.nla.gov.au/newspaper/page/24092131 | 24092131 |
31981 | 31981 | 1917-01-27 | 17 | a | Advertisement for the Wing On & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31982 | 31982 | 1917-01-27 | 17 | a | Advertisement for the Lee Sang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31983 | 31983 | 1917-01-27 | 17 | a | Advertisement for Tim Young & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31984 | 31984 | 1917-01-27 | 17 | a | Advertisement for the Press Brothers, Sydney/ | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31985 | 31985 | 1917-01-27 | 17 | b | Advertisement for the New South Wales Chinese Chamber of Commerce, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31986 | 31986 | 1917-01-27 | 17 | b | Advertisement for the King Young, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31987 | 31987 | 1917-01-27 | 17 | a | Advertisement for Dr Williams pink pills for pale people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31988 | 31988 | 1917-01-27 | 17 | c | Advertisement for Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31989 | 31989 | 1917-01-27 | 17 | c | Advertisement for Kwock Kea, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31990 | 31990 | 1917-01-27 | 17 | c | Advertisement for Mrs Sun, Tramway Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31991 | 31991 | 1917-01-27 | 17 | c | Advertisement for Sam War Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31992 | 31992 | 1917-01-27 | 17 | c | Advertisement for Dr Tan Liangnan, Chinese herbalist, by Li Xiantao, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31993 | 31993 | 1917-01-27 | 17 | d | Advertisement for See Jan Park Kee, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31994 | 31994 | 1917-01-27 | 17 | d | Advertisement for The International Rubber Stamp Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31995 | 31995 | 1917-01-27 | 17 | d | Advertisement for J. Cragg & Son, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
31996 | 31996 | 1917-01-27 | 17 | d | Advertisement for John Watson, 373 George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095578 | 24095578 | |
33031 | 33031 | 1918-02-16 | 17 | a | Advertisement for War Lee & Co Ltd, fruit and produce merchants, auctioneers and commissioning agents, Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33032 | 33032 | 1918-02-16 | 17 | a | Advertisement for Dr Williams' Pink Pills for Pale People, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33033 | 33033 | 1918-02-16 | 17 | a | Advertisement for H. L. Bussell & Co, Ltd, White Wings Mill, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33034 | 33034 | 1918-02-16 | 17 | a | Advertisement for Tattersall's Consultations, Hobart, Tasmania. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33035 | 33035 | 1918-02-16 | 17 | a | Advertisement for Guardian Assurance Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33036 | 33036 | 1918-02-16 | 17 | a | Advertisement for the Government Savings Bank of New South Wales, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33037 | 33037 | 1918-02-16 | 17 | b | Advertisement for H. Sleeman, watchmaker, jeweller, optician and silverware specialist, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33038 | 33038 | 1918-02-16 | 17 | c | Advertisement for Newman's Baking Powder, Waterloo, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33039 | 33039 | 1918-02-16 | 17 | c | Advertisement for Yow Sang & Co, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33040 | 33040 | 1918-02-16 | 17 | c | Advertisement for Ping On Chahn & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33041 | 33041 | 1918-02-16 | 17 | c | Advertisement for Shanghai Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33042 | 33042 | 1918-02-16 | 17 | d | Advertisement for "Biff" Relieves Sore, Tired Feet, The Biff Manufacturing Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33043 | 33043 | 1918-02-16 | 17 | d | Advertisement for Rowan's Bond, Pitt Street, Circular Quay, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
33044 | 33044 | 1918-02-16 | 17 | d | Advertisement for W. Kerr, watchmaker & jeweller, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
34163 | 34163 | 1919-02-08 | 17 | a | Advertisement for War Lee & Co Ltd, fruit and produce merchants, auctioneers and commission agents, Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34164 | 34164 | 1919-02-08 | 17 | a | Advertisement for Harry Walters, Prince of Wales Hotel, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34165 | 34165 | 1919-02-08 | 17 | a | Advertisement for the Government Savings Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34166 | 34166 | 1919-02-08 | 17 | aa | Advertisement for Tattersall's Consultations, George Adams, Hobart, Tasmania. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34167 | 34167 | 1919-02-08 | 17 | a | Advertisement for Lewis & Whitty, 158 Sussex Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34168 | 34168 | 1919-02-08 | 17 | b | Advertisement for the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34169 | 34169 | 1919-02-08 | 17 | b | Advertisement for Yow Sang & Co, Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34170 | 34170 | 1919-02-08 | 17 | b | Advertisement for Chinese herbalist Zhong Dewan, a native of Xinhui in Sydney, by Guan Xiquan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34171 | 34171 | 1919-02-08 | 17 | b | Advertisement for Shanghai Cafe, Chinese chop suey house, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34172 | 34172 | 1919-02-08 | 17 | b | Advertisement for Rowan's Bond, York Street North, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34173 | 34173 | 1919-02-08 | 17 | b | Advertisement for W. Kerr, watchmaker & jeweller, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
34174 | 34174 | 1919-02-08 | 17 | c | Advertisement for The Biff Manufacturing Co. Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097612 | 24097612 | |
35384 | 35384 | 1920-02-21 | 17 | a | Advertisement for Simpson's, 410 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098063 | 24098063 | |
35385 | 35385 | 1920-02-21 | 17 | a | Advertisement for Anthony Hordern & Sons Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098063 | 24098063 | |
35386 | 35386 | 1920-02-21 | 17 | a | Advertisement for Rexoma, the rapid healer, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098063 | 24098063 | |
35387 | 35387 | 1920-02-21 | 17 | b | A holiday notice from the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098063 | 24098063 | |
35388 | 35388 | 1920-02-21 | 17 | b | Advertisement for Tientsin Cafe, 70 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098063 | 24098063 | |
35389 | 35389 | 1920-02-21 | 17 | c | Advertisement for Joe Gardener boots, George & Barlow Sts, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098063 | 24098063 | |
36641 | 36641 | 1921-02-12 | 17 | a | Photograph of the Niang Zi Guan in Pingding county, Shanxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093440 | 24093440 | |
36642 | 36642 | 1921-02-12 | 17 | b | American shipyards are building ships for various purposes. | America | http://trove.nla.gov.au/newspaper/page/24093440 | 24093440 | |
38239 | 38239 | 1922-01-28 | 17 | a | Photograph of Princess Mary who is engaged with the 6th Earl of Harewood. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093852 | 24093852 | |
38240 | 38240 | 1922-01-28 | 17 | a | Chinese school in Java. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093852 | 24093852 | |
38241 | 38241 | 1922-01-28 | 17 | a-b | Hunting in Papua. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093852 | 24093852 | |
38242 | 38242 | 1922-01-28 | 17 | b | Suva in the past and at present. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093852 | 24093852 | |
39502 | 39502 | 1923-02-17 | 17 | a | Photograph of the Yudai Bridge in Hangzhou, Zhejiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094308 | 24094308 | |
39503 | 39503 | 1923-02-17 | 17 | b | Photograph of a river in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094308 | 24094308 | |
39505 | 39505 | 1923-02-17 | 17 | c | Advertisement for D. S. Ford, printers and publishers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094308 | 24094308 | |
41117 | 41117 | 1924-02-09 | 17 | c | Advertisement for Bert Jacobson, tailor, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100613 | 24100613 |
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]);