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