This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45230 | 45230 | 1926-10-16 | 6 | b | Chinese community in Java fights for equal treatment. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101748 | 24101748 | |
45231 | 45231 | 1926-10-16 | 6 | c-d | Chinese businessmen in the Philippines fight for their own rights. | Tung Wah | 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]);