This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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]);