This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45229 | 45229 | 1926-10-16 | 6 | a-b | Wu Peifu is defeated in Hanyang and the detailed report. | China | http://trove.nla.gov.au/newspaper/page/24101748 | 24101748 | |
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 |
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]);