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 |
---|---|---|---|---|---|---|---|---|---|
45636 | 45636 | 1927-04-23 | 2 | d | Telegram from Zhang Zuolin to Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24101956 | 24101956 | |
45637 | 45637 | 1927-04-23 | 2 | d | Britain returns its concessions in Tianjin to the Chinese government and the talks. | China | http://trove.nla.gov.au/newspaper/page/24101956 | 24101956 | |
45638 | 45638 | 1927-04-23 | 2 | e | The power of Chinese naval fleet in Bohai Sea. | China | http://trove.nla.gov.au/newspaper/page/24101956 | 24101956 | |
45639 | 45639 | 1927-04-23 | 2 | f | Russian ship Lenin is detained by Chinese authority and now transportation ship. | China | http://trove.nla.gov.au/newspaper/page/24101956 | 24101956 | |
45640 | 45640 | 1927-04-23 | 2 | f | Zhang Zuolin to issue a declaration on Jiang Jieshi (Chiang Kai-shek). | China | http://trove.nla.gov.au/newspaper/page/24101956 | 24101956 | |
45641 | 45641 | 1927-04-23 | 3 | b | China's effort to revise treaties with Japan, France and Belgium and the progress. | China | http://trove.nla.gov.au/newspaper/page/24101955 | 24101955 | |
45642 | 45642 | 1927-04-23 | 3 | c | Chinese ambassadors are returning from overseas due to budget shortage. | China | http://trove.nla.gov.au/newspaper/page/24101955 | 24101955 | |
45643 | 45643 | 1927-04-23 | 3 | c | Governor of Anhui province Gao Shidu is killed by Sun Dianying. | China | http://trove.nla.gov.au/newspaper/page/24101955 | 24101955 | |
45644 | 45644 | 1927-04-23 | 3 | d | Japanese and American forces in Nanyang. | China | http://trove.nla.gov.au/newspaper/page/24101955 | 24101955 | |
45645 | 45645 | 1927-04-23 | 3 | d | Chinese ambassador to Japan Wang Rongbao reports his talks with Thailand on the treaty issues. | China | http://trove.nla.gov.au/newspaper/page/24101955 | 24101955 | |
45646 | 45646 | 1927-04-23 | 3 | d | Chinese in Cuba report the detainment and their sufferings. | China | http://trove.nla.gov.au/newspaper/page/24101955 | 24101955 | |
45648 | 45648 | 1927-04-23 | 3 | f | Foreign missions in Beijing on the defence in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101955 | 24101955 | |
45649 | 45649 | 1927-04-23 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101957 | 24101957 | |
45652 | 45652 | 1927-04-23 | 8 | a-d | Guangdong news/ Local judges under investigation in Guangdong. Public Security Bureau and the liberation of women in Guangzhou. Guangdong pays army provisions and the burden. Number of the Nationalist troops in Guangdong after the Northern Expedition. Health authority in Guangzhou issues new requirements for medical examination for prostitutes. Fan Shisheng is ordered to postpone his entry into Yunnan province. Provincial peasants' association in Guangdong. Fighting between bandits and troops in Guangdong. Bribery and protest representatives in Taishan county. Bandits in Xinxing and Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24101962 | 24101962 |
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]);