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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 32969 | 32969 | 1918-02-16 | 8 | b | Confucianism is the key to save China, an article selected from a newspaper in Gangzhou, Guangdong province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097185 | 24097185 | |
| 32971 | 32971 | 1918-02-16 | 9 | b | Industrial report/ Survey on the gold and silver mines in Shanxi province, China. Invention and manufacturing of canvas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097184 | 24097184 | |
| 32972 | 32972 | 1918-02-16 | 9 | b | Comments by Tung Wah Times on the current situations in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097184 | 24097184 | |
| 32976 | 32976 | 1918-02-16 | 10 | b | Tung Wah Times will stop publishing due to the New Year holiday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097187 | 24097187 | |
| 32977 | 32977 | 1918-02-16 | 10 | b | Photographs of Chinese Consul-General in Australia Wei Zijing and his wife. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097187 | 24097187 | |
| 32978 | 32978 | 1918-02-16 | 10 | b | A notice issued by the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097187 | 24097187 | |
| 32979 | 32979 | 1918-02-16 | 10 | b | Advertisement for Harry Walters, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097187 | 24097187 | |
| 32987 | 32987 | 1918-02-16 | 13 | b | Photograph of Jerusalem, birthplace of Jesus Christ. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097188 | 24097188 | |
| 32993 | 32993 | 1918-02-16 | 14 | b | A flying hunter in Paris, France. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097191 | 24097191 | |
| 33002 | 33002 | 1918-02-16 | 15 | b | Advertisement for Dockson & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
| 33003 | 33003 | 1918-02-16 | 15 | b | Advertisement for Lum See Jan, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
| 33004 | 33004 | 1918-02-16 | 15 | b | Advertisement for Sam War, 319 Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
| 33005 | 33005 | 1918-02-16 | 15 | b | Advertisement for S. Hoffnung & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097190 | 24097190 | |
| 33019 | 33019 | 1918-02-16 | 16 | b | Advertisement for Tiy Loy & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
| 33020 | 33020 | 1918-02-16 | 16 | b | Advertisement for G. Tong, oriental herbalist, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
| 33021 | 33021 | 1918-02-16 | 16 | b | Advertisement for Goon Lee Shing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097193 | 24097193 | |
| 33037 | 33037 | 1918-02-16 | 17 | b | Advertisement for H. Sleeman, watchmaker, jeweller, optician and silverware specialist, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097192 | 24097192 | |
| 33050 | 33050 | 1918-02-16 | 18 | b | Advertisement for A. U. S. N. Co Ltd, Burns Philp & Co Ltd agents, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097195 | 24097195 | |
| 33051 | 33051 | 1918-02-16 | 18 | b | Advertisement for Tucker & Co Ltd, Sydney, Chateau-Tanunda Special, 3 star hospital brandy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097195 | 24097195 | |
| 33052 | 33052 | 1918-02-16 | 18 | b | Advertisement for Anthony Hordern & Sons Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097195 | 24097195 | |
| 33056 | 33056 | 1918-02-16 | 19 | b | Advertisement for W. Gardiner & Co Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097194 | 24097194 |
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]);