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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 45729 | 45729 | 1927-05-21 | 2 | d | American senator comes to visit China. | America | http://trove.nla.gov.au/newspaper/page/24101992 | 24101992 | |
| 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 | |
| 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 | |
| 45732 | 45732 | 1927-05-21 | 3 | c | Chinese community in Cuba and their sufferings. | Other... | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
| 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 | |
| 45734 | 45734 | 1927-05-21 | 3 | e | Ye Kaixin is appointed army commander. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
| 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 | |
| 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 | |
| 45737 | 45737 | 1927-05-21 | 3 | f | Victory celebration in Nanjing, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
| 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 | |
| 45739 | 45739 | 1927-05-21 | 5 | c | Police in London search Russian companies. | Britain | http://trove.nla.gov.au/newspaper/page/24101993 | 24101993 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |
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]);