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 |
---|---|---|---|---|---|---|---|---|---|
47377 | 47377 | 1928-09-01 | 2 | b | First part of a speech by Dr Chen Huanzhang in San Francisco on the quintessence of Confucianism. | America | http://trove.nla.gov.au/newspaper/page/24098930 | 24098930 | |
47381 | 47381 | 1928-09-01 | 3 | b | Nanjing government sets up special committee to abolish the likin tax and the first meeting of the committee. | China | http://trove.nla.gov.au/newspaper/page/24098929 | 24098929 | |
47387 | 47387 | 1928-09-01 | 5 | b | The growing of ginseng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098931 | 24098931 | |
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]);