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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
31554 | 31554 | 1916-09-09 | 3 | b-c | Japan's plan to divide China. | Japan | http://trove.nla.gov.au/newspaper/page/24095397 | 24095397 | |
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 | |
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 | |
31560 | 31560 | 1916-09-09 | 6 | c | Miscellaneous report on the officialdom in China. | China | http://trove.nla.gov.au/newspaper/page/24095402 | 24095402 | |
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 | |
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 | |
31555 | 31555 | 1916-09-09 | 3 | c-d | Japan's plan to divide China. | Japan | 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 | |
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 | |
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 | |
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 | |
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 | |
31558 | 31558 | 1916-09-09 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095397 | 24095397 |
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]);