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 |
---|---|---|---|---|---|---|---|---|---|
46528 | 46528 | 1927-12-10 | 2 | c | The Communists in Hunan province and the assistance of Soviet Russian consulate. Hunan provincial authority requests Soviet Russian consul to leave. Negotiation in Hunan on the gasoline company. | China | http://trove.nla.gov.au/newspaper/page/24098624 | 24098624 | |
46529 | 46529 | 1927-12-10 | 2 | d | He Baofang, wife of foreign minister Wu Chaoshu, is detained in Tianjin and the report. | China | http://trove.nla.gov.au/newspaper/page/24098624 | 24098624 | |
46530 | 46530 | 1927-12-10 | 2 | e | Bandits in Shanghai kidnap in day time. | China | http://trove.nla.gov.au/newspaper/page/24098624 | 24098624 | |
46531 | 46531 | 1927-12-10 | 2 | f | The Nationalist government in Nanjing and Tang Shengzhi. | China | http://trove.nla.gov.au/newspaper/page/24098624 | 24098624 | |
46532 | 46532 | 1927-12-10 | 2 | f | Zheng Yuxiu to tour Europe as envoy of the Nationalist government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098624 | 24098624 | |
46534 | 46534 | 1927-12-10 | 3 | b | Fierce battle between bandits and troops in Jiaozhou peninsula, Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098623 | 24098623 | |
46535 | 46535 | 1927-12-10 | 3 | b | Japanese consul in Fengtian and his demands. | China | http://trove.nla.gov.au/newspaper/page/24098623 | 24098623 | |
46536 | 46536 | 1927-12-10 | 3 | c | An opinion on the case of Mei Lanfang in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098623 | 24098623 | |
46537 | 46537 | 1927-12-10 | 3 | d | Survey on gold mines in Fengtian province. | China | http://trove.nla.gov.au/newspaper/page/24098623 | 24098623 | |
46538 | 46538 | 1927-12-10 | 3 | e | Soviet Russia has outlined their new strategies in China. Borodin is appointed adviser of the Mongolian troops. | China | http://trove.nla.gov.au/newspaper/page/24098623 | 24098623 | |
46539 | 46539 | 1927-12-10 | 3 | e | Tang Shengzhi has envoy in Beijing for liaison with Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098623 | 24098623 | |
46540 | 46540 | 1927-12-10 | 3 | f | Theatre in Zhabei, Shanghai, collapses. | China | http://trove.nla.gov.au/newspaper/page/24098623 | 24098623 | |
46541 | 46541 | 1927-12-10 | 5 | a | Yang Yuting is against the loans for the railway construction in south Manchuria. Foreigners in Shanghai request to wipe out the Communists. | China | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
46543 | 46543 | 1927-12-10 | 5 | a | Tram stops in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
46545 | 46545 | 1927-12-10 | 5 | b | Pirates kidnap Britain captain near Yichang, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
46549 | 46549 | 1927-12-10 | 5 | Social security in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | ||
46553 | 46553 | 1927-12-10 | 7 | b | Guangdong news/ Road construction in Xinhui county. House maids to be liberated. People and gentry in Xinhui county ask for military protection during the harvest time. | China | http://trove.nla.gov.au/newspaper/page/24098627 | 24098627 | |
46554 | 46554 | 1927-12-10 | 8 | a-d | Guangdong news/ A plan to wipe out all bandits in Guangdong. Warning to those people who want to immigrate to Peru in South America. Decision to replace county magistrates. The Communist disasters in Haifeng and Lufeng county. Beggars in Guangzhou to be housed. Economic commission of Guangdong and Guangxi province and their functions. Bandits murder in Nanti. | China | http://trove.nla.gov.au/newspaper/page/24098630 | 24098630 |
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]);