This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32949 | 32949 | 1918-02-16 | 3 | a | Advertisement for On Chong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32950 | 32950 | 1918-02-16 | 3 | a | Advertisement for The International Rubber Stamp Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32951 | 32951 | 1918-02-16 | 3 | a | Advertisement for J. Cragg & Son, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32952 | 32952 | 1918-02-16 | 3 | a | Advertisement for Ford Adams & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32953 | 32953 | 1918-02-16 | 3 | a | Advertisement for Glebe Sales Yards, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32954 | 32954 | 1918-02-16 | 3 | a | Advertisement for H. S. Jerdan, optician, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32955 | 32955 | 1918-02-16 | 3 | b | Advertisement for S. Freeman & Sons Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32956 | 32956 | 1918-02-16 | 3 | b | Advertisement for G. R. Carlyle, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32957 | 32957 | 1918-02-16 | 3 | b | Advertisement for Sydney Boot Repairing Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32958 | 32958 | 1918-02-16 | 3 | b | Advertisement for Mr L. S. Keong, Chinese herbalist, Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32959 | 32959 | 1918-02-16 | 3 | c | Advertisement for The Employers' Liability Assurance Corporation Ltd of London, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32960 | 32960 | 1918-02-16 | 3 | c | Advertisement for James Stedman Ltd, manufacturing confectioners, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32961 | 32961 | 1918-02-16 | 3 | c | Advertisement for Gibbs Bright & Co, insurance department, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32962 | 32962 | 1918-02-16 | 3 | c | Advertisement for printing and stationery services at the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32963 | 32963 | 1918-02-16 | 3 | d | Advertisement for Althouse & Geiger, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32964 | 32964 | 1918-02-16 | 3 | d | Advertisement for Tillock & Co, merchants and manufacturers, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32965 | 32965 | 1918-02-16 | 3 | d | Advertisement for Lea & Perrins' sauce, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 |
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]);