This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41842 | 41842 | 1924-07-19 | 7 | a | Chinese students in New South Wales organise their own association and the constitution. Organisers include students Su Guanqing, Luo Fuquan, Chen Qingyi, Wu Lianyun, Su Yiguang, Xiao Songfen, Ye Lin, Zeng Zhensheng, Liu Xiliang and Zhou You, and their temporary office is in the Lai Gee Club (li zhi hui). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 | |
41843 | 41843 | 1924-07-19 | 7 | b | Bandits commit robbery in a Melbourne park. | Australia | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 | |
41844 | 41844 | 1924-07-19 | 7 | b | A young man dies in a train accident while another one injured seriously. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 | |
41845 | 41845 | 1924-07-19 | 7 | b | A man in Adelaide marries his sister. | Australia | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 | |
41846 | 41846 | 1924-07-19 | 7 | b-c | Chinese football team explains their travel with Japanese liner. Members of the Chinese football team. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 | |
41847 | 41847 | 1924-07-19 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100796 | 24100796 |
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]);