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 |
---|---|---|---|---|---|---|---|---|---|
47520 | 47520 | 1928-10-20 | 5 | a | Hong Kong news/ Plan for aviation industry development in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098987 | 24098987 | |
47522 | 47522 | 1928-10-20 | 8 | a | Bandits in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 | |
47523 | 47523 | 1928-10-20 | 8 | a | Earthquake in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 | |
47524 | 47524 | 1928-10-20 | 8 | a | Romanian authority deport Hungarian workers. | Canada | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 | |
47525 | 47525 | 1928-10-20 | 8 | a | Australia news/ Picnic organised by the Chinese Chamber of Commerce in New South Wales to celebrate the National Day on October 10 and the birthday of Confucius, and speakers include Wu Zhaoquan, Liu Guangfu, Guo Jianying, Zhang Fuxiang and others. Trial on the Sydney woman for her murder of husband. Strike and riots in Newcastle. Professor of history at University of Sydney commit suicide. Death of son on Anthony Horden and the redistribution of wealth. New survey on the factories in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 | |
47521 | 47521 | 1928-10-20 | 6-7 | a-d | Guangdong news/ Indian communists in Guangzhou. Opium sales in Guangzhou. Registration of new business firms. Provincial commercial chamber organised. Entertainment levy to be collected. Severe punishment applies to all clan fighting. Conspiracy of the Communist in Guangzhou. Martial law in the south of Guangzhou. Communists are still active in Haifeng county. Road to be built to connect Haifeng and Huizhou. Civil corps in Gaoyao county in trouble. Weapons seized from a silk factory in Shunde. Bandit chieftain arrested in Dongguan. Fire in the Qingyun Temple. | China | http://trove.nla.gov.au/newspaper/page/24098990 | 24098990 | |
47504 | 47504 | 1928-10-20 | 2 | b | Editorial by Tung Wah Times on the riots in Mongolia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098986 | 24098986 | |
47513 | 47513 | 1928-10-20 | 3 | b | Naval port to be built in Xiangshan, of Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24098985 | 24098985 | |
47514 | 47514 | 1928-10-20 | 3 | b | Japanese consul in Shanghai talks on his return. | Japan | http://trove.nla.gov.au/newspaper/page/24098985 | 24098985 | |
47505 | 47505 | 1928-10-20 | 2 | c | Border demarcation in Macao and treaty review between China and Portugal. | China | http://trove.nla.gov.au/newspaper/page/24098986 | 24098986 | |
47515 | 47515 | 1928-10-20 | 3 | c | Internal fighting within the Fujian provincial government. | China | http://trove.nla.gov.au/newspaper/page/24098985 | 24098985 | |
47506 | 47506 | 1928-10-20 | 2 | d | China at the conference of the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24098986 | 24098986 | |
47507 | 47507 | 1928-10-20 | 2 | d | Foreign missions in Beijing respond to China's request for tariff autonomy. | China | http://trove.nla.gov.au/newspaper/page/24098986 | 24098986 | |
47508 | 47508 | 1928-10-20 | 2 | d | Rumours says Cheng Qian has been assassinated | China | http://trove.nla.gov.au/newspaper/page/24098986 | 24098986 | |
47516 | 47516 | 1928-10-20 | 3 | d | Panchen Lama offers to persuade Zhang Xueliang in Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24098985 | 24098985 | |
47509 | 47509 | 1928-10-20 | 2 | e | Zhang Zongchang and Chu Yupu issue circular telegram to condemn Zhang Xueliang. | China | http://trove.nla.gov.au/newspaper/page/24098986 | 24098986 | |
47510 | 47510 | 1928-10-20 | 2 | e | Persia replaces China as standing member of the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24098986 | 24098986 | |
47511 | 47511 | 1928-10-20 | 2 | e | Police and civil administration in Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098986 | 24098986 | |
47517 | 47517 | 1928-10-20 | 3 | e | Yan Xishan on the administration in Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24098985 | 24098985 | |
47512 | 47512 | 1928-10-20 | 2 | f | The assassination of Shen Dingyi in Xiaoshan, Zhejiang province, and the investigation. | China | http://trove.nla.gov.au/newspaper/page/24098986 | 24098986 | |
47518 | 47518 | 1928-10-20 | 3 | f | Withdrawal of Japanese troops from Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098985 | 24098985 | |
47519 | 47519 | 1928-10-20 | 3 | f | Li Guojun is arrested in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098985 | 24098985 |
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]);