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 |
---|---|---|---|---|---|---|---|---|---|
33162 | 33162 | 1918-04-06 | 2 | f | Government troops from the north are defeated in Yuezhou, Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24097240 | 24097240 | |
33163 | 33163 | 1918-04-06 | 3 | a-b | Hubei provincial authorities and their negotiation with Hanyeping (Hanyang, Daye and Pingxiang) Iron and Steel Company. | China | http://trove.nla.gov.au/newspaper/page/24097239 | 24097239 | |
33164 | 33164 | 1918-04-06 | 3 | b-c | Xiong Xiling comments on the current situations in China in his correspondence with Qin Chunxuan. | China | http://trove.nla.gov.au/newspaper/page/24097239 | 24097239 | |
33165 | 33165 | 1918-04-06 | 3 | c-d | Li Tiancai executes Ji Yulin and the report. | China | http://trove.nla.gov.au/newspaper/page/24097239 | 24097239 | |
33166 | 33166 | 1918-04-06 | 3 | d | Chinese President Feng Guozhang talks to Japanese military officer in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24097239 | 24097239 | |
33167 | 33167 | 1918-04-06 | 3 | d-e | An exhibition of antiquities in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24097239 | 24097239 | |
33180 | 33180 | 1918-04-06 | 8 | a-b | Beijing news/ President Feng Guozhang orders to prepare for the establishment of new national parliament. China's negotiation with Russia and Japan over the railway in Manchuria. Premier Wang Shizhen resigns. Government troops from the north gather in Hubei province. Japan may take over the railways in Manchuria. President Feng Guozhang still seeks mediation over the north-south conflicts. Zhang Zuolin withholds some weapons from the government side. Cao Kun and Zhang Jingyao agree to stop fighting. Military governor of Hubei province Wang Zhanyuan seeks truce. Feng Yuxiang betrays the central government. Liu Chunhou starts peace talks with the troops from the south. | China | http://trove.nla.gov.au/newspaper/page/24097246 | 24097246 | |
33181 | 33181 | 1918-04-06 | 8 | b-d | Guangdong news/ Lu Rongting seeks suggestions for peace. Tan Haoming sends telegram to Li Chun. Long Jiguang's telegram to Beijing. War clouds over Fujian and Guangdong province. Earthquake in Guangdong. War in Dianbai and Dapu counties. Chen Bingkun and Shen Hongying start a joint attach on Long Jiguang. Bandits in Kaiping county and the magistrate. Mo Rongxin seeks to take some salt tax. Women in Guangzhou sell clothes for disaster relief. Fire in Foshan. Hu Hanqing reports his fighting with Long Jiguang. Tan Haoming to collect weapons in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24097246 | 24097246 |
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]);