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 |
---|---|---|---|---|---|---|---|---|---|
46558 | 46558 | 1927-12-17 | 2 | e | The truth of treaty talks between China and Holland. | China | http://trove.nla.gov.au/newspaper/page/24098632 | 24098632 | |
46573 | 46573 | 1927-12-17 | 5 | b | The Chinese Communist Party occupies Guangzhou and the report. | China | http://trove.nla.gov.au/newspaper/page/24098633 | 24098633 | |
46556 | 46556 | 1927-12-17 | 2 | c | Tang Shengzhi seeks alliance from the north (Zhang Zuolin). | China | http://trove.nla.gov.au/newspaper/page/24098632 | 24098632 | |
46559 | 46559 | 1927-12-17 | 2 | e | Tang Shengzhi and his real force. | China | http://trove.nla.gov.au/newspaper/page/24098632 | 24098632 | |
46561 | 46561 | 1927-12-17 | 3 | b | Soviet Russian ambassador in France is also a communist instigator. | France | http://trove.nla.gov.au/newspaper/page/24098631 | 24098631 | |
46566 | 46566 | 1927-12-17 | 3 | e | Russian refugees attack the Soviet Russian consulate in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098631 | 24098631 | |
46571 | 46571 | 1927-12-17 | 5 | a | Policies of the Soviet Russian Communist Party. | Britain | http://trove.nla.gov.au/newspaper/page/24098633 | 24098633 | |
46572 | 46572 | 1927-12-17 | 5 | b | New Ford cars manufactured. | America | http://trove.nla.gov.au/newspaper/page/24098633 | 24098633 | |
46570 | 46570 | 1927-12-17 | 5 | a | Manager of the railway in south Manchuria denies effort to borrow loans from America. | Japan | http://trove.nla.gov.au/newspaper/page/24098633 | 24098633 | |
46576 | 46576 | 1927-12-17 | 7 | a | King of Afghanistan to tour Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24098635 | 24098635 | |
46569 | 46569 | 1927-12-17 | 5 | a | Japanese cabinet has finalised its China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24098633 | 24098633 | |
46565 | 46565 | 1927-12-17 | 3 | e | He Chengrui and Wei Daofeng try again to mediate the conflict between Zhang Zuolin and Yan Xishan. | China | http://trove.nla.gov.au/newspaper/page/24098631 | 24098631 | |
46575 | 46575 | 1927-12-17 | 7 | a | Hatred towards Chinese labourers in Korea. Japanese newspaper ridicule American President. | Japan | http://trove.nla.gov.au/newspaper/page/24098635 | 24098635 | |
46578 | 46578 | 1927-12-17 | 7 | b-c | Guangdong news/ Riots on rice in Zhongshan county. Road construction in Shunde county. | China | http://trove.nla.gov.au/newspaper/page/24098635 | 24098635 | |
46579 | 46579 | 1927-12-17 | 8 | a-d | Guangdong news/ Dai Jitao and Zhu Jiaji in Shanghai encourage the students of Zhongshan University to concentrate on their study. Provincial authority tries to guide the labour movement in Guangdong. Request to suppress the Communist forces in Dongguan county. Representatives of the Hainan island request help to suppress bandits. Provincial judicial authority replies to Qingyuan county on the trial of raping cases. Women association in Guangzhou requests to rehabilitate political prisoners. Official report on the financial situation in Guangdong. Provincial authority to take back French consulate and build a park. Join defence strategies in Huizhou and Boluo counties. Huangpu Military Academy changes name. Rice businessmen request to cancel some taxes. | China | http://trove.nla.gov.au/newspaper/page/24098638 | 24098638 | |
46555 | 46555 | 1927-12-17 | 2 | b | First part of translation from Sydney Morning Herald on the progress in Manchuria. | Australia | http://trove.nla.gov.au/newspaper/page/24098632 | 24098632 | |
46577 | 46577 | 1927-12-17 | 7 | a | Feng Yuxiang's army attack Xuzhou, north Jiangsu province, but are defeated. Fierce battle in Guangzhou. Strike in Guangzhou. The Chinese Communist Party and their Communist policy. | China | http://trove.nla.gov.au/newspaper/page/24098635 | 24098635 | |
46557 | 46557 | 1927-12-17 | 2 | d | Discussions in the White House, Washington, on the Chinese issues (two governments in the north and in the south, and others). | America | http://trove.nla.gov.au/newspaper/page/24098632 | 24098632 | |
46563 | 46563 | 1927-12-17 | 3 | d | Cooperation between Wu Peifu and Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098631 | 24098631 | |
46568 | 46568 | 1927-12-17 | 5 | a | Clash between bandits and police in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098633 | 24098633 | |
46564 | 46564 | 1927-12-17 | 3 | d | Britain, France and other countries support the Chinese government to collect tax on luxurious goods. | China | http://trove.nla.gov.au/newspaper/page/24098631 | 24098631 | |
46560 | 46560 | 1927-12-17 | 2 | f | Bomb found on the railway from Fengtian to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24098632 | 24098632 | |
46574 | 46574 | 1927-12-17 | 7 | a | Australia news/ Timely rain in Queensland. Chinese man is beaten in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098635 | 24098635 | |
46562 | 46562 | 1927-12-17 | 3 | c | Another war to break out in Guizhou and Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24098631 | 24098631 | |
46567 | 46567 | 1927-12-17 | 3 | a | Advertisement for Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098631 | 24098631 |
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]);