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