This data as json, CSV (advanced)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
32956 | 32956 | 1918-02-16 | 3 | b | Advertisement for G. R. Carlyle, 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 | |
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 | |
32953 | 32953 | 1918-02-16 | 3 | a | Advertisement for Glebe Sales Yards, 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 | |
32951 | 32951 | 1918-02-16 | 3 | a | Advertisement for J. Cragg & Son, 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 | |
32949 | 32949 | 1918-02-16 | 3 | a | Advertisement for On Chong & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097178 | 24097178 | |
32948 | 32948 | 1918-02-16 | 2 | a | Advertisement for Nippon Yusen Kaisha, Japan Mail Steamship Line, Burns Philip & Co, Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097179 | 24097179 | |
32947 | 32947 | 1918-02-16 | 1 | a | Advertisement for On Chong & Company, importers and exporters, shipping merchants, Sydney, Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097177 | 24097177 |
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]);