This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45232 | 45232 | 1926-10-16 | 7 | a-b | Australia news/ Smuggled opium seized in Melbourne. Russian refugees escape to Australia. Bathroom is compulsory for residential house. Chinese community in Sydney celebrates the National Day on October 10 and speakers include Wu Zhaoquan, Zhao Zhongguang, Chen Xiafu, Liu Guangfu, Guo Jianying, Pan Yonghan, Zheng Fanchang, and Li Run, Ling Shu'an (Ying). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101747 | 24101747 | |
45233 | 45233 | 1926-10-16 | 7 | b | The fall of Jiujiang in Jiangxi province and Wuchang in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24101747 | 24101747 | |
45234 | 45234 | 1926-10-16 | 7 | c-d | News on the war in China between the south and the north. News on the strike in Guangzhou and Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24101747 | 24101747 |
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]);