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 |
|---|---|---|---|---|---|---|---|---|---|
| 46699 | 46699 | 1928-02-04 | 2 | b-c | An article selected from Chicago Tribune says America should not maintain its privileges in China by force, and should seek friendship relations with China. | America | http://trove.nla.gov.au/newspaper/page/24098680 | 24098680 | |
| 46700 | 46700 | 1928-02-04 | 2 | c | Relief work in Guangdong after the Communist disasters. | China | http://trove.nla.gov.au/newspaper/page/24098680 | 24098680 | |
| 46701 | 46701 | 1928-02-04 | 2 | d-f | The Communist forces attack Changsha, capital of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098680 | 24098680 | |
| 46702 | 46702 | 1928-02-04 | 2 | f | The Nationalist government in Nanjing starts new military system. | China | http://trove.nla.gov.au/newspaper/page/24098680 | 24098680 | |
| 46703 | 46703 | 1928-02-04 | 3 | b-d | Detailed report on the anti-Chinese movement in Korea. | Other... | http://trove.nla.gov.au/newspaper/page/24098679 | 24098679 | |
| 46704 | 46704 | 1928-02-04 | 3 | d | Japan fails to borrow loans from America. | Japan | http://trove.nla.gov.au/newspaper/page/24098679 | 24098679 | |
| 46705 | 46705 | 1928-02-04 | 3 | e | The amount and usage of Boxer Indemnity China has paid to France and the detailed report. | China | http://trove.nla.gov.au/newspaper/page/24098679 | 24098679 | |
| 46706 | 46706 | 1928-02-04 | 3 | f | The Nationalist army take over Xuzhou, Jiangsu province, and a meeting of Zhang Zongchang, Sun Chuanfang and Chu Yupu in Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098679 | 24098679 | |
| 46707 | 46707 | 1928-02-04 | 5 | a | The Communists in Guangzhou is planning another rebellion. Foreign powers to ask the Nationalist government in Nanjing to suppress bandits seriously. Farewell to British military commander in Shanghai. Warlords in north China purchase large numbers of weapons from overseas and the report. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098681 | 24098681 | |
| 46708 | 46708 | 1928-02-04 | 5 | b | Troops in Moscow and their mutiny. | Britain | http://trove.nla.gov.au/newspaper/page/24098681 | 24098681 | |
| 46709 | 46709 | 1928-02-04 | 5 | b-c | Soviet Russian consuls are leaving China. The execution of Zhan Dabei and Li Hanjun in Shanghai. Duan Qirui seeks to mediate the conflict between Yan Xishan and Zhang Zuolin. Progress of the Northern Expedition. | China | http://trove.nla.gov.au/newspaper/page/24098681 | 24098681 | |
| 46710 | 46710 | 1928-02-04 | 5 | d | Advertisement for Assurance Homes of Australia Ltd, the investment of the century, in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098681 | 24098681 | |
| 46711 | 46711 | 1928-02-04 | 7 | a | A notice issued by Miu Huili to resign from the position of director of the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098683 | 24098683 | |
| 46712 | 46712 | 1928-02-04 | 7 | a | A meeting notice by the Dongguan and Zengcheng lian yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098683 | 24098683 | |
| 46713 | 46713 | 1928-02-04 | 7 | a | Australia news/ Agricultural research helps the harvest this year. Two prisoners escape from a New South Wales prison. Advertisement for Assurance Homes of Australia Ltd. Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098683 | 24098683 | |
| 46714 | 46714 | 1928-02-04 | 7 | a | Ye Tonggui, Chen Yin and other Chinese businessmen in Sydney help to set up a high-level Chinese school in their home town, Zengcheng, which is named dong qiao xue xiao (Eastern Overseas Chinese School), and its regulations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098683 | 24098683 | |
| 46715 | 46715 | 1928-02-04 | 8 | a-d | Guangdong news/ Bandits in Guangdong. Bandits bomb cargo ships. Longxi Commune of Nanhai county reports the Communist disasters. Road construction in Taishan county. The Communist bandits in Haifeng county rob grains. Mai Yingchang becomes magistrate of Xinhui county. Evils of communists in Meixian county. Peasants' association in Zhongshan county attack civil corps. | China | http://trove.nla.gov.au/newspaper/page/24098686 | 24098686 |
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]);