This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46257 | 46257 | 1927-10-01 | 7 | a | A notice issued by the Sydney Chinese Sports Club on its first annual grand blue and white ball. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098547 | 24098547 | |
46258 | 46258 | 1927-10-01 | 7 | a | A notice issued by the Young Chinese Association in Australia (li zhi hui) in Sydney. | Other... | http://trove.nla.gov.au/newspaper/page/24098547 | 24098547 | |
46259 | 46259 | 1927-10-01 | 7 | a | Australia news/ A tea party organised by the Chinese Chamber of Commerce in Sydney to celebrate the birthday of Confucius and speakers include Wu Zhaoquan, Ye Bingnan, Zhang Fanchang, Zhu Songqing, Guo Jianying, Liu Guangfu, and Liu Junchen. Chinese gardener in Victoria fights bandits near Goulburn. Timely rain in north New South Wales. German journalist comes to collect data for his book about Australia. Women in Sydney on the price increase of bread. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098547 | 24098547 | |
46260 | 46260 | 1927-10-01 | 7 | b | Troops from north China are moving south. | China | http://trove.nla.gov.au/newspaper/page/24098547 | 24098547 | |
46261 | 46261 | 1927-10-01 | 7 | b | Rao Hanxiang and his stories. | China | http://trove.nla.gov.au/newspaper/page/24098547 | 24098547 |
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]);