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 |
---|---|---|---|---|---|---|---|---|---|
45734 | 45734 | 1927-05-21 | 3 | e | Ye Kaixin is appointed army commander. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45737 | 45737 | 1927-05-21 | 3 | f | Victory celebration in Nanjing, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45728 | 45728 | 1927-05-21 | 2 | c-d | The independence of Mongolia and its influence upon China. | China | http://trove.nla.gov.au/newspaper/page/24101992 | 24101992 | |
45731 | 45731 | 1927-05-21 | 3 | c | Refugees from Shandong and Zhili (Hebei) province flee to the Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45739 | 45739 | 1927-05-21 | 5 | c | Police in London search Russian companies. | Britain | http://trove.nla.gov.au/newspaper/page/24101993 | 24101993 | |
45738 | 45738 | 1927-05-21 | 5 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101993 | 24101993 | |
45743 | 45743 | 1927-05-21 | 8 | a-d | Guangdong news/ Jiang Jieshi praises various social associations for their anti-Communist attitude. Qian Dajun reports the suppression of communists. Russians move out of Guangzhou. British, Japanese and American consuls congratulate the suppress of communists. The Chinese Communist Party members under arrest in Guangzhou. Commercial chambers and the interest of peasants' association. Agricultural and industrial authority and their response to the Communists. Special committee set up in Guangzhou on the rights of workers. Liang Lin is released from the prison. The Communist weekly newspaper Xiangdao (The Guide) is closed in Guangzhou. Public Security in Guangzhou requests to ban entry of newspapers from Hankou. Kidnap and ransom in the Peiying School in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101998 | 24101998 | |
45735 | 45735 | 1927-05-21 | 3 | e | Foreign ministry in Beijing stops the redundancy plan. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45727 | 45727 | 1927-05-21 | 2 | b-c | Editorial by Tung Wah Times on the bandits in Guangdong and the efforts to wipe them out. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101992 | 24101992 | |
45736 | 45736 | 1927-05-21 | 3 | f | Circular telegram issued by Lu Xingban to support the Nationalist Party and Jiang Jieshi. | Canada | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45732 | 45732 | 1927-05-21 | 3 | c | Chinese community in Cuba and their sufferings. | Other... | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45730 | 45730 | 1927-05-21 | 2 | e | Chinese communist leader Li Dazhao is arrested in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101992 | 24101992 | |
45740 | 45740 | 1927-05-21 | 7 | a-b | Australia news/ Police in Sydney raid Chinese gambling dens. Chinese Consul-General Wei Zijing congratulates the move of Australian national capital from Melbourne to Canberra. Welcome to the Chinese football team in Sydney. Another arrest of the Chinese gambling in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101995 | 24101995 | |
45729 | 45729 | 1927-05-21 | 2 | d | American senator comes to visit China. | America | http://trove.nla.gov.au/newspaper/page/24101992 | 24101992 | |
45733 | 45733 | 1927-05-21 | 3 | e | American consulates in Mexico refuse to grant visas to the Chinese applicants. | America | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45742 | 45742 | 1927-05-21 | 7 | d | Advertisement for the Prospectus of Gehrig's New South Wales Wines Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101995 | 24101995 | |
45741 | 45741 | 1927-05-21 | 7 | b | A dead boy walks in Linqing county, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24101995 | 24101995 |
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]);