This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 31938 | 31938 | 1917-01-27 | 6 | a-b | New Year greetings from the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095569 | 24095569 | |
| 31939 | 31939 | 1917-01-27 | 6 | a-b | Two photographs of Chinese President Li Yuanhong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095569 | 24095569 | |
| 31942 | 31942 | 1917-01-27 | 7 | a-b | Miscellaneous report on Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24095568 | 24095568 | |
| 31947 | 31947 | 1917-01-27 | 8 | a-b | Words on the occasion of Chinese New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095571 | 24095571 | |
| 31953 | 31953 | 1917-01-27 | 10 | a-b | Comments on the Chinese nationalisation and the Europeanization. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095573 | 24095573 | |
| 31960 | 31960 | 1917-01-27 | 12 | a-b | Local provinces in China to set up offices for internal affairs, finance, education and industrial development, and the explanation. | China | http://trove.nla.gov.au/newspaper/page/24095575 | 24095575 | |
| 31974 | 31974 | 1917-01-27 | 15 | a-b | A survey on the railway achievements in China and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095576 | 24095576 | |
| 31978 | 31978 | 1917-01-27 | 16 | a-b | The manufacturing of warship and its history. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095579 | 24095579 | |
| 32048 | 32048 | 1917-01-27 | 22 | a-b | Advertisement for the Wing On Company Ltd, Shanghai, for its effort to raise more shares in the Australian Chinese communities. And the detailed map of Wing On Company Ltd in Shanghai. Agents include Guo Biao, Guo Shun, Ma Zuxing, Ouyang Jiantang, Chen Jingchen, Li Lihou, Liang Yaoting and Li Jiongtang respectively in Sydney, Shanghai, Thailand, Guangzhou, Tianjin, Hankou and Singapore. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095585 | 24095585 | |
| 32049 | 32049 | 1917-01-27 | 23 | a-b | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095584 | 24095584 | |
| 32056 | 32056 | 1917-01-27 | 24 | a-b | Long and short verses on hatred. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095587 | 24095587 |
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]);