This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12826 | 12826 | 1904-02-27 | 2 | a | Words of gretting from Tung Wah Times on the Chinese New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800383 | 26800383 | |
12827 | 12827 | 1904-02-27 | 2 | a | An editorial on the war between Russia and Japan and its impact on China. A further comments on yellow peril. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800383 | 26800383 | |
12835 | 12835 | 1904-02-27 | 2 | c | Chinese communities in Sydney and Brisbane donate to Japanese servicemen and their families as the war going to break out. Organisers includes Liu Ruxing, Ye Bingnan, Chen Xia, Tang Caizhi, Wu E'lou, Liang Chuang, Zheng Fanchang, Chen Lianke, Mei Bing, and Wu Yanfan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800383 | 26800383 | |
12842 | 12842 | 1904-02-27 | 3 | b | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800382 | 26800382 | |
12843 | 12843 | 1904-02-27 | 3 | b | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800382 | 26800382 | |
12844 | 12844 | 1904-02-27 | 3 | c | A notice to directors of Tung Wah Times for monthly meeting. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800382 | 26800382 |
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]);