This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42159 | 42159 | 1924-10-04 | 6 | a-c | The establishment of the National Museum of China and its mission. | China | http://trove.nla.gov.au/newspaper/page/24100885 | 24100885 | |
42164 | 42164 | 1924-10-04 | 7 | a-c | Chinese Chamber of Commerce in New South Wales celebrates the birthday of Confucius and speakers include Guo Jianying, Zhao Zhongguang, Su Yiguang, Chen Qingyi, Luo Fuquan, Zheng Fanchang, Guo Jiexiu, Wu Elou, and Li Xuchun. First part of the speeches by Zhao Zhongguang, chief-editor of Gong Bao, a bulletin of the Sydney zhi gong tang, Guo Jianying and Su Yiguang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100884 | 24100884 |
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]);