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 |
---|---|---|---|---|---|---|---|---|---|
46653 | 46653 | 1928-01-14 | 2 | b | Editorial by Tung Wah Times on the Communist disasters in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098664 | 24098664 | |
46654 | 46654 | 1928-01-14 | 2 | b | Party school students in Nanjing are killed in demonstration and report on the tragedy. | China | http://trove.nla.gov.au/newspaper/page/24098664 | 24098664 | |
46655 | 46655 | 1928-01-14 | 2 | c | Writings by Jiang Jieshi (Chiang Kai-shek) for his marriage with Song Meiling. | China | http://trove.nla.gov.au/newspaper/page/24098664 | 24098664 | |
46656 | 46656 | 1928-01-14 | 2 | d | Soviet Russia is planning to build railway up to the border with China. | China | http://trove.nla.gov.au/newspaper/page/24098664 | 24098664 | |
46657 | 46657 | 1928-01-14 | 2 | e | Troops from the north-west take over Xuzhou, north Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24098664 | 24098664 | |
46658 | 46658 | 1928-01-14 | 2 | e | Chinese residents near the Ussuri River suffer from Russian defence forces. | China | http://trove.nla.gov.au/newspaper/page/24098664 | 24098664 | |
46659 | 46659 | 1928-01-14 | 3 | b | Process of the battle between Shandong and Henan province. | China | http://trove.nla.gov.au/newspaper/page/24098663 | 24098663 | |
46660 | 46660 | 1928-01-14 | 3 | c | Zhang Zuolin's army deny any use of gas in their fighting with Yan Xishan's troops. | China | http://trove.nla.gov.au/newspaper/page/24098663 | 24098663 | |
46661 | 46661 | 1928-01-14 | 3 | d | Hong Kong governor suggests a joint action of five countries in order to suppress bandits in south China. | China | http://trove.nla.gov.au/newspaper/page/24098663 | 24098663 | |
46662 | 46662 | 1928-01-14 | 3 | d | The wedding of Jiang Jieshi and Song Meiling. | China | http://trove.nla.gov.au/newspaper/page/24098663 | 24098663 | |
46663 | 46663 | 1928-01-14 | 3 | d | Possibility of peaceful solution to the chaos in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098663 | 24098663 | |
46664 | 46664 | 1928-01-14 | 3 | f | Japan denies any plan to dispatch more troops to Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098663 | 24098663 | |
46665 | 46665 | 1928-01-14 | 5 | a | Cold winter in America. | America | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46666 | 46666 | 1928-01-14 | 5 | a | Jiang Jieshi is back to office. Feng Yuxiang's army besiege Weihui, of Henan province. Chinese government to renew treaties with Italy and Portugal. Bandits killed by police in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46667 | 46667 | 1928-01-14 | 5 | a | Floods in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46668 | 46668 | 1928-01-14 | 5 | b | King of Afghanistan arrives Rome for a visit to Italy. | Britain | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46669 | 46669 | 1928-01-14 | 5 | b | British Prime Minister Stanley Baldwin hopes to see China unified. | Britain | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46670 | 46670 | 1928-01-14 | 5 | b | Li Jishen back to Guangdong. The military balance after the fall of Xuzhou. Talks between Jiang Jieshi and Li Jishen. The Nationalist government deports Soviet Russian consul. | China | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46671 | 46671 | 1928-01-14 | 5 | f | Advertisement for Reo Motors Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46672 | 46672 | 1928-01-14 | 6 | a-d | First part of a detailed report on the Communist massacre in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098668 | 24098668 | |
46673 | 46673 | 1928-01-14 | 7 | a | The sign of Red Cross in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098667 | 24098667 | |
46674 | 46674 | 1928-01-14 | 7 | a | Australia news/ British woman is deported from Sydney because she comes from China. Western visitor on the Communist disaster in China. Chinese businessman Lei Peng exports Australian dry fruits into China. Grain supply to the British troops in China. The Webster's Company in Brisbane on blaze. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098667 | 24098667 | |
46675 | 46675 | 1928-01-14 | 8 | a-d | Guangdong news/ Lijia Village in Taishan is robbed by bandits. Peasants' associations are ordered to disband. Peasants' bandits in Gaoyao county. Old temple to be renovated. Female dog feeds baby boy in Xinhui county. Report on the suppression of bandits in Chaoyang county. Bandits in Xinhui county, their kidnap and ransom. Police forces to recruit graduates of police school. Self-defence on board of ferries in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24098670 | 24098670 |
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]);