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 |
---|---|---|---|---|---|---|---|---|---|
20580 | 20580 | 1909-01-23 | 15 | a | Chinese people use mercury to determine weather temperature. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802041 | 26802041 | |
20581 | 20581 | 1909-01-23 | 15 | b | Customs and habits in Tibet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802041 | 26802041 | |
22374 | 22374 | 1910-02-12 | 15 | a-b | Photograph of Admiral Sa Zhenbing (Sa Chen Ping), Head of the newly-created Admiralty Board, and report on his background. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802505 | 26802505 | |
24264 | 24264 | 1911-02-04 | 15 | a-b | The spirit of self-discipline of the Britain and German | The spirit of self-discipline of the Britain and German. | Other... | http://trove.nla.gov.au/newspaper/page/24091634 | 24091634 |
24265 | 24265 | 1911-02-04 | 15 | a | Photograph of Lu Junyi | A photograph of Mr Lu Junyi, who is in charge of teaching at Sydney Chinese Mengyang School. | Australia | http://trove.nla.gov.au/newspaper/page/24091634 | 24091634 |
24266 | 24266 | 1911-02-04 | 15 | b | A commentary on current affairs | A commentary on Japan and Eygpt. | Other... | http://trove.nla.gov.au/newspaper/page/24091634 | 24091634 |
25791 | 25791 | 1912-02-24 | 15 | a | Adieus in Greece | Adieus in Greece is another beautiful historical relic in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092129 | 24092129 |
25792 | 25792 | 1912-02-24 | 15 | a | Price for marrying ugly woman | A wealthy German man set up a price funding for those marrying ugly women and disabled women. | Other... | http://trove.nla.gov.au/newspaper/page/24092129 | 24092129 |
31972 | 31972 | 1917-01-27 | 15 | a | Photographs of Ren Kecheng, governor of Yunnan province, and Liu Cunhou, military commander in Sichuan province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095576 | 24095576 | |
31973 | 31973 | 1917-01-27 | 15 | a | Chinese businessman Luo Yukai in Java invents astronomical instrument. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095576 | 24095576 | |
31974 | 31974 | 1917-01-27 | 15 | a-b | A survey on the railway achievements in China and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095576 | 24095576 | |
31975 | 31975 | 1917-01-27 | 15 | c | Advertisement for Mick Simmons Ltd, the leading tobacco warehouse in the Commonwealth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095576 | 24095576 | |
32997 | 32997 | 1918-02-16 | 15 | a | Advertisement for Lee Sang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
32998 | 32998 | 1918-02-16 | 15 | a | Advertisement for Gee Ick & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
32999 | 32999 | 1918-02-16 | 15 | a | Advertisement for On War Tai & Co, 146-148 Wickham Street, Valley, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33000 | 33000 | 1918-02-16 | 15 | a | Advertisement for See War & Co, merchants, 225-227 Brunswick Street, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33001 | 33001 | 1918-02-16 | 15 | a | Advertisement for A. G. Baxter & Chatfield, Late of Burns Philip & Co, Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33002 | 33002 | 1918-02-16 | 15 | b | Advertisement for Dockson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33003 | 33003 | 1918-02-16 | 15 | b | Advertisement for Lum See Jan, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33004 | 33004 | 1918-02-16 | 15 | b | Advertisement for Sam War, 319 Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33005 | 33005 | 1918-02-16 | 15 | b | Advertisement for S. Hoffnung & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33006 | 33006 | 1918-02-16 | 15 | c | Advertisement for Wing On & Co, fruit merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33007 | 33007 | 1918-02-16 | 15 | c | Advertisement for Kwong War Chong & Co, storekeepers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33008 | 33008 | 1918-02-16 | 15 | c | Advertisement for The Commonwealth Studio, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33009 | 33009 | 1918-02-16 | 15 | c | Advertisement for Sun Fong, Chinese expert for venereal diseases in Emmaville, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33010 | 33010 | 1918-02-16 | 15 | c | Advertisement for W. Schofield & Co, builders and contractors, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33011 | 33011 | 1918-02-16 | 15 | d | Advertisement for Kwong Wing Chong, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33012 | 33012 | 1918-02-16 | 15 | d | Advertisement for King Young, general merchants and commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
33013 | 33013 | 1918-02-16 | 15 | d | Advertisement for Alliance Assurance Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
34128 | 34128 | 1919-02-08 | 15 | a | Advertisement for Lee Sang & Co, produce merchants, importers and exporters, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34129 | 34129 | 1919-02-08 | 15 | a | Advertisement for Gee Ick & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34130 | 34130 | 1919-02-08 | 15 | a | Advertisement for See War & Co, merchants, Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34131 | 34131 | 1919-02-08 | 15 | a | Advertisement for Kwong War Chong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34132 | 34132 | 1919-02-08 | 15 | a | Advertisement for Holdsworth MacPherson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34133 | 34133 | 1919-02-08 | 15 | b | Advertisement for Dockson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34134 | 34134 | 1919-02-08 | 15 | b | Advertisement for Lum See Jan, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34135 | 34135 | 1919-02-08 | 15 | b | Advertisement for Sam War, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34136 | 34136 | 1919-02-08 | 15 | b | Advertisement for S. Hoffnung & Co Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34137 | 34137 | 1919-02-08 | 15 | c | Advertisement for Wing On & Co, fruit merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34138 | 34138 | 1919-02-08 | 15 | c | Advertisement for Sun Suey Wah & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34139 | 34139 | 1919-02-08 | 15 | c | Advertisement for Fong Lee Jang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34140 | 34140 | 1919-02-08 | 15 | c | Advertisement for War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34141 | 34141 | 1919-02-08 | 15 | c | Advertisement for Clements Tonic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34142 | 34142 | 1919-02-08 | 15 | d | Advertisement for Kwock Kea, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34143 | 34143 | 1919-02-08 | 15 | d | Advertisement for Kwong Wing Chong, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34144 | 34144 | 1919-02-08 | 15 | d | Advertisement for King Young, general merchant, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
34145 | 34145 | 1919-02-08 | 15 | d | Advertisement for Alliance Assurance Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097610 | 24097610 | |
35371 | 35371 | 1920-02-21 | 15 | a | Photograph of Xu Fosu, envoy from the north for peace talks in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098061 | 24098061 | |
35372 | 35372 | 1920-02-21 | 15 | a | An article written by Guo Jianying expresses his wishes on the occasion of New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098061 | 24098061 | |
35373 | 35373 | 1920-02-21 | 15 | b | Advertisement for The Co-operative Assurance Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098061 | 24098061 | |
35374 | 35374 | 1920-02-21 | 15 | b | Advertisement for Nicola Truda & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098061 | 24098061 | |
35375 | 35375 | 1920-02-21 | 15 | c | Advertisement for David Cohen & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098061 | 24098061 | |
36634 | 36634 | 1921-02-12 | 15 | a | Photograph of the Flowery Bridge in Guilin, Guangxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093438 | 24093438 | |
36635 | 36635 | 1921-02-12 | 15 | a | Japanese newspaper reports that transportation in Europe is almost at a standstill after the War. | Japan | http://trove.nla.gov.au/newspaper/page/24093438 | 24093438 | |
36636 | 36636 | 1921-02-12 | 15 | b | An automatic telegraph machine for the pilot. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093438 | 24093438 | |
36637 | 36637 | 1921-02-12 | 15 | b | France has more women. | France | http://trove.nla.gov.au/newspaper/page/24093438 | 24093438 | |
38234 | 38234 | 1922-01-28 | 15 | a-b | Communism in Russia and its consequence (Lenin government, conference of the Soviet Communist Party). | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093850 | 24093850 | |
39492 | 39492 | 1923-02-17 | 15 | a | Photograph of Beijing Hotel. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39493 | 39493 | 1923-02-17 | 15 | a | Overseas Chinese communities request disarmament in China. | China | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39494 | 39494 | 1923-02-17 | 15 | a-b | Russian refugees in Beijing and their sufferings. | China | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39495 | 39495 | 1923-02-17 | 15 | b | How foreign powers intervene with China's internal affairs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39496 | 39496 | 1923-02-17 | 15 | b | Conditions of the peace talks between Zhang Zuolin and Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39497 | 39497 | 1923-02-17 | 15 | c | Advertisement for Black & White Whisky. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
41109 | 41109 | 1924-02-09 | 15 | a | Scenery photograph from India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100611 | 24100611 | |
41110 | 41110 | 1924-02-09 | 15 | a | A letter from Shanghai on the investment in agriculture and forestry in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100611 | 24100611 | |
41111 | 41111 | 1924-02-09 | 15 | b | Chinese Chamber of Commerce in Dutch colony organises an exhibition of China products. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100611 | 24100611 | |
41112 | 41112 | 1924-02-09 | 15 | c | Advertisement for Lea & Perrin's sauce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100611 | 24100611 |
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]);