This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31931 | 31931 | 1917-01-27 | 5 | c | Advertisement for The Employers' Liability Assurance Corporation Ltd, of London. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095566 | 24095566 | |
31932 | 31932 | 1917-01-27 | 5 | c | Advertisement for James Stedman Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095566 | 24095566 | |
31933 | 31933 | 1917-01-27 | 5 | c | Advertisement for Gibbs Bright & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095566 | 24095566 | |
31934 | 31934 | 1917-01-27 | 5 | c | Advertisement for Korean ginseng available from Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095566 | 24095566 | |
31940 | 31940 | 1917-01-27 | 6 | c | Advertisement for Adet Curcier & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095569 | 24095569 | |
31943 | 31943 | 1917-01-27 | 7 | c | Advertisement for Lindeman's Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095568 | 24095568 | |
31956 | 31956 | 1917-01-27 | 10 | c | Advertisement for Holdsworth MacPherson & Co, 252 George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095573 | 24095573 | |
31957 | 31957 | 1917-01-27 | 11 | c | Advertisement for Arnott's Biscuits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095572 | 24095572 | |
31961 | 31961 | 1917-01-27 | 12 | c | Advertisement for Brunton's flour, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095575 | 24095575 | |
31962 | 31962 | 1917-01-27 | 12 | c | Advertisement for Anderson & Co Ltd, seedsmen in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095575 | 24095575 | |
31965 | 31965 | 1917-01-27 | 13 | c | Photograph of the World Peace Conference building in Hague, Holland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095574 | 24095574 | |
31971 | 31971 | 1917-01-27 | 14 | c | Advertisement for David Cohen & Co Ltd, 10 Spring Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095577 | 24095577 | |
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 | |
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 | |
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 | |
32007 | 32007 | 1917-01-27 | 18 | c | Advertisement for The New South Wales Chinese Merchants' Society, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095581 | 24095581 | |
32008 | 32008 | 1917-01-27 | 18 | c | Advertisement for Gee Ick & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095581 | 24095581 | |
32009 | 32009 | 1917-01-27 | 18 | c | Advertisement for On War Tai & Co, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095581 | 24095581 | |
32010 | 32010 | 1917-01-27 | 18 | c | Advertisement for See War & Co, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095581 | 24095581 | |
32011 | 32011 | 1917-01-27 | 18 | c | Advertisement for Hook Yick & Co, Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095581 | 24095581 | |
32026 | 32026 | 1917-01-27 | 19 | c | Advertisement for Rowan's Bond, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32027 | 32027 | 1917-01-27 | 19 | c | Advertisement for War Hing Tiy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32028 | 32028 | 1917-01-27 | 19 | c | Advertisement for Chong Wah Jang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095580 | 24095580 | |
32041 | 32041 | 1917-01-27 | 20 | c | Advertisement for W. Mow Sang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095583 | 24095583 | |
32042 | 32042 | 1917-01-27 | 20 | c | Advertisement for John Hoe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095583 | 24095583 | |
32043 | 32043 | 1917-01-27 | 20 | c | Advertisement for Undeman Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095583 | 24095583 | |
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 | |
32053 | 32053 | 1917-01-27 | 23 | c | Advertisement for Lee Sang & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095584 | 24095584 |
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]);