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 |
---|---|---|---|---|---|---|---|---|---|
46581 | 46581 | 1927-12-24 | 2 | c | People in Dingzhou, of Shanxi province, suffer from the disasters of war. | China | http://trove.nla.gov.au/newspaper/page/24098640 | 24098640 | |
46582 | 46582 | 1927-12-24 | 2 | d | Hunan provincial authority to unify management of Buddhist temples and properties. | China | http://trove.nla.gov.au/newspaper/page/24098640 | 24098640 | |
46583 | 46583 | 1927-12-24 | 2 | e | A speech by Zou Lu on the Party policies. | China | http://trove.nla.gov.au/newspaper/page/24098640 | 24098640 | |
46584 | 46584 | 1927-12-24 | 2 | e | Russian refugees in Jinan, of Shandong province, organise an anti-Communist association and the report. | China | http://trove.nla.gov.au/newspaper/page/24098640 | 24098640 | |
46586 | 46586 | 1927-12-24 | 3 | b | Progress of textile industry in Shanghai and the survey. | China | http://trove.nla.gov.au/newspaper/page/24098639 | 24098639 | |
46589 | 46589 | 1927-12-24 | 3 | c | Japan and America compete with each other for the control of radio communications in China. | China | http://trove.nla.gov.au/newspaper/page/24098639 | 24098639 | |
46590 | 46590 | 1927-12-24 | 3 | d | Zhang Zuolin's army attack Datong, of Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24098639 | 24098639 | |
46591 | 46591 | 1927-12-24 | 3 | e | Soviet Russia totally controls the railway construction in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24098639 | 24098639 | |
46592 | 46592 | 1927-12-24 | 3 | e | American ambassador in Beijing on the nationalist movement in China and the influence of Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24098639 | 24098639 | |
46593 | 46593 | 1927-12-24 | 5 | a | The Nationalist Party decides to ask Jiang Jieshi to be the military commander-in-chief again. British soldiers in Shanghai shoot Chinese children. | China | http://trove.nla.gov.au/newspaper/page/24098641 | 24098641 | |
46596 | 46596 | 1927-12-24 | 5 | a | Li Fulin repulses the Communists from Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098641 | 24098641 | |
46598 | 46598 | 1927-12-24 | 5 | b | The Nationalist troops in Shanghai search the Communists and the report. The Guangzhou after the disaster of war and the Communist retreat. | China | http://trove.nla.gov.au/newspaper/page/24098641 | 24098641 | |
46602 | 46602 | 1927-12-24 | 7 | b | Many Russian people (mainly diplomatic personnel) are leaving China. | China | http://trove.nla.gov.au/newspaper/page/24098643 | 24098643 | |
46604 | 46604 | 1927-12-24 | 8 | a-d | Guangdong news/ Yu Cai is kidnapped in broad daylight. Clan feud and fighting in Changping town, of Dongguan county. A case of murder in Xinhui county. Village robbed in Dongguan county. Defence conference in Taishan for the winter time. Robbery in Heyuan county. A pity woman in Chenghai county. Business in Foshan this year. Bandits rob villages in Zengcheng county. New tax in Xinhui county. Bandits in Shunde control the opium smuggling. | China | http://trove.nla.gov.au/newspaper/page/24098646 | 24098646 |
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]);