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 |
|---|---|---|---|---|---|---|---|---|---|
| 47418 | 47418 | 1928-09-15 | 2 | b | Third and final part of the speech by Dr Chen Huanzhang in San Francisco on the quintessence of Confucianism. | America | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
| 47419 | 47419 | 1928-09-15 | 2 | c | A reply from the Japanese government to China's request to abrogate treaties. | China | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
| 47420 | 47420 | 1928-09-15 | 2 | e | A meeting of the Central Executive Committee of the Nationalist Party, attendants and the resolutions. | China | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
| 47421 | 47421 | 1928-09-15 | 2 | f | Shandong people appeal for help and their organisations in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
| 47422 | 47422 | 1928-09-15 | 2 | f | Japanese have different policy in Manchuria, Mongolia and inland China. | China | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
| 47423 | 47423 | 1928-09-15 | 3 | b | A public gathering in Shanghai and their appeals to the Nationalist government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098945 | 24098945 | |
| 47424 | 47424 | 1928-09-15 | 3 | c | Japanese troops in Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098945 | 24098945 | |
| 47425 | 47425 | 1928-09-15 | 3 | e | The Communist Party is still very active in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098945 | 24098945 | |
| 47426 | 47426 | 1928-09-15 | 5 | a-b | Notice issued by the Special Committee of the Chinese Chamber of Commerce in NSW for the National Day celebration and the birthday celebration for Confucius. The national anthem of the Republic of China. Photographs of the Special Committee members: organising superintendent Guo Jianying (W. Gock Young), treasurer Zhang Maokuan (Jong Young), vice-treasurer Zhang Fu (Jung Foo), English secretary Liu Guangfu (William J. L. Liu), and Chinese secretary Zhang Fuxiang (Jong Foo Chong). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098947 | 24098947 | |
| 47427 | 47427 | 1928-09-15 | 6-7 | a-d | Guangdong news/ Recent labour movement in Guangzhou. Communist forces arrive Guangdong from Hunan province. Key Communist activists arrested in Guangzhou for inciting strike. Director of the Guangzhou railway bureau Lao Mian and the comments by journalism. Smuggled submarine mines detected in Guangzhou. Ban on gambling might be lifted soon in Guangzhou. Wang Qingyu and his plan for afforestation in the north of Guangdong. Gentry from Guangning, Zengcheng and Fogang counties appeal for help for the suppression of bandits. Bandits in Dongguan county. Illegal prostitutes executed in Zhaoqing. News from Taishan. Bandits in Shunde. Minority peoples in Hainan island and their civilisations. Yao minority people oppose to the appointment of new director of the Yao People Affairs Bureau in Guangzhou. Bandits in Gaoming. | China | http://trove.nla.gov.au/newspaper/page/24098950 | 24098950 | |
| 47428 | 47428 | 1928-09-15 | 8 | a | Collision of a train and a truck in Germany. | Other... | http://trove.nla.gov.au/newspaper/page/24098952 | 24098952 | |
| 47429 | 47429 | 1928-09-15 | 8 | a | Conference of the League of Nations refuses to accept Chinese delegation. | Other... | http://trove.nla.gov.au/newspaper/page/24098952 | 24098952 | |
| 47430 | 47430 | 1928-09-15 | 8 | a | Soviet Union government in crisis. | Britain | http://trove.nla.gov.au/newspaper/page/24098952 | 24098952 | |
| 47431 | 47431 | 1928-09-15 | 8 | b | Australia news/ Dockers on strike in Sydney. Lawyer in Melbourne dies in court. Catholic parade in Vatican. A son of Anthony Horden, rich businessman in Sydney, dies. A man in Sydney is charged with using dud cheque. Proposal to organise Chinese around the world for business progress. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098952 | 24098952 | |
| 47432 | 47432 | 1928-09-15 | 8 | c | Chinese Chamber of Commerce in New South Wales to farewell Wei Zijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098952 | 24098952 |
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]);