This data as json, CSV (advanced)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
39424 | 39424 | 1923-02-17 | 3 | d | Advertisement for Gibbs Bright & Co, Insurance Department, 41 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094294 | 24094294 | |
39437 | 39437 | 1923-02-17 | 4 | d | Advertisement for Tiy Loy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39438 | 39438 | 1923-02-17 | 4 | d | Advertisement for War Hing Tiy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39439 | 39439 | 1923-02-17 | 4 | d | Advertisement for Tillook & Co Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094297 | 24094297 | |
39453 | 39453 | 1923-02-17 | 5 | d | Advertisement for Peter Dawson's Whisky, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39454 | 39454 | 1923-02-17 | 5 | d | Advertisement fro Ping Hong Lowe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
39455 | 39455 | 1923-02-17 | 5 | d | Advertisement for W. Mow Sang & Co, fruit and vegetable merchants & commission agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094296 | 24094296 | |
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 | |
39414 | 39414 | 1923-02-17 | 1 | one page | Advertisement for Eastern and Australian Steamship Company Ltd, Gibbs Bright & Co, General agents in Australia, 37 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094293 | 24094293 | |
39415 | 39415 | 1923-02-17 | 2 | one page | Advertisement for On Chong & Company, importers & exporters, shipping merchants, 225 George Street, Sydney, Australia, | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094295 | 24094295 | |
39538 | 39538 | 1923-02-17 | 24 | one page | Advertisement for Australian Oriental Line, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094316 | 24094316 |
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]);