This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 46527 | 46527 | 1927-12-10 | 2 | b-c | Editorial by Tung Wah Times on the economic struggle of the Chinese people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098624 | 24098624 | |
| 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 | |
| 46533 | 46533 | 1927-12-10 | 2 | f | Genghis Khan's grave found in Mongolia. | Germany | 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 | |
| 46542 | 46542 | 1927-12-10 | 5 | a | Floods in Algeria. | Britain | 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 | |
| 46544 | 46544 | 1927-12-10 | 5 | b | Japan wants to dispatch troops to north China once again. | Japan | 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 | |
| 46546 | 46546 | 1927-12-10 | 5 | b | Epidemic in India. | Other... | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
| 46547 | 46547 | 1927-12-10 | 5 | b | Train derails in Soviet Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
| 46548 | 46548 | 1927-12-10 | 5 | b | Relations between France and Italy. | France | 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 | ||
| 46550 | 46550 | 1927-12-10 | 5 | c | The Communist movement in Bulgaria. | Other... | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
| 46551 | 46551 | 1927-12-10 | 5 | c | Rich woman in America sells her ear. | America | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
| 46552 | 46552 | 1927-12-10 | 7 | a | Australia news/ New telephone to be used in Sydney. Potato price going up in Sydney. Burglary in the Sydney post office. Dwarf workers on strike in Sydney and the impacts. Dongqiao (Overseas Zengcheng natives) School to be opened in Kowloon, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098627 | 24098627 | |
| 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]);