This data as json, CSV (advanced)
Suggested facets: date, column, title, 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 | |
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 | |
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 | |
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]);