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 |
---|---|---|---|---|---|---|---|---|---|
32681 | 32681 | 1917-11-17 | 2 | e-f | Officials of the foreign affairs ministry in Beijing talks to journalist on China's diplomacy and others. | China | http://trove.nla.gov.au/newspaper/page/24095908 | 24095908 | |
32682 | 32682 | 1917-11-17 | 3 | a | China seeks to take back Qingdao, of Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24095907 | 24095907 | |
32683 | 32683 | 1917-11-17 | 3 | a-b | Further report on Zhang Xun and his restoration movement. | China | http://trove.nla.gov.au/newspaper/page/24095907 | 24095907 | |
32684 | 32684 | 1917-11-17 | 3 | b-c | Achievements of the immigration and land cultivation in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24095907 | 24095907 | |
32685 | 32685 | 1917-11-17 | 3 | c | The court hearing on the case of Zhang Zhenfang (for traitor and opium-smoking). | China | http://trove.nla.gov.au/newspaper/page/24095907 | 24095907 | |
32689 | 32689 | 1917-11-17 | 6 | b-c | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24095912 | 24095912 | |
32698 | 32698 | 1917-11-17 | 8 | a-c | Beijing news/ Warrant issued by Beijing police authority to the capture of Sun Yatsen. Troops moved from Shandong province to the south. Hunan province declares independence and the responses of the central government in Beijing. Liu Xianshi attacks Liu Cunhou once again. The central government in Beijing consults Guangdong on the troops dispatched to Europe. The wartime conference in Beijing and its discussions. American government refunds some of the Boxer Indemnity. | China | http://trove.nla.gov.au/newspaper/page/24095914 | 24095914 | |
32699 | 32699 | 1917-11-17 | 8 | c-d | Guangdong news/ Naval forces in Guangdong. Mo Qingyu and his talks with the naval commanders. Yang Jindong returns to Guangzhou from Hong Kong. Sun Yatsen and his ambitions. Vietnamese authority refuses to give in to Yunnan army. Stamp duties apply to pawn business and the acts. Drought in Gaoyao county. A military conference in the cement factory, Guangzhou, convened by Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24095914 | 24095914 |
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]);