This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32973 | 32973 | 1918-02-16 | 10 | a | Photographs of Wang Shizhen, Lu Zhengxiang, Qian Nengxun, Jiang Yong, Tian Wenlie, Liu Guanxiong, and Yin Chang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097187 | 24097187 | |
32974 | 32974 | 1918-02-16 | 10 | a | Lin Xueheng can know the past and predicts the future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097187 | 24097187 | |
32975 | 32975 | 1918-02-16 | 10 | a | Miscellaneous report on the Chinese politics. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097187 | 24097187 | |
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 | |
32980 | 32980 | 1918-02-16 | 10 | c | Advertisement for the Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097187 | 24097187 |
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]);