This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47389 | 47389 | 1928-09-01 | 8 | a | Passenger liner Ruitai (from Hong Kong to Macao) on fire. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098936 | 24098936 | |
47390 | 47390 | 1928-09-01 | 8 | a | Fifteen countries sign the peace treaty in Paris. | Britain | http://trove.nla.gov.au/newspaper/page/24098936 | 24098936 | |
47391 | 47391 | 1928-09-01 | 8 | a | Traffic accident in a tunnel in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24098936 | 24098936 | |
47392 | 47392 | 1928-09-01 | 8 | a | British businessmen jointly set up big company in China. | Britain | http://trove.nla.gov.au/newspaper/page/24098936 | 24098936 | |
47393 | 47393 | 1928-09-01 | 8 | b | People in Shanghai request to ban dog racing. | China | http://trove.nla.gov.au/newspaper/page/24098936 | 24098936 | |
47394 | 47394 | 1928-09-01 | 8 | b | More riots in Shandong province and other areas in China. | China | http://trove.nla.gov.au/newspaper/page/24098936 | 24098936 | |
47395 | 47395 | 1928-09-01 | 8 | b | Australia news/ Wu Qinfen replaces Wei Zijing as new Chinese consul-general in Australia and their public notices. Special committee organised by the Chinese Chamber of Commerce in New South Wales for the National Day celebration on October 10 and the birthday celebration for Confucius, and its includes Guo Jianying, Huang Guangzhao, Charlie Deng, Zhang Maokuan, Zhang Fu, Zhang Fuxiang, Liu Guangfu, Zhu Hechou, Cai Tian, Chen Chucai, Zhu Zhongming, Fang Yahua, Chen Shunyao, He Wangfu, and Luo Yanxia. Chinese husband in Sydney is murdered by his half-breed wife. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098936 | 24098936 |
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]);