This data as json, CSV (advanced)
Suggested facets: page, column, description, source, page_url, trove_id, date (date)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31567 | 31567 | 1916-09-09 | 8 | b-e | Guangdong news/ Yang Jindong asks Tang Jiyao to help solve the Guangdong problems. Long Jiguang in Guangzhou. Bandits in Xiangshan county. Liang Shiyi sells his companies. Long Jiguang's troops attack Shilong. Bandits in Xinhui county hijack a train. Bandits in Dongjiang River area, Dongguan and Panyu county. | China | http://trove.nla.gov.au/newspaper/page/24095403 | 24095403 | |
31566 | 31566 | 1916-09-09 | 8 | a-b | Beijing news/ Sitting of the parliament in Beijing, the budget, and the qualifications of members. Tang Jiyao on the current situations in Beijing. Chen Jintao to borrow more money from overseas. Li Kaishen and Wang Pengnian are leaving Beijing for Guangdong on the mission of mediation. | China | http://trove.nla.gov.au/newspaper/page/24095403 | 24095403 | |
31565 | 31565 | 1916-09-09 | 7 | d-e | Advertisement for The Sun Company Ltd, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095401 | 24095401 | |
31564 | 31564 | 1916-09-09 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095401 | 24095401 | |
31563 | 31563 | 1916-09-09 | 7 | b-c | Correspondence from Zengcheng county, Guangdong, claims that Zengcheng has turned into the hell. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095401 | 24095401 | |
31562 | 31562 | 1916-09-09 | 7 | b | Japan's four demands from China to solve the clash near Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24095401 | 24095401 | |
31561 | 31561 | 1916-09-09 | 7 | a | A white young man in Sydney is sentenced to death for shooting at Chinese which caused one death and two injuries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095401 | 24095401 | |
31560 | 31560 | 1916-09-09 | 6 | c | Miscellaneous report on the officialdom in China. | China | http://trove.nla.gov.au/newspaper/page/24095402 | 24095402 | |
31559 | 31559 | 1916-09-09 | 6 | a-c | Qin Chunxuan's open letter to the provincial legislature assembly on the crimes of Long Jiguang. Some members of the Guangdong provincial legislature assembly request to denounce Long Jiguang and their circular telegram. | China | http://trove.nla.gov.au/newspaper/page/24095402 | 24095402 | |
31558 | 31558 | 1916-09-09 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095397 | 24095397 | |
31557 | 31557 | 1916-09-09 | 3 | d | Cai E, Lu Rongting and Chen Bingkun suggest to close the Military Academy in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24095397 | 24095397 | |
31556 | 31556 | 1916-09-09 | 3 | c-d | Freedom of speech is back in China and the newspaper publishing. | China | http://trove.nla.gov.au/newspaper/page/24095397 | 24095397 | |
31555 | 31555 | 1916-09-09 | 3 | c-d | Japan's plan to divide China. | Japan | http://trove.nla.gov.au/newspaper/page/24095397 | 24095397 | |
31554 | 31554 | 1916-09-09 | 3 | b-c | Japan's plan to divide China. | Japan | http://trove.nla.gov.au/newspaper/page/24095397 | 24095397 | |
31553 | 31553 | 1916-09-09 | 2 | e-f | Recent appointments and removal of local government officials in China. | China | http://trove.nla.gov.au/newspaper/page/24095398 | 24095398 | |
31552 | 31552 | 1916-09-09 | 2 | d-e | New disputes between the south and the north in China. | China | http://trove.nla.gov.au/newspaper/page/24095398 | 24095398 | |
31551 | 31551 | 1916-09-09 | 2 | c-d | Orders issued by the Chinese President Li Yuanhong. | China | http://trove.nla.gov.au/newspaper/page/24095398 | 24095398 | |
31550 | 31550 | 1916-09-09 | 2 | a-c | Editorial on the peaceful solution to the Guangdong problems. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095398 | 24095398 |
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]);