This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42641 | 42641 | 1925-01-24 | 7 | a-b | Chinese students in Melbourne suggest the Chinese community to set up a school. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42642 | 42642 | 1925-01-24 | 7 | b | A train accident in New South Wales and the tragedy. | Australia | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42643 | 42643 | 1925-01-24 | 7 | b | A sleepwalking man in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42644 | 42644 | 1925-01-24 | 7 | b | Storm and damages in New South Wales and Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42645 | 42645 | 1925-01-24 | 7 | b | A Sydney lawyer pleads for the Chinese gamblers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42646 | 42646 | 1925-01-24 | 7 | c | A Chinese boy is barred from returning to Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42647 | 42647 | 1925-01-24 | 7 | c | Chinese magic performer Lang Deshan returns to Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42648 | 42648 | 1925-01-24 | 7 | c | Bandits in New York hijack a post train. | America | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42649 | 42649 | 1925-01-24 | 7 | c | Earthquake in Persia and the tragedy. | Other... | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42650 | 42650 | 1925-01-24 | 7 | c | Russian people have a memory service for Lenin. | Britain | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42651 | 42651 | 1925-01-24 | 7 | c | Pirates hijack a Chinese ship on its way from Singapore to Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42652 | 42652 | 1925-01-24 | 7 | c | Royal British navy to dispatch fleet to the Far East. | Britain | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42653 | 42653 | 1925-01-24 | 7 | c-d | Lu Yongxiang, of Zhejiang, and Qi Xieyuan, of Jiangsu, start another war. | China | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42654 | 42654 | 1925-01-24 | 7 | d | Lu Yongxiang, of Zhejiang province, recruits Russian soldiers into his troops. | China | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42655 | 42655 | 1925-01-24 | 7 | e | Foreign naval forces in Shanghai to block the return of Qi Xieyuan. | China | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42656 | 42656 | 1925-01-24 | 7 | e | Two open letters respectively by Miao Huili and the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 |
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]);