This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47461 | 47461 | 1928-09-29 | 5 | a-b | Notice issued by the Special Committee of the Chinese Chamber of Commerce in NSW for the National Day celebration and the birthday celebration for Confucius. Photographs of the Special Committee members: Chen Chucai (N. Lean Fore), Zhu Zhongming (Fred Hing), Mrs He Wang (H. Wong), Miss Luo Yanxia (Ida Yum), Huang Guangzhao (Horace Wong), and Charles Kee. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098963 | 24098963 | |
47472 | 47472 | 1928-09-29 | 5 | a | Notice issued by the Special Committee of the Chinese Chamber of Commerce in NSW for the National Day celebration and the birthday celebration for Confucius. Photographs of the Special Committee members: Mrs A. Sarsin, Fang Yahua (Fred Fong) and Chen Shunyao (Edward Kaw). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098963 | 24098963 |
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]);