This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39421 | 39421 | 1923-02-17 | 3 | c | Advertisement for The State Assurance Company Ltd and the Law Union and Rock Insurance Co Ltd., Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094294 | 24094294 | |
39422 | 39422 | 1923-02-17 | 3 | c | Advertisement for Brunton's Flour. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094294 | 24094294 | |
39423 | 39423 | 1923-02-17 | 3 | c | Advertisement for Messrs-Anderson & Co Ltd, seedsmen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094294 | 24094294 | |
39433 | 39433 | 1923-02-17 | 4 | c | Advertisement for Ophir Tea, John Barlow Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39434 | 39434 | 1923-02-17 | 4 | c | Advertisement for Hong Kong Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39435 | 39435 | 1923-02-17 | 4 | c | Advertisement for The Southern Cross Assurance Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39436 | 39436 | 1923-02-17 | 4 | c | Advertisement for G. Tong, oriental herbalist, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39449 | 39449 | 1923-02-17 | 5 | c | Advertisement for Lean Sun Low, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39450 | 39450 | 1923-02-17 | 5 | c | Advertisement for Holdsworth, McPherson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39451 | 39451 | 1923-02-17 | 5 | c | Advertisement for Wing Tiy & Co, fruit merchants & commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39452 | 39452 | 1923-02-17 | 5 | c | Advertisement for Thomas Hardy & Sons, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39466 | 39466 | 1923-02-17 | 6 | c | Advertisement for Ford, Adams & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094299 | 24094299 | |
39467 | 39467 | 1923-02-17 | 6 | c | Advertisement for Gibbs Bright & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094299 | 24094299 | |
39473 | 39473 | 1923-02-17 | 10 | c | Advertisement for Fry's Pure Breakfast Cocoa, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094303 | 24094303 | |
39474 | 39474 | 1923-02-17 | 10 | c | Advertisement for Dockson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094303 | 24094303 | |
39475 | 39475 | 1923-02-17 | 10 | c | Advertisement for Doctor Tan Liangnan, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094303 | 24094303 | |
39477 | 39477 | 1923-02-17 | 11 | c | Advertisement for Mick Simmons Ltd, the leading tobacco warehouse in the Commonwealth, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094302 | 24094302 | |
39480 | 39480 | 1923-02-17 | 12 | c | Advertisement for the Bank of New South Wales, George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094305 | 24094305 | |
39486 | 39486 | 1923-02-17 | 13 | c | Advertisement for Brunton's Flour, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094304 | 24094304 | |
39487 | 39487 | 1923-02-17 | 13 | c | Advertisement for Anderson & Co Ltd, Seedsmen, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094304 | 24094304 | |
39490 | 39490 | 1923-02-17 | 14 | c | Advertisement for Lindeman's Ltd, Queen Victoria Market, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094307 | 24094307 | |
39497 | 39497 | 1923-02-17 | 15 | c | Advertisement for Black & White Whisky. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094306 | 24094306 | |
39501 | 39501 | 1923-02-17 | 16 | c | Advertisement for David Cohen & Co, 10 Spring Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094309 | 24094309 | |
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 | |
39509 | 39509 | 1923-02-17 | 18 | c | Advertisement for Arnott's Biscuits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094311 | 24094311 | |
39517 | 39517 | 1923-02-17 | 19 | c | Advertisement for Sargents Ltd, High-class pastrycooks and caterers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094310 | 24094310 | |
39522 | 39522 | 1923-02-17 | 20 | c | Advertisement for Lea & Perrin's Sauce, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094313 | 24094313 | |
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 | |
39535 | 39535 | 1923-02-17 | 22 | c | Advertisement for Hop Lee & Co, wholesale fruit and produce, merchants & general commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094315 | 24094315 |
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]);