This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46242 | 46242 | 1927-10-01 | 5 | a | British attitude towards the Communist party in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46243 | 46243 | 1927-10-01 | 5 | a | Military clash in Longhua, Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46244 | 46244 | 1927-10-01 | 5 | a | Bandits in Nicaragua. | America | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46245 | 46245 | 1927-10-01 | 5 | a | French government wants the Soviet Russian ambassador recalled back. | France | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46246 | 46246 | 1927-10-01 | 5 | a | Japanese invasion into Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
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 |
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]);