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 |
---|---|---|---|---|---|---|---|---|---|
32433 | 32433 | 1917-07-07 | 2 | c-d | Liang Qichao on China's foreign polocy. | China | http://trove.nla.gov.au/newspaper/page/24095753 | 24095753 | |
32434 | 32434 | 1917-07-07 | 2 | d-e | Open letter from some ordinary people to the Chinese parliament and urge them to declare war with Germany. | China | http://trove.nla.gov.au/newspaper/page/24095753 | 24095753 | |
32435 | 32435 | 1917-07-07 | 2 | e-f | Some activists are arrested in Beijing for their protest and harassment in the Chinese parliament. | China | http://trove.nla.gov.au/newspaper/page/24095753 | 24095753 | |
32436 | 32436 | 1917-07-07 | 2 | f | Corruption in the transportation administration in China. | China | http://trove.nla.gov.au/newspaper/page/24095753 | 24095753 | |
32437 | 32437 | 1917-07-07 | 3 | a-b | Dispute and fighting between Luo Peijin and Liu Cunhou in Sichuan province, and the investigation by Wang Renwen, an envoy from the Central Government in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24095752 | 24095752 | |
32438 | 32438 | 1917-07-07 | 3 | d | A conference in Shandong province on local administration, China's relations with Japan, and the issues of local legislature assembly. | China | http://trove.nla.gov.au/newspaper/page/24095752 | 24095752 | |
32439 | 32439 | 1917-07-07 | 3 | c-d | Zhang Zuolin's troops in Manchuria and Mongolia have fighting with Japanese soldiers. | China | http://trove.nla.gov.au/newspaper/page/24095752 | 24095752 | |
32440 | 32440 | 1917-07-07 | 3 | d | Opium businessmen in Shanghai are in panic. | China | http://trove.nla.gov.au/newspaper/page/24095752 | 24095752 | |
32441 | 32441 | 1917-07-07 | 3 | d | Representatives of the Guangzhou-Hankou railway gather in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24095752 | 24095752 | |
32442 | 32442 | 1917-07-07 | 3 | d-e | Investigation on the corruption charges in the Chinese Ministry of Transportation. | China | http://trove.nla.gov.au/newspaper/page/24095752 | 24095752 | |
32443 | 32443 | 1917-07-07 | 3 | e | British government bans entry of Chinese tea and the negotiation in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24095752 | 24095752 | |
32453 | 32453 | 1917-07-07 | 8 | a-b | Beijing news/ The three factions in the Chinese parliament. Senate debates China's foreign policy. Feng Guozhang is ill for a few months. The constitution conference is cancelled. A circular telegram from Liu Cunhou in Sichuan province. Chinese government refuses to permit rice export by a foreign businessman. | China | http://trove.nla.gov.au/newspaper/page/24095759 | 24095759 | |
32454 | 32454 | 1917-07-07 | 8 | b-e | Guangdong news/ Overspending of the provincial government and the reason. Number of security troops in Guangzhou. Provincial government on the stamp duties on rice sales. Governor orders investigation on the looting by government troops in Xiangshan county. Police office set up in Mailizhou, of Dongguan county. Complaint from Shilong businessmen on heavy tax for dry fish. Monument status to be erected in Xiangshan county for martyrs. Tax on ox skins in Qingyuan county. Another robbery in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24095759 | 24095759 |
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]);