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 |
---|---|---|---|---|---|---|---|---|---|
46805 | 46805 | 1928-03-03 | 8 | a-d | Guangdong news/ Security tax to be collected for the next three months. Even Russian refugees are driven out of Guangzhou after the Communist disaster. Former provincial treasurer Chen Rong and the new treasurer Feng Zhuwan. Villagers organise self-defence corps against bandits. Zhu Zhaoxin is still active and the reason. Three bombs found in Guanyin Mountain near Guangzhou. Naval warship Haiqi arrives Guangdong. Storm in Yaxian, Hainan island, and the damages. | China | http://trove.nla.gov.au/newspaper/page/24098718 | 24098718 | |
46804 | 46804 | 1928-03-03 | 7 | b-c | Australia news/ Demonstration in Sydney of the unemployed people. Burglaries in Sydney. Australia exports sandalwood to China and the survey. A fishing boat nearly sinks near New Zealand. A Chinese furniture factory in Alexandria is penalised for illegal operation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46803 | 46803 | 1928-03-03 | 7 | b | Arrest in America for diamond smuggling. | America | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46802 | 46802 | 1928-03-03 | 7 | b | The Communist force in the east of Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46801 | 46801 | 1928-03-03 | 7 | a | Bandits in Chicago hijack train. | America | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46800 | 46800 | 1928-03-03 | 7 | a | Value of gold in the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46799 | 46799 | 1928-03-03 | 7 | a | British authority arrests illegal Chinese immigrants. | Britain | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46798 | 46798 | 1928-03-03 | 7 | a | Counterfeit bank notes in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46797 | 46797 | 1928-03-03 | 7 | a | Number of unemployed workers in America. | America | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46796 | 46796 | 1928-03-03 | 5 | a | Second part of the report on various business activities in Guangzhou last year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098713 | 24098713 | |
46795 | 46795 | 1928-03-03 | 3 | e | Miu Bin reports the shortage of army provisions. | China | http://trove.nla.gov.au/newspaper/page/24098711 | 24098711 | |
46794 | 46794 | 1928-03-03 | 3 | d | American's view on China and the social observation. | America | http://trove.nla.gov.au/newspaper/page/24098711 | 24098711 | |
46793 | 46793 | 1928-03-03 | 3 | c | News from Moscow (restrictions on the entry of foreigners, market in Moscow, people's clothes, food price, etc). | France | http://trove.nla.gov.au/newspaper/page/24098711 | 24098711 | |
46792 | 46792 | 1928-03-03 | 3 | b | All communists are eliminated in Wuhan and the report. | China | http://trove.nla.gov.au/newspaper/page/24098711 | 24098711 | |
46791 | 46791 | 1928-03-03 | 2 | f | Chaos in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24098712 | 24098712 | |
46790 | 46790 | 1928-03-03 | 2 | d | Farewell message by Dai Jitao on his tour to Europe for education research. | China | http://trove.nla.gov.au/newspaper/page/24098712 | 24098712 | |
46789 | 46789 | 1928-03-03 | 2 | d | Sun Chuanfang's spies in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098712 | 24098712 | |
46788 | 46788 | 1928-03-03 | 2 | c | Both Zhu Xia and Yang Zhu support Jiang Jieshi. All trade unions in Wuhan are disbanded. | China | http://trove.nla.gov.au/newspaper/page/24098712 | 24098712 | |
46787 | 46787 | 1928-03-03 | 2 | c | Bai Chongxi comments on Jiang Jieshi after his back to the office. | China | http://trove.nla.gov.au/newspaper/page/24098712 | 24098712 | |
46786 | 46786 | 1928-03-03 | 2 | b | Second and final part of the article written by Guo Shaozong on Japan's privileges in Manchuria and Mongolia and their negotiations with China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098712 | 24098712 |
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]);