This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38245 | 38245 | 1922-01-28 | 19 | a | Photograph of a Chinese wedding, Ye Yuezu and Li Yueming. Also in the photograph are Ye Zuye, Ye Rongxi, Ye Huizhen, Ye Lijiao, Li Suxin, and Ye Genghao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093854 | 24093854 | |
38246 | 38246 | 1922-01-28 | 19 | b | Second part of the brief introduction to Asian philosophy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093854 | 24093854 | |
38247 | 38247 | 1922-01-28 | 19 | b | Poems by Xiaozhen, He Chengfang and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093854 | 24093854 |
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]);