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 |
---|---|---|---|---|---|---|---|---|---|
45762 | 45762 | 1927-06-04 | 2 | b | Editorial by the Tung Wah Times on the suppression of the Chinese Communist Party members in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102009 | 24102009 | |
45779 | 45779 | 1927-06-04 | 7 | a-b | Australia news/ Phonographic photos seized in a Sydney studio. New South Wales has new government. Chinese football team wins the first match in Melbourne. A white man jumps into the sea in Sydney and commits suicide. Advertisement for Chinese Sales Manager Charles See in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102012 | 24102012 | |
45780 | 45780 | 1927-06-04 | 7 | b-c | A filial horse and its story. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102012 | 24102012 | |
45781 | 45781 | 1927-06-04 | 7 | b-c | A woman in Shanghai and her story. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102012 | 24102012 | |
45782 | 45782 | 1927-06-04 | 7 | d | A notice by Tan Liangnan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102012 | 24102012 | |
45783 | 45783 | 1927-06-04 | 6 | one page | Advertisement for Fosseys on George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102013 | 24102013 | |
45784 | 45784 | 1927-06-04 | 8 | one page | Advertisement for Sydney, the greatest and most progressive city of Australia, an owner of land in Sydney today must make money, how to make money, electric railway station estate, Chinese sales manager Mr Charles See (Huang Yongchun), and Sydney Subdivisions Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102014 | 24102014 |
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]);