This data as json, CSV (advanced)
Suggested facets: page, column, 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 | |
47378 | 47378 | 1928-09-01 | 2 | c | Conference of the League of Nations and the attendance of Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24098930 | 24098930 | |
47379 | 47379 | 1928-09-01 | 2 | e | Qingdao, of Shandong province, under the Japanese control. | China | http://trove.nla.gov.au/newspaper/page/24098930 | 24098930 | |
47380 | 47380 | 1928-09-01 | 2 | f | Expiration of the treaty between China and Japan. | China | 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 | |
47382 | 47382 | 1928-09-01 | 3 | c | Nanjing government to take back the Kaiping coal mine from British company. | China | http://trove.nla.gov.au/newspaper/page/24098929 | 24098929 | |
47383 | 47383 | 1928-09-01 | 3 | d | Large amount of weapons arrive Shanghai purchased by Liu Xiang, of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24098929 | 24098929 | |
47384 | 47384 | 1928-09-01 | 3 | f | Xu Qian is appointed financial director of Xinjiang provincial government, northweast of China. | China | http://trove.nla.gov.au/newspaper/page/24098929 | 24098929 | |
47385 | 47385 | 1928-09-01 | 3 | f | Minister of Internal Affairs of the Nanjing government Xue Dubi suggests to abolish prostitution. | China | http://trove.nla.gov.au/newspaper/page/24098929 | 24098929 | |
47386 | 47386 | 1928-09-01 | 5 | a | Hong Kong news/ Anti-Japanese sentiment in Hong Kong. Private banks collapse in Shiqi, Zhongshan county. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098931 | 24098931 | |
47387 | 47387 | 1928-09-01 | 5 | b | The growing of ginseng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098931 | 24098931 | |
47388 | 47388 | 1928-09-01 | 6-7 | a-d | Guangdong news/ Communist forces in Hunan province now gather on the border of Guangdong. Arrest of Communist bandits in Guangzhou. Circular telegram issued by Chen Mingshu to support political involvement of military forces. Bandits in Zengcheng county. Road construction in Xinhui county. Efforts to suppress bandits in Zengcheng. Plague of locusts in Dongguan. Looting by bandits in Shilong town. Communists in Gaoyao county. Bandits in Nanhai county collect land levy. Clan feud and fighting in Heshan county. | China | http://trove.nla.gov.au/newspaper/page/24098934 | 24098934 | |
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]);