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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
46803 | 46803 | 1928-03-03 | 7 | b | Arrest in America for diamond smuggling. | America | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
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 | |
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 | |
46801 | 46801 | 1928-03-03 | 7 | a | Bandits in Chicago hijack train. | America | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
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 | |
46799 | 46799 | 1928-03-03 | 7 | a | British authority arrests illegal Chinese immigrants. | Britain | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
46791 | 46791 | 1928-03-03 | 2 | f | Chaos in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24098712 | 24098712 | |
46798 | 46798 | 1928-03-03 | 7 | a | Counterfeit bank notes in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
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 | |
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 | |
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 | |
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 | |
46797 | 46797 | 1928-03-03 | 7 | a | Number of unemployed workers in America. | America | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
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 | |
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 | |
46789 | 46789 | 1928-03-03 | 2 | d | Sun Chuanfang's spies in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098712 | 24098712 | |
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 | |
46800 | 46800 | 1928-03-03 | 7 | a | Value of gold in the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 |
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]);