This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39416 | 39416 | 1923-02-17 | 3 | a | Advertisement for the China-Australia Steamship Mail Line Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094294 | 24094294 | |
39417 | 39417 | 1923-02-17 | 3 | a | Advertisement for Arnott's Biscuits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094294 | 24094294 | |
39418 | 39418 | 1923-02-17 | 3 | a | Advertisement for Win On & Co, importers & exporters, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094294 | 24094294 | |
39425 | 39425 | 1923-02-17 | 4 | a | Advertisement for War Loong & Co, produce merchants, 98 Hay Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39426 | 39426 | 1923-02-17 | 4 | a | Advertisement for Goon Lee Shing & Co, general merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39427 | 39427 | 1923-02-17 | 4 | a | Advertisement for Doctor Sue Fong in Emmaville, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39428 | 39428 | 1923-02-17 | 4 | a | Advertisement for War Hing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39429 | 39429 | 1923-02-17 | 4 | a | Advertisement for L. & P. Sauce, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39440 | 39440 | 1923-02-17 | 5 | a | Advertisement for Lee Sang & Co, produce merchants, importers & exporters, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39441 | 39441 | 1923-02-17 | 5 | a | Advertisement for Sun Tuey Wah Chockson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39442 | 39442 | 1923-02-17 | 5 | a | Advertisement for Doctor Chen Weiting in Tamworth, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39443 | 39443 | 1923-02-17 | 5 | a | Advertisement for Ping On Chann & Co, 21 Dixon Street and 46 Harbour Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39444 | 39444 | 1923-02-17 | 5 | a | Advertisement for Alliance Assurance Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39456 | 39456 | 1923-02-17 | 6 | a | Advertisement for the Chinese Chamber of Commerce, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094299 | 24094299 | |
39457 | 39457 | 1923-02-17 | 6 | a | Advertisement for The Wing Sang Co Ltd, fruit merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094299 | 24094299 | |
39458 | 39458 | 1923-02-17 | 6 | a | Advertisement for Mick Simmons Ltd, tobacco merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094299 | 24094299 | |
39459 | 39459 | 1923-02-17 | 6 | a | Advertisement for Mark Foy's Ltd, the piazza, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094299 | 24094299 | |
39468 | 39468 | 1923-02-17 | 10 | a | Advertisement for Doctor Chen Weiting (by Wu Elou). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094303 | 24094303 | |
39469 | 39469 | 1923-02-17 | 10 | a | Advertisement for Moreez, metal polish, Australasian distributors, Hean's Essence Property, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094303 | 24094303 | |
39470 | 39470 | 1923-02-17 | 10 | a | Advertisement for On Sang & Co, Eastern Merchants, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094303 | 24094303 | |
39478 | 39478 | 1923-02-17 | 12 | a | Photograph of Moo Yeung Gateway of the Peiking City. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094305 | 24094305 | |
39481 | 39481 | 1923-02-17 | 13 | a | Photograph of the Entrance to some of the Palaces, Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094304 | 24094304 | |
39488 | 39488 | 1923-02-17 | 14 | a | Statistics on China's national debt prepared by the Treasury in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24094307 | 24094307 | |
39489 | 39489 | 1923-02-17 | 14 | a | Cao Rulin and Lu Zongyu and the foreign loans to China. | China | http://trove.nla.gov.au/newspaper/page/24094307 | 24094307 | |
39491 | 39491 | 1923-02-17 | 14 | a | Photograph of Ye Lijiao, daughter of Sydney Chinese businessman Ye Tonggui, in the Summer Palace, Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094307 | 24094307 | |
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 | |
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 | |
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 | |
39506 | 39506 | 1923-02-17 | 18 | a | Photograph of bird nests on the coast of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094311 | 24094311 | |
39510 | 39510 | 1923-02-17 | 19 | a | Photograph of a temple in India. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094310 | 24094310 | |
39511 | 39511 | 1923-02-17 | 19 | a | Population in the six states of Australia by 1921. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094310 | 24094310 | |
39512 | 39512 | 1923-02-17 | 19 | a | Police forces in the six states of Australia (number, salary payment and others). | Australia | http://trove.nla.gov.au/newspaper/page/24094310 | 24094310 | |
39518 | 39518 | 1923-02-17 | 20 | a | Photograph of Tian Zhongyu, military governor of Shandong province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094313 | 24094313 | |
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 | |
39530 | 39530 | 1923-02-17 | 22 | a | Photographs of Sun Yatsen, his first and second wives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094315 | 24094315 | |
39531 | 39531 | 1923-02-17 | 22 | a | History of military conflict in Guangdong in the past few years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094315 | 24094315 | |
39536 | 39536 | 1923-02-17 | 23 | a | Advertisement for Mort's Dock and Engineering Company Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094314 | 24094314 |
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]);