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 |
|---|---|---|---|---|---|---|---|---|---|
| 46580 | 46580 | 1927-12-24 | 2 | b | Second and final part of translation from Sydney Morning Herald on the progress in Manchuria. | Australia | http://trove.nla.gov.au/newspaper/page/24098640 | 24098640 | |
| 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 | |
| 46585 | 46585 | 1927-12-24 | 2 | f | Food shortage in Japan and their solutions. | Japan | 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 | |
| 46587 | 46587 | 1927-12-24 | 3 | b | German scientist predicts natural disasters. | Germany | http://trove.nla.gov.au/newspaper/page/24098639 | 24098639 | |
| 46588 | 46588 | 1927-12-24 | 3 | b | Japanese reveals Soviet Russian's secret plan for the Siberian railway. | Japan | 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 | |
| 46594 | 46594 | 1927-12-24 | 5 | a | The Chinese Communists in Hankou. | Britain | http://trove.nla.gov.au/newspaper/page/24098641 | 24098641 | |
| 46595 | 46595 | 1927-12-24 | 5 | a | Japan seeks to expand its air force. | Japan | 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 | |
| 46597 | 46597 | 1927-12-24 | 5 | b | Labour Party MPs in the House of Commons request to withdraw their troops from China. | Britain | 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 | |
| 46599 | 46599 | 1927-12-24 | 7 | a | Australia news/ Population increase in Australia. Federal government in Canberra on the chaos in Guangdong. Electricity office in Melbourne on fire. Illegal Chinese immigrants are going back by liner Taiping. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098643 | 24098643 | |
| 46600 | 46600 | 1927-12-24 | 7 | a | Anti-Chinese movement in Korea. | Japan | http://trove.nla.gov.au/newspaper/page/24098643 | 24098643 | |
| 46601 | 46601 | 1927-12-24 | 7 | b | Japanese authority refuses to grant visa to Wang Jingwei. | Japan | http://trove.nla.gov.au/newspaper/page/24098643 | 24098643 | |
| 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 | |
| 46603 | 46603 | 1927-12-24 | 7 | c | Letter in praise of noble characters of Wei Zijing, Chinese Consul-General in Australia, written by Li Fen, Li Bo, Wu Fu and others. | Tung Wah | 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]);