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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
47387 | 47387 | 1928-09-01 | 5 | b | The growing of ginseng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098931 | 24098931 | |
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 | |
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 |
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]);