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 |
---|---|---|---|---|---|---|---|---|---|
46299 | 46299 | 1927-10-15 | 3 | b | Industrialists and businessmen in Fengtian oppose to Japanese rule in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098559 | 24098559 | |
46307 | 46307 | 1927-10-15 | 5 | b | Leader of rebellions is arrested in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
46308 | 46308 | 1927-10-15 | 5 | b | Danish warship sinks in the North Sea. | Other... | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
46309 | 46309 | 1927-10-15 | 5 | b | Troops from Shanxi province are approaching Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
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 |
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]);