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 |
|---|---|---|---|---|---|---|---|---|---|
| 45744 | 45744 | 1927-05-28 | 2 | b-c | Editorial by Tung Wah Times on the bandits in Guangdong and the government's effort to suppress bandits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102000 | 24102000 | |
| 45745 | 45745 | 1927-05-28 | 2 | c | The internal politics in the Soviet Russia (population, number of Communists Party members, election, labour movement and the salary, education for workers and farmers, award for Russian teaching, etc). | Other... | http://trove.nla.gov.au/newspaper/page/24102000 | 24102000 | |
| 45746 | 45746 | 1927-05-28 | 2 | d | A telegram from Zhang Xueliang and Tan Linchun to military commanders. | China | http://trove.nla.gov.au/newspaper/page/24102000 | 24102000 | |
| 45747 | 45747 | 1927-05-28 | 2 | f | Military education in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24102000 | 24102000 | |
| 45748 | 45748 | 1927-05-28 | 2 | f | Call for comprise in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24102000 | 24102000 | |
| 45749 | 45749 | 1927-05-28 | 3 | c | Zhang Zuolin is to set up a military government. | China | http://trove.nla.gov.au/newspaper/page/24101999 | 24101999 | |
| 45750 | 45750 | 1927-05-28 | 3 | c | Chinese embassy to London asks the Chinese people to remain quiet. | China | http://trove.nla.gov.au/newspaper/page/24101999 | 24101999 | |
| 45751 | 45751 | 1927-05-28 | 3 | c | Xu Shichang and Li Jinglin arrive Dalian, of Liaoning (Fengtian) province. | China | http://trove.nla.gov.au/newspaper/page/24101999 | 24101999 | |
| 45752 | 45752 | 1927-05-28 | 3 | d | Zhang Zhijiang dies in Wuyuan of the Northwest. | China | http://trove.nla.gov.au/newspaper/page/24101999 | 24101999 | |
| 45753 | 45753 | 1927-05-28 | 3 | d | Bi Shucheng is executed in Jinan, of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24101999 | 24101999 | |
| 45754 | 45754 | 1927-05-28 | 3 | d | Rong Zhen talks to journalists in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24101999 | 24101999 | |
| 45755 | 45755 | 1927-05-28 | 3 | e | The transportation of the Beijing-Hankou railway. | China | http://trove.nla.gov.au/newspaper/page/24101999 | 24101999 | |
| 45756 | 45756 | 1927-05-28 | 3 | f | Advertisement for the Chinese doctor Hang Hi, at 209 Thomas Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101999 | 24101999 | |
| 45757 | 45757 | 1927-05-28 | Supplement | One page | Chinese and English almanac of 1927, a supplement to the Tung Wah Times Chinese New Year edition. | Tung Wah | |||
| 45758 | 45758 | 1927-05-28 | 5 | a-c | Miscellaneous report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24102003 | 24102003 | |
| 45759 | 45759 | 1927-05-28 | 7 | a-b | Australia news/ Strike in Sydney following the sack of child labour. Australian federal government provides flour to the British troops in China. Prince Edward, Duke of York, leave Perth, Western Australia. New South Wales state government issues new regulations on the railway operation. News on the football match between Chinese and Australian teams. Expenses for the welcome of Prince Edward. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102004 | 24102004 | |
| 45760 | 45760 | 1927-05-28 | 7 | c-d | Students in Harvard University dies for love. | America | http://trove.nla.gov.au/newspaper/page/24102004 | 24102004 | |
| 45761 | 45761 | 1927-05-28 | 8 | a-d | Guangdong news/ Commercial chamber in Guangzhou to organise self-defence corps. Effort in Guangzhou to wipe out the Communists and the report. Effort in Dongguan county to wipe out the Communists. Municipal propaganda department prepares a book on the crimes of the Chinese communists. Bandits in Guangdong. Peasants' association in Gaoyao county. Businessmen in Hong Kong and the horse racing. Huizhou is now quiet after the suppression of the Communists. Order to arrest the Communist journalist in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24102007 | 24102007 |
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]);