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 |
|---|---|---|---|---|---|---|---|---|---|
| 46908 | 46908 | 1928-04-07 | 2 | b | Editorial on the ban of dancing in Guangzhou and the social decency. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098752 | 24098752 | |
| 46909 | 46909 | 1928-04-07 | 2 | c | Shen Yi and his proposals for the social construction in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098752 | 24098752 | |
| 46910 | 46910 | 1928-04-07 | 2 | f | Jiang Jieshi seeks peaceful solution to the current disputes in China. | China | http://trove.nla.gov.au/newspaper/page/24098752 | 24098752 | |
| 46911 | 46911 | 1928-04-07 | 3 | b | Soviet Russia subsidises the Japanese Bolshevik Party for their election campaign. | Japan | http://trove.nla.gov.au/newspaper/page/24098751 | 24098751 | |
| 46912 | 46912 | 1928-04-07 | 3 | b | Military situation in Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/24098751 | 24098751 | |
| 46913 | 46913 | 1928-04-07 | 3 | b | Number of Russian refugees in China. A conference of the Russian refugees in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098751 | 24098751 | |
| 46914 | 46914 | 1928-04-07 | 3 | c | Wu Peifu enjoys his life in Liangshan Mountain, Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24098751 | 24098751 | |
| 46915 | 46915 | 1928-04-07 | 3 | c | Result of the general election in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24098751 | 24098751 | |
| 46916 | 46916 | 1928-04-07 | 3 | d | Commercial chambers in provinces call for a national conference for the unification. | China | http://trove.nla.gov.au/newspaper/page/24098751 | 24098751 | |
| 46917 | 46917 | 1928-04-07 | 3 | e | Internal split within the Chinese Communist Party (Tan Pingshan, Deng Yinda, Guo Moruo, Song Qingling, Chen Youren, Su Zhaozheng, Mao Zedong, Borodin and others). | China | http://trove.nla.gov.au/newspaper/page/24098751 | 24098751 | |
| 46918 | 46918 | 1928-04-07 | 5 | a | Effort of the Guangzhou government is trying to borrow money from Hong Kong and the report. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098753 | 24098753 | |
| 46919 | 46919 | 1928-04-07 | 5 | b | Second part of the survey on the handmade paper industry in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098753 | 24098753 | |
| 46920 | 46920 | 1928-04-07 | 5 | c | Elephant in Burma. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098753 | 24098753 | |
| 46921 | 46921 | 1928-04-07 | 6 | a-d | Guangdong news/ Financial difficulties of the local county authorities in Guangdong. The Communist forces are defeated by civil corps in Lufeng county. Huang Shaoxiong is back to Guangzhou while the 7th Army is returning to Guangxi. Deng Yanhua requests to suppress the communists. There are many dinner parties in the Guangzhou officialdom. Restaurants in Guangzhou oppose to new tax. Journalist Huang Xianzhao is free now. The labour movement in Guangdong, the past and the present. | China | http://trove.nla.gov.au/newspaper/page/24098756 | 24098756 | |
| 46922 | 46922 | 1928-04-07 | 7 | a | British House of Commons questions weapon transportation to China. | Britain | http://trove.nla.gov.au/newspaper/page/24098755 | 24098755 | |
| 46923 | 46923 | 1928-04-07 | 7 | a | Shantou may fall into the control of the Chinese Communist forces. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098755 | 24098755 | |
| 46924 | 46924 | 1928-04-07 | 7 | a | Troops from the south and the north China are preparing for a big war. | China | http://trove.nla.gov.au/newspaper/page/24098755 | 24098755 | |
| 46925 | 46925 | 1928-04-07 | 7 | a | Egypt demands autonomy from Britain. | Other... | http://trove.nla.gov.au/newspaper/page/24098755 | 24098755 | |
| 46926 | 46926 | 1928-04-07 | 7 | b | American ambassador declines to comment his talks with the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24098755 | 24098755 | |
| 46927 | 46927 | 1928-04-07 | 7 | b-c | Australia news/ Royal Agricultural Show in Sydney and the visitors. Motor factory in Brisbane is on blaze. Federal treasurer reports the revenue of tariff and post service. A white man hangs himself in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098755 | 24098755 | |
| 46928 | 46928 | 1928-04-07 | 7 | c | A letter from the Dongqiao School in Hong Kong to Ye Tonggui, Chinese businessman in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098755 | 24098755 | |
| 46929 | 46929 | 1928-04-07 | 8 | a-d | Guangdong news/ A young man in Guangzhou murders his mother. Refugees from Haifeng county report the Communist forces. Provincial authority trying to maintain current value of the bank notes. A party of the Han and the Yao minority peoples in Lianping county. Zhongshan county authority asks to extradite communist activists from Macao. The Communists and the bandits in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24098758 | 24098758 |
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]);