This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46614 | 46614 | 1927-12-31 | 5 | a | Documents found in Soviet Russian consulate in Guangzhou about their communist propaganda. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46615 | 46615 | 1927-12-31 | 5 | a | Shandong provincial authority confiscates British goods and the negotiations. | Britain | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46616 | 46616 | 1927-12-31 | 5 | a | Rumours say Japanese seek to take over the railway line in Shandong province from Jiaozhou to Jinan. | Japan | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46617 | 46617 | 1927-12-31 | 5 | a | Tang Shengzhi is besieged by Chinese students in Japan. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46618 | 46618 | 1927-12-31 | 5 | a | A declaration issued by Wu Chaoshu, foreign minister of the Nationalist government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46619 | 46619 | 1927-12-31 | 5 | b | Feng Yuxiang asks Jiang Jieshi to resume to his post of commander. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46620 | 46620 | 1927-12-31 | 5 | b | Japanese planning to invade Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46621 | 46621 | 1927-12-31 | 5 | b | Tan Yankai condemns Zhang Zuolin and the telegram. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46622 | 46622 | 1927-12-31 | 5 | b | Wu Peifu is wanted by the military committee in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 | |
46623 | 46623 | 1927-12-31 | 5 | b | Feng Yuxiang's army enter Shanxi province. Hu Hanmin is negative. Dramatic changes in Changsha, Hunan province. Military news from various warlords in China. Bai Chongxi delivers a speech in Wuhan. Yan Xishan and his military arrangement. Tan Yankai reports on Guangdong situations and the Northern Expedition. The Communists make trouble again in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098649 | 24098649 |
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]);