This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46313 | 46313 | 1927-10-15 | 7 | a | The enterprise of a 17-year-old Australian boy, George Palmer. Photograph of George Palmer and Miss Thelma Nelson. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 | |
46314 | 46314 | 1927-10-15 | 7 | b | Australia news/ Chinese businessman in Inverell, New South Wales, welcomes his mother in Sydney on her arrival. Farewell party for Chen Zanhua and Lin Kangnian and welcome Cai Tian. Chinese communities in Sydney celebrate the National Day on October 10, and speakers include Wu Zhaoquan, Ye Bingnan, Ye Tonggui, Zheng Fanchang, Guo Jianying, Liu Guangfu and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 | |
46315 | 46315 | 1927-10-15 | 7 | c | Finance and business in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 | |
46316 | 46316 | 1927-10-15 | 7 | c | The Shanxi army after the war with Zhang Zuolin's army. | China | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 | |
46317 | 46317 | 1927-10-15 | 7 | c | Riots in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098563 | 24098563 |
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]);