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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 46797 | 46797 | 1928-03-03 | 7 | a | Number of unemployed workers in America. | America | 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 | |
| 46799 | 46799 | 1928-03-03 | 7 | a | British authority arrests illegal Chinese immigrants. | Britain | 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 | |
| 46801 | 46801 | 1928-03-03 | 7 | a | Bandits in Chicago hijack train. | 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 | |
| 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 | |
| 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 |
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]);